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

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 6.1.0 CE RC1
• Fix Version/s: --Sprint 12/11, 6.1.0 CE RC1
• Component/s: Upgrades
• Labels:
  • QA-R
• Environment: All
• Similar Issues: Show 5 results ; ;

  LPS-20956	Upgrading Image Gallery from 6.0 fails due to index violation in ResourcePermission
  LPS-31400	Using specific definitions causes a console error after upgrading from 6.0.12
  LPS-28661	Failure to upgrade from 6.0.11 to 6.1.0 due to attempt to drop index that does not exist
  LPS-22480	Missing sql update from LPS-17743 in 6.0.12 to 6.1.0 upgrade
  LPS-11157	Upgrade WARN due to missing column uuid_ on table WikiPageResource

Reproduce as following steps:
1. Start 6.0.12 EE server with MySql;
2. Sign in with [e-mail];
3. Shut down the server;
4. Upgrade to 6.1.x.

[Ginson Ren]

FAILED Manual Testing using the following steps:
1. Start 6.0.12 EE server with MySql;
2. Sign in with [e-mail];
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

[Raymond Auge]

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

[Ginson Ren]

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.

[Michael Saechang]

Hi Ginson,

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

[Ginson Ren]

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.

[Vicki Tsang]

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