Re: [h2] Unique index or primary key violation: SYS_ID ON PUBLIC.SYS(ID) [23505-168] (using 1.3.168)

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

Re: [h2] Unique index or primary key violation: SYS_ID ON PUBLIC.SYS(ID) [23505-168] (using 1.3.168)

With 1.4.179 I am facing this problem Unique index or primary key violation: PRIMARY KEY ON .PAGE_INDEX; SQL statement: ALTER TABLE PUBLIC.TABACCOUNT ADD CONSTRAINT PUBLIC.FK_TABACCOUNT_PARENTACCOUNTNO FOREIGN KEY(PARENTACCOUNTNO) INDEX PUBLIC.FK_TABACCOUNT_PARENTACCOUNTNO_INDEX_D REFERENCES

Re: [h2] Unique index or primary key violation: SYS_ID ON PUBLIC.SYS(ID) [23505-168] (using 1.3.168)

Another input (might be useful) I did a checkout of source code of revision # 5751 and tried to generate script. However I got the error which I posted above. Then I set the flag *retry=true* in *public void add(Session session, Row row)* method in *org.h2.index.PageDataIndex* and it generated