Fwd: Re: [Refdb-users] main database is too old or corrupt

[Markus H. <mar...@mh...>]

Hi,
I'm sorry that I didn't get round to look into this lately. A conference and two
deadlines forced me to do what I'm being paid for.

Daniel O'Donnell <dan...@ul...> was heard to say:

> I must be really dumb: I can't find it.
>

You mean the refdb database file? There is no such thing if you use MySQL, so
please don't feel dumb. MySQL has a subdirectory called refdb somewhere that
contains the database files and indexes. I was just asking for someone who uses
SQLite on Debian to send me the file, as this is simpler to analyze. I must have
somehow thought you were using SQLite.

I've received the file from Osvaldo, and it looks ok to me.

> I have the impression reading the lists that there are some real issues
> with the Debian? Would you recommend scrapping it and trying a make
> instead? I'm wondering if the problem might not be that it didn't load
> the mysql drivers?
>

There are problems with Debian, and I'm absolutely sure they can be solved by
building libdbi, libdbi-drivers, and RefDB from the sources. But that's not why
we try to provide packages. I'd like to see the problems with the packages fixed
as this lowers the threshold for new users considerably.

I don't think that RefDB can't load the mysql driver. refdbd will refuse to even
start if it can't load the requested driver. If it can't connect to the MySQL
engine, you'd see a different error ("could not open main database"). The only
way to arrive at the error that you all see is that the query for the database
version fails, or that the version is indeed too old. As we're still at version
1 (older versions were not versioned), the query must fail somehow, or the
result cannot be retrieved or is erroneous for some reason.

If anyone of those affected by this problem is skilled enough to fiddle with the
command line client of his/her database engine, please run the following query
for me (SQLite shown here, other db engines are equivalent):

$ sqlite path/to/refdb
SQLite version 2.8.15
Enter ".help" for instructions
sqlite> .headers ON
sqlite> select * from t_meta;
meta_app|meta_type|meta_version|meta_dbversion|meta_create_date|meta_modify_date

refdb|refdb|0.9.6-pre2|1|2005-10-03 11:38:24|2005-10-03 11:38:24

I'll try to reproduce the error on a Debian box on the weekend. It'll be
considerably easier to fix if I can reproduce it.

regards,
Markus




-- 
Markus Hoenicka
mar...@ca...
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de

----- Ende der weitergeleiteten Nachricht -----


-- 
Markus Hoenicka
mar...@ca...
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de