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

          Transition Time In Source Status Execution Times
          Nirbhay Choubey (Inactive) made transition -
          Open In Progress
          28d 5h 27m 1
          Nirbhay Choubey (Inactive) made transition -
          In Progress Closed
          18h 19m 1

          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.