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

Galera: Rolling upgrade: eliminate binlog format check for DDLs

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.4.3, 10.3.13
    • Fix Version/s: 10.4.3, 10.3.14
    • Component/s: Galera
    • Labels:
    • Environment:
      Ubuntu 18.04

      Description

      Found this during upgrade tests:

      • Start given number of nodes - with my test 5 nodes with 10.3 Maria + 3.x Galera.
      • Shutdown node5
      • Start node5 with 10.4 Maria + 4.x Galera.(upgrade)
      • Run mysql_upgrade on node5
      • Shutdown node5
      • Start node5
      • Run followings:

      MariaDB [(none)]> set session wsrep_trx_fragment_size=2147483647;
      Query OK, 0 rows affected (0.000 sec)
       
      MariaDB [(none)]> select @@wsrep_trx_fragment_size;
      +---------------------------+
      | @@wsrep_trx_fragment_size |
      +---------------------------+
      |                2147483647 |
      +---------------------------+
      1 row in set (0.002 sec)
       
      MariaDB [(none)]> drop database sbtest;
      ERROR 1235 (42000): Streaming replication not supported with binlog_format=STATEMENT
      MariaDB [(none)]> select @@binlog_format;
      +-----------------+
      | @@binlog_format |
      +-----------------+
      | ROW             |
      +-----------------+
      1 row in set (0.002 sec)
      

      As discussed with Teemu:

      DROP DATABASE is replicated as Query_log_event, which is the format for STATEMENT replication. I guess the binlog format check should not care about DDLs

        Attachments

          Activity

            People

            • Assignee:
              teemu.ollakka Teemu Ollakka
              Reporter:
              shako Shahriyar Rzayev
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: