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;

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

            anikitin Andrii Nikitin (Inactive) created issue -
            anikitin Andrii Nikitin (Inactive) made changes -
            Field Original Value New Value
            Summary install_db shows corruption for rest encryption with innodb_data_home_dir=/ and two tablespaces install_db shows corruption for rest encryption with innodb_data_file_path=ibdata1:3M;
            anikitin Andrii Nikitin (Inactive) made changes -
            Attachment error1.log [ 43355 ]
            elenst Elena Stepanova made changes -
            Fix Version/s 10.1 [ 16100 ]
            elenst Elena Stepanova made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            jplindst Jan Lindström (Inactive) made changes -
            Status Confirmed [ 10101 ] In Progress [ 3 ]
            jplindst Jan Lindström (Inactive) made changes -
            Assignee Jan Lindström [ jplindst ] Andrii Nikitin [ anikitin ]
            anikitin Andrii Nikitin (Inactive) made changes -
            Assignee Andrii Nikitin [ anikitin ] Jan Lindström [ jplindst ]
            jplindst Jan Lindström (Inactive) made changes -
            Assignee Jan Lindström [ jplindst ] Marko Mäkelä [ marko ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.1.24 [ 161 ]
            jplindst Jan Lindström (Inactive) made changes -
            marko Marko Mäkelä made changes -
            Assignee Marko Mäkelä [ marko ] Jan Lindström [ jplindst ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            jplindst Jan Lindström (Inactive) made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            jplindst Jan Lindström (Inactive) made changes -
            Component/s Encryption [ 11200 ]
            Component/s Storage Engine - XtraDB [ 10135 ]
            Fix Version/s 10.1.25 [ 22542 ]
            Fix Version/s 10.1 [ 16100 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            anikitin Andrii Nikitin (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Closed [ 6 ] Stalled [ 10000 ]
            elenst Elena Stepanova made changes -
            Fix Version/s 10.1 [ 16100 ]
            Fix Version/s 10.1.25 [ 22542 ]
            jplindst Jan Lindström (Inactive) made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            jplindst Jan Lindström (Inactive) made changes -
            Rank Ranked higher
            jplindst Jan Lindström (Inactive) made changes -
            Rank Ranked higher
            jplindst Jan Lindström (Inactive) made changes -
            Rank Ranked higher
            jplindst Jan Lindström (Inactive) made changes -
            Sprint 10.1.24 [ 161 ] 10.1.24, 10.1.30 [ 161, 215 ]
            jplindst Jan Lindström (Inactive) made changes -
            Rank Ranked lower
            jplindst Jan Lindström (Inactive) made changes -
            Fix Version/s 10.3.1 [ 22532 ]
            Fix Version/s 10.2.9 [ 22611 ]
            Fix Version/s 10.1.25 [ 22542 ]
            Fix Version/s 10.1 [ 16100 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            jplindst Jan Lindström (Inactive) made changes -
            Fix Version/s 10.2.7 [ 22543 ]
            Fix Version/s 10.2.9 [ 22611 ]
            jplindst Jan Lindström (Inactive) made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 79728 ] MariaDB v4 [ 151741 ]

            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.