List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:August 5 1999 1:20pm
Subject:Serious locking problem
View as plain text  
>>>>> "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
Thread
Serious locking problemPatrick Verdon5 Aug
  • Serious locking problemMichael Widenius5 Aug
  • Serious locking problemMichael Widenius5 Aug