PUBLIC - Liferay Portal Community Edition
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-22001

Upgrade from 6.0.12 to 6.1 results in index errors due to missing tables

    Details

    • Similar Issues:
      Show 4 results 

      Description

      Reproduce as following steps:
      1. Start 6.0.12 EE server with MySql;
      2. Sign in with test@liferay.com;
      3. Shut down the server;
      4. Upgrade to 6.1.x.

        Issue Links

          Activity

          Hide
          Ginson Ren added a comment - - edited

          FAILED Manual Testing using the following steps:
          1. Start 6.0.12 EE server with MySql;
          2. Sign in with test@liferay.com;
          3. Shut down the server;
          4. Upgrade to 6.1.x.

          Reproduced on:
          Tomcat 7.0.21 + MySQL 5. 6.1.x Revision 90355.

          Failed on:
          Tomcat 7.0.21 + MySQL 5. 6.1.x Revision 90598.

          The upgrade was failed and the console displayed error messages as follow:

          02:19:54,626 ERROR [MainServlet:203] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'PollsVote.userName' in 'where clause'
          com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'PollsVote.userName' in 'where clause'
                  at com.liferay.portal.events.StartupAction.run(StartupAction.java:57)
                  at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1279)
                  at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:200)
                  at javax.servlet.GenericServlet.init(GenericServlet.java:160)
                  at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1228)
                  at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1147)
                  at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1043)
                  at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4957)
                  at org.apache.catalina.core.StandardContext$3.call(StandardContext.java:5284)
                  at org.apache.catalina.core.StandardContext$3.call(StandardContext.java:5279)
                  at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
                  at java.util.concurrent.FutureTask.run(Unknown Source)
                  at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
                  at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
                  at java.lang.Thread.run(Unknown Source)
          Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'PollsVote.userName' in 'where clause'
                  at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:211)
                  at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:93)
                  at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:46)
                  at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:73)
                  at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:40)
                  at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:112)
                  at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:128)
                  at com.liferay.portal.events.StartupAction.run(StartupAction.java:51)
                  ... 14 more
          Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'PollsVote.userName' in 'where clause'
                  at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:211)
                  at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:227)
                  at com.liferay.portal.upgrade.UpgradeProcess_6_0_12_to_6_1_0.doUpgrade(UpgradeProcess_6_0_12_to_6_1_0.java:51)
                  at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:208)
                  ... 21 more
          Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'PollsVote.userName' in 'where clause'
                  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
                  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
                  at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
                  at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
                  at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
                  at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)
                  at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1448)
                  at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
                  at com.liferay.portal.upgrade.v6_0_12_to_6_1_0.UpgradeUserName.updateTable(UpgradeUserName.java:65)
                  at com.liferay.portal.upgrade.v6_0_12_to_6_1_0.UpgradeUserName.doUpgrade(UpgradeUserName.java:34)
                  at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:208)
                  ... 24 more
          Stopping the server due to unexpected startup errors
          
          Show
          Ginson Ren added a comment - - edited FAILED Manual Testing using the following steps: 1. Start 6.0.12 EE server with MySql; 2. Sign in with test@liferay.com; 3. Shut down the server; 4. Upgrade to 6.1.x. Reproduced on: Tomcat 7.0.21 + MySQL 5. 6.1.x Revision 90355. Failed on: Tomcat 7.0.21 + MySQL 5. 6.1.x Revision 90598. The upgrade was failed and the console displayed error messages as follow: 02:19:54,626 ERROR [MainServlet:203] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'PollsVote.userName' in 'where clause' com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'PollsVote.userName' in 'where clause' at com.liferay.portal.events.StartupAction.run(StartupAction.java:57) at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1279) at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:200) at javax.servlet.GenericServlet.init(GenericServlet.java:160) at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1228) at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1147) at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1043) at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4957) at org.apache.catalina.core.StandardContext$3.call(StandardContext.java:5284) at org.apache.catalina.core.StandardContext$3.call(StandardContext.java:5279) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang. Thread .run(Unknown Source) Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'PollsVote.userName' in 'where clause' at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:211) at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:93) at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:46) at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:73) at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:40) at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:112) at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:128) at com.liferay.portal.events.StartupAction.run(StartupAction.java:51) ... 14 more Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'PollsVote.userName' in 'where clause' at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:211) at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:227) at com.liferay.portal.upgrade.UpgradeProcess_6_0_12_to_6_1_0.doUpgrade(UpgradeProcess_6_0_12_to_6_1_0.java:51) at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:208) ... 21 more Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'PollsVote.userName' in 'where clause' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3256) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1448) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) at com.liferay.portal.upgrade.v6_0_12_to_6_1_0.UpgradeUserName.updateTable(UpgradeUserName.java:65) at com.liferay.portal.upgrade.v6_0_12_to_6_1_0.UpgradeUserName.doUpgrade(UpgradeUserName.java:34) at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:208) ... 24 more Stopping the server due to unexpected startup errors
          Hide
          Raymond Auge added a comment -

          When upgrading you need to make sure to set the correct upgrade process:

          upgrade.processes=com.liferay.portal.upgrade.UpgradeProcess_6_0_12_to_6_1_0

          Show
          Raymond Auge added a comment - When upgrading you need to make sure to set the correct upgrade process: upgrade.processes=com.liferay.portal.upgrade.UpgradeProcess_6_0_12_to_6_1_0
          Hide
          Ginson Ren added a comment -

          Hi Raymond,I have added the line of upgrade process in portal-ext file,the error messages show that the problem is a mysql exception : Unknown column 'PollsVote.userName' in 'where clause'.I think it is nothing about upgrade process,I saw you deleted alter table PollsVote commands,I am not sure if this cause the issue.

          Show
          Ginson Ren added a comment - Hi Raymond,I have added the line of upgrade process in portal-ext file,the error messages show that the problem is a mysql exception : Unknown column 'PollsVote.userName' in 'where clause'.I think it is nothing about upgrade process,I saw you deleted alter table PollsVote commands,I am not sure if this cause the issue.
          Hide
          Michael Saechang added a comment -

          Hi Ginson,

          Code was committed on 6.1.x revision 91444 for this ticket. It should be fixed, please test.

          Show
          Michael Saechang added a comment - Hi Ginson, Code was committed on 6.1.x revision 91444 for this ticket. It should be fixed, please test.
          Hide
          Ginson Ren added a comment -

          PASSED Manual Testing following steps in description.

          Reproduced on:
          Tomcat 7.0.21 + MySQL 5. 6.1.x Revision 90598.

          Fixed on:
          Tomcat 7.0.21 + MySQL 5. 6.1.x Revision 91559.

          Show
          Ginson Ren added a comment - PASSED Manual Testing following steps in description. Reproduced on: Tomcat 7.0.21 + MySQL 5. 6.1.x Revision 90598. Fixed on: Tomcat 7.0.21 + MySQL 5. 6.1.x Revision 91559.
          Hide
          Vicki Tsang added a comment -

          This is being bulk closed in preparation for the new workflow.

          Show
          Vicki Tsang added a comment - This is being bulk closed in preparation for the new workflow.

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

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

                Development

                  Structure Helper Panel