Re: Thread freezes on SLAVE START/STOP

[Guilhem Bichot]

>         A  thread  in  which SLAVE START/STOP was issued freezes. E.g.
>         'mysql'  can  be  only  exited  by  pressing Ctrl-C. Actually,
>         only first command is executed. Next are ignored.
>         Sideeffects  tends to be table files corruption, 'master.info'
>         erase.
>         Now (4.0.11) they freeze even after server full restart.
>         We tried different mysql versions: 4.0.7, 4.0.8, 4.0.11
>
> >How-To-Repeat:
>
>         The  exact  conditions  are  unknown.  Sometimes they work. It
>         looks  like  fault  happens after any replication error. (E.g.
>         table update error). But I'm not sure.
>
> >Release:       mysql-4.0.11-gamma-standard (Official MySQL-standard
> > binary)
>         System:  FreeBSD  dev.fotki.com  4.7-STABLE FreeBSD 4.7-STABLE

Hi,

I believe you. But to investigate this, I need a proper How-to-Repeat :
please try to find a repeatable sequence of commands that always cause
the hang, then send them to bugs@stripped together with the .err
files from your master and slave (these contain the error messages,
crucial info to understand what is happening).
Please also tell me under which OS your master runs.
Also expand this sentence 

>         Now (4.0.11) they freeze even after server full restart.

What has happened before restarting the server ? etc

If you can provide all this, I will forward it to our FreeBSD developers,
as it seems to be platform-dependent.

Regards,
Guilhem
-- 
MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/
For technical support contracts, visit https://order.mysql.com/?ref=mgbi
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Guilhem Bichot <guilhem@stripped>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Full-Time Software Developer
/_/  /_/\_, /___/\___\_\___/   Bordeaux, France
       <___/   www.mysql.com