Fórum

Anyone upgraded 6.0eesp2 to 6.1.30-ee-ga3 ?

thumbnail
Suresh Nimmakayala, modificado 10 Anos atrás.

Anyone upgraded 6.0eesp2 to 6.1.30-ee-ga3 ?

New Member Postagens: 10 Data de Entrada: 18/01/10 Postagens Recentes
Hi All,

Environment :Tomcatbundle + mysql + linux

i am upgrading upgrade 6.0eesp2 to 6.1.30-ee-ga3 while upgrading i am keep getting the following error looks simple duplicate error


serverlog below
....................................
01:37:54,687 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_0_12_to_6_1_0.UpgradeUserName
01:37:54,699 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeAdminPortlets
01:37:55,061 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeCamelCasePortletPreferences
01:38:05,645 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeCountry
01:38:05,666 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_0_12_to_6_1_0.UpgradeDocumentLibrary
01:38:07,062 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeGroup
01:38:08,755 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery
01:38:08,777 ERROR [localhost-startStop-1][MainServlet:217] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '5486701' for key 1
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '5486701' for key 1
at com.liferay.portal.events.StartupAction.run(StartupAction.java:56)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1300)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:214)
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:5123)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5407)
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:657)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1636)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '5486701' for key 1
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:181)
at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:113)
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:119)
at com.liferay.portal.ee.license.StartupAction.doRun(Unknown Source)
at com.liferay.portal.events.StartupAction.run(StartupAction.java:50)
... 20 more
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '5486701' for key 1
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_0_12_to_6_1_0.doUpgrade(UpgradeProcess_6_0_12_to_6_1_0.java:57)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:178)
... 29 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '5486701' for key 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
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:1040)
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.executeUpdate(PreparedStatement.java:2458)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2375)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2359)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery.addIGImageDLFileEntryType(UpgradeImageGallery.java:318)
at com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery.addIGImageDLFileEntryType(UpgradeImageGallery.java:277)
at com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery.doUpgrade(UpgradeImageGallery.java:451)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:178)
... 32 more
Stopping the server due to unexpected startup errors

........................................................
seems error in UpgradeImageGallery class

package com.liferay.portal.upgrade.v6_1_0/

public class UpgradeImageGallery extends UpgradeProcess {

-----------------------------------------------------
in the table i see

DLFileEntryType table it is created with this upgrade only, i mean 6.0 to 6.1 it is newly created


"a6227238-02de-40f4-ab48-2179173aeee6","5486701","7888","6576","9898","","2014-04-23 22:50:01","2014-04-23 22:50:01","Image Gallery Image","Image Gallery Image"
"a1c820f3-1d05-4bef-80f7-9678d94fc331","5486702","4517638","5656","2323","","2014-04-23 22:50:01","2014-04-23 22:50:01","Image Gallery Image","Image Gallery Image"
"013c1490-a64b-45ca-9021-0b96b3b0ede4","5486703","4517635","132121","675656","","2014-04-23 22:50:01","2014-04-23 22:50:01","Image Gallery Image","Image Gallery Image"
"5caa92b7-525d-452a-8a21-75bba16c0b00","5486704","4517647","2323","12322","","2014-04-23 22:50:01","2014-04-23 22:50:01","Image Gallery Image","Image Gallery Image"
"21c945cf-34c3-4b46-8345-b8e64a5a564d","5486705","4517644","3232","989876","","2014-04-23 22:50:01","2014-04-23 22:50:01","Image Gallery Image","Image Gallery Image"
"d6093b70-6092-407b-8605-f9c65fb1d55d","5486706","4517641","232323","6787645","","2014-04-23 22:50:01","2014-04-23 22:50:01","Image Gallery Image","Image Gallery Image"

i wonder why it is trying to create again with 5486701, while it already created , when i see that table there are 6 rows as shown above

i guess some one should have been faced this problem , then please share how you fixed ?

i stuck with the upgrade, please help any one

appreciate for your help

Suresh Nimmakayala
thumbnail
Suresh Nimmakayala, modificado 9 Anos atrás.

RE: Anyone upgraded 6.0eesp2 to 6.1.30-ee-ga3 ?

New Member Postagens: 10 Data de Entrada: 18/01/10 Postagens Recentes
strange no one faced this problem
thumbnail
Suresh Nimmakayala, modificado 9 Anos atrás.

RE: Anyone upgraded 6.0eesp2 to 6.1.30-ee-ga3 ?

New Member Postagens: 10 Data de Entrada: 18/01/10 Postagens Recentes
yes i done it again emoticon



may be it helps some one upgrading from old versions, i have upgraded this system several times from 4.2, i am doing it on dev server so some of the files not up to date

* get a copy of all documentlibrary from live to dev

* re-index from server admin

* i got a latest bundle liferay-portal-6.1-ee-ga3-sp1, prev i am doing on liferay-portal-6.1.30-ee-ga3

*migration removed dl.hook.impl, set properties dl.store to FileSystemStore

* while doing indexing several times to make it error free , need to cleanup some of the journal,wiki,software catalog ,image rows from database where group not exist in group table, it is happened because this system upgraded from old system when we delete community seems not deleted data related to that group from some tables

Regards
Suresh Nimmakayala
Norhafizah Hanzah, modificado 9 Anos atrás.

RE: Anyone upgraded 6.0eesp2 to 6.1.30-ee-ga3 ?

New Member Postagens: 3 Data de Entrada: 16/05/13 Postagens Recentes
may i know what attribute you put on 'portal-ext.properties'?

mine only add these:
'image.hook.impl=com.liferay.portal.image.FileSystemHook'

i try add these but still failed:
upgrade.processes=com.liferay.portal.upgrade.UpgradeProcess_6_0_12_to_6_1_0,com.liferay.portal.upgrade.UpgradeProcess_6_1_1
thumbnail
Suresh Nimmakayala, modificado 9 Anos atrás.

RE: Anyone upgraded 6.0eesp2 to 6.1.30-ee-ga3 ?

Liferay Master Postagens: 690 Data de Entrada: 18/08/04 Postagens Recentes
Please provide what was the error in server log? this will lead us to know what is the problem

cheers
suresh
Norhafizah Hanzah, modificado 9 Anos atrás.

RE: Anyone upgraded 6.0eesp2 to 6.1.30-ee-ga3 ?

New Member Postagens: 3 Data de Entrada: 16/05/13 Postagens Recentes
Hi Suresh,

Sorry for the late respone, just come to work.
Attached is catalina.out log for your reference. Seem like the server is up but i cant acces to the web page. Blank page/no respone from the server.
thumbnail
Suresh Nimmakayala, modificado 9 Anos atrás.

RE: Anyone upgraded 6.0eesp2 to 6.1.30-ee-ga3 ?

Liferay Master Postagens: 690 Data de Entrada: 18/08/04 Postagens Recentes
Note: you need to take / should have a backups because we need to put them back and try until we have success( Others say in forum wash,rinse & dry ) ..emoticon
every time if it is not successful then you need to restore database with 6.0.12 and try with different settings



when i done i have in portal-ext for upgrade as i have the following so check as per your settings


upgrade.processes=\
com.liferay.portal.upgrade.UpgradeProcess_6_0_12,\
com.liferay.portal.upgrade.UpgradeProcess_6_0_12_to_6_1_0,\
com.liferay.portal.upgrade.UpgradeProcess_6_1_1



# note this in 6.0.12 i have migrated to DLHook Since 6.1, only DLHook is supported.
#changed as per your directory

liferay.home= /opt/liferay-portal-6.1-ee-ga3-sp4
resource.repositories.root= /opt/liferay-portal-6.1-ee-ga3-sp4/data
image.hook.impl=com.liferay.portal.image.DLHook
image.hook.file.system.root.dir=${liferay.home}/data/images

#
# FileSystemStore
#
dl.store.impl=com.liferay.portlet.documentlibrary.store.FileSystemStore
dl.store.file.system.root.dir=${liferay.home}/data/document_library



hope this helps emoticon
Norhafizah Hanzah, modificado 9 Anos atrás.

RE: Anyone upgraded 6.0eesp2 to 6.1.30-ee-ga3 ?

New Member Postagens: 3 Data de Entrada: 16/05/13 Postagens Recentes
Thanks for your prompt reply.

I already create Database dump for it and restore countless time when upgrade failed... emoticon
From my previous portal-ext i only add these attribute: (maybe need to add more attribute)
#Image Hook
image.hook.impl=com.liferay.portal.image.FileSystemHook

#Upgrade version
upgrade.process=\com.liferay.portal.upgrade.UpgradeProcess_6_0_12_to_6_1_0,\com.liferay.portal.upgrade.UpgradeProcess_6_1_1


# note this in 6.0.12 i have migrated to DLHook Since 6.1, only DLHook is supported.
#changed as per your directory

liferay.home= /opt/liferay-portal-6.1-ee-ga3-sp4
resource.repositories.root= /opt/liferay-portal-6.1-ee-ga3-sp4/data
image.hook.impl=com.liferay.portal.image.DLHook
image.hook.file.system.root.dir=${liferay.home}/data/images

#
# FileSystemStore
#
dl.store.impl=com.liferay.portlet.documentlibrary.store.FileSystemStore
dl.store.file.system.root.dir=${liferay.home}/data/document_library

-By default "image.hook.impl=com.liferay.portal.image.FileSystemHook" is the attribute for migration. So i need to change it to "image.hook.impl=com.liferay.portal.image.DLHook" so that v6.1 will be supported.
-Do i need to configure something for "DLHook" in webpage before migration happen? (Sorry for asking so much question, im still new to this liferay. emoticon )

Btw,I will give it a try using your configuration provided. Thanks you very much.... ^_^
thumbnail
Suresh Nimmakayala, modificado 9 Anos atrás.

RE: Anyone upgraded 6.0eesp2 to 6.1.30-ee-ga3 ?

Liferay Master Postagens: 690 Data de Entrada: 18/08/04 Postagens Recentes
before migration to 6.1 first move image hook to DLHook, should help