REQTIMEOUT in lockstatistics & db deadlocks detection

2004-03-17 Thread Ajit Aranha
Hi, >>Ten thread Odbc (committed) inserting 2 rows a minute into a >>table. Should have been Ten thread Odbc (committed) 2000 rows a minute into a table (2000 total not each) Regards, Ajit -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:

FW: REQTIMEOUT in lockstatistics & db deadlocks detection

2004-03-16 Thread Ajit Aranha
Hi, The scenario under which i have deadlock is the following. (kernel ver 7.3.30 win32) Ten thread Odbc (committed) inserting 2 rows a minute into a table. 1 thread (jdbc TRANSACTION_READ_UNCOMMITTED) doing a select every two minutes. on the table 5 threads running updates that ch

REQTIMEOUT in lockstatistics

2004-03-16 Thread Ajit Aranha
Hi, I'm running 7.3.30 and running into deadlocks. Can someone tell me why REQTIMEOUT can be null (?) in LOCKSTATISTICS TABLE?? My clients (jdbc) block forever or until the db is restarted. regards, Ajit