On Wed, May 29, 2002 at 02:06:19PM +0300, Heikki Tuuri wrote:
> Jeremy,
> 
> it looks like this crash can happen if you use MySQL 'user level locks'
> which are kind of semaphores. In that case MySQL will write a binlog entry
> even after THD::cleanup where the transaction handle is freed.
> 
> >From the manual:
> "You can also solve some cases by using the user-level lock functions
> GET_LOCK() and RELEASE_LOCK()."
> 
> I believe the patch below to ha_innobase.cc fixes the problem.

Ah-ha!  That explains it!  We use GET_LOCK() and RELEASE_LOCK() all
over the place.!

I'll build a new binary in a few hours with your modified function and
test that out.  Thanks a bunch.

Jeremy
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936

MySQL 3.23.51: up 0 days, processed 20,341,584 queries (462/sec. avg)

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to