Same problem. 1. The database was created in CREATE_BUILD 170, then was used with 1.3.174. I've tried using 1.4.178 on that database in Hibernate-based product - got
org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: "PRIMARY KEY ON """".PAGE_INDEX"; SQL statement:[...] 1.3.175 works ok on that db. 1.3.176 is not. 2. Opening the db in 1.3.176 Console produces this (table names removed): Unique index or primary key violation: "PRIMARY KEY ON """".PAGE_INDEX"; SQL statement: ALTER TABLE PUBLIC.-------------- ADD CONSTRAINT PUBLIC.FK28D9808AF98221CA FOREIGN KEY(JESID) REFERENCES PUBLIC.--------------(ID) NOCHECK [23505-176] 23505/23505 (Help) On Monday, May 26, 2014 10:33:05 AM UTC+3, Germano Rizzo wrote: > > Provided > here<https://groups.google.com/forum/?hl=it#!topic/h2-database/lNp80bgbvBY>. > Thanks! > > Il giorno giovedì 22 maggio 2014 17:43:18 UTC+2, Thomas Mueller ha scritto: >> >> Hi >> >> I would need a reproducible test case, or the database file. >> >> Regards, Thomas >> >> On Thursday, May 22, 2014, jack jin <[email protected]> wrote: >> >>> when I upgrade to 1.3.176,I have the same problem. the old version h2 >>> is works fine with the db file >>> >>> On Tuesday, May 6, 2014 5:00:52 PM UTC+8, Germano Rizzo wrote: >>>> >>>> Hi Thomas, >>>> so your opinion is that all the db's are corrupted? The strange >>>> thing is, they fail to open only with the latest stable version. Every >>>> other version I tried works fine, and this configuration have worked in 40 >>>> installations for 3 years now, across different versions of H2. Do you >>>> want >>>> me to start another thread? >>>> >>>> Germano >>>> >>>> Il giorno martedì 6 maggio 2014 07:59:45 UTC+2, Thomas Mueller ha >>>> scritto: >>>>> >>>>> Hi, >>>>> >>>>> If you are using LOCK_MODE=0;UNDO_LOG=0 then you need to be aware of >>>>> the risks. See the FAQ and the documentation. >>>>> >>>>> Please use different email subjects for different problems. >>>>> >>>>> Regards, >>>>> Thomas >>>>> >>>>> >>>>> On Monday, May 5, 2014, mano <[email protected]> wrote: >>>>> >>>>>> mano wrote >>>>>> > Opening it with version 1.3.168 will give the error. >>>>>> >>>>>> Sorry, I meant 1.3.176. >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> View this message in context: http://h2-database.66688.n3. >>>>>> nabble.com/Unique-index-or-primary-key-violation-SYS-ID- >>>>>> ON-PUBLIC-SYS-ID-23505-168-using-1-3-168-tp4028700p4029078.html >>>>>> Sent from the H2 Database mailing list archive at Nabble.com. >>>>>> >>>>>> -- >>>>>> 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. >>> >> -- 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.
