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

Cannot load from mysql.event when sql_mode is set to PAD_CHAR_TO_FULL_LENGTH

    XMLWordPrintable

Details

    • 10.0.26

    Description

      Cannot load from mysql.event when sql_mode is set to PAD_CHAR_TO_FULL_LENGTH

      mysql Ver 15.1 Distrib 10.0.22-MariaDB, for Linux (x86_64) using readline 5.1

      Steps to reproduce:

      MariaDB [test]> create table test1 (col1 INT);
      MariaDB [test]> insert into test1 values(100);
      MariaDB [test]> select * from test1;
      +------+
      | col1 |
      +------+
      |  100 |
      +------+
      1 row in set (0.00 sec)
       
      MariaDB [test]> create event event1 ON SCHEDULE every 5 SECOND do insert into test.test1 (col1) values(200);
      Query OK, 0 rows affected (0.00 sec)
       
      MariaDB [test]> show events;
      ERROR 1728 (HY000): Cannot load from mysql.event. The table is probably corrupted
      MariaDB [test]> show variables like 'sql_mode'\G
      *************************** 1. row ***************************
      Variable_name: sql_mode
              Value: STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,PAD_CHAR_TO_FULL_LENGTH
      1 row in set (0.00 sec)
       
      MariaDB [test]> show events;
      ERROR 1728 (HY000): Cannot load from mysql.event. The table is probably corrupted
       
      MariaDB [test]> set sql_mode = 'STRICT_TRANS_TABLES';
      Query OK, 0 rows affected (0.01 sec)
       
      MariaDB [test]> show variables like 'sql_mode'\G
      *************************** 1. row ***************************
      Variable_name: sql_mode
              Value: STRICT_TRANS_TABLES
      1 row in set (0.00 sec)
       
      MariaDB [test]> show events \G
      *************************** 1. row ***************************
                        Db: test
                      Name: event1
                   Definer: root@localhost
                 Time zone: SYSTEM
                      Type: RECURRING
                Execute at: NULL
            Interval value: 5
            Interval field: SECOND
                    Starts: 2016-01-27 17:52:40
                      Ends: NULL
                    Status: ENABLED
                Originator: 1
      character_set_client: utf8
      collation_connection: utf8_general_ci
        Database Collation: utf8_general_ci
      1 row in set (0.00 sec)
      

      While searching I have found https://bugs.mysql.com/bug.php?id=74947
      looks like the same problem.

      Attachments

        Issue Links

          Activity

            People

              bar Alexander Barkov
              nirbhay_c Nirbhay Choubey (Inactive)
              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.