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

          rotty Raymond Auge created issue -
          rotty Raymond Auge made changes -
          Field Original Value New Value
          Status Open [ 1 ] In Progress [ 3 ]
          rotty Raymond Auge made changes -
          Status In Progress [ 3 ] In Review [ 10006 ]
          brian.chan Brian Chan made changes -
          Status In Review [ 10006 ] Manual Testing [ 10007 ]
          michael.saechang Michael Saechang made changes -
          Labels QA-R
          ginson.ren Ginson Ren made changes -
          Assignee Raymond Auge [ rotty ] Ginson Ren [ ginson.ren ]
          Hide
          ginson.ren 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 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
          ginson.ren Ginson Ren made changes -
          Status Manual Testing [ 10007 ] In Progress [ 3 ]
          ginson.ren Ginson Ren made changes -
          Assignee Ginson Ren [ ginson.ren ] Raymond Auge [ rotty ]
          Hide
          rotty 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
          rotty 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
          rotty Raymond Auge made changes -
          Assignee Raymond Auge [ rotty ] Ginson Ren [ ginson.ren ]
          Hide
          ginson.ren 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 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.
          ginson.ren Ginson Ren made changes -
          Assignee Ginson Ren [ ginson.ren ] Raymond Auge [ rotty ]
          michael.saechang Michael Saechang made changes -
          Labels QA-R
          rotty Raymond Auge made changes -
          Status In Progress [ 3 ] In Review [ 10006 ]
          brian.chan Brian Chan made changes -
          Status In Review [ 10006 ] Manual Testing [ 10007 ]
          matthew.kong Matthew Kong made changes -
          Link This issue is duplicated by LPS-22480 [ LPS-22480 ]
          michael.saechang Michael Saechang made changes -
          Labels QA-R
          michael.saechang Michael Saechang made changes -
          Assignee Raymond Auge [ rotty ] Ginson Ren [ ginson.ren ]
          Hide
          michael.saechang 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 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.
          ginson.ren Ginson Ren made changes -
          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.
          Hide
          ginson.ren 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 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.
          ginson.ren Ginson Ren made changes -
          Status Manual Testing [ 10007 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Hide
          vicki.tsang Vicki Tsang (Inactive) added a comment -

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

          Show
          vicki.tsang Vicki Tsang (Inactive) added a comment - This is being bulk closed in preparation for the new workflow.
          vicki.tsang Vicki Tsang (Inactive) made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          vicki.tsang Vicki Tsang (Inactive) made changes -
          Workflow Liferay Workflow 2.2 [ 258243 ] LPS Workflow [ 283367 ]
          andrew.kim Andrew Kim made changes -
          Workflow LPS Workflow [ 283367 ] Copy of LPS Workflow [ 427781 ]
          andrew.kim Andrew Kim made changes -
          Workflow Copy of LPS Workflow [ 427781 ] LPS Workflow [ 459390 ]
          andrew.kim Andrew Kim made changes -
          Workflow LPS Workflow [ 459390 ] Copy 2 of LPS Workflow [ 491757 ]
          andrew.kim Andrew Kim made changes -
          Workflow Copy 2 of LPS Workflow [ 491757 ] LPS Workflow [ 523643 ]
          randy.zhu Randy Zhu (Inactive) made changes -
          Workflow LPS Workflow [ 523643 ] PUBLIC - LPS Generic Workflow [ 575529 ]
          randy.zhu Randy Zhu (Inactive) made changes -
          Workflow PUBLIC - LPS Generic Workflow [ 575529 ] Copy of PUBLIC - LPS Generic Workflow [ 609839 ]
          randy.zhu Randy Zhu (Inactive) made changes -
          Workflow Copy of PUBLIC - LPS Generic Workflow [ 609839 ] PUBLIC - LPS Generic Workflow [ 641768 ]
          randy.zhu Randy Zhu (Inactive) made changes -
          Workflow PUBLIC - LPS Generic Workflow [ 641768 ] PUBLIC - LPS General Workflow [ 735087 ]
          randy.zhu Randy Zhu (Inactive) made changes -
          Workflow PUBLIC - LPS General Workflow [ 735087 ] PUBLIC - LPS Bugs Workflow [ 830588 ]
          Transition Time In Source Status Execution Times Last Executer Last Execution Date
          Open Open In Progress In Progress
          1m 15s 1 Raymond Auge 10/Oct/11 1:21 PM
          Manual Testing Manual Testing In Progress In Progress
          1d 16h 57m 1 Ginson Ren 12/Oct/11 7:32 PM
          In Progress In Progress In Review In Review
          13d 1h 11m 2 Raymond Auge 25/Oct/11 1:19 PM
          In Review In Review Manual Testing Manual Testing
          7h 16m 2 Brian Chan 25/Oct/11 2:46 PM
          Manual Testing Manual Testing Resolved Resolved
          1d 5h 7m 1 Ginson Ren 26/Oct/11 7:54 PM
          Resolved Resolved Closed Closed
          11d 4h 26m 1 Vicki Tsang (Inactive) 06/Nov/11 11:20 PM

            People

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

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                4 years, 14 weeks, 2 days ago

                Development

                  Subcomponents

                    Structure Helper Panel