>>>>> "Patrick" == Patrick Verdon <patrick.verdon@stripped> writes:
Patrick> Hi,
Patrick> I have a serious deadlock problem occurring where
Patrick> mysqld dumps core. I'm making use of LOCK TABLES
Patrick> and I can reproduce the problem every time by
Patrick> clicking the submit button simultaneously on two
Patrick> different browsers (it's a Web application).
Patrick> mysqld dumps core and I get these messages in
Patrick> Apache's error_log:
<cut>
Hi!
Here is a patch for this:
*** /my/monty/master/mysql-3.22.24/sql/lock.cc Sun Apr 4 01:11:53 1999
--- ./lock.cc Thu Aug 5 16:13:47 1999
***************
*** 41,46 ****
--- 41,47 ----
if (thr_multi_lock(sql_lock->locks,sql_lock->lock_count))
{
thd->some_tables_deleted=1; // Try again
+ sql_lock->lock_count=0; // Locks are alread freed
}
else
{
***************
*** 234,240 ****
b->table_count*sizeof(*b->table));
my_free((gptr) a,MYF(0));
my_free((gptr) b,MYF(0));
! return sql_lock;
}
--- 235,241 ----
b->table_count*sizeof(*b->table));
my_free((gptr) a,MYF(0));
my_free((gptr) b,MYF(0));
! DBUG_RETURN(sql_lock);
}
Regards,
Monty
