Gilles Roy
|
Re: QDB Input/Output Error
|
Gilles Roy
09/07/2010 11:11 AM
post66141
|
Re: QDB Input/Output Error
This bug is old (2006/2007) all Sqlite libraries used by QNX should have the
fix.
I think we would have to see the QDB logs to get more information. Simply
the output of sloginfo might help, but even better would be if you started
QDB with -o profile -vvvvvv (among the other options). Then in a telnet
window start sloginfo -w (log the output) and then reproduce your issue.
Post the output of sloginfo afterwards.
Regards,
Gilles
On 10-09-07 10:58 AM, "Tysen Moore" <community-noreply@qnx.com> wrote:
> I'm seeing some errors when doing simple QDB requests. I am seeing
> ³Input/Output error², code 5. This is a simple database with a simple query.
> I¹ve read from the QDB documentation that these are actually SQLite error
> messages coming from QDB. I¹ve also seen that a bug exists in SQLite which
> can erroneously cause this error: https://issues.rpath.com/browse/RPL-1729. I
> was wondering if anyone had more information on the possible cause for this
> error? Also, what version of SQLite does QDB use? This problem is creating a
> lot of problems because critical data is not reliably returned from QDB. Any
> added information you could give would be much appreciated. As always thanks
> for the time and help.
>
> The Query made is similar to:
> SELECT value FROM keyvalueTbl WHERE key = 'CurrentStr';
>
> The database is configured as:
> [keyvalue]
> Filename = /fs/etfs/usr/share/misc/keyvalue
> Base Schema = /etc/keyvalue.sql
> Data Schema = /etc/keyvalue_data.sql
> Compression = bzip
>
> # use -i qdb
> NAME=qdb
> DESCRIPTION=QNX SQL Database Server
> DATE=2010/04/26-18:05:44-EDT
> STATE=stable
> HOST=spare1
> USER=builder
> VERSION=20.21
> TAGID=3336@295193
>
> # use -i /usr/lib/libsqlite3.so.1
> NAME=libsqlite3.so
> DESCRIPTION=SQLite Library
> DATE=2010/04/26-15:51:08-EDT
> STATE=stable
> HOST=spare1
> USER=builder
> VERSION=20.21
> TAGID=3336@295193
>
> # use -i /usr/lib/libsqlite3.so
> NAME=libsqlite3.so
> DESCRIPTION=SQLite Library
> DATE=2010/04/26-15:51:08-EDT
> STATE=stable
> HOST=spare1
> USER=builder
> VERSION=20.21
> TAGID=3336@295193
>
_______________________________________________
General
http://community.
> qnx.com/sf/go/post66140
|
|
|