Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-73410

Installing GA4 on an empty MySQL 5.7 results in a fatal exception

    Details

      Description

      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

        Attachments

          Activity

            People

            Assignee:
            lu.liu Lu Liu
            Reporter:
            victorlima02 Victor de Lima Soares
            Participants of an Issue:
            Recent user:
            Victor de Lima Soares
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since last comment:
              3 years, 24 weeks, 4 days ago

                Packages

                Version Package
                6.2.X EE
                7.0.X EE
                Master