[debian-mysql] Bug#541796: replication failed with INSERT ... ON DUPLICATE KEY UPDATE
Evgeniy Kozhuhovskiy
ugenk at mgts.by
Sun Aug 16 11:36:29 UTC 2009
Package: mysql-server
Version: 5.0.51a-24+lenny1
I've configured replication on debian-lenny with two servers, and
on secondary server show slave status says:
| Slave_IO_State | Master_Host | Master_User |
Master_Port | Connect_Retry | Master_Log_File | Read_Master_Log_Pos |
Relay_Log_File | Relay_Log_Pos | Relay_Master_Log_File |
Slave_IO_Running | Slave_SQL_Running | Replicate_Do_DB |
Replicate_Ignore_DB | Replicate_Do_Table | Replicate_Ignore_Table |
Replicate_Wild_Do_Table | Replicate_Wild_Ignore_Table | Last_Errno |
Last_Error
| Skip_Counter |
Exec_Master_Log_Pos | Relay_Log_Space | Until_Condition | Until_Log_File
| Until_Log_Pos | Master_SSL_Allowed | Master_SSL_CA_File |
Master_SSL_CA_Path | Master_SSL_Cert | Master_SSL_Cipher |
Master_SSL_Key | Seconds_Behind_Master |
| Waiting for master to send event | 82.209.245.158 | repl |
3306 | 60 | mysql-bin.002044 | 36426392 |
mysqld-relay-bin.000003 | 456 | mysql-bin.001892 | Yes
| No | radius |
| | |
| | 1105 | Error 'master may suffer
from http://bugs.mysql.com/bug.php?id=24432 so slave stops; check error
log on slave for more info' on query. Default database: 'radius'. Query:
'INSERT INTO radcheck (username,attribute,op,value) VALUES
('mgts002367 at guest','Cleartext-Password',':=','101002367') ON DUPLICATE
KEY UPDATE value='101002367'' | 0 | 319 |
14334428638 | None | | 0 | No
| | |
| | | NULL |
Version of mysql-server on both servers is the same - 5.0.51a-24+lenny1,
master server is lenny/i386, secondary - lenny/amd64
Linux masterserver 2.6.22.16-vs2.2.0.6ext #1 SMP Mon Feb 11 12:05:33 EET
2008 i686 GNU/Linux
Linux slaveserver 2.6.26-2-amd64 #1 SMP Sun Jul 26 20:35:48 UTC 2009
x86_64 GNU/Linux
More information about the pkg-mysql-maint
mailing list