Hi
I am running 4.1.20 as this is the stock version in RHEL4 u5 and i have
setup a master/slave combination. Updates at first appeared to work as
creating and inserting into the master created the db's on the slave
etc. I have noticed however that data in the master is not making its
way to the slave.
I am now seeing issues like this
mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.12.225
Master_User: repl
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000003
Read_Master_Log_Pos: 2008085
Relay_Log_File: devsw19nagios02-relay-bin.000001
Relay_Log_Pos: 2909
Relay_Master_Log_File: mysql-bin.000003
Slave_IO_Running: Yes
Slave_SQL_Running: No
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 1062
Last_Error: Error 'Duplicate entry '754' for key 1' on
query. Default database: 'nagiosql'. Query: 'INSERT INTO tbl_logbook SET
user='Admin',time=NOW(), entry='Passwort successfully modified''
Skip_Counter: 0
Exec_Master_Log_Pos: 2941
Relay_Log_Space: 2008053
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: NULL
1 row in set (0.00 sec)
and in the mysql log
080516 9:23:01 [Note] Slave SQL thread initialized, starting
replication in log 'mysql-bin.000003' at position 79, relay log
'./devpctnagios02-relay-bin.000001' position: 4
080516 9:23:01 [Note] Slave I/O thread: connected to master
'[EMAIL PROTECTED]:3306', replication started in log
'mysql-bin.000003' at position 79
080516 10:06:58 [ERROR] Slave: Error 'Duplicate entry '754' for key 1'
on query. Default database: 'nagiosql'. Query: 'INSERT INTO tbl_logbook
SET user='Admin',time=NOW(), entry='Passwort successfully modified'',
Error_code: 1062
080516 10:06:58 [ERROR] Error running query, slave SQL thread aborted.
Fix the problem, and restart the slave SQL thread with "SLAVE START". We
stopped at log 'mysql-bin.000003' position 2941
Any clues as to how i can fix this?
thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
