Skip to content

Unknown status variable in query event - mariadb 11.7 #632

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Open
jasper-eljakim opened this issue Apr 22, 2025 · 0 comments
Open

Unknown status variable in query event - mariadb 11.7 #632

jasper-eljakim opened this issue Apr 22, 2025 · 0 comments

Comments

@jasper-eljakim
Copy link

jasper-eljakim commented Apr 22, 2025

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant