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

mysql_tzinfo_to_sql in galera distribution adds "SET SESSION wsrep_replicate_myisam"

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Duplicate
        • Affects Version/s: 5.5.36-galera
        • Fix Version/s: None
        • Component/s: None
        • Labels:

          Description

          The mysql_tzinfo_to_sql tool included with Galera distributions of MariaDB gives this as its first line of output:

          SET SESSION wsrep_replicate_myisam=ON;

          That is problematic since, wsrep_replication_myisam is not a session variable. This means that the tool will fail with this error:

          ERROR 1229 (HY000) at line 1: Variable 'wsrep_replicate_myisam' is a GLOBAL variable and should be set with SET GLOBAL

          Perhaps this should be used instead:

          SET SESSION wsrep_on=0;

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                nirbhay_c Nirbhay Choubey added a comment -

                Hi Kolbe,
                It has already been addressed (s/SESSION/GLOBAL) in 5.5.36-galera. (MDEV#5534).
                Setting @@session.wsrep_on=0 would stop the replication altogether (see lp:1161432).

                Show
                nirbhay_c Nirbhay Choubey added a comment - Hi Kolbe, It has already been addressed (s/SESSION/GLOBAL) in 5.5.36-galera. (MDEV#5534). Setting @@session.wsrep_on=0 would stop the replication altogether (see lp:1161432).
                Hide
                Permalink
                nirbhay_c Nirbhay Choubey added a comment -

                MDEV#5534

                Show
                nirbhay_c Nirbhay Choubey added a comment - MDEV#5534

                  People

                  • Assignee:
                    nirbhay_c Nirbhay Choubey
                    Reporter:
                    kolbe Kolbe Kegel
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: