replication failed on slave due to super_read_only
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
New
|
Undecided
|
Unassigned |
Bug Description
The master executed this statement (excerpt from the master general log)
150928 22:10:19 2430019 Query SELECT 1
and the slave stopped replicating (excerpt from the slave error log)
2015-09-28 22:10:19 5680 [ERROR] Slave SQL: Error 'The MySQL server is running with the --read-only (super) option so it cannot execute this statement' on query. Default database: 'BroadcastApi'. Query: 'UPDATE channels c, accounts a SET c.active = false WHERE c.active = true and a.deleted = true and c.accountGuid = a.accountGuid', Error_code: 1290
2015-09-28 22:10:19 5680 [Warning] Slave: The MySQL server is running with the --read-only (super) option so it cannot execute this statement Error_code: 1290
2015-09-28 22:10:19 5680 [Warning] Slave: Unknown error Error_code: 1105
2015-09-28 22:10:19 5680 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'bin.006687' position 214170
Excerpt from the slave general log
150928 22:10:19 255 Query BEGIN
mysql> show slave status\G ******* ******* ****** 1. row ******* ******* ******* ******
Slave_ IO_State: Waiting for master to send event
Master_ Host: calm-voice
Master_ User: SUSR_Repl
Master_ Port: 3306
Connect_ Retry: 15
Master_ Log_File: bin.006688
Read_ Master_ Log_Pos: 226901
Relay_ Log_File: relay.005480
Relay_ Log_Pos: 214368
Relay_ Master_ Log_File: bin.006687
Slave_ IO_Running: Yes
Slave_ SQL_Running: No
Replicate_ Do_DB:
Replicate_ Ignore_ DB:
Replicate_ Do_Table:
Replicate_ Ignore_ Table: _Wild_Do_ Table: Wild_Ignore_ Table:
Last_ Errno: 1290
Last_ Error: Error 'The MySQL server is running with the --read-only (super) option so it cannot execute this statement' on query. Default database: 'BroadcastApi'. Query: 'UPDATE channels c, accounts a SET c.active = false WHERE c.active = true and a.deleted = true and c.accountGuid = a.accountGuid'
Skip_ Counter: 0
Exec_ Master_ Log_Pos: 214170
Relay_Log_ Space: 1370601
Until_Condition : None
Until_ Log_File:
Until_ Log_Pos: 0
Master_ SSL_Allowed: Yes
Master_ SSL_CA_ File: /opt/mysql/ dbdata1/ public_ key_certificate s/ca-cert. pem
Master_ SSL_CA_ Path:
Master_ SSL_Cert: /opt/mysql/ dbdata1/ public_ key_certificate s/client- cert.pem
Master_ SSL_Cipher:
Master_ SSL_Key: /opt/mysql/ dbdata1/ private_ keys/client- key.pem
Seconds_ Behind_ Master: NULL SSL_Verify_ Server_ Cert: No
Last_ IO_Errno: 0
Last_ IO_Error:
Last_SQL_ Errno: 1290
Last_SQL_ Error: Error 'The MySQL server is running with the --read-only (super) option so it cannot execute this statement' on query. Default database: 'BroadcastApi'. Query: 'UPDATE channels c, accounts a SET c.active = false WHERE c.active = true and a.deleted = true and c.accountGuid = a.accountGuid' Ignore_ Server_ Ids:
Master_ Server_ Id: 1625821009
Master_ UUID: c0d78983- f8cf-11e4- 9ea6-120e63b6c4 e7
Master_ Info_File: /opt/mysql/ dbdata1/ broadcastapi- q0/master. info
SQL_ Delay: 0
SQL_ Remaining_ Delay: NULL SQL_Running_ State:
Master_ Retry_Count: 86400
Master_ Bind: IO_Error_ Timestamp: SQL_Error_ Timestamp: 150928 22:10:19
Master_ SSL_Crl:
Master_ SSL_Crlpath:
Retrieved_ Gtid_Set: c0d78983- f8cf-11e4- 9ea6-120e63b6c4 e7:1154394- 3332219
Executed_ Gtid_Set: 2be7a979- 1a2c-11e5- b830-0e8fff6383 05:1-15, f8cf-11e4- 9ea6-120e63b6c4 e7:1-3330031
Auto_ Position: 1
*******
Replicate
Replicate_
Master_
Replicate_
Slave_
Last_
Last_
c0d78983-
1 row in set (0.00 sec)