Binlog has bad magic number [SOLVED]
For me, this problem was due to: This problem occurs when the my.cnf file on the master contains log-bin=/var/log/replication.log but just log-bin seems to work. On Mon, Apr 02, 2001 at 05:11:21PM -0400, Jim Ziegler wrote: What causes: 010402 17:08:56 Error reading packet from server: Binlog has bad magic number, fire your magician (read_errno 0,server_errno=65535) in the err log of a replication slave? is it related to: 010402 17:10:34 create_table_from_dump::failed in handler::net_read_dump() 010402 17:10:34 fetch_nx_table: failed on create table when i try to: mysql load table aca from master; ERROR 1189: Net error reading from master -- [EMAIL PROTECTED] (Jim Ziegler) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- [EMAIL PROTECTED] (Jim Ziegler) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
replication-magic number-fire your magician
Description: I am unable to get replication running. I have set up both master and slave systems with version 3.23.33-log of musql. I can do a load table from master but when I start the slave, all I get in the slave log is: 010410 16:37:24 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 4 010410 16:37:24 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position 4 010410 16:37:24 Error reading packet from server: Binlog has bad magic number, fire your magician (read_errno 0,server_errno=65535) and in the master log: 010410 16:35:583006 Connect[EMAIL PROTECTED] on 3007 Connect[EMAIL PROTECTED] on 3007 Quit 3006 Binlog Dum How-To-Repeat: see below Fix: This problem occurs when the my.cnf file on the master contains log-bin=/var/log/replication.log but just log-bin seems to work. However, how do you control the location and name of the log? (This may just be a documentation issue, but the error message is not very intuitive.) Submitter-Id: submitter ID Originator:Jim Ziegler Organization: [EMAIL PROTECTED] (Jim Ziegler) MySQL support: [none | licence | email support | extended email support ] Synopsis: replication-bad magic number-fire your magician Severity: critical Priority: Category: mysql Class: Release: mysql-3.23.36 (Source distribution) Environment: System: Linux jimz 2.2.19 #1 Sun Jun 24 15:06:27 EST 2001 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20010319 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='-O2 -fomit-frame-pointer -g' CXX='g++' CXXFLAGS='-O2 -fomit-frame-pointer -g -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 14 Mar 28 11:57 /lib/libc.so.5 - libc.so.5.4.46 -rw-r--r--1 root root 589460 Mar 19 08:47 /lib/libc.so.5.4.46 lrwxrwxrwx1 root root 13 Jun 11 13:04 /lib/libc.so.6 - libc-2.2.3.so -rwxr-xr-x1 root root 1104456 May 28 18:49 /lib/libc-2.2.3.so -rw-r--r--1 root root 2522408 May 28 18:51 /usr/lib/libc.a -rw-r--r--1 root root 178 May 28 18:51 /usr/lib/libc.so lrwxrwxrwx1 root root 10 Nov 15 2000 /usr/lib/libc-client.a - c-client.a lrwxrwxrwx1 root root 18 Nov 15 2000 /usr/lib/libc-client.so - libc-client.so.4.7 -rw-r--r--1 root root 665260 Sep 1 2000 /usr/lib/libc-client.so.4.7 Configure command: ./configure --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql --localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info --mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler --with-berkeley-db --with-innobase --enable-static --enable-shared --with-raid --without-readline --with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql --without-bench --with-extra-charsets=all - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: bad magic number, fire your magician error
On Mon, Jun 25, 2001 at 06:52:34PM +, patrick ward wrote: Hello Mr. Ziegler, I'm sorry if I'm intruding and promise not to do so again without your consent but our db replication has come to a grinding halt with the error 'bad magic number, fire your magician'. I'm at my wits end and I was hoping you might be able to help being that you posted a similar error on deja(now google). I have not yet resolved this issue, nor have I received any useful response from my posted requests for assistance. I'm mysql newbie (with hordes of theoretical knowledge but very little practical) and I've been recently assigned to find out what's causing our DB replication to fail and a launch an error like 'bad magic number'. I I have been a mysql user for 3 years, but am just now trying to get replication to work. followed the news groups regarding the error but found nothing in the way of a solution. ditto I've also read through the documentation at the MySql site and found nothing of use although I may have overlooked something. ditto I noticed you posted a similar problem to the newsgroups and I'm wondering if you found a solution. If so, I was hoping you might share it with me or direct me to a resource that might help. Will do, likewise if you find the answer, please share it with me. Some details, We're running, OS: Redhat 7.1. Debian testing Mysql version: 3.23.39 3.23.36 The error messages: 010625 12:25:55 Error reading packet from server: Binlog has bad magic number, fire your magician (read_errno 0,server_errno=65535) 010625 12:26:55 Slave: Failed reading log event, reconnecting to retry, log 'db-bin.143' position 20054 010625 12:26:55 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'db-bin.143' at position 20054 Again, any help you can provide will be immensely appreciated. Thanks for you time and have a great day. Sincerely, Patrick Ward Jr Programmer/DB Administrator. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- [EMAIL PROTECTED] (Jim Ziegler) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how to install mysql replication ?
On Tue, Jun 12, 2001 at 12:50:20AM -0700, Jeremy Zawodny wrote: On Tue, Jun 12, 2001 at 02:15:41PM +0700, Said Madrus wrote: Dear all, can anybody tell me how to install mysql replication step by step :-). thanks in advance. Best regards, It is described step-by-step in the manual already. If you find it to be lacking, please let us know and someone will make it more clear (and update the manual). Did that, it didn't work, asked for help, got none. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 17 days, processed 115,979,732 queries (76/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- [EMAIL PROTECTED] (Jim Ziegler) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how to install mysql replication ?
On Tue, Jun 12, 2001 at 12:45:15PM -0700, Jeremy Zawodny wrote: On Tue, Jun 12, 2001 at 03:41:25PM -0400, Jim Ziegler wrote: On Tue, Jun 12, 2001 at 12:50:20AM -0700, Jeremy Zawodny wrote: On Tue, Jun 12, 2001 at 02:15:41PM +0700, Said Madrus wrote: Dear all, can anybody tell me how to install mysql replication step by step :-). thanks in advance. Best regards, It is described step-by-step in the manual already. If you find it to be lacking, please let us know and someone will make it more clear (and update the manual). Did that, it didn't work, asked for help, got none. What happened? What failed? What error messages did you get? Were there parts of the documentation that were unclear? I updated the replication docs a few months ago when *I* found them unclear, but that doesn't mean that they're as good as they could be... From my previous post: Envelope-to: [EMAIL PROTECTED] Delivery-date: Fri, 13 Apr 2001 09:04:18 -0400 Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org) List-ID: mysql.mysql.com List-Help: mailto:[EMAIL PROTECTED] List-Unsubscribe: mailto:[EMAIL PROTECTED] List-Post: mailto:[EMAIL PROTECTED] List-Subscribe: mailto:[EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: replication problems From: Jim Ziegler [EMAIL PROTECTED] X-UIDL: d8dfffe8bce601f2bac2c6bf2bb666c5 does anyone that is using replication have any suggestions at all about how to get past this problem? is anyone using replication successfully? - Forwarded message from Jim Ziegler [EMAIL PROTECTED] - Envelope-to: [EMAIL PROTECTED] Delivery-date: Tue, 10 Apr 2001 16:42:26 -0400 Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org) List-ID: mysql.mysql.com List-Help: mailto:[EMAIL PROTECTED] List-Unsubscribe: mailto:[EMAIL PROTECTED] List-Post: mailto:[EMAIL PROTECTED] List-Subscribe: mailto:[EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: replication problems From: Jim Ziegler [EMAIL PROTECTED] X-UIDL: bf6be71aa70b2cf435089831f4dbdcb3 mysql sql db I am unable to get replication running. I have set up both master and slave systems with version 3.23.33-log of musql. I can do a load table from master but when I start the slave, all I get in the slave log is: 010410 16:37:24 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 4 010410 16:37:24 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position 4 010410 16:37:24 Error reading packet from server: Binlog has bad magic number, fire your magician (read_errno 0,server_errno=65535) and in the master log: 010410 16:35:583006 Connect[EMAIL PROTECTED] on 3007 Connect[EMAIL PROTECTED] on 3007 Quit 3006 Binlog Dum What is wrong? Where do I get a better magician? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
replication problems
does anyone that is using replication have any suggestions at all about how to get past this problem? is anyone using replication successfully? - Forwarded message from Jim Ziegler [EMAIL PROTECTED] - Envelope-to: [EMAIL PROTECTED] Delivery-date: Tue, 10 Apr 2001 16:42:26 -0400 Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org) List-ID: mysql.mysql.com List-Help: mailto:[EMAIL PROTECTED] List-Unsubscribe: mailto:[EMAIL PROTECTED] List-Post: mailto:[EMAIL PROTECTED] List-Subscribe: mailto:[EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: replication problems From: Jim Ziegler [EMAIL PROTECTED] X-UIDL: bf6be71aa70b2cf435089831f4dbdcb3 mysql sql db I am unable to get replication running. I have set up both master and slave systems with version 3.23.33-log of musql. I can do a "load table from master" but when I start the slave, all I get in the slave log is: 010410 16:37:24 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 4 010410 16:37:24 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position 4 010410 16:37:24 Error reading packet from server: Binlog has bad magic number, fire your magician (read_errno 0,server_errno=65535) and in the master log: 010410 16:35:583006 Connect[EMAIL PROTECTED] on 3007 Connect[EMAIL PROTECTED] on 3007 Quit 3006 Binlog Dum What is wrong? Where do I get a better magician? -- [EMAIL PROTECTED] (Jim Ziegler) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - End forwarded message - -- [EMAIL PROTECTED] (Jim Ziegler) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
replication problems
mysql sql db I am unable to get replication running. I have set up both master and slave systems with version 3.23.33-log of musql. I can do a "load table from master" but when I start the slave, all I get in the slave log is: 010410 16:37:24 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 4 010410 16:37:24 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position 4 010410 16:37:24 Error reading packet from server: Binlog has bad magic number, fire your magician (read_errno 0,server_errno=65535) and in the master log: 010410 16:35:583006 Connect[EMAIL PROTECTED] on 3007 Connect[EMAIL PROTECTED] on 3007 Quit 3006 Binlog Dum What is wrong? Where do I get a better magician? -- [EMAIL PROTECTED] (Jim Ziegler) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: load aca from master
database,sql,query load table from master does not work for me. I get the error message ERROR 1189: Net error reading from master what can cause this? both the master and the slave are version 3.23.33-log -- [EMAIL PROTECTED] (Jim Ziegler) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SOLVED: Re: load aca from master
On Mon, Apr 09, 2001 at 02:01:55PM -0400, Jim Ziegler wrote: database,sql,query load table from master does not work for me. I get the error message ERROR 1189: Net error reading from master what can cause this? both the master and the slave are version 3.23.33-log apparantly, the load table from master command does not work with isam tables. I converted the tables to myisam and now it works. -- [EMAIL PROTECTED] (Jim Ziegler) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Binlog has bad magic number
database,sql,query What causes: 010409 15:47:42 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 4 010409 15:47:42 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position 4 010409 15:47:42 Error reading packet from server: Binlog has bad magic number, fire your magician (read_errno 0,server_errno=65535) in the err log of a replication slave? I can do a "load table xxx from master" so the two are communicating ok, does this have anything to do with the replication resumed in log 'FIRST' message? The log file on the master is not named FIRST. -- [EMAIL PROTECTED] (Jim Ziegler) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problem with LOAD TABLE command
why do i get: mysql load table aca from master; ERROR 1189: Net error reading from master the error log shows: 010402 11:37:10 create_table_from_dump::failed in handler::net_read_dump() 010402 11:37:10 fetch_nx_table: failed on create table status shows: mysql status -- mysql Ver 11.12 Distrib 3.23.33, for pc-linux-gnu (i686) Connection id: 5 Current database: esp Current user: jcz@localhost Current pager: stdout Using outfile: '' Server version: 3.23.33-log Protocol version: 10 Connection: Localhost via UNIX socket Client characterset:latin1 Server characterset:latin1 UNIX socket:/var/run/mysqld/mysqld.sock Uptime: 2 hours 4 min 40 sec Threads: 1 Questions: 20 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 1 Queries per second avg: 0.003 -- status on the master: mysql status; -- mysql Ver 11.12 Distrib 3.23.33, for pc-linux-gnu (i686) Connection id: 34 Current database: Current user: jcz@localhost Current pager: stdout Using outfile: '' Server version: 3.23.33-log Protocol version: 10 Connection: Localhost via UNIX socket Client characterset:latin1 Server characterset:latin1 UNIX socket:/var/run/mysqld/mysqld.sock Uptime: 1 hour 50 min 34 sec Threads: 1 Questions: 224 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 6 Queries per second avg: 0.034 -- -- [EMAIL PROTECTED] (Jim Ziegler) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Binlog has bad magic number
What causes: 010402 17:08:56 Error reading packet from server: Binlog has bad magic number, fire your magician (read_errno 0,server_errno=65535) in the err log of a replication slave? is it related to: 010402 17:10:34 create_table_from_dump::failed in handler::net_read_dump() 010402 17:10:34 fetch_nx_table: failed on create table when i try to: mysql load table aca from master; ERROR 1189: Net error reading from master -- [EMAIL PROTECTED] (Jim Ziegler) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php