SQL Error: 1205 - Lock exception with a tuned MySQL install

2009-09-22 Thread Grover Blue
I'm trying to get to the bottom of the 1205 exceptions I've been getting. I understand it's a lock, but I don't understand exactly why it's happening and how I can fix (either by recoding, table restructure, or mysql configuration). Also, I should note that I'm a Java developer using JPA, and not

JPA, InnoDB, and locking in multi-threaded app

2009-09-14 Thread Grover Blue
Hi everyone, I have an application that spawns various threads for inserting into various table. Additionally, another thread is launched to delete old records. They all use JPA and entity managed transactions. I think I'm getting locking issues, but I'm not sure. So, I'd like to get your thoug