Dead lock in graph, that reads data from MySQL

How-to(s), solutions to common problems, pearls of wisdom

avackova
Posts: 841
Joined: Fri Jul 20, 2007 9:28 am

Dead lock in graph, that reads data from MySQL

Postby avackova » Fri Oct 01, 2010 11:25 am

Sometimes graph, that cooperates with MySQL database (DBInputTable, DBJoin, DBLookupTable) hangs up. There is no error, but graph is still running and the number of processed records doesn't change. What can be the cause?
Agata Vackova
Javlin a.s.
agata.vackova@javlin.eu

avackova
Posts: 841
Joined: Fri Jul 20, 2007 9:28 am

Re: Dead lock in graph, that reads data from MySQL

Postby avackova » Fri Oct 01, 2010 11:30 am

The reason is the bug in MySQL jdbc driver (http://bugs.mysql.com/bug.php?id=31353). To avoid the never-ending graph execution set socketTimeout connection property. Then the graph will fail, but it won't run "forever".
Agata Vackova

Javlin a.s.

agata.vackova@javlin.eu