I recompiled with v 3.8.3.1 and enabled sqlite3_log (lines starting with "LOG:" in output). Result below. Thanks.
validate smartclient appinfo database OPEN name=D:\blp\wintrv\smartclient\applications\appinfo.db, pFile=214C18, flags=106, pOutFlags=12F09C OPEN file=2C, name=D:\blp\wintrv\smartclient\applications\appinfo.db, access=c0000000, rc=ok OPEN file=2C, name=D:\blp\wintrv\smartclient\applications\appinfo.db, access=c0000000, pOutFlags=12F09C, *pOutFlags=2, rc=ok FCNTL file=2C, op=18, pArg=12EE94 FCNTL file=2C, rc=SQLITE_OK FCNTL file=2C, op=18, pArg=12F078 FCNTL file=2C, rc=SQLITE_OK READ file=2C, buffer=12F2C8, amount=100, offset=0, lock=0 READ file=2C, rc=SQLITE_OK FCNTL file=2C, op=15, pArg=214BB8 FCNTL file=2C, rc=SQLITE_NOTFOUND FCNTL file=2C, op=18, pArg=12F044 FCNTL file=2C, rc=SQLITE_OK FCNTL file=2C, op=14, pArg=12EB64 FCNTL file=2C, rc=SQLITE_NOTFOUND LOCK file=2C, oldLock=0(0), newLock=1 READ-LOCK file=2C, lock=0 READ-LOCK file=2C, rc=SQLITE_ERROR LOCK file=2C, lock=1, rc=SQLITE_OK ACCESS name=D:\blp\wintrv\smartclient\applications\appinfo.db-journal, flags=0, pResOut=12DDA8 ACCESS name=D:\blp\wintrv\smartclient\applications\appinfo.db-journal, pResOut=12DDA8, *pResOut=0, rc=SQLITE_OK SIZE file=2C, pSize=12DCB4 SIZE file=2C, pSize=12DCB4, *pSize=1024, rc=SQLITE_OK ACCESS name=D:\blp\wintrv\smartclient\applications\appinfo.db-wal, flags=0, pResOut=12DDB8 ACCESS name=D:\blp\wintrv\smartclient\applications\appinfo.db-wal, pResOut=12DDB8, *pResOut=0, rc=SQLITE_OK SIZE file=2C, pSize=12DDB0 SIZE file=2C, pSize=12DDB0, *pSize=1024, rc=SQLITE_OK READ file=2C, buffer=3DFEC8, amount=1024, offset=0, lock=1 READ file=2C, rc=SQLITE_OK OPEN name=D:\blp\wintrv\smartclient\applications\appinfo.db-wal, pFile=215BD8, flags=80006, pOutFlags=12DD14 OPEN file=30, name=D:\blp\wintrv\smartclient\applications\appinfo.db-wal, access=c0000000, rc=ok OPEN file=30, name=D:\blp\wintrv\smartclient\applications\appinfo.db-wal, access=c0000000, pOutFlags=12DD14, *pOutFlags=2, rc=ok FCNTL file=2C, op=18, pArg=12DD34 FCNTL file=2C, rc=SQLITE_OK OPEN name=D:\blp\wintrv\smartclient\applications\appinfo.db-shm, pFile=3E0398, flags=80006, pOutFlags=0 OPEN file=34, name=D:\blp\wintrv\smartclient\applications\appinfo.db-shm, access=c0000000, rc=ok OPEN file=34, name=D:\blp\wintrv\smartclient\applications\appinfo.db-shm, access=c0000000, pOutFlags=0, *pOutFlags=0, rc=ok SHM-LOCK file=34, lock=3, offset=128, size=1 SHM-LOCK file=34, func=winLockFile, errno=0, rc=SQLITE_OK TRUNCATE file=34, size=0, lock=0 SEEK file=34, offset=0 SEEK file=34, rc=SQLITE_OK TRUNCATE file=34, rc=SQLITE_OK SHM-LOCK file=34, lock=1, offset=128, size=1 SHM-LOCK file=34, func=winUnlockFile, errno=0, rc=SQLITE_OK SHM-LOCK file=34, lock=2, offset=128, size=1 SHM-LOCK file=34, func=winLockFile, errno=0, rc=SQLITE_OK SIZE file=34, pSize=12D74C SIZE file=34, pSize=12D74C, *pSize=0, rc=SQLITE_OK SHM-LOCK file=34, lock=3, offset=120, size=1 SHM-LOCK file=34, func=winLockFile, errno=0, rc=SQLITE_OK SHM-LOCK pid=2776, id=0, sharedMask=000, exclMask=001, rc=SQLITE_OK SIZE file=34, pSize=12D74C SIZE file=34, pSize=12D74C, *pSize=0, rc=SQLITE_OK TRUNCATE file=34, size=32768, lock=0 SEEK file=34, offset=32768 SEEK file=34, rc=SQLITE_OK LOG: os_win.c:33842: (33) winTruncate2(D:\blp\wintrv\smartclient\applications\appinfo.db-shm) - プãƒã‚»ã‚¹ã¯ãƒ•ã‚¡ã‚¤ãƒ«ã«ã‚¢ã‚¯ã‚»ã‚¹ã§ãã¾ã›ã‚“。別ã®ãƒ—ãƒã‚»ã‚¹ãŒãƒ•ã‚¡ã‚¤ãƒ«ã®ä¸€éƒ¨ã‚’ãƒãƒE‚¯ã—ã, extended-result-code: 1546 TRUNCATE file=34, rc=SQLITE_IOERR_TRUNCATE LOG: os_win.c:35002: (33) winShmMap2(D:\blp\wintrv\smartclient\applications\appinfo.db) - プãƒã‚»ã‚¹ã¯ãƒ•ã‚¡ã‚¤ãƒ«ã«ã‚¢ã‚¯ã‚»ã‚¹ã§ãã¾ã›ã‚“。別ã®ãƒ—ãƒã‚»ã‚¹ãŒãƒ•ã‚¡ã‚¤ãƒ«ã®ä¸€éƒ¨ã‚’ãƒãƒE‚¯ã—ã¦ãE, extended-result-code: 4874 SHM-LOCK file=34, lock=1, offset=120, size=1 SHM-LOCK file=34, func=winUnlockFile, errno=0, rc=SQLITE_OK SHM-LOCK pid=2776, id=0, sharedMask=000, exclMask=000, rc=SQLITE_OK LOG: disk I/O error, extended-result-code: 4874 Error occurred-> SQLITE_IOERR[10]: disk I/O error LOCK file=2C, oldLock=1(0), newLock=4 READ-UNLOCK file=2C, lock=1 READ-UNLOCK file=2C, rc=SQLITE_ERROR LOCK file=2C, lock=4, rc=SQLITE_OK SIZE file=34, pSize=12EA4C SIZE file=34, pSize=12EA4C, *pSize=0, rc=SQLITE_OK SIZE file=34, pSize=12EA4C SIZE file=34, pSize=12EA4C, *pSize=0, rc=SQLITE_OK TRUNCATE file=34, size=32768, lock=0 SEEK file=34, offset=32768 SEEK file=34, rc=SQLITE_OK LOG: os_win.c:33842: (33) winTruncate2(D:\blp\wintrv\smartclient\applications\appinfo.db-shm) - プãƒã‚»ã‚¹ã¯ãƒ•ã‚¡ã‚¤ãƒ«ã«ã‚¢ã‚¯ã‚»ã‚¹ã§ãã¾ã›ã‚“。別ã®ãƒ—ãƒã‚»ã‚¹ãŒãƒ•ã‚¡ã‚¤ãƒ«ã®ä¸€éƒ¨ã‚’ãƒãƒE‚¯ã—ã, extended-result-code: 1546 TRUNCATE file=34, rc=SQLITE_IOERR_TRUNCATE LOG: os_win.c:35002: (33) winShmMap2(D:\blp\wintrv\smartclient\applications\appinfo.db) - プãƒã‚»ã‚¹ã¯ãƒ•ã‚¡ã‚¤ãƒ«ã«ã‚¢ã‚¯ã‚»ã‚¹ã§ãã¾ã›ã‚“。別ã®ãƒ—ãƒã‚»ã‚¹ãŒãƒ•ã‚¡ã‚¤ãƒ«ã®ä¸€éƒ¨ã‚’ãƒãƒE‚¯ã—ã¦ãE, extended-result-code: 4874 SHM-PURGE pid=2776, deleteFlag=0 CLOSE file=34 UNMAP-FILE pid=2776, pFile=3E0398, hMap=0, pMapRegion=0, mmapSize=0, mmapSizeActual=0, mmapSizeMax=0 UNMAP-FILE pid=2776, pFile=3E0398, rc=SQLITE_OK CLOSE file=0, rc=ok CLOSE file=30 UNMAP-FILE pid=2776, pFile=215BD8, hMap=0, pMapRegion=0, mmapSize=0, mmapSizeActual=0, mmapSizeMax=0 UNMAP-FILE pid=2776, pFile=215BD8, rc=SQLITE_OK CLOSE file=0, rc=ok UNLOCK file=2C, oldLock=4(0), newLock=0 READ-UNLOCK file=2C, lock=4 READ-UNLOCK file=2C, rc=SQLITE_OK UNLOCK file=2C, lock=0, rc=SQLITE_OK CLOSE file=2C UNMAP-FILE pid=2776, pFile=214C18, hMap=0, pMapRegion=0, mmapSize=0, mmapSizeActual=0, mmapSizeMax=0 UNMAP-FILE pid=2776, pFile=214C18, rc=SQLITE_OK CLOSE file=0, rc=ok OPEN name=D:\blp\wintrv\smartclient\applications\appinfo.backup.db, pFile=214480, flags=106, pOutFlags=12F09C OPEN file=30, name=D:\blp\wintrv\smartclient\applications\appinfo.backup.db, access=c0000000, rc=ok OPEN file=30, name=D:\blp\wintrv\smartclient\applications\appinfo.backup.db, access=c0000000, pOutFlags=12F09C, *pOutFlags=2, rc=ok FCNTL file=30, op=18, pArg=12EE94 FCNTL file=30, rc=SQLITE_OK FCNTL file=30, op=18, pArg=12F078 FCNTL file=30, rc=SQLITE_OK READ file=30, buffer=12F2C8, amount=100, offset=0, lock=0 READ file=30, rc=SQLITE_IOERR_SHORT_READ FCNTL file=30, op=15, pArg=214420 FCNTL file=30, rc=SQLITE_NOTFOUND FCNTL file=30, op=18, pArg=12F044 FCNTL file=30, rc=SQLITE_OK FCNTL file=30, op=14, pArg=12EB64 FCNTL file=30, rc=SQLITE_NOTFOUND LOCK file=30, oldLock=0(0), newLock=1 READ-LOCK file=30, lock=0 READ-LOCK file=30, rc=SQLITE_ERROR LOCK file=30, lock=1, rc=SQLITE_OK ACCESS name=D:\blp\wintrv\smartclient\applications\appinfo.backup.db-journal, flags=0, pResOut=12DDA8 ACCESS name=D:\blp\wintrv\smartclient\applications\appinfo.backup.db-journal, pResOut=12DDA8, *pResOut=0, rc=SQLITE_OK SIZE file=30, pSize=12DCB4 SIZE file=30, pSize=12DCB4, *pSize=0, rc=SQLITE_OK DELETE name=D:\blp\wintrv\smartclient\applications\appinfo.backup.db-wal, syncDir=0 DELETE name=D:\blp\wintrv\smartclient\applications\appinfo.backup.db-wal, rc=SQLITE_IOERR_DELETE_NOENT SIZE file=30, pSize=12DDB0 SIZE file=30, pSize=12DDB0, *pSize=0, rc=SQLITE_OK UNLOCK file=30, oldLock=1(0), newLock=0 READ-UNLOCK file=30, lock=1 READ-UNLOCK file=30, rc=SQLITE_ERROR UNLOCK file=30, lock=0, rc=SQLITE_OK LOCK file=30, oldLock=0(0), newLock=1 READ-LOCK file=30, lock=0 READ-LOCK file=30, rc=SQLITE_ERROR LOCK file=30, lock=1, rc=SQLITE_OK ACCESS name=D:\blp\wintrv\smartclient\applications\appinfo.backup.db-journal, flags=0, pResOut=12DCA0 ACCESS name=D:\blp\wintrv\smartclient\applications\appinfo.backup.db-journal, pResOut=12DCA0, *pResOut=0, rc=SQLITE_OK SIZE file=30, pSize=12DCA8 SIZE file=30, pSize=12DCA8, *pSize=0, rc=SQLITE_OK SIZE file=30, pSize=12DBAC SIZE file=30, pSize=12DBAC, *pSize=0, rc=SQLITE_OK DELETE name=D:\blp\wintrv\smartclient\applications\appinfo.backup.db-wal, syncDir=0 DELETE name=D:\blp\wintrv\smartclient\applications\appinfo.backup.db-wal, rc=SQLITE_IOERR_DELETE_NOENT SIZE file=30, pSize=12DCA8 SIZE file=30, pSize=12DCA8, *pSize=0, rc=SQLITE_OK UNLOCK file=30, oldLock=1(0), newLock=0 READ-UNLOCK file=30, lock=1 READ-UNLOCK file=30, rc=SQLITE_ERROR UNLOCK file=30, lock=0, rc=SQLITE_OK UNLOCK file=30, oldLock=0(0), newLock=0 UNLOCK file=30, lock=0, rc=SQLITE_OK CLOSE file=30 UNMAP-FILE pid=2776, pFile=214480, hMap=0, pMapRegion=0, mmapSize=0, mmapSizeActual=0, mmapSizeMax=0 UNMAP-FILE pid=2776, pFile=214480, rc=SQLITE_OK CLOSE file=0, rc=ok ----- Original Message ----- From: sqlite-users@sqlite.org To: sqlite-users@sqlite.org At: Feb 20 2014 09:49:37 On 02/20/2014 09:29 PM, Akintoye Olorode (BLOOMBERG/ 731 LEXIN) wrote: > 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 ? The operation that is failing is (probaby) an attempt to use SetEndOfFile() to extend the size of the *-shm file to 32KB (from 0KB). I have no idea why it is failing. What version of SQLite is this? Newer versions provide more detail for debugging, particularly if you also turn on sqlite3_log() logging: http://sqlite.org/c3ref/log.html Dan. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
