postgresnosql load issue

[akkinenivijay]

Hi,

I have been trying to benchmark postgresnosql use case and been running into issues when using multiple threads. The load only works with single thread .

The command below raises Duplicate key exception ./bin/ycsb load postgrenosql -P workloads/workloadb -P postgrenosql-binding/conf/postgrenosql.properties -s -target 500 -threads 16

[Thread-5] ERROR site.ycsb.postgrenosql.PostgreNoSQLDBClient - Error in processing insert to table: usertable: org.postgresql.util.PSQLException: ERROR: duplicate key value (ycsb_key)=('user3232700585171816769') violates unique constraint "primary"

Any pointers on why would be very helpful.

[wtflanders]

I have the same problem... if I use 8 threads then only 12500 records get inserted on load before it fails. FYI.

[Adam-sturesson]

Has this issue been resolved yet? I am trying to use multiple threads as well and it is not working out for me at the moment! Thankful for answers! :D

[kazzasticc]

@akkinenivijay has the issue been resolved?

[AmshuRao]

This means You are trying to insert the the same YCSB key into the database. solution : delete all the things inside the database before running different workload. For example if you created a database named test and table named usertable inside the test database, then go to that database using the command delete from usertable.