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

main.repair_symlink-5543 fails with "Errcode: 249" when " Errcode: 20" is expected on some platforms

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.5.5, 10.3(EOL), 10.4(EOL)
    • 10.5
    • Tests
    • None

    Description

      While importing MariaDB 10.5.5 to Debian I saw this failure on archs and hppa:

      main.repair_symlink-5543                 [ fail ]
              Test ended at 2020-10-08 13:29:05
       
      CURRENT_TEST: main.repair_symlink-5543
      --- /<<PKGBUILDDIR>>/mysql-test/main/repair_symlink-5543.result	2020-08-07 12:57:35.000000000 +0000
      +++ /<<PKGBUILDDIR>>/mysql-test/main/repair_symlink-5543.reject	2020-10-08 13:29:05.319051025 +0000
      @@ -4,15 +4,15 @@
       # while others don't have openat and fail with errcode 20.
       repair table t1;
       Table	Op	Msg_type	Msg_text
      -test.t1	repair	error	20 for record at pos 0
      -test.t1	repair	Error	File 'MYSQL_TMP_DIR/t1.MYD' not found (Errcode: 20 "<errmsg>")
      +test.t1	repair	error	249 for record at pos 0
      +test.t1	repair	Error	File 'MYSQL_TMP_DIR/t1.MYD' not found (Errcode: 249 "<errmsg>")
       test.t1	repair	status	Operation failed
       drop table t1;
       create table t2 (a int) engine=aria data directory='MYSQL_TMP_DIR';
       insert t2 values (1);
       repair table t2;
       Table	Op	Msg_type	Msg_text
      -test.t2	repair	error	20 for record at pos 256
      -test.t2	repair	Error	File 'MYSQL_TMP_DIR/t2.MAD' not found (Errcode: 20 "<errmsg>")
      +test.t2	repair	error	249 for record at pos 256
      +test.t2	repair	Error	File 'MYSQL_TMP_DIR/t2.MAD' not found (Errcode: 249 "<errmsg>")
       test.t2	repair	status	Operation failed
       drop table t2;
      

      Full log at https://buildd.debian.org/status/fetch.php?pkg=mariadb-10.5&arch=hppa&ver=1%3A10.5.5-3%7Eexp2&stamp=1602164461&raw=0 (hppa)

      This also occured on arch alpha:

      main.repair_symlink-5543                 w2 [ fail ]
              Test ended at 2020-10-07 04:52:40
       
      CURRENT_TEST: main.repair_symlink-5543
      --- /<<PKGBUILDDIR>>/mysql-test/main/repair_symlink-5543.result	2020-08-07 12:57:35.000000000 +0000
      +++ /<<PKGBUILDDIR>>/mysql-test/main/repair_symlink-5543.reject	2020-10-07 04:52:40.440837468 +0000
      @@ -4,15 +4,15 @@
       # while others don't have openat and fail with errcode 20.
       repair table t1;
       Table	Op	Msg_type	Msg_text
      -test.t1	repair	error	20 for record at pos 0
      -test.t1	repair	Error	File 'MYSQL_TMP_DIR/t1.MYD' not found (Errcode: 20 "<errmsg>")
      +test.t1	repair	error	62 for record at pos 0
      +test.t1	repair	Error	File 'MYSQL_TMP_DIR/t1.MYD' not found (Errcode: 62 "<errmsg>")
       test.t1	repair	status	Operation failed
       drop table t1;
       create table t2 (a int) engine=aria data directory='MYSQL_TMP_DIR';
       insert t2 values (1);
       repair table t2;
       Table	Op	Msg_type	Msg_text
      -test.t2	repair	error	20 for record at pos 256
      -test.t2	repair	Error	File 'MYSQL_TMP_DIR/t2.MAD' not found (Errcode: 20 "<errmsg>")
      +test.t2	repair	error	62 for record at pos 256
      +test.t2	repair	Error	File 'MYSQL_TMP_DIR/t2.MAD' not found (Errcode: 62 "<errmsg>")
       test.t2	repair	status	Operation failed
       drop table t2;
      

      Full log at https://buildd.debian.org/status/fetch.php?pkg=mariadb-10.5&arch=alpha&ver=1%3A10.5.5-2&stamp=1602049326&raw=0 (alpha).

      This is very similar to MDEV-12215 (fixed by cvicentiu), the number is just different.

      Attachments

        Issue Links

          Activity

            I filed this downstream in Debian as https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=972055 and https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=972060 in case some hppa or alpha experts from Debian could help out.

            otto Otto Kekäläinen added a comment - I filed this downstream in Debian as https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=972055 and https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=972060 in case some hppa or alpha experts from Debian could help out.

            While reviewing 10.6.7 build status in Debian I saw this failure on sparc64:

            main.repair_symlink-5543                 w11 [ fail ]
                    Test ended at 2022-02-25 11:03:12
             
            CURRENT_TEST: main.repair_symlink-5543
            --- /<<PKGBUILDDIR>>/mysql-test/main/repair_symlink-5543.result	2022-02-10 20:07:03.000000000 +0000
            +++ /<<PKGBUILDDIR>>/mysql-test/main/repair_symlink-5543.reject	2022-02-25 11:03:11.794236299 +0000
            @@ -4,15 +4,15 @@
             # while others don't have openat and fail with errcode 20.
             repair table t1;
             Table	Op	Msg_type	Msg_text
            -test.t1	repair	error	20 for record at pos 0
            -test.t1	repair	Error	File 'MYSQL_TMP_DIR/t1.MYD' not found (Errcode: 20 "<errmsg>")
            +test.t1	repair	error	62 for record at pos 0
            +test.t1	repair	Error	File 'MYSQL_TMP_DIR/t1.MYD' not found (Errcode: 62 "<errmsg>")
             test.t1	repair	status	Operation failed
             drop table t1;
             create table t2 (a int) engine=aria data directory='MYSQL_TMP_DIR';
             insert t2 values (1);
             repair table t2;
             Table	Op	Msg_type	Msg_text
            -test.t2	repair	error	20 for record at pos 256
            -test.t2	repair	Error	File 'MYSQL_TMP_DIR/t2.MAD' not found (Errcode: 20 "<errmsg>")
            +test.t2	repair	error	62 for record at pos 256
            +test.t2	repair	Error	File 'MYSQL_TMP_DIR/t2.MAD' not found (Errcode: 62 "<errmsg>")
             test.t2	repair	status	Operation failed
             drop table t2;
            

            Full log at https://buildd.debian.org/status/fetch.php?pkg=mariadb-10.6&arch=sparc64&ver=1%3A10.6.7-2%7Eexp1&stamp=1645787355&raw=0

            otto Otto Kekäläinen added a comment - While reviewing 10.6.7 build status in Debian I saw this failure on sparc64: main.repair_symlink-5543 w11 [ fail ] Test ended at 2022-02-25 11:03:12   CURRENT_TEST: main.repair_symlink-5543 --- /<<PKGBUILDDIR>>/mysql-test/main/repair_symlink-5543.result 2022-02-10 20:07:03.000000000 +0000 +++ /<<PKGBUILDDIR>>/mysql-test/main/repair_symlink-5543.reject 2022-02-25 11:03:11.794236299 +0000 @@ -4,15 +4,15 @@ # while others don't have openat and fail with errcode 20. repair table t1; Table Op Msg_type Msg_text -test.t1 repair error 20 for record at pos 0 -test.t1 repair Error File 'MYSQL_TMP_DIR/t1.MYD' not found (Errcode: 20 "<errmsg>") +test.t1 repair error 62 for record at pos 0 +test.t1 repair Error File 'MYSQL_TMP_DIR/t1.MYD' not found (Errcode: 62 "<errmsg>") test.t1 repair status Operation failed drop table t1; create table t2 (a int) engine=aria data directory='MYSQL_TMP_DIR'; insert t2 values (1); repair table t2; Table Op Msg_type Msg_text -test.t2 repair error 20 for record at pos 256 -test.t2 repair Error File 'MYSQL_TMP_DIR/t2.MAD' not found (Errcode: 20 "<errmsg>") +test.t2 repair error 62 for record at pos 256 +test.t2 repair Error File 'MYSQL_TMP_DIR/t2.MAD' not found (Errcode: 62 "<errmsg>") test.t2 repair status Operation failed drop table t2; Full log at https://buildd.debian.org/status/fetch.php?pkg=mariadb-10.6&arch=sparc64&ver=1%3A10.6.7-2%7Eexp1&stamp=1645787355&raw=0

            Also fails on FreeBSD 10.3+

            10.4 3327bb609

            main.repair_symlink-5543                 w3 [ fail ]
                    Test ended at 2022-04-12 14:12:13
             
            CURRENT_TEST: main.repair_symlink-5543
            --- /usr/local/share/mysql-test/main/repair_symlink-5543.result	2022-04-12 13:31:00.404936000 +0000
            +++ /tmp/var/3/log/repair_symlink-5543.reject	2022-04-12 14:12:13.002811000 +0000
            @@ -4,15 +4,15 @@
             # while others don't have openat and fail with errcode 20.
             repair table t1;
             Table	Op	Msg_type	Msg_text
            -test.t1	repair	error	20 for record at pos 0
            -test.t1	repair	Error	File 'MYSQL_TMP_DIR/t1.MYD' not found (Errcode: 20 "<errmsg>")
            +test.t1	repair	error	31 for record at pos 0
            +test.t1	repair	Error	File 'MYSQL_TMP_DIR/t1.MYD' not found (Errcode: 31 "<errmsg>")
             test.t1	repair	status	Operation failed
             drop table t1;
             create table t2 (a int) engine=aria data directory='MYSQL_TMP_DIR';
             insert t2 values (1);
             repair table t2;
             Table	Op	Msg_type	Msg_text
            -test.t2	repair	error	20 for record at pos 256
            -test.t2	repair	Error	File 'MYSQL_TMP_DIR/t2.MAD' not found (Errcode: 20 "<errmsg>")
            +test.t2	repair	error	31 for record at pos 256
            +test.t2	repair	Error	File 'MYSQL_TMP_DIR/t2.MAD' not found (Errcode: 31 "<errmsg>")
             test.t2	repair	status	Operation failed
             drop table t2;
             
            mysqltest: Result content mismatch
            

            elenst Elena Stepanova added a comment - Also fails on FreeBSD 10.3+ 10.4 3327bb609 main.repair_symlink-5543 w3 [ fail ] Test ended at 2022-04-12 14:12:13   CURRENT_TEST: main.repair_symlink-5543 --- /usr/local/share/mysql-test/main/repair_symlink-5543.result 2022-04-12 13:31:00.404936000 +0000 +++ /tmp/var/3/log/repair_symlink-5543.reject 2022-04-12 14:12:13.002811000 +0000 @@ -4,15 +4,15 @@ # while others don't have openat and fail with errcode 20. repair table t1; Table Op Msg_type Msg_text -test.t1 repair error 20 for record at pos 0 -test.t1 repair Error File 'MYSQL_TMP_DIR/t1.MYD' not found (Errcode: 20 "<errmsg>") +test.t1 repair error 31 for record at pos 0 +test.t1 repair Error File 'MYSQL_TMP_DIR/t1.MYD' not found (Errcode: 31 "<errmsg>") test.t1 repair status Operation failed drop table t1; create table t2 (a int) engine=aria data directory='MYSQL_TMP_DIR'; insert t2 values (1); repair table t2; Table Op Msg_type Msg_text -test.t2 repair error 20 for record at pos 256 -test.t2 repair Error File 'MYSQL_TMP_DIR/t2.MAD' not found (Errcode: 20 "<errmsg>") +test.t2 repair error 31 for record at pos 256 +test.t2 repair Error File 'MYSQL_TMP_DIR/t2.MAD' not found (Errcode: 31 "<errmsg>") test.t2 repair status Operation failed drop table t2;   mysqltest: Result content mismatch

            People

              cvicentiu Vicențiu Ciorbaru
              otto Otto Kekäläinen
              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.