[Date Prev][Date Next] [Chronological] [Thread] [Top]

*prio* SQLightning/LMDB OpenBSD problem: ./sqlite3 fails with "unknown error" on start and sqlite3_open() fails with 2 = SQLITE_INTERNAL. Did I build it incorrectly or do we need to resolve a bug?


On OpenBSD 5.5 AMD64, I compile SQLightning as follows:

git clone https://github.com/LMDB/lmdb.git
cd lmdb
git checkout mdb.RE/0.9
cd libraries/liblmdb
sudo make install
(On Linux: sudo ldconfig)
cd ../../..

git clone https://github.com/LMDB/sqlightning.git
cd sqlightning
git checkout mdb

(trying "make" here complained that "mdb.c" doesn't exist on Linux and that "mdb.h" doesn't exist on OpenBSD, so I fixed this by "cp ../lmdb/libraries/liblmdb/* src/" and then):

make -j2
sudo make install
(On Linux: sudo ldconfig)

I then try the newly built sqlite3 binary:

./sqlite3 /tmp/zz
SQLite version 3.7.17 2013-05-20 00:56:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create table a(b);
Error: unable to open database "/tmp/zz": unknown error

Equally so, sqlite3_open() fails with 2 = SQLITE_INTERNAL , http://www.sqlite.org/rescode.html#internal .

Both SQLightning, LMDB and SQLite are built specifically to work on OpenBSD (except for in the read-only mmap+fwrite()+fsync() mode, how to switch that off or on is beyond my current knowledge).

How fix?


Thank you very much!