-
Type:
Bug
-
Status: Closed
-
Resolution: No Longer Reproducible
-
Affects Version/s: 7.0.3 CE GA4
-
Component/s: Environments, Environments > Databases
-
Labels:None
In an empty database, MySQL 5.7, when the servers is brought up the follow exception is raised. (seem on both drivers com.mysql.jdbc.Driver and com.mysql.cj.jdbc.Driver)
liferay | 21:45:35,927 ERROR [localhost-startStop-1][MainServlet:275] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: java.sql.SQLSyntaxErrorException: Table 'XXXXX.EVENTS' doesn't exist
liferay | com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: java.sql.SQLSyntaxErrorException: Table 'XXXXX.EVENTS' doesn't exist
liferay | at com.liferay.portal.events.StartupAction.run(StartupAction.java:91)
liferay | at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1329)
liferay | at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:272)
liferay | at javax.servlet.GenericServlet.init(GenericServlet.java:158)
liferay | at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1183)
liferay | at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1099)
liferay | at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:989)
liferay | at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4931)
liferay | at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5241)
liferay | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
liferay | at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752)
liferay | at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728)
liferay | at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
liferay | at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:596)
liferay | at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1805)
liferay | at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
liferay | at java.util.concurrent.FutureTask.run(FutureTask.java:266)
liferay | at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
liferay | at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
liferay | at java.lang.Thread.run(Thread.java:748)
liferay | Caused by: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: java.sql.SQLSyntaxErrorException: Table 'XXXXX.EVENTS' doesn't exist
liferay | at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:73)
liferay | at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:113)
liferay | at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:78)
liferay | at com.liferay.portal.verify.VerifyProcessUtil.verifyProcess(VerifyProcessUtil.java:47)
liferay | at com.liferay.portal.events.StartupHelper.verifyProcess(StartupHelper.java:175)
liferay | at com.liferay.portal.events.StartupHelperUtil.verifyProcess(StartupHelperUtil.java:87)
liferay | at com.liferay.portal.tools.DBUpgrader.verify(DBUpgrader.java:247)
liferay | at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:243)
liferay | at com.liferay.portal.events.StartupAction.run(StartupAction.java:85)
liferay | ... 19 more
liferay | Caused by: com.liferay.portal.verify.VerifyException: java.sql.SQLSyntaxErrorException: Table 'XXXXX.EVENTS' doesn't exist
liferay | at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:73)
liferay | at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:88)
liferay | at com.liferay.portal.verify.VerifyProcessSuite.doVerify(VerifyProcessSuite.java:27)
liferay | at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:70)
liferay | ... 27 more
liferay | Caused by: java.sql.SQLSyntaxErrorException: Table 'XXXXX.EVENTS' doesn't exist
liferay | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:536)
liferay | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:513)
liferay | at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:115)
liferay | at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1983)
liferay | at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1936)
liferay | at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1422)
liferay | at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
liferay | at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
liferay | at com.liferay.portal.verify.VerifyMySQL.getActualColumnType(VerifyMySQL.java:64)
liferay | at com.liferay.portal.verify.VerifyMySQL.verifyDatetimePrecisionForTable(VerifyMySQL.java:105)
liferay | at com.liferay.portal.verify.VerifyMySQL.verifyDatetimePrecision(VerifyMySQL.java:83)
liferay | at com.liferay.portal.verify.VerifyMySQL.doVerify(VerifyMySQL.java:49)
liferay | at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:70)
liferay | ... 30 more
liferay | Stopping the server due to unexpected startup errors