topic Re: how to resolve 'previous schema upgrade failed'? in Alfresco Archive

how to resolve 'previous schema upgrade failed'?

stk137 — Wed, 26 Sep 2007 17:05:08 GMT

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 failedorg.alfresco.error.AlfrescoRuntimeException: A previous schema upgrade failed. Revert to the original database before attempting the upgrade

Re: how to resolve 'previous schema upgrade failed'?

mikeh — Wed, 26 Sep 2007 19:44:06 GMT

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

Re: how to resolve 'previous schema upgrade failed'?

stk137 — Wed, 26 Sep 2007 20:48:40 GMT

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.

Re: how to resolve 'previous schema upgrade failed'?

a_weed096 — Tue, 12 Feb 2008 18:55:01 GMT

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.

Re: how to resolve 'previous schema upgrade failed'?

andy — Wed, 20 Feb 2008 15:24:17 GMT

Hi

What is the exception or message?

Andy