Unable to access sqlite db

David Nebauer <[email protected]>
Newsgroups gmane.text.refdb.devel
Message-ID <[email protected]>
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.


-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.