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 <
thomas.tom.muel...@gmail.com> 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 <
> dieter.caill...@gmail.com> 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 h2-database+unsubscr...@googlegroups.com.
>> To post to this group, send email to h2-database@googlegroups.com.
>> 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 h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
