« Upgrade Instructions に戻る

Upgrade Instructions from 5.2 to 6.0

Alternative Languages: 日本語

This upgrade is recommended to anyone running Liferay Portal 5.2.3SE and wants to benefit from the New Features in Liferay Portal v6.0

Always use the latest version of 6.0 available as it will have fixed all the potential upgrade issues that may have been found. You should at least use v6.0.3 (there is no need to update to 6.0.1 or 6.0.2 first!)

Prerequisite #

It's recommended to upgrade first at least to 5.2.3SE if you are running any previous version.

Basic Upgrade #

If you're using a Liferay Bundle with MySQL or another external database attached: all you need to do is to back up your old bundle, saving the entire thing somewhere in case you need the configuration files, then download the new bundle and configure it for MySQL or whatever database you're using. Liferay 6.0 will auto-detect old versions of the database and upgrade automatically on start. Since all your data is in the database, your users and data will be preserved. Themes, additional plugins, and add-ons will need to be reinstalled however -- it would be wise to make a list of themes and plugins that you need, and to reinstall them after your upgrade.

Themes will need to be upgraded. You can learn to upgrade 5.2.x themes to 6.0.x via Upgrade 5.2.x Themes to 6.0.x

Additional Resources #

The official resource for topics including upgrading is the Portal Administrator's Guide. The book is available for print as well as a free PDF download.

How to keep the old values #

The default values of some properties have been changed. In order to keep the previous values, you have to run Liferay with the following system property:

 java ... -Dexternal-properties=portal-legacy-5.2.properties

Application servers differ on how to add these parameters.

In Tomcat: modify setenv.sh/setenv.bat and append that option to the environment variable JAVA_OPTS (other documentations suggest catalina.sh/catalina.bat or catalina.conf, depending on the exact version you are using. setenv.sh or setenv.bat is not delivered with tomcat but - if existing - it will be embedded in the startup process, so it's a nice way to separate your own settings from tomcats default shell scripts).

Here are the complete contents of that file (portal-legacy-5.2.properties) for reference:

users.image.max.height=0
users.image.max.width=0

locale.prepend.friendly.url.style=0

auth.token.check.enabled=false

permissions.user.check.algorithm=5
permissions.view.dynamic.inheritance=false

image.hook.impl=com.liferay.portal.image.DatabaseHook

cdn.host.http=${cdn.host}
cdn.host.https=${cdn.host}

virtual.hosts.default.community.name=

breadcrumb.show.guest.group=false
breadcrumb.show.parent.groups=false

wiki.page.titles.regexp=([^/\\\\\\[\\]%&?@]+)
wiki.page.titles.remove.regexp=([/\\\\\\[\\]%&?@]+)

Configure Database and Mail #

The configuration of the database parameters and those for mail integration are handled through the portal.properties to unify the configuration through all application servers.

It's still possible to use application server specific datasources and pools if desired by using certain configuration properties, that is, if you've been using them even with the 5.2.x releases.

Check Database Configuration for further details on how to adapt your existing configuration.

0 添付ファイル
65995 参照数
平均 (5 投票)
平均評価は3.4星中の5です。
コメント
コメント 作成者 日時
Did anybody successful upgrade from 5.2.3 to... Andreas Stangl 2010/07/19 7:19
Hi Andreas, I was able to upgrade. Here are... Michael Hashimoto 2010/07/21 10:26
Hi Andreas, Actually we need to integrate the... Senthil Chockalingam 2010/08/16 8:00
Michael, Your procedure looks like it deletes... Kirk Stork 2010/09/10 7:12
Hi Andreas, have you solved this problem? I'm... Dirk Ohst 2010/07/21 10:53
I'm also still facing the problems with the... Azaman Suleiman 2010/07/22 6:33
Oh it could be because of the default... Michael Hashimoto 2010/07/23 9:10
We're observing similar errors when attempting... Chris Stavros 2010/07/27 0:57
.. same Exception here ;-( I even didn't... A. E. 2010/07/29 5:47
Same issue here. Any solutions? Matt Smith 2010/08/12 19:31
Hi, How to integrate from liferay 5.2.3 to... Senthil Chockalingam 2010/08/16 8:03
Hello all, I'm trying to migrate from 5.2.3 to... José Cardoso 2010/08/18 6:36
We're upgrading from 5.2.3 to 6.0.5 with JBoss... Blue Coat 2010/08/19 12:41
Hi Blue, I got the same error. If somebody... Jatin Panchal 2010/12/10 0:16
Hi, I am actually able to upgrade from 5.3.2 to... Dikie Rendra Aditya 2010/08/25 2:01
Hi, I was able to upgrade from 5.2.3 to 6.0.5... Javier Lamadrid 2010/09/01 6:06
Sorry, The problem of the exception was not... Javier Lamadrid 2010/09/02 4:53
I'm upgrading a LR5 EE to LR6 CE. (We are on a... Kirk Stork 2010/09/10 10:05
We're upgrading from Liferay 5.2.3 to 6.0.5.... Dev S 2010/09/16 9:55
I get the same error that Kirk reported. Any... Dennis Greiffenberg 2010/10/15 8:19
Has anyone had success with updating 5.2.3 to... Mark Cummings 2011/01/12 12:14
Are there any known issues with the document... Kendal Montgomery 2011/04/10 23:00
Hi I am trying to upgrade from 5.2.3 to 6.0.6... Marco Ferretti 2011/05/17 3:45
For Document Library Exception you need to... Harish Kumar 2011/07/26 22:49
Hi, I am able to do the upgrade from... Ravikant Kadbe 2011/09/06 8:58
Have someone succeed to perform the upgrade... malik khalf. 2011/11/15 6:12
I have taken the backup of my live portal and I... Sunil Rai 2012/02/08 4:58
Actually I am working on up-gradation from last... Sunil Rai 2012/03/01 5:19
Hi Andreas, Did you ever get the duplicate... Brian Scott Schupbach 2012/05/21 20:10
Hi all, I have successfully upgraded to... Mudasar Kalwar 2012/10/02 4:46
Here's how I succesfully upgraded from 5.2.3 to... Juha Anttila 2012/10/19 1:31

Did anybody successful upgrade from 5.2.3 to 6.0.3? All the upgrade process does for me is to produce stuff like

14:17:57,418 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeAsset
14:17:57,440 ERROR [MainServlet:196] 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 '10149' for key 1

after all the startup dies with

Stopping the server due to unexpected startup errors

:-(
投稿日時:10/07/19 7:19
Hi Andreas,

I was able to upgrade. Here are the steps I took to get it to work using 'tomcat+mysql':

1) Delete out all the folders in the 5.2.3 tomcat directory '/.../tomcat-6.0.18/webapps/' except for 'ROOT' and 'tunnel-web'.
2) Set the '/.../tomcat-6.0.18/webapps/ROOT/WEB-INF/classes/portal-ext.properties' to this:

jdbc.default.jndi.name=

jdbc.default.driverClassName=com.mysql.jdbc.Driver­
jdbc.default.url=jdbc:mysql://localhost/lportal?useUnicode=true&characterEncodi­ng=UTF-8&useFastDateParsing=false
jdbc.default.username=
jdbc.default.password=

3­) Drop database 'lportal'.
4) Create database 'lportal' w/ character set utf8.
5) Start up the 5.2.3 tomcat bundle.
6) Stop the 5.2.3 tomcat bundle.

7) Delete out all the folders in the 6.0.3 tomcat directory '/.../tomcat-6.0.26/webapps/' except for 'ROOT' and 'tunnel-web'.
8) Set the '/.../tomcat-6.0.26/webapps/ROOT/WEB-INF/classes/portal-ext.properties' to this:

jdbc.default.jndi.name=

jdbc.default.driverClassName=com.mysql.jdbc.Driver­
jdbc.default.url=jdbc:mysql://localhost/lportal?useUnicode=true&characterEncodi­ng=UTF-8&useFastDateParsing=false
jdbc.default.username=
jdbc.default.password=

9­) Start up the 6.0.3 tomcat bundle.


After doing these specific steps the database would successfully upgrade for me. What app server + database did you use?
Andreas Stanglへのコメント。投稿日時:10/07/21 10:26
Hi Andreas,

have you solved this problem?

I'm facing with a similar problem, but i'm using Oracle.
Andreas Stanglへのコメント。投稿日時:10/07/21 10:53
I'm also still facing the problems with the following errors:

13:22:34,183 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_3.UpgradeLookAndFeel
13:22:34,205 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_3.UpgradePermission
13:22:34,218 ERROR [MainServlet:196] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: No value specified for parameter 2
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: No value specified for parameter 2
at com.liferay.portal.events.StartupAction.run(StartupAction.java:53)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:115­9)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:193)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4187­)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4496)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.ja­va:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.jav­a:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: No value specified for parameter 2
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:114­)
at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil­.java:80)
at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.­java:37)
at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:73)
at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.jav­a:40)
at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:94)
at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:117)
at com.liferay.portal.events.StartupAction.run(StartupAction.java:47)
... 29 more
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: No value specified for parameter 2
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:114­)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:130­)
at com.liferay.portal.upgrade.UpgradeProcess_6_0_3.doUpgrade(UpgradeProcess_6_0_3.j­ava:43)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:111­)
... 36 more
Caused by: java.sql.SQLException: No value specified for parameter 2
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:1718)
at com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:1666)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1377)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPrepared­Statement.java:76)
at com.liferay.portal.upgrade.v6_0_3.UpgradePermission.assignSingleApproverWorkflow­Roles(UpgradePermission.java:195)
at com.liferay.portal.upgrade.v6_0_3.UpgradePermission.updatePermissions_5(UpgradeP­ermission.java:313)
at com.liferay.portal.upgrade.v6_0_3.UpgradePermission.doUpgrade(UpgradePermission.­java:247)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:111­)
... 39 more
Stopping the server due to unexpected startup errors
投稿日時:10/07/22 6:33
Oh it could be because of the default permission algorithm. Maybe if you set this in your 'portal-ext.properties' it will work.

permissions.user.check.algorithm=5

I think that 5.2.x defaults to permission algorithm 5 and 6.0.x defaults to permission algorithm 6. So those 2 may conflict during the upgrade process.
Azaman Suleimanへのコメント。投稿日時:10/07/23 9:10
We're observing similar errors when attempting to upgrade from 5.2.3 to 6.0.4 (JBoss bundle).

Michael, your suggestion to set permissions.user.check.algorithm=5 is a good one, and appears to have addressed a previous error, but this one persists.

The error that is fixed by the permission setting is:

2010-07-27 06:44:21,421 ERROR [com.liferay.portal.servlet.MainServlet] (main) com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: com.liferay.portal.NoSuchResourceActionException: com.liferay.portlet.journal.model.JournalArticle#ADD_DISCUSSION
com.liferay.porta­l.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: com.liferay.portal.NoSuchResourceActionException: com.liferay.portlet.journal.model.JournalArticle#ADD_DISCUSSION
at com.liferay.portal.events.StartupAction.run(StartupAction.java:53)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:116­0)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:193)


The error we are still getting, with the first or both of the following set:

permissions.user.check.algorithm=5
permissions.view.dynamic.inheritance=false­

is:

[com.liferay.portal.servlet.MainServlet] (main) 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 '10149' 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.MySQLIntegrityConstraintViolationException: Duplicate entry '10149' for key 1
at com.liferay.portal.events.StartupAction.run(StartupAction.java:53)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:116­0)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:193)
. . . .


Has anyone worked this out yet?
投稿日時:10/07/27 0:57
.. same Exception here ;-(

I even didn't changed any db-tables or something... it was a new liferay 5.2.3 installation with some users and organizations.
Chris Stavrosへのコメント。投稿日時:10/07/29 5:47
Chris Stavrosへのコメント。投稿日時:10/08/12 19:31
Hi Andreas,

Actually we need to integrate the liferay 5.2.3 DB to liferay 6.0. The liferay 6.0 DB contains more than 155 tables, so please help us on this.
Michael Hashimotoへのコメント。投稿日時:10/08/16 8:00
Hi,

How to integrate from liferay 5.2.3 to liferay 6.0.4. we want to restore / use the old db content in liferay 6.0.4. The 6.0.4 versions contains above 150 tables, so please help us on this.
投稿日時:10/08/16 8:03
Hello all,

I'm trying to migrate from 5.2.3 to 6.0.4 (postgresql). I've followed the upgrade procedure, but i've got some errors:

13:35:45,045 INFO [ConfigurationLoader:56] Properties for jar:file:/home/liferay/SemBackup/liferay-files-migration/liferay-portal-6.0.4/to­mcat-6.0.26/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/portal loaded from [file:/home/liferay/SemBackup/liferay-files-migration/liferay-portal-6.0.4/tomca­t-6.0.26/webapps/ROOT/WEB-INF/classes/portal-ext.properties, jar:file:/home/liferay/SemBackup/liferay-files-migration/liferay-portal-6.0.4/to­mcat-6.0.26/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/portal.properties]
Loading jar:file:/home/liferay/SemBackup/liferay-files-migration/liferay-portal-6.0.4/to­mcat-6.0.26/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/portal.properties
Loading file:/home/liferay/SemBackup/liferay-files-migration/liferay-portal-6.0.4/tomcat­-6.0.26/webapps/ROOT/WEB-INF/classes/portal-ext.properties
13:35:48,779 INFO [DialectDetector:69] Determining dialect for PostgreSQL 8
13:35:48,829 INFO [DialectDetector:49] Using dialect org.hibernate.dialect.PostgreSQLDialect
13:35:50,810 INFO [PortalImpl:276] Global lib directory /home/liferay/SemBackup/liferay-files-migration/liferay-portal-6.0.4/tomcat-6.0.­26/lib/ext/
13:35:50,812 INFO [PortalImpl:296] Portal lib directory /home/liferay/SemBackup/liferay-files-migration/liferay-portal-6.0.4/tomcat-6.0.­26/webapps/ROOT/WEB-INF/lib/
Starting Liferay Portal Community Edition 6.0.4 CE (Bunyan / Build 6004 / July 21, 2010)
13:35:59,097 ERROR [JDBCExceptionReporter:101] ERROR: relation "lock_" does not exist
Position: 403
13:35:59,448 INFO [BaseDB:394] Database supports case sensitive queries
13:35:59,455 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_0_0
13:35:59,456 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeSchema
13:36:04,816 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeAsset
13:37:09,910 ERROR [MainServlet:196] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: ERROR: column "entryid" of relation "assettagproperty" does not exist
Position: 101
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: ERROR: column "entryid" of relation "assettagproperty" does not exist
Position: 101
at com.liferay.portal.events.StartupAction.run(StartupAction.java:53)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:116­0)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:193)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
­at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4187­)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4496)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
­at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
at­ org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.ja­va:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at­ sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.jav­a:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: ERROR: column "entryid" of relation "assettagproperty" does not exist
Position: 101
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:114­)
at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil­.java:80)
at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.­java:37)
at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:73)
at­ com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.jav­a:40)
at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:94)
at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:117)
at com.liferay.portal.events.StartupAction.run(StartupAction.java:47)
... 29 more
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: ERROR: column "entryid" of relation "assettagproperty" does not exist
Position: 101
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:114­)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:130­)
at com.liferay.portal.upgrade.UpgradeProcess_6_0_0.doUpgrade(UpgradeProcess_6_0_0.j­ava:45)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:111­)
... 36 more
Caused by: org.postgresql.util.PSQLException: ERROR: column "entryid" of relation "assettagproperty" does not exist
Position: 101
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.­java:2062)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1­795)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:­479)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statem­ent.java:367)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement­.java:321)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPrepare­dStatement.java:105)
at com.liferay.portal.upgrade.v6_0_0.UpgradeAsset.addProperty(UpgradeAsset.java:180­)
at com.liferay.portal.upgrade.v6_0_0.UpgradeAsset.copyProperties(UpgradeAsset.java:­374)
at com.liferay.portal.upgrade.v6_0_0.UpgradeAsset.updateAssetTags(UpgradeAsset.java­:512)
at com.liferay.portal.upgrade.v6_0_0.UpgradeAsset.doUpgrade(UpgradeAsset.java:388)
­at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:111­)
... 39 more
Stopping the server due to unexpected startup errors

Can someone help me ?

Thank You!
投稿日時:10/08/18 6:36
We're upgrading from 5.2.3 to 6.0.5 with JBoss and Oracle and we're receving these two errors:

1. http://issues.liferay.com/browse/LPS-11711

2. 17:06:21,718 INFO 17:06:21,709 ERROR [ContextLoader:220] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'serviceAdvice' defined in class path resource [META-INF/base-spring.x
ml]: Cannot resolve reference to bean 'asyncAdvice' while setting bean property 'nextMethodInterceptor'; nested exception is org.springframework.beans.factor
y.BeanCreationException: Error creating bean with name 'asyncAdvice' defined in class path resource [META-INF/base-spring.xml]: Cannot resolve reference to b
ean 'threadLocalCacheAdvice' while setting bean property 'nextMethodInterceptor'; nested exception is org.springframework.beans.factory.BeanCreationException
: Error creating bean with name 'threadLocalCacheAdvice' defined in class path resource [META-INF/base-spring.xml]: Cannot resolve reference to bean 'buffere
dIncrementAdvice' while setting bean property 'nextMethodInterceptor'; nested exception is org.springframework.beans.factory.BeanCreationException: Error cre
ating bean with name 'bufferedIncrementAdvice' defined in class path resource [META-INF/base-spring.xml]: Cannot resolve reference to bean 'transactionAdvice
' while setting bean property 'nextMethodInterceptor'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with
name 'transactionAdvice' defined in class path resource [META-INF/base-spring.xml]: Cannot resolve reference to bean 'liferayTransactionManager' while settin
g bean property 'transactionManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liferayTran
sactionManager' defined in class path resource [META-INF/hibernate-spring.xml]: Cannot resolve reference to bean 'liferayHibernateSessionFactory' while setti
ng constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liferayHibernateSessionF
actory' defined in class path resource [META-INF/hibernate-spring.xml]: Invocation of init method failed; nested exception is net.sf.ehcache.CacheException:
Error configuring from null. Initial cause was null
投稿日時:10/08/19 12:41
Hi, I am actually able to upgrade from 5.3.2 to 6.0.3 here are the step that I perform:
1. Extract downloaded zip file into a folder

2. remove these folder:
webapps\sevencogs-hook
webapps\sevencogs-mobile-theme
webapps\sevencogs-them­e

3. Since I'm installing in windows vista, then edited the setenv.bat in tomcat bin directory as mentioned above

4. create portal-ext.propertis in webapps\ROOT\WEB-INF\classes then add this lines:

include-and-override=portal-developer.properties

#JDBC Driver
jdbc.default.driverClassName=c­om.mysql.jdbc.Driver jdbc.default.u­rl=jdbc:mysql://localhost/lportal_6?useUnicode=true&characterEncoding=UTF-8&useF­astDateParsing=false
jdbc.default.username=root
jdbc.default.password=password

Note: I'm using MySQL

5. Create database backup from my old liferay portal 5.2.3 which is: lportal in a form of SQL Script

6. Edit the SQL Script to create 'lportal_6' database instead of lportal:
...
CREATE DATABASE IF NOT EXISTS mportal_6;
USE lportal_6;
...

7. Run the edited SQL Script above.

8. Start liferay and login after the server finish the start process.

9. Go to Control Panel > Server Administration

10. Run the 'Reindex all Search Index' button

That all the step, HTH
投稿日時:10/08/25 2:01
Hi,

I was able to upgrade from 5.2.3 to 6.0.5 following the instructions. But now I have problems with permissions, I get a NoSuchRoleException with any non-admin user.

I have upgraded using the portal-legacy-5.2.properties with permissions.user.check.algorithm = 5

Any ideas?

Thank You!
投稿日時:10/09/01 6:06
Sorry,

The problem of the exception was not related to migration.

At the end I made it. The only extra thing I had to do is remove the portal-legacy-5.2.properties once I have completed the migration. If I left the file could not go into the control panel with a non-administrator user, possibly by permission problems.

Greetings
Javier Lamadridへのコメント。投稿日時:10/09/02 4:53
Michael,

Your procedure looks like it deletes all your data.

3) drop database 'lportal'

I don't see any steps that would restore your old data. Am I missing something, or is there a missing step somewhere before step 9?
Michael Hashimotoへのコメント。投稿日時:10/09/10 7:12
I'm upgrading a LR5 EE to LR6 CE. (We are on a trial license, and haven't yet received a LR 6 EE bundle to install)

I have two databases, one for the portal and one for jackrabbit. My repositories are configured to use mysql for everything (there are no LUCENE indexes or anything in the filesystem, and my document library is in the MySQL database, not the filesystem.)

I believe in this case I need to (or at least, safely can) drop the LUCENE tables from my lportal database. But when the database migration runs, I still get database duplicate entry errors (see below).

The questions are:

1. which tables (if any) from the old installation should be dropped because they really contain transient data? (Perhaps it would be better to ask, which tables should be preserved from the LR5 database for the upgrade migration to operate on?)

2. Is it even possible to migrate LR 5 EE to LR 6 CE?

3. Is there a way to get the upgrade process to report which table it is that contains the offending duplicate entry?

4. Is it possible that the upgrade migration simply doesn't know what to do if the document library is in the database?

Thanks in advance.

---

16:53:29,770 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_0_0
16:53:29,771 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeSchema
16:53:29,978 WARN [BaseDB:372] Duplicate column name 'description': alter table DLFileVersion add description STRING null;
16:53:30,182 WARN [BaseDB:372] Table 'Lock_' already exists: create table Lock_ ( uuid_ VARCHAR(75) null, lockId LONG not null primary key, companyId LONG, userId LONG, userName VARCHAR(75) null, createDate DATE null, className VARCHAR(75) null, key_ VARCHAR(200) null, owner VARCHAR(75) null, inheritable BOOLEAN, expirationDate DATE null);
16:53:30,356 WARN [BaseDB:372] Duplicate column name 'servletContextName': alter table Release_ add servletContextName VARCHAR(75);
16:53:30,366 WARN [BaseDB:372] Table 'UserGroupGroupRole' already exists: create table UserGroupGroupRole ( userGroupId LONG not null, groupId LONG not null, roleId LONG not null, primary key (userGroupId, groupId, roleId));
16:53:30,443 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeAsset
16:53:30,903 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeAssetPublisher
16:53:30,911 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeBlogs
16:53:30,922 INFO [Table:371] Starting backup of BlogsEntry to /opt/liferay/tomcat/temp/temp-db-BlogsEntry-1284137610922
16:53:30,926 INFO [Table:407] Finished backup of BlogsEntry to /opt/liferay/tomcat/temp/temp-db-BlogsEntry-1284137610922 in 4 ms
16:53:30,928 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeDocumentLibrary
16:53:33,222 ERROR [MainServlet:202] 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 '11408-DLFE-1.pdf-1' for key 2
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 '11408-DLFE-1.pdf-1' for key 2
at com.liferay.portal.events.StartupAction.run(StartupAction.java:53)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:116­6)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:199)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4187­)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4496)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.ja­va:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.jav­a:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '11408-DLFE-1.pdf-1' for key 2
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:114­)
at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil­.java:80)
at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.­java:37)
at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:73)
at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.jav­a:40)
at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:94)
at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:117)
at com.liferay.portal.events.StartupAction.run(StartupAction.java:47)
... 29 more
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '11408-DLFE-1.pdf-1' for key 2
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:114­)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:130­)
at com.liferay.portal.upgrade.UpgradeProcess_6_0_0.doUpgrade(UpgradeProcess_6_0_0.j­ava:48)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:111­)
... 36 more
Caused by: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '11408-DLFE-1.pdf-1' for key 2
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(NewProxyPrepare­dStatement.java:105)
at com.liferay.portal.upgrade.v6_0_0.UpgradeDocumentLibrary.addFileVersion(UpgradeD­ocumentLibrary.java:86)
at com.liferay.portal.upgrade.v6_0_0.UpgradeDocumentLibrary.doUpgrade(UpgradeDocume­ntLibrary.java:133)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:111­)
... 39 more
Stopping the server due to unexpected startup errors
投稿日時:10/09/10 10:05
We're upgrading from Liferay 5.2.3 to 6.0.5. PostgreSQL 8.4.4 is used as the backend for the existing site. The upgrade process seems to run but then we get lots of NullPointerException s'.Has anyone been able to upgrade 5.2.3 to 6.0.5 without issues ? We've also set all the recommended properties for an upgrade in portal-ext.properties.


Extract of Exception output on console.

[#|2010-09-16T18:47:43.169+0200|INFO|glassfish3.0.1|javax.enterprise.sys­tem.std.com.sun.enterprise.v3.services.impl|_ThreadID=11;_ThreadName=Thread-1;|1­8:47:43,166 ERROR [PortalInstanc
es:354] com.liferay.portal.NoSuchRoleException: No Role exists with the key {companyId=10112, name=user}
com.liferay.portal.NoSuchRoleException: No Role exists with the key {companyId=10112, name=user}
at com.liferay.portal.service.persistence.RolePersistenceImpl.findByC_N(RolePersist­enceImpl.java:1264)
at com.liferay.portal.service.impl.RoleLocalServiceImpl.getRole(RoleLocalServiceImp­l.java:276)
at sun.reflect.GeneratedMethodAccessor252.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.jav­a:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils­.java:309)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(Ref­lectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveM­ethodInvocation.java:150)
at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionI­nterceptor.java:65)
Kirk Storkへのコメント。投稿日時:10/09/16 9:55
I get the same error that Kirk reported. Any solution to that?
投稿日時:10/10/15 8:19
Hi Blue,
I got the same error.

If somebody have solution then please provide it.

Thanks.
Blue Coatへのコメント。投稿日時:10/12/10 0:16
Has anyone had success with updating 5.2.3 to 6.0.x when using Tomcat as a service rather than the batch file method. Everything I have seen seems to assume it is the batch method rather than the service. Thanks in advance.
投稿日時:11/01/12 12:14
Are there any known issues with the document library (using the default FileSystem hook) when upgrading from 5.2.3 to 6.0.5 / 6.0.6? I've got a site that has a fair amount of documents in the library in our 5.2.3 instance, but when we copy the site to a 6.0.5 instance do the upgrade the document libraries all have zero counts, searching for documents yields no results, etc. I've definitely made sure to reindex all the content on the site, and I see artifacts in my data/document_libraray directory and in the database (DLFileEntry, DLFileVersion, etc. all have data). Any ideas?

Thanks.

Kendal.
投稿日時:11/04/10 23:00
Hi
I am trying to upgrade from 5.2.3 to 6.0.6 on a postgresql 8.4.4; I updated portal-ext.properties adding the configuration for the database and the algorithm ( permissions.user.check.algorithm=5 ), removed the sevencogs apps and run the portal.

I get the following exception :
10:38:54,608 INFO [PortalImpl:298] Portal lib directory /home/ferrema/software/liferay-portal-6.0.6/tomcat-6.0.29/webapps/ROOT/WEB-INF/l­ib/
Starting Liferay Portal Community Edition 6.0.6 CE (Bunyan / Build 6006 / February 17, 2011)
10:39:19,173 ERROR [JDBCExceptionReporter:101] ERROR: relation "lock_" does not exist
Position: 403
10:39:19,983 INFO [BaseDB:400] Database supports case sensitive queries
10:39:20,001 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_0_0
10:39:20,003 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeSchema
10:39:21,750 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeAsset
10:39:26,689 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeAssetPublisher
10:39:26,940 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeBlogs
10:39:26,956 INFO [Table:371] Starting backup of BlogsEntry to /home/ferrema/software/liferay6/tomcat-6.0.29/temp/temp-db-BlogsEntry-1305628766­955
10:39:27,455 INFO [Table:407] Finished backup of BlogsEntry to /home/ferrema/software/liferay6/tomcat-6.0.29/temp/temp-db-BlogsEntry-1305628766­955 in 499 ms
10:39:27,467 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeDocumentLibrary
10:39:32,880 ERROR [MainServlet:202] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "ix_6c5e6512"
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "ix_6c5e6512"
at com.liferay.portal.events.StartupAction.run(StartupAction.java:53)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:116­6)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:199)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
­at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4350­)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4659)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
­at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
at­ org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.ja­va:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)
at org.apache.catalina.core.StandardService.start(StandardService.java:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at­ sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.jav­a:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "ix_6c5e6512"
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:114­)
at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil­.java:80)
at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.­java:37)
at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:73)
at­ com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.jav­a:40)
at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:94)
at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:117)
at com.liferay.portal.events.StartupAction.run(StartupAction.java:47)
... 29 more
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "ix_6c5e6512"
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:114­)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:130­)
at com.liferay.portal.upgrade.UpgradeProcess_6_0_0.doUpgrade(UpgradeProcess_6_0_0.j­ava:48)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:111­)
... 36 more
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "ix_6c5e6512"
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.­java:2062)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1­795)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:­479)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statem­ent.java:367)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement­.java:321)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPrepare­dStatement.java:105)
at com.liferay.portal.upgrade.v6_0_0.UpgradeDocumentLibrary.addFileVersion(UpgradeD­ocumentLibrary.java:89)
at com.liferay.portal.upgrade.v6_0_0.UpgradeDocumentLibrary.doUpgrade(UpgradeDocume­ntLibrary.java:141)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:111­)
... 39 more

then the process stops.

Any idea ???
投稿日時:11/05/17 3:45
For Document Library Exception you need to delete all records from existing dlfileversion table. Don't repeat the upgrade process again in case in fails in between means It should be a fresh process. So step should be -

1. Clear the new database and Import the existing sql dump to the new database.
2 delete all records from dlfileversion table.
3.start the server.

upgrade process will populate the dlfileversion table again. It worked in my case.
Marco Ferrettiへのコメント。投稿日時:11/07/26 22:49
Hi,

I am able to do the upgrade from Liferay5.2.3 to liferay6.but when trying to do Re-Index, it throwing exception as:
2011-09-06 16:11:25,103 INFO (http-127.0.0.1-8080-11) 16:11:25,098 ERROR [LuceneIndexer:146] Error encountered while reindexing
com.liferay.portal.kernel.search.SearchException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: java.lang.UnsupportedOperationException: query result offset is not supported
at com.liferay.portal.kernel.search.BaseIndexer.reindex(BaseIndexer.java:114)

Does anyone of you have faced this issue.
Harish Kumarへのコメント。投稿日時:11/09/06 8:58
Have someone succeed to perform the upgrade from LR5.2.3 to LR 6.0.6 for postgresql8 ?
If this is the case, could your show us the steps?

thx
Ravikant Kadbeへのコメント。投稿日時:11/11/15 6:12
I have taken the backup of my live portal and I want to upgrade it to newer version in localhost and then move the upgraded version to my live site.

I followed the steps mentioned here and my stpes are :

1) I have setup the new liferay 6.0 on my localhost
(successful installation of liferay 6.0 with inbuilt Hypersonic database )

2) I have imported MySql database of live system to the local MySql Server.

3) After stopping the tomcat server, I have changed the configuration file portal-ext.properties for the MySql database details.

4) Then, I have started the start.bat file. It is showing upgrade process well but after few minutes window is closed.


Can anyone help me in this regard where I have done some mistake or am I missing something during the upgration. If anyone has some idea then please share their steps.

Thanks in advance
投稿日時:12/02/08 4:58
Actually I am working on up-gradation from last 20 days with some hit and trial but still not able to do it successfully 100%. To some extent "permissions.user.check.algorithm=5" resolve my problem but still facing issues.

After upgrade step sometime liferay portal run with lots of users are missing in the database and also from next time when I start the tomcat server still it is showing some upgrade message. I have copied document_lib documents already. Is there anything that we have to do with lucene and Jackrabbit folders too check this link also: ewernli.com/how-to-upgrade-liferay. My portal is integrated with active-directories and getting LDAP error too. Please anyone guide me.
Sunil Raiへのコメント。投稿日時:12/03/01 5:19
Hi Andreas,

Did you ever get the duplicate entry error figured out? I am having the exact same issue..

Thanks,

Brian
投稿日時:12/05/21 20:10
Hi all, I have successfully upgraded to liferay 6.0.6 from liferay 5.2.3.
Brian Scott Schupbachへのコメント。投稿日時:12/10/02 4:46
Here's how I succesfully upgraded from 5.2.3 to 6.0.6 using osx/mysql:

1. Create backup from your liferay-5.2.3
The system I'm working with has 2 folders
a) "liferay" which includes "ehcache" and "jackrabbit" folders
b) "liferay-portal-5.2.3"
so I took a backup of these

2. Create backup from database
I'm using mysql, so for all databases the portal uses do a mysqldump t.ex (mysqldump -u root -p lportal > lportal_bup.sql)

3. Download liferay-6.0.6-jboss bundle

4. Unzip the liferay-6.0.6-jboss bundle

5. Delete following folders from unzipped bundle
liferay-portal-6.0.6/jboss-5.1.0/server/default/tmp
liferay-portal-6.­0.6/jboss-5.1.0/server/default/work
liferay-portal-6.0.6/jboss-5.1.0/server/de­fault/deploy/sevencogs-hook.war
liferay-portal-6.0.6/jboss-5.1.0/server/defaul­t/deploy/sevencogs-mobile-theme.war
liferay-portal-6.0.6/jboss-5.1.0/server/de­fault/deploy/sevencogs-theme.war

6. With text editor go to the end of file liferay-portal-6.0.6/jboss-5.1.0/bin/run.conf and add to JAVA_OPTS parameters
-Duser.language=en -Duser.region=US -Dexternal-properties=portal-legacy-5.2.properties
(without the -Duser.language=en -Duser.region=US the the version numbers of the document library will corrupt!)

7. Create file liferay-portal-6.0.6/jboss-5.1.0/server/default/deploy/ROOT.war/WEB-INF/classes/­portal-ext.properties

8. Add to the portal-ext.properties the following

include-and-override=portal-developer.properties
jdbc.default.driverClassNa­me=com.mysql.jdbc.Driver
jdbc.default.url=jdbc:mysql://localhost/***A***?useUn­icode=true&characterEncoding=UTF-8&useFastDateParsing=false
jdbc.default.usern­ame=***B***
jdbc.default.password=***C***
image.hook.impl=com.liferay.portal­.image.DatabaseHook
liferay.home=***D***
resource.repositories.root=***E***
­ jcr.initialize.on.startup=false
jcr.workspace.name=liferay
jcr.node.documen­tlibrary=documentlibrary
jcr.jackrabbit.repository.root=***F***
jcr.jackrabb­it.config.file.path=${jcr.jackrabbit.repository.root}/repository.xml
jcr.jackr­abbit.repository.home=${jcr.jackrabbit.repository.root}/home
jcr.jackrabbit.cr­edentials.password=none
jcr.jackrabbit.credentials.username=none
dl.hook.imp­l=com.liferay.documentlibrary.util.JCRHook
dl.hook.file.system.root.dir=${reso­urce.repositories.root}/document_library

replace

***A*** with your lportal db name
***B*** with your db username
***C*** with your db password
***D*** with your liferay-portal-6.0.6 folder path
***E*** with your liferay-portal-6.0.6/data folder path
***F*** with your liferay-5.2.3 jackrabbit folder path

9. Run liferay-portal-6.0.6/jboss-5.1.0/bin/run.sh
the Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeDocumentLibrary takes a long time

10. To fix the user rights in liferay-portal-6.0.6/jboss-5.1.0/server/default/deploy/ROOT.war/WEB-INF/classes/­portal-legacy-5.2.properties set
permissions.user.check.algorithm=6

11. Run liferay-portal-6.0.6/jboss-5.1.0/bin/run.sh
Mudasar Kalwarへのコメント。投稿日時:12/10/19 1:31