<< Back to previous view |
[QB-3174] Exception: Can't create more than max_prepared_stmt_count statements
|
|
Status: | Closed |
Project: | QuickBuild |
Component/s: | None |
Affects Version/s: | 7.0.28 |
Fix Version/s: | None |
Type: | Bug | Priority: | Blocker |
Reporter: | Piotr Jedrys | Assigned To: | Robin Shen |
Resolution: | Cannot Reproduce | Votes: | 1 |
Remaining Estimate: | Unknown | Time Spent: | Unknown |
Original Estimate: | Unknown | ||
Environment: | Linux |
Description |
Whenever we try to go into configuration details, we get
Error Details: Message: could not extract ResultSet Root cause: org.mariadb.jdbc.internal.util.dao.QueryException: Error preparing query: Can't create more than max_prepared_stmt_count statements (current value: 16382) 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.plan.exec.internal.AbstractLoadPlanBasedLoader.getResultSet(AbstractLoadPlanBasedLoader.java:449) at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeQueryStatement(AbstractLoadPlanBasedLoader.java:202) at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:137) at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:102) at org.hibernate.loader.entity.plan.AbstractLoadPlanBasedEntityLoader.load(AbstractLoadPlanBasedEntityLoader.java:186) at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:4126) at org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:503) at org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:468) at org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:213) at org.hibernate.event.internal.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:275) at org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:151) at org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1106) at org.hibernate.internal.SessionImpl.internalLoad(SessionImpl.java:1025) at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:716) at org.hibernate.type.ManyToOneType.assemble(ManyToOneType.java:282) at org.hibernate.type.TypeHelper.assemble(TypeHelper.java:113) at org.hibernate.cache.spi.entry.StandardCacheEntryImpl.assemble(StandardCacheEntryImpl.java:163) at org.hibernate.event.internal.DefaultLoadEventListener.convertCacheEntryToEntity(DefaultLoadEventListener.java:707) at org.hibernate.event.internal.DefaultLoadEventListener.loadFromSecondLevelCache(DefaultLoadEventListener.java:618) at org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:452) at org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:213) at org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:146) at org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1106) at org.hibernate.internal.SessionImpl.immediateLoad(SessionImpl.java:1012) at org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:174) at org.hibernate.proxy.AbstractLazyInitializer.getImplementation(AbstractLazyInitializer.java:286) at org.hibernate.proxy.pojo.javassist.JavassistLazyInitializer.invoke(JavassistLazyInitializer.java:185) at com.pmease.quickbuild.model.Configuration_$$_jvst518_e.getInheritDistance(Configuration_$$_jvst518_e.java) at com.pmease.quickbuild.security.SecurityHelper.hasPermission(SecurityHelper.java:340) at com.pmease.quickbuild.security.SecurityHelper.hasPermission(SecurityHelper.java:376) at com.pmease.quickbuild.security.SecurityHelper.hasPermission(SecurityHelper.java:382) at com.pmease.quickbuild.web.page.configuration.ConfigurationPage.isAuthorized(ConfigurationPage.java:85) at com.pmease.quickbuild.web.page.BasePage.onInitialize(BasePage.java:127) at com.pmease.quickbuild.web.page.MainPage.onInitialize(MainPage.java:76) at com.pmease.quickbuild.web.page.configuration.ConfigurationPage.onInitialize(ConfigurationPage.java:103) at com.pmease.quickbuild.web.page.configuration.ConfigurationOverview.onInitialize(ConfigurationOverview.java:106) at org.apache.wicket.Component.fireInitialize(Component.java:924) at org.apache.wicket.MarkupContainer.internalInitialize(MarkupContainer.java:1002) at org.apache.wicket.Page.internalPrepareForRender(Page.java:278) 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.equinox.http.helper.FilterServletAdaptor$FilterChainImpl.doFilter(FilterServletAdaptor.java:56) at org.eclipse.jetty.servlets.UserAgentFilter.doFilter(UserAgentFilter.java:83) at org.eclipse.jetty.servlets.GzipFilter.doFilter(GzipFilter.java:365) at org.eclipse.equinox.http.helper.FilterServletAdaptor.service(FilterServletAdaptor.java:37) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:812) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669) at com.pmease.quickbuild.Quickbuild$DisableTraceFilter.doFilter(Quickbuild.java:1076) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:221) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:110) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97) at org.eclipse.jetty.server.Server.handle(Server.java:499) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:311) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:258) at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:544) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555) at java.lang.Thread.run(Thread.java:748) Complete stack: org.hibernate.exception.SQLGrammarException: could not extract ResultSet at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:80) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91) at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.getResultSet(AbstractLoadPlanBasedLoader.java:449) at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeQueryStatement(AbstractLoadPlanBasedLoader.java:202) at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:137) at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:102) at org.hibernate.loader.entity.plan.AbstractLoadPlanBasedEntityLoader.load(AbstractLoadPlanBasedEntityLoader.java:186) at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:4126) at org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:503) at org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:468) at org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:213) at org.hibernate.event.internal.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:275) at org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:151) at org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1106) at org.hibernate.internal.SessionImpl.internalLoad(SessionImpl.java:1025) at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:716) at org.hibernate.type.ManyToOneType.assemble(ManyToOneType.java:282) at org.hibernate.type.TypeHelper.assemble(TypeHelper.java:113) at org.hibernate.cache.spi.entry.StandardCacheEntryImpl.assemble(StandardCacheEntryImpl.java:163) at org.hibernate.event.internal.DefaultLoadEventListener.convertCacheEntryToEntity(DefaultLoadEventListener.java:707) at org.hibernate.event.internal.DefaultLoadEventListener.loadFromSecondLevelCache(DefaultLoadEventListener.java:618) at org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:452) at org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:213) at org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:146) at org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1106) at org.hibernate.internal.SessionImpl.immediateLoad(SessionImpl.java:1012) at org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:174) at org.hibernate.proxy.AbstractLazyInitializer.getImplementation(AbstractLazyInitializer.java:286) at org.hibernate.proxy.pojo.javassist.JavassistLazyInitializer.invoke(JavassistLazyInitializer.java:185) at com.pmease.quickbuild.model.Configuration_$$_jvst518_e.getInheritDistance(Configuration_$$_jvst518_e.java) at com.pmease.quickbuild.security.SecurityHelper.hasPermission(SecurityHelper.java:340) at com.pmease.quickbuild.security.SecurityHelper.hasPermission(SecurityHelper.java:376) at com.pmease.quickbuild.security.SecurityHelper.hasPermission(SecurityHelper.java:382) at com.pmease.quickbuild.web.page.configuration.ConfigurationPage.isAuthorized(ConfigurationPage.java:85) at com.pmease.quickbuild.web.page.BasePage.onInitialize(BasePage.java:127) at com.pmease.quickbuild.web.page.MainPage.onInitialize(MainPage.java:76) at com.pmease.quickbuild.web.page.configuration.ConfigurationPage.onInitialize(ConfigurationPage.java:103) at com.pmease.quickbuild.web.page.configuration.ConfigurationOverview.onInitialize(ConfigurationOverview.java:106) at org.apache.wicket.Component.fireInitialize(Component.java:924) at org.apache.wicket.MarkupContainer.internalInitialize(MarkupContainer.java:1002) at org.apache.wicket.Page.internalPrepareForRender(Page.java:278) 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) java.sql.SQLSyntaxErrorException: Error preparing query: Can't create more than max_prepared_stmt_count statements (current value: 16382) at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:125) at org.mariadb.jdbc.internal.util.ExceptionMapper.throwException(ExceptionMapper.java:69) at org.mariadb.jdbc.MariaDbStatement.executeQueryEpilog(MariaDbStatement.java:226) at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:376) 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.plan.exec.internal.AbstractLoadPlanBasedLoader.getResultSet(AbstractLoadPlanBasedLoader.java:449) at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeQueryStatement(AbstractLoadPlanBasedLoader.java:202) at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:137) at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:102) at org.hibernate.loader.entity.plan.AbstractLoadPlanBasedEntityLoader.load(AbstractLoadPlanBasedEntityLoader.java:186) at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:4126) at org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:503) at org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:468) at org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:213) at org.hibernate.event.internal.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:275) at org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:151) at org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1106) at org.hibernate.internal.SessionImpl.internalLoad(SessionImpl.java:1025) at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:716) at org.hibernate.type.ManyToOneType.assemble(ManyToOneType.java:282) at org.hibernate.type.TypeHelper.assemble(TypeHelper.java:113) at org.hibernate.cache.spi.entry.StandardCacheEntryImpl.assemble(StandardCacheEntryImpl.java:163) at org.hibernate.event.internal.DefaultLoadEventListener.convertCacheEntryToEntity(DefaultLoadEventListener.java:707) at org.hibernate.event.internal.DefaultLoadEventListener.loadFromSecondLevelCache(DefaultLoadEventListener.java:618) at org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:452) at org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:213) at org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:146) at org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1106) at org.hibernate.internal.SessionImpl.immediateLoad(SessionImpl.java:1012) at org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:174) at org.hibernate.proxy.AbstractLazyInitializer.getImplementation(AbstractLazyInitializer.java:286) at org.hibernate.proxy.pojo.javassist.JavassistLazyInitializer.invoke(JavassistLazyInitializer.java:185) at com.pmease.quickbuild.model.Configuration_$$_jvst518_e.getInheritDistance(Configuration_$$_jvst518_e.java) at com.pmease.quickbuild.security.SecurityHelper.hasPermission(SecurityHelper.java:340) at com.pmease.quickbuild.security.SecurityHelper.hasPermission(SecurityHelper.java:376) at com.pmease.quickbuild.security.SecurityHelper.hasPermission(SecurityHelper.java:382) at com.pmease.quickbuild.web.page.configuration.ConfigurationPage.isAuthorized(ConfigurationPage.java:85) at com.pmease.quickbuild.web.page.BasePage.onInitialize(BasePage.java:127) at com.pmease.quickbuild.web.page.MainPage.onInitialize(MainPage.java:76) at com.pmease.quickbuild.web.page.configuration.ConfigurationPage.onInitialize(ConfigurationPage.java:103) at com.pmease.quickbuild.web.page.configuration.ConfigurationOverview.onInitialize(ConfigurationOverview.java:106) at org.apache.wicket.Component.fireInitialize(Component.java:924) at org.apache.wicket.MarkupContainer.internalInitialize(MarkupContainer.java:1002) at org.apache.wicket.Page.internalPrepareForRender(Page.java:278) 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) |
Comments |
Comment by Piotr Jedrys [ 19/Apr/18 08:26 AM ] |
Seems like the QB is leaking closing the statements .
After 0,5h it grew from: mysql> show global status like 'com_stmt%'; +-------------------------+----------+ | Variable_name | Value | +-------------------------+----------+ | Com_stmt_execute | 31578163 | | Com_stmt_close | 4936646 | | Com_stmt_fetch | 0 | | Com_stmt_prepare | 4957234 | | Com_stmt_reset | 0 | | Com_stmt_send_long_data | 809434 | | Com_stmt_reprepare | 4206 | +-------------------------+----------+ 7 rows in set (0.00 sec) to mysql> show global status like 'com_stmt%'; +-------------------------+----------+ | Variable_name | Value | +-------------------------+----------+ | Com_stmt_execute | 31610053 | | Com_stmt_close | 4941519 | | Com_stmt_fetch | 0 | | Com_stmt_prepare | 4962121 | | Com_stmt_reset | 0 | | Com_stmt_send_long_data | 811294 | | Com_stmt_reprepare | 4213 | +-------------------------+----------+ 7 rows in set (0.01 sec) |
Comment by Robin Shen [ 19/Apr/18 10:49 PM ] |
Can you please use MySQL jdbc driver instead of MaridDB driver to see if it still exhibits the problem? To do it, download MySQL jdbc driver jar into "<QB server>/plugins/com.pmease.quickbuild.libs", and edit "conf/hibernate.properties" to use below properties:
hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect hibernate.connection.driver_class=com.mysql.jdbc.Driver hibernate.connection.url=jdbc:mysql://localhost:3306/quickbuild # change it to your db server url hibernate.connection.username=root # change it to your db user hibernate.connection.password=root # change it to your db password |
Comment by Piotr Jedrys [ 23/Apr/18 11:50 AM ] |
This is strange, cause we do have it set up but using MySQLDialect:
hibernate.dialect=org.hibernate.dialect.MySQLDialect hibernate.connection.driver_class=com.mysql.jdbc.Driver hibernate.connection.url=jdbc:mysql://quickbuild_mysql_database:3306/quickbuild |
Comment by Piotr Jedrys [ 23/Apr/18 11:56 AM ] |
and we have jar file in the plugins:
ls /opt/quickbuild/quickbuild-7.0.28/plugins/co mariadb-java-client-1.5.2.jar META-INF mysql-connector-java-5.1.28.jar postgresql-9.3-1101.jdbc4.jar READ-THIS-BEFORE-UPDATE-LIBS.txt sqljdbc_auth.dll sqljdbc4.jar |
Comment by Robin Shen [ 23/Apr/18 11:38 PM ] |
Probably you forget to comment out the MariaDB section under the MySQL section? |
Comment by Piotr Jedrys [ 24/Apr/18 06:52 AM ] |
Unfortunately not;/
We have a dockerized QuickBuild server set up, and I have double checked - there is no configuration file with "MariaDB" set and these are all our hibernate config properties found under active/conf directory root@navkit-quickbuild-master:~/active/conf# grep -R "hibernate" hibernate.properties:hibernate.dialect=org.hibernate.dialect.MySQLDialect hibernate.properties:hibernate.connection.driver_class=com.mysql.jdbc.Driver hibernate.properties:hibernate.connection.url=jdbc:mysql://quickbuild_mysql_database:3306/quickbuild hibernate.properties:hibernate.connection.username=**** hibernate.properties:hibernate.connection.password=**** hibernate.properties:hibernate.connection.autocommit=true hibernate.properties:hibernate.c3p0.min_size=5 hibernate.properties:hibernate.c3p0.max_size=125 hibernate.properties:hibernate.c3p0.max_statements=0 hibernate.properties:hibernate.c3p0.idle_test_period=600 hibernate.properties:hibernate.show_sql=false hibernate.properties:hibernate.format_sql=true hibernate.properties:hibernate.use_sql_comments=true hibernate.properties:hibernate.validator.apply_to_ddl=false hibernate.properties:hibernate.cache.provider_class=org.hibernate.cache.EhCacheProvider hibernate.properties:hibernate.cache.use_query_cache=true log4j.properties:log4j.logger.org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory=ERROR log4j.properties:log4j.logger.org.hibernate.cache.ReadWriteCache=ERROR log4j.properties:log4j.logger.org.hibernate.tool.hbm2ddl.SchemaUpdate=WARN |
Comment by Robin Shen [ 24/Apr/18 09:43 PM ] |
Please delete the MariaDB client jar from the com.pmease.quickbuild.libs directory and restart QB to see what happens. |