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

install_db shows corruption for rest encryption with innodb_data_file_path=ibdata1:3M;

    XMLWordPrintable

Details

    • 10.1.24, 10.1.30

    Description

      When trying to install database with rest encryption and config like :

      innodb_file_per_table=0
      innodb_data_home_dir=/
      innodb_data_file_path=/home/a/innodb_data_home_dir/ibdata1:3M;/home/a/innodb_data_home_dir/ibdata2:10M:autoextend
      

      Errors below are shown:

      Space id in fsp header 3176603904,but in the page header 0
      [Note] InnoDB: Highest supported file format is Barracuda.
      [ERROR] InnoDB: Corruption: Block in space_id 0 in file //home/a/innodb_data_home_dir/ibdata1 corrupted
      [ERROR] InnoDB: Based on page type SYS (6)
      [ERROR] InnoDB: Database page corruption on disk or a failed
      [ERROR] InnoDB: Space 0 file //home/a/innodb_data_home_dir/ibdata1 read of page 192.
      [ERROR] InnoDB: You may have to recover from a backup.
      InnoDB: Page dump in ascii and hex (16384 bytes):
       len 16384; hex c32efd07000000c000000000000000000000000000042...
      2017-02-22 15:11:15 7fb0eb12ebc0 InnoDB: uncompressed page, stored checksum in field1 3274636551, calculated checksums for field1: crc32 1289775906, innodb 511039384, none 3735928559, stored checksum in field2 3103017090, calculated checksums for field2: crc32 1289775906, innodb 3103017090, none 3735928559, page LSN 0 274306, low 4 bytes of LSN at page end 274306, page number (if stored to page already) 192, space id (if created with >= MySQL-4.1.1 and stored already) 0
      and later:
      2017-02-22 15:11:15 7fb0eb12ebc0  InnoDB: Assertion failure in thread 140397834857408 in file buf0buf.cc line 4844
      ..
      mysys/stacktrace.c:268(my_print_stacktrace)[0x7fb0e91b43ea]
      buf/buf0buf.cc:4710(buf_page_io_complete(buf_page_t*))[0x558c4c25bc1a]
      buf/buf0rea.cc:262(buf_read_page_low(dberr_t*, bool, unsigned long, unsigned long, unsigned long, unsigned long, long, unsigned long, trx_t*, buf_page_t**))[0x558c4c26febf]
      buf/buf0rea.cc:474(buf_read_page(unsigned long, unsigned long, unsigned long, trx_t*, buf_page_t**))[0x558c4c2710f4]
      buf/buf0buf.cc:3002(buf_page_get_gen(unsigned long, unsigned long, unsigned long, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, dberr_t*))[0x558c4c2569ea]
      include/trx0rseg.ic:73(trx_rsegf_get_new)[0x558c4c21015e]
      trx/trx0rseg.cc:289(trx_rseg_create_instance)[0x558c4c210a4c]
      trx/trx0sys.cc:661(trx_sys_init_at_db_start())[0x558c4c211f6e]
      srv/srv0start.cc:2545(innobase_start_or_create_for_mysql())[0x558c4c1fb93b]
      /sql/mysqld(+0x79a5ed)[0x558c4c1385ed]
      handler/ha_innodb.cc:4439(innobase_init(void*))[0x558c4bf01ec5]
      sql/handler.cc:513(ha_initialize_handlerton(st_plugin_int*))[0x558c4bda663b]
      sql/sql_plugin.cc:1687(plugin_init(int*, char**, int))[0x558c4bda753a]
      sql/mysqld.cc:5148(init_server_components())[0x558c4bd121ad]
      sql/mysqld.cc:5739(mysqld_main(int, char**))[0x558c4bd16a4a]
      

      When trying the same without encryption - no crash happens.
      When trying single ibdata file - no crash happens (e.g. innodb_data_file_path=/home/a/innodb_data_home_dir/ibdata1:3M:autoextend )

      Attachments

        1. error.log
          111 kB
        2. error1.log
          111 kB
        3. innodb_data_home_dir.zip
          4.90 MB

        Issue Links

          Activity

            People

              jplindst Jan Lindström (Inactive)
              anikitin Andrii Nikitin (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.