Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
Philip Coates
Multiple unresolved issues upgrading from 6.0.6 to 6.1.0 (CE)
March 17, 2012 10:54 AM
Answer

Philip Coates

Rank: Junior Member

Posts: 34

Join Date: December 10, 2010

Recent Posts

Hi,

We've been trying to upgrade to Liferay 6.1.0 CE for the past couple of weeks and have kept hitting a wall.

We're using Ubuntu with MySQL 5.1.41, Java 1.6.0_20 and running the bundled Tomcat 7.0.23.

We started off by upgrading our installation from 6.0.5 to 6.0.6, as we had heard this was the best route. This worked fine.

I've made changes to portal-ext.properties, as per the guide at http://www.liferay.com/documentation/liferay-portal/6.1/user-guide/-/ai/upgrading-lifer-5

Our instance is running under Tomcat (6.0.6 under tc 6 and 6.1.0 under tc 7.

The process I'm trying to follow is:

1) Stop Tomcat running 6.0.6
2) Backup database
3) Start Tomcat running 6.1.0

What we see is the usual upgrade process scrolling through the Tomcat logs, culminating in a bunch of errors around:

[MainServlet:198] 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 'fileEntryId' in 'where clause'

I've tried to make database changes, as per this post: http://www.liferay.com/community/forums/-/message_boards/message/8526628

I've been searching through the forum but have not been able to find anything that works.

Any hints? How can we resolve this?

Also, every time we restart the server, it goes into trying to upgrade all over again!

Out portal-ext.properties contains (amongst other things):

upgrade.processes=com.liferay.portal.upgrade.UpgradeProcess_6_0_12_to_6_1_0
image.hook.impl=com.liferay.portal.image.DLHook
...
live.users.enabled=true
buddy.list.strategy=all
...


Many thanks,

Phil.
Juan Gonzalez
RE: Multiple unresolved issues upgrading from 6.0.6 to 6.1.0 (CE)
March 17, 2012 1:34 PM
Answer

Juan Gonzalez

LIFERAY STAFF

Rank: Liferay Legend

Posts: 1984

Join Date: October 28, 2008

Recent Posts

Please read user guide and follow steps:

http://www.liferay.com/documentation/liferay-portal/6.1/user-guide/-/ai/upgrading-lifer-5
Hamish Campbell
RE: Multiple unresolved issues upgrading from 6.0.6 to 6.1.0 (CE)
March 17, 2012 2:04 PM
Answer

Hamish Campbell

Rank: Junior Member

Posts: 87

Join Date: August 20, 2008

Recent Posts

Juan Gonzalez P:


Phil has read every word many times on the user guide (: looking around over the last week or two it seams lots of people are having many different issues, are the upgrade scripts BORKED for a proportion of users? We have been upgrading since 5.2 with only small issues, this time it's not working at all.
Juan Gonzalez
RE: Multiple unresolved issues upgrading from 6.0.6 to 6.1.0 (CE)
March 17, 2012 2:10 PM
Answer

Juan Gonzalez

LIFERAY STAFF

Rank: Liferay Legend

Posts: 1984

Join Date: October 28, 2008

Recent Posts

Hamish Campbell:
Juan Gonzalez P:


Phil has read every word many times on the user guide (: looking around over the last week or two it seams lots of people are having many different issues, are the upgrade scripts BORKED for a proportion of users? We have been upgrading since 5.2 with only small issues, this time it's not working at all.


Yep there are some issues when upgrading (you can look at them in Liferay JIRA). But that error doesn't sound to me...
Mika Koivisto
RE: Multiple unresolved issues upgrading from 6.0.6 to 6.1.0 (CE)
March 19, 2012 2:20 PM
Answer

Mika Koivisto

LIFERAY STAFF

Rank: Liferay Legend

Posts: 1501

Join Date: August 7, 2006

Recent Posts

You shouldn't be using UpgradeProcess_6_0_12_to_6_1_0 since you are upgrading from 6.0.6 and not from 6.0.12.
marc barto
RE: Multiple unresolved issues upgrading from 6.0.6 to 6.1.0 (CE)
April 4, 2012 8:32 AM
Answer

marc barto

Rank: New Member

Posts: 17

Join Date: July 18, 2011

Recent Posts

Hi all

seems that lots of people having issues upgrading to 6.1. We have tried various solutions and upgrading from different versions but no luck so far.
Can people report here their experience, if they encountered similar problems and how they fixed them?
It would be a great help.

tks

Marc
Philip Coates
RE: Multiple unresolved issues upgrading from 6.0.6 to 6.1.0 (CE)
April 4, 2012 11:28 AM
Answer

Philip Coates

Rank: Junior Member

Posts: 34

Join Date: December 10, 2010

Recent Posts

Hi,

Yes, I realised that, unfortunately that actually seemed worse than before:

[UpgradeProcessUtil:77] java.lang.ClassNotFoundException: com.liferay.portal.upgrade.UpgradeProcess_6_0_6_to_6_1_0

If I can get this working, I promise to document my steps for everyone else having problems!

Cheers,

Phil.
Hamish Campbell
RE: Multiple unresolved issues upgrading from 6.0.6 to 6.1.0 (CE)
April 17, 2012 1:50 AM
Answer

Hamish Campbell

Rank: Junior Member

Posts: 87

Join Date: August 20, 2008

Recent Posts

We have given up on trying to upgrade 6.06 to 6.1 after 2 weeks of trying http://www.liferay.com/community/forums/-/message_boards/message/13041511 do people think that the new version 6.11? coming out at the end of the month might address the upgrading issues lots of people are having?

We really love the Liferay software and project and evangelise it to the wider world through projects such as http://springofcode.org which is running on liferay 6.06 but this site was built with 6.1 in mind and thus the failure to upgrade means whole parts of the site are not working and this looks bad for Liferay outreach to the techys we are working with.
Juan Gonzalez
RE: Multiple unresolved issues upgrading from 6.0.6 to 6.1.0 (CE)
April 17, 2012 7:46 AM
Answer

Juan Gonzalez

LIFERAY STAFF

Rank: Liferay Legend

Posts: 1984

Join Date: October 28, 2008

Recent Posts

Yep, many updgrade issues will be solved.

I guess there are 2 more upgrading issues won't be there, but I will give a patch to everyone who wants that solves that issues and many others.

Stay tuned, will create a thread in forums...
Willem Vermeer
RE: Multiple unresolved issues upgrading from 6.0.6 to 6.1.0 (CE)
April 18, 2012 2:19 AM
Answer

Willem Vermeer

Rank: New Member

Posts: 22

Join Date: March 30, 2012

Recent Posts

Same here - spent many, many hours trying to upgrade from 6.0.5 CE to 6.1.0 and 6.1.1, without any luck. Testing the upgrade is a very time-consuming process as one dabatase migration may run for 6 hours on end and then crash on an integrity constraint violation or other problems.

What is the expected release date for 6.1.1 CE GA2, is it still due for Friday April 20th?

My latest stacktrace, just to give you an idea:
08:36:36,849 INFO [VerifyResourcePermissions:142] Processed 100 resource permissions for com.liferay.portal.model.User
08:36:38,568 ERROR [MainServlet:198] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: com.liferay.portal.NoSuchContactException: No Contact exists with the primary key 127626312
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: com.liferay.portal.NoSuchContactException: No Contact exists with the primary key 127626312
at com.liferay.portal.events.StartupAction.run(StartupAction.java:58)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1219)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:195)
at javax.servlet.GenericServlet.init(GenericServlet.java:160)
at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1080)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5015)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5302)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:897)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:873)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:615)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:649)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1581)
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:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:679)
Caused by: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: com.liferay.portal.NoSuchContactException: No Contact exists with the primary key 127626312
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:82)
at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:117)
at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:78)
at com.liferay.portal.verify.VerifyProcessUtil.verifyProcess(VerifyProcessUtil.java:46)
at com.liferay.portal.events.StartupHelper.verifyProcess(StartupHelper.java:137)
at com.liferay.portal.events.StartupHelperUtil.verifyProcess(StartupHelperUtil.java:52)
at com.liferay.portal.tools.DBUpgrader.verify(DBUpgrader.java:201)
at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:182)
at com.liferay.portal.events.StartupAction.run(StartupAction.java:52)
... 20 more
Caused by: com.liferay.portal.verify.VerifyException: com.liferay.portal.NoSuchContactException: No Contact exists with the primary key 127626312
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:82)
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:87)
at com.liferay.portal.verify.VerifyProcessSuite.doVerify(VerifyProcessSuite.java:46)
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:79)
... 28 more
Caused by: com.liferay.portal.NoSuchContactException: No Contact exists with the primary key 127626312
at com.liferay.portal.service.persistence.ContactPersistenceImpl.findByPrimaryKey(ContactPersistenceImpl.java:490)
at com.liferay.portal.service.base.ContactLocalServiceBaseImpl.getContact(ContactLocalServiceBaseImpl.java:366)
at sun.reflect.GeneratedMethodAccessor644.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:112)
at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:71)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:108)
at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:211)
at $Proxy18.getContact(Unknown Source)
at com.liferay.portal.service.ContactLocalServiceUtil.getContact(ContactLocalServiceUtil.java:178)
at com.liferay.portal.verify.VerifyResourcePermissions.verifyModel(VerifyResourcePermissions.java:126)
at com.liferay.portal.verify.VerifyResourcePermissions.verifyModel(VerifyResourcePermissions.java:168)
at com.liferay.portal.verify.VerifyResourcePermissions.doVerify(VerifyResourcePermissions.java:81)
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:79)
... 31 more
Stopping the server due to unexpected startup errors
Mika Koivisto
RE: Multiple unresolved issues upgrading from 6.0.6 to 6.1.0 (CE)
April 18, 2012 6:59 AM
Answer

Mika Koivisto

LIFERAY STAFF

Rank: Liferay Legend

Posts: 1501

Join Date: August 7, 2006

Recent Posts

Upgrading from 6.0.x to 6.1.0 you shouldn't need to modify the upgrade.processes property as it is already correct.
Phap Phan
RE: Multiple unresolved issues upgrading from 6.0.6 to 6.1.0 (CE)
April 19, 2012 1:29 AM
Answer

Phap Phan

Rank: New Member

Posts: 5

Join Date: March 26, 2012

Recent Posts

We are also trying to upgrade the DB from LR 6.0.6 CE to 6.1 GA1, but it's really frustrating. Don't know the exact reason why the upgrading process failed after encountering a duplicate entry. Here is my log:

08:17:55,703 INFO [BaseDB:406] Database supports case sensitive queries
08:17:55,900 INFO [UpgradeProcess:205] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_1_0
08:17:55,901 INFO [UpgradeProcess:205] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeSchema
08:18:11,106 INFO [UpgradeProcess:205] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeUserName
08:18:11,147 INFO [UpgradeProcess:205] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeAdminPortlets
08:18:11,175 INFO [UpgradeProcess:205] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeBlogs
08:18:11,339 INFO [UpgradeProcess:205] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeCamelCasePortletPreferences
08:18:26,376 INFO [UpgradeProcess:205] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeCountry
08:18:26,976 INFO [UpgradeProcess:205] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeDocumentLibrary
08:18:28,140 INFO [UpgradeProcess:205] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeExpando
08:18:28,144 INFO [UpgradeProcess:205] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeGroup
08:18:28,242 INFO [UpgradeProcess:205] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery
08:18:29,528 ERROR [MainServlet:198] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '10157-24526-myqgs.com-Valentine (2)' for key 'IX_ED5CA615'
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '10157-24526-myqgs.com-Valentine (2)' for key 'IX_ED5CA615'
at com.liferay.portal.events.StartupAction.run(StartupAction.java:58)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1267)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:195)
at javax.servlet.GenericServlet.init(GenericServlet.java:160)
at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1080)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5001)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5289)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:866)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:842)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:615)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:649)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1581)
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:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:636)
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '10157-24526-myqgs.com-Valentine (2)' for key 'IX_ED5CA615'
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:81)
at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:40)
at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:119)
at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:144)
at com.liferay.portal.events.StartupAction.run(StartupAction.java:52)
... 20 more
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '10157-24526-myqgs.com-Valentine (2)' for key 'IX_ED5CA615'
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:211)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:225)
at com.liferay.portal.upgrade.UpgradeProcess_6_1_0.doUpgrade(UpgradeProcess_6_1_0.java:67)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:208)
... 27 more
Caused by: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '10157-24526-myqgs.com-Valentine (2)' for key 'IX_ED5CA615'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
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.executeUpdate(PreparedStatement.java:1585)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1500)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1485)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery.addDLFileEntry(UpgradeImageGallery.java:126)
at com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery.updateIGImageEntries(UpgradeImageGallery.java:548)
at com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery.doUpgrade(UpgradeImageGallery.java:244)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:208)
... 30 more
Willem Vermeer
RE: Multiple unresolved issues upgrading from 6.0.6 to 6.1.0 (CE)
April 19, 2012 1:41 AM
Answer

Willem Vermeer

Rank: New Member

Posts: 22

Join Date: March 30, 2012

Recent Posts

Yeah we saw that one too. It happens when there are multiple images with the same name. What I did is to run the following query (before upgrading):
select lower(name),folderid,groupid, count(*) c from igimage group by lower(name),folderid,groupid having c>1
and then manually update the igimage.name for all matching records, something like:
update igimage set name='bbb 2' where imageid=2447915;
HTH,
Willem
Kristjan Purre
RE: Multiple unresolved issues upgrading from 6.0.6 to 6.1.0 (CE)
October 30, 2012 1:53 AM
Answer

Kristjan Purre

Rank: New Member

Posts: 3

Join Date: January 21, 2011

Recent Posts

om.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: com.liferay.portal.NoSuchContactException: No Contact exists with the primary key 127626312
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: com.liferay.portal.NoSuchContactException: No Contact exists with the primary key 127626312

the problem seems to be , that in user_ table tthere is user with contactid number 127626312

but in contact_ table its missing .. best bet .. delete user from user_ table .. just trying that myself.