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

max_binlog_size was exceeded

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • 10.0.21-galera
    • N/A
    • Replication

    Description

      This was a galera node acting as an async sync slave to another non-galera server. This server had log-slave-updates enabled.

      The slave status before the start:

      MariaDB [(none)]> show slave status\G
      *************************** 1. row ***************************
                     Slave_IO_State: Waiting for master to send event
                        Master_Host: localhost
                        Master_User: replication
                        Master_Port: 63306
                      Connect_Retry: 60
                    Master_Log_File: mysql-bin.034995
                Read_Master_Log_Pos: 51689463
                     Relay_Log_File: mysqld-relay-bin.000201
                      Relay_Log_Pos: 53798956
              Relay_Master_Log_File: mysql-bin.034775
                   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: 0
                         Last_Error:
                       Skip_Counter: 0
                Exec_Master_Log_Pos: 53798665
                    Relay_Log_Space: 22683519000
                    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: 0
                     Last_SQL_Error:
        Replicate_Ignore_Server_Ids:
                   Master_Server_Id: 9
                     Master_SSL_Crl:
                 Master_SSL_Crlpath:
                         Using_Gtid: No
                        Gtid_IO_Pos:
      1 row in set (0.00 sec)

      It was started with:

      start slave sql_thread until RELAY_LOG_FILE = 'mysqld-relay-bin.000837', RELAY_LOG_POS = 0;

      636 relay log files is quite large amount so I'm assuming the limit is bypassed for this UNTIL RELAY_LOG_FILE options to start slave.

      Seems the limit got exceeded in the binary logs

      | max_binlog_size                          | 104857600            |
       
      -rw-rw---- 1 mysql mysql   107362623 Aug 28 13:13 mysql-bin.000057
      -rw-rw---- 1 mysql mysql   104866589 Aug 28 13:13 mysql-bin.000058
      -rw-rw---- 1 mysql mysql   105813602 Aug 28 13:14 mysql-bin.000059
      -rw-rw---- 1 mysql mysql   105470582 Aug 28 13:14 mysql-bin.000060
      -rw-rw---- 1 mysql mysql 35721262759 Sep  3 12:30 mysql-bin.000061
      -rw-rw---- 1 mysql mysql        1952 Aug 28 13:14 mysql-bin.index
       
       mysql]# tail  mysql-bin.index
      /var/lib/mysql/mysql-bin.000052
      /var/lib/mysql/mysql-bin.000053
      /var/lib/mysql/mysql-bin.000054
      /var/lib/mysql/mysql-bin.000055
      /var/lib/mysql/mysql-bin.000056
      /var/lib/mysql/mysql-bin.000057
      /var/lib/mysql/mysql-bin.000058
      /var/lib/mysql/mysql-bin.000059
      /var/lib/mysql/mysql-bin.000060
      /var/lib/mysql/mysql-bin.000061

      Attachments

        Issue Links

          Activity

            People

              seppo Seppo Jaakola
              danblack Daniel Black
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.