db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <rick.hille...@gmail.com>
Subject Re: Unknown page format at page Page(7,Container(0, 161)) [SYSCOLUMNS_INDEX1] on bootup
Date Fri, 25 Sep 2015 02:45:08 GMT
Hi David,

If all else fails, you can create an empty database with the same schema 
as the old one, and then siphon data out of the corrupt database into 
the new database using the custom tool attached to 
https://issues.apache.org/jira/browse/DERBY-6136. Something like this...

call syscs_util.syscs_register_tool( 'customTool', true, 'RawDBReader', 

...and then a sequence of statements like this...

insert into myschema.my_table select * from old_myschema.my_table;

Hope this helps,

On 9/24/15 4:02 AM, David Sitsky wrote:
> Hi all,
> I have a database from another user which unfortunately can't boot up 
> with this error:
> ERROR XJ040: Failed to start database 'E:\XXXXXXXX\Database' with 
> class loader sun.misc.Launcher$AppClassLoader@1540e19d, see the next 
> exception for details.
> ERROR XSDBB: Unknown page format at page Page(7,Container(0, 161)), 
> page dump follows:
> I understand 161 refers to the conglomerate SYSCOLUMNS_INDEX1 and the 
> file ca1.dat.
> Is there any magic I can do to somehow drop this "index" and 
> regenerate it?
> Thanks in advance for any pointers.  I checked 
> https://wiki.apache.org/db-derby/DatabaseCorruption but given this is 
> a system index and I can't boot the database I don't have any ideas.
> Cheers,
> David

View raw message