Hi Brett, I am a little bit lost as to why this is happening. The only suggestion I have at this point is to go through the replication troubleshooting in this chapter and see if something there is causing the problem. Looking at what you have done and the docs, I don't think this will help. This may be a bug. Sorry I can't be of more assistance.
http://dev.mysql.com/doc/refman/5.0/en/replication.html I did find this in the bug system, you may be able to either re-open it or log a new one http://bugs.mysql.com/bug.php?id=10157 Regards --------------------------------------------------------------- ********** _/ ********** David Logan ******* _/ ******* ITO Delivery Specialist - Database ***** _/ ***** Hewlett-Packard Australia Ltd **** _/_/_/ _/_/_/ **** E-Mail: [EMAIL PROTECTED] **** _/ _/ _/ _/ **** Desk: +618 8408 4273 **** _/ _/ _/_/_/ **** Mobile: 0417 268 665 ***** _/ ****** ****** _/ ******** Postal: 148 Frome Street, ******** _/ ********** Adelaide SA 5001 Australia i n v e n t --------------------------------------------------------------- -----Original Message----- From: Brett Harvey [mailto:[EMAIL PROTECTED] Sent: Monday, 24 July 2006 11:06 PM To: mysql@lists.mysql.com Subject: RE: Replication Problem David, I could try and create a table. But I've got it set just for the one database "FMS". The error log, last night, was showing this (I think I had it in my first post) 060723 21:01:11 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013) 060723 21:01:11 [Note] Slave I/O thread killed while reading event 060723 21:01:11 [Note] Slave I/O thread exiting, read up to log 'FMSweb-bin.000004', position 349828 060723 21:01:11 [Note] Error reading relay log event: slave SQL thread was killed The two are on the same network, same switch in fact. I can do commands from one to the other without problem. The logs seem to update in that sense.... but when looking at the data - no go. I'll check binlogs on the slave. Brett >Just about to go when your email rocked up 8-) Like you, I can't see any >reason why it is not replicating according to the logs. > >Have you tried to create a database on the master and see if it appears >on the slave? What commands are being replicated at this time? You can >use the mysqlbinlog command to check the binary log to see what it is >trying to replicate. There are certain commands that are not replicated >and we want to eliminate those from the equation. > >Try the create database command eg. > >On master > >>CREATE DATABASE THING; > >On Slave > >>SHOW DATABASES; > >You should see the database thing on your slave. You can then drop the >database on the master and it should disappear. > >Regards > >--------------------------------------------------------------- >********** _/ ********** David Logan >******* _/ ******* ITO Delivery Specialist - Database >***** _/ ***** Hewlett-Packard Australia Ltd >**** _/_/_/ _/_/_/ **** E-Mail: [EMAIL PROTECTED] >**** _/ _/ _/ _/ **** Desk: +618 8408 4273 >**** _/ _/ _/_/_/ **** Mobile: 0417 268 665 >***** _/ ****** >****** _/ ******** Postal: 148 Frome Street, >******** _/ ********** Adelaide SA 5001 > Australia >i n v e n t >--------------------------------------------------------------- > >-----Original Message----- >From: Brett Harvey [mailto:[EMAIL PROTECTED] >Sent: Monday, 24 July 2006 9:51 PM >To: mysql@lists.mysql.com >Subject: RE: Replication Problem > >David, > >mysql> show master status\g >+-------------------+----------+--------------+------------------+ >| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | >+-------------------+----------+--------------+------------------+ >| FMSweb-bin.000001 | 903763 | | | >+-------------------+----------+--------------+------------------+ >1 row in set (0.00 sec) > >mysql> show slave status\G >*************************** 1. row *************************** >Slave_IO_State: Waiting for master to send event >Master_Host: xxx.xxx.xxx.xxx >Master_User: FMSReplicate >Master_Port: 3306 >Connect_Retry: 60 >Master_Log_File: FMSweb-bin.000001 >Read_Master_Log_Pos: 903763 >Relay_Log_File: FMSbuilding-relay-bin.000004 >Relay_Log_Pos: 901275 >Relay_Master_Log_File: FMSweb-bin.000001 >Slave_IO_Running: Yes >Slave_SQL_Running: Yes >Replicate_Do_DB: FMS >Replicate_Ignore_DB: >Replicate_Do_Table: >Replicate_Ignore_Table: >Replicate_Wild_Do_Table: >Replicate_Wild_Ignore_Table: >Last_Errno: 0 >Last_Error: >Skip_Counter: 0 >Exec_Master_Log_Pos: 903763 >Relay_Log_Space: 901275 >Until_Condition: None >Until_Log_File: >Until_Log_Pos: 0 >Master_SSL_Allowed: No >Master_SSL_CA_File: >Master_SSL_CA_Path: >Master_SSL_Cert: >Master_SSL_Cipher: >Master_SSL_Key: > Seconds_Behind_Master: 0 >1 row in set (0.00 sec) > >Gnite to you! lol I just got up... > >Thanks! >Brett > > >>Hi Brett, >> >>Can you please do the following : >> >>>SHOW MASTER STATUS; (on the master) >> >>and >> >>>SHOW SLAVE STATUS; (on the slave) >> >>Thanks >> >>P.S I will be going to bed soon so don't worry if you don't hear >>anything, I'll look at it first thing in the morning. > >-- >----------------------------------------------------------------------- - >-------- >/Brett C. Harvey; >/Creative-Pages.Net, President; >/Facility Management Systems, CTO (www.fmsystems.biz); >/Lasso Partner Association Member ID #LPA135259 >(www.omnipilot.com/www.lassopartner.com); >----------------------------------------------------------------------- - >-------- -- ------------------------------------------------------------------------ -------- /Brett C. Harvey; /Creative-Pages.Net, President; /Facility Management Systems, CTO (www.fmsystems.biz); /Lasso Partner Association Member ID #LPA135259 (www.omnipilot.com/www.lassopartner.com); ------------------------------------------------------------------------ -------- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]