Re: mysql replication problem
Have you turned log-bin on the master server? The master will not generate the log files that the slave reads unless this is turned on. |-+> | | Floyd Wellershaus| | | <[EMAIL PROTECTED]| | | .com>| | || | | 04/03/2003 12:54 | | || |-+> >--| | | | To: "Mysqllist (E-mail)" <[EMAIL PROTECTED]> | | cc: | | Subject: mysql replication problem | >--| Hello, I am trying to start replication between 2 linux servers mysql version is 4.0.8. I am following all instructions, but I keep getting the following error message on the slave when I restart. 030303 10:35:28 mysqld started 030303 10:35:29 InnoDB: Started /usr/mysql/libexec/mysqld: ready for connections 030303 10:35:29 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'floyd-bin.008' at position 164 030303 10:35:29 Error reading packet from server: Could not find first log file name in binary log index file (server_errno=1236) 030303 10:35:29 Got fatal error 1236: 'Could not find first log file name in binary log index file' from master when reading data from binary log 030303 10:35:29 Slave I/O thread exiting, read up to log 'floyd-bin.008', position 164 - 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
mysql replication problem
Hello, I am trying to start replication between 2 linux servers mysql version is 4.0.8. I am following all instructions, but I keep getting the following error message on the slave when I restart. 030303 10:35:28 mysqld started 030303 10:35:29 InnoDB: Started /usr/mysql/libexec/mysqld: ready for connections 030303 10:35:29 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'floyd-bin.008' at position 164 030303 10:35:29 Error reading packet from server: Could not find first log file name in binary log index file (server_errno=1236) 030303 10:35:29 Got fatal error 1236: 'Could not find first log file name in binary log index file' from master when reading data from binary log 030303 10:35:29 Slave I/O thread exiting, read up to log 'floyd-bin.008', position 164 Can anyone help on this ? Thank You, floyd - 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: mysql replication problem
Vaso Koutsonikola wrote: > Hi, > I am replicating a table between 2 servers. > The table on the master executes many transactions that should be > replicated to the table on the slave.. > The table on the slave is only readable... > I have noticed that the changes on the master are not replicated at once > but it takes about 2 hours to > get the slave updated.. > When this happens I see on the slaves error log file the error > Error reading packet from server: Lost connection to MySQL server during > query (read_errno 134,server_errno=2013) > and then the slave seems to reconnect to the master. > Has anyone any idea why is this happening? > Is it possible that when I read data from the table on the slave, the > slave cannot be updated because it gets locked or something > like that? > > Thanks.. > > - > 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 Vaso, What version of mysql and what OS? walt - 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
mysql replication problem
Hi, I am replicating a table between 2 servers. The table on the master executes many transactions that should be replicated to the table on the slave.. The table on the slave is only readable... I have noticed that the changes on the master are not replicated at once but it takes about 2 hours to get the slave updated.. When this happens I see on the slaves error log file the error Error reading packet from server: Lost connection to MySQL server during query (read_errno 134,server_errno=2013) and then the slave seems to reconnect to the master. Has anyone any idea why is this happening? Is it possible that when I read data from the table on the slave, the slave cannot be updated because it gets locked or something like that? Thanks.. - 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: Mysql replication problem
Just a guess, but I would say the problem rests in the network or network configuration. We have a number of installation running replication (both Win32 and Linux), and have never seen anything like this. Gerald Jensen - Original Message - From: "Vaso Koutsonikola" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "Vaso Koutsonikola" <[EMAIL PROTECTED]> Sent: Saturday, November 23, 2002 1:10 PM Subject: Mysql replication problem Hello, I use mysql version 3.23.49 and I have set up replication but once in a while I get the error below on the slave.. "Error reading packet from server: Lost connection to MySQL server during query (read_errno 134,server_errno=2013)" Then the slave reconnects to the master and the replication goes on... Does anyone have any idea why is this happening and what can I do to solve this problem?? Thank you.. - 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 - 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
Mysql replication problem
Hello, I use mysql version 3.23.49 and I have set up replication but once in a while I get the error below on the slave.. "Error reading packet from server: Lost connection to MySQL server during query (read_errno 134,server_errno=2013)" Then the slave reconnects to the master and the replication goes on... Does anyone have any idea why is this happening and what can I do to solve this problem?? Thank you.. - 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: mysql replication problem
On Thu, Nov 08, 2001 at 04:16:50PM -0500, [EMAIL PROTECTED] wrote: > > Is there anyone out there who is successfully replicating between two MySQL > 3.23.43 servers? > I have replication running between three .43 servers. All are InnoDB tables and all seem to be working fine. Ask for more details. robert -- robert cope \ I know the answer! The answer lies within the heart [EMAIL PROTECTED] / of all mankind! The answer is twelve? I think I'm \ in the wrong building. - 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