[MDEV-25213] INSERT DELAYED isn't writing ANNOTATE_ROWS binlog event Created: 2021-03-21  Updated: 2023-04-27

Status: Open
Project: MariaDB Server
Component/s: Replication
Affects Version/s: 10.2, 10.3, 10.4, 10.5, 10.6
Fix Version/s: 10.4, 10.5

Type: Bug Priority: Major
Reporter: Ruslan Altynbaev Assignee: Andrei Elkin
Resolution: Unresolved Votes: 0
Labels: None
Environment:

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.


Generated at Thu Feb 08 09:36:00 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.