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

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

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

          Show
          Vicki Tsang (Inactive) added a comment - This is being bulk closed in preparation for the new workflow.
          Vicki Tsang (Inactive) made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Vicki Tsang (Inactive) made changes -
          Workflow Liferay Workflow 2.2 [ 258243 ] LPS Workflow [ 283367 ]
          Andrew Kim made changes -
          Workflow LPS Workflow [ 283367 ] Copy of LPS Workflow [ 427781 ]
          Andrew Kim made changes -
          Workflow Copy of LPS Workflow [ 427781 ] LPS Workflow [ 459390 ]
          Andrew Kim made changes -
          Workflow LPS Workflow [ 459390 ] Copy 2 of LPS Workflow [ 491757 ]
          Andrew Kim made changes -
          Workflow Copy 2 of LPS Workflow [ 491757 ] LPS Workflow [ 523643 ]
          Randy Zhu made changes -
          Workflow LPS Workflow [ 523643 ] PUBLIC - LPS Generic Workflow [ 575529 ]
          Randy Zhu made changes -
          Workflow PUBLIC - LPS Generic Workflow [ 575529 ] Copy of PUBLIC - LPS Generic Workflow [ 609839 ]
          Randy Zhu made changes -
          Workflow Copy of PUBLIC - LPS Generic Workflow [ 609839 ] PUBLIC - LPS Generic Workflow [ 641768 ]
          Randy Zhu made changes -
          Workflow PUBLIC - LPS Generic Workflow [ 641768 ] PUBLIC - LPS General Workflow [ 735087 ]
          Randy Zhu 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:
                3 years, 43 weeks, 5 days ago

                Development

                  Subcomponents

                    Structure Helper Panel