benchbase
benchbase copied to clipboard
Overflow exception on converting to BIGINT for SqlServer on Auctionmark and SEATS benchmarks
Error: 2023-03-23 19:[31](https://github.com/cmu-db/benchbase/actions/runs/4504433120/jobs/7928903713?pr=264#step:11:32):12,567 [Thread-0] com.oltpbenchmark.util.ThreadUtil run - Exception in Loader Thread with message: [Unexpected error while generating table data for 'global_attribute_group']; will count down latch with count 15 and then exit :(
java.lang.RuntimeException: Unexpected error while generating table data for 'global_attribute_group'
at com.oltpbenchmark.benchmarks.auctionmark.AuctionMarkLoader$AbstractTableGenerator.load(AuctionMarkLoader.java:375)
at com.oltpbenchmark.benchmarks.auctionmark.AuctionMarkLoader$CountdownLoaderThread.load(AuctionMarkLoader.java:145)
at com.oltpbenchmark.api.LoaderThread.run(LoaderThread.java:45)
at com.oltpbenchmark.util.ThreadUtil$LatchRunnable.run(ThreadUtil.java:145)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.base/java.lang.Thread.run(Thread.java:8[33](https://github.com/cmu-db/benchbase/actions/runs/4504433120/jobs/7928903713?pr=264#step:11:34))
Caused by: java.sql.BatchUpdateException: Arithmetic overflow error converting expression to data type bigint.
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:2181)
at com.oltpbenchmark.benchmarks.auctionmark.AuctionMarkLoader.generateTableData(AuctionMarkLoader.java:233)
at com.oltpbenchmark.benchmarks.auctionmark.AuctionMarkLoader$AbstractTableGenerator.load(AuctionMarkLoader.java:[37](https://github.com/cmu-db/benchbase/actions/runs/4504433120/jobs/7928903713?pr=264#step:11:38)3)
... 6 more
Error: 2023-03-23 19:31:23,334 [Thread-1] com.oltpbenchmark.util.ThreadUtil run - Exception in Loader Thread with message: [Failed to load data files for scaling-sized table 'customer']; will count down latch with count 6 and then exit :(
java.lang.RuntimeException: Failed to load data files for scaling-sized table 'customer'
at com.oltpbenchmark.benchmarks.seats.SEATSLoader.loadScalingTable(SEATSLoader.java:495)
at com.oltpbenchmark.benchmarks.seats.SEATSLoader$6.load(SEATSLoader.java:256)
at com.oltpbenchmark.api.LoaderThread.run(LoaderThread.java:45)
at com.oltpbenchmark.util.ThreadUtil$LatchRunnable.run(ThreadUtil.java:145)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.base/java.lang.Thread.run(Thread.java:833)
Caused by: java.lang.RuntimeException: Failed to load table customer
at com.oltpbenchmark.benchmarks.seats.SEATSLoader.loadTable(SEATSLoader.java:641)
at com.oltpbenchmark.benchmarks.seats.SEATSLoader.loadScalingTable(SEATSLoader.java:493)
... 6 more
Caused by: java.sql.BatchUpdateException: Arithmetic overflow error converting expression to data type bigint.
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:2181)
at com.oltpbenchmark.benchmarks.seats.SEATSLoader.loadTable(SEATSLoader.java:6[29](https://github.com/cmu-db/benchbase/actions/runs/4504433120/jobs/7929007892?pr=264#step:11:30))
... 7 more