Hi, i am getting the error using 1.4.179 version also. Same error is coming when I try to generate script. Please help me out to get rid of this error.
Ravindra. On Monday, June 2, 2014 9:46:18 PM UTC+5:30, Thomas Mueller wrote: > > Hi, > > I finally found and fixed the problem now. This problem will be fixed in > the next release. One workaround is to not upgrade to version 1.3.176 if > the database was created with an earlier version. Another workaround is to > export the database file to a SQL script and re-create it. > > Regards, > Thomas > > > > On Wed, May 28, 2014 at 4:42 PM, Nick99 <[email protected] <javascript:> > > wrote: > >> 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.na >>>>>>>> bble.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] <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> 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.
