|
|
|
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 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 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 Probably you forget to comment out the MariaDB section under the MySQL section?
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 Please delete the MariaDB client jar from the com.pmease.quickbuild.libs directory and restart QB to see what happens.
|
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)