how to resolve 'previous schema upgrade failed'?

[stk137]

Even after reverting the database and running again and I keep getting this error:

08:41:39,534 ERROR [domain.schema.SchemaBootstrap] Schema auto-update failed
org.alfresco.error.AlfrescoRuntimeException: A previous schema upgrade failed.  Revert to the original database before attempting the upgrade again.
‍‍‍

How can I troubleshoot and resolve?
There's no error messages logged for any actual schema update failures.

This related to 1.4 to 2.1 using MySQL 5

I did see this
http://issues.alfresco.com/browse/AR-1766
so I tried using the MySQL root account but still get this error.

[mikeh]

Hi,

There might be an "alf_bootstrap_lock" table left over from a previously interrupted bootstrap, which will prevent the app launching. If so, drop the table and try again.


Thanks,
Mike

[stk137]

Hi,

There might be an "alf_bootstrap_lock" table left over from a previously interrupted bootstrap, which will prevent the app launching. If so, drop the table and try again.


Thanks,
Mike

yes that's it!

I had finally figured that out after digging through the source.  Although I still don't know why it was left behind originally.  Alfresco swallows the original SQL error and just gives the above. 

I also didn't know my sys-admin had "improved" our restore script to only drop tables that it was going to restore (leaving alf_bootstrap_lock around).  So I went crazy trying to figure out why it was failing even after restore for awhile.

[a_weed096]

I'm sorry for bringing up an old topic, but I am having a similar problem, in that I get the same error message, but I am unable to fix the problem the same way. I dropped the table alf_bootstrap_lock, but this does not alleviate the problem. I have tried reinstalling both MySQL and Alfresco, but this didn't help. I am on Windows 2003 Server working with Alfresco 2.9B. Thanks for any help in advance.

[andy]

Hi

What is the exception or message?

Andy