2014-05-09 15:30 GMT+02:00 Germano Rizzo <[email protected]>: > Hi, > I have a reproducible bug with versions 174 and 176 (at least). A db > created with 1.3.174 (no particular settings) corrupts when just opening > and closing it in 1.3.176. To reproduce: >
I have also a problem with 176. With at least one (but not all) database I get the following error when opening the database in H2 console: Unique index or primary key violation: "PRIMARY KEY ON """".PAGE_INDEX"; SQL statement: ALTER TABLE PUBLIC.WEIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_74 FOREIGN KEY(CATEGORYID) REFERENCES PUBLIC.CATEGORIES(ID) NOCHECK [23505-176] <http://127.0.0.2:8082/login.do?jsessionid=906bcb32b9beddff983be35575c2bd82#> 23505/23505 When going back to 174 luckily all my databases work like before. weights is defined as: FIELD <http://127.0.0.2:8082/query.do?jsessionid=3f87e6740013f7de2ee326159fb984e7#> TYPE <http://127.0.0.2:8082/query.do?jsessionid=3f87e6740013f7de2ee326159fb984e7#> NULL <http://127.0.0.2:8082/query.do?jsessionid=3f87e6740013f7de2ee326159fb984e7#> KEY <http://127.0.0.2:8082/query.do?jsessionid=3f87e6740013f7de2ee326159fb984e7#> DEFAULT <http://127.0.0.2:8082/query.do?jsessionid=3f87e6740013f7de2ee326159fb984e7#> CATEGORYIDUUID(2147483647)NOPRINULLMEASUREDATEDATE(8)NOPRICURRENT_DATE() WEIGHTDOUBLE(17)NONULLFATDOUBLE(17)YESNULLWATERDOUBLE(17)YESNULLMUSCLE DOUBLE(17)YESNULL When certain information is needed: let me know. -- Cecil Westerhof -- 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.
