Identity Manager (Waveset) and MySQL 4.1.7

Just in case anyone else runs into this problem…..

I was getting a JDBC error (deadlock) when trying to import the initial sample/init.xml file into Identity Manager.

This was with MySQL 4.1.7.

The solution was to revert back to the old innodb table locking behavior.

Put this in your my.cnf file (or my.ini if you are on Windows):


innodb_table_locks=0


More information can be found here:
http://dev.mysql.com/doc/mysql/en/Innodb_deadlocks.html