Query hung. Any help. (sqlite & dbi)
SQLite version 3.7.2 built on
This is perl, v5.8.8 built for x86_64-linux-thread-multi
DBI 1.611
DBD::SQLite 1.29
Centos Linux(2.6.18-164.11.1.el5xen) 64bit.
Below are output snippets from two dbi trace files. In the first snippet, the
sqlite.db is "smallish", in the second snippet, the sqlite.db is "larger".
The code executing the query is the same, the only difference in the actual
data, and size of the sqlite.db files.
For a smallish sqlite.db file(1,302,528 bytes)...
sqlite trace: prepare statement: SELECT COUNT(*) FROM link LEFT OUTER JOIN node
ON node.pvid = link.ref_node_pvid WHERE link.ref_node_pvid != -1 AND
link.ref_node_pvid != -2 AND node.pvid IS NULL; at dbdimp.c line 425
<- prepare= DBI::st=HASH(0x1365a490) at mysubs.pm line 5376 via at
mysubs.pm line 10007
>> execute DISPATCH (DBI::st=HASH(0x1365a490) rc1/1 @1 g0 ima1041
pid#31160) at mysubs.pm line 5379 via at mysubs.pm line 10007
-> execute for DBD::SQLite::st (DBI::st=HASH(0x1365a490)~0x135cdd20)
thr#10ae0010
sqlite trace: executing SELECT COUNT(*) FROM link LEFT OUTER JOIN node ON
node.pvid = link.ref_node_pvid WHERE link.ref_node_pvid != -1 AND
link.ref_node_pvid != -2 AND node.pvid IS NULL; at dbdimp.c line 477
sqlite trace: Execute returned 1 cols at dbdimp.c line 596
sqlite trace: exec ok - 0 rows, 1 cols at dbdimp.c line 621
For a larger sqlite.db file(7,553,024 bytes)...
sqlite trace: prepare statement: SELECT COUNT(*) FROM link LEFT OUTER JOIN node
ON node.pvid = link.ref_node_pvid WHERE link.ref_node_pvid != -1 AND
link.ref_node_pvid != -2 AND node.pvid IS NULL; at dbdimp.c line 425
<- prepare= DBI::st=HASH(0x1eedc5e0) at mysubs.pm line 5376 via at
mysubs.pm line 10007
>> execute DISPATCH (DBI::st=HASH(0x1eedc5e0) rc1/1 @1 g0 ima1041
pid#31307) at mysubs.pm line 5379 via at mysubs.pm line 10007
-> execute for DBD::SQLite::st (DBI::st=HASH(0x1eedc5e0)~0x1eee58a0)
thr#1c36b010
sqlite trace: executing SELECT COUNT(*) FROM link LEFT OUTER JOIN node ON
node.pvid = link.ref_node_pvid WHERE link.ref_node_pvid != -1 AND
link.ref_node_pvid != -2 AND node.pvid IS NULL; at dbdimp.c line 477
sqlite trace: Execute returned 1 cols at dbdimp.c line 596
(* at this point the application is hung)
Does anyone have any idea what is going on here?
Thanks in advance.
Jack
The information contained in this communication may be CONFIDENTIAL and is
intended only for the use of the recipient(s) named above. If you are not the
intended recipient, you are hereby notified that any dissemination,
distribution, or copying of this communication, or any of its contents, is
strictly prohibited. If you have received this communication in error, please
notify the sender and delete/destroy the original message and any copy of it
from your computer or paper files.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
