Re: [h2] Re: Corruption in a database created in 1.3.174 when opening and closing it in 1.3.176

2014-05-26 Thread Germano Rizzo
Thank you, I hope you'll manage to fix this. Let me know if I can be of some help. Let me add that: - version 175 seems to behave like 174, so the problem seems to be between 175 and 176. - the latest 2 beta versions seem to be ok Thanks, Germano Il giorno giovedì 22 maggio 2014

Re: [h2] Re: Corruption in a database created in 1.3.174 when opening and closing it in 1.3.176

2014-05-22 Thread Thomas Mueller
Hi, Thanks a lot for the test case! I could reproduce the problem now. The SQL.sql can be reduced to: create table a(x int primary key); create table b(x int, y int, primary key(x, y)); alter table b add foreign key(x) references a(x); I used the following shell script to reproduce the error:

[h2] Re: Corruption in a database created in 1.3.174 when opening and closing it in 1.3.176

2014-05-16 Thread Niko Paltzer
I can confirm the problem. We tried to move from 1.3.172 to 1.3.174 and got the same error. On Friday, May 9, 2014 4:12:29 PM UTC+2, Germano Rizzo wrote: If I remove the foreign key definition (last line in the SQL) the problem doesn't present itself. Of course I can't do this, as I have

[h2] Re: Corruption in a database created in 1.3.174 when opening and closing it in 1.3.176

2014-05-09 Thread Germano Rizzo
Actually, in the eclipse project the URL has also ;TRACE_LEVEL_FILE=0;FILE_LOCK=FS;. If you remove it (leaving no url parameter), the bug triggers the same. Il giorno venerdì 9 maggio 2014 15:30:07 UTC+2, Germano Rizzo ha scritto: Hi, I have a reproducible bug with versions 174 and 176

[h2] Re: Corruption in a database created in 1.3.174 when opening and closing it in 1.3.176

2014-05-09 Thread Germano Rizzo
If I remove the foreign key definition (last line in the SQL) the problem doesn't present itself. Of course I can't do this, as I have many databases already created. I'll stick with 174 until this is solved. Il giorno venerdì 9 maggio 2014 15:30:07 UTC+2, Germano Rizzo ha scritto: Hi, I