topic Re: Alfresco database upgrade failure in Alfresco Archive

Alfresco database upgrade failure

bsubramanian — Wed, 15 Oct 2008 07:17:37 GMT

Hi ThereWe are upgrading alfresco 2.1.2 (Enterprise edition) to 2.2.1 (Enterprise edition) in our development suite running on RHEL 5 with MYSQL database and Jboss 4.2.1. The process we followed was.1. Stopped the old alfresco instance running2. Backed up the old mysql database using mysqldump c

Re: Alfresco database upgrade failure

norgan — Wed, 15 Oct 2008 09:05:14 GMT

Hello Bala,
I had the same problem on installation of a Lab 3.0 Version. My only solution was "delete alf_data & database and restart from scratch". I didn't even get to the import of my old data. Maybe that helps. Otherwise, beeing a user of the Enterprise Version, the support should be available to you, right?

Good Hunting,
Norgan

Re: Alfresco database upgrade failure

bsubramanian — Tue, 21 Oct 2008 04:36:18 GMT

Hi Norgan

I had a suggestion from support team (Unfortunately, it didn't work for me) to delete the database table "alf_bootstrap_lock". The steps to be repated are

— delete current db
— restore db from backup
— REMOVE alf_bootstrap_lock table
— delete alfresco app dir from: <JBOSS-DIR>\\server\default\tmp\deploy \tmp61353alfresco-exp.war
— comment this out: index.recovery.mode=VALIDATE
— restart jboss (assuming the war file is on the deploy dir)

Could you try to get back your data from older db if it will not hurt your current installation and let me know?

Thanks
Bala

Re: Alfresco database upgrade failure

loftux — Tue, 21 Oct 2008 06:19:21 GMT

Have you tried to get this up and running on a 'clean' install?

By doing so you can rule out basic connectivity and configuration problems. Once that is done, remove the test data, then load your db and alf_data with the actual data and now try the upgrade.

Re: Alfresco database upgrade failure

bsubramanian — Tue, 21 Oct 2008 10:45:54 GMT

The clean install works fine. The issue arises only when we try to restore the db from a back up. Were you able to upgrade your stuff to 2.2 SP1?

Thanks
Sonia

Re: Alfresco database upgrade failure

maxmax — Tue, 21 Oct 2008 13:27:12 GMT

Hi,
had same thing with 2.1.1 to 2.1.6 … when u catch this error the best is always to start back from your backups

but the working trick for me was to add in the custom-repo file :

 
db.schema.update=true
db.schema.update.lockRetryCount=24
db.schema.update.lockRetryWaitSeconds=5
‍‍‍‍‍

when

Re: Alfresco database upgrade failure

toltech — Mon, 10 Nov 2008 08:30:33 GMT

Hello,
I have also been experiencing problems with an upgrade, But if you want to upgrade (2.2. -> 3.0) and this fails, how do you upgrade from backup? alf_data and the database are belonging to 2.2 and can not be used. To the only solution I can think of, is to make a dump through one of the other interfaces (e.g. FTP), import this directory structure in the new installation also using CIFS of FTP and recreate the user and right structure by hand, which is of course an error prone method.

Any ideas?
Robert