Upgrade issue - 6.1 - 6.2 GA1 CE

[Philip Coates, modifié il y a 10 années.]

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, modifié il y a 10 années.]

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

[Juan Gonzalez, modifié il y a 10 années.]

Hi Hamish,

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

[JOSE JAVIER QUIÑONEZ CACERES, modifié il y a 10 années.]

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, modifié il y a 10 années.]

Thanks for the help, will give these a try

[Philip Coates, modifié il y a 10 années.]

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, modifié il y a 9 années.]

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, modifié il y a 9 années.]

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, modifié il y a 9 années.]

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, modifié il y a 9 années.]

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, modifié il y a 9 années.]

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, modifié il y a 9 années.]

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

Cheers,

Phil.