| << Back to previous view |
|
[QB-3377] After upgrading do QB9.0.7 server can't start
|
|
| Status: | Closed |
| Project: | QuickBuild |
| Component/s: | None |
| Affects Version/s: | 9.0.7 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Critical |
| Reporter: | Jedrzej Buraczewski | Assigned To: | Robin Shen |
| Resolution: | Fixed | Votes: | 0 |
| Remaining Estimate: | Unknown | Time Spent: | Unknown |
| Original Estimate: | Unknown | ||
| Environment: | Ubuntu 18.04.2, OpenJDK openjdk-11-jre 11.0.2+9-3ubuntu1~18.04.3 | ||
| Description |
|
After upgrading packages in the OS to latest ones and QB to 9.0.7 the server is not able to start correctly.
Error shown in log file: jvm 1 | WrapperStartStopApp Error: Encountered an error running start main: java.lang.reflect.InvocationTargetException jvm 1 | WrapperStartStopApp Error: java.lang.reflect.InvocationTargetException jvm 1 | WrapperStartStopApp Error: at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) jvm 1 | WrapperStartStopApp Error: at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) jvm 1 | WrapperStartStopApp Error: at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) jvm 1 | WrapperStartStopApp Error: at java.base/java.lang.reflect.Method.invoke(Method.java:566) jvm 1 | WrapperStartStopApp Error: at com.pmease.quickbuild.bootstrap.Bootstrap.boot(Bootstrap.java:614) jvm 1 | WrapperStartStopApp Error: at com.pmease.quickbuild.bootstrap.Bootstrap.main(Bootstrap.java:128) jvm 1 | WrapperStartStopApp Error: at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) jvm 1 | WrapperStartStopApp Error: at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) jvm 1 | WrapperStartStopApp Error: at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) jvm 1 | WrapperStartStopApp Error: at java.base/java.lang.reflect.Method.invoke(Method.java:566) jvm 1 | WrapperStartStopApp Error: at org.tanukisoftware.wrapper.WrapperStartStopApp.run(WrapperStartStopApp.java:429) jvm 1 | WrapperStartStopApp Error: at java.base/java.lang.Thread.run(Thread.java:834) jvm 1 | WrapperStartStopApp Error: Caused by: java.lang.RuntimeException: java.lang.reflect.InvocationTargetException jvm 1 | WrapperStartStopApp Error: at com.pmease.quickbuild.bootstrap.BootstrapUtils.wrapAsUnchecked(BootstrapUtils.java:56) jvm 1 | WrapperStartStopApp Error: at com.pmease.quickbuild.equinoxadapter.EquinoxAdapter.startup(EquinoxAdapter.java:61) jvm 1 | WrapperStartStopApp Error: ... 12 more jvm 1 | WrapperStartStopApp Error: Caused by: java.lang.reflect.InvocationTargetException jvm 1 | WrapperStartStopApp Error: at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) jvm 1 | WrapperStartStopApp Error: at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) jvm 1 | WrapperStartStopApp Error: at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) jvm 1 | WrapperStartStopApp Error: at java.base/java.lang.reflect.Method.invoke(Method.java:566) jvm 1 | WrapperStartStopApp Error: at com.pmease.quickbuild.equinoxadapter.EquinoxAdapter.startup(EquinoxAdapter.java:59) jvm 1 | WrapperStartStopApp Error: ... 12 more jvm 1 | WrapperStartStopApp Error: Caused by: java.lang.ClassCastException: class [B cannot be cast to class [C ([B and [C are in module java.base of loader 'bootstrap') jvm 1 | WrapperStartStopApp Error: at org.mariadb.jdbc.internal.stream.PacketOutputStream.send(PacketOutputStream.java:848) jvm 1 | WrapperStartStopApp Error: at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:131) jvm 1 | WrapperStartStopApp Error: at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.loadServerData(AbstractConnectProtocol.java:614) jvm 1 | WrapperStartStopApp Error: at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connect(AbstractConnectProtocol.java:379) jvm 1 | WrapperStartStopApp Error: at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:755) jvm 1 | WrapperStartStopApp Error: at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:468) jvm 1 | WrapperStartStopApp Error: at org.mariadb.jdbc.Driver.connect(Driver.java:104) jvm 1 | WrapperStartStopApp Error: at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677) jvm 1 | WrapperStartStopApp Error: at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228) jvm 1 | WrapperStartStopApp Error: at com.pmease.quickbuild.util.DbUtils.getConnection(DbUtils.java:101) jvm 1 | WrapperStartStopApp Error: at com.pmease.quickbuild.util.DbUtils.getDataVersion(DbUtils.java:135) jvm 1 | WrapperStartStopApp Error: at com.pmease.quickbuild.Quickbuild.startServer(Quickbuild.java:799) jvm 1 | WrapperStartStopApp Error: at com.pmease.quickbuild.Quickbuild.start(Quickbuild.java:288) jvm 1 | WrapperStartStopApp Error: ... 17 more jvm 1 | 2019-04-18 14:01:24,869 INFO - Stopping QuickBuild server... jvm 1 | 2019-04-18 14:01:24,888 INFO - Stopping plugins... jvm 1 | 2019-04-18 14:01:24,895 INFO - Stopping task scheduler... jvm 1 | 2019-04-18 14:01:25,927 INFO - QuickBuild server stopped. |
| Comments |
| Comment by Robin Shen [ 18/Apr/19 11:40 PM ] |
| Which database are you using? If you are using MySQL, please remove the MariaDB driver from "plugins\com.pmease.quickbuild.libs" and start server again to see if it works. |
| Comment by Jedrzej Buraczewski [ 19/Apr/19 07:12 AM ] |
|
After removing file the error changed to the following:
jvm 1 | Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. jvm 1 | WrapperStartStopApp: jvm 1 | WrapperStartStopApp Error: Encountered an error running start main: java.lang.reflect.InvocationTargetException jvm 1 | WrapperStartStopApp Error: java.lang.reflect.InvocationTargetException jvm 1 | WrapperStartStopApp Error: at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) jvm 1 | WrapperStartStopApp Error: at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) jvm 1 | WrapperStartStopApp Error: at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) jvm 1 | WrapperStartStopApp Error: at java.base/java.lang.reflect.Method.invoke(Method.java:566) jvm 1 | WrapperStartStopApp Error: at com.pmease.quickbuild.bootstrap.Bootstrap.boot(Bootstrap.java:614) jvm 1 | WrapperStartStopApp Error: at com.pmease.quickbuild.bootstrap.Bootstrap.main(Bootstrap.java:128) jvm 1 | WrapperStartStopApp Error: at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) jvm 1 | WrapperStartStopApp Error: at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) jvm 1 | WrapperStartStopApp Error: at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) jvm 1 | WrapperStartStopApp Error: at java.base/java.lang.reflect.Method.invoke(Method.java:566) jvm 1 | WrapperStartStopApp Error: at org.tanukisoftware.wrapper.WrapperStartStopApp.run(WrapperStartStopApp.java:429) jvm 1 | WrapperStartStopApp Error: at java.base/java.lang.Thread.run(Thread.java:834) jvm 1 | WrapperStartStopApp Error: Caused by: java.lang.RuntimeException: java.lang.reflect.InvocationTargetException jvm 1 | WrapperStartStopApp Error: at com.pmease.quickbuild.bootstrap.BootstrapUtils.wrapAsUnchecked(BootstrapUtils.java:56) jvm 1 | WrapperStartStopApp Error: at com.pmease.quickbuild.equinoxadapter.EquinoxAdapter.startup(EquinoxAdapter.java:61) jvm 1 | WrapperStartStopApp Error: ... 12 more jvm 1 | WrapperStartStopApp Error: Caused by: java.lang.reflect.InvocationTargetException jvm 1 | WrapperStartStopApp Error: at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) jvm 1 | WrapperStartStopApp Error: at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) jvm 1 | WrapperStartStopApp Error: at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) jvm 1 | WrapperStartStopApp Error: at java.base/java.lang.reflect.Method.invoke(Method.java:566) jvm 1 | WrapperStartStopApp Error: at com.pmease.quickbuild.equinoxadapter.EquinoxAdapter.startup(EquinoxAdapter.java:59) jvm 1 | WrapperStartStopApp Error: ... 12 more jvm 1 | WrapperStartStopApp Error: Caused by: java.lang.RuntimeException: java.sql.SQLException: The server time zone value 'CEST' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support. jvm 1 | WrapperStartStopApp Error: at com.pmease.quickbuild.bootstrap.BootstrapUtils.wrapAsUnchecked(BootstrapUtils.java:56) jvm 1 | WrapperStartStopApp Error: at com.pmease.quickbuild.util.ExceptionUtils.wrapAsUnchecked(ExceptionUtils.java:82) jvm 1 | WrapperStartStopApp Error: at com.pmease.quickbuild.util.DbUtils.getConnection(DbUtils.java:107) jvm 1 | WrapperStartStopApp Error: at com.pmease.quickbuild.util.DbUtils.getDataVersion(DbUtils.java:135) jvm 1 | WrapperStartStopApp Error: at com.pmease.quickbuild.Quickbuild.startServer(Quickbuild.java:799) jvm 1 | WrapperStartStopApp Error: at com.pmease.quickbuild.Quickbuild.start(Quickbuild.java:288) jvm 1 | WrapperStartStopApp Error: ... 17 more jvm 1 | WrapperStartStopApp Error: Caused by: java.sql.SQLException: The server time zone value 'CEST' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support. jvm 1 | WrapperStartStopApp Error: at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) jvm 1 | WrapperStartStopApp Error: at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) jvm 1 | WrapperStartStopApp Error: at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) jvm 1 | WrapperStartStopApp Error: at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) jvm 1 | WrapperStartStopApp Error: at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) jvm 1 | WrapperStartStopApp Error: at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:76) jvm 1 | WrapperStartStopApp Error: at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:835) jvm 1 | WrapperStartStopApp Error: at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455) jvm 1 | WrapperStartStopApp Error: at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240) jvm 1 | WrapperStartStopApp Error: at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199) jvm 1 | WrapperStartStopApp Error: at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677) jvm 1 | WrapperStartStopApp Error: at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228) jvm 1 | WrapperStartStopApp Error: at com.pmease.quickbuild.util.DbUtils.getConnection(DbUtils.java:101) jvm 1 | WrapperStartStopApp Error: ... 20 more jvm 1 | WrapperStartStopApp Error: Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value 'CEST' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support. jvm 1 | WrapperStartStopApp Error: at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) jvm 1 | WrapperStartStopApp Error: at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) jvm 1 | WrapperStartStopApp Error: at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) jvm 1 | WrapperStartStopApp Error: at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490) jvm 1 | WrapperStartStopApp Error: at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) jvm 1 | WrapperStartStopApp Error: at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85) jvm 1 | WrapperStartStopApp Error: at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:132) jvm 1 | WrapperStartStopApp Error: at com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2241) jvm 1 | WrapperStartStopApp Error: at com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2265) jvm 1 | WrapperStartStopApp Error: at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1319) jvm 1 | WrapperStartStopApp Error: at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:966) jvm 1 | WrapperStartStopApp Error: at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:825) jvm 1 | WrapperStartStopApp Error: ... 26 more |
| Comment by Robin Shen [ 19/Apr/19 10:56 PM ] |
|
Please modify mysql section of hibernate.properties like below:
hibernate.connection.driver_class=com.mysql.cj.jdbc.Driver hibernate.connection.url=jdbc:mysql://<your mysql host>:3306/<quickbuild database name>?serverTimezone=UTC&allowPublicKeyRetrieval=true&useSSL=false&disableMariaDbDriver=true |
| Comment by Jedrzej Buraczewski [ 23/Apr/19 09:44 AM ] |
|
Thank you.
Removing mariadb driver and running with hibernate.connection.url=jdbc:mysql://<your mysql host>:3306/<quickbuild database name>?serverTimezone=UTC resolved the problem. |