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
/ /|_/ / // /\ \/ /_/ / /__ 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/bugs?unsub=gcdmb-bugs@m.gmane.org