It seems that rc = fsync(fd); is failing in function
static int full_fsync(int fd, int fullSync, int dataOnly) in file os_unix.c
{
#else /* if !defined(F_FULLSYNC) */
if( dataOnly ){
rc = fdatasync(fd);
}else{
//*********************this call is failing********************
rc = fsync(fd);
}
}
using -DSQLITE_NO_SYNC in the Makefile works
What is the way out for this problem?
What happens if we use this option -DSQLITE_NO_SYNC ?
Thanks
Shilpa
On 5/21/07, Joe Wilson <[EMAIL PROTECTED]> wrote:
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]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
