Hi,
Some more questions:
- With which version of H2 was this database created?
You can find it out using:
select * from information_schema.settings where name='CREATE_BUILD'
or have a look in the SQL script created by the recover tool.
- Did the application run out of memory (once, or multiple times)?
Known corruptions with older versions are: With version 1.3.171 and older:
when using local temporary tables and not dropping them manually before
closing the session, and then killing the process could result in a
database that couldn't be opened.
Regards,
Thomas
On Tue, Mar 18, 2014 at 6:31 AM, Thomas Mueller <
[email protected]> wrote:
> Hi,
>
> Could you tell us, what database URL do you or did you use? It looks like
> a corruption of some kind, but I'm not sure.
>
> Regards,
> Thomas
>
>
>
> On Mon, Mar 17, 2014 at 8:11 AM, Dieter Cailliau <
> [email protected]> wrote:
>
>> With 1.3.175 the error message is a bit longer:
>>
>> Uniq<http://127.0.1.1:8082/test.do?jsessionid=4ea64ad64b043f1dd5de67ef7339a197#>ue
>> index or primary key violation: "SYS_ID ON PUBLIC.SYS(ID) VALUES ( /*
>> key:266 */ 15, 0, 3, 'CREATE SEQUENCE
>> PUBLIC.SYSTEM_SEQUENCE_803C1AF8_DCEB_49F0_8A0D_14C8577C2238 START WITH 34
>> BELONGS_TO_TABLE')"
>> [23505-175]<http://127.0.1.1:8082/test.do?jsessionid=4ea64ad64b043f1dd5de67ef7339a197#>
>> 23505/23505
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "H2 Database" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected].
>> To post to this group, send email to [email protected].
>> Visit this group at http://groups.google.com/group/h2-database.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
