Skip to content
This repository has been archived by the owner on Aug 23, 2021. It is now read-only.

Batch failure using DB2 #335

Open
frederikstalschus opened this issue Sep 8, 2020 · 0 comments
Open

Batch failure using DB2 #335

frederikstalschus opened this issue Sep 8, 2020 · 0 comments

Comments

@frederikstalschus
Copy link

Hi guys, when I try to run ./oltpbenchmark -b tpcc -c config/sample_db2tpcc_config.xml --create=true --load=true I get this error message:

12:18:57,754 (DBWorkload.java:270) INFO  - ======================================================================

Benchmark:     TPCC {com.oltpbenchmark.benchmarks.tpcc.TPCCBenchmark}
Configuration: config/sample_db2tpcc_config.xml
Type:          DB2
Driver:        com.ibm.db2.jcc.DB2Driver
URL:           jdbc:db2:tpcc
Isolation:     TRANSACTION_SERIALIZABLE
Scale Factor:  20.0

12:18:57,756 (DBWorkload.java:271) INFO  - ======================================================================
12:18:57,773 (DBWorkload.java:533) INFO  - Creating new TPCC database...
12:19:52,357 (DBWorkload.java:535) INFO  - Finished!
12:19:52,357 (DBWorkload.java:536) INFO  - ======================================================================
12:19:52,358 (DBWorkload.java:559) INFO  - Loading data into TPCC database with 80 threads...
com.ibm.db2.jcc.am.BatchUpdateException: [jcc][102][10040][4.21.29] 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
        at com.ibm.db2.jcc.am.kd.a(kd.java:502)
        at com.ibm.db2.jcc.am.Agent.endBatchedReadChain(Agent.java:416)
        at com.ibm.db2.jcc.am.tp.a(tp.java:5328)
        at com.ibm.db2.jcc.am.tp.c(tp.java:4915)
        at com.ibm.db2.jcc.am.tp.executeBatch(tp.java:3048)
        at com.oltpbenchmark.benchmarks.tpcc.TPCCLoader.loadOrders(TPCCLoader.java:661)
        at com.oltpbenchmark.benchmarks.tpcc.TPCCLoader$2.load(TPCCLoader.java:120)
        at com.oltpbenchmark.api.Loader$LoaderThread.run(Loader.java:63)
        at com.oltpbenchmark.util.ThreadUtil$LatchRunnable.run(ThreadUtil.java:343)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)
com.ibm.db2.jcc.am.BatchUpdateException: [jcc][102][10040][4.21.29] 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
        at com.ibm.db2.jcc.am.kd.a(kd.java:502)
        at com.ibm.db2.jcc.am.Agent.endBatchedReadChain(Agent.java:416)
        at com.ibm.db2.jcc.am.tp.a(tp.java:5328)
        at com.ibm.db2.jcc.am.tp.c(tp.java:4915)
        at com.ibm.db2.jcc.am.tp.executeBatch(tp.java:3048)
        at com.oltpbenchmark.benchmarks.tpcc.TPCCLoader.loadOrders(TPCCLoader.java:661)
        at com.oltpbenchmark.benchmarks.tpcc.TPCCLoader$2.load(TPCCLoader.java:120)
        at com.oltpbenchmark.api.Loader$LoaderThread.run(Loader.java:63)
        at com.oltpbenchmark.util.ThreadUtil$LatchRunnable.run(ThreadUtil.java:343)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)
com.ibm.db2.jcc.am.BatchUpdateException: [jcc][102][10040][4.21.29] 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
        at com.ibm.db2.jcc.am.kd.a(kd.java:502)
        at com.ibm.db2.jcc.am.Agent.endBatchedReadChain(Agent.java:416)
        at com.ibm.db2.jcc.am.tp.a(tp.java:5328)
        at com.ibm.db2.jcc.am.tp.c(tp.java:4915)
        at com.ibm.db2.jcc.am.tp.executeBatch(tp.java:3048)
        at com.oltpbenchmark.benchmarks.tpcc.TPCCLoader.loadOrders(TPCCLoader.java:656)
        at com.oltpbenchmark.benchmarks.tpcc.TPCCLoader$2.load(TPCCLoader.java:120)
        at com.oltpbenchmark.api.Loader$LoaderThread.run(Loader.java:63)
        at com.oltpbenchmark.util.ThreadUtil$LatchRunnable.run(ThreadUtil.java:343)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)
com.ibm.db2.jcc.am.BatchUpdateException: [jcc][102][10040][4.21.29] 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
        at com.ibm.db2.jcc.am.kd.a(kd.java:502)
        at com.ibm.db2.jcc.am.Agent.endBatchedReadChain(Agent.java:416)
        at com.ibm.db2.jcc.am.tp.a(tp.java:5328)
        at com.ibm.db2.jcc.am.tp.c(tp.java:4915)
        at com.ibm.db2.jcc.am.tp.executeBatch(tp.java:3048)
        at com.oltpbenchmark.benchmarks.tpcc.TPCCLoader.loadOrders(TPCCLoader.java:661)
        at com.oltpbenchmark.benchmarks.tpcc.TPCCLoader$2.load(TPCCLoader.java:120)
        at com.oltpbenchmark.api.Loader$LoaderThread.run(Loader.java:63)
        at com.oltpbenchmark.util.ThreadUtil$LatchRunnable.run(ThreadUtil.java:343)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)
12:23:49,598 (DBWorkload.java:563) INFO  - Finished!
12:23:49,599 (DBWorkload.java:564) INFO  - ======================================================================
12:23:49,601 (DBWorkload.java:598) INFO  - Skipping benchmark workload execution

This is sample_db2tpcc_config.xml:

<?xml version="1.0"?>
<parameters>
   <dbtype>db2</dbtype>
   <driver>com.ibm.db2.jcc.DB2Driver</driver>
   <DBUrl>jdbc:db2:tpcc</DBUrl>
   <username>user</username>
   <password>pwd</password>
   <isolation>TRANSACTION_SERIALIZABLE</isolation>
   <scalefactor>20</scalefactor>
   <terminals>20</terminals>
   <uploadCode></uploadCode>
   <uploadUrl></uploadUrl>

   <works>
      <work>
         <time>300</time>
         <rate>unlimited</rate>
         <weights>45,43,4,4,4</weights>
      </work>
   </works>

   <transactiontypes>
      <transactiontype>
         <name>NewOrder</name>
      </transactiontype>
      <transactiontype>
         <name>Payment</name>
      </transactiontype>
      <transactiontype>
         <name>OrderStatus</name>
      </transactiontype>
      <transactiontype>
         <name>Delivery</name>
      </transactiontype>
      <transactiontype>
         <name>StockLevel</name>
      </transactiontype>
   </transactiontypes>
</parameters>

Do you know what could be the problem?

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant