Hi all, I see my query hanging with this stack: dybagme->where #0 0x000000332b00ee00 in __fsync_nocancel () from /lib64/libpthread.so.0 #1 0x000000000041b418 in full_fsync (fd=6, fullSync=0, dataOnly=0) at sqlite3.c:27735 #2 0x000000000041b54c in unixSync (id=0x2315650, flags=2) at sqlite3.c:27824 #3 0x0000000000411c7c in sqlite3OsSync (id=0x2315650, flags=2) at sqlite3.c:15816 #4 0x00000000004243c8 in syncJournal (pPager=0x23153f8, newHdr=0) at sqlite3.c:44399 #5 0x0000000000426829 in sqlite3PagerCommitPhaseOne (pPager=0x23153f8, zMaster=0x0, noSync=0) at sqlite3.c:46451 #6 0x000000000042f967 in sqlite3BtreeCommitPhaseOne (p=0x23157b8, zMaster=0x0) at sqlite3.c:54827 #7 0x000000000043da85 in vdbeCommit (db=0x23150c8, p=0x234c548) at sqlite3.c:64185 #8 0x000000000043e48b in sqlite3VdbeHalt (p=0x234c548) at sqlite3.c:64592 #9 0x0000000000443f38 in sqlite3VdbeExec (p=0x234c548) at sqlite3.c:68930 #10 0x0000000000441729 in sqlite3Step (p=0x234c548) at sqlite3.c:66694 #11 0x000000000044191d in sqlite3_step (pStmt=0x234c548) at sqlite3.c:66760 #12 0x000000000047362a in sqlite3_exec (db=0x23150c8, zSql=0x6fa820 <qbuf.10064> "update vms set pm_id=41,pm_name='s_40' where vm_id=161", xCallback=0x0, pArg=0x0, pzErrMsg=0x6f6808 <errmsg>) at sqlite3.c:96874 #13 0x000000000040b830 in db_update_vm_pm (pm=0x232fbf0, vm=0x234a110) at pack.db.c:653 #14 0x000000000040b4fa in db_record_sched_decision (link=0x2328150) at pack.db.c:580 #15 0x000000000040849b in place () at pack.place.c:182 #16 0x00000000004051a5 in try_place () at pack.c:241 #17 0x0000000000405022 in run () at pack.c:184 #18 0x0000000000404d7d in main (argc=1, argv=0x7fffacdedb48) at pack.c:88
it is processing things in a loop and updating. If I do the updates in a transaction it returns no error but the database is not updated. The program itself is in state D waiting for IO. I am writing on a local disk. I don't use threads. What can be wrong? Thanks. David Bigagli _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users