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
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:\\Database' with class
loader sun.misc.Launcher$AppClassLoader@1540e19d, see the next exception
for details.
ERROR XSDBB: Unknown page format at page
> ERROR XJ040: Failed to start database 'E:\\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
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?
Do you have any slightly older backups of this particular database that you
can copy ca1.dat from?
Alternatively, did you try
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