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?

Thank you,
Brian Piere




--
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

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

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:sinisa@mysql.com]
Sent: Wednesday, December 10, 2003 5:44 AM
To: Brian@PrintsMadeEasy.com
Cc: bugs@lists.mysql.com
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
/ /|_/ / // /\ \/ /_/ / /__ 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/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: ERROR 1201

Hi!

On Dec 10, Brian Piere wrote:
> 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

You may try to use strace to see exactly where mysqld gets this
permission denied error.

Regards,
Sergei

--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ 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

RE: ERROR 1201

Thanks for the "strace" hint... it looks like the problem has nothing to do
with master.info ... I still can't figure out what is happening though. I
set the permissions really broad on the affected files, although I don't
think it was necessary. Here is some more info from my system. I really
appreciate the help!


Error from START SLAVE command
=============================
ERROR 1201: Could not initialize master info structure, check permisions on
master.info



Here is an error from my dev.pmehost.com.err
========================================
031211 20:23:22 Failed to open the relay log './plain-relay-bin.001'
(relay_log_pos 230799709)
031211 20:23:22 Could not find target log during relay log initialization




Result from strace
======================================================
13067 close(10) = 0
13067 getcwd("/var/lib/mysql", 4095) = 15
13067 lstat64("/var/lib/mysql/master.info", {st_mode=S_IFREG|0777,
st_size=74, ...}) = 0
13067 access("/var/lib/mysql/master.info", F_OK) = 0
13067 open("/var/lib/mysql/master.info", O_RDWR|O_LARGEFILE) = 9
13067 _llseek(9, 0, [74], SEEK_END) = 0
13067 _llseek(9, 0, [0], SEEK_SET) = 0
13067 read(9, "server-bin.001\n230799702\nwww.pri"..., 74) = 74
13067 getcwd("/var/lib/mysql", 4095) = 15
13067 lstat64("/var/lib/mysql/relay-log.info", {st_mode=S_IFREG|0660,
st_size=57, ...}) = 0
13067 open("./", O_RDONLY|O_NONBLOCK|O_LARGEFILE|O_DIRECTORY) = 10
13067 fstat64(10, {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
13067 fcntl64(10, F_SETFD, FD_CLOEXEC) = 0
13067 getdents64(10, /* 52 entries */, 4096) = 1984
13067 getdents64(10, /* 0 entries */, 4096) = 0
13067 close(10) = 0
13067 open("./dev-relay-bin.022", O_RDWR|O_APPEND|O_CREAT|O_LARGEFILE, 0660)
= 10
13067 _llseek(10, 0, [0], SEEK_CUR) = 0
13067 _llseek(10, 0, [0], SEEK_END) = 0
13067 _llseek(10, 0, [0], SEEK_END) = 0
13067 open("./dev-relay-bin.index", O_RDWR|O_CREAT|O_LARGEFILE, 0660) = 11
13067 _llseek(11, 0, [420], SEEK_END) = 0
13067 write(10, "\376bin", 4) = 4
13067 _llseek(11, 420, [420], SEEK_SET) = 0
13067 write(11, "./dev-relay-bin.022\n", 20) = 20
13067 access("/var/lib/mysql/relay-log.info", F_OK) = 0
13067 open("/var/lib/mysql/relay-log.info", O_RDWR|O_LARGEFILE) = 12
13067 _llseek(12, 0, [57], SEEK_END) = 0
13067 _llseek(12, 0, [0], SEEK_SET) = 0
13067 read(12, "./plain-relay-bin.001\n230799709\n"..., 57) = 57
13067 _llseek(11, 0, [0], SEEK_SET) = 0
13067 read(11, "./dev-relay-bin.001\n./dev-relay-"..., 440) = 440
13067 time(NULL) = 1071190376
13067 write(2, "031211 18:52:56 ", 17) = 17
13067 write(2, "Failed to open the relay log \'./"..., 78) = 78
13067 write(2, "\n", 1) = 1
13067 time(NULL) = 1071190376
13067 write(2, "031211 18:52:56 ", 17) = 17
13067 write(2, "Could not find target log during"..., 57) = 57
13067 write(2, "\n", 1) = 1
13067 close(12) = 0
13067 close(10) = 0
13067 close(11) = 0
13067 close(9) = 0
13067 time(NULL) = 1071190376
13067 write(2, "031211 18:52:56 ", 17) = 17
13067 write(2, "Failed to initialize the master "..., 46) = 46
13067 write(2, "\n", 1) = 1
13067 fstat64(1, {st_mode=S_IFCHR|0620, st_rdev=makedev(136, 0), ...}) = 0
13067 old_mmap(NULL, 4096, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x41576000
13067 write(1, "/usr/sbin/mysqld: ready for conn"..., 41) = 41
13067 write(1, "Version: \'4.0.15-standard\' sock"..., 76) = 76
13067 sched_getscheduler(0x330b) = 0
13067 sched_getparam(0x330b, 0xbfffeb68) = 0
13067 fcntl64(3, F_GETFL) = 0x2 (flags O_RDWR)
13067 fcntl64(4, F_GETFL) = 0x2 (flags O_RDWR)




=======================================================

drwxr-xr-x 12 mysql root 4096 Dec 11 20:23 ./
drwxr-xr-x 12 root root 4096 Oct 16 05:06 ../
-rw------- 1 mysql mysql 154 Dec 10 20:35 .bash_history
-rw-rw---- 1 mysql root 11636 Dec 11 20:23 dev.pmehost.com.err
-rw-rw---- 1 mysql mysql 5 Dec 11 18:58 dev.pmehost.com.pid
-rw-rw---- 1 mysql mysql 4 Dec 7 16:05 dev-relay-bin.001
-rw-rw---- 1 mysql mysql 4 Dec 10 01:51 dev-relay-bin.002
-rw-rw---- 1 mysql mysql 4 Dec 10 02:01 dev-relay-bin.003
-rw-rw---- 1 mysql mysql 4 Dec 10 02:12 dev-relay-bin.004
-rw-rw---- 1 mysql mysql 4 Dec 10 02:25 dev-relay-bin.005
-rw-rw---- 1 mysql mysql 4 Dec 10 02:33 dev-relay-bin.006
-rw-rw---- 1 mysql mysql 4 Dec 10 20:23 dev-relay-bin.007
-rw-rw---- 1 mysql mysql 4 Dec 10 20:44 dev-relay-bin.008
-rw-rw---- 1 mysql mysql 4 Dec 10 20:47 dev-relay-bin.009
-rw-rw---- 1 mysql mysql 4 Dec 10 20:50 dev-relay-bin.010
-rw-rw---- 1 mysql mysql 4 Dec 11 02:23 dev-relay-bin.011
-rw-rw---- 1 mysql mysql 4 Dec 11 02:44 dev-relay-bin.012
-rw-rw---- 1 mysql mysql 4 Dec 11 03:56 dev-relay-bin.013
-rw-rw---- 1 mysql mysql 4 Dec 11 04:06 dev-relay-bin.014
-rw-rw---- 1 mysql mysql 4 Dec 11 04:39 dev-relay-bin.015
-rw-rw---- 1 mysql mysql 4 Dec 11 18:29 dev-relay-bin.016
-rw-rw---- 1 mysql mysql 4 Dec 11 18:33 dev-relay-bin.017
-rw-rw---- 1 mysql mysql 4 Dec 11 18:36 dev-relay-bin.018
-rw-rw---- 1 mysql mysql 4 Dec 11 18:38 dev-relay-bin.019
-rw-rw---- 1 mysql mysql 4 Dec 11 18:40 dev-relay-bin.020
-rw-rw---- 1 mysql mysql 4 Dec 11 18:50 dev-relay-bin.021
-rw-rw---- 1 mysql mysql 4 Dec 11 18:52 dev-relay-bin.022
-rw-rw---- 1 mysql mysql 4 Dec 11 18:53 dev-relay-bin.023
-rw-rw---- 1 mysql mysql 4 Dec 11 18:54 dev-relay-bin.024
-rw-rw---- 1 mysql mysql 4 Dec 11 18:58 dev-relay-bin.025
-rw-rw---- 1 mysql mysql 4 Dec 11 19:42 dev-relay-bin.026
-rw-rw---- 1 mysql mysql 4 Dec 11 20:23 dev-relay-bin.027
-rw-rw---- 1 mysql mysql 540 Dec 11 20:23 dev-relay-bin.index
drwx------ 2 mysql mysql 4096 Oct 16 05:02 eximstats/
drwx------ 2 mysql mysql 4096 Oct 16 05:04 horde/
-rw-rw---- 1 mysql mysql 25088 Oct 16 04:34
ib_arch_log_0000000000
-rw-rw---- 1 mysql mysql 10485760 Dec 11 18:58 ibdata1
-rw-rw---- 1 mysql mysql 5242880 Dec 11 18:58 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 Oct 16 04:34 ib_logfile1
drwxrwx--- 2 mysql mail 4096 Oct 16 05:06 mail/
-rwxrwxrwx 1 mysql mysql 74 Dec 7 16:01 master.info*
drwx--x--x 2 mysql root 4096 Oct 17 02:05 mysql/
-rw------- 1 mysql mysql 97 Dec 10 20:35 .mysql_history
srwxrwxrwx 1 mysql mysql 0 Dec 11 18:58 mysql.sock=
-rw-rw---- 1 mysql mysql 79 Oct 28 19:07 plain-bin.001
-rw-rw---- 1 mysql mysql 16 Oct 28 19:07 plain-bin.index
-rwxrwxrwx 1 mysql mysql 230799709 Dec 7 16:01
plain-relay-bin.001*
-rw-rw---- 1 mysql mysql 22 Nov 26 06:02
plain-relay-bin.index
drwx------ 2 mysql mysql 4096 Nov 6 23:32 printsma_prints/
-rw-rw---- 1 mysql mysql 57 Dec 7 16:01 relay-log.info






-----Original Message-----
From: Sergei Golubchik [mailto:serg@mysql.com]
Sent: Thursday, December 11, 2003 1:44 AM
To: Brian Piere
Cc: bugs@lists.mysql.com; justmanj@msu.edu
Subject: Re: ERROR 1201


Hi!

On Dec 10, Brian Piere wrote:
> 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

You may try to use strace to see exactly where mysqld gets this
permission denied error.

Regards,
Sergei

--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ 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

Re: ERROR 1201

> Thanks for the "strace" hint... it looks like the problem has nothing to do
> with master.info ... I still can't figure out what is happening though. I
> set the permissions really broad on the affected files, although I don't
> think it was necessary. Here is some more info from my system. I really
> appreciate the help!
>
>
> Error from START SLAVE command
> =============================
> ERROR 1201: Could not initialize master info structure, check permisions on
> master.info
>
>
>
> Here is an error from my dev.pmehost.com.err
> ========================================
> 031211 20:23:22 Failed to open the relay log './plain-relay-bin.001'
> (relay_log_pos 230799709)
> 031211 20:23:22 Could not find target log during relay log initialization
>
>
>
>
> Result from strace
> ======================================================
> 13067 close(10) = 0
> 13067 getcwd("/var/lib/mysql", 4095) = 15
> 13067 lstat64("/var/lib/mysql/master.info", {st_mode=S_IFREG|0777,
> st_size=74, ...}) = 0
> 13067 access("/var/lib/mysql/master.info", F_OK) = 0
> 13067 open("/var/lib/mysql/master.info", O_RDWR|O_LARGEFILE) = 9
> 13067 _llseek(9, 0, [74], SEEK_END) = 0
> 13067 _llseek(9, 0, [0], SEEK_SET) = 0
> 13067 read(9, "server-bin.001\n230799702\nwww.pri"..., 74) = 74
> 13067 getcwd("/var/lib/mysql", 4095) = 15
> 13067 lstat64("/var/lib/mysql/relay-log.info", {st_mode=S_IFREG|0660,
> st_size=57, ...}) = 0
> 13067 open("./", O_RDONLY|O_NONBLOCK|O_LARGEFILE|O_DIRECTORY) = 10
> 13067 fstat64(10, {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
> 13067 fcntl64(10, F_SETFD, FD_CLOEXEC) = 0
> 13067 getdents64(10, /* 52 entries */, 4096) = 1984
> 13067 getdents64(10, /* 0 entries */, 4096) = 0
> 13067 close(10) = 0
> 13067 open("./dev-relay-bin.022", O_RDWR|O_APPEND|O_CREAT|O_LARGEFILE, 0660)
> = 10
> 13067 _llseek(10, 0, [0], SEEK_CUR) = 0
> 13067 _llseek(10, 0, [0], SEEK_END) = 0
> 13067 _llseek(10, 0, [0], SEEK_END) = 0
> 13067 open("./dev-relay-bin.index", O_RDWR|O_CREAT|O_LARGEFILE, 0660) = 11
> 13067 _llseek(11, 0, [420], SEEK_END) = 0
> 13067 write(10, "\376bin", 4) = 4
> 13067 _llseek(11, 420, [420], SEEK_SET) = 0
> 13067 write(11, "./dev-relay-bin.022\n", 20) = 20
> 13067 access("/var/lib/mysql/relay-log.info", F_OK) = 0
> 13067 open("/var/lib/mysql/relay-log.info", O_RDWR|O_LARGEFILE) = 12
> 13067 _llseek(12, 0, [57], SEEK_END) = 0
> 13067 _llseek(12, 0, [0], SEEK_SET) = 0
> 13067 read(12, "./plain-relay-bin.001\n230799709\n"..., 57) = 57
> 13067 _llseek(11, 0, [0], SEEK_SET) = 0
> 13067 read(11, "./dev-relay-bin.001\n./dev-relay-"..., 440) = 440
> 13067 time(NULL) = 1071190376
> 13067 write(2, "031211 18:52:56 ", 17) = 17
> 13067 write(2, "Failed to open the relay log \'./"..., 78) = 78
> 13067 write(2, "\n", 1) = 1
> 13067 time(NULL) = 1071190376
> 13067 write(2, "031211 18:52:56 ", 17) = 17
> 13067 write(2, "Could not find target log during"..., 57) = 57
> 13067 write(2, "\n", 1) = 1
> 13067 close(12) = 0
> 13067 close(10) = 0
> 13067 close(11) = 0
> 13067 close(9) = 0
> 13067 time(NULL) = 1071190376
> 13067 write(2, "031211 18:52:56 ", 17) = 17
> 13067 write(2, "Failed to initialize the master "..., 46) = 46
> 13067 write(2, "\n", 1) = 1
> 13067 fstat64(1, {st_mode=S_IFCHR|0620, st_rdev=makedev(136, 0), ...}) = 0
> 13067 old_mmap(NULL, 4096, PROT_READ|PROT_WRITE,
> MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x41576000
> 13067 write(1, "/usr/sbin/mysqld: ready for conn"..., 41) = 41
> 13067 write(1, "Version: \'4.0.15-standard\' sock"..., 76) = 76
> 13067 sched_getscheduler(0x330b) = 0
> 13067 sched_getparam(0x330b, 0xbfffeb68) = 0
> 13067 fcntl64(3, F_GETFL) = 0x2 (flags O_RDWR)
> 13067 fcntl64(4, F_GETFL) = 0x2 (flags O_RDWR)
>
>
>
>
> =======================================================
>
> drwxr-xr-x 12 mysql root 4096 Dec 11 20:23 ./
> drwxr-xr-x 12 root root 4096 Oct 16 05:06 ../
> -rw------- 1 mysql mysql 154 Dec 10 20:35 .bash_history
> -rw-rw---- 1 mysql root 11636 Dec 11 20:23 dev.pmehost.com.err
> -rw-rw---- 1 mysql mysql 5 Dec 11 18:58 dev.pmehost.com.pid
> -rw-rw---- 1 mysql mysql 4 Dec 7 16:05 dev-relay-bin.001
> -rw-rw---- 1 mysql mysql 4 Dec 10 01:51 dev-relay-bin.002
> -rw-rw---- 1 mysql mysql 4 Dec 10 02:01 dev-relay-bin.003
> -rw-rw---- 1 mysql mysql 4 Dec 10 02:12 dev-relay-bin.004
> -rw-rw---- 1 mysql mysql 4 Dec 10 02:25 dev-relay-bin.005
> -rw-rw---- 1 mysql mysql 4 Dec 10 02:33 dev-relay-bin.006
> -rw-rw---- 1 mysql mysql 4 Dec 10 20:23 dev-relay-bin.007
> -rw-rw---- 1 mysql mysql 4 Dec 10 20:44 dev-relay-bin.008
> -rw-rw---- 1 mysql mysql 4 Dec 10 20:47 dev-relay-bin.009
> -rw-rw---- 1 mysql mysql 4 Dec 10 20:50 dev-relay-bin.010
> -rw-rw---- 1 mysql mysql 4 Dec 11 02:23 dev-relay-bin.011
> -rw-rw---- 1 mysql mysql 4 Dec 11 02:44 dev-relay-bin.012
> -rw-rw---- 1 mysql mysql 4 Dec 11 03:56 dev-relay-bin.013
> -rw-rw---- 1 mysql mysql 4 Dec 11 04:06 dev-relay-bin.014
> -rw-rw---- 1 mysql mysql 4 Dec 11 04:39 dev-relay-bin.015
> -rw-rw---- 1 mysql mysql 4 Dec 11 18:29 dev-relay-bin.016
> -rw-rw---- 1 mysql mysql 4 Dec 11 18:33 dev-relay-bin.017
> -rw-rw---- 1 mysql mysql 4 Dec 11 18:36 dev-relay-bin.018
> -rw-rw---- 1 mysql mysql 4 Dec 11 18:38 dev-relay-bin.019
> -rw-rw---- 1 mysql mysql 4 Dec 11 18:40 dev-relay-bin.020
> -rw-rw---- 1 mysql mysql 4 Dec 11 18:50 dev-relay-bin.021
> -rw-rw---- 1 mysql mysql 4 Dec 11 18:52 dev-relay-bin.022
> -rw-rw---- 1 mysql mysql 4 Dec 11 18:53 dev-relay-bin.023
> -rw-rw---- 1 mysql mysql 4 Dec 11 18:54 dev-relay-bin.024
> -rw-rw---- 1 mysql mysql 4 Dec 11 18:58 dev-relay-bin.025
> -rw-rw---- 1 mysql mysql 4 Dec 11 19:42 dev-relay-bin.026
> -rw-rw---- 1 mysql mysql 4 Dec 11 20:23 dev-relay-bin.027
> -rw-rw---- 1 mysql mysql 540 Dec 11 20:23 dev-relay-bin.index
> drwx------ 2 mysql mysql 4096 Oct 16 05:02 eximstats/
> drwx------ 2 mysql mysql 4096 Oct 16 05:04 horde/
> -rw-rw---- 1 mysql mysql 25088 Oct 16 04:34
> ib_arch_log_0000000000
> -rw-rw---- 1 mysql mysql 10485760 Dec 11 18:58 ibdata1
> -rw-rw---- 1 mysql mysql 5242880 Dec 11 18:58 ib_logfile0
> -rw-rw---- 1 mysql mysql 5242880 Oct 16 04:34 ib_logfile1
> drwxrwx--- 2 mysql mail 4096 Oct 16 05:06 mail/
> -rwxrwxrwx 1 mysql mysql 74 Dec 7 16:01 master.info*
> drwx--x--x 2 mysql root 4096 Oct 17 02:05 mysql/
> -rw------- 1 mysql mysql 97 Dec 10 20:35 .mysql_history
> srwxrwxrwx 1 mysql mysql 0 Dec 11 18:58 mysql.sock=
> -rw-rw---- 1 mysql mysql 79 Oct 28 19:07 plain-bin.001
> -rw-rw---- 1 mysql mysql 16 Oct 28 19:07 plain-bin.index
> -rwxrwxrwx 1 mysql mysql 230799709 Dec 7 16:01
> plain-relay-bin.001*
> -rw-rw---- 1 mysql mysql 22 Nov 26 06:02
> plain-relay-bin.index
> drwx------ 2 mysql mysql 4096 Nov 6 23:32 printsma_prints/
> -rw-rw---- 1 mysql mysql 57 Dec 7 16:01 relay-log.info
>

Hi,

So slave is looking for relay logs called plain* but finds only dev*
ones. Maybe there was some hostname change (MySQL's behaviour in that
case is not a real bug but a confusing behaviour which I will change,
see http://bugs.mysql.com/?id=2122). I see a plain-bin.001 file above...
In any case, as you said, the error message returned to the command-line
client is truly a bad indication, so I changed it to
"Could not initialize master info structure, more error messages can be
found in the MySQL error log"
in 4.0.18 (was too late for 4.0.17 which is already built and soon
released).

Thanks for your bug report!
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