Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
Upgrade 5.2.3 to 6.0.5 Igor Beslic August 18, 2010 3:11 PM
RE: Upgrade 5.2.3 to 6.0.5 Igor Beslic August 18, 2010 4:22 PM
RE: Upgrade 5.2.3 to 6.0.5 Krista M Leopold August 30, 2010 12:17 PM
RE: Upgrade 5.2.3 to 6.0.5 Krista M Leopold September 2, 2010 8:11 AM
RE: Upgrade 5.2.3 to 6.0.5 Igor Beslic September 20, 2010 11:41 AM
RE: Upgrade 5.2.3 to 6.0.5 Kirk Stork September 13, 2010 9:08 AM
RE: Upgrade 5.2.3 to 6.0.5 Igor Beslic September 20, 2010 11:52 AM
RE: Upgrade 5.2.3 to 6.0.5 Dennis Greiffenberg October 15, 2010 7:36 AM
Upgrade 5.2.3 to 6.0.5 Mathieu Amblard September 17, 2010 12:50 AM
RE: Upgrade 5.2.3 to 6.0.5 C. Daniel Mojoli-Boggino September 18, 2010 3:39 PM
RE: Upgrade 5.2.3 to 6.0.5 Nicolas Figay November 6, 2010 10:57 AM
RE: Upgrade 5.2.3 to 6.0.5 Fuad Efendi December 11, 2010 4:55 PM
RE: Upgrade 5.2.3 to 6.0.5 gianluca maranzana December 14, 2010 7:49 AM
RE: Upgrade 5.2.3 to 6.0.5 Peter B West December 19, 2010 6:02 AM
RE: Upgrade 5.2.3 to 6.0.5 Peter B West December 19, 2010 5:54 PM
RE: Upgrade 5.2.3 to 6.0.5 Purba Chowdhury February 28, 2011 11:08 PM
RE: Upgrade 5.2.3 to 6.0.5 Francois Fournel April 29, 2011 2:20 AM
RE: Upgrade 5.2.3 to 6.0.5 Francois Fournel April 29, 2011 7:12 AM
RE: Upgrade 5.2.3 to 6.0.5 evan cheung October 20, 2011 12:00 PM
RE: Upgrade 5.2.3 to 6.0.5 malik khalf. October 26, 2011 1:05 AM
RE: Upgrade 5.2.3 to 6.0.5 malik khalf. November 9, 2011 12:20 AM
RE: Upgrade 5.2.3 to 6.0.5 Andy Liao November 10, 2013 6:54 AM
RE: Upgrade 5.2.3 to 6.0.5 Mua Dibh March 28, 2013 5:22 AM
Igor Beslic
Upgrade 5.2.3 to 6.0.5
August 18, 2010 3:11 PM
Answer

Igor Beslic

Rank: Junior Member

Posts: 39

Join Date: August 3, 2006

Recent Posts

Hi,
I've fell into troubles upgrading liferay 5.2.3 to 6.0.5. I suspect maybe my MySql DB is configured in some way Liferay doesn't like.

My environment is
OS: linux
DB: MySql 5.x
(I have even repeated process with MySql and LR at windows host but exactly same exception occures)

Exception in log is:

21:39:10,499 INFO [DialectDetector:69] Determining dialect for MySQL 5
21:39:10,553 INFO [DialectDetector:49] Using dialect org.hibernate.dialect.MySQLDialect
21:39:12,772 INFO [PortalImpl:277] Global lib directory /opt/apache-tomcat-6.0.26_test/lib/ext/
21:39:12,773 INFO [PortalImpl:297] Portal lib directory /opt/apache-tomcat-6.0.26_test/webapps/portal/WEB-INF/lib/
21:39:22,399 INFO [BaseDB:399] Database does not support case sensitive queries
21:39:22,408 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_0_0
21:39:22,409 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeSchema
21:39:22,430 WARN [BaseDB:372] Table 'AssetCategory' already exists: create table AssetCategory ( uuid_ VARCHAR(75) null, categoryId LONG not null primary key, groupId LONG, companyId LONG, userId LONG, userName VARCHAR(75) null, createDate DATE null, modifiedDate DATE null, parentCategoryId LONG, leftCategoryId LONG, rightCategoryId LONG, name VARCHAR(75) null, title STRING null, vocabularyId LONG);
21:39:22,435 WARN [BaseDB:372] Table 'AssetCategoryProperty' already exists: create table AssetCategoryProperty ( categoryPropertyId LONG not null primary key, companyId LONG, userId LONG, userName VARCHAR(75) null, createDate DATE null, modifiedDate DATE null, categoryId LONG, key_ VARCHAR(75) null, value VARCHAR(75) null);
21:39:22,438 WARN [BaseDB:372] Table 'AssetEntries_AssetCategories' already exists: create table AssetEntries_AssetCategories ( entryId LONG not null, categoryId LONG not null, primary key (entryId, categoryId));
21:39:22,460 WARN [BaseDB:372] Table 'AssetEntries_AssetTags' already exists: create table AssetEntries_AssetTags ( entryId LONG not null, tagId LONG not null, primary key (entryId, tagId));
21:39:22,462 WARN [BaseDB:372] Table 'AssetEntry' already exists: create table AssetEntry ( entryId LONG not null primary key, groupId LONG, companyId LONG, userId LONG, userName VARCHAR(75) null, createDate DATE null, modifiedDate DATE null, classNameId LONG, classPK LONG, visible BOOLEAN, startDate DATE null, endDate DATE null, publishDate DATE null, expirationDate DATE null, mimeType VARCHAR(75) null, title VARCHAR(255) null, description STRING null, summary STRING null, url STRING null, height INTEGER, width INTEGER, priority DOUBLE, viewCount INTEGER);
21:39:22,464 WARN [BaseDB:372] Table 'AssetTag' already exists: create table AssetTag ( tagId LONG not null primary key, groupId LONG, companyId LONG, userId LONG, userName VARCHAR(75) null, createDate DATE null, modifiedDate DATE null, name VARCHAR(75) null, assetCount INTEGER);
21:39:22,467 WARN [BaseDB:372] Table 'AssetTagProperty' already exists: create table AssetTagProperty ( tagPropertyId LONG not null primary key, companyId LONG, userId LONG, userName VARCHAR(75) null, createDate DATE null, modifiedDate DATE null, tagId LONG, key_ VARCHAR(75) null, value VARCHAR(255) null);
21:39:22,469 WARN [BaseDB:372] Table 'AssetTagStats' already exists: create table AssetTagStats ( tagStatsId LONG not null primary key, tagId LONG, classNameId LONG, assetCount INTEGER);
21:39:22,471 WARN [BaseDB:372] Table 'AssetVocabulary' already exists: create table AssetVocabulary ( uuid_ VARCHAR(75) null, vocabularyId LONG not null primary key, groupId LONG, companyId LONG, userId LONG, userName VARCHAR(75) null, createDate DATE null, modifiedDate DATE null, name VARCHAR(75) null, title STRING null, description STRING null, settings_ STRING null);
21:39:22,979 WARN [BaseDB:372] Table 'LayoutPrototype' already exists: create table LayoutPrototype ( layoutPrototypeId LONG not null primary key, companyId LONG, name STRING null, description STRING null, settings_ STRING null, active_ BOOLEAN);
21:39:22,987 WARN [BaseDB:372] Table 'LayoutSetPrototype' already exists: create table LayoutSetPrototype ( layoutSetPrototypeId LONG not null primary key, companyId LONG, name STRING null, description STRING null, settings_ STRING null, active_ BOOLEAN);
21:39:22,989 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);
21:39:23,213 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));
21:39:23,259 WARN [BaseDB:372] Table 'WorkflowDefinitionLink' already exists: create table WorkflowDefinitionLink ( workflowDefinitionLinkId LONG not null primary key, groupId LONG, companyId LONG, userId LONG, userName VARCHAR(75) null, createDate DATE null, modifiedDate DATE null, classNameId LONG, workflowDefinitionName VARCHAR(75) null, workflowDefinitionVersion INTEGER);
21:39:23,261 WARN [BaseDB:372] Table 'WorkflowInstanceLink' already exists: create table WorkflowInstanceLink ( workflowInstanceLinkId LONG not null primary key, groupId LONG, companyId LONG, userId LONG, userName VARCHAR(75) null, createDate DATE null, modifiedDate DATE null, classNameId LONG, classPK LONG, workflowInstanceId LONG);
21:39:23,264 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeAsset
21:39:23,296 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.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '10254' for key 'PRIMARY'
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 '10254' for key 'PRIMARY'
at com.liferay.portal.events.StartupAction.run(StartupAction.java:53)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1166)
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.java: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.java: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.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '10254' for key 'PRIMARY'
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.java: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.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '10254' for key 'PRIMARY'
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.java:45)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:111)
... 36 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '10254' for key 'PRIMARY'
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:409)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2409)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2327)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2312)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at com.liferay.portal.upgrade.v6_0_0.UpgradeAsset.addEntry(UpgradeAsset.java:137)
at com.liferay.portal.upgrade.v6_0_0.UpgradeAsset.updateAssetEntries(UpgradeAsset.java:466)
at com.liferay.portal.upgrade.v6_0_0.UpgradeAsset.doUpgrade(UpgradeAsset.java:386)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:111)
... 39 more

Thanks!
Igor Beslic
RE: Upgrade 5.2.3 to 6.0.5
August 18, 2010 4:22 PM
Answer

Igor Beslic

Rank: Junior Member

Posts: 39

Join Date: August 3, 2006

Recent Posts

Resolved! I've used update scripts.

1. update mysql db with scripts
2. prevent liferay upgrade process by updating Release_ table: update Release_ set buildNumber=6005 where releaseId=1;

NOTE: probably there is some flag for mysql to ignore errors when trying to create tables or add columns which already exists. I'm not MySql expert so I also had to change sql update scripts by removing all create statements and some alter statements (look at attached files)
Attachments: update-5.2.3-6.0.0-mysql.sql (3.4k), update-6.0.0-6.0.1-mysql.sql (0.1k), update-6.0.1-6.0.2-mysql.sql (1.0k), update-6.0.2-6.0.3-mysql.sql (2.0k), update-6.0.4-6.0.5-mysql.sql (0.0k)
Krista M Leopold
RE: Upgrade 5.2.3 to 6.0.5
August 30, 2010 12:17 PM
Answer

Krista M Leopold

Rank: New Member

Posts: 24

Join Date: October 6, 2009

Recent Posts

I apologize in advance for my tone, but I am frustrated beyond belief with this upgrade process. I'm very glad to hear you got it to work, but I am curious about how you managed to preserve your data? I followed your steps below and ALL OF MY DATA IS GONE. emoticonemoticon Well, the data I care about anyway like, oh y'know... USERS. emoticon

What is the point of "upgrading" my database if the data isn't going to be preserved? Is there a "migration" script I can run instead?

I want to move from 5.2.3 to 6.0.5 as well. I was having the same issues as others who posted their woes with 6.0.3 and 6.0.4. It looked like they would be fixed with this release, but apparently it is not so.

For the record, I've tried all of these recommendations and still have been unable to get 6.0.5 running with my data:

http://www.liferay.com/community/forums/-/message_boards/message/4858313/maximized?p_p_auth=6lqOKIbh
http://www.liferay.com/community/wiki/-/wiki/1071674/Upgrade+Instructions+from+5.2+to+6.0/maximized?p_p_auth=qYpyqu6H
http://www.liferay.com/community/forums/-/message_boards/message/5505736/maximized?p_p_auth=6lqOKIbh

Has anyone successfully kept their data AND upgraded to Liferay 6??? How did you do it? I'm on Windows and Solaris, tomcat6, apache, mysql...
Krista M Leopold
RE: Upgrade 5.2.3 to 6.0.5
September 2, 2010 8:11 AM
Answer

Krista M Leopold

Rank: New Member

Posts: 24

Join Date: October 6, 2009

Recent Posts

It appears that the reason my data was disappearing is because the sevencogs-hook upgrade script was erasing everything (What's up with that, BTW?). Here are my steps to success:

1. Started with my current production 5.2.3 database.
2. Added the following lines to portal-ext.properties:
 1
 2browser.launcher.url=
 3index.on.startup=true
 4mail.session.jndi.name=
 5axis.servlet.hosts.allowed=
 6tunnel.servlet.hosts.allowed=
 7image.hook.impl=com.liferay.portal.image.DatabaseHook
 8dl.hook.impl=com.liferay.documentlibrary.util.FileSystemHook
 9dl.hook.file.system.root.dir=C:/dev/Liferay/liferay-portal-5.2.3/data/document_library
10permissions.user.check.algorithm=5

3. Modified the properties file at liferay-portal-6.0.5/tomcat-6.0.26/webapps/sevencogs-hook/WEB-INF/classes/portal.properties by deleting this line:
1upgrade.processes=\
2    com.liferay.sevencogs.hook.upgrade.UpgradeProcess_1_0_0

4. Started up the server.

I haven't done extensive testing, but so far I see my data, I see my users, I see no errors. It's a good day.
Kirk Stork
RE: Upgrade 5.2.3 to 6.0.5
September 13, 2010 9:08 AM
Answer

Kirk Stork

Rank: Junior Member

Posts: 29

Join Date: May 19, 2010

Recent Posts

Igor Beslic:
Resolved! I've used update scripts.

1. update mysql db with scripts
2. prevent liferay upgrade process by updating Release_ table: update Release_ set buildNumber=6005 where releaseId=1;

NOTE: probably there is some flag for mysql to ignore errors when trying to create tables or add columns which already exists. I'm not MySql expert so I also had to change sql update scripts by removing all create statements and some alter statements (look at attached files)


Hi Igor,

Thanks for this.. it got me a few steps closer to moving my 5.2.3 EE to 6.0.5 EE.

But not quite, this is how far I get:

Starting Liferay Portal Enterprise Edition 6.0 EE (Bunyan / Build 6010 / September 7, 2010)
15:54:03,771 INFO [BaseDB:403] Database does not support case sensitive queries
15:54:03,786 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_0_6
15:54:03,792 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_6.UpgradeSchema
15:54:03,834 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_6.UpgradeRSS
15:54:04,609 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.VerifyProcessSuite
15:54:04,615 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.VerifyProperties
15:54:04,617 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.VerifyMySQL
15:54:04,875 INFO [VerifyMySQL:36] Updating table LUCENE_0 to use engine InnoDB
15:54:29,154 INFO [VerifyMySQL:36] Updating table LUCENE_10114 to use engine InnoDB
15:54:32,686 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.VerifyCounter
15:54:32,737 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.VerifyUUID
15:54:34,255 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.VerifyRole
15:54:34,447 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.VerifyBlogs
15:54:34,456 ERROR [JDBCExceptionReporter:101] Table 'lportal6.AssetEntry' doesn't exist
15:54:34,461 ERROR [MainServlet:202] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query


Where do you find these sql migrations? Or did you roll them yourself?
Mathieu Amblard
Upgrade 5.2.3 to 6.0.5
September 17, 2010 12:50 AM
Answer

Mathieu Amblard

Rank: New Member

Posts: 1

Join Date: September 17, 2010

Recent Posts

Hi,

I've upgraded liferay 5.2.3 to 6.0.5 but when I build the ext I have many errors like:

4: package com.liferay.portal.kernel.job does not exist
import com.liferay.portal.kernel.job.JobSchedulerUtil;
^
/Users/catar/Liferay6/liferay-plugins-sdk-6.0.5/ext/ENTSavoie-ext/docroot/WEB-INF/ext-service/src/com/pentila/entSavoie/blogEntryInfos/Schedule
...

I think the ext plugin isn't linked to the portal-src in my eclipse project.

Thanks.
C. Daniel Mojoli-Boggino
RE: Upgrade 5.2.3 to 6.0.5
September 18, 2010 3:39 PM
Answer

C. Daniel Mojoli-Boggino

Rank: New Member

Posts: 12

Join Date: August 4, 2008

Recent Posts

I've fell into troubles upgrading liferay 5.2.3 to 6.0.5. I suspect maybe my MySql DB is configured in some way Liferay doesn't like.


We encountered the same problem while upgrading

  • from version 5.2.3 CE to 6.0.5 CE
  • in zones in OpenSolaris 2009.6 in EC2 m1.small instances
  • using Postgres 8.3.7 32 bit in the same OpenSolaris host

It is database independent.

Looking over the code, com.liferay.portal.upgrade.v6_0_0.updateAssetEntries selects all TagsAsset entries and attempts to insert new AssetEntry entries constructed with the result set's data. Unfortunately, all the AssetEntry entries already exist, aborting the insert operation on primary key constraint violations.

Just as other pieces of the upgrade process swallow exceptions emitting a non-disruptive warning, shouldn't this be the same?

It seems as the intent of this fragment of code is not to upgrade the schema but to resolve inconsistent data. If so, should it be part of the upgrade process?

FYI, we transcribed our stack trace at the end of this post, oh JEE deep chainy fun. This error has occurred in all our deployments.

We will use the scripts directly. We automatically remove 7cogs as part of our installation procedures so it should no interfere. It brings me to one unrelated question, what is 7cogs purpose in life? Ever since we use Liferay it is simply something to remove, we do not even look at it. Maybe its value is in our blind spots.

 117:59:07,305 ERROR [MainServlet:202] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel
 2.upgrade.UpgradeException: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "assetentry_pkey"
 3com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgr
 4esql.util.PSQLException: ERROR: duplicate key value violates unique constraint "assetentry_pkey"
 5        at com.liferay.portal.events.StartupAction.run(StartupAction.java:53)
 6        at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1166)
 7        at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:199)
 8        at javax.servlet.GenericServlet.init(GenericServlet.java:212)
 9        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
10        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
11        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4187)
12        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4496)
13        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
14        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
15        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
16        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
17        at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
18        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
19        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
20        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
21        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
22        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
23        at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
24        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
25        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
26        at org.apache.catalina.core.StandardService.start(StandardService.java:519)
27        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
28        at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
29        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
30
31        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
32        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
33        at java.lang.reflect.Method.invoke(Method.java:597)
34        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
35        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
36Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "assetentry_pkey"
37        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:114)
38        at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:80)
39        at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:37)
40        at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:73)
41        at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:40)
42        at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:94)
43        at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:117)
44        at com.liferay.portal.events.StartupAction.run(StartupAction.java:47)
45        ... 29 more
46Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "assetentry_pkey"
47        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:114)
48        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:130)
49        at com.liferay.portal.upgrade.UpgradeProcess_6_0_0.doUpgrade(UpgradeProcess_6_0_0.java:45)
50        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:111)
51        ... 36 more
52Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "assetentry_pkey"
53        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
54        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
55        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
56        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
57        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
58        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)
59        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
60        at com.liferay.portal.upgrade.v6_0_0.UpgradeAsset.addEntry(UpgradeAsset.java:137)
61        at com.liferay.portal.upgrade.v6_0_0.UpgradeAsset.updateAssetEntries(UpgradeAsset.java:466)
62        at com.liferay.portal.upgrade.v6_0_0.UpgradeAsset.doUpgrade(UpgradeAsset.java:386)
63        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:111)
64        ... 39 more
65Stopping the server due to unexpected startup errors
Igor Beslic
RE: Upgrade 5.2.3 to 6.0.5
September 20, 2010 11:41 AM
Answer

Igor Beslic

Rank: Junior Member

Posts: 39

Join Date: August 3, 2006

Recent Posts

Hi Krista,

as I had backuped LR5 db. before anything, later I played with it and figured out some basic mistakes I had done.

1. you can completely ignore my scripts and use original scripts. It is true, originals brakes but ieg. in mysql if you use -f option (I found it later) during update you'll be wrned about breaked statements but rest of script will do the job fine.

example:
1> mysql -f -u dbuser -pdbpass lportal < update_5.2.3-6.0.0-mysql.sql


2. mistake I did was missed to place legacy portal properties to WEB-INF/classes. It ruined my images and url-s as LR6 differently handles them. It is stupid mistake but it took me a day to figure it.

So, at the end, I repeted whole upgrade in just 15 minutes and my LR 6 was up and running with all data from 5.2.3 version.
Igor Beslic
RE: Upgrade 5.2.3 to 6.0.5
September 20, 2010 11:52 AM
Answer

Igor Beslic

Rank: Junior Member

Posts: 39

Join Date: August 3, 2006

Recent Posts

Kirk Stork:

Where do you find these sql migrations? Or did you roll them yourself?

I changed original scripts, but as I said IT WAS NOT NECESSARY because if you know how to ignore failing sql commands you can run originals.

Original scripts are available for download in LR's repository. Archive file is liferay-portal-sql-6.0.5.zip. You find your db and upgrade it manualy.

At the end:
- don't forget to update version info
- check are legacy properties in WEB-INF/classes

Hope this will help!
Dennis Greiffenberg
RE: Upgrade 5.2.3 to 6.0.5
October 15, 2010 7:36 AM
Answer

Dennis Greiffenberg

Rank: Regular Member

Posts: 222

Join Date: April 30, 2007

Recent Posts

Hi all,

I'm not at all able to get this update work. Tomcat is still failing to start due to duplicate key error on startup.
I tried the automagic process as well as using the appropriate db-scripts (I'm also running MySQL).
I changed the portal-ext.properties to include the following:
1image.hook.impl=com.liferay.portal.image.DatabaseHook
2dl.hook.impl=com.liferay.documentlibrary.util.FileSystemHook
3dl.hook.file.system.root.dir=C:/DEV/tomcat/liferay-portal-5.2.3/data/document_library
4permissions.user.check.algorithm=5


I also got rid of the seven-cogs-stuff.
When starting Tomcat with the new Liferay 6 it recognizes it has to upgrade, does some stuff and after a while it shuts down. The errors are all already included.

I also tried to do the following, however all the appropriate tables where empty(?!):
1delete from dlfileversion where version = 1;
2delete from quartz_cron_triggers;
3delete from quartz_job_details;
4delete from quartz_triggers;


To me it looks as half of the people is able to update like a charm and the other half isn't able to update at all...
...seems I'm part of the latter group :-(

Any more hints available?

Many thanks,
Dennis
Nicolas Figay
RE: Upgrade 5.2.3 to 6.0.5
November 6, 2010 10:57 AM
Answer

Nicolas Figay

Rank: New Member

Posts: 4

Join Date: July 2, 2009

Recent Posts

Dear C. Daniel,

I had exactly the same problem, with as OS DEBIAN and as Database Postgresql, with the Glassfich bundle.

For my migration, I followed the documentation on migration, for which you just have to install Liferay 6, then change portal-ext.properties appropriately, and finally run Liferay which should detect that some update is to be launched.

The problem, when proceeding this way, is that you don't know exactly what is done by Liferay.

Going further in my investigation, it seems that the database structure it already updated, so launching any sql script is not required. The error come from the upgrade process.

Here are the lines indicating the error which stop the server (so neither glassfish nor liferay are running after the error);

My portal is currently off, and I just don't know if I have to reinstall older version, or if I can manage without risk performing migration till the end.

Any idea on how to being able to have the udpate process going till the end?
Does it require to change the update program, or is there any other way?


Thanks for advance for you help.

Regards.

Nicolas Figay



[#|2010-11-06T17:27:27.243+0000|INFO|glassfish3.0.1|javax.enterprise.system.std.com.sun.enterprise.v3.services.impl|_ThreadID=11;_ThreadName=FelixStartLevel;|17:27:27,243 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeAsset
|#]

[#|2010-11-06T17:27:27.285+0000|INFO|glassfish3.0.1|javax.enterprise.system.std.com.sun.enterprise.v3.services.impl|_ThreadID=11;_ThreadName=FelixStartLevel;|17:27:27,283 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 "assetentry_pkey"
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 "assetentry_pkey"
at com.liferay.portal.events.StartupAction.run(StartupAction.java:53)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1166)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:199)
at javax.servlet.GenericServlet.init(GenericServlet.java:242)
at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1428)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1230)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5007)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:5280)
at com.sun.enterprise.web.WebModule.start(WebModule.java:499)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:928)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:912)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:694)
at com.sun.enterprise.web.WebContainer.loadWebModule(WebContainer.java:1947)
at com.sun.enterprise.web.WebContainer.loadWebModule(WebContainer.java:1619)
at com.sun.enterprise.web.WebApplication.start(WebApplication.java:90)
at org.glassfish.internal.data.EngineRef.start(EngineRef.java:126)
at org.glassfish.internal.data.ModuleInfo.start(ModuleInfo.java:241)
at org.glassfish.internal.data.ApplicationInfo.start(ApplicationInfo.java:236)
at com.sun.enterprise.v3.server.ApplicationLifecycle.deploy(ApplicationLifecycle.java:339)
at com.sun.enterprise.v3.server.ApplicationLoaderService.processApplication(ApplicationLoaderService.java:362)
at com.sun.enterprise.v3.server.ApplicationLoaderService.postConstruct(ApplicationLoaderService.java:185)
at com.sun.hk2.component.AbstractWombImpl.inject(AbstractWombImpl.java:174)
at com.sun.hk2.component.ConstructorWomb$1.run(ConstructorWomb.java:87)
at java.security.AccessController.doPrivileged(Native Method)
at com.sun.hk2.component.ConstructorWomb.initialize(ConstructorWomb.java:84)
at com.sun.hk2.component.AbstractWombImpl.get(AbstractWombImpl.java:77)
at com.sun.hk2.component.SingletonInhabitant.get(SingletonInhabitant.java:58)
at com.sun.hk2.component.LazyInhabitant.get(LazyInhabitant.java:107)
at com.sun.hk2.component.AbstractInhabitantImpl.get(AbstractInhabitantImpl.java:60)
at com.sun.enterprise.v3.server.AppServerStartup.run(AppServerStartup.java:236)
at com.sun.enterprise.v3.server.AppServerStartup.start(AppServerStartup.java:128)
at com.sun.enterprise.module.bootstrap.Main.launch(Main.java:457)
at com.sun.enterprise.module.bootstrap.Main.launch(Main.java:401)
at org.jvnet.hk2.osgiadapter.HK2Main.start(HK2Main.java:125)
at org.apache.felix.framework.util.SecureAction.startActivator(SecureAction.java:640)
at org.apache.felix.framework.Felix.activateBundle(Felix.java:1700)
at org.apache.felix.framework.Felix.startBundle(Felix.java:1622)
at org.apache.felix.framework.BundleImpl.start(BundleImpl.java:915)
at org.jvnet.hk2.osgimain.Main.start(Main.java:140)
at org.apache.felix.framework.util.SecureAction.startActivator(SecureAction.java:640)
at org.apache.felix.framework.Felix.activateBundle(Felix.java:1700)
at org.apache.felix.framework.Felix.startBundle(Felix.java:1622)
at org.apache.felix.framework.Felix.setActiveStartLevel(Felix.java:1077)
at org.apache.felix.framework.StartLevelImpl.run(StartLevelImpl.java:264)
at java.lang.Thread.run(Thread.java:619)
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 "assetentry_pkey"
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.java: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)
... 44 more
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "assetentry_pkey"
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.java:45)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:111)
... 51 more
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "assetentry_pkey"
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
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(AbstractJdbc2Statement.java:367)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)
at com.sun.gjc.spi.base.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:108)
at com.liferay.portal.upgrade.v6_0_0.UpgradeAsset.addEntry(UpgradeAsset.java:137)
at com.liferay.portal.upgrade.v6_0_0.UpgradeAsset.updateAssetEntries(UpgradeAsset.java:466)
at com.liferay.portal.upgrade.v6_0_0.UpgradeAsset.doUpgrade(UpgradeAsset.java:386)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:111)
... 54 more
|#]

[#|2010-11-06T17:27:27.285+0000|INFO|glassfish3.0.1|javax.enterprise.system.std.com.sun.enterprise.v3.services.impl|_ThreadID=11;_ThreadName=FelixStartLevel;|Stopping the server due to unexpected startup errors|#]
Fuad Efendi
RE: Upgrade 5.2.3 to 6.0.5
December 11, 2010 4:55 PM
Answer

Fuad Efendi

Rank: Regular Member

Posts: 148

Join Date: April 5, 2007

Recent Posts

This is of course drawback of design: AssetEntry stores "calculated" values.

Workaround for 6.0.5:

DELETE FROM AssetEntry;

Then start 6.0.5, it will recreate all those records...
gianluca maranzana
RE: Upgrade 5.2.3 to 6.0.5
December 14, 2010 7:49 AM
Answer

gianluca maranzana

Rank: Junior Member

Posts: 26

Join Date: July 30, 2008

Recent Posts

Followed step-by-step what discussed above, during migration from 5.2.3 to 6.0.5 (included final "pre-launch" DELETE FROM AssetEntry....) but I still get:
  115:20:11,992 INFO  [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_
  20_0.UpgradeAsset
  315:20:15,954 ERROR [MainServlet:202] com.liferay.portal.kernel.events.ActionExce
  4ption: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.ke
  5rnel.upgrade.UpgradeException: org.postgresql.util.PSQLException: ERROR: duplica
  6te key value violates unique constraint "assetentry_pkey"
  7  Dettaglio: Key (entryid)=(165202) already exists.
  8com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgr
  9ade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: org.po
 10stgresql.util.PSQLException: ERROR: duplicate key value violates unique constrai
 11nt "assetentry_pkey"
 12  Dettaglio: Key (entryid)=(165202) already exists.
 13        at com.liferay.portal.events.StartupAction.run(StartupAction.java:53)
 14        at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServl
 15et.java:1166)
 16        at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:199)
 17        at javax.servlet.GenericServlet.init(GenericServlet.java:212)
 18        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.
 19java:1173)
 20        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:99
 213)
 22        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContex
 23t.java:4187)
 24        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4
 25496)
 26        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
 27.java:791)
 28        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:77
 291)
 30        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
 31
 32        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.ja
 33va:637)
 34        at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.j
 35ava:563)
 36        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498
 37)
 38        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
 39        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
 40:321)
 41        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
 42eSupport.java:119)
 43        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
 44
 45        at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
 46        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
 47
 48        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443
 49)
 50        at org.apache.catalina.core.StandardService.start(StandardService.java:5
 5119)
 52        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710
 53)
 54        at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
 55        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 56        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
 57        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 58        at java.lang.reflect.Method.invoke(Unknown Source)
 59        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
 60        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
 61Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.porta
 62l.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: ERROR: dup
 63licate key value violates unique constraint "assetentry_pkey"
 64  Dettaglio: Key (entryid)=(165202) already exists.
 65        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProce
 66ss.java:114)
 67        at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(Upgrade
 68ProcessUtil.java:80)
 69        at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeP
 70rocessUtil.java:37)
 71        at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.
 72java:73)
 73        at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHel
 74perUtil.java:40)
 75        at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:94)
 76        at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:117)
 77
 78        at com.liferay.portal.events.StartupAction.run(StartupAction.java:47)
 79        ... 29 more
 80Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.ut
 81il.PSQLException: ERROR: duplicate key value violates unique constraint "asseten
 82try_pkey"
 83  Dettaglio: Key (entryid)=(165202) already exists.
 84        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProce
 85ss.java:114)
 86        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProce
 87ss.java:130)
 88        at com.liferay.portal.upgrade.UpgradeProcess_6_0_0.doUpgrade(UpgradeProc
 89ess_6_0_0.java:45)
 90        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProce
 91ss.java:111)
 92        ... 36 more
 93Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violate
 94s unique constraint "assetentry_pkey"
 95  Dettaglio: Key (entryid)=(165202) already exists.
 96        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
 97ecutorImpl.java:2102)
 98        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
 99Impl.java:1835)
100        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
101va:257)
102        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
103ement.java:500)
104        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
105Jdbc2Statement.java:388)
106        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdb
107c2Statement.java:334)
108        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewP
109roxyPreparedStatement.java:105)
110        at com.liferay.portal.upgrade.v6_0_0.UpgradeAsset.addEntry(UpgradeAsset.
111java:137)
112        at com.liferay.portal.upgrade.v6_0_0.UpgradeAsset.updateAssetEntries(Upg
113radeAsset.java:466)
114        at com.liferay.portal.upgrade.v6_0_0.UpgradeAsset.doUpgrade(UpgradeAsset
115.java:386)
116        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProce
117ss.java:111)
118        ... 39 more

Any other known workaround?

tnx
Peter B West
RE: Upgrade 5.2.3 to 6.0.5
December 19, 2010 6:02 AM
Answer

Peter B West

Rank: Junior Member

Posts: 57

Join Date: March 23, 2009

Recent Posts

The endless frustration of attempting to upgrade continues. How long has this been going on? The developers seem incapable of solving these problems.

The closest I have come to a successful update involves this process.

Download and expand the 6.0.5 tomcat distribution.

Download and expand the 6.0.5 src distribution.

Download and expand the 6.0.5 sql scripts distribution.

Copy the portal-ext.properties from the src to a stable place (tat won't be overwritten by your experiments with 6.0.5.)

Rename to portal-ext.properties.legacy, and edit as follows.

Make sure liferay.home points to your (new) distribution.
Modify to include these properties:
image.hook.impl=com.liferay.portal.image.DatabaseHook
dl.hook.impl=com.liferay.documentlibrary.util.FileSystemHook
permissions.user.check.algorithm=5

Note: leave the dl.hook.file.system.root.dir value pointing at the default, that is, dl.hook.file.system.root.dir=${liferay.home}/data/document_library

Copy the existing 5.2.3 ${liferay.home}/data directory to the 6.0.5 ${liferay.home} directory.
Copy portal-ext.properties.legacy to the 6.0.5 ${liferay.home} directory, renaming it as portal-ext.properties.

Assuming your existing database is called lportal,
mysqldump --databases lportal --add-drop-database -u root -p >lportal-5.2.3.sql
(Read the man page for mysqldump to see if you want to use the --single-transaction option.)

Here's the tricky part. You need to hack the database. So you must either do this while the database is offline, or modify all fo the scripts to use another database, say lportal_6, or test on a different system, or set up a VM to test all of this. A VM is a good option is you don't have a test system, and your database isn't enormous.

I'll assume this is taking place on a test system or in a VM.

Save this file in a safe place.
Copy the following files from the sql scripts directory, to the location where you are keeping the dump file.

update-5.2.3-6.0.0/update-5.2.3-6.0.0-mysql.sql
update-6.0.0-6.0.1/update-6.0.0-6.0.1-mysql.sql
update-6.0.1-6.0.2/update-6.0.1-6.0.2-mysql.sql
update-6.0.2-6.0.3/update-6.0.2-6.0.3-mysql.sql
update-6.0.4-6.0.5/update-6.0.4-6.0.5-mysql.sql

Run mysql, use lportal (or whatever the name of your database is).

For each mysql script, execute
source <script_name>
within mysql. Outside mysql, execute mysqldump, saving the file with an appropriate name, e.g. lportal-6.0.1.sql

This way if anything goes wrong a any particular stage, you can recover the last version that worked, instead of starting again.

Still in mysql, execute
update Release_ set buildNumber=6005 where releaseId=1;

To tell liferay that the upgrade has been done.

Outside mysql, execute mysqldump again, saving as lportal-6.0.5-build6005.sql

I was able to perform all of these steps without errors, but other people cannot. See, for example, Fuad Efendi's tip about cleaning up the AssetEntry table. Whenever you do any of these things to the database, mysqldump the result with a name identifying the fixes applied.

When you think you have the database cleaned up, the data directory copied over, and the legacy portal-ext.properties in place, try bringing the system up.

As many other have reported, the Document Library is a problem. My images came up OK, but the documents from the DL are missing. They exist in the data directory, but are not being found.
Peter B West
RE: Upgrade 5.2.3 to 6.0.5
December 19, 2010 5:54 PM
Answer

Peter B West

Rank: Junior Member

Posts: 57

Join Date: March 23, 2009

Recent Posts

Part of the problem with the document library relates to file versions.

I only have two documents is the library, fortunately. One is a PDF, and one is a KMZ file. Each file has three entries in the the DLFileRank table. The KMZ file in the DLFileEntry table has a version of 1.1. There are two version of the file in the data/document_library, in teh directory specified in the database. The PDF has a version of 1.

There is only one entry in the DLFileVersion table - for the KMZ file, and its version is given as 1. In the logs, I see this message:

11:19:22,720 ERROR [IncludeTag:231] Current URL /group/control_panel/manage/-/document_library/view/12666?p_p_state=maximized&doAsGroupId=10136&refererPlid=12312 generates exception: javax.servlet.ServletException: com.liferay.portlet.documentlibrary.NoSuchFileVersionException: No DLFileVersion exists with the key {groupId=10136, folderId=12666, name=DLFE-201.kmz, version=1.1}
11:19:22,723 ERROR [IncludeTag:154] com.liferay.portlet.documentlibrary.NoSuchFileVersionException: No DLFileVersion exists with the key {groupId=10136, folderId=12666, name=DLFE-201.kmz, version=1.1}
at com.liferay.portlet.documentlibrary.service.persistence.DLFileVersionPersistenceImpl.findByG_F_N_V(DLFileVersionPersistenceImpl.java:954)
at com.liferay.portlet.documentlibrary.service.impl.DLFileVersionLocalServiceImpl.getFileVersion(DLFileVersionLocalServiceImpl.java:45)
at com.liferay.portal.dao.jdbc.aop.DynamicDataSourceTransactionInterceptor.invoke(DynamicDataSourceTransactionInterceptor.java:44)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
at com.liferay.portlet.documentlibrary.service.DLFileVersionLocalServiceUtil.getFileVersion(DLFileVersionLocalServiceUtil.java:241)
at com.liferay.portlet.documentlibrary.model.impl.DLFileEntryImpl.getFileVersion(DLFileEntryImpl.java:96)
at com.liferay.portal.kernel.bean.AutoEscapeBeanHandler.invoke(AutoEscapeBeanHandler.java:66)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488)
Purba Chowdhury
RE: Upgrade 5.2.3 to 6.0.5
February 28, 2011 11:08 PM
Answer

Purba Chowdhury

Rank: Junior Member

Posts: 25

Join Date: June 3, 2010

Recent Posts

I have tried by making the following changes in portal.properties file:

Point to the DB used by the arlier version of Liferay.


# MySQL
jdbc.default.driverClassName=com.mysql.jdbc.Driver
jdbc.default.url=jdbc:mysql://localhost/lportal1?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false
jdbc.default.username=lportal
jdbc.default.password=lportal

(where lportal1 is the DB holding the datas of earlier version of liferay)

Then,
Uncomment the 3 lines
permissions.checker=com.liferay.portal.security.permission.SimplePermissionChecker
permissions.user.check.algorithm=5
permissions.view.dynamic.inheritance=false


You can have a try on that.
Francois Fournel
RE: Upgrade 5.2.3 to 6.0.5
April 29, 2011 2:20 AM
Answer

Francois Fournel

Rank: Junior Member

Posts: 99

Join Date: April 15, 2010

Recent Posts

Same problem with document librairy :

When I click on a link in liferay to start the download, it says :

 108:56:53,437 ERROR [IncludeTag:154] com.liferay.portlet.documentlibrary.NoSuchFileVersionException: No DLFileVersion exists with the key {groupId=10136, folderId=12771, name=DLFE-443.xls, version=1.3}
 2        at com.liferay.portlet.documentlibrary.service.persistence.DLFileVersionPersistenceImpl.findByG_F_N_V(DLFileVersionPersistenceImpl.java:945)
 3        at com.liferay.portlet.documentlibrary.service.impl.DLFileVersionLocalServiceImpl.getFileVersion(DLFileVersionLocalServiceImpl.java:45)
 4        at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:82)
 5        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
 6        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
 7        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
 8        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
 9        at com.liferay.portlet.documentlibrary.service.DLFileVersionLocalServiceUtil.getFileVersion(DLFileVersionLocalServiceUtil.java:241)
10        at com.liferay.portlet.documentlibrary.model.impl.DLFileEntryImpl.getFileVersion(DLFileEntryImpl.java:96)
11        at com.liferay.portal.kernel.bean.AutoEscapeBeanHandler.invoke(AutoEscapeBeanHandler.java:66)
12        at org.apache.jsp.html.portlet.document_005flibrary.view_jsp._jspService(view_jsp.java:4669)
13        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
14        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
15        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
16        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
17        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
18        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
19        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
20        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
21        at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
22
2308:57:03,666 WARN  [ThemeLocalServiceImpl:121] No theme found for specified theme id clitheme_WAR_clithemetheme. Returning the default theme.
2408:57:03,688 WARN  [ThemeLocalServiceImpl:121] No theme found for specified theme id clitheme_WAR_clithemetheme. Returning the default theme.
2508:57:03,917 ERROR [IncludeTag:231] Current URL /fr/group/control_panel/manage/-/document_library/view/12771?p_p_state=maximized&doAsGroupId=10136&refererPlid=11349 generates exception: An exception occurred processing JSP page /html/portlet/document_library/file_entry_columns.jspf at line 73
26
2770:                                     message="<%= fileEntry.getTitle() %>"
2871:                             />
2972:
3073:                             <c:if test="<%= fileEntry.getFileVersion().isPending() %>">
3174:                                     <div class="workflow-status-pending">
3275:                                             (<liferay-ui:message key="pending" />)
3376:                                     </div>
34
35
36Stacktrace:
3708:57:03,919 ERROR [IncludeTag:154] com.liferay.portlet.documentlibrary.NoSuchFileVersionException: No DLFileVersion exists with the key {groupId=10136, folderId=12771, name=DLFE-443.xls, version=1.3}
38        at com.liferay.portlet.documentlibrary.service.persistence.DLFileVersionPersistenceImpl.findByG_F_N_V(DLFileVersionPersistenceImpl.java:945)
39        at com.liferay.portlet.documentlibrary.service.impl.DLFileVersionLocalServiceImpl.getFileVersion(DLFileVersionLocalServiceImpl.java:45)
40        at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:82)
41        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
42        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
43        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
44        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)



Anyone managed to make the document librairy works after this upgrade ?
Francois Fournel
RE: Upgrade 5.2.3 to 6.0.5
April 29, 2011 7:12 AM
Answer

Francois Fournel

Rank: Junior Member

Posts: 99

Join Date: April 15, 2010

Recent Posts

For the help to the community emoticon :

In fact the upgrade process from the 5.2.3 to 6.0.x (personnaly, I did directly from 5.2.3 to 6.0.6 and it works) is :

0) Install a liferay 6.0.6 "out of the box".
Set the pointed db so as to be a restore of your current liferay 5.2.3 db
Set the /data directory so as to be the same that your current liferay 5.2.3 data

1)
Under linux append in file setenv.sh (in tomcat/bin) to variable JVM_OPTS the value
1-Dexternal-properties=portal-legacy-5.2.properties


Same under windows but in file setenv.bat.

Normally, this extra option is taken into account when you start liferay and all db patches are applied successfully (i.e. cf. logs for no big stack trace errors), otherwise be sure that this extra option is taken into account if you have big stack trace errors.

Thanks to this option, all additional properties that should be in portal-ext.properties are taken into account without modifying this file by hand.
More info here :
http://www.liferay.com/community/wiki/-/wiki/Main/Upgrade+Instructions+from+5.2+to+6.0

2)
Like this topic says : http://www.liferay.com/community/forums/-/message_boards/message/6493162
Apply a patch to liferay 6.0.6 source code (you can download it easily through official liferay download site on sourceforge).
This path is available for download to this corresponding solved issue : http://issues.liferay.com/browse/LPS-12109
After application, just remplace the built portal-impl.jar with the one in tomcat/webapps/ROOT/WEB-INF/lib

3) Empty tomcat/logs, tomcat/temp and tomcat/work.

4) Start liferay and it should work.

This step are ok for an upgrade of liferay 523 OTB to 60x OTB, but probably, custom theme or portlets become obsolete and should be recompiled/rearrange with liferay 60x sdk (updated librairies used as plugin dependencies, etc.)
evan cheung
RE: Upgrade 5.2.3 to 6.0.5
October 20, 2011 12:00 PM
Answer

evan cheung

Rank: Junior Member

Posts: 81

Join Date: April 17, 2008

Recent Posts

Hi,
The way I set up that works for me from 5.2.3 to 6.0.6 is this to put the following settings in the portal-ext.properties and nothing else.

permissions.checker=com.liferay.portal.security.permission.SimplePermissionChecker
permissions.user.check.algorithm=5
permissions.view.dynamic.inheritance=false


jdbc.default.driverClassName=oracle.jdbc.driver.OracleDriver
jdbc.default.url=jdbc:oracle:thin:@host
jdbc.default.username=username
jdbc.default.password=password

portal.ctx=/


hibernate.show_sql=trueupgrade.processes=\
com.liferay.portal.upgrade.UpgradeProcess_5_2_3_to_6_0_0,\
com.liferay.portal.upgrade.UpgradeProcess_6_0_1,\
com.liferay.portal.upgrade.UpgradeProcess_6_0_2,\
com.liferay.portal.upgrade.UpgradeProcess_6_0_3,\
com.liferay.portal.upgrade.UpgradeProcess_6_0_5,\
com.liferay.portal.upgrade.UpgradeProcess_6_0_6

Hope this helps anyone.

Evan
malik khalf.
RE: Upgrade 5.2.3 to 6.0.5
October 26, 2011 1:05 AM
Answer

malik khalf.

Rank: Junior Member

Posts: 51

Join Date: September 23, 2011

Recent Posts

you mean we don't need to upgrade the database ??
malik khalf.
RE: Upgrade 5.2.3 to 6.0.5
November 9, 2011 12:20 AM
Answer

malik khalf.

Rank: Junior Member

Posts: 51

Join Date: September 23, 2011

Recent Posts

Hi all,
I tried to upgrade from configuration1 to configuration2 where:
  1. configuration1= Liferay 5.2.3 + postgresql 8 + Glassfish 4
  2. configuration1= Liferay 6.0.6 + postgresql 8 + JBoss 5 GA


I followed the procedure given by evan cheung which works pretty well with an empty Mysql database. But in my configuration I got tho following errors when starting JBoss:

2011-11-09 07:44:37,036 INFO [org.jboss.bootstrap.microcontainer.ServerImpl] (JBoss Shutdown Hook) Runtime shutdown hook called, forceHalt: true
2011-11-09 07:44:37,254 INFO [org.apache.coyote.http11.Http11AprProtocol] (JBoss Shutdown Hook) Suspension de Coyote HTTP/1.1 sur http-127.0.0.1-8080
2011-11-09 07:44:37,317 INFO [org.apache.coyote.http11.Http11AprProtocol] (JBoss Shutdown Hook) Arr�t de Coyote HTTP/1.1 sur http-127.0.0.1-8080
2011-11-09 07:44:37,504 INFO [org.apache.coyote.ajp.AjpAprProtocol] (JBoss Shutdown Hook) Pausing Coyote AJP/1.3 on ajp-127.0.0.1-8009
2011-11-09 07:44:37,504 INFO [org.apache.coyote.ajp.AjpAprProtocol] (JBoss Shutdown Hook) Stopping Coyote AJP/1.3 on ajp-127.0.0.1-8009
2011-11-09 07:44:37,692 INFO [org.jboss.jms.server.connectionfactory.ConnectionFactory] (JBoss Shutdown Hook) org.jboss.jms.server.connectionfactory.ConnectionFactory@8f74e8 undeployed
2011-11-09 07:44:37,692 INFO [org.jboss.jms.server.connectionfactory.ConnectionFactory] (JBoss Shutdown Hook) org.jboss.jms.server.connectionfactory.ConnectionFactory@fbb486 undeployed
2011-11-09 07:44:37,692 INFO [org.jboss.jms.server.connectionfactory.ConnectionFactory] (JBoss Shutdown Hook) org.jboss.jms.server.connectionfactory.ConnectionFactory@5687e1 undeployed
2011-11-09 07:44:37,692 INFO [org.jboss.web.tomcat.service.deployers.TomcatDeployment] (JBoss Shutdown Hook) undeploy, ctxPath=/web-console
2011-11-09 07:44:37,707 INFO [org.jboss.jms.server.destination.QueueService] (JBoss Shutdown Hook) Queue[/queue/ExpiryQueue] stopped
2011-11-09 07:44:37,707 INFO [org.jboss.jms.server.destination.QueueService] (JBoss Shutdown Hook) Queue[/queue/DLQ] stopped
2011-11-09 07:44:38,004 INFO [org.jboss.ejb3.session.SessionSpecContainer] (JBoss Shutdown Hook) Stopping jboss.j2ee:jar=profileservice-secured.jar,name=SecureProfileService,service=EJB3
2011-11-09 07:44:38,160 INFO [org.jboss.ejb3.EJBContainer] (JBoss Shutdown Hook) STOPPED EJB: org.jboss.profileservice.ejb.SecureProfileServiceBean ejbName: SecureProfileService
2011-11-09 07:44:38,207 INFO [org.jboss.ejb3.session.SessionSpecContainer] (JBoss Shutdown Hook) Stopping jboss.j2ee:jar=profileservice-secured.jar,name=SecureDeploymentManager,service=EJB3
2011-11-09 07:44:38,332 INFO [org.jboss.ejb3.EJBContainer] (JBoss Shutdown Hook) STOPPED EJB: org.jboss.profileservice.ejb.SecureDeploymentManager ejbName: SecureDeploymentManager
2011-11-09 07:44:38,379 INFO [org.jboss.ejb3.session.SessionSpecContainer] (JBoss Shutdown Hook) Stopping jboss.j2ee:jar=profileservice-secured.jar,name=SecureManagementView,service=EJB3
2011-11-09 07:44:38,395 INFO [org.jboss.ejb3.EJBContainer] (JBoss Shutdown Hook) STOPPED EJB: org.jboss.profileservice.ejb.SecureManagementView ejbName: SecureManagementView
2011-11-09 07:44:38,442 INFO [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] (JBoss Shutdown Hook) Unbound ConnectionManager 'jboss.jca:service=ConnectionFactoryBinding,name=JmsXA' from JNDI name 'java:JmsXA'
2011-11-09 07:44:38,895 INFO [org.jboss.jms.server.ServerPeer] (JBoss Shutdown Hook) JMS ServerPeer[0] stopped
2011-11-09 07:44:38,895 INFO [org.jboss.web.tomcat.service.deployers.TomcatDeployment] (JBoss Shutdown Hook) undeploy, ctxPath=/invoker
2011-11-09 07:44:38,973 INFO [org.jboss.web.tomcat.service.deployers.TomcatDeployment] (JBoss Shutdown Hook) undeploy, ctxPath=/jbossws
2011-11-09 07:44:38,973 INFO [org.jboss.web.tomcat.service.deployers.TomcatDeployment] (JBoss Shutdown Hook) undeploy, ctxPath=/admin-console
2011-11-09 07:44:38,973 INFO [org.jboss.web.tomcat.service.deployers.TomcatDeployment] (JBoss Shutdown Hook) undeploy, ctxPath=/
2011-11-09 07:44:38,973 INFO [org.apache.catalina.core.ContainerBase.[jboss.web]..[/tunnel-web]] (JBoss Shutdown Hook) Destroying Spring FrameworkServlet 'Spring Servlet'
2011-11-09 07:44:41,114 INFO [org.apache.catalina.core.ContainerBase.[jboss.web]..[/]] (JBoss Shutdown Hook) Closing Spring root WebApplicationContext
2011-11-09 07:44:42,145 INFO [com.liferay.portal.kernel.deploy.hot.HotDeployUtil] (JBoss Shutdown Hook) Initializing hot deploy manager 5387809
2011-11-09 07:44:42,363 INFO [org.jboss.web.tomcat.service.deployers.TomcatDeployment] (JBoss Shutdown Hook) undeploy, ctxPath=/jmx-console
2011-11-09 07:44:42,363 INFO [org.jboss.web.tomcat.service.deployers.TomcatDeployment] (JBoss Shutdown Hook) undeploy, ctxPath=/tunnel-web
2011-11-09 07:44:42,363 INFO [org.apache.catalina.core.StandardService] (JBoss Shutdown Hook) Arr�t du service jboss.web
2011-11-09 07:44:42,738 INFO [org.jboss.mail.MailService] (JBoss Shutdown Hook) Mail service 'java:/Mail' removed from JNDI
2011-11-09 07:44:42,801 INFO [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] (JBoss Shutdown Hook) Unbound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DefaultDS' from JNDI name 'javaemoticonefaultDS'
2011-11-09 07:44:45,223 INFO [com.arjuna.ats.jbossatx.jta.TransactionManagerService] (JBoss Shutdown Hook) Stopping transaction recovery manager
2011-11-09 07:44:45,223 INFO [com.arjuna.ats.jbossatx.jta.TransactionManagerService] (JBoss Shutdown Hook) Destroying TransactionManagerService
2011-11-09 07:44:45,473 INFO [org.jboss.jdbc.HypersonicDatabase] (JBoss Shutdown Hook) Database standalone closed clean
2011-11-09 07:44:50,441 INFO [org.jboss.bootstrap.microcontainer.ServerImpl] (JBoss Shutdown Hook) Shutdown complete
2011-11-09 07:48:11,561 INFO [org.jboss.web.WebService] (main) Using RMI server codebase: http://127.0.0.1:8083/
2011-11-09 07:48:18,733 INFO [org.jboss.wsf.stack.jbws.NativeServerConfig] (main) JBoss Web Services - Stack Native Core
2011-11-09 07:48:18,733 INFO [org.jboss.wsf.stack.jbws.NativeServerConfig] (main) 3.1.2.GA
2011-11-09 07:48:19,358 INFO [org.jboss.dependency.plugins.AttributeCallbackItem] (main) Owner callback not implemented.
2011-11-09 07:48:20,264 INFO [org.jboss.logbridge.LogNotificationListener] (main) Adding notification listener for logging mbean "jboss.system:service=Logging,type=Log4jService" to server org.jboss.mx.server.MBeanServerImpl@1f7d812[ defaultDomain='jboss' ]
2011-11-09 07:48:23,342 INFO [org.jboss.virtual.plugins.copy.CopyMechanism] (main) VFS temp dir: C:\development\tools\jboss-5.1.0.GA\server\default\tmp
2011-11-09 07:49:05,060 INFO [org.jboss.ejb3.deployers.Ejb3DependenciesDeployer] (main) Encountered deployment AbstractVFSDeploymentContext@31800058{vfsfile:/C:/development/tools/jboss-5.1.0.GA/server/default/deploy/profileservice-secured.jar/}
2011-11-09 07:49:05,060 INFO [org.jboss.ejb3.deployers.Ejb3DependenciesDeployer] (main) Encountered deployment AbstractVFSDeploymentContext@31800058{vfsfile:/C:/development/tools/jboss-5.1.0.GA/server/default/deploy/profileservice-secured.jar/}
2011-11-09 07:49:05,060 INFO [org.jboss.ejb3.deployers.Ejb3DependenciesDeployer] (main) Encountered deployment AbstractVFSDeploymentContext@31800058{vfsfile:/C:/development/tools/jboss-5.1.0.GA/server/default/deploy/profileservice-secured.jar/}
2011-11-09 07:49:05,060 INFO [org.jboss.ejb3.deployers.Ejb3DependenciesDeployer] (main) Encountered deployment AbstractVFSDeploymentContext@31800058{vfsfile:/C:/development/tools/jboss-5.1.0.GA/server/default/deploy/profileservice-secured.jar/}
2011-11-09 07:49:07,950 INFO [org.jboss.mx.remoting.service.JMXConnectorServerService] (main) JMX Connector server: service:jmx:rmi://127.0.0.1/jndi/rmi://127.0.0.1:1090/jmxconnector
2011-11-09 07:49:08,169 INFO [org.jboss.mail.MailService] (main) Mail Service bound to java:/Mail
2011-11-09 07:49:10,216 WARN [org.jboss.jms.server.jbosssx.JBossASSecurityMetadataStore] (main) WARNING! POTENTIAL SECURITY RISK. It has been detected that the MessageSucker component which sucks messages from one node to another has not had its password changed from the installation default. Please see the JBoss Messaging user guide for instructions on how to do this.
2011-11-09 07:49:10,232 WARN [org.jboss.annotation.factory.AnnotationCreator] (main) No ClassLoader provided, using TCCL: org.jboss.managed.api.annotation.ManagementComponent
2011-11-09 07:49:10,310 WARN [org.jboss.annotation.factory.AnnotationCreator] (main) No ClassLoader provided, using TCCL: org.jboss.managed.api.annotation.ManagementComponent
2011-11-09 07:49:10,466 INFO [com.arjuna.ats.jbossatx.jta.TransactionManagerService] (main) JBossTS Transaction Service (JTA version - tag:JBOSSTS_4_6_1_GA) - JBoss Inc.
2011-11-09 07:49:10,466 INFO [com.arjuna.ats.jbossatx.jta.TransactionManagerService] (main) Setting up property manager MBean and JMX layer
2011-11-09 07:49:10,669 INFO [com.arjuna.ats.jbossatx.jta.TransactionManagerService] (main) Initializing recovery manager
2011-11-09 07:49:10,888 INFO [com.arjuna.ats.jbossatx.jta.TransactionManagerService] (main) Recovery manager configured
2011-11-09 07:49:10,888 INFO [com.arjuna.ats.jbossatx.jta.TransactionManagerService] (main) Binding TransactionManager JNDI Reference
2011-11-09 07:49:10,935 INFO [com.arjuna.ats.jbossatx.jta.TransactionManagerService] (main) Starting transaction recovery manager
2011-11-09 07:49:11,575 INFO [org.apache.catalina.core.AprLifecycleListener] (main) Loaded Apache Tomcat Native library 1.1.22.
2011-11-09 07:49:11,575 INFO [org.apache.catalina.core.AprLifecycleListener] (main) APR capabilities: IPv6 , sendfile , random .
2011-11-09 07:49:12,747 INFO [org.apache.coyote.http11.Http11AprProtocol] (main) Initialisation de Coyote HTTP/1.1 sur http-127.0.0.1-8080
2011-11-09 07:49:12,747 INFO [org.apache.coyote.ajp.AjpAprProtocol] (main) Initializing Coyote AJP/1.3 on ajp-127.0.0.1-8009
2011-11-09 07:49:12,778 INFO [org.apache.catalina.core.StandardService] (main) D�marrage du service jboss.web
2011-11-09 07:49:12,778 INFO [org.apache.catalina.core.StandardEngine] (main) Starting Servlet Engine: JBoss Web/2.1.3.GA
2011-11-09 07:49:12,810 INFO [org.apache.catalina.startup.Catalina] (main) Server startup in 68 ms
2011-11-09 07:49:12,825 INFO [org.jboss.web.tomcat.service.deployers.TomcatDeployment] (main) deploy, ctxPath=/web-console
2011-11-09 07:49:13,857 INFO [org.jboss.web.tomcat.service.deployers.TomcatDeployment] (main) deploy, ctxPath=/invoker
2011-11-09 07:49:13,888 INFO [org.jboss.web.tomcat.service.deployers.TomcatDeployment] (main) deploy, ctxPath=/jbossws
2011-11-09 07:49:14,075 INFO [org.jboss.resource.deployers.RARDeployment] (main) Required license terms exist, view vfsfile:/C:/development/tools/jboss-5.1.0.GA/server/default/deploy/jboss-local-jdbc.rar/META-INF/ra.xml
2011-11-09 07:49:14,091 INFO [org.jboss.resource.deployers.RARDeployment] (main) Required license terms exist, view vfsfile:/C:/development/tools/jboss-5.1.0.GA/server/default/deploy/jboss-xa-jdbc.rar/META-INF/ra.xml
2011-11-09 07:49:14,107 INFO [org.jboss.resource.deployers.RARDeployment] (main) Required license terms exist, view vfsfile:/C:/development/tools/jboss-5.1.0.GA/server/default/deploy/jms-ra.rar/META-INF/ra.xml
2011-11-09 07:49:14,122 INFO [org.jboss.resource.deployers.RARDeployment] (main) Required license terms exist, view vfsfile:/C:/development/tools/jboss-5.1.0.GA/server/default/deploy/mail-ra.rar/META-INF/ra.xml
2011-11-09 07:49:14,200 INFO [org.jboss.resource.deployers.RARDeployment] (main) Required license terms exist, view vfsfile:/C:/development/tools/jboss-5.1.0.GA/server/default/deploy/quartz-ra.rar/META-INF/ra.xml
2011-11-09 07:49:14,294 INFO [org.quartz.simpl.SimpleThreadPool] (main) Job execution threads will use class loader of thread: main
2011-11-09 07:49:14,325 INFO [org.quartz.core.QuartzScheduler] (main) Quartz Scheduler v.1.5.2 created.
2011-11-09 07:49:14,325 INFO [org.quartz.simpl.RAMJobStore] (main) RAMJobStore initialized.
2011-11-09 07:49:14,325 INFO [org.quartz.impl.StdSchedulerFactory] (main) Quartz scheduler 'DefaultQuartzScheduler' initialized from default resource file in Quartz package: 'quartz.properties'
2011-11-09 07:49:14,325 INFO [org.quartz.impl.StdSchedulerFactory] (main) Quartz scheduler version: 1.5.2
2011-11-09 07:49:14,325 INFO [org.quartz.core.QuartzScheduler] (main) Scheduler DefaultQuartzScheduler_$_NON_CLUSTERED started.
2011-11-09 07:49:15,294 INFO [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] (main) Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DefaultDS' to JNDI name 'javaemoticonefaultDS'
2011-11-09 07:49:15,872 INFO [org.jboss.jms.server.ServerPeer] (main) JBoss Messaging 1.4.3.GA server [0] started
2011-11-09 07:49:15,950 INFO [org.jboss.jms.server.connectionfactory.ConnectionFactoryJNDIMapper] (main) supportsFailover attribute is true on connection factory: jboss.messaging.connectionfactory:service=ClusteredConnectionFactory but post office is non clustered. So connection factory will *not* support failover
2011-11-09 07:49:15,950 INFO [org.jboss.jms.server.connectionfactory.ConnectionFactoryJNDIMapper] (main) supportsLoadBalancing attribute is true on connection factory: jboss.messaging.connectionfactory:service=ClusteredConnectionFactory but post office is non clustered. So connection factory will *not* support load balancing
2011-11-09 07:49:16,013 INFO [org.jboss.jms.server.connectionfactory.ConnectionFactory] (main) Connector bisocket://127.0.0.1:4457 has leasing enabled, lease period 10000 milliseconds
2011-11-09 07:49:16,013 INFO [org.jboss.jms.server.connectionfactory.ConnectionFactory] (main) org.jboss.jms.server.connectionfactory.ConnectionFactory@a3b90a started
2011-11-09 07:49:16,013 INFO [org.jboss.jms.server.connectionfactory.ConnectionFactory] (main) Connector bisocket://127.0.0.1:4457 has leasing enabled, lease period 10000 milliseconds
2011-11-09 07:49:16,013 INFO [org.jboss.jms.server.connectionfactory.ConnectionFactory] (main) org.jboss.jms.server.connectionfactory.ConnectionFactory@908776 started
2011-11-09 07:49:16,013 INFO [org.jboss.jms.server.connectionfactory.ConnectionFactory] (main) Connector bisocket://127.0.0.1:4457 has leasing enabled, lease period 10000 milliseconds
2011-11-09 07:49:16,013 INFO [org.jboss.jms.server.connectionfactory.ConnectionFactory] (main) org.jboss.jms.server.connectionfactory.ConnectionFactory@108042a started
2011-11-09 07:49:16,028 INFO [org.jboss.jms.server.destination.QueueService] (main) Queue[/queue/DLQ] started, fullSize=200000, pageSize=2000, downCacheSize=2000
2011-11-09 07:49:16,028 INFO [org.jboss.jms.server.destination.QueueService] (main) Queue[/queue/ExpiryQueue] started, fullSize=200000, pageSize=2000, downCacheSize=2000
2011-11-09 07:49:16,091 INFO [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] (main) Bound ConnectionManager 'jboss.jca:service=ConnectionFactoryBinding,name=JmsXA' to JNDI name 'java:JmsXA'
2011-11-09 07:49:16,685 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) Created KernelDeployment for: profileservice-secured.jar
2011-11-09 07:49:16,685 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) installing bean: jboss.j2ee:jar=profileservice-secured.jar,name=SecureProfileService,service=EJB3
2011-11-09 07:49:16,685 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) with dependencies:
2011-11-09 07:49:16,685 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) and demands:
2011-11-09 07:49:16,685 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) jndi:SecureManagementView/remote-org.jboss.deployers.spi.management.ManagementView
2011-11-09 07:49:16,685 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) jboss.ejb:service=EJBTimerService
2011-11-09 07:49:16,685 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) and supplies:
2011-11-09 07:49:16,685 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) Class:org.jboss.profileservice.spi.ProfileService
2011-11-09 07:49:16,685 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) jndi:SecureProfileService/remote
2011-11-09 07:49:16,685 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) jndi:SecureProfileService/remote-org.jboss.profileservice.spi.ProfileService
2011-11-09 07:49:16,685 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) Added bean(jboss.j2ee:jar=profileservice-secured.jar,name=SecureProfileService,service=EJB3) to KernelDeployment of: profileservice-secured.jar
2011-11-09 07:49:16,700 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) installing bean: jboss.j2ee:jar=profileservice-secured.jar,name=SecureDeploymentManager,service=EJB3
2011-11-09 07:49:16,700 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) with dependencies:
2011-11-09 07:49:16,700 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) and demands:
2011-11-09 07:49:16,700 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) jboss.ejb:service=EJBTimerService
2011-11-09 07:49:16,700 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) and supplies:
2011-11-09 07:49:16,700 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) jndi:SecureDeploymentManager/remote-org.jboss.deployers.spi.management.deploy.DeploymentManager
2011-11-09 07:49:16,700 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) Class:org.jboss.deployers.spi.management.deploy.DeploymentManager
2011-11-09 07:49:16,700 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) jndi:SecureDeploymentManager/remote
2011-11-09 07:49:16,700 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) Added bean(jboss.j2ee:jar=profileservice-secured.jar,name=SecureDeploymentManager,service=EJB3) to KernelDeployment of: profileservice-secured.jar
2011-11-09 07:49:16,700 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) installing bean: jboss.j2ee:jar=profileservice-secured.jar,name=SecureManagementView,service=EJB3
2011-11-09 07:49:16,700 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) with dependencies:
2011-11-09 07:49:16,700 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) and demands:
2011-11-09 07:49:16,700 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) jboss.ejb:service=EJBTimerService
2011-11-09 07:49:16,700 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) and supplies:
2011-11-09 07:49:16,700 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) jndi:SecureManagementView/remote-org.jboss.deployers.spi.management.ManagementView
2011-11-09 07:49:16,700 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) Class:org.jboss.deployers.spi.management.ManagementView
2011-11-09 07:49:16,700 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) jndi:SecureManagementView/remote
2011-11-09 07:49:16,700 INFO [org.jboss.ejb3.deployers.JBossASKernel] (main) Added bean(jboss.j2ee:jar=profileservice-secured.jar,name=SecureManagementView,service=EJB3) to KernelDeployment of: profileservice-secured.jar
2011-11-09 07:49:16,700 INFO [org.jboss.ejb3.endpoint.deployers.EJB3EndpointDeployer] (main) Deploy AbstractBeanMetaData@8c4e0a{name=jboss.j2ee:jar=profileservice-secured.jar,name=SecureProfileService,service=EJB3_endpoint bean=org.jboss.ejb3.endpoint.deployers.impl.EndpointImpl properties= constructor=null autowireCandidate=true}
2011-11-09 07:49:16,700 INFO [org.jboss.ejb3.endpoint.deployers.EJB3EndpointDeployer] (main) Deploy AbstractBeanMetaData@fc3ac1{name=jboss.j2ee:jar=profileservice-secured.jar,name=SecureDeploymentManager,service=EJB3_endpoint bean=org.jboss.ejb3.endpoint.deployers.impl.EndpointImpl properties= constructor=null autowireCandidate=true}
2011-11-09 07:49:16,700 INFO [org.jboss.ejb3.endpoint.deployers.EJB3EndpointDeployer] (main) Deploy AbstractBeanMetaData@c01c06{name=jboss.j2ee:jar=profileservice-secured.jar,name=SecureManagementView,service=EJB3_endpoint bean=org.jboss.ejb3.endpoint.deployers.impl.EndpointImpl properties= constructor=null autowireCandidate=true}
2011-11-09 07:49:16,825 INFO [org.jboss.ejb3.session.SessionSpecContainer] (main) Starting jboss.j2ee:jar=profileservice-secured.jar,name=SecureDeploymentManager,service=EJB3
2011-11-09 07:49:16,825 INFO [org.jboss.ejb3.EJBContainer] (main) STARTED EJB: org.jboss.profileservice.ejb.SecureDeploymentManager ejbName: SecureDeploymentManager
2011-11-09 07:49:16,888 INFO [org.jboss.ejb3.proxy.impl.jndiregistrar.JndiSessionRegistrarBase] (main) Binding the following Entries in Global JNDI:

SecureDeploymentManager/remote - EJB3.x Default Remote Business Interface
SecureDeploymentManager/remote-org.jboss.deployers.spi.management.deploy.DeploymentManager - EJB3.x Remote Business Interface

2011-11-09 07:49:16,966 INFO [org.jboss.ejb3.session.SessionSpecContainer] (main) Starting jboss.j2ee:jar=profileservice-secured.jar,name=SecureManagementView,service=EJB3
2011-11-09 07:49:16,966 INFO [org.jboss.ejb3.EJBContainer] (main) STARTED EJB: org.jboss.profileservice.ejb.SecureManagementView ejbName: SecureManagementView
2011-11-09 07:49:16,966 INFO [org.jboss.ejb3.proxy.impl.jndiregistrar.JndiSessionRegistrarBase] (main) Binding the following Entries in Global JNDI:

SecureManagementView/remote - EJB3.x Default Remote Business Interface
SecureManagementView/remote-org.jboss.deployers.spi.management.ManagementView - EJB3.x Remote Business Interface

2011-11-09 07:49:17,028 INFO [org.jboss.ejb3.session.SessionSpecContainer] (main) Starting jboss.j2ee:jar=profileservice-secured.jar,name=SecureProfileService,service=EJB3
2011-11-09 07:49:17,028 INFO [org.jboss.ejb3.EJBContainer] (main) STARTED EJB: org.jboss.profileservice.ejb.SecureProfileServiceBean ejbName: SecureProfileService
2011-11-09 07:49:17,028 INFO [org.jboss.ejb3.proxy.impl.jndiregistrar.JndiSessionRegistrarBase] (main) Binding the following Entries in Global JNDI:

SecureProfileService/remote - EJB3.x Default Remote Business Interface
SecureProfileService/remote-org.jboss.profileservice.spi.ProfileService - EJB3.x Remote Business Interface

2011-11-09 07:49:17,466 INFO [org.jboss.web.tomcat.service.deployers.TomcatDeployment] (main) deploy, ctxPath=/admin-console
2011-11-09 07:49:17,591 INFO [javax.enterprise.resource.webcontainer.jsf.config] (main) Initializing Mojarra (1.2_12-b01-FCS) for context '/admin-console'
2011-11-09 07:49:20,185 INFO [org.jboss.web.tomcat.service.deployers.TomcatDeployment] (main) deploy, ctxPath=/
2011-11-09 07:49:21,622 INFO [com.liferay.portal.kernel.util.ServerDetector] (main) Detected server jboss
2011-11-09 07:49:21,825 INFO [org.apache.catalina.core.ContainerBase.[jboss.web]..[/]] (main) Initializing Spring root WebApplicationContext
2011-11-09 07:49:27,762 INFO [com.liferay.portal.spring.hibernate.DialectDetector] (main) Determining dialect for PostgreSQL 8
2011-11-09 07:49:27,841 INFO [com.liferay.portal.spring.hibernate.DialectDetector] (main) Using dialect org.hibernate.dialect.PostgreSQLDialect
2011-11-09 07:49:34,465 INFO [com.liferay.portal.util.PortalImpl] (main) Global lib directory
2011-11-09 07:49:34,465 INFO [com.liferay.portal.util.PortalImpl] (main) Portal lib directory /C:/development/tools/jboss-5.1.0.GA/server/default/deploy/ROOT.war/WEB-INF/lib/
2011-11-09 07:50:05,590 ERROR [org.hibernate.util.JDBCExceptionReporter] (main) ERROR: relation "lock_" does not exist
2011-11-09 07:50:07,668 INFO [com.liferay.portal.dao.db.BaseDB] (main) Database supports case sensitive queries
2011-11-09 07:50:07,699 INFO [com.liferay.portal.kernel.upgrade.UpgradeProcess] (main) Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_0_0
2011-11-09 07:50:07,715 INFO [com.liferay.portal.kernel.upgrade.UpgradeProcess] (main) Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeSchema
2011-11-09 07:50:18,542 INFO [com.liferay.portal.kernel.upgrade.UpgradeProcess] (main) Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeAsset
2011-11-09 07:50:23,667 INFO [com.liferay.portal.kernel.upgrade.UpgradeProcess] (main) Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeAssetPublisher
2011-11-09 07:50:24,917 INFO [com.liferay.portal.kernel.upgrade.UpgradeProcess] (main) Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeBlogs
2011-11-09 07:50:24,948 INFO [com.liferay.portal.upgrade.util.Table] (main) Starting backup of BlogsEntry to C:\DOCUME~1\ADM-20~1\LOCALS~1\Temp\/temp-db-BlogsEntry-1320825024948
2011-11-09 07:50:25,761 INFO [com.liferay.portal.upgrade.util.Table] (main) Finished backup of BlogsEntry to C:\DOCUME~1\ADM-20~1\LOCALS~1\Temp\/temp-db-BlogsEntry-1320825024948 in 813 ms
2011-11-09 07:50:25,808 INFO [com.liferay.portal.kernel.upgrade.UpgradeProcess] (main) Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeDocumentLibrary
2011-11-09 07:50:31,355 INFO [com.liferay.portal.upgrade.util.Table] (main) Starting backup of DLFileEntry to C:\DOCUME~1\ADM-20~1\LOCALS~1\Temp\/temp-db-DLFileEntry-1320825031355
2011-11-09 07:50:35,729 INFO [com.liferay.portal.upgrade.util.Table] (main) Finished backup of DLFileEntry to C:\DOCUME~1\ADM-20~1\LOCALS~1\Temp\/temp-db-DLFileEntry-1320825031355 in 4374 ms
2011-11-09 07:50:36,620 INFO [com.liferay.portal.upgrade.util.Table] (main) Starting backup of DLFileRank to C:\DOCUME~1\ADM-20~1\LOCALS~1\Temp\/temp-db-DLFileRank-1320825036620
2011-11-09 07:50:36,620 INFO [com.liferay.portal.upgrade.util.Table] (main) Finished backup of DLFileRank to C:\DOCUME~1\ADM-20~1\LOCALS~1\Temp\/temp-db-DLFileRank-1320825036620 in 0 ms
2011-11-09 07:50:36,729 INFO [com.liferay.portal.upgrade.util.Table] (main) Starting backup of DLFileShortcut to C:\DOCUME~1\ADM-20~1\LOCALS~1\Temp\/temp-db-DLFileShortcut-1320825036729
2011-11-09 07:50:36,745 INFO [com.liferay.portal.upgrade.util.Table] (main) Finished backup of DLFileShortcut to C:\DOCUME~1\ADM-20~1\LOCALS~1\Temp\/temp-db-DLFileShortcut-1320825036729 in 16 ms
2011-11-09 07:50:36,761 INFO [com.liferay.portal.upgrade.util.Table] (main) Starting backup of DLFileVersion to C:\DOCUME~1\ADM-20~1\LOCALS~1\Temp\/temp-db-DLFileVersion-1320825036761
2011-11-09 07:50:36,979 INFO [com.liferay.portal.upgrade.util.Table] (main) Finished backup of DLFileVersion to C:\DOCUME~1\ADM-20~1\LOCALS~1\Temp\/temp-db-DLFileVersion-1320825036761 in 218 ms
2011-11-09 07:50:37,479 INFO [com.liferay.portal.kernel.upgrade.UpgradeProcess] (main) Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeExpando
2011-11-09 07:50:37,667 INFO [com.liferay.portal.kernel.upgrade.UpgradeProcess] (main) Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeGroup
2011-11-09 07:50:37,933 INFO [com.liferay.portal.kernel.upgrade.UpgradeProcess] (main) Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeJournal
2011-11-09 07:50:38,292 INFO [com.liferay.portal.kernel.upgrade.UpgradeProcess] (main) Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradePolls
2011-11-09 07:50:38,495 INFO [com.liferay.portal.kernel.upgrade.UpgradeProcess] (main) Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradePortletId
2011-11-09 07:50:38,729 INFO [com.liferay.portal.kernel.upgrade.UpgradeProcess] (main) Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeResourceAction
2011-11-09 07:50:38,807 INFO [com.liferay.portal.kernel.upgrade.UpgradeProcess] (main) Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeShopping
2011-11-09 07:50:38,995 INFO [com.liferay.portal.kernel.upgrade.UpgradeProcess] (main) Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeSocial
2011-11-09 07:50:39,761 INFO [com.liferay.portal.upgrade.util.Table] (main) Starting backup of SocialActivity to C:\DOCUME~1\ADM-20~1\LOCALS~1\Temp\/temp-db-SocialActivity-1320825039761
2011-11-09 07:50:39,792 INFO [com.liferay.portal.upgrade.util.Table] (main) Finished backup of SocialActivity to C:\DOCUME~1\ADM-20~1\LOCALS~1\Temp\/temp-db-SocialActivity-1320825039761 in 31 ms
2011-11-09 07:50:40,386 INFO [com.liferay.portal.upgrade.util.Table] (main) Starting backup of SocialRelation to C:\DOCUME~1\ADM-20~1\LOCALS~1\Temp\/temp-db-SocialRelation-1320825040386
2011-11-09 07:50:40,417 INFO [com.liferay.portal.upgrade.util.Table] (main) Finished backup of SocialRelation to C:\DOCUME~1\ADM-20~1\LOCALS~1\Temp\/temp-db-SocialRelation-1320825040386 in 31 ms
2011-11-09 07:50:40,479 INFO [com.liferay.portal.upgrade.util.Table] (main) Starting backup of SocialRequest to C:\DOCUME~1\ADM-20~1\LOCALS~1\Temp\/temp-db-SocialRequest-1320825040479
2011-11-09 07:50:40,479 INFO [com.liferay.portal.upgrade.util.Table] (main) Finished backup of SocialRequest to C:\DOCUME~1\ADM-20~1\LOCALS~1\Temp\/temp-db-SocialRequest-1320825040479 in 0 ms
2011-11-09 07:50:40,511 INFO [com.liferay.portal.kernel.upgrade.UpgradeProcess] (main) Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeWiki
2011-11-09 07:50:40,698 INFO [com.liferay.portal.kernel.upgrade.UpgradeProcess] (main) Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_0_1
2011-11-09 07:50:40,698 INFO [com.liferay.portal.kernel.upgrade.UpgradeProcess] (main) Upgrading com.liferay.portal.upgrade.v6_0_1.UpgradeSchema
2011-11-09 07:50:40,729 INFO [com.liferay.portal.kernel.upgrade.UpgradeProcess] (main) Upgrading com.liferay.portal.upgrade.v6_0_1.UpgradeDocumentLibrary
2011-11-09 07:50:40,964 INFO [com.liferay.portal.kernel.upgrade.UpgradeProcess] (main) Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_0_2
2011-11-09 07:50:40,979 INFO [com.liferay.portal.kernel.upgrade.UpgradeProcess] (main) Upgrading com.liferay.portal.upgrade.v6_0_2.UpgradeSchema
2011-11-09 07:50:41,307 INFO [com.liferay.portal.kernel.upgrade.UpgradeProcess] (main) Upgrading com.liferay.portal.upgrade.v6_0_2.UpgradeExpando
2011-11-09 07:50:41,323 INFO [com.liferay.portal.kernel.upgrade.UpgradeProcess] (main) Upgrading com.liferay.portal.upgrade.v6_0_2.UpgradeNestedPortlets
2011-11-09 07:50:41,526 INFO [com.liferay.portal.kernel.upgrade.UpgradeProcess] (main) Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_0_3
2011-11-09 07:50:41,542 INFO [com.liferay.portal.kernel.upgrade.UpgradeProcess] (main) Upgrading com.liferay.portal.upgrade.v6_0_3.UpgradeSchema
2011-11-09 07:50:43,198 WARN [com.liferay.portal.dao.db.BaseDB] (main) ERROR: column "minsymbols" of relation "passwordpolicy" already exists: alter table PasswordPolicy add minSymbols INTEGER;
2011-11-09 07:50:43,260 INFO [com.liferay.portal.kernel.upgrade.UpgradeProcess] (main) Upgrading com.liferay.portal.upgrade.v6_0_3.UpgradeAsset
2011-11-09 07:50:54,541 INFO [com.liferay.portal.kernel.upgrade.UpgradeProcess] (main) Upgrading com.liferay.portal.upgrade.v6_0_3.UpgradeAssetPublisher
2011-11-09 07:50:54,760 INFO [com.liferay.portal.kernel.upgrade.UpgradeProcess] (main) Upgrading com.liferay.portal.upgrade.v6_0_3.UpgradeDocumentLibrary
2011-11-09 07:51:09,775 INFO [com.liferay.portal.kernel.upgrade.UpgradeProcess] (main) Upgrading com.liferay.portal.upgrade.v6_0_3.UpgradeLookAndFeel
2011-11-09 07:51:09,775 INFO [com.liferay.portal.kernel.upgrade.UpgradeProcess] (main) Upgrading com.liferay.portal.upgrade.v6_0_3.UpgradePermission
2011-11-09 07:51:10,010 INFO [com.liferay.portal.kernel.upgrade.UpgradeProcess] (main) Upgrading com.liferay.portal.upgrade.v6_0_3.UpgradeScopes
2011-11-09 07:51:13,010 INFO [com.liferay.portal.kernel.upgrade.UpgradeProcess] (main) Upgrading com.liferay.portal.upgrade.v6_0_3.UpgradeSitemap
2011-11-09 07:51:13,275 INFO [com.liferay.portal.kernel.upgrade.UpgradeProcess] (main) Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_0_5
2011-11-09 07:51:13,275 INFO [com.liferay.portal.kernel.upgrade.UpgradeProcess] (main) Upgrading com.liferay.portal.upgrade.v6_0_5.UpgradeSchema
2011-11-09 07:51:13,291 INFO [com.liferay.portal.kernel.upgrade.UpgradeProcess] (main) Upgrading com.liferay.portal.upgrade.v6_0_5.UpgradeJournal
2011-11-09 07:51:13,619 INFO [com.liferay.portal.kernel.upgrade.UpgradeProcess] (main) Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_0_6
2011-11-09 07:51:13,728 INFO [com.liferay.portal.kernel.upgrade.UpgradeProcess] (main) Upgrading com.liferay.portal.upgrade.v6_0_6.UpgradeSchema
2011-11-09 07:51:13,744 INFO [com.liferay.portal.kernel.upgrade.UpgradeProcess] (main) Upgrading com.liferay.portal.upgrade.v6_0_6.UpgradeRSS
2011-11-09 07:51:14,775 INFO [com.liferay.portal.verify.VerifyProcess] (main) Verifying com.liferay.portal.verify.VerifyProcessSuite
2011-11-09 07:51:14,775 INFO [com.liferay.portal.verify.VerifyProcess] (main) Verifying com.liferay.portal.verify.VerifyProperties
2011-11-09 07:51:14,775 INFO [com.liferay.portal.verify.VerifyProcess] (main) Verifying com.liferay.portal.verify.VerifyMySQL
2011-11-09 07:51:14,775 INFO [com.liferay.portal.verify.VerifyProcess] (main) Verifying com.liferay.portal.verify.VerifyCounter
2011-11-09 07:51:15,088 INFO [com.liferay.portal.verify.VerifyProcess] (main) Verifying com.liferay.portal.verify.VerifyUUID
2011-11-09 07:51:15,369 ERROR [com.liferay.portal.scheduler.messaging.SchedulerMessageListener] (liferay/scheduler_engine) Unable to process message {destinationName=liferay/scheduler_engine, responseDestinationName=null, responseId=null, payload=com.liferay.portal.kernel.scheduler.messaging.SchedulerRequest@6f526f, values=null}
com.liferay.portal.kernel.scheduler.SchedulerException: Unable to start scheduler
at com.liferay.portal.scheduler.quartz.QuartzSchedulerEngineImpl.start(QuartzSchedulerEngineImpl.java:276)
at com.liferay.portal.scheduler.messaging.SchedulerMessageListener.doReceive(SchedulerMessageListener.java:85)
at com.liferay.portal.scheduler.messaging.SchedulerMessageListener.receive(SchedulerMessageListener.java:50)
at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:63)
at com.liferay.portal.kernel.messaging.ParallelDestination$1.run(ParallelDestination.java:61)
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:722)
Caused by: org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't store trigger '7898b0d2-85d8-48d3-bfa8-22721150f6a9' for '7898b0d2-85d8-48d3-bfa8-22721150f6a9' job:invalid stream header: 230A2346 [See nested exception: java.io.StreamCorruptedException: invalid stream header: 230A2346]]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:623)
at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:466)
at org.quartz.impl.StdScheduler.start(StdScheduler.java:143)
at com.liferay.portal.scheduler.quartz.QuartzSchedulerEngineImpl.start(QuartzSchedulerEngineImpl.java:273)
... 7 more
Caused by: org.quartz.JobPersistenceException: Couldn't store trigger '7898b0d2-85d8-48d3-bfa8-22721150f6a9' for '7898b0d2-85d8-48d3-bfa8-22721150f6a9' job:invalid stream header: 230A2346 [See nested exception: java.io.StreamCorruptedException: invalid stream header: 230A2346]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeTrigger(JobStoreSupport.java:1241)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.doUpdateOfMisfiredTrigger(JobStoreSupport.java:1009)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverMisfiredJobs(JobStoreSupport.java:953)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:830)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$2.execute(JobStoreSupport.java:802)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$41.execute(JobStoreSupport.java:3708)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3742)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3704)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:798)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:621)
... 10 more
Caused by: java.io.StreamCorruptedException: invalid stream header: 230A2346
at java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:801)
at java.io.ObjectInputStream.<init>(ObjectInputStream.java:298)
at org.quartz.impl.jdbcjobstore.PostgreSQLDelegate.getObjectFromBlob(PostgreSQLDelegate.java:99)
at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectJobDetail(StdJDBCDelegate.java:904)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeTrigger(JobStoreSupport.java:1197)
... 19 more
2011-11-09 07:51:17,869 INFO [com.liferay.portal.verify.VerifyProcess] (main) Verifying com.liferay.portal.verify.VerifyRole
2011-11-09 07:51:18,181 INFO [com.liferay.portal.verify.VerifyProcess] (main) Verifying com.liferay.portal.verify.VerifyBlogs
2011-11-09 07:51:18,197 INFO [com.liferay.portal.verify.VerifyProcess] (main) Verifying com.liferay.portal.verify.VerifyBookmarks
2011-11-09 07:51:18,228 INFO [com.liferay.portal.verify.VerifyProcess] (main) Verifying com.liferay.portal.verify.VerifyCalendar
2011-11-09 07:51:18,431 INFO [com.liferay.portal.verify.VerifyProcess] (main) Verifying com.liferay.portal.verify.VerifyDocumentLibrary
2011-11-09 07:51:18,463 INFO [com.liferay.portal.verify.VerifyProcess] (main) Verifying com.liferay.portal.verify.VerifyGroup
2011-11-09 07:51:19,463 INFO [com.liferay.portal.verify.VerifyProcess] (main) Verifying com.liferay.portal.verify.VerifyImageGallery
2011-11-09 07:51:19,463 INFO [com.liferay.portal.verify.VerifyProcess] (main) Verifying com.liferay.portal.verify.VerifyJournal
2011-11-09 07:51:19,556 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.JournalStructure#DELETE
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.JournalStructure#DELETE
at com.liferay.portal.events.StartupAction.run(StartupAction.java:53)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1166)
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:1048)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:950)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4122)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4421)
at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeployInternal(TomcatDeployment.java:310)
at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeploy(TomcatDeployment.java:142)
at org.jboss.web.deployers.AbstractWarDeployment.start(AbstractWarDeployment.java:461)
at org.jboss.web.deployers.WebModule.startModule(WebModule.java:118)
at org.jboss.web.deployers.WebModule.start(WebModule.java:97)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:668)
at org.jboss.system.microcontainer.ServiceProxy.invoke(ServiceProxy.java:206)
at $Proxy38.start(Unknown Source)
at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:42)
at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:37)
at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)
at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)
at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)
at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
at org.jboss.system.microcontainer.ServiceControllerContext.install(ServiceControllerContext.java:286)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1631)
at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
at org.jboss.system.ServiceController.doChange(ServiceController.java:688)
at org.jboss.system.ServiceController.start(ServiceController.java:460)
at org.jboss.system.deployers.ServiceDeployer.start(ServiceDeployer.java:163)
at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:99)
at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:46)
at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62)
at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:50)
at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:171)
at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1439)
at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1157)
at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1178)
at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1098)
at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1631)
at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:781)
at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:702)
at org.jboss.system.server.profileservice.repository.MainDeployerAdapter.process(MainDeployerAdapter.java:117)
at org.jboss.system.server.profileservice.repository.ProfileDeployAction.install(ProfileDeployAction.java:70)
at org.jboss.system.server.profileservice.repository.AbstractProfileAction.install(AbstractProfileAction.java:53)
at org.jboss.system.server.profileservice.repository.AbstractProfileService.install(AbstractProfileService.java:361)
at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1631)
at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
at org.jboss.system.server.profileservice.repository.AbstractProfileService.activateProfile(AbstractProfileService.java:306)
at org.jboss.system.server.profileservice.ProfileServiceBootstrap.start(ProfileServiceBootstrap.java:271)
at org.jboss.bootstrap.AbstractServerImpl.start(AbstractServerImpl.java:461)
at org.jboss.Main.boot(Main.java:221)
at org.jboss.Main$1.run(Main.java:556)
at java.lang.Thread.run(Thread.java:722)
Caused by: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: com.liferay.portal.NoSuchResourceActionException: com.liferay.portlet.journal.model.JournalStructure#DELETE
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:82)
at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:101)
at com.liferay.portal.verify.VerifyProcessUtil.verifyProcess(VerifyProcessUtil.java:66)
at com.liferay.portal.events.StartupHelper.verifyProcess(StartupHelper.java:79)
at com.liferay.portal.events.StartupHelperUtil.verifyProcess(StartupHelperUtil.java:44)
at com.liferay.portal.tools.DBUpgrader.verify(DBUpgrader.java:158)
at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:153)
at com.liferay.portal.events.StartupAction.run(StartupAction.java:47)
... 74 more
Caused by: com.liferay.portal.verify.VerifyException: com.liferay.portal.NoSuchResourceActionException: com.liferay.portlet.journal.model.JournalStructure#DELETE
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:82)
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:89)
at com.liferay.portal.verify.VerifyProcessSuite.doVerify(VerifyProcessSuite.java:38)
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:79)
... 81 more
Caused by: com.liferay.portal.NoSuchResourceActionException: com.liferay.portlet.journal.model.JournalStructure#DELETE
at com.liferay.portal.service.impl.ResourceActionLocalServiceImpl.getResourceAction(ResourceActionLocalServiceImpl.java:80)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:82)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at $Proxy381.getResourceAction(Unknown Source)
at com.liferay.portal.service.impl.ResourcePermissionLocalServiceImpl.doUpdateResourcePermission(ResourcePermissionLocalServiceImpl.java:375)
at com.liferay.portal.service.impl.ResourcePermissionLocalServiceImpl.updateResourcePermission(ResourcePermissionLocalServiceImpl.java:415)
at com.liferay.portal.service.impl.ResourcePermissionLocalServiceImpl.setResourcePermissions(ResourcePermissionLocalServiceImpl.java:329)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:82)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at $Proxy383.setResourcePermissions(Unknown Source)
at com.liferay.portal.service.impl.ResourceLocalServiceImpl.addResources_6(ResourceLocalServiceImpl.java:781)
at com.liferay.portal.service.impl.ResourceLocalServiceImpl.addResources(ResourceLocalServiceImpl.java:192)
at com.liferay.portal.service.impl.ResourceLocalServiceImpl.addResources(ResourceLocalServiceImpl.java:151)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:82)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at $Proxy379.addResources(Unknown Source)
at com.liferay.portal.service.ResourceLocalServiceUtil.addResources(ResourceLocalServiceUtil.java:268)
at com.liferay.portal.verify.VerifyJournal.doVerify(VerifyJournal.java:57)
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:79)
... 84 more
2011-11-09 07:51:19,666 INFO [org.jboss.bootstrap.microcontainer.ServerImpl] (JBoss Shutdown Hook) Runtime shutdown hook called, forceHalt: true
2011-11-09 07:51:19,666 WARN [org.jboss.system.server.profileservice.ProfileServiceBootstrap] (JBoss Shutdown Hook) Error deactivating profile: ProfileKey@9527ee
org.jboss.profileservice.spi.NoSuchProfileException: No active profile for: ProfileKey@9527ee
at org.jboss.system.server.profileservice.repository.AbstractProfileService.deactivateProfile(AbstractProfileService.java:391)
at org.jboss.system.server.profileservice.ProfileServiceBootstrap.shutdown(ProfileServiceBootstrap.java:327)
at org.jboss.bootstrap.AbstractServerImpl.shutdownServer(AbstractServerImpl.java:571)
at org.jboss.bootstrap.AbstractServerImpl$ShutdownHook.run(AbstractServerImpl.java:909)
2011-11-09 07:51:20,088 INFO [org.jboss.web.tomcat.service.deployers.TomcatDeployment] (JBoss Shutdown Hook) undeploy, ctxPath=/web-console
2011-11-09 07:51:20,088 INFO [org.jboss.web.tomcat.service.deployers.TomcatDeployment] (JBoss Shutdown Hook) undeploy, ctxPath=/invoker
2011-11-09 07:51:20,088 INFO [org.jboss.web.tomcat.service.deployers.TomcatDeployment] (JBoss Shutdown Hook) undeploy, ctxPath=/jbossws
2011-11-09 07:51:20,103 INFO [org.jboss.web.tomcat.service.deployers.TomcatDeployment] (JBoss Shutdown Hook) undeploy, ctxPath=/admin-console
2011-11-09 07:51:20,103 INFO [org.apache.catalina.core.StandardService] (JBoss Shutdown Hook) Arr�t du service jboss.web


Any idea?
Mua Dibh
RE: Upgrade 5.2.3 to 6.0.5
March 28, 2013 5:22 AM
Answer

Mua Dibh

Rank: New Member

Posts: 2

Join Date: February 11, 2009

Recent Posts

Since I never saw a solution in the forums I like to add the following:

The root cause of the MySQLIntegrityConstraintViolationException is that the database has not been properly reset from a previous unsuccessful upgrade attempt.

So it helps to drop and create the database before restoring the mysqldump file of the 5.2.3 database and attempting another update.

Hope that helps other poor souls like me instead of having to learn this the hard way ...
Andy Liao
RE: Upgrade 5.2.3 to 6.0.5
November 10, 2013 6:54 AM
Answer

Andy Liao

Rank: New Member

Posts: 1

Join Date: November 10, 2013

Recent Posts

I have been having issue upgrading.
Then I started with a clean MySQL db from 5.2.3 and follow the instruction here. The upgrade to 6.0.0 finally succeeded. emoticon
====
n fact the upgrade process from the 5.2.3 to 6.0.x (personnaly, I did directly from 5.2.3 to 6.0.6 and it works) is :

0) Install a liferay 6.0.6 "out of the box".
Set the pointed db so as to be a restore of your current liferay 5.2.3 db
Set the /data directory so as to be the same that your current liferay 5.2.3 data

1)
Under linux append in file setenv.sh (in tomcat/bin) to variable JVM_OPTS the value
1-Dexternal-properties=portal-legacy-5.2.properties


Same under windows but in file setenv.bat.

Normally, this extra option is taken into account when you start liferay and all db patches are applied successfully (i.e. cf. logs for no big stack trace errors), otherwise be sure that this extra option is taken into account if you have big stack trace errors.

Thanks to this option, all additional properties that should be in portal-ext.properties are taken into account without modifying this file by hand.
More info here :
http://www.liferay.com/community/wiki/-/wiki/Main/Upgrade+Instructions+from+5.2+to+6.0

2)
Like this topic says : http://www.liferay.com/community/forums/-/message_boards/message/6493162
Apply a patch to liferay 6.0.6 source code (you can download it easily through official liferay download site on sourceforge).
This path is available for download to this corresponding solved issue : http://issues.liferay.com/browse/LPS-12109
After application, just remplace the built portal-impl.jar with the one in tomcat/webapps/ROOT/WEB-INF/lib

3) Empty tomcat/logs, tomcat/temp and tomcat/work.

4) Start liferay and it should work.

This step are ok for an upgrade of liferay 523 OTB to 60x OTB, but probably, custom theme or portlets become obsolete and should be recompiled/rearrange with liferay 60x sdk (updated librairies used as plugin dependencies, etc.)
====