Hi, collugues
Have a problem with replication in MySQL-5.0.0-alpha
Configured server with server-id=2, slave with server-id=4
Copied DBs, configured the slave, restarted the servers.
Under MySQL v4.0.18 from debian distro replication works perfectly.
Kept all configs in place, overwrite all binary with self build
binaries from MySQL v5.0.0.-alpha
Slave logs:
Version: '5.0.0-alpha-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306
040417 16:32:53 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306',
replication started in log 'netlab-bin
.000001' at position 4
040417 16:32:53 Error reading packet from server: Misconfigured master - server id
was not set (server_errno=1236
)
040417 16:32:53 Got fatal error 1236: 'Misconfigured master - server id was not set'
from master when reading dat
a from binary log
040417 16:32:53 Slave I/O thread exiting, read up to log 'netlab-bin.000001',
position 4
Master status shows:
mysql> show binlog events;
+-------------------+-----+-------------+-----------+-------------+--------------------------------------------+
| Log_name | Pos | Event_type | Server_id | End_log_pos | Info
|
+-------------------+-----+-------------+-----------+-------------+--------------------------------------------+
| netlab-bin.000001 | 4 | Format_desc | 1 | 95 | Server ver:
5.0.0-alpha-log, Binlog ver: 4 |
| netlab-bin.000001 | 95 | Query | 1 | 181 | use `km`; delete
from zakaz where id=2146 |
| netlab-bin.000001 | 181 | Query | 1 | 267 | use `km`; delete
from zakaz where id=3378 |
| netlab-bin.000001 | 267 | Query | 1 | 353 | use `km`; delete
from zakaz where id=2155 |
+-------------------+-----+-------------+-----------+-------------+--------------------------------------------+
4 rows in set (0.00 sec)
See, all the time server-id=1, while in v4.0.18 and in config it happen to =2 !
Have I use precompiled binaries from ftp.mysql.com?
Is there working setups with 5.0.0 and replication?
Auf Wiederlesen ophil aka Д-р Антикоммуний
--
Oleg P. Philon http://gomelug.agava.ru/articles
Linux Lab, Gomel, Belarus mailto:ophil(at)gomelug.agava.ru
http://anticommunist.narod.ru mailto:anticommunist(at)narod.ru
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
