Re: [sqlite] Disk IO ERROR on AIX

2009-08-07 Thread Ken
--- On Fri, 8/7/09, Dan Kennedy <danielk1...@gmail.com> wrote: > From: Dan Kennedy <danielk1...@gmail.com> > Subject: Re: [sqlite] Disk IO ERROR on AIX > To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> > Date: Friday, August 7, 2009,

Re: [sqlite] Disk IO ERROR on AIX

2009-08-07 Thread Dan Kennedy
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

[sqlite] Disk IO ERROR on AIX

2009-08-07 Thread Kenneth Long
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

Re: [sqlite] Disk IO error on AIX

2006-02-01 Thread Christian Smith
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

Re: [sqlite] Disk IO error on AIX

2006-01-31 Thread Robert Tortajada
[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

Re: [sqlite] Disk IO error on AIX

2006-01-31 Thread drh
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

Re: [sqlite] Disk IO error on AIX

2006-01-31 Thread Robert Tortajada
[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

Re: [sqlite] Disk IO error on AIX

2006-01-31 Thread drh
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,

Re: [sqlite] Disk IO error on AIX

2006-01-31 Thread Robert Tortajada
[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>

Re: [sqlite] Disk IO error on AIX

2006-01-31 Thread drh
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] Disk IO error on AIX

2006-01-31 Thread Robert Tortajada
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