Vista Combinata Vista Piatta Vista ad Albero
Discussioni [ Precedente | Successivo ]
toggle
Philip Coates
Multiple unresolved issues upgrading from 6.0.6 to 6.1.0 (CE)
17 marzo 2012 10.54
Risposta

Philip Coates

Punteggio: Junior Member

Messaggi: 34

Data di Iscrizione: 10 dicembre 2010

Messaggi recenti

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)
17 marzo 2012 13.34
Risposta

Juan Gonzalez

LIFERAY STAFF

Punteggio: Liferay Legend

Messaggi: 1865

Data di Iscrizione: 28 ottobre 2008

Messaggi recenti

Hamish Campbell
RE: Multiple unresolved issues upgrading from 6.0.6 to 6.1.0 (CE)
17 marzo 2012 14.04
Risposta

Hamish Campbell

Punteggio: Junior Member

Messaggi: 87

Data di Iscrizione: 20 agosto 2008

Messaggi recenti

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)
17 marzo 2012 14.10
Risposta

Juan Gonzalez

LIFERAY STAFF

Punteggio: Liferay Legend

Messaggi: 1865

Data di Iscrizione: 28 ottobre 2008

Messaggi recenti

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)
19 marzo 2012 14.20
Risposta

Mika Koivisto

LIFERAY STAFF

Punteggio: Liferay Legend

Messaggi: 1499

Data di Iscrizione: 7 agosto 2006

Messaggi recenti

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)
4 aprile 2012 8.32
Risposta

marc barto

Punteggio: New Member

Messaggi: 17

Data di Iscrizione: 18 luglio 2011

Messaggi recenti

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)
4 aprile 2012 11.28
Risposta

Philip Coates

Punteggio: Junior Member

Messaggi: 34

Data di Iscrizione: 10 dicembre 2010

Messaggi recenti

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)
17 aprile 2012 1.50
Risposta

Hamish Campbell

Punteggio: Junior Member

Messaggi: 87

Data di Iscrizione: 20 agosto 2008

Messaggi recenti

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)
17 aprile 2012 7.46
Risposta

Juan Gonzalez

LIFERAY STAFF

Punteggio: Liferay Legend

Messaggi: 1865

Data di Iscrizione: 28 ottobre 2008

Messaggi recenti

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)
18 aprile 2012 2.19
Risposta

Willem Vermeer

Punteggio: New Member

Messaggi: 22

Data di Iscrizione: 30 marzo 2012

Messaggi recenti

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)
18 aprile 2012 6.59
Risposta

Mika Koivisto

LIFERAY STAFF

Punteggio: Liferay Legend

Messaggi: 1499

Data di Iscrizione: 7 agosto 2006

Messaggi recenti

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)
19 aprile 2012 1.29
Risposta

Phap Phan

Punteggio: New Member

Messaggi: 5

Data di Iscrizione: 26 marzo 2012

Messaggi recenti

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)
19 aprile 2012 1.41
Risposta

Willem Vermeer

Punteggio: New Member

Messaggi: 22

Data di Iscrizione: 30 marzo 2012

Messaggi recenti

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)
30 ottobre 2012 1.53
Risposta

Kristjan Purre

Punteggio: New Member

Messaggi: 3

Data di Iscrizione: 21 gennaio 2011

Messaggi recenti

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.