2014-06-01 10:16 GMT+02:00 Cecil Westerhof <[email protected]>: > 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)NONULLFAT DOUBLE(17)YESNULLWATERDOUBLE(17)YESNULLMUSCLE > DOUBLE(17)YESNULL > When certain information is needed: let me know. >
By the way, the database was created with version 171. But a database which does not have the problem was also created with 171. -- 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.
