Skip to content

Unknown status variable in query event - mariadb 11.7 #632

Open
@jasper-eljakim

Description

@jasper-eljakim

I am trying to read binlogs from my local mariadb server, which has version 11.7.

in the binlogs, there is an event status with the key 131 and a uint16 as the content.

Traceback (most recent call last):
  File "binlog2sql/test.py", line 7, in <module>
    for binlogevent in stream:
                       ^^^^^^
  File "binlog2sql/venv/lib/python3.13/site-packages/pymysqlreplication/binlogstream.py", line 618, in fetchone
    binlog_event = BinLogPacketWrapper(
        pkt,
    ...<12 lines>...
        self.__optional_meta_data,
    )
  File "binlog2sql/venv/lib/python3.13/site-packages/pymysqlreplication/packet.py", line 116, in __init__
    self.event = event_class(
                 ~~~~~~~~~~~^
        self,
        ^^^^^
    ...<11 lines>...
        optional_meta_data=optional_meta_data,
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    )
    ^
  File "binlog2sql/venv/lib/python3.13/site-packages/pymysqlreplication/event.py", line 496, in __init__
    self._read_status_vars_value_for_key(status_vars_key)
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^
  File "binlog2sql/venv/lib/python3.13/site-packages/pymysqlreplication/event.py", line 596, in _read_status_vars_value_for_key
    raise StatusVariableMismatch
pymysqlreplication.exceptions.StatusVariableMismatch: Unknown status variable in query event. Possible parse failure in preceding fields or outdated constants.STATUS_VAR_KEY Refer to MySQL documentation/source code or create an issue on GitHub
MariaDB [(none)]> select VERSION();
+--------------------+
| VERSION()          |
+--------------------+
| 11.7.2-MariaDB-log |
+--------------------+
1 row in set (0.002 sec)

query that triggered it is a create table.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions