Our client got the following print-out. First hint of failure is the line "TRUNCATE 48 32768 failed". Any insights into what the root cause might be ?
OPEN 40 D:\blp\wintrv\smartclient\applications\appinfo.db 0xc0000000 ok READ 40 lock=0 LOCK 40 1 was 0(0) READ 40 lock=1 OPEN 44 D:\blp\wintrv\smartclient\applications\appinfo.db-wal 0xc0000000 ok OPEN 48 D:\blp\wintrv\smartclient\applications\appinfo.db-shm 0xc0000000 ok SHM-LOCK 48 ok LockFileEx 0x00000000 TRUNCATE 48 0 TRUNCATE 48 0 ok SHM-LOCK 48 ok UnlockFileEx 0x00000000 SHM-LOCK 48 ok LockFileEx 0x00000000 SHM-LOCK 48 ok LockFileEx 0x00000000 SHM-LOCK shmid-0, pid-7308 got 000,001 ok TRUNCATE 48 32768 TRUNCATE 48 32768 failed SHM-LOCK 48 ok UnlockFileEx 0x00000000 SHM-LOCK shmid-0, pid-7308 got 000,000 ok Error occurred-> SQLITE_IOERR[10]: disk I/O error LOCK 40 4 was 1(0) unreadlock = 1 TRUNCATE 48 32768 TRUNCATE 48 32768 failed CLOSE 48 CLOSE 48 ok CLOSE 44 CLOSE 44 ok UNLOCK 40 to 0 was 4(0) CLOSE 40 CLOSE 40 ok OPEN 44 D:\blp\wintrv\smartclient\applications\appinfo.backup.db 0xc0000000 ok READ 44 lock=0 LOCK 44 1 was 0(0) DELETE "D:\blp\wintrv\smartclient\applications\appinfo.backup.db-wal" failed UNLOCK 44 to 0 was 1(0) LOCK 44 1 was 0(0) DELETE "D:\blp\wintrv\smartclient\applications\appinfo.backup.db-wal" failed UNLOCK 44 to 0 was 1(0) UNLOCK 44 to 0 was 0(0) CLOSE 44 CLOSE 44 ok Thanks, Akintoye ----- Original Message ----- From: Akintoye Olorode (BLOOMBERG/ 731 LEXIN) To: sqlite-users@sqlite.org At: Jan 30 2014 10:52:17 Thanks, will try this suggestions and post results. - Akintoye ----- Original Message ----- From: sqlite-users@sqlite.org To: sqlite-users@sqlite.org At: Jan 30 2014 10:44:45 On 01/30/2014 10:19 PM, Akintoye Olorode (BLOOMBERG/ 731 LEXIN) wrote: > Hi, > > We have one client that recently upgraded from WinXP SP3 to Win7 sp1 > (Japanese Language). With new OS, attempts to access read from our sqlite > database fails with disk I/O error. > > Can anyone help with suggestions on how to troubleshoot disk I/O error ? > Adding call to sqlite3_config(SQLITE_CONFIG_LOG, ...) produces no additional > information. > > We have not been able to reproduce the error in-house.The user has HP ENVY > laptop with hybrid drive. User has tried : > > 1. Install latest file system drivers > 2. reformat the hard-drive & reinstall Win7 OS > > > all to no avail. Client does not report problems with any other applications. Immediately after the error occurs, what value is returned by the sqlite3_extended_errcode() function? Often the extended error code identifies the specific IO operation that failed, which can shed light on the problem. Another thing to do is to try compiling with the following defines: -DSQLITE_DEBUG=1 -DSQLITE_DEBUG_OS_TRACE=1 This causes the Windows VFS module to print various messages to standard output that should help to figure out what is happening. Dan. _______________________________________________ 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
