サポート #847

DBスレーブ再起動

山本 義治 が8年以上前に追加. 8年以上前に更新.

ステータス:解決開始日:2016/07/27
優先度:通常期日:
担当者:山本 義治進捗 %:

0%

カテゴリ:DB作業時間の記録:-
対象バージョン:-

説明

[admin@db1 ~]$ mysql -u root -p
mysql> show slave status\G
*************************** 1. row ***************************
             Slave_IO_State: Waiting for master to send event
                Master_Host: 192.168.2.104
                Master_User: repl
                Master_Port: 3306
              Connect_Retry: 60
            Master_Log_File: mysql-bin.001150
        Read_Master_Log_Pos: 368291688
             Relay_Log_File: db1-relay-bin.123427
              Relay_Log_Pos: 200257271
      Relay_Master_Log_File: mysql-bin.001150
           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: 1016
                 Last_Error: Error 'Can't open file: './aff/asp_list.frm' (errno: 24)' on query. Default database: 'aff'. Query: 'update asp_list set duplicate_flg = 0 where duplicate_auto = 1 and duplicate_type = 3 and duplicate_date < (now() - interval duplicate_reset_period hour)'
               Skip_Counter: 0
        Exec_Master_Log_Pos: 200257134
            Relay_Log_Space: 368291825
            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)

mysql> SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;
Query OK, 0 rows affected (0.00 sec)

mysql> START SLAVE;
Query OK, 0 rows affected (0.00 sec)

mysql> show slave status\G
*************************** 1. row ***************************
             Slave_IO_State: Waiting for master to send event
                Master_Host: 192.168.2.104
                Master_User: repl
                Master_Port: 3306
              Connect_Retry: 60
            Master_Log_File: mysql-bin.001150
        Read_Master_Log_Pos: 369240973
             Relay_Log_File: db1-relay-bin.123427
              Relay_Log_Pos: 206747235
      Relay_Master_Log_File: mysql-bin.001150
           Slave_IO_Running: Yes
          Slave_SQL_Running: Yes
            Replicate_Do_DB: 
        Replicate_Ignore_DB: 
         Replicate_Do_Table: 
     Replicate_Ignore_Table: 
    Replicate_Wild_Do_Table: 
Replicate_Wild_Ignore_Table: 
                 Last_Errno: 0
                 Last_Error: 
               Skip_Counter: 0
        Exec_Master_Log_Pos: 206747098
            Relay_Log_Space: 369241110
            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: 15934
1 row in set (0.00 sec)

履歴

#1 山本 義治 が8年以上前に更新

  • ステータス を 新規 から 解決 に変更

他の形式にエクスポート: Atom PDF