Project Home
Project Home
Trackers
Trackers
Documents
Documents
Wiki
Wiki
Discussion Forums
Discussions
Project Information
Project Info
Forum Topic - SQLite3 on QNX Neutrino 6.x: (4 Items)
   
SQLite3 on QNX Neutrino 6.x  
Hi, 
We are trying to Port SQLite3 onto QNX Neutrino 6.x based system.
We are receiving a SQL error DISK I/O ERROR on the execution of very first command (sqlite3_exec()) to create a table 
inside a database. Note: The database file was created (sqlite3_open() was successful).

From a similar post on qnx 4 support site we understand that the SQLite should work straight out of the box. Can 
somebody help us by letting us know the necessary macros (for compilation) we should enable.
Re: SQLite3 on QNX Neutrino 6.x  
Has there been any progress on this? I see that sqlite3 is now included in SDP 6.6, however, when I add it to the image,
 I also get this error:

# cd /tmp
# sqlite3 test.sqlite
SQLite version 3.7.14.1 2012-10-26 13:34:05
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> CREATE TABLE Cars(Id INTEGER PRIMARY KEY, Name TEXT, Price INTEGER);
Error: disk I/O error
sqlite> 



This is the content of the image, because I might be missing a library:

   Offset     Size  Name
        0        8  *.boot
        8      100  Startup-header flags1=0xd flags2=0 paddr_bias=0
      108    15008  startup.*
    15110       5c  Image-header mountpoint=/
    1516c     2d90  Image-directory
     ----     ----  Root-dirent
    18000    90000  proc/boot/procnto-instr
    a8000      85c  proc/boot/.script
     ----        e  bin/sh -> /proc/boot/ksh
     ----        9  dev/console -> /dev/ser1
     ----        a  tmp -> /dev/shmem
     ----        4  var/log -> /tmp
     ----        4  usr/tmp -> /tmp
    b0000    8f1fe  proc/boot/libc.so.3
     ----        9  proc/boot/libc.so -> libc.so.3
   140000    22e7f  proc/boot/libm.so.2
     ----        9  proc/boot/libm.so -> libm.so.2
   170000     f732  proc/boot/libcam.so.2
     ----        b  proc/boot/libcam.so -> libcam.so.2
   180000    27b46  proc/boot/io-blk.so
   1a8000     4660  proc/boot/cam-disk.so
   1ad000     55bc  proc/boot/cam-cdrom.so
   1c0000    16602  proc/boot/fs-qnx6.so
   1d7000     d4d1  proc/boot/fs-qnx4.so
   1e5000    128ec  proc/boot/fs-dos.so
   200000    1274c  proc/boot/fs-udf.so
   213000     b6c6  proc/boot/fs-cd.so
   21f000     97fe  proc/boot/devu-dm816x-mg.so
   229000     a65e  proc/boot/libusbdi.so.2
     ----        d  proc/boot/libusbdi.so -> libusbdi.so.2
   234000     89e6  proc/boot/devu-usbumass-am335x-musbmhdrc.so
   23d000     8ae4  proc/boot/devu-usbser-am335x-musbmhdrc.so
   246000     8a95  proc/boot/devu-usbncm-am335x-musbmhdrc.so
   24f000     a523  proc/boot/libusbdci.so.2
     ----        e  proc/boot/libusbdci.so -> libusbdci.so.2
   260000    14c9c  proc/boot/devnp-usbdnet.so
   275000     4f47  proc/boot/spi-dm816x.so
   27a000    11de4  proc/boot/devnp-dm814x-am335x.so
   290000    20d7d  proc/boot/libsocket.so.3
     ----        e  proc/boot/libsocket.so -> libsocket.so.3
   2c0000     52f5  proc/boot/libtracelog.so.1
     ----       10  proc/boot/libtracelog.so -> libtracelog.so.1
   2c6000     5278  proc/boot/libhiddi.so.1
     ----        d  proc/boot/libhiddi.so -> libhiddi.so.1
   2cc000     941c  usr/lib/libdisputil.so.2
     ----       10  usr/lib/libdisputil.so -> libdisputil.so.2
   2d6000     426c  usr/lib/libWFD.so.1
     ----        b  usr/lib/libWFD.so -> libWFD.so.1
   2db000     a36c  usr/lib/libinputevents.so.1
     ----       13  usr/lib/libinputevents.so -> libinputevents.so.1
   2e6000     219b  usr/lib/libkalman.so.1
     ----        e  usr/lib/libkalman.so -> libkalman.so.1
   2e9000     31ed  lib/dll/screen-pvr2d.so
   2ed000     a373  lib/dll/screen-gles2.so
   300000    372d7  usr/lib/graphics/am335x/libsrv_um.so
   338000     726a  usr/lib/graphics/am335x/libpvr2d.so
   340000    191ec  usr/lib/graphics/am335x/pvrsrvinit.so
   360000    3e490  usr/lib/graphics/am335x/pvrsrv.so
   39f000     75f9  usr/lib/graphics/am335x/libWFDam335x-bbb.so
   3a7000     42e1  usr/lib/graphics/am335x/libwfdcfg.so.0
     ----        e  usr/lib/graphics/am335x/libwfdcfg-am335x-bbb.so -> libwfdcfg.so.0
   3ac000      4c9  usr/lib/graphics/am335x/graphics.conf
   3ad000     9b65  usr/lib/libEGL.so.1
     ----        b  usr/lib/libEGL.so -> libEGL.so.1
   3c0000    12338  usr/lib/libscreen.so.1
     ----        e  usr/lib/libscreen.so -> libscreen.so.1
   3e0000     a174  usr/lib/libGLESv1_CM.so.1
     ----       11  usr/lib/libGLESv1_CM.so -> libGLESv1_CM.so.1
 ...
View Full Message
RE: SQLite3 on QNX Neutrino 6.x  
/tmp has to point to an actual filesystem with locking. 

     ----        a  tmp -> /dev/shmem

That not going to do it... You might be able to use TMPDIR to point at something on disk.

________________________________________
From: Sebastian Fischmeister [community-noreply@qnx.com]
Sent: Thursday, July 09, 2015 10:12 AM
To: general-community
Subject: Re: SQLite3 on QNX Neutrino 6.x

Has there been any progress on this? I see that sqlite3 is now included in SDP 6.6, however, when I add it to the image,
 I also get this error:

# cd /tmp
# sqlite3 test.sqlite
SQLite version 3.7.14.1 2012-10-26 13:34:05
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> CREATE TABLE Cars(Id INTEGER PRIMARY KEY, Name TEXT, Price INTEGER);
Error: disk I/O error
sqlite>



This is the content of the image, because I might be missing a library:

   Offset     Size  Name
        0        8  *.boot
        8      100  Startup-header flags1=0xd flags2=0 paddr_bias=0
      108    15008  startup.*
    15110       5c  Image-header mountpoint=/
    1516c     2d90  Image-directory
     ----     ----  Root-dirent
    18000    90000  proc/boot/procnto-instr
    a8000      85c  proc/boot/.script
     ----        e  bin/sh -> /proc/boot/ksh
     ----        9  dev/console -> /dev/ser1
     ----        a  tmp -> /dev/shmem
     ----        4  var/log -> /tmp
     ----        4  usr/tmp -> /tmp
    b0000    8f1fe  proc/boot/libc.so.3
     ----        9  proc/boot/libc.so -> libc.so.3
   140000    22e7f  proc/boot/libm.so.2
     ----        9  proc/boot/libm.so -> libm.so.2
   170000     f732  proc/boot/libcam.so.2
     ----        b  proc/boot/libcam.so -> libcam.so.2
   180000    27b46  proc/boot/io-blk.so
   1a8000     4660  proc/boot/cam-disk.so
   1ad000     55bc  proc/boot/cam-cdrom.so
   1c0000    16602  proc/boot/fs-qnx6.so
   1d7000     d4d1  proc/boot/fs-qnx4.so
   1e5000    128ec  proc/boot/fs-dos.so
   200000    1274c  proc/boot/fs-udf.so
   213000     b6c6  proc/boot/fs-cd.so
   21f000     97fe  proc/boot/devu-dm816x-mg.so
   229000     a65e  proc/boot/libusbdi.so.2
     ----        d  proc/boot/libusbdi.so -> libusbdi.so.2
   234000     89e6  proc/boot/devu-usbumass-am335x-musbmhdrc.so
   23d000     8ae4  proc/boot/devu-usbser-am335x-musbmhdrc.so
   246000     8a95  proc/boot/devu-usbncm-am335x-musbmhdrc.so
   24f000     a523  proc/boot/libusbdci.so.2
     ----        e  proc/boot/libusbdci.so -> libusbdci.so.2
   260000    14c9c  proc/boot/devnp-usbdnet.so
   275000     4f47  proc/boot/spi-dm816x.so
   27a000    11de4  proc/boot/devnp-dm814x-am335x.so
   290000    20d7d  proc/boot/libsocket.so.3
     ----        e  proc/boot/libsocket.so -> libsocket.so.3
   2c0000     52f5  proc/boot/libtracelog.so.1
     ----       10  proc/boot/libtracelog.so -> libtracelog.so.1
   2c6000     5278  proc/boot/libhiddi.so.1
     ----        d  proc/boot/libhiddi.so -> libhiddi.so.1
   2cc000     941c  usr/lib/libdisputil.so.2
     ----       10  usr/lib/libdisputil.so -> libdisputil.so.2
   2d6000     426c  usr/lib/libWFD.so.1
     ----        b  usr/lib/libWFD.so -> libWFD.so.1
   2db000     a36c  usr/lib/libinputevents.so.1
     ----       13  usr/lib/libinputevents.so -> libinputevents.so.1
   2e6000     219b  usr/lib/libkalman.so.1
     ----        e  usr/lib/libkalman.so -> libkalman.so.1
   2e9000     31ed  lib/dll/screen-pvr2d.so
   2ed000     a373  lib/dll/screen-gles2.so
   300000    372d7  usr/lib/graphics/am335x/libsrv_um.so
   338000     726a  usr/lib/graphics/am335x/libpvr2d.so
   340000    191ec  usr/lib/graphics/am335x/pvrsrvinit.so
   360000    3e490  usr/lib/graphics/am335x/pvrsrv.so
   39f000     75f9  usr/lib/graphics/am335x/libWFDam335x-bbb.so
   3a7000     42e1  usr/lib/graphics/am335x/libwfdcfg.so.0
     ----        e  usr/lib/graphics/am335x/libwfdcfg-am335x-bbb.so -> libwfdcfg.so.0
   3ac000      4c9  usr/lib/graphics/am335x/graphics.conf
  ...
View Full Message
Re: RE: SQLite3 on QNX Neutrino 6.x  
Thanks. I changed it so the database writes on a fat32 partition and it's working.

  Sebastian