掲示板
RE: Multiple unresolved issues upgrading from 6.0.6 to 6.1.0 (CE)
12年前 に Philip Coates によって更新されました。
Multiple unresolved issues upgrading from 6.0.6 to 6.1.0 (CE)
Junior Member 投稿: 34 参加年月日: 10/12/10 最新の投稿
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:
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):
Many thanks,
Phil.
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.
12年前 に Juan Gonzalez P によって更新されました。
RE: Multiple unresolved issues upgrading from 6.0.6 to 6.1.0 (CE)
Liferay Legend 投稿: 3089 参加年月日: 08/10/28 最新の投稿
Please read user guide and follow steps:
http://www.liferay.com/documentation/liferay-portal/6.1/user-guide/-/ai/upgrading-lifer-5
http://www.liferay.com/documentation/liferay-portal/6.1/user-guide/-/ai/upgrading-lifer-5
12年前 に Hamish Campbell によって更新されました。
RE: Multiple unresolved issues upgrading from 6.0.6 to 6.1.0 (CE)
Junior Member 投稿: 87 参加年月日: 08/08/20 最新の投稿Juan Gonzalez P:
Please read user guide and follow steps:
http://www.liferay.com/documentation/liferay-portal/6.1/user-guide/-/ai/upgrading-lifer-5
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.
12年前 に Juan Gonzalez P によって更新されました。
RE: Multiple unresolved issues upgrading from 6.0.6 to 6.1.0 (CE)
Liferay Legend 投稿: 3089 参加年月日: 08/10/28 最新の投稿Hamish Campbell:
Juan Gonzalez P:Please read user guide and follow steps:
http://www.liferay.com/documentation/liferay-portal/6.1/user-guide/-/ai/upgrading-lifer-5
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...
12年前 に Mika Koivisto によって更新されました。
RE: Multiple unresolved issues upgrading from 6.0.6 to 6.1.0 (CE)
Liferay Legend 投稿: 1519 参加年月日: 06/08/07 最新の投稿
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.
12年前 に marc b によって更新されました。
RE: Multiple unresolved issues upgrading from 6.0.6 to 6.1.0 (CE)
New Member 投稿: 17 参加年月日: 11/07/18 最新の投稿
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
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
12年前 に Philip Coates によって更新されました。
RE: Multiple unresolved issues upgrading from 6.0.6 to 6.1.0 (CE)
Junior Member 投稿: 34 参加年月日: 10/12/10 最新の投稿
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.
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.
12年前 に Hamish Campbell によって更新されました。
RE: Multiple unresolved issues upgrading from 6.0.6 to 6.1.0 (CE)
Junior Member 投稿: 87 参加年月日: 08/08/20 最新の投稿
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.
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.
12年前 に Juan Gonzalez P によって更新されました。
RE: Multiple unresolved issues upgrading from 6.0.6 to 6.1.0 (CE)
Liferay Legend 投稿: 3089 参加年月日: 08/10/28 最新の投稿
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...
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...
12年前 に Willem Vermeer によって更新されました。
RE: Multiple unresolved issues upgrading from 6.0.6 to 6.1.0 (CE)
Junior Member 投稿: 32 参加年月日: 12/03/30 最新の投稿
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
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
11年前 に Kristjan Purre によって更新されました。
RE: Multiple unresolved issues upgrading from 6.0.6 to 6.1.0 (CE)
New Member 投稿: 3 参加年月日: 11/01/21 最新の投稿
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.
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.
12年前 に Mika Koivisto によって更新されました。
RE: Multiple unresolved issues upgrading from 6.0.6 to 6.1.0 (CE)
Liferay Legend 投稿: 1519 参加年月日: 06/08/07 最新の投稿
Upgrading from 6.0.x to 6.1.0 you shouldn't need to modify the upgrade.processes property as it is already correct.
12年前 に Phap Phan によって更新されました。
RE: Multiple unresolved issues upgrading from 6.0.6 to 6.1.0 (CE)
New Member 投稿: 5 参加年月日: 12/03/27 最新の投稿
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
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
12年前 に Willem Vermeer によって更新されました。
RE: Multiple unresolved issues upgrading from 6.0.6 to 6.1.0 (CE)
Junior Member 投稿: 32 参加年月日: 12/03/30 最新の投稿
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
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