[MDEV-18341] [Draft] Got error 176 "Read page with wrong checksum" from storage engine Aria Created: 2019-01-22  Updated: 2023-06-19  Resolved: 2023-06-19

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Aria
Affects Version/s: 10.4
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Elena Stepanova
Resolution: Cannot Reproduce Votes: 1
Labels: None

Attachments: File data.tar.gz     File mysql.err     File mysql.log     File trial.log    

 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.


Generated at Thu Feb 08 08:43:22 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.