Is this the right list for sqlite4 bugs? I have sqlite4 build fde11ff78c433d66 and a largish database. When I drop one of the indices on it through the sqlite4 command line tool, the tool dies with a BUS ERROR. For this database file it reproduces 100% of the time for me. I have the gdb backtrace below. I can share the database but it's quite large so I'd rather not upload it unless someone thinks they can actually make use of it.
1.7G database.db 347M database.db-log 2.0G database.db-shm $ gdb $(which sqlite4) --args sqlite4 databasedb/database.db "drop index idx_followers_main; create index idx_followers_main on followers(hash, next_token, count)" This GDB was configured as "x86_64-apple-darwin"...Reading symbols for shared libraries .. done (gdb) run Starting program: /Users/dking/sync/sqlite4/sqlite4 databasedb/database.db drop\ index\ idx_followers_main\;\ create\ index\ idx_followers_main\ on\ followers\(hash,\ next_token,\ count\) Reading symbols for shared libraries +........................ done Program received signal EXC_BAD_ACCESS, Could not access memory. Reason: 10 at address: 0x00000001f7231004 treeShmalloc (pDb=0x100800008, bAlign=1052536, nByte=40, pRc=0x1f7231000) at lsm_tree.c:683 683 lsm_tree.c: No such file or directory. in lsm_tree.c (gdb) bt #0 treeShmalloc (pDb=0x100800008, bAlign=1052536, nByte=40, pRc=0x1f7231000) at lsm_tree.c:683 #1 0x000000010004b7fe in treeShmallocZero [inlined] () at lsm_tree.c:712 #2 0x000000010004b7fe in newTreeNode [inlined] () at :723 #3 0x000000010004b7fe in treeInsert (pDb=0x7fff5fbfe150, pCsr=0x100100f78, iLeftPtr=1606410576, iTreeKey=1606410576, iRightPtr=2147450820, iSlot=3) at lsm_tree.c:978 #4 0x000000010004b741 in treeInsert (pDb=0x7fff5fbfe1b0, pCsr=0x7fff5fbfe260, iLeftPtr=1606410672, iTreeKey=1606410672, iRightPtr=2147450740, iSlot=3) at lsm_tree.c:939 #5 0x000000010004b741 in treeInsert (pDb=0x7fff5fbfe210, pCsr=0x7fff5fbfe260, iLeftPtr=1606410768, iTreeKey=1606410768, iRightPtr=2147450688, iSlot=3) at lsm_tree.c:939 #6 0x000000010004c115 in treeInsertLeaf [inlined] () at :1052 #7 0x000000010004c115 in treeInsertEntry (pDb=0x7fff5fbfe3e0, flags=1606411232, pKey=0x7fff5fbfe3e0, nKey=1606411232, pVal=0x15, nVal=1606411232) at lsm_tree.c:1557 #8 0x000000010003bb9f in doWriteOp (pDb=0x100800008, bDeleteRange=1606411312, pKey=0x100102a98, nKey=16, pVal=0x7fff5fbfe430, nVal=1606411312) at lsm_main.c:696 #9 0x0000000100031914 in kvlsmDelete (pKVCursor=0x1001032a0) at kvlsm.c:297 #10 0x0000000100030474 in sqlite4KVCursorDelete (p=0x1001032a0) at kv.c:202 #11 0x00000001000092a5 in sqlite4VdbeExec (p=0x100800008) at vdbe.c:3933 #12 0x0000000100064b9a in sqlite4Step [inlined] () at :383 #13 0x0000000100064b9a in sqlite4_step (pStmt=0x1001039f0) at vdbeapi.c:444 #14 0x000000010000322d in shell_exec () at ctype.h:175 #15 0x0000000100001c32 in main (argc=3, argv=0x7fff5fbfe918) at shell.c:2892 (gdb) _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users