db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Sitsky <david.sit...@gmail.com>
Subject Re: Unknown page format at page Page(7,Container(0, 161)) [SYSCOLUMNS_INDEX1] on bootup
Date Mon, 28 Sep 2015 11:28:30 GMT
Hi Bryan and Rick,

Thanks for your suggestions.  It turns out the customer did have another
database available with the same schema.  Copying ca1.dat helped a little,
but I was still getting NPEs executing various statements.  I tried copying
more and more SYS tables/indexes and in the end basically copied all of
them across and that seemed to get the database into a working state.

For the record, these were the files I copied across.  Thanks again for
your advice.

c31.dat c41.dat c51.dat c71.dat c81.dat ca1.dat cb1.dat cd1.dat
ce1.dat c20.dat c60.dat c90.dat cc0.dat c101.dat c111.dat c121.dat
cf0.dat c141.dat c130.dat c161.dat c171.dat c150.dat c191.dat c1a1.dat
c1b1.dat c180.dat c1d1.dat c1c0.dat c1f1.dat c1e0.dat c211.dat
c221.dat c200.dat c241.dat c251.dat c230.dat c271.dat c281.dat
c260.dat c2a1.dat c2b1.dat c2c1.dat c290.dat c2e1.dat c2d0.dat
c2f0.dat c311.dat c321.dat c331.dat c300.dat c351.dat c361.dat
c371.dat c340.dat c391.dat c3a1.dat c3b1.dat c380.dat c3d1.dat
c3e1.dat c3f1.dat c3c0.dat c411.dat c421.dat c400.dat c441.dat
c451.dat c461.dat c430.dat


On Fri, Sep 25, 2015 at 12:45 PM, Rick Hillegas <rick.hillegas@gmail.com>

> 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,
> -Rick
> 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