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

[Draft] Got error 176 "Read page with wrong checksum" from storage engine Aria

    XMLWordPrintable

Details

    Description

      https://travis-ci.org/elenst/travis-tests/jobs/482522726 [2556 9 4]

      10.4 382115b992

      2019-01-22  0:27:47 18 [ERROR] mysqld: Got error 176 "Read page with wrong checksum" from storage engine Aria
      2019-01-22  0:27:47 18 [Warning] Sort aborted, host: localhost, user: rqg, thread: 18, query: UPDATE LOW_PRIORITY IGNORE `table10_key_pk_parts_2_int_autoinc` AS X SET `col_int` = 116 WHERE X.`col_int_key` IN ( 6, 9, 3786670080, 3, 'p' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 7 /* QNO 864 CON_ID 18 */
      2019-01-22  0:27:47 19 [ERROR] mysqld: Got error 176 "Read page with wrong checksum" from storage engine Aria
      2019-01-22  0:27:47 19 [Warning] Sort aborted, host: localhost, user: rqg, thread: 19, query: DELETE LOW_PRIORITY QUICK FROM `view_table10_key_pk_parts_2_int_autoinc` WHERE `pk` IN ( SELECT `col_char_12` FROM `view_table2_int_autoinc` WHERE `pk` = 3962765312 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3
      2019-01-22  0:27:47 19 [ERROR] mysqld: Got error 176 "Read page with wrong checksum" from storage engine Aria
      2019-01-22  0:27:47 19 [Warning] Sort aborted, host: localhost, user: rqg, thread: 19, query: DELETE LOW_PRIORITY IGNORE FROM `table10_key_pk_parts_2_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 /* QNO 898 CON_ID 19 */
      2019-01-22  0:27:47 17 [ERROR] mysqld: Table 'table10_key_pk_parts_2_int_autoinc' is marked as crashed and should be repaired
      2019-01-22  0:27:47 17 [Warning] Aborted connection 17 to db: 'test' user: 'rqg' host: 'localhost' (Got an error reading communication packets)
      2019-01-22  0:27:47 20 [ERROR] mysqld: Table './test/table10_key_pk_parts_2_int_autoinc#P#p0' is marked as crashed and should be repaired
      2019-01-22  0:27:47 20 [Warning] Recovering table: './test/table10_key_pk_parts_2_int_autoinc'
      2019-01-22  0:27:47 20 [Note] Found 0 of 1 rows when repairing './test/table10_key_pk_parts_2_int_autoinc'
      2019-01-22  0:27:47 20 [Warning] Checking table:   './test/table10_key_pk_parts_2_int_autoinc'
      

      elenst-jira-refs 8b68af909d Toolbox: b534cb88ebe

      perl ./runall-new.pl --basedir=/home/travis/server --vardir=/home/travis/logs/vardir --duration=350 --threads=6 --seed=1548116856 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --views --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/instant_add.yy --redefine=conf/mariadb/modules/alter_table_columns.yy --redefine=conf/mariadb/sp.yy --redefine=conf/mariadb/bulk_insert.yy --redefine=conf/mariadb/modules/admin.yy --redefine=conf/mariadb/modules/userstat.yy --redefine=conf/mariadb/modules/foreign_keys.yy -redefine=conf/mariadb/modules/locks.yy --redefine=conf/mariadb/modules/sql_mode.yy --redefine=conf/mariadb/modules/acl.yy --redefine=conf/mariadb/versioning.yy --redefine=conf/mariadb/sequences.yy --redefine=conf/mariadb/modules/locks-10.4-extra.yy --mysqld=--log_output=FILE --mysqld=--max-statement-time=30 --mysqld=--lock-wait-timeout=10 --mysqld=--loose-innodb-lock-wait-timeout=5 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --mysqld=--default-storage-engine=Aria --grammar=conf/engines/engine_stress.yy --gendata=conf/engines/engine_stress.zz --mysqld=--log_bin_trust_function_creators=1 --mysqld=--log-bin --transformers=ExecuteAsIntersect,ExecuteAsExcept,ExecuteAsCTE,ExecuteAsExecuteImmediate,ExecuteAsDeleteReturning,ExecuteAsInsertSelect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsPreparedTwice --redefine=conf/mariadb/general-workarounds.yy --filter=/home/travis/mariadb-toolbox/travis/10.4-combo-filter.ff
      

      Not reproducible right away.

      Attachments

        1. mysql.err
          7 kB
          Elena Stepanova
        2. mysql.log
          2.20 MB
          Elena Stepanova
        3. trial.log
          120 kB
          Elena Stepanova
        4. data.tar.gz
          665 kB
          Elena Stepanova

        Issue Links

          Activity

            People

              elenst Elena Stepanova
              elenst Elena Stepanova
              Votes:
              1 Vote for this issue
              Watchers:
              2 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.