jump to navigation

Alfresco: A previous schema upgrade failed. Revert to the original database before attempting the upgrade again. January 23, 2008

Posted by maxmil in : Alfresco , trackback

Alfresco 2.1 sometimes refuses to start with the error

Caused by: org.alfresco.error.AlfrescoRuntimeException: A previous schema upgrade failed. Revert to the original database before attempting the upgrade again.

Not quite sure how this comes about, think that it can be from a failed start previously, but a solution is to drop the table alf_bootstrap_lock and try again.

Comments»

1. armando - September 9, 2008

THANK YOU! I was wondering if i had to reinstall the application. Glad I didn’t have to.

2. bloggingIT » Blog Archive » Alfresco - You Will Not Beat ME! - September 18, 2008

[...] FINALLY I found the solution at Bits n Bobs. It’s ridiculously simple: drop the table alf_bootstrap_lock and restart the server. [...]

3. John R - September 18, 2008

Ditto! My pork has well and truly been rescued.

4. DBK - February 18, 2009

I have dropped all the tables bcas I wanted to recreate all the tables in another user .But still getting the error

5. maxmil - February 18, 2009

I’m not sure what to do if you’ve dropped ALL the tables, i would imagine the best thing to do is drop the database and recreate it with a script similar to the one in extras/databases.

If the default user that you want to use is not “alfresco” you will have to modify the database configuration in custom-repository.properties.

6. Andriy - June 3, 2009

Thanks a lot!! It realy works for me.

7. Rafael - October 26, 2009

I changed a variable related to lower_case table names due to another project. Then, when I came back to Alfresco I had this problem…

But, with your solution, everything works now! =)

Thank you very much!