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

System table in InnoDB format allowed in MariaDB could lead to crash

Details

    • 10.1.18

    Description

      Hi,

      After working on an upstream bug with a time_zone_name table created in InnoDB format, I figured out than trying to create them in InnoDB is forbidden in MySQL, but not in MariaDB.

      The original bugreport : http://bugs.mysql.com/bug.php?id=82910

      When I try to import the timezone.sql from this bugreport in MySQL, it's forbidden :

      MySQL 5.6.33 :

      mysql mysql < timezone.sql
      ERROR 1726 (HY000) at line 72: Storage engine 'InnoDB' does not support system tables. [mysql.time_zone_name]
      

      However in MariaDB it works like a charm, and it leads to the crashes described in the bugreport, easily reproducible in MariaDB.

      It would be great to have the same check than in MySQL (since MariaDB also crashes with a time_zone_name table in InnoDB format).

      Thanks and regards,
      Jocelyn Fournier

      Attachments

        Issue Links

          Activity

            Transition Time In Source Status Execution Times
            Elena Stepanova made transition -
            Open Confirmed
            3h 59m 1
            Sergei Golubchik made transition -
            Confirmed In Progress
            14d 4h 20m 1
            Sergei Golubchik made transition -
            In Progress Stalled
            2s 1
            Sergei Golubchik made transition -
            Stalled Closed
            2d 20h 12m 1

            People

              serg Sergei Golubchik
              joce jocelyn fournier
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.