oltpbench icon indicating copy to clipboard operation
oltpbench copied to clipboard

Running AuctionMark database partially works, but produces a long list of exceptions

Open arunmarathe opened this issue 6 years ago • 0 comments

Running AuctionMark on Linux/MySQL sort of works partially, but there is a long list of exceptions of the following sort.

Thanks, Arun

12:18:36,989 (Worker.java:495) WARN - The DBMS rejected the transaction without an error code com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '72058693549622084-4677-1099511694148-66372' for key 'PRIMARY' at sun.reflect.GeneratedConstructorAccessor9.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1040) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2734) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2375) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2359) at com.oltpbenchmark.benchmarks.auctionmark.procedures.NewPurchase.run(NewPurchase.java:203) at com.oltpbenchmark.benchmarks.auctionmark.AuctionMarkWorker.executeNewPurchase(AuctionMarkWorker.java:836) at com.oltpbenchmark.benchmarks.auctionmark.AuctionMarkWorker.executeWork(AuctionMarkWorker.java:392) at com.oltpbenchmark.api.Worker.doWork(Worker.java:386) at com.oltpbenchmark.api.Worker.run(Worker.java:296) at java.lang.Thread.run(Thread.java:748)

arunmarathe avatar Mar 27 '19 16:03 arunmarathe