Re: ERROR 1201

Sinisa Milivojevic <[email protected]>
Newsgroups gmane.comp.db.mysql.bugs
Message-ID <[email protected]>
Brian Piere writes:
> 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?
> 
> Thank you,
> Brian Piere
> 

HI!

Please re-check ownerships and mode of the file.

Check that the owner is user under whose UID MySQL server is running,
unless it is ran by root.

-- 

Sincerely,

-- 
For technical support contracts, go to https://order.mysql.com/?ref=msmi
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Sinisa Milivojevic <[email protected]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB
/_/  /_/\_, /___/\___\_\___/   Fulltime Developer and Support Coordinator
       <___/   www.mysql.com   Larnaca, Cyprus


-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.