HSQL Corrupt / Invalid

[ravikumar]

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 intact.  How do we over come this? Could you please help us on the relationship between Content Store, Indexes and Meta data ?

As it is in Production, your valuable suggestions/solution will be very helpful.

Thanks,
Ravi

[pmonks]

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

[ravikumar]

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