BigInteger to Long casting error while loading or running a benchmark

[arunmarathe]

When loading a data into tpcc database, I am getting this error.

I tried to sidestep the error by loading the tpcc data from an existing instance, and was hoping the error would go away. But now while executing the tpcc benchmark, I am getting the same error about BigInteger to Long casting failing.

Is this a well-known issue with a simple solution?

Thanks, Arun

[root@vm-arunm oltpbench]# ./oltpbenchmark -b tpcc -c config/sample_tpcc_config.xml --execute=true -s 5 -o outputfile
11:44:25,330 (DBWorkload.java:262) INFO  - ======================================================================

Benchmark:     TPCC {com.oltpbenchmark.benchmarks.tpcc.TPCCBenchmark}
Configuration: config/sample_tpcc_config.xml
Type:          MYSQL
Driver:        com.mysql.jdbc.Driver
URL:           jdbc:mysql://127.0.0.1:3306/tpcc
Isolation:     TRANSACTION_READ_COMMITTED
Scale Factor:  2.0

11:44:25,332 (DBWorkload.java:263) INFO  - ======================================================================
11:44:25,345 (DBWorkload.java:820) INFO  - Creating 20 virtual terminals...
java.lang.RuntimeException: Failed to connect to database
        at com.oltpbenchmark.api.Worker.<init>(Worker.java:91)
        at com.oltpbenchmark.benchmarks.tpcc.TPCCWorker.<init>(TPCCWorker.java:56)
        at com.oltpbenchmark.benchmarks.tpcc.TPCCBenchmark.createTerminals(TPCCBenchmark.java:123)
        at com.oltpbenchmark.benchmarks.tpcc.TPCCBenchmark.makeWorkersImpl(TPCCBenchmark.java:57)
        at com.oltpbenchmark.api.BenchmarkModule.makeWorkers(BenchmarkModule.java:244)
        at com.oltpbenchmark.DBWorkload.runWorkload(DBWorkload.java:821)
        at com.oltpbenchmark.DBWorkload.main(DBWorkload.java:574)
Caused by: java.sql.SQLException: java.lang.ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
        at com.mysql.jdbc.ConnectionImpl.buildCollationMapping(ConnectionImpl.java:1041)
        at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3496)
        at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2460)
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2230)
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:813)
        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        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.ConnectionImpl.getInstance(ConnectionImpl.java:399)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:334)
        at java.sql.DriverManager.getConnection(DriverManager.java:664)
        at java.sql.DriverManager.getConnection(DriverManager.java:247)
        at com.oltpbenchmark.api.BenchmarkModule.makeConnection(BenchmarkModule.java:120)
        at com.oltpbenchmark.api.Worker.<init>(Worker.java:81)
        ... 6 more
Caused by: java.lang.ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long
        at com.mysql.jdbc.ConnectionImpl.buildCollationMapping(ConnectionImpl.java:992)
        ... 22 more
11:44:25,582 (DBWorkload.java:825) INFO  - Launching the TPCC Benchmark with 1 Phase...
11:44:25,587 (ThreadBench.java:327) INFO  - PHASE START :: [Workload=TPCC] [Serial=false] [Time=300] [WarmupTime=0] [Rate=10000] [Arrival=REGULAR] [Ratios=[45.0, 43.0, 4.0, 4.0, 4.0]] [ActiveWorkers=20]
11:44:25,587 (ThreadBench.java:478) INFO  - MEASURE :: Warmup complete, starting measurements.