Re: Cannot add reference.

Wei-Wei Guo writes:
 > The new refdbd.log has 'ulonglong' now. I should restart refdbd before run
 > the test procedure.

Yes, it is all too easy to forget this. Maybe I should have mentioned
it.

Your log indicates that this is apparently not a RefDB problem, but a
problem of the libdbi driver which you use to access the SQLite
database. We (that is, a few libdbi developers and myself) came across
a platform-dependent problem with the sqlite and sqlite3 drivers just
the other day. In a nutshell, these drivers do not handle 8 byte
integers correctly on Linux, returning 0 instead of the real
value. This is what your logs indicate as well. The id value returned
by this query:

7:pid=3251:Wed May 06 10:55:45 2009:SELECT note_id, note_user_id FROM t_note WHERE note_key='wwguo-wwguo'
7:pid=3251:Wed May 06 10:55:45 2009:ulonglong: u 0<< lu 0<< llu 0

ought to be 1, which you already confirmed by running this query in
the sqlite command line app. However, the driver returns 0 as
indicated by the debug log output.

I'll investigate this driver problem in the next days. I'll let you
know as soon as there are good news. Also, feel free to watch the
libdbi-drivers-devel list for further news
(http://sourceforge.net/mailarchive/forum.php?forum_name=libdbi-drivers-devel).

Unfortunately, at this time there are only two options to get RefDB up
and running: use FreeBSD (or any other OS not affected by this bug),
or use a different database engine.

regards,
Markus


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

------------------------------------------------------------------------------
The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
production scanning environment may not be a perfect world - but thanks to
Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700
Series Scanner you'll get full speed at 300 dpi even with all image 
processing features enabled. http://p.sf.net/sfu/kodak-com