Discussion:
*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?
Tinker
2015-05-23 09:14:16 UTC
Permalink
Hi!
git clone https://github.com/LMDB/lmdb.git
cd lmdb
git checkout mdb.RE/0.9
cd libraries/liblmdb
make
sudo make install
(On Linux: sudo ldconfig)
cd ../../..
git clone https://github.com/LMDB/sqlightning.git
cd sqlightning
git checkout mdb
./configure
(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
make -j2
sudo make install
(On Linux: sudo ldconfig)
./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 [1] .

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!
Tinker



Links:
------
[1] http://www.sqlite.org/rescode.html#internal

Loading...