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
