ROCKSDB Failed to acquire lock due to rocksdb_max_row_locks

Question

I´m trying to load a .csv in to my rocksdb database, but it fails and show me this error:

Got error 10 'Operation aborted:Failed to acquire lock due to rocksdb_max_row_locks limit' from ROCKSDB

I've tried with SET SESSION rocksdb_max_row_locks=1073741824; but same error always.

Anyone can help me?

user_1040618 · Answer

This should do the trick (before starting the insert)

SET session rocksdb_bulk_load=1;