Re: [Fwd: ERROR 1201]

> > Hi guys,
> > 
> > I think I found a bug in the replication but I am not quite sure.  I am an
> > experienced programmer, I have spent 3 hours searching for a reason/solution
> > to this problem throughout your documentation and newsgroups and have come
> > up with nothing.
> > 
> > I am using...
> > Ver 4.0.15-standard for pc-linux on i686 with RedHat 8
> > The same version of Mysql is running on both the master and the slave.
> > 
> > I have had replication running for about a month now.  It was working fine
> > for a while and then it just stopped.  When I run START SLAVE I get the
> > error.
> > 
> > ERROR 1201: Could not initialize master info structure, check permissions on
> > master.info
> > 
> > I have checked the permissions on the file and even tried setting to 777 to
> > be sure. The same problem.  This is the contents of the file.
> > 
> > --------------
> > server-bin.001
> > 230799702
> > www.printsmadeeasy.com
> > UserName
> > Password
> > 3306
> > 60
> > -----
> > 
> > I don't want to run any commands such as "RESET SLAVE" or take a new
> > snapshot of the DB and start clean because I bet that it will start working
> > fine again.  If I do this I might need to wait another week to see it fail
> > again.   So I am a little bit limited in troubleshooting the problem.
> > 
> > What do you think?

Hi,

It would be interesting to see the contents of MySQL's error log
(usually named with a .err extension) when START SLAVE fails like this;
it may contain more info than the error you got in the mysql client.

Thanks in advance,
Guilhem
-- 
For technical support contracts, visit https://order.mysql.com/?ref=mgbi
Are you MySQL certified? visit http://www.mysql.com/certification/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Guilhem Bichot <[email protected]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Full-Time Software Developer
/_/  /_/\_, /___/\___\_\___/   Bordeaux, France
       <___/   www.mysql.com


-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]