Upgrade issue - 6.1 - 6.2 GA1 CE

[Philip Coates, módosítva 10 év-val korábban]

Hi,

We're having yet another upgrade issue, this time moving from 6.1 to 6.2 GA1 CE.

The upgrade starts off looking like it's going to be fine, but then starts to fail with the exception:

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'FLEX' in 'where clause'

(Full stack trace at the end of this post)

I found a mention of this in Jira: https://support.liferay.com/browse/LPS-42200 and there's the suggestion there that this is fixed (Shelton Zhang's comment of 2014-01-05) but this doesn't seem to be reflected in the download of 6.2 GA1 CE available from Liferay.com.

Should I clone the repo and build it locally/take a nightly build? When will the next stable build be released that will address this, if GA1 doesn't?

Is there any other way round the problem?

Many thanks,

Phil.

Full stack trace:

23:55:11,530 ERROR [localhost-startStop-1][MainServlet:209] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'FLEX' 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.jdbc4.MySQLSyntaxErrorException: Unknown column 'FLEX' in 'where clause'
at com.liferay.portal.events.StartupAction.run(StartupAction.java:74)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1238)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:206)
at javax.servlet.GenericServlet.init(GenericServlet.java:160)
at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1280)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1193)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1088)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5176)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5460)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:656)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1635)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:701)
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'FLEX' in 'where clause'
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:181)
at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:114)
at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:66)
at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:46)
at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:138)
at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:61)
at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:143)
at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:160)
at com.liferay.portal.events.StartupAction.run(StartupAction.java:68)
... 20 more
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'FLEX' in 'where clause'
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:181)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:195)
at com.liferay.portal.upgrade.UpgradeProcess_6_2_0.doUpgrade(UpgradeProcess_6_2_0.java:75)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:178)
... 28 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'FLEX' in 'where clause'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:534)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2794)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2322)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:116)
at com.liferay.portal.upgrade.v6_2_0.UpgradeJournal.updateStructure(UpgradeJournal.java:323)
at com.liferay.portal.upgrade.v6_2_0.UpgradeJournal.addDDMStructure(UpgradeJournal.java:127)
at com.liferay.portal.upgrade.v6_2_0.UpgradeJournal.updateStructures(UpgradeJournal.java:404)
at com.liferay.portal.upgrade.v6_2_0.UpgradeJournal.doUpgrade(UpgradeJournal.java:217)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:178)
... 31 more
Stopping the server due to unexpected startup errors

[Hamish Campbell, módosítva 10 év-val korábban]

where would you get the fixed version of this? Or is there a patch!

[Juan Gonzalez, módosítva 10 év-val korábban]

Hi Hamish,

you can find the LPS in git and merge the source code.

[JOSE JAVIER QUIÑONEZ CACERES, módosítva 10 év-val korábban]

Hello/Hola

Try uninstalling these portlets:

- Beveled theme
- Violet Eagle Theme
- Resources Importer CE

After the uninstallation process, the upgrade worked fine, clear and fast.

Cheers

Javier
@jjqc

[Hamish Campbell, módosítva 10 év-val korábban]

Thanks for the help, will give these a try

[Philip Coates, módosítva 10 év-val korábban]

Thanks, unfortunately I don't have any of these themes installed.

I've had a try with a version from lcepatchers.com, but not had any success with that either

Thanks for the help so far, I'll keep on trying!

Phil.

[Philip Coates, módosítva 9 év-val korábban]

Have tried again moving from 6.1.2 - 6.2 GA2 (CE)

It looks like this is still an issue:

Unable to update journal structure with structure ID FLEX-SLIDERS

because

Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'FLEX' in 'where clause'

Has anyone else seen this before?

This is a vanilla 6.2 install (with 6.1.2 data) - is it at all possible that something in the <6.2 stack installed something and left something nasty in amongst the table structure?

There seems to be an issue about it here: https://issues.liferay.com/browse/LPS-42200

I tried putting

journal.structure.force.autogenerate.id=true

into portal-ext.properties, but that made no difference.

Can anyone point me in the right sort of direction?

Thanks,

Phil.

[Hamish Campbell, módosítva 9 év-val korábban]

flex slider is that a portal we could remove?

it didn't used to so hard to upgrade, is this an issue with CE liferay qualerty control slipping?

[Philip Coates, módosítva 9 év-val korábban]

I don't think it's actually installed any more - possibly left some cruft in the DB - does anyone know of a good way to check the DB for redundant tables, etc.?

Thanks,

Phil.

[Mohan Krishna, módosítva 9 év-val korábban]

I am facing the same issue. Wondering if there is fix for CE or if there is work around. I don't have any structure IDs with a dash, as was mentioned elsewhere as the potential reason for the failure. Any help apprediciated

[André Bunse, módosítva 9 év-val korábban]

If i remember correct it was a problem with the mysql.jar in ${TOMCAT}/lib/ext.

I mean a downgrade to another version of the mysql.jar fixed the problem. (to mysql-connector-java-5.1.21-bin.jar, i am not sure)

[Philip Coates, módosítva 9 év-val korábban]

Thanks, I'll give this a go and let you know how it went,

Cheers,

Phil.