On the second commit I found that the locking_mode=exclusive caused the journal to merly be truncated vs deleted.
I put the locking mode back to normal. It looks like the IOERR_DIR_FSYNC is due to the fact that a MJ journal is not being created! Pragma synchronous=OFF was in effect. The same error also happens when Pragma synchronous=FULL Ken Ken <[EMAIL PROTECTED]> wrote: Ok this is really weird. One sqlite Db functions fine. A second db (connection to a different db) commits and does not delete the journal file. I have verified that data is being written and the journal does indeed have the original blocks. Where in the source does sqlite make the decision to delete the journal? Thanks, Ken Ken wrote: This might be an error on my side since the normal .db handling seems to function ok. The main .db is opened using sync_mode=off. So I shouldn't even get this particular error. I'll dig deeper into this and post more info once I validate the source of the error. John Stanton wrote: On earlier versions of AIX Sqlite has no issues. This problem might not be inherent to AIX V5.3. D. Richard Hipp wrote: > On Jul 14, 2008, at 1:31 PM, Ken wrote: > >> sqlite 3.5.9 and AIX 5.3 >> >> Upon commit of a main DB with an attached DB sqlite returns (1290) >> 0x50A SQLITE_IOERR_DIR_FSYNC >> >> >> what would cause this? Any ideas on how to resolve? > > > SQLite is attempting to fsync() a directory after unlinking the master > journal file from that directory. Apparently AIX does not like you to > call fsync() on a directory. Can you provide us more information on > the capabilities and limitations of AIX in the area of fsync() so that > we can try to figure out what it expects? Perhaps also provide us > with a C preprocessor macro that we can use to conditionally compile > for AIX. > > > D. Richard Hipp > [EMAIL PROTECTED] > > > > _______________________________________________ > 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-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-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
