Project Home
Project Home
Documents
Documents
Wiki
Wiki
Discussion Forums
Discussions
Project Information
Project Info
Forum Topic - QDB Input/Output Error: (2 Items)
   
QDB Input/Output Error  
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
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