Hi,
I'm struggling to narrow down on what is causing LockAcquisition Exception in my program.
Today I got this exception while reading from a table.
My program connects to a remote db.
More than one process access this db concurrently.
How do I know which process contains the bad code that keeps a table locked and prevent other processes from accessing it?
Although this question might fit into the java section of the forum, my problem is not as much about fixing the java code as to locate the process containing the bad code. I feel people with mysql experience would also be of help since I have barely scratched the surface of mysql. So I'm feeling lost with this exception.
Thanks in advance.
I'm struggling to narrow down on what is causing LockAcquisition Exception in my program.
Today I got this exception while reading from a table.
My program connects to a remote db.
More than one process access this db concurrently.
How do I know which process contains the bad code that keeps a table locked and prevent other processes from accessing it?
Although this question might fit into the java section of the forum, my problem is not as much about fixing the java code as to locate the process containing the bad code. I feel people with mysql experience would also be of help since I have barely scratched the surface of mysql. So I'm feeling lost with this exception.
Thanks in advance.