Details

    • Fix Priority:
      5

      Description

      Steps to reproduce:

      1. Update to latest 7.0.x-private.
      2. Compile and start the bundle.

      Expected result:
      Portal could start up successfully.

      Actual result:
      MySQLSyntaxErrorException is thrown in console.

      03:55:53,014 ERROR [localhost-startStop-1][DBUpgrader:253] Unable to execute verify process: com.liferay.portal.verify.VerifyException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Can't DROP 'TEMP_INDEX'; check that column/key exists
      com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Can't DROP 'TEMP_INDEX'; check that column/key exists
      	at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:73)
      	at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:113)
      	at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:78)
      	at com.liferay.portal.verify.VerifyProcessUtil.verifyProcess(VerifyProcessUtil.java:47)
      	at com.liferay.portal.events.StartupHelper.verifyProcess(StartupHelper.java:175)
      	at com.liferay.portal.events.StartupHelperUtil.verifyProcess(StartupHelperUtil.java:87)
      	at com.liferay.portal.tools.DBUpgrader.verify(DBUpgrader.java:247)
      	at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:243)
      	at com.liferay.portal.events.StartupAction.run(StartupAction.java:85)
      	at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1341)
      	at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:272)
      	at javax.servlet.GenericServlet.init(GenericServlet.java:158)
      	at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1238)
      	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1151)
      	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1038)
      	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4997)
      	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5289)
      	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
      	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
      	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
      	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
      	at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:585)
      	at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1794)
      	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
      	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
      	at java.lang.Thread.run(Thread.java:745)
      Caused by: com.liferay.portal.verify.VerifyException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Can't DROP 'TEMP_INDEX'; check that column/key exists
      	at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:73)
      	at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:88)
      	at com.liferay.portal.verify.VerifyProcessSuite.doVerify(VerifyProcessSuite.java:32)
      	at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:70)
      	... 27 more
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                beck.liu Beck Liu
                Reporter:
                beck.liu Beck Liu
                Participants of an Issue:
                Recent user:
                Hong Zhao
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  1 year, 47 weeks ago

                  Packages

                  Version Package
                  7.0.X EE