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

Crash recovery fails with "The size of tablespace file ... is only 32768, should be at least 65536!" for ROW_FORMAT=COMPRESSED

    XMLWordPrintable

Details

    • Can result in data loss

    Description

                                                                                                                                                                                                                                          
      --source include/have_innodb.inc                                                                                                                                                                                                               
      SET GLOBAL innodb_log_checkpoint_now=ON;                                                                                                                                                                                                       
      CREATE TABLE t1 (a INT) ENGINE=InnoDB ROW_FORMAT=COMPRESSED;                                                                                                                                                                                   
      --source include/kill_mysqld.inc                                                                                                                                                                                                               
      --remove_file $MARIADB_DATADIR/test/t1.ibd                                                                                                                                                                                                     
      --source include/start_mysqld.inc                                                                                                                                                                                                              
      --source include/restart_mysqld.inc                                                                                                                                                                                                            
      INSERT INTO t1 VALUES (1);                                                                                                                                                                                                                     
      --source include/kill_mysqld.inc                                                                                                                                                                                                               
      --source include/start_mysqld.inc                                                                                                                                                                                                              
      SELECT * FROM t1;                                                                                                                                                                                                                              
      DROP TABLE t1;                                                                                                                                                                                                                                 
      

      Leads to:
      INNODB_ERROR|The size of tablespace file './test/t1.ibd' is only 32768, should be at least 65536!

      INFO: no cores found at data*/core nor at node*/core, and no *SAN or Valgrind report found in var/log/mysqld.1.err

      Bug Detection Matrix

                                                                                                                                                                                                                  
            Rel    o/d  Build   Commit                                    UniqueID observed                                                                                                                                                              
        CS  10.11  dbg  121026  7aecfef1072045404167edaaba4656edf218a7a8  INNODB_ERROR|The size of tablespace file './test/t1.ibd' is only 32768, should be at least 65536!                                                                              
        CS  10.11  opt  121026  7aecfef1072045404167edaaba4656edf218a7a8  INNODB_ERROR|The size of tablespace file './test/t1.ibd' is only 32768, should be at least 65536!                                                                              
        CS  11.4   dbg  121026  fd85202eb2f866bac7117b5a4542b76f438e2780  INNODB_ERROR|The size of tablespace file './test/t1.ibd' is only 32768, should be at least 65536!                                                                              
        CS  11.4   opt  121026  fd85202eb2f866bac7117b5a4542b76f438e2780  INNODB_ERROR|The size of tablespace file './test/t1.ibd' is only 32768, should be at least 65536!                                                                              
        CS  11.8   dbg  121026  14362356d14b80242d60dceb9b34f988bbcc9945  INNODB_ERROR|The size of tablespace file './test/t1.ibd' is only 32768, should be at least 65536!                                                                              
        CS  11.8   opt  121026  14362356d14b80242d60dceb9b34f988bbcc9945  INNODB_ERROR|The size of tablespace file './test/t1.ibd' is only 32768, should be at least 65536!                                                                              
        CS  12.3   dbg  121026  5e1d303aa6acf34c09309a9d64d750f20fc1921d  INNODB_ERROR|The size of tablespace file './test/t1.ibd' is only 32768, should be at least 65536!                                                                              
        CS  12.3   opt  121026  5e1d303aa6acf34c09309a9d64d750f20fc1921d  INNODB_ERROR|The size of tablespace file './test/t1.ibd' is only 32768, should be at least 65536!                                                                              
        CS  13.0   dbg  121026  620a4b5624222048fece7fe1789978ae0675cae2  INNODB_ERROR|The size of tablespace file './test/t1.ibd' is only 32768, should be at least 65536!                                                                              
        CS  13.0   opt  121026  620a4b5624222048fece7fe1789978ae0675cae2  INNODB_ERROR|The size of tablespace file './test/t1.ibd' is only 32768, should be at least 65536!                                                                              
        CS  13.2   dbg  121026  cf542109f3389838b4b688b78941797f6a95d51f  INNODB_ERROR|The size of tablespace file './test/t1.ibd' is only 32768, should be at least 65536!                                                                              
        CS  13.2   opt  121026  cf542109f3389838b4b688b78941797f6a95d51f  INNODB_ERROR|The size of tablespace file './test/t1.ibd' is only 32768, should be at least 65536!                                                                              
        ES  10.6   dbg  121026  4cdc4f0b741fd1a3cc3fc34c7dc197a5b12c65cc  MTR|Path '/test/t1.ibd' is not a subdirectory of MYSQLTEST_VARDIR '/test/EMD121026-mariadb-10.6.29-25-linux-x86_64-dbg/mysql-test/var'or MYSQL_TMP_DIR                         
        '/test/EMD121026-mariadb-1                                                                                                                                                                                                                       
        0.6.29-25-linux-x86_64-dbg/mysql-test/var/tmp'                                                                                                                                                                                                   
        ES  10.6   opt  121026  4cdc4f0b741fd1a3cc3fc34c7dc197a5b12c65cc  MTR|query 'SET GLOBAL innodb_log_checkpoint_now=ON' failed: ER_UNKNOWN_SYSTEM_VARIABLE (1193): Unknown system variable 'innodb_log_checkpoint_now'                             
        ES  11.4   dbg  121026  f1a52e7bb41922f37759b2d6a7d7dbd6b779dd40  INNODB_ERROR|The size of tablespace file './test/t1.ibd' is only 32768, should be at least 65536!                                                                              
        ES  11.4   opt  121026  f1a52e7bb41922f37759b2d6a7d7dbd6b779dd40  INNODB_ERROR|The size of tablespace file './test/t1.ibd' is only 32768, should be at least 65536!                                                                              
        ES  11.8   dbg  121026  2b449b705bc9223b003a05bed300873361e5e970  INNODB_ERROR|The size of tablespace file './test/t1.ibd' is only 32768, should be at least 65536!                                                                              
        ES  11.8   opt  121026  2b449b705bc9223b003a05bed300873361e5e970  INNODB_ERROR|The size of tablespace file './test/t1.ibd' is only 32768, should be at least 65536!                                                                              
        ES  12.3   dbg  121026  b09ac90250cf897f23f243954754ed88c57f4f31  INNODB_ERROR|The size of tablespace file './test/t1.ibd' is only 32768, should be at least 65536!                                                                              
        ES  12.3   opt  121026  b09ac90250cf897f23f243954754ed88c57f4f31  INNODB_ERROR|The size of tablespace file './test/t1.ibd' is only 32768, should be at least 65536!                                                                              
        

      Attachments

        Activity

          People

            tafzeel Mohammad Tafzeel Shams
            saahil Saahil Alam
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Time Tracking

                Estimated:
                Original Estimate - 0d
                0d
                Remaining:
                Time Spent - 1.25h Remaining Estimate - 3d
                3d
                Logged:
                Time Spent - 1.25h Remaining Estimate - 3d
                1.25h

                Git Integration

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