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

mysql_tzinfo_to_sql generates wrong query

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 5.5.34-galera
    • 5.5.36-galera
    • None
    • None
    • Ubuntu 12.04

    Description

      executing

      root@cluster01:~# mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql

      outputs the following error

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

      The resulting file contains at line 1

      SET SESSION wsrep_replicate_myisam=ON;

      Removing the line (as it's already enabled on my instance) and feeding the remaining queries to mysql works without any problem

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          giannello Giuseppe Iannello created issue -
          serg Sergei Golubchik made changes -
          Field Original Value New Value
          Priority Trivial [ 5 ] Minor [ 4 ]
          serg Sergei Golubchik made changes -
          Affects Version/s 5.5.34 [ 13700 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 5.5.35-galera [ 14300 ]
          nirbhay_c Nirbhay Choubey (Inactive) made changes -
          Assignee Nirbhay Choubey [ nirbhay_c ]
          nirbhay_c Nirbhay Choubey (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          nirbhay_c Nirbhay Choubey (Inactive) made changes -
          Fix Version/s 5.5.36-galera [ 14801 ]
          Fix Version/s 5.5.35-galera [ 14300 ]
          nirbhay_c Nirbhay Choubey (Inactive) added a comment -

          Pushed to maria-5.5-galera.

          nirbhay_c Nirbhay Choubey (Inactive) added a comment - Pushed to maria-5.5-galera.
          nirbhay_c Nirbhay Choubey (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow defaullt [ 33654 ] MariaDB v2 [ 42751 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Workflow MariaDB v2 [ 42751 ] MariaDB v3 [ 61759 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 61759 ] MariaDB v4 [ 147410 ]

          People

            nirbhay_c Nirbhay Choubey (Inactive)
            giannello Giuseppe Iannello
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.