Replication won't start under mysql-3.23.33

2001-03-05 Thread mills 

I have a master and slave server, both running mysql-3.23.29-gamma.
When I set up a second slave running mysql-3.23.33, it logged these
errors:

010304 10:18:50  mysqld started
/opt/local/mysql/libexec/mysqld: ready for connections
010304 10:18:51  Slave: connected to master '[EMAIL PROTECTED]:3306',  
replication started in log 'FIRST' at position 0
010304 10:18:51  Error reading packet from server: Could not open log file (read_errno 
0,server_errno=2)

I notice that the file name is missing in the status display:

mysql show slave status;
++-+-+---+--+-+---+-+-+++--+
| Master_Host| Master_User | Master_Port | Connect_retry | Log_File | Pos 
|| Slave_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | Last_error | 
|Skip_counter |
++-+-+---+--+-+---+-+-+++--+
| master.cc.umanitoba.ca | replic  | 3306| 60|  | 4   
|| Yes   | | | 0  || 0 
|   |
++-+-+---+--+-+---+-+-+++--+
1 row in set (0.00 sec)

I had to do this to fix it:

mysql change master to master_log_file='master-bin.197';
Query OK, 0 rows affected (0.01 sec)

The error log now said:

010304 10:39:48  Slave: connected to master '[EMAIL PROTECTED]:3306',  
replication started in log 'master-bin.197' at position 0


Should this be necessary?  Is there a bug someplace?


-- 
-Gary Mills--Unix Support--U of M Academic Computing and Networking-

-
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 won't start

2001-01-28 Thread Alan Hunter 

On the slave err log I have:

010128 11:04:28  Slave: Failed reading log event, reconnecting to retry, 
log 'FIRST' position 4
010128 11:04:28  Slave: reconnected to master 
'repl@glenastle:3306',replication resumed in log 'FIRST' at position 4
010128 11:04:28  Slave: received 0 length packet from server, apparent 
master shutdown:  (0)

The master hasn't shutdown and seems quite happy
010128 11:04:17  21 Connect[EMAIL PROTECTED] on
22 Connect[EMAIL PROTECTED] on
21 Binlog Dum
22 Quit

Where do I start?

Thanks,
Alan


-
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