Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#15 DG goes into an infinite loop when a commit batch fails

open
Xueyuan Peng
Bug (17)
5
2011-11-15
2011-10-08
Michael
No

The batch of commit statements failed because:
AN INSERTED OR UPDATED VALUE IS INVALID BECAUSE THE INDEX IN INDEX SPACE indexspace-name CONSTRAINS COLUMNS OF THE TABLE SO NO TWO ROWS CAN CONTAIN DUPLICATE VALUES IN THOSE COLUMNS. RID OF EXISTING ROW IS X record-id

DG continued to run and looked like it was still committing rows. Difficult to catch since if a user walks away from their computer while DG is running, they won't see the error message printed.

63996 [main] INFO com.ibm.dg.DataGenerator - Generating data for 'Movie.people_relationship' table.
This table will have 1000 row(s).
Threads: 4, with around 250 row(s) per thread.
Exception in thread "Thread-24" java.lang.RuntimeException: Thread failed to execute batch, stopping: SQLException 0
Code: -4229
SqlState: null
Error Message: [jcc][t4][102][10040][3.62.56] Batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch.
Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null
SQLException 1
Code: -803
SqlState: 23505
Error Message: Error for batch element #1: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=1;MOVIE.PEOPLE_RELATIONSHIP, DRIVER=3.62.56

at com.ibm.dg.threads.TableThread.commitBatch(TableThread.java:331)
at com.ibm.dg.threads.TableThread.run(TableThread.java:251)
at java.lang.Thread.run(Thread.java:636)
Comm. (stmts) Comm. (size) Commit Rate (stmts/s) Commit Rate (size/s)
======
250 2.9 KB -1 null
250 2.9 KB -1 null
250 2.9 KB -1 null
250 2.9 KB -1 null
250 2.9 KB -1 null
250 2.9 KB -1 null
250 2.9 KB -1 null

Discussion

  • Michael
    Michael
    2011-11-15

    • assigned_to: nobody --> xueyuan0106