If you're using Linux, try:
echo "create table t1(a);" |strace ./sqlite3 my.db 2>&1 |less
and examine the output. See where it differs from the successful
tmpfs run.
Newer versions of sqlite3 may have better IO error messages.
> I'm running the command line tool to create sqlite3 db.
> My directory permissions are drwxrwxrwt.
> I'm getting the following error.
>
> > ./sqlite3 newdb
> SQLite version 3.3.12
> Enter ".help" for instructions
> sqlite> create table tbl1(one varchar(10), two smallint);
> SQL error: disk I/O error
>
> If I try the same thing in a tmpfs, it works.
____________________________________________________________________________________Looking
for a deal? Find great prices on flights and hotels with Yahoo! FareChase.
http://farechase.yahoo.com/
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
