Upgrade Liferay 5.2.3 -> 6.0.3

[Leon Schaeps, geändert vor 13 Jahren.]

I want to update from Liferay 5.2.3 to Liferay 6.0.3
For this upgrade I changed the portal-ext.properties to

permissions.user.check.algorithm=5
image.hook.impl=com.liferay.portal.image.DatabaseHook

The upgrade results in an Duplicate entry error within:
Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeDocumentLibrary

08:35:52,169 ERROR [JDBCExceptionReporter:101] Table 'lportal6.lock_' doesn't exist
08:35:53,092 INFO [BaseDB:393] Database does not support case sensitive queries
08:35:53,109 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_0_0
08:35:53,110 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeSchema
08:37:59,743 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeAsset
08:41:34,656 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeAssetPublisher
08:41:42,203 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeBlogs
08:41:42,233 INFO [Table:371] Starting backup of BlogsEntry to C:\ontwikkel\liferay-portal-6.0.3\tomcat-6.0.26/temp/temp-db-BlogsEntry-1279528902232
08:41:43,329 INFO [Table:407] Finished backup of BlogsEntry to C:\ontwikkel\liferay-portal-6.0.3\tomcat-6.0.26/temp/temp-db-BlogsEntry-1279528902232 in 1096 ms
08:41:51,110 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeDocumentLibrary
08:41:55,995 ERROR [MainServlet:196] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '24814-DLFE-1752.doc-1' for key 'IX_6C5E6512'
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '24814-DLFE-1752.doc-1' for key 'IX_6C5E6512'
at com.liferay.portal.events.StartupAction.run(StartupAction.java:53)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1159)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:193)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4187)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4496)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.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:592)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '24814-DLFE-1752.doc-1' for key 'IX_6C5E6512'
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:114)
at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:80)
at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:37)
at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:73)
at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.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.MySQLIntegrityConstraintViolationException: Duplicate entry '24814-DLFE-1752.doc-1' for key 'IX_6C5E6512'
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:114)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:130)
at com.liferay.portal.upgrade.UpgradeProcess_6_0_0.doUpgrade(UpgradeProcess_6_0_0.java:48)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:111)
... 36 more
Caused by: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '24814-DLFE-1752.doc-1' for key 'IX_6C5E6512'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1585)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1500)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1485)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at com.liferay.portal.upgrade.v6_0_0.UpgradeDocumentLibrary.addFileVersion(UpgradeDocumentLibrary.java:86)
at com.liferay.portal.upgrade.v6_0_0.UpgradeDocumentLibrary.doUpgrade(UpgradeDocumentLibrary.java:133)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:111)
... 39 more


Any idea?

Kind regards,

Leon

[Marek Wianecki, geändert vor 13 Jahren.]

well, I have put image.hook.impl=com.liferay.portal.image.DatabaseHook to portal-ext.properties after upgrade and images work fine. Maybe try this:
1. permissions.user.check.algorithm=5
2. upgrade
3. #permissions.user.check.algorithm=5
4. image.hook.impl=com.liferay.portal.image.DatabaseHook
5. test

[Leon Schaeps, geändert vor 13 Jahren.]

Marek Wianecki:

well, I have put image.hook.impl=com.liferay.portal.image.DatabaseHook to portal-ext.properties after upgrade and images work fine. Maybe try this:
1. permissions.user.check.algorithm=5
2. upgrade
3. #permissions.user.check.algorithm=5
4. image.hook.impl=com.liferay.portal.image.DatabaseHook
5. test

Thanks for your answer, but I already tried that.

[Marek Wianecki, geändert vor 13 Jahren.]

it worked ? if not, do you have the same exception ? for me Your exception looks like You have upgraded, upgrade failed and you try to run it again. I dont know if it would work this way but when I had similar exception I did database recovery to the version before upgrade and then I've tried these steps ...

[Leon Schaeps, geändert vor 13 Jahren.]

Marek Wianecki:

it worked ? if not, do you have the same exception ? for me Your exception looks like You have upgraded, upgrade failed and you try to run it again. I dont know if it would work this way but when I had similar exception I did database recovery to the version before upgrade and then I've tried these steps ...

Hi,

Not successfully so far
When the upgrade fails I allways restart with a fresh import. So i don't run it again.
When I run it again, the number of errors is very huge.
After the failure I decided to delete the Document Library content and do a new import.
But that import resulted in a new failure:

http://issues.liferay.com/browse/LPS-11365

After I manually fixed the portal-impl.jar the update, without DL-entries, runs ok.
But the site crashes with an null pointer exception.

Looks like the upgrade scenario hasn't be tested very well.

Kind regards,

Leon

[JR Houn, geändert vor 13 Jahren.]

Since it looks like your upgrade is failing on document library you may need to configure liferay portal 6 to use the proper document library hook that your previous installation was using see this section in the 6.0.3 portal-ext.properties:


##
## Document Library Portlet
##

#
# Set the name of a class that implements
# com.liferay.documentlibrary.util.Hook. The
# document library server will use this persist documents.
#
#dl.hook.impl=com.liferay.documentlibrary.util.AdvancedFileSystemHook
#dl.hook.impl=com.liferay.documentlibrary.util.CMISHook
dl.hook.impl=com.liferay.documentlibrary.util.FileSystemHook
#dl.hook.impl=com.liferay.documentlibrary.util.JCRHook
#dl.hook.impl=com.liferay.documentlibrary.util.S3Hook

#
# FileSystemHook
#
dl.hook.file.system.root.dir=${liferay.home}/data/document_library

#
# JCRHook
#
dl.hook.jcr.fetch.delay=500
dl.hook.jcr.fetch.max.failures=5

#
# S3Hook
#
dl.hook.s3.access.key=
dl.hook.s3.secret.key=
dl.hook.s3.bucket.name=

#
# S3Hook
#
dl.hook.s3.access.key=
dl.hook.s3.secret.key=
dl.hook.s3.bucket.name=


The settings you enter for the 6.0.3 portal-ext.properties installation should match the same document library hook that your 5.2.3 installation used.

-jr

[Leon Schaeps, geändert vor 13 Jahren.]

Hi JR,

My portal-ext.properties:

jdbc.default.driverClassName=com.mysql.jdbc.Driver
jdbc.default.url=jdbc:mysql://localhost/lportal6?useUnicode=true&characterEncoding=UTF-8&
useFastDateParsing=false
jdbc.default.username=root
jdbc.default.password=admin
com.liferay.portal.servlet.filters.gzip.GZipFilter=false
com.liferay.portal.servlet.filters.header.HeaderFilter=true
axis.servlet.hosts.allowed=127.0.0.1
axis.servlet.https.required=false


permissions.user.check.algorithm=5
image.hook.impl=com.liferay.portal.image.DatabaseHook


We started at Liferay 5.2.3 so this should be fine, I think.

Still very strange to get an duplicate key entry while updating a database.

Kind regards,

Leon

[Bryan Nylander, geändert vor 13 Jahren.]

I am also attempting to upgrade liferay CE addition from 5.2.3 -> 6.0.3 and receiving a similar error condition but in a different location and infrastructure.

App server Linux. DB Server Oracle 10.

Im willing to post all the errors however the log output to the catalina.out is very long.

For my upgrade, I opened a copy of the liferay6.0.3 under a bundle directory and pointed a symbolic link called current from the 5.2.3 to the 6.0.3 directory. I copied over the portal-ext.properties to the new 6.0.3 directory as well as move over a copy of ojdbc6.jar to the new tomcat-6.0.26/lib so that the OJDB jar will be found within the path.

When running the startup.sh script under the new tomcat-6.0.26/bin I get sever errors which do not seam to sync up.

Here is a copy of what I have defined within the protal-ext.properties file

=================================================
jdbc.default.jndi.name=jdbc/LiferayPool
jdbc.default.driverClassName=oracle.jdbc.driver.OracleDriver
jdbc.default.url=jdbc:oracle:thin:@server1.maximus.com:1000:LIFERAY
jdbc.default.username=liferay
jdbc.default.password=LIFERAY

# Mail server configuration
mail.session.mail.pop3.host=localhost
mail.session.mail.pop3.password=
mail.session.mail.pop3.port=110
mail.session.mail.pop3.user=
mail.session.mail.smtp.auth=false
mail.session.mail.smtp.host=localhost
mail.session.mail.smtp.password=
mail.session.mail.smtp.port=25

# Remove Chat option at the bottom of all pages
layout.static.portlets.all=
=================================================


First set of errors I see is:
=================================================
Loading jar:file:/u01/maximus/liferay-dev/bundle/liferay-portal-6.0.3/tomcat-6.0.26/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/system.properties
Loading jar:file:/u01/maximus/liferay-dev/bundle/liferay-portal-6.0.3/tomcat-6.0.26/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/portal.properties
Loading file:/u01/maximus/liferay-dev/bundle/current/portal-ext.properties
17:16:39,500 ERROR [DataSourceFactoryBean:74] Unable to lookup jdbc/LiferayPool
javax.naming.NameNotFoundException: Name jdbc is not bound in this Context
at org.apache.naming.NamingContext.lookup(NamingContext.java:770)
at org.apache.naming.NamingContext.lookup(NamingContext.java:140)
at org.apache.naming.NamingContext.lookup(NamingContext.java:781)
=================================================

This indicates that jdbc/LiferayPool could not be found. The log files continue with 30 or so pages worth of stack traces shown below.

=================================================
17:17:00,073 WARN [DriverManagerDataSource:107] Could not load driverClass oracle.jdbc.driver.OracleDriver
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1516)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1361)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded(DriverManagerDataSource.java:100)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:132)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:148)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)

=================================================

This would seam to be a driver location issue until the following errors are shown further in the log file

=================================================
17:17:58,557 INFO [HotDeployUtil:62] Initializing hot deploy manager 16785420
Jul 19, 2010 5:17:58 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [Dispatch-Thread-for-com.mchange.v2.async.ThreadPerTaskAsynchronousRunner@1473a2e] but has failed to stop it. This is very likely to create a memory leak.
Jul 19, 2010 5:17:58 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [Task-Thread-for-com.mchange.v2.async.ThreadPerTaskAsynchronousRunner@1473a2e] but has failed to stop it. This is very likely to create a memory leak.
Jul 19, 2010 5:17:58 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [Task-Thread-for-com.mchange.v2.async.ThreadPerTaskAsynchronousRunner@1473a2e] but has failed to stop it. This is very likely to create a memory leak.
=================================================

Further in the catalina.out log file I see a shift within the logging where it appears that an Update to the Schema starts. What is strange is that after a dump of the DML is presented, We see ORA errors which looks like an Oracle version of the issue reported on this thread.

=================================================
Starting Liferay Portal Community Edition 6.0.3 CE (Bunyan / Build 6003 / July 15, 2010)
17:19:46,468 INFO [BaseDB:390] Database supports case sensitive queries
17:19:46,492 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_0_0
17:19:46,495 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeSchema
17:19:46,537 WARN [BaseDB:366] ORA-00955: name is already used by an existing object: 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);
17:19:46,552 WARN [BaseDB:366] ORA-00955: name is already used by an existing object: 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);
17:19:46,564 WARN [BaseDB:366] ORA-00955: name is already used by an existing object: create table AssetEntries_AssetCategories ( entryId LONG not null, categoryId LONG not null, primary key (entryId, categoryId));
17:19:46,579 WARN [BaseDB:366] ORA-00955: name is already used by an existing object: create table AssetEntries_AssetTags ( entryId LONG not null, tagId LONG not null, primary key (entryId, tagId));
17:19:46,606 WARN [BaseDB:366] ORA-00955: name is already used by an existing object: 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);
17:19:46,617 WARN [BaseDB:366] ORA-00955: name is already used by an existing object: 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);
17:19:46,626 WARN [BaseDB:366] ORA-00955: name is already used by an existing object: 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);
17:19:46,634 WARN [BaseDB:366] ORA-00955: name is already used by an existing object: create table AssetTagStats ( tagStatsId LONG not null primary key, tagId LONG, classNameId LONG, assetCount INTEGER);
17:19:46,642 WARN [BaseDB:366] ORA-00955: name is already used by an existing object: 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);
17:19:46,650 WARN [BaseDB:366] ORA-01430: column being added already exists in table: alter table BlogsEntry add allowPingbacks BOOLEAN;
17:19:46,683 WARN [BaseDB:366] ORA-01430: column being added already exists in table: alter table BlogsEntry add status INTEGER;
17:19:46,715 WARN [BaseDB:366] ORA-01430: column being added already exists in table: alter table BlogsEntry add statusByUserId LONG;
17:19:46,745 WARN [BaseDB:366] ORA-01430: column being added already exists in table: alter table BlogsEntry add statusByUserName VARCHAR(75);
17:19:46,776 WARN [BaseDB:366] ORA-01430: column being added already exists in table: alter table BlogsEntry add statusDate DATE;
=================================================
Further in log
=================================================
17:19:47,744 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeAsset
17:19:47,754 ERROR [MainServlet:196] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (LRAY.IX_A32C097E) violated

com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (LRAY.IX_A32C097E) violated

at com.liferay.portal.events.StartupAction.run(StartupAction.java:53)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1159)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:193)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4187)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4496)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.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: java.sql.SQLIntegrityConstraintViolation
=================================================


Where the process starts with not being able to find the ojdb driver, further in the process clearly finds something as it returns oracle related errors.

Sorry kept it short as I could. Let me know what you think may have happened or things which I should try out.

Thanks for the help.

[Leon Schaeps, geändert vor 13 Jahren.]

Hi Bryan,

did you restart the upgrade procedure after it failed the first time?
Because you always should start with a clean 5.2.3 database.

Kind regards,

Leon

[Marek Wianecki, geändert vor 13 Jahren.]

Leo,
I have 2 Liferay nodes (cluster) with mod_jk, and mysql. We have some webcontent and some documents in document library so installation isn't pure test. This is my upgrade procedure which worked:
1. Liferay and DB backup
2. extract liferay to destination folder
3. start liferay on its defaults (it looks like you have to do it before upgrade)
4. liferay shutdown
5. configure Liferay
#portal-ext.properties
jdbc.default.jndi.name=jdbc/LiferayPool
dl.file.max.size=15728640
dl.file.extensions=.bmp,.css,.doc,.dot,.gif,.gz,.htm,.html,.jpg,.js,.lar,.odb,.odf,.odg,.odp,.ods,.odt,.pdf,.png,.ppt,.rtf,.swf,.sxc,.sxi,.sxw,.tar,.tiff,.tgz,.txt,.vsd,.xls,.xml,.zip,.flv
permissions.user.check.algorithm=5

#modify files:
/data/jackrabbit/repository.xml (my jackrabbit uses mysql)
/tomcat-6.0.26/conf/context.xml (cluster)
/tomcat-6.0.26/conf/server.xml (cluster)
/tomcat-6.0.26/conf/Catalina/localhost/ROOT.xml (mysql data source config)

6. remove all sevencogs apps (upgrade always fails because of it)
7. start liferay, watch catalina.out for errors
8. shutdown
9. remove permissions.user.check.algorithm=5
10. add image.hook.impl=com.liferay.portal.image.DatabaseHook
11. startup liferay

I hope it helps ...

[Leon Schaeps, geändert vor 13 Jahren.]

Marek Wianecki:

Leo,
I have 2 Liferay nodes (cluster) with mod_jk, and mysql. We have some webcontent and some documents in document library so installation isn't pure test. This is my upgrade procedure which worked:
1. Liferay and DB backup
2. extract liferay to destination folder
3. start liferay on its defaults (it looks like you have to do it before upgrade)
4. liferay shutdown
5. configure Liferay
#portal-ext.properties
jdbc.default.jndi.name=jdbc/LiferayPool
dl.file.max.size=15728640
dl.file.extensions=.bmp,.css,.doc,.dot,.gif,.gz,.htm,.html,.jpg,.js,.lar,.odb,.odf,.odg,.odp,.ods,.odt,.pdf,.png,.ppt,.rtf,.swf,.sxc,.sxi,.sxw,.tar,.tiff,.tgz,.txt,.vsd,.xls,.xml,.zip,.flv
permissions.user.check.algorithm=5

#modify files:
/data/jackrabbit/repository.xml (my jackrabbit uses mysql)
/tomcat-6.0.26/conf/context.xml (cluster)
/tomcat-6.0.26/conf/server.xml (cluster)
/tomcat-6.0.26/conf/Catalina/localhost/ROOT.xml (mysql data source config)

6. remove all sevencogs apps (upgrade always fails because of it)
7. start liferay, watch catalina.out for errors
8. shutdown
9. remove permissions.user.check.algorithm=5
10. add image.hook.impl=com.liferay.portal.image.DatabaseHook
11. startup liferay

I hope it helps ...

Didn't really help.
I'm able to upgrade a default 5.2.3 database with sevencogs to 6.0.3 but not with the production database.

[Leon Schaeps, geändert vor 13 Jahren.]

Marek Wianecki:

Leo,
I have 2 Liferay nodes (cluster) with mod_jk, and mysql. We have some webcontent and some documents in document library so installation isn't pure test. This is my upgrade procedure which worked:
1. Liferay and DB backup
2. extract liferay to destination folder
3. start liferay on its defaults (it looks like you have to do it before upgrade)
4. liferay shutdown
5. configure Liferay
#portal-ext.properties
jdbc.default.jndi.name=jdbc/LiferayPool
dl.file.max.size=15728640
dl.file.extensions=.bmp,.css,.doc,.dot,.gif,.gz,.htm,.html,.jpg,.js,.lar,.odb,.odf,.odg,.odp,.ods,.odt,.pdf,.png,.ppt,.rtf,.swf,.sxc,.sxi,.sxw,.tar,.tiff,.tgz,.txt,.vsd,.xls,.xml,.zip,.flv
permissions.user.check.algorithm=5

#modify files:
/data/jackrabbit/repository.xml (my jackrabbit uses mysql)
/tomcat-6.0.26/conf/context.xml (cluster)
/tomcat-6.0.26/conf/server.xml (cluster)
/tomcat-6.0.26/conf/Catalina/localhost/ROOT.xml (mysql data source config)

6. remove all sevencogs apps (upgrade always fails because of it)
7. start liferay, watch catalina.out for errors
8. shutdown
9. remove permissions.user.check.algorithm=5
10. add image.hook.impl=com.liferay.portal.image.DatabaseHook
11. startup liferay

I hope it helps ...

Thanks Marek,

I was able to upgrade
This upgrade is without the content of the Document Library, this is probably hitting http://issues.liferay.com/browse/LPS-11099

I followed your procedure.

Thanks

[Marek Wianecki, geändert vor 13 Jahren.]

well, our content library was upgraded but we've hit LPS-11286. Im glad I helped

[Dennis Greiffenberg, geändert vor 13 Jahren.]

Hi Marek,

unfortunately your solutions doesn't work for me.
I'm trying to upgrade from 5.2.3 to 6.0.5 on MySQL and whenever I run tomcat for the first time (pointing to a copy of the 5.2.3 database) i get the following error:

Starting Liferay Portal Community Edition 6.0.5 CE (Bunyan / Build 6005 / August 16, 2010)
15:51:49,208 ERROR [JDBCExceptionReporter:101] Table 'tpliferay6.lock_' doesn't exist
15:51:49,997 INFO  [BaseDB:399] Database does not support case sensitive queries
15:51:50,008 INFO  [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_0_0
15:51:50,009 INFO  [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeSchema
15:51:51,358 INFO  [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeAsset
15:51:51,840 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.MySQLSyntaxErrorException: Unknown column 'tagId' in 'field list'
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tagId' in 'field list'
        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.MySQLSyntaxErrorException: Unknown column 'tagId' in 'field list'
        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.MySQLSyntaxErrorException: Unknown column 'tagId' in 'field list'
        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.MySQLSyntaxErrorException: Unknown column 'tagId' in 'field list'
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1585)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1500)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1485)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
        at com.liferay.portal.upgrade.v6_0_0.UpgradeAsset.addProperty(UpgradeAsset.java:180)
        at com.liferay.portal.upgrade.v6_0_0.UpgradeAsset.copyProperties(UpgradeAsset.java:374)
        at com.liferay.portal.upgrade.v6_0_0.UpgradeAsset.copyEntriesToCategories(UpgradeAsset.java:330)
        at com.liferay.portal.upgrade.v6_0_0.UpgradeAsset.updateAssetCategories(UpgradeAsset.java:421)
        at com.liferay.portal.upgrade.v6_0_0.UpgradeAsset.doUpgrade(UpgradeAsset.java:387)
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:111)
        ... 39 more
Stopping the server due to unexpected startup errors

I'd appreciate any help on that.

Many thanks,
Dennis

[Jatin Panchal, geändert vor 13 Jahren.]

Hi Dennis,

I am facing the same problem.
kindly help me if someone have complete solution

[Dennis Greiffenberg, geändert vor 13 Jahren.]

Hi Jatin,

I don't know if there's a solution to this problem. It must be somehow correlated to the data as this seems not to be a general error during the upgrade. However, there's quite a few people out there having this problem.

Best regards,
Dennis

[Matthieu Levesque, geändert vor 13 Jahren.]

Hi,

I'm also having the same problem with Liferay EE 6.

After looking at the create database script of Liferay, it looks like they droped this index IX_6C5E6512 to replace it with this new one IX_2F8FED9C:

Old Index:

UNIQUE KEY `IX_6C5E6512` (`folderId`,`name`,`version`)

New Index:

create unique index IX_2F8FED9C on DLFileVersion (groupId, folderId, name, version);

They added the field version to the index.

I will try to drop the index IX_6C5E6512 and see if the upgrade will go.

Will post my results.

EDIT:

After dropping the index the upgrade went all the way.

EDIT(2): After specifying the right upgrade.processes. I didn't have to drop the index.


Maybe this post will help too:
http://www.liferay.com/community/forums/-/message_boards/message/6712282

Matthieu

[Jatin Panchal, geändert vor 13 Jahren.]

Hi,
I am trying to upgrade liferay version 5.2.3 to 6.0 directly. That causes this error.
Instead of that I have found one solution and that works fine for me.
Follow these steps.
1) do upgrading of liferay version step-by-step.
-->I mean first check your Release_ table and see what values buildNumber have.
-->Let's say if it is 5203 then change it by one step ahead say 6000.
-->Also for build number take reference of ReleaseInfo.java file from liferay portal source.
2) After that restart server again and if it fails again then increament build number in Release_ table by
6001 and again restart.

continue this steps until you upgrade db successfully.

If it successfully done then check your Release_ table and see buildNumber column's value changes from older one to latest version.

Thanks.

[Bryan Nylander, geändert vor 13 Jahren.]

Hello there. I have tried several different attempts. First started to upgrade using the latest available (6.0.2) and received same errors.

I am able to bring 5.2.3 backup and us it without errors against this DB. So is the expectations now that there are some irreversible damage which leaves this DB stuck at 5.2.3?

Thanks for the help all.

B

[Mudasar Kalwar, geändert vor 11 Jahren.]

Hi JR Houn,

I have made changes as you mentioned but still getting the following errors.
[indent]12:47:57,781 INFO [PortalImpl:3829] Current URL /image/image_gallery?uuid=f718eebc-a933-429a-bfb5-44c89af3a037&groupid=14&t=1325834593850 generates exception: No default image exists for 0
12:48:05,750 ERROR [HookFactory:41] java.lang.ClassNotFoundException: com.liferay.portal.image.FileSystemHook,com.liferay.portal.image.DatabaseHook
java.lang.ClassNotFoundException: com.liferay.portal.image.FileSystemHook,com.liferay.portal.image.DatabaseHook
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1387)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1233)
at com.liferay.portal.image.HookFactory.getInstance(HookFactory.java:37)
at com.liferay.portal.model.impl.ImageImpl.getTextObj(ImageImpl.java:35)
at com.liferay.portal.servlet.ImageServlet.getImageBytes(ImageServlet.java:265)
at com.liferay.portal.servlet.ImageServlet.writeImage(ImageServlet.java:370)
at com.liferay.portal.servlet.ImageServlet.service(ImageServlet.java:121)
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 com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
at com.liferay.portal.servlet.filters.cache.CacheFilter.processFilter(CacheFilter.java:399)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
at com.liferay.portal.servlet.filters.etag.ETagFilter.processFilter(ETagFilter.java:45)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
at com.liferay.portal.servlet.filters.header.HeaderFilter.processFilter(HeaderFilter.java:129)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
at com.liferay.portal.servlet.filters.sso.ntlm.NtlmPostFilter.processFilter(NtlmPostFilter.java:81)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
at com.liferay.portal.sharepoint.SharepointFilter.processFilter(SharepointFilter.java:179)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
at com.liferay.portal.servlet.filters.virtualhost.VirtualHostFilter.processFilter(VirtualHostFilter.java:240)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:126)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:126)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:738)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
at com.liferay.portal.servlet.filters.threadlocal.ThreadLocalFilter.processFilter(ThreadLocalFilter.java:35)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Thread.java:662)
12:48:05,766 ERROR [ImageImpl:40] Error reading image 24710
java.lang.NullPointerException
at com.liferay.portal.model.impl.ImageImpl.getTextObj(ImageImpl.java:37)
at com.liferay.portal.servlet.ImageServlet.getImageBytes(ImageServlet.java:265)
at com.liferay.portal.servlet.ImageServlet.writeImage(ImageServlet.java:370)
at com.liferay.portal.servlet.ImageServlet.service(ImageServlet.java:121)
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 com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
at com.liferay.portal.servlet.filters.cache.CacheFilter.processFilter(CacheFilter.java:399)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
at com.liferay.portal.servlet.filters.etag.ETagFilter.processFilter(ETagFilter.java:45)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
at com.liferay.portal.servlet.filters.header.HeaderFilter.processFilter(HeaderFilter.java:129)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
at com.liferay.portal.servlet.filters.sso.ntlm.NtlmPostFilter.processFilter(NtlmPostFilter.java:81)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
at com.liferay.portal.sharepoint.SharepointFilter.processFilter(SharepointFilter.java:179)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
at com.liferay.portal.servlet.filters.virtualhost.VirtualHostFilter.processFilter(VirtualHostFilter.java:240)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:126)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:126)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:738)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
at com.liferay.portal.servlet.filters.threadlocal.ThreadLocalFilter.processFilter(ThreadLocalFilter.java:35)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Thread.java:662)[/indent]

Here is my changes in the portal-ext.properties file

#permissions.user.check.algorithm=5
 image.hook.impl=com.liferay.portal.image.DatabaseHook 
 dl.hook.file.system.root.dir=${liferay.home}/data/document_library
#
# JCRHook
#
dl.hook.jcr.fetch.delay=500
dl.hook.jcr.fetch.max.failures=5

#
# S3Hook
#
dl.hook.s3.access.key=
dl.hook.s3.secret.key=
dl.hook.s3.bucket.name=

#
# S3Hook
#
dl.hook.s3.access.key=
dl.hook.s3.secret.key=
dl.hook.s3.bucket.name=

I am upgrading from liferay 5.2.3 to 6.0.6 , Mysql, tomcat5.

[Mudasar Kalwar, geändert vor 11 Jahren.]

Hi , every one I just successfully migrated from liferay 5.2.3 to liferay 6.0.6 , but there is a one issue I can't login with any user like I had created admin in liferay 5 and it exists but it can't login. any suggestions ?
here is the error trace:
[indent]12:44:57,803 INFO [PortalImpl:3829] Current URL /image/image_gallery?uuid=f718eebc-a933-429a-bfb5-44c89af3a037&groupid=14&t=1325834593850 generates exception: No default image exists for 0
12:45:13,022 INFO [PortalImpl:3829] Current URL /image/image_gallery?uuid=f718eebc-a933-429a-bfb5-44c89af3a037&groupid=14&t=1325834593850 generates exception: No default image exists for 0
12:46:07,336 INFO [PortalImpl:3829] Current URL /image/image_gallery?uuid=f718eebc-a933-429a-bfb5-44c89af3a037&groupid=14&t=1325834593850 generates exception: No default image exists for 0
12:46:42,048 INFO [PortalImpl:3829] Current URL /web/control_panel?doAsGroupId=14&refererPlid=24304 generates exception: {groupId=10116,privateLayout=false} does not have any layouts
12:46:42,048 INFO [PortalImpl:3841] {groupId=10116,privateLayout=false} does not have any layouts
12:46:56,726 INFO [PortalImpl:3829] Current URL /web/guest/control_panel?doAsGroupId=14&refererPlid=24304 generates exception: null
12:46:56,727 INFO [PortalImpl:3841]
12:47:05,687 INFO [PortalImpl:3829] Current URL /group/17/control_panel?doAsGroupId=14&refererPlid=24304 generates exception: null
12:47:05,688 INFO [PortalImpl:3841]
12:48:50,585 INFO [PortalImpl:3829] Current URL /image/image_gallery?uuid=f718eebc-a933-429a-bfb5-44c89af3a037&groupid=14&t=1325834593850 generates exception: No default image exists for 0
[/indent]

when I add the password it shows error like "You have entered invalid data. Please try again ." and "Authentication failed. Please try again. "

any help?
Thanks

[Tom Thomas, geändert vor 13 Jahren.]

Same as everyone else, I'm trying to upgrade from the Tomcat 5.2.3 bundle to Tomcat 6.0.5 bundle. The db is SQL Server 2005. I believe I have tried everything above with no luck.

The upgrade works just fine if the db is MySql - for what it's worth.

[Ali Faisal, geändert vor 12 Jahren.]

Well I am having this problem as well (SQL Server) did anyone figure out how it was solved? so far I have tried everything recommended above.

Thanks.

This is the error I am having. Clearly its the primary key violation.

15:15:32,088 ERROR [MainServlet:214] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__AssetEnt__D124D3D52E26C93A'. Cannot insert duplicate key in object 'dbo.AssetEntry'.
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__AssetEnt__D124D3D52E26C93A'. Cannot insert duplicate key in object 'dbo.AssetEntry'.
at com.liferay.portal.events.StartupAction.run(StartupAction.java:52)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1190)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:211)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)