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

INSERT DELAYED isn't writing ANNOTATE_ROWS binlog event

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.2, 10.3, 10.4, 10.5, 10.6
    • 10.4, 10.5
    • Replication
    • None
    • mariadb 10.6-branch Linux x64

    Description

      According to the docs, INSERT DELAYED should generate an Annotate_rows event, but doesn't.

      It seems to be disabled in the code. See sql_insert.cc:

            /*
              Annotating delayed inserts is not supported.
            */
            di->thd.variables.binlog_annotate_row_events= 0;
      

      And

          /* Don't annotate insert delayed binlog events */
          thd->variables.binlog_annotate_row_events= 0;
      

      Why is that? Why can't the annotate event still be written and ignored when/if needed?

      We really want to see as many rows events annotated as possible, for monitoring purposes.

      Please advise if it's possible to fix this.

      Attachments

        Activity

          People

            Elkin Andrei Elkin
            rustyx Ruslan Altynbaev
            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.