pmwkaa / ioarena

Embedded storage benchmarking tool
Other
134 stars 24 forks source link

sqlite3: `set` test with `lazy` durability produces an error #37

Open mardy opened 6 years ago

mardy commented 6 years ago
./src/ioarena -m lazy -D sqlite3 -v 2048 -B set -n 10000
IOARENA (embedded storage benchmarking)

configuration:
  engine       = sqlite3
  datadir      = ./_ioarena
  benchmark    = set
  durability   = lazy
  wal          = indef
  operations   = 10000
  key size     = 16
  value size   = 2048
  binary       = no
  batch length = 500
  continuous   = no

key-gen: using 16 bits, up to 10000 keys
doer.0: {set}, key-space 0, key-sequence 0
execution failed, error: UNIQUE constraint failed: benchmark_t.key
error: ia_sqlite3_next, set, (null)
er0p commented 6 years ago

Hi Mardy, I take a look at this issue soon.

mardy commented 6 years ago

Thanks! I found out that if I remove the DB file _ioarena/sqlite3/test.sqlite left over from previous runs, then it works. So it's not such a critical issue (maybe ioarena could delete all files under _ioarena on startup?).