Hi all, I am using sqlite 3.3.15 version in my setup on Solaris 10 SPARC machine. sqlite_exec function is hanging suddenly in the middle while retrieveing rows from a table. I am able to reproduce this very frequently. I did not understand why it is hanging for 30 to 40 mins without throwing any error. I dint get clues even after using sqlite3_trace and sqlite3_profile. Sqlite3_busy_handle also did not work. When I looked at the process stack I saw below stack traces:
Stack trace 1: fe3d4390 _malloc_unlocked (30, 0, 260790, fe46cbc0, e41170, 0) + 230 fe3d4144 malloc (2a, 1, 94184, acd67fac, fe468284, fe4709b0) + 4c acd67fac sqlite3GenericMalloc (2a, 1310a45, 0, 62, 260798, 0) + c acd75408 sqlite3MallocRaw (2a, 1, 16b2870, 2a, 0, fb6fa030) + 48 acdf7b94 sqlite3VdbeExec (12444d8, 1, 1, 0, ad0405e2, c00) + 313c acd78b00 sqlite3Step (12444d8, ad0262c4, 1f430, 1, e10d90, fb6fa480) + 2a8 acd78d30 sqlite3_step (12444d8, 2, 16f29e0, 16f29d8, fb6fa514, c00) + 18 acd8a530 sqlite3_exec (e32f58, 10b6ec8, acd5e260, fb6fa63c, fb6fa6ec, 0) + 170 Stack trace 2: acdb3ca4 parseCellPtr (13101e0, 13101b9, 1314b58, 493, 0, e23938) + 184 acdb3e28 parseCell (13101e0, 0, 1314b58, fe46cbc0, fdee9c00, 1000) + 38 acdb8004 getCellInfo (1314b38, 1, 94184, acd67fac, fe468284, fe4709b0) + 3c acdb8730 fetchPayload (1314b38, fb6f9c00, 0, 62, 113aaf0, 0) + 20 acdb92e8 sqlite3BtreeMoveto (1314b38, 113aaf0, 0, 2a, 0, fb6fa030) + 290 acdf8fbc sqlite3VdbeExec (12444d8, 1, 1, 0, ad0405e2, c00) + 4564 acd78b00 sqlite3Step (12444d8, ad0262c4, 1f430, 1, e10d90, fb6fa480) + 2a8 acd78d30 sqlite3_step (12444d8, 2, 16f29e0, 16f29d8, fb6fa514, c00) + 18 acd8a530 sqlite3_exec (e32f58, 10b6ec8, acd5e260, fb6fa63c, fb6fa6ec, 0) + 170 Stack trace 3: acdf7244 sqlite3VdbeExec (12444d8, 1, 1, 0, ad0405e2, c00) + 27ec acd78b00 sqlite3Step (12444d8, ad0262c4, 1f430, 1, e10d90, fb6fa480) + 2a8 acd78d30 sqlite3_step (12444d8, 2, 16f29e0, 16f29d8, fb6fa514, c00) + 18 acd8a530 sqlite3_exec (e32f58, 10b6ec8, acd5e260, fb6fa63c, fb6fa6ec, 0) + 170 StackTrace 4 acd753d4 sqlite3MallocRaw (2a, 1, 16b2870, 2a, 0, fb6fa030) + 14 acdf7b94 sqlite3VdbeExec (12444d8, 1, 1, 0, ad0405e2, c00) + 313c acd78b00 sqlite3Step (12444d8, ad0262c4, 1f430, 1, e10d90, fb6fa480) + 2a8 acd78d30 sqlite3_step (12444d8, 2, 16f29e0, 16f29d8, fb6fa514, c00) + 18 acd8a530 sqlite3_exec (e32f58, 10b6ec8, acd5e260, fb6fa63c, fb6fa6ec, 0) + 170 Most of the time I saw sqlite3_exec function is hanging at *sqlite3VdbeExec*function. Any ideas about what can be the problem or how to debug? Thanks Haki _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
