|
|
|
[
Permlink
| « Hide
]
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.
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 Probably you forget to comment out the MariaDB section under the MySQL section?
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 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 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 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) |