topic HSQL Corrupt / Invalid in Alfresco Archive

HSQL Corrupt / Invalid

ravikumar — Mon, 16 Jun 2008 19:12:39 GMT

Hi,We are receiving the bootstrap failure error. Environment is Windows/Tomcat/ hsql.Opened the HSQL file and saw that the last line is inserted partially. Removed that last line of the hsql file and restarted. It is creating a fresh db (vanilla). All the meta data are lost. The Content Store is int

Re: HSQL Corrupt / Invalid

pmonks — Mon, 16 Jun 2008 19:34:26 GMT

As mentioned on the wiki (http://wiki.alfresco.com/wiki/Database_Configuration#Hypersonic_SQL_Databases), the Alfresco log and elsewhere, HSQLDB is not intended for production use. Corruption is one of the reasons for this (as you've discovered HSQLDB can, in some situations, corrupt itself).

At this point I think your safest bet is to restore the most recent backup of your repository (HSQLDB + contentstore). http://wiki.alfresco.com/wiki/Backup_and_Restore describes how the restoration should be performed (assuming you've backed up your repository properly, also described on that page).

Cheers,
Peter

Re: HSQL Corrupt / Invalid

ravikumar — Tue, 17 Jun 2008 04:50:42 GMT

Hi Peter,

Thanks for your immediate response i apologize for cross posting, will avoid it.

Now if i modify the last line of alfresco.script file and open it using hsql db client, things seems to be fine.

Again when i restart alfresco server it creates the vanilla footprint, is it due to mismatch between index and
metadata or index and content? On what basis does alfresco creates the fresh details, please explain

As i don't have any recent backup to fall back, thsi is very crucial

thanks
Ravi