Your browser was unable to load all of the resources. They may have been blocked by your firewall, proxy or browser configuration.
Press Ctrl+F5 or Ctrl+Shift+R to have your browser try again.

Error preparing query: Table 'quickbuild9.qb_measurement_datar01' doesn't exist #4291

retzero ·

Hello.

We faced fatal issue in GRID tab.
How to fix this?
If I enter GRID -> Active Nodes below fatal screen is shown. An measurement tab shows nothing.

Error Details: 

Message: Error attaching this container for rendering: [WebMarkupContainer [Component id = body]]

Root cause:

org.mariadb.jdbc.internal.util.dao.QueryException: Error preparing query: Table 'quickbuild9.qb_measurement_datar01' doesn't exist
	 at org.mariadb.jdbc.internal.packet.ComStmtPrepare.read(ComStmtPrepare.java:106)
	 at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.prepareAndExecute(AbstractQueryProtocol.java:510)
	 at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:365)
	 at org.mariadb.jdbc.MariaDbServerPreparedStatement.execute(MariaDbServerPreparedStatement.java:323)
	 at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeQuery(MariaDbServerPreparedStatement.java:304)
	 at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:116)
	 at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82)
	 at org.hibernate.loader.Loader.getResultSet(Loader.java:2066)
	 at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1863)
	 at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839)
	 at org.hibernate.loader.Loader.doQuery(Loader.java:910)
	 at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355)
	 at org.hibernate.loader.Loader.doList(Loader.java:2554)
	 at org.hibernate.loader.Loader.doList(Loader.java:2540)
	 at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370)
	 at org.hibernate.loader.Loader.list(Loader.java:2365)
	 at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:497)
	 at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387)
	 at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:236)
	 at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1300)
	 at org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)
	 at org.hibernate.internal.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:966)
	 at com.pmease.quickbuild.entitymanager.impl.DefaultMeasurementDataManager.lastUpdatedTime(DefaultMeasurementDataManager.java:182)
	 at com.pmease.quickbuild.entitymanager.impl.DefaultMeasurementDataManager.getLastTimestamp(DefaultMeasurementDataManager.java:205)
	 at com.pmease.quickbuild.persistence.SessionInterceptor.invoke(SessionInterceptor.java:91)
	 at com.pmease.quickbuild.plugin.measurement.core.cache.UpdatedTimeCache$1.load(UpdatedTimeCache.java:23)
	 at com.pmease.quickbuild.plugin.measurement.core.cache.UpdatedTimeCache$1.load(UpdatedTimeCache.java:19)
	 at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3599)
	 at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2379)
	 at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2342)
	 at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2257)
	 at com.google.common.cache.LocalCache.get(LocalCache.java:4000)
	 at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:4004)
	 at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4874)
	 at com.google.common.cache.LocalCache$LocalLoadingCache.getUnchecked(LocalCache.java:4880)
	 at com.pmease.quickbuild.plugin.measurement.core.cache.UpdatedTimeCache.get(UpdatedTimeCache.java:33)
	 at com.pmease.quickbuild.plugin.measurement.core.cache.LatestReportCache$1.load(LatestReportCache.java:27)
	 at com.pmease.quickbuild.plugin.measurement.core.cache.LatestReportCache$1.load(LatestReportCache.java:23)
	 at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3599)
	 at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2379)
	 at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2342)
	 at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2257)
	 at com.google.common.cache.LocalCache.get(LocalCache.java:4000)
	 at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:4004)
	 at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4874)
	 at com.google.common.cache.LocalCache$LocalLoadingCache.getUnchecked(LocalCache.java:4880)
	 at com.pmease.quickbuild.plugin.measurement.core.web.node.ActiveNodesTablePanel$19.populateItem(ActiveNodesTablePanel.java:1065)
	 at org.apache.wicket.extensions.markup.html.repeater.data.grid.AbstractDataGridView.populateItem(AbstractDataGridView.java:156)
	 at org.apache.wicket.markup.repeater.RefreshingView$1.newItem(RefreshingView.java:113)
	 at org.apache.wicket.markup.repeater.DefaultItemReuseStrategy$1.next(DefaultItemReuseStrategy.java:71)
	 at org.apache.wicket.markup.repeater.DefaultItemReuseStrategy$1.next(DefaultItemReuseStrategy.java:68)
	 at org.apache.wicket.markup.repeater.RefreshingView.addItems(RefreshingView.java:188)
	 at org.apache.wicket.markup.repeater.RefreshingView.onPopulate(RefreshingView.java:97)
	 at org.apache.wicket.markup.repeater.AbstractRepeater.onBeforeRender(AbstractRepeater.java:119)
	 at org.apache.wicket.markup.repeater.AbstractPageableView.onBeforeRender(AbstractPageableView.java:115)
	 at org.apache.wicket.Component.internalBeforeRender(Component.java:986)
	 at org.apache.wicket.Component.beforeRender(Component.java:1022)
	 at org.apache.wicket.MarkupContainer.onBeforeRenderChildren(MarkupContainer.java:1785)
	 at org.apache.wicket.Component.onBeforeRender(Component.java:3798)
	 at org.apache.wicket.Component.internalBeforeRender(Component.java:986)
	 at org.apache.wicket.Component.beforeRender(Component.java:1022)
	 at org.apache.wicket.MarkupContainer.onBeforeRenderChildren(MarkupContainer.java:1785)
	 at org.apache.wicket.Component.onBeforeRender(Component.java:3798)
	 at org.apache.wicket.Component.internalBeforeRender(Component.java:986)
	 at org.apache.wicket.Component.beforeRender(Component.java:1022)
	 at org.apache.wicket.MarkupContainer.onBeforeRenderChildren(MarkupContainer.java:1785)
	 at org.apache.wicket.Component.onBeforeRender(Component.java:3798)
	 at org.apache.wicket.Component.internalBeforeRender(Component.java:986)
	 at org.apache.wicket.Component.beforeRender(Component.java:1022)
	 at org.apache.wicket.MarkupContainer.onBeforeRenderChildren(MarkupContainer.java:1785)
	 at org.apache.wicket.Component.onBeforeRender(Component.java:3798)
	 at org.apache.wicket.Component.internalBeforeRender(Component.java:986)
	 at org.apache.wicket.Component.beforeRender(Component.java:1022)
	 at org.apache.wicket.MarkupContainer.onBeforeRenderChildren(MarkupContainer.java:1785)
	 at org.apache.wicket.Component.onBeforeRender(Component.java:3798)
	 at org.apache.wicket.Component.internalBeforeRender(Component.java:986)
	 at org.apache.wicket.Component.beforeRender(Component.java:1022)
	 at org.apache.wicket.MarkupContainer.onBeforeRenderChildren(MarkupContainer.java:1785)
	 at org.apache.wicket.Component.onBeforeRender(Component.java:3798)
	 at org.apache.wicket.Component.internalBeforeRender(Component.java:986)
	 at org.apache.wicket.Component.beforeRender(Component.java:1022)
	 at org.apache.wicket.MarkupContainer.onBeforeRenderChildren(MarkupContainer.java:1785)
	 at org.apache.wicket.Component.onBeforeRender(Component.java:3798)
	 at org.apache.wicket.Component.internalBeforeRender(Component.java:986)
	 at org.apache.wicket.Component.beforeRender(Component.java:1022)
	 at org.apache.wicket.MarkupContainer.onBeforeRenderChildren(MarkupContainer.java:1785)
	 at org.apache.wicket.Component.onBeforeRender(Component.java:3798)
	 at org.apache.wicket.Page.onBeforeRender(Page.java:823)
	 at com.pmease.quickbuild.web.page.BasePage.onBeforeRender(BasePage.java:362)
	 at org.apache.wicket.Component.internalBeforeRender(Component.java:986)
	 at org.apache.wicket.Component.beforeRender(Component.java:1022)
	 at org.apache.wicket.Component.internalPrepareForRender(Component.java:2191)
	 at org.apache.wicket.Page.internalPrepareForRender(Page.java:280)
	 at org.apache.wicket.Component.render(Component.java:2280)
	 at org.apache.wicket.Page.renderPage(Page.java:1035)
	 at org.apache.wicket.request.handler.render.WebPageRenderer.renderPage(WebPageRenderer.java:105)
	 at org.apache.wicket.request.handler.render.WebPageRenderer.respond(WebPageRenderer.java:182)
	 at org.apache.wicket.request.handler.RenderPageRequestHandler.respond(RenderPageRequestHandler.java:147)
	 at org.apache.wicket.request.cycle.RequestCycle$HandlerExecutor.respond(RequestCycle.java:719)
	 at org.apache.wicket.request.RequestHandlerStack.execute(RequestHandlerStack.java:63)
	 at org.apache.wicket.request.cycle.RequestCycle.processRequest(RequestCycle.java:210)
	 at org.apache.wicket.request.cycle.RequestCycle.processRequestAndDetach(RequestCycle.java:253)
	 at org.apache.wicket.protocol.http.WicketFilter.processRequest(WicketFilter.java:162)
	 at org.apache.wicket.protocol.http.WicketServlet.doGet(WicketServlet.java:137)
	 at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
	 at com.pmease.quickbuild.web.MainServlet.service(MainServlet.java:135)
	 at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
	 at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:867)
	 at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1623)
	 at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:198)
	 at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:176)
	 at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1610)
	 at com.pmease.quickbuild.Quickbuild$DisableTraceFilter.doFilter(Quickbuild.java:1188)
	 at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1610)
	 at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:540)
	 at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:146)
	 at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:753)
	 at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
	 at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:257)
	 at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1588)
	 at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
	 at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1345)
	 at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)
	 at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:480)
	 at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1557)
	 at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)
	 at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1247)
	 at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)
	 at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:126)
	 at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
	 at org.eclipse.jetty.server.Server.handle(Server.java:502)
	 at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:364)
	 at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)
	 at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:305)
	 at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)
	 at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)
	 at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)
	 at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)
	 at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)
	 at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)
	 at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)
	 at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:765)
	 at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:683)
	 at java.lang.Thread.run(Thread.java:745)
  • solved #4
  • replies 6
  • views 94
  • stars 0
robinshen ADMIN ·

What database are you using? MariaDB or MySQL

retzero ·

Sorry for late reply.
We're using MySQL.

robinshen ADMIN ·

Please remove the MariaDB driver from " /plugins/com.pmease.quickbuild.libs" and copy over official MySQL jdbc driver if not already exist. Then restart QB server to see if the issue still exist.

retzero ·

We have below list.
Should I remove mariadb-java-client-1.5.2.jar?
Is mysql-connector-java-5.1.38-bin.jar the one "official MySQL jdbc driver"?

$ ls -al plugins/com.pmease.quickbuild.libs/

mariadb-java-client-1.5.2.jar
META-INF
mysql-connector-java-5.1.38-bin.jar
p4java-2015.2.1312871.jar
postgresql-42.2.5.jre7.jar
READ-THIS-BEFORE-UPDATE-LIBS.txt
snakeyaml-1.9.jar
sqljdbc4.jar
sqljdbc_auth.dll

``
robinshen ADMIN ·

Yes, please remove "mariadb-java-client-1.5.2.jar", and keep "mysql-connector-java-5.1.38-bin.jar" which is the official one.

retzero ·

thanks. I'll try.