[xwiki-users] HSQLDB
Hi, I had my xwiki linux pc crash on me during a powercut and the HSQLDB database seemed to revert to content that was on the xwiki several weeks ago. What's happened? Does hsqldb store data in memory and that is why the data has got lost when the power went? I thought it stored the data in xwiki_db.script? Anyone? Regards, Richard Thales UK Ltd (Wells) DISCLAIMER: The information contained in this e-mail is confidential. It may also be legally privileged. It is intended only for the stated addressee(s) and access to it by any other person is unauthorised. If you are not an addressee, you must not disclose, copy, circulate or in any other way use or rely on the information contained in this e-mail. Such unauthorised use may be unlawful. We may monitor all e-mail communications through our networks. If you have received this e-mail in error, please inform us immediately on +44 (0) 1749 672081 and delete it and all copies from your system. We accept no responsibility for changes to any e-mail which occur after it has been sent. Attachments to this e-mail may contain software viruses which could damage your system. We therefore recommend you virus-check all attachments before opening. A business of Thales UK Ltd. Registered Office: 2 Dashwood Lang Road, The Bourne Business Park, Addlestone, Weybridge, Surrey KT15 2NX Registered in England No. 868273
On Nov 21, 2007, at 5:02 PM, goldring, richard wrote:
Hi,
I had my xwiki linux pc crash on me during a powercut and the HSQLDB database seemed to revert to content that was on the xwiki several weeks ago. What's happened? Does hsqldb store data in memory and that is why the data has got lost when the power went? I thought it stored the data in xwiki_db.script? Anyone?
It depends how you configured HSQLDB. AFAIK xwiki configures it by default to store to files and not in memory... Now it probably has a cache for performance reasons but several weeks of data loss looks like another issue. I'd recommend talking to the HSQLDB guys on their forums/mailing list. They're the best to know how to fix this I think. We also recommend making regular backups of your database same as you would backup any of your personal files. For HSQLDB it's especially easy since you just have to save a directory. I know, it's too late now for you but if that can help others... Thanks -Vincent
participants (2)
-
goldring, richard -
Vincent Massol