Skip to content

Instantly share code, notes, and snippets.

@ryanaslett
Created December 2, 2016 18:23
Show Gist options
  • Save ryanaslett/f859ab0a4dbdb8a86f7576194045c4d2 to your computer and use it in GitHub Desktop.
Save ryanaslett/f859ab0a4dbdb8a86f7576194045c4d2 to your computer and use it in GitHub Desktop.
MariaDB [(none)]> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 10.1.1.42
Master_User: repl_user
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: drupal-db5-binlog.041531
Read_Master_Log_Pos: 4814904
Relay_Log_File: relay-bin.000077
Relay_Log_Pos: 8668522
Relay_Master_Log_File: drupal-db5-binlog.041529
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: 1032
Last_Error: Could not execute Delete_rows_v1 event on table drupal.cache_metatag; Can't find record in 'cache_metatag', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log drupal-db5-binlog.041529, end_log_pos 27856782
Skip_Counter: 0
Exec_Master_Log_Pos: 27529678
Relay_Log_Space: 195677892
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
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 1032
Last_SQL_Error: Could not execute Delete_rows_v1 event on table drupal.cache_metatag; Can't find record in 'cache_metatag', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log drupal-db5-binlog.041529, end_log_pos 27856782
Replicate_Ignore_Server_Ids:
Master_Server_Id: 5
Master_SSL_Crl:
Master_SSL_Crlpath:
Using_Gtid: No
Gtid_IO_Pos:
1 row in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment