Fórumok

Upgrade from 5.2.3 to 6.0.6 failed on Linux env (DB not upgraded properly)

Viktoryia Pupochkina, módosítva 10 év-val korábban

Upgrade from 5.2.3 to 6.0.6 failed on Linux env (DB not upgraded properly)

New Member Bejegyzések: 3 Csatlakozás dátuma: 2012.08.23. Legújabb bejegyzések
Hi everyone!
When I start the 6.0.6 Liferay with Tomcat 6.0.29 it updates the old (5.2.3 version) database almost without errors except :
10:22:35,967 ERROR [JDBCExceptionReporter:101] ERROR: relation "lock_" does not exist Position: 403
and
10:22:37,546 WARN [BaseDB:376] ERROR: column "minsymbols" of relation "passwordpolicy" already exists: alter table PasswordPolicy add minSymbols INTEGER;

When I try to access the home page I get the following error:
11:29:01,122 ERROR [VirtualHostFilter:136] java.lang.ArrayIndexOutOfBoundsException: 0
java.lang.ArrayIndexOutOfBoundsException: 0
at com.liferay.portal.util.PortalInstances._getDefaultCompanyId(PortalInstances.java:281)
at com.liferay.portal.util.PortalInstances._getCompanyId(PortalInstances.java:188)
at com.liferay.portal.util.PortalInstances.getCompanyId(PortalInstances.java:66)

And if I try to restart Tomcat it tries to update the database again and throw a lot of errors like "[BaseDB:376] ERROR: relation "assetcategory" already exists:"

Also I noticed that it doesn't update the Release_ table in proper way: buildnumber column stayed "5203" and modifieddate also stayed old.
My Linux version is "Linux 2.6.21.7-2.fc8xen-ec2-v1.0 #1 SMP Tue Sep 1 10:25:30 EDT 2009 x86_64 GNU/Linux"

Can you help me to resolve the issue with the upgrade?
thumbnail
Victor Zorin, módosítva 10 év-val korábban

RE: Upgrade from 5.2.3 to 6.0.6 failed on Linux env (DB not upgraded proper

Liferay Legend Bejegyzések: 1228 Csatlakozás dátuma: 2008.04.14. Legújabb bejegyzések
If the buildnumber is still 5203, no point of going to the home page, it won't work.
Try to finish the upgrade cleanly. What you need to see is that running of VerifyProcess tasks has completed the job. The BuildNumber is set only after this.

Some of links related to 5.2.+ migration problems:
Migration to 6.1 fails while verifying document library
After upgrading from Liferay CE GA2 to GA3 non-admins missing control panel

Also make sure that you follow exactly the recommended migration procedures.