Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-7829

Could not execute Update_rows_v1 event on table mysql.table_stats; Can't find record in 'table_stats'

    XMLWordPrintable

    Details

      Description

      master:

      MariaDB [mysql]> show  variables like '%bin%';
      +-----------------------------------------+--------------------------------------------------+
      | Variable_name                           | Value                                            |
      +-----------------------------------------+--------------------------------------------------+
      | binlog_annotate_row_events              | ON                                               |
      | binlog_cache_size                       | 32768                                            |
      | binlog_checksum                         | NONE                                             |
      | binlog_commit_wait_count                | 20                                               |
      | binlog_commit_wait_usec                 | 500000                                           |
      | binlog_direct_non_transactional_updates | OFF                                              |
      | binlog_format                           | ROW                                              |
      | binlog_optimize_thread_scheduling       | ON                                               |
      | binlog_stmt_cache_size                  | 32768                                            |
      | gtid_binlog_pos                         | 0-20077-142671                                   |
      | gtid_binlog_state                       | 0-77-2218,0-20076-86398,0-76-2219,0-20077-142671 |
      | innodb_api_enable_binlog                | OFF                                              |
      | innodb_locks_unsafe_for_binlog          | OFF                                              |
      | log_bin                                 | ON                                               |
      | log_bin_trust_function_creators         | OFF                                              |
      | max_binlog_cache_size                   | 18446744073709547520                             |
      | max_binlog_size                         | 1073741824                                       |
      | max_binlog_stmt_cache_size              | 18446744073709547520                             |
      | sql_log_bin                             | ON                                               |
      | sync_binlog                             | 0                                                |
       
      show master status;select * from mysql.table_stats into outfile '/tmp/table_stats.txt'; load data infile '/tmp/table_stats.txt' REPLACE  INTO TABLE mysql.table_stats;
      +------------------------------+-----------+--------------+------------------+
      | File                         | Position  | Binlog_Do_DB | Binlog_Ignore_DB |
      +------------------------------+-----------+--------------+------------------+
      | tulwaurt006-mysql-bin.000143 | 806528297 |              |                  |
      +------------------------------+-----------+--------------+------------------+
      1 row in set (0.00 sec)
       
       mysqlbinlog --verbose --base64-output=DECODE-ROWS --start-position 807572906  tulwaurt006-mysql-bin.000143
      /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
      /*!40019 SET @@session.max_insert_delayed_threads=0*/;
      /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
      DELIMITER /*!*/;
      # at 807572906
      # at 807573930
      # at 807574874
      # at 807575844
      # at 807576798
      # at 807577780
      # at 807578796
      # at 807579746
      # at 807580714
      # at 807581666
      # at 807582664
      # at 807583704
      # at 807584716
      # at 807585692
      # at 807586722
      # at 807587746
      # at 807588730
      # at 807589754
      # at 807590722
      # at 807591738
      # at 807592720
      # at 807593742
      # at 807594722
      # at 807595684
      # at 807596646
      # at 807597632
      # at 807598608
      # at 807599568
      # at 807600596
      # at 807601620
      #150325 14:52:02 server id 20077  end_log_pos 807573930         Update_rows: table id 654
      #150325 14:52:02 server id 20077  end_log_pos 807574874         Update_rows: table id 654
      #150325 14:52:02 server id 20077  end_log_pos 807575844         Update_rows: table id 654
      ....
      #150325 14:52:02 server id 20077  end_log_pos 807598608         Update_rows: table id 654
      #150325 14:52:02 server id 20077  end_log_pos 807599568         Update_rows: table id 654
      #150325 14:52:02 server id 20077  end_log_pos 807600596         Update_rows: table id 654
      #150325 14:52:02 server id 20077  end_log_pos 807601620         Update_rows: table id 654
      #150325 14:52:02 server id 20077  end_log_pos 807602020         Update_rows: table id 654 flags: STMT_END_F
      ### Row event for unknown table #654### Row event for unknown table #654### Row event for unknown table #654### Row event for unknown table #654### Row event for unknown table #654### Row event
       for unknown table #654### Row event for unknown table #654### Row event for unknown table #654### Row event for unknown table #654### Row event for unknown table #654### Row event for unknown 
      table #654### Row event for unknown table #654### Row event for unknown table #654### Row event for unknown table #654### Row event for unknown table #654### Row event for unknown table #654###
       Row event for unknown table #654### Row event for unknown table #654### Row event for unknown table #654### Row event for unknown table #654### Row event for unknown table #654### Row event fo
      r unknown table #654### Row event for unknown table #654### Row event for unknown table #654### Row event for unknown table #654### Row event for unknown table #654### Row event for unknown tab
      le #654### Row event for unknown table #654### Row event for unknown table #654### Row event for unknown table #654# at 807602020
      #150325 14:52:02 server id 20077  end_log_pos 807602090         Query   thread_id=1277  exec_time=0     error_code=0
      SET TIMESTAMP=1427260922/*!*/;
      SET @@session.pseudo_thread_id=1277/*!*/;
      SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
      SET @@session.sql_mode=0/*!*/;
      SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
      /*!\C utf8 *//*!*/;
      SET @@session.character_set_client=33,@@session.collation_connection=33,@@session.collation_server=8/*!*/;
      SET @@session.lc_time_names=0/*!*/;
      SET @@session.collation_database=DEFAULT/*!*/;
      COMMIT
      /*!*/;
      # at 807602090
      #150325 14:52:02 server id 20077  end_log_pos 807602128         GTID 0-20077-141913

      slave:

                    Master_Log_File: tulwaurt006-mysql-bin.000143
                Read_Master_Log_Pos: 852465402
                     Relay_Log_File: tulwaurt005-relay-bin.000022
                      Relay_Log_Pos: 807571992
              Relay_Master_Log_File: tulwaurt006-mysql-bin.000143
                   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 Update_rows_v1 event on table mysql.table_stats; Can't find record in 'table_stats', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log tulwaurt006-mysql-bin.000143, end_log_pos 807572906
                       Skip_Counter: 0
                Exec_Master_Log_Pos: 807571693
                    Relay_Log_Space: 1927121418
                    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 Update_rows_v1 event on table mysql.table_stats; Can't find record in 'table_stats', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log tulwaurt006-mysql-bin.000143, end_log_pos 807572906
        Replicate_Ignore_Server_Ids: 
                   Master_Server_Id: 20077
                     Master_SSL_Crl: 
                 Master_SSL_Crlpath: 
                         Using_Gtid: Slave_Pos
                        Gtid_IO_Pos: 0-20077-141955
       
      | Variable_name                           | Value                                            |
      +-----------------------------------------+--------------------------------------------------+
      | binlog_annotate_row_events              | ON                                               |
      | binlog_cache_size                       | 32768                                            |
      | binlog_checksum                         | NONE                                             |
      | binlog_commit_wait_count                | 20                                               |
      | binlog_commit_wait_usec                 | 50000                                            |
      | binlog_direct_non_transactional_updates | OFF                                              |
      | binlog_format                           | MIXED                                            |
      | binlog_optimize_thread_scheduling       | ON                                               |
      | binlog_stmt_cache_size                  | 32768                                            |
      | gtid_binlog_pos                         | 0-20077-142746                                   |
      | gtid_binlog_state                       | 0-77-2218,0-20076-86398,0-76-2219,0-20077-142746 |
      | innodb_api_enable_binlog                | OFF                                              |
      | innodb_locks_unsafe_for_binlog          | OFF                                              |
      | log_bin                                 | ON                                               |
      | log_bin_trust_function_creators         | OFF                                              |
      | max_binlog_cache_size                   | 18446744073709547520                             |
      | max_binlog_size                         | 1073741824                                       |
      | max_binlog_stmt_cache_size              | 18446744073709547520                             |
      | sql_log_bin                             | ON                                               |
      | sync_binlog                             | 0                                                |
       
       
      MariaDB [(none)]> show global variables like '%para%';
      +-------------------------------+--------+
      | Variable_name                 | Value  |
      +-------------------------------+--------+
      | slave_domain_parallel_threads | 10     |
      | slave_parallel_max_queued     | 131072 |
      | slave_parallel_threads        | 20     |

      inspired by the will to work around MDEV-7363

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              danblack Daniel Black
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Due:
                Created:
                Updated:
                Resolved:

                  Git Integration