[Refdb-devel] Unable to access sqlite db

[David N. <dav...@sw...>]

Hi Markus,

I'm apparently not out of the woods yet with the new debian packages.  
I'm unable to access _any_ of my previously accessible sqlite dbs.  I'm 
running refdb-cvs and the newest libdbi and libdbi drivers (pgsql, mysql 
and sqlite -- sqlite3 is not installed).

Here is the user experience:

---------------------------------------------------------------------------------------------
$ refdbc
not a RefDB database
refdbc: listdb
999:0
refdbc: selectdb experimental
not a RefDB database
refdbc: quit
$
---------------------------------------------------------------------------------------------

Here is what's occurring behind the scenes when attempting to listdb:

---------------------------------------------------------------------------------------------
root@hezmana: /home/david/tmp# refdbd -s -e 0 -l 7
dbi_driver_dir went to:

dbi is up using default driver dir
Available libdbi database drivers:
sqlite
mysql
pgsql
Requested libdbi driver found
Database directory:
/var/lib/refdb/db
application server started
share extended notes by default
use /tmp/refdbd_fifo18594 as fifo
server waiting n_max_fd=4

<!-- start 'refdbc' -->

adding client 127.0.0.1 on fd 5
server waiting n_max_fd=5
try to read from client
serving client on fd 5 with protocol version 4
012-21-75-51
send pseudo-random string to client
parent removing client on fd 5
server waiting n_max_fd=4
selectdb experimental -u david -w 083066087051103076052079126
dbi is up
localhost
david
daviduser


sqlite
/var/lib/refdb/db

refdb
connected to database server using database:
refdb
updated version file:
/var/lib/refdb/db/DB_VERSION
Main database looks ok:
refdb
localhost
david
daviduser


sqlite
/var/lib/refdb/db

refdb
connected to database server using database:
refdb

localhost
david
daviduser


sqlite
/var/lib/refdb/db

experimental
connected to database server using database:
experimental
SELECT meta_app,meta_type,meta_dbversion from t_meta
not a RefDB database
child exited with code 0
server waiting n_max_fd=4

<!-- execute 'listdb' command -->

adding client 127.0.0.1 on fd 5
server waiting n_max_fd=5
try to read from client
serving client on fd 5 with protocol version 4
102-32-57-03
send pseudo-random string to client
parent removing client on fd 5
server waiting n_max_fd=4
listdb  -u david -w 125043087036059035034120070
dbi is up
localhost
david
daviduser


sqlite
/var/lib/refdb/db

refdb
connected to database server using database:
refdb
updated version file:
/var/lib/refdb/db/DB_VERSION
Main database looks ok:
refdb
localhost
david
daviduser


sqlite
/var/lib/refdb/db

refdb
connected to database server using database:
refdb

localhost
david
daviduser


sqlite
/var/lib/refdb/db

refdb
connected to database server using database:
refdb
SELECT meta_app,meta_type,meta_dbversion from t_meta
localhost
david
daviduser


sqlite
/var/lib/refdb/db

refs_computing
connected to database server using database:
refs_computing
SELECT meta_app,meta_type,meta_dbversion from t_meta
localhost
david
daviduser


sqlite
/var/lib/refdb/db

experimental
connected to database server using database:
experimental
SELECT meta_app,meta_type,meta_dbversion from t_meta
localhost
david
daviduser


sqlite
/var/lib/refdb/db

Testcase
connected to database server using database:
Testcase
SELECT meta_app,meta_type,meta_dbversion from t_meta
An invalid or out-of-range index was passed to libdbi
command processing done, finish dialog now
child finished client on fd 5
child exited with code 0
server waiting n_max_fd=4
server exited gracefully
---------------------------------------------------------------------------------------------

Here is proof that there is nothing wrong with database 'experimental':

---------------------------------------------------------------------------------------------
# pwd
/var/lib/refdb/db
# sqlite experimental
SQLite version 2.8.16
Enter ".help" for instructions
sqlite> SELECT meta_app,meta_type,meta_dbversion from t_meta;
refdb|risx|1
sqlite> .quit
#

---------------------------------------------------------------------------------------------

I've no idea where to go from here in troubleshooting.  Any suggestions 
gratefully appreciated.

Regards,
David.