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

ER_EVENT_STORE_FAILED upon creating event under some uca140_xxx_nopad_xx_xx collations

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
    • 10.11
    • Character Sets, Events
    • None

    Description

      SET NAMES 'utf8mb3' COLLATE 'uca1400_swedish_nopad_ai_ci';
      		 
       
      		 
      CREATE TABLE t (a CHAR(8));
      		 
      INSERT INTO t VALUES ('foo');
      		 
      --error ER_TRUNCATED_WRONG_VALUE
      		 
      ALTER TABLE t MODIFY a INT;
      		 
      CREATE EVENT ev ON SCHEDULE EVERY 1 HOUR DO BEGIN END;
      		 
       
      		 
      # Cleanup
      		 
      DROP EVENT ev;
      		 
      DROP TABLE t;

      10.10 bb76dcbe

      		 
      query 'CREATE EVENT ev ON SCHEDULE EVERY 1 HOUR DO BEGIN END' failed: ER_EVENT_STORE_FAILED (1538): Failed to store event body. Error code 2 "No such file or directory" from storage engine

      I tried a few uca1400_xxxx_nopad_xx_xx collations, it was reproducible with each of them. Couldn't reproduce with non-nopad, non-uca1400, and non-language-specific (without xxxx) which I tried.

      Reproducible on 10.10/10.11.
      The test case isn't applicable to earlier versions due to the use of UCA1400 collations.
      On some reason the failing ALTER TABLE is important here, although I can't figure why.

      Attachments

        Issue Links

          is caused by

          Task - A task that needs to be done. MDEV-27009 Add UCA-14.0.0 collations

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29776 collation_connection and db_collation are too short in mysql.proc and mysql.event

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            elenst Elena Stepanova created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            elenst Elena Stepanova made changes -
            Description {code:sql}
            SET NAMES 'utf8mb3' COLLATE 'uca1400_swedish_nopad_ai_ci';

            CREATE TABLE t (a CHAR(8));
            INSERT INTO t VALUES ('foo');
            --error ER_TRUNCATED_WRONG_VALUE
            ALTER TABLE t MODIFY a INT;
            CREATE EVENT ev ON SCHEDULE EVERY 1 HOUR DO BEGIN END;

            # Cleanup
            DROP EVENT ev;
            DROP TABLE t;
            {code}

            {code:sql|title=10.10 bb76dcbe}
            query 'CREATE EVENT ev ON SCHEDULE EVERY 1 HOUR DO BEGIN END' failed: ER_EVENT_STORE_FAILED (1538): Failed to store event body. Error code 2 "No such file or directory" from storage engine
            {code}

            I tried a few uca1400_xxxx_nopad_xx_xx collations, it was reproducible with each of them. Couldn't reproduce with non-nopad, non-uca1400, and non-language-specific (without xxxx) which I tried.

            Reproducible on 10.10/10.11.
            The test case isn't applicable to earlier versions due to the use of UCA1400 collations.             		{code:sql}
            SET NAMES 'utf8mb3' COLLATE 'uca1400_swedish_nopad_ai_ci';

            CREATE TABLE t (a CHAR(8));
            INSERT INTO t VALUES ('foo');
            --error ER_TRUNCATED_WRONG_VALUE
            ALTER TABLE t MODIFY a INT;
            CREATE EVENT ev ON SCHEDULE EVERY 1 HOUR DO BEGIN END;

            # Cleanup
            DROP EVENT ev;
            DROP TABLE t;
            {code}

            {code:sql|title=10.10 bb76dcbe}
            query 'CREATE EVENT ev ON SCHEDULE EVERY 1 HOUR DO BEGIN END' failed: ER_EVENT_STORE_FAILED (1538): Failed to store event body. Error code 2 "No such file or directory" from storage engine
            {code}

            I tried a few uca1400_xxxx_nopad_xx_xx collations, it was reproducible with each of them. Couldn't reproduce with non-nopad, non-uca1400, and non-language-specific (without xxxx) which I tried.

            Reproducible on 10.10/10.11.
            The test case isn't applicable to earlier versions due to the use of UCA1400 collations.
            On some reason the failing ALTER TABLE is important here, although I can't figure why.
            bar Alexander Barkov made changes -
            Priority Major [ 3 ] Blocker [ 1 ]
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            Priority Blocker [ 1 ] Major [ 3 ]
            bar Alexander Barkov made changes -
            Affects Version/s 10.3 [ 22126 ]
            Affects Version/s 10.4 [ 22408 ]
            Affects Version/s 10.5 [ 23123 ]
            Affects Version/s 10.6 [ 24028 ]
            Affects Version/s 10.7 [ 24805 ]
            Affects Version/s 10.8 [ 26121 ]
            Affects Version/s 10.9 [ 26905 ]
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 10.11 [ 27614 ]
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 10.10 [ 27530 ]

            People

              bar Alexander Barkov
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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