Re: [sqlite] Disk IO ERROR on AIX
--- On Fri, 8/7/09, Dan Kennedy wrote: > From: Dan Kennedy > Subject: Re: [sqlite] Disk IO ERROR on AIX > To: "General Discussion of SQLite Database" > Date: Friday, August 7, 2009, 8:26 AM > > On Aug 4, 2009, at 5:07 AM, Kenneth Long wrote: > > > > > Hi, > > > > I'm getting a Disk I/O error when committing a > transaction on an AIX > > system. > > > > The extended result code is 1290. Which i believe > means that the > > extended code is a SQLITE_IOERR_DIR_FSYNC error. > > > > Any ideas why this is happening or how to track it > down? > > Compile with SQLITE_DISABLE_DIRSYNC for AIX. > > Dan. > > > > Thanks, > > Ken > > Dan, Many thanks. That did the trick!!! ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Disk IO ERROR on AIX
On Aug 4, 2009, at 5:07 AM, Kenneth Long wrote: > > Hi, > > I'm getting a Disk I/O error when committing a transaction on an AIX > system. > > The extended result code is 1290. Which i believe means that the > extended code is a SQLITE_IOERR_DIR_FSYNC error. > > Any ideas why this is happening or how to track it down? Compile with SQLITE_DISABLE_DIRSYNC for AIX. Dan. > Thanks, > Ken > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Disk IO ERROR on AIX
Hi, I'm getting a Disk I/O error when committing a transaction on an AIX system. The extended result code is 1290. Which i believe means that the extended code is a SQLITE_IOERR_DIR_FSYNC error. Any ideas why this is happening or how to track it down? Thanks, Ken ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Disk IO error on AIX
On Tue, 31 Jan 2006 [EMAIL PROTECTED] wrote: >Robert Tortajada <[EMAIL PROTECTED]> wrote: >> > >> The bad return from fsync is -1 so I am not sure that will be helpfull. >> However, couldn't we just disable DIRSYNC since that seems to be the issue? >> > >Yeah. Just disable DIRSYNC. This will slightly increase >the risk of database corruption following a power failure >(the risk is that the journal files name will be lost and >the file itself will be moved into /lost+found). But how >often does that happen, really? Given that any OS today surely does directory manipulation either synchronously, in-order (such as soft updates) or journalled, is this a case that can even occur? Christian -- /"\ \ /ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL X - AGAINST MS ATTACHMENTS / \
Re: [sqlite] Disk IO error on AIX
[EMAIL PROTECTED] wrote: Robert Tortajada <[EMAIL PROTECTED]> wrote: The bad return from fsync is -1 so I am not sure that will be helpfull. However, couldn't we just disable DIRSYNC since that seems to be the issue? Yeah. Just disable DIRSYNC. This will slightly increase the risk of database corruption following a power failure (the risk is that the journal files name will be lost and the file itself will be moved into /lost+found). But how often does that happen, really? -- D. Richard Hipp <[EMAIL PROTECTED]> That did work, thanks for the help. I also noticed that the sqlite3-ruby interface needs a shared library and libsqlite3.a does not work. However, I copied the libsqlite3.so.0 and renamed it and was able to get that to work as well. Thanks again for the help. Bob T
Re: [sqlite] Disk IO error on AIX
Robert Tortajada <[EMAIL PROTECTED]> wrote: > > > The bad return from fsync is -1 so I am not sure that will be helpfull. > However, couldn't we just disable DIRSYNC since that seems to be the issue? > Yeah. Just disable DIRSYNC. This will slightly increase the risk of database corruption following a power failure (the risk is that the journal files name will be lost and the file itself will be moved into /lost+found). But how often does that happen, really? -- D. Richard Hipp <[EMAIL PROTECTED]>
Re: [sqlite] Disk IO error on AIX
[EMAIL PROTECTED] wrote: Robert Tortajada <[EMAIL PROTECTED]> wrote: The following snipit is where the error is generated. #ifndef SQLITE_DISABLE_DIRSYNC if( full_fsync(pFile->dirfd, pFile->fullSync, 0) ){ return SQLITE_IOERR; OK. Good information. We are narrowing down the problem. Now, can you please single-step through the full_fsync() routine and figure out where it is failing. Probably the call to fsync() is returning some kind of error code. If fsync() is not working, please check the value of errno, look up that value in /usr/include/errno.h and let me know what the problem is. -- D. Richard Hipp <[EMAIL PROTECTED]> The bad return from fsync is -1 so I am not sure that will be helpfull. However, couldn't we just disable DIRSYNC since that seems to be the issue?
Re: [sqlite] Disk IO error on AIX
Robert Tortajada <[EMAIL PROTECTED]> wrote: > > > The following snipit is where the error is generated. > > #ifndef SQLITE_DISABLE_DIRSYNC > if( full_fsync(pFile->dirfd, pFile->fullSync, 0) ){ > return SQLITE_IOERR; > OK. Good information. We are narrowing down the problem. Now, can you please single-step through the full_fsync() routine and figure out where it is failing. Probably the call to fsync() is returning some kind of error code. If fsync() is not working, please check the value of errno, look up that value in /usr/include/errno.h and let me know what the problem is. -- D. Richard Hipp <[EMAIL PROTECTED]>
Re: [sqlite] Disk IO error on AIX
[EMAIL PROTECTED] wrote: Robert Tortajada <[EMAIL PROTECTED]> wrote: Hello, I am trying to get sqlite to work on AIX 5.3. It seemed to compile fine and I can access my db file and do selects. However, any kind of update or create will fail with the following error: sunjin:/usr/local> ./bin/sqlite3 gg.db SQLite version 3.3.2 Enter ".help" for instructions sqlite> CREATE TABLE nodes (name TEXT UNIQUE, grouptype INTEGER); SQL error: disk I/O error It is not a file permission issue and in this case it did actually create a zero byte gg.db file. Can you run the program in a debugger and set breakpoints on every line of os_unix.c that might return SQLITE_IOERR. (Use grep -n to find them). Then tell me which of the various I/O errors you are hitting. -- D. Richard Hipp <[EMAIL PROTECTED]> The following snipit is where the error is generated. #ifndef SQLITE_DISABLE_DIRSYNC if( full_fsync(pFile->dirfd, pFile->fullSync, 0) ){ return SQLITE_IOERR;
Re: [sqlite] Disk IO error on AIX
Robert Tortajada <[EMAIL PROTECTED]> wrote: > Hello, I am trying to get sqlite to work on AIX 5.3. It seemed to > compile fine and I can access my db file and do selects. However, any > kind of update or create will fail with the following error: > > sunjin:/usr/local> ./bin/sqlite3 gg.db > SQLite version 3.3.2 > Enter ".help" for instructions > sqlite> CREATE TABLE nodes (name TEXT UNIQUE, grouptype INTEGER); > SQL error: disk I/O error > > It is not a file permission issue and in this case it did actually > create a zero byte gg.db file. > Can you run the program in a debugger and set breakpoints on every line of os_unix.c that might return SQLITE_IOERR. (Use grep -n to find them). Then tell me which of the various I/O errors you are hitting. -- D. Richard Hipp <[EMAIL PROTECTED]>
[sqlite] Disk IO error on AIX
Hello, I am trying to get sqlite to work on AIX 5.3. It seemed to compile fine and I can access my db file and do selects. However, any kind of update or create will fail with the following error: sunjin:/usr/local> ./bin/sqlite3 gg.db SQLite version 3.3.2 Enter ".help" for instructions sqlite> CREATE TABLE nodes (name TEXT UNIQUE, grouptype INTEGER); SQL error: disk I/O error It is not a file permission issue and in this case it did actually create a zero byte gg.db file. The sqlite3 file is small (86k)and I have the LIPPATH set to point to the libraries. I had a large binary (1.3MB) sqlite3 from version 3.1.3 wiich ran fine. but I needed the libraries for Ruby. Any advice, Thanks Bob T