Re: [h2] Problem still persist on latest release(1.4.179) IndexOutOfBoundsException during executeBatch.

2014-06-29 Thread Thomas Mueller
Hi, Do you have a simple, reproducible test case? If not, could you describe what your application does exactly? Regards, Thomas On Sun, Jun 29, 2014 at 5:34 AM, Vishwa vishwas...@gmail.com wrote: I have been getting this exception on 1.4.178 and 1.4.179. Problem still persist on latest

[h2] Re: Problem still persist on latest release(1.4.179) IndexOutOfBoundsException during executeBatch.

2014-06-29 Thread Vishwa
I have around 100M row in each tables/views and loading from MySQL. I cannot use link table as it is too slow(mentioned in earlier thread). So I am loading myself by simple select and insert using prepared statement and batch. I am committing every 10, Here is the part of database load.

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

2014-06-29 Thread Ravindra Gullapalli
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)

2014-06-29 Thread Ravindra Gullapalli
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)

2014-06-29 Thread Ravindra Gullapalli
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