*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? - openldap-devel

Saturday, 23 May 2015

Hi!

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
 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
../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 [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

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

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?