[prev in list] [next in list] [prev in thread] [next in thread] 

List:       hsqldb-user
Subject:    [Hsqldb-user]  HSQLDB-Cached tables
From:       iceDice <nmilasinovic () gmail ! com>
Date:       2011-05-18 12:11:43
Message-ID: 31646271.post () talk ! nabble ! com
[Download RAW message or body]


Hello,

I am using hsqldb with cached tables.
Recently i got invalid database script files somehow. I don't know why this
happens and why script files are damaged.
However problem is that values for indexes in commands:
SET TABLE PUBLIC.ACT INDEX '931552 12552 0 0 21305'
SET TABLE PUBLIC.ACTVERSION INDEX '3515904 2388384 2107840 1683832 0 0 0 0
28221'
SET TABLE PUBLIC.DOCUMENT INDEX '23170776 4888824 4881456 6301040 0 0 0 0
122694'
...
are invalid, and i cannot re-open such database (load cached tables from
data file).

Is there any way to recreate those indexes, as .data file where all cached
tables are stored is 
still valid?
If there is a way to generate valid indexes again it will repair database.

I also tried to delete all SET TABLE tablename INDEX commands and after that
i succeed to 
open database, but all cached tables are empty!

Full stack trace of exception when trying to load cached tables
http://old.nabble.com/file/p31646271/ExceptionStackTrace.txt
ExceptionStackTrace.txt  from data file when script file is damaged are in
attachment.

Best regards.
-- 
View this message in context: http://old.nabble.com/HSQLDB-Cached-tables-tp31646271p31646271.html
Sent from the HSQLDB - User mailing list archive at Nabble.com.


------------------------------------------------------------------------------
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its 
next-generation tools to help Windows* and Linux* C/C++ and Fortran 
developers boost performance applications - including clusters. 
http://p.sf.net/sfu/intel-dev2devmay
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
[prev in list] [next in list] [prev in thread] [next in thread]