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

pseudo_slave_mode variable inconsistent behavior

    XMLWordPrintable

Details

    Description

      SELECT @@pseudo_slave_mode;
      --error ER_BASE64_DECODE_ERROR
      BINLOG ' a';
      SELECT @@pseudo_slave_mode;
      SHOW SESSION VARIABLES LIKE '%pseudo_slave_mode%';
      SET pseudo_slave_mode=1;
      SHOW WARNINGS;
      

      Leads to:

      CS 12.2.0 fd15fd2765b53d0c070dd01d86fb231024b8f284 (Debug, Clang 21.1.3-20250923) Build 10/11/2025

      12.2.0-dbg>SELECT @@pseudo_slave_mode;
      +---------------------+
      | @@pseudo_slave_mode |
      +---------------------+
      |                   0 |
      +---------------------+
      1 row in set (0.000 sec)
       
      12.2.0-dbg>BINLOG ' a';
      ERROR 1575 (HY000): Decoding of base64 string failed
      12.2.0-dbg>SELECT @@pseudo_slave_mode;
      +---------------------+
      | @@pseudo_slave_mode |
      +---------------------+
      |                   0 |
      +---------------------+
      1 row in set (0.000 sec)
       
      12.2.0-dbg>SHOW SESSION VARIABLES LIKE '%pseudo_slave_mode%';
      +-------------------+-------+
      | Variable_name     | Value |
      +-------------------+-------+
      | pseudo_slave_mode | OFF   |
      +-------------------+-------+
      1 row in set (0.003 sec)
       
      12.2.0-dbg>SET pseudo_slave_mode=1;
      Query OK, 0 rows affected, 1 warning (0.001 sec)
       
      12.2.0-dbg>SHOW WARNINGS;
      +---------+------+------------------------------------+
      | Level   | Code | Message                            |
      +---------+------+------------------------------------+
      | Warning | 1231 | 'pseudo_slave_mode' is already ON. |
      +---------+------+------------------------------------+
      1 row in set (0.000 sec)
      

      Which is clearly faulty. Looks unrelated to actual BINLOG command used.

      Attachments

        Issue Links

          Activity

            People

              Elkin Andrei Elkin
              Roel Roel Van de Paar
              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.