LumoSQL / archive1-LumoSQL-on-github

Initial work on SQLite and LMDB integration
https://lumosql.github.io/LumoSQL/
Other
68 stars 14 forks source link

Error during speed test with LMDB 0.9.17 and above #7

Closed maxwell-k closed 4 years ago

maxwell-k commented 4 years ago

After building with LMDB 0.9.18 and following steps in the README: Contents of README have changed, this should still give an idea of the problem, reproduction steps in later comment:

$ git -C sqlightning checkout benchmarking && tclsh sqlightning/tool/speedtest.tcl
✂
<h2>Test 9: INSERTs from a SELECT</h2>
<blockquote>
BEGIN;<br>INSERT INTO t1 SELECT * FROM t2;<br>INSERT INTO t2 SELECT * FROM t1;<br>COMMIT;
</blockquote><table border=0 cellpadding=0 cellspacing=0>
Error: near line 3: database or disk is full
Error: near line 4: cannot commit - no transaction is active
    while executing
"exec ./sqlite3 s2k.db <test9.sql"
    invoked from within
"time "exec ./sqlite3 s2k.db <$sqlfile" 1"
    (procedure "runtest" line 27)
    invoked from within
"runtest {INSERTs from a SELECT}"
    (file "sqlightning/tool/speedtest.tcl" line 198)
$ df -h . /tmp
Filesystem               Size  Used Avail Use% Mounted on
/dev/mapper/fedora-root   69G   35G   31G  54% /run/host/var
fuse-overlayfs           143G   21G  115G  16% /
$ ./sqlite3 --version
3.7.17 a3eb036 LMDB_0.9.18 ad8488c
maxwell-k commented 4 years ago

make LMDB_0.9.17.html or make LMDB_0.9.18.html can also now be used to reproduce.

danshearer commented 4 years ago

Fixed in trunk.