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
        2. mysql.log
          2.20 MB
        3. trial.log
          120 kB
        4. data.tar.gz
          665 kB

        Activity

          People

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