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

binlog_checksum dynamic changes seem ineffective, restart required

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.3.30
    • None
    • Replication
    • None

    Description

      Hi,

      I set up replication from MariaDB 10.3.30 slave to an old 5.5.29-29.4-log Percona Server master.

      I got errors with the I/O thread:
      ```
      Last_IO_Errno: 1595
      Last_IO_Error: Relay log write failure: could not queue event from master
      ```

      Some research indicated me to binlog_checksum now being enabled by default. The parameter is dynamic (according to the documentation and from being able to change it with SET GLOBAL) so I changed it that way. After I tried to fix replication by restarting the I/O thread and restarting replication entirely. Both were ineffective and generated the same error.

      I added the parameter to the configuration file and restarted the server. Replication now came up without issues.

      Please fix it by making the parameter dynamic again, or by making it not dynamic and changing the documentation.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              michaeldg Michaël de groot
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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