[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