RE: ERROR 1201

Hi there,

Thank you for the quick reply.  However, nothing I have done will get the
master.info file to load.  The file is owned by `mysql' (which is what it
should be).  I have even tried setting the permissions to 777.   This is
strange because I did have replication working for a while before it
stopped, and I never touched the server.

Any command with
"CHANGE MASTER TO"  fails with the same error.

Do you have any more details on what would trigger that error message?

Thanks,
Brian

-----Original Message-----
From: Sinisa Milivojevic [mailto:[email protected]]
Sent: Wednesday, December 10, 2003 5:44 AM
To: [email protected]
Cc: [email protected]
Subject: Re: ERROR 1201


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]