--- 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,
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
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
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
[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
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
[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
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,
[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>
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
>
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
11 matches
Mail list logo