Mysql Locked Process Hang

2009-05-06 Thread Andrew Carlson
Any ideas about this? It's very aggravating and I have no idea how to debug this any further. Thanks. Hi. I am having a problem with a program I am writing. The program reads a file, checks an object file, and if the record doesn't exist, it inserts to a node table (one table per node) and

Re: Mysql Locked Process Hang

2009-05-06 Thread Brent Baisley
You have 2 queries that are probably blocking everything. They are in the update state. | 30 | root | localhost | bsm | Query | 138 | update | insert into upbcgww03 values(/var/tmp/zypp.067D9R/zypp-trusted-kr9rzhrO,trustdb.gpg,1200,b18a1a | 30 | root | localhost | bsm | Query | 138 |

Mysql Locked Process Hang

2009-05-04 Thread Andrew Carlson
Hi. I am having a problem with a program I am writing. The program reads a file, checks an object file, and if the record doesn't exist, it inserts to a node table (one table per node) and the objects file. I wrote a C program to do this, with multiple processes running at one time. I have 15