[MDEV-3173] LP:602169 - RQG: Assertion "crc" == "failure in REDO_INDEX" on Maria engine recovery Created: 2010-07-06  Updated: 2015-02-02  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Philip Stoev (Inactive) Assignee: Michael Widenius
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug602169.xml     Zip Archive LPexportBug602169_var-bug602169-2.zip     Zip Archive LPexportBug602169_var-bug602169trace.zip     Zip Archive LPexportBug602169_var-mariabug602169.zip    

 Description   

When recovering from a kill -9 crash that happened during a DML workload, maria 5.3 crashed as follows:

#8 0x00897de8 in __assert_fail () from /lib/libc.so.6
#9 0x08557165 in _ma_apply_redo_index (info=0x9c94d60, lsn=4297618642, header=0x9c75816 "\346\017\271*\267\273", head_length=18) at ma_key_recover.c:987
#10 0x085bda51 in exec_REDO_LOGREC_REDO_INDEX (rec=0xbfe2a8b0) at ma_recovery.c:1571
#11 0x085bb5db in display_and_apply_record (log_desc=0x9265440, rec=0xbfe2a8b0) at ma_recovery.c:517
#12 0x085bfee3 in run_redo_phase (lsn=4294975495, apply=MARIA_LOG_APPLY) at ma_recovery.c:2507
#13 0x085baf94 in maria_apply_log (from_lsn=4294975495, apply=MARIA_LOG_APPLY, trace_file=0x9c251a0, should_run_undo_phase=1 '\001', skip_DDLs_arg=1 '\001',
take_checkpoints=1 '\001', warnings_count=0xbfe2d434) at ma_recovery.c:316
#14 0x085bac7c in maria_recovery_from_log () at ma_recovery.c:218
#15 0x085404f3 in ha_maria_init (p=0x9c16dd0) at ha_maria.cc:3265
#16 0x083b9d09 in ha_initialize_handlerton (plugin=0x9c08f08) at handler.cc:429
#17 0x08473e5f in plugin_initialize (plugin=0x9c08f08) at sql_plugin.cc:1038
#18 0x084746d5 in plugin_init (argc=0x8a4e318, argv=0x9bdba40, flags=0) at sql_plugin.cc:1267
#19 0x0827a0ec in init_server_components () at mysqld.cc:4113
#20 0x0827abb2 in main (argc=14, argv=0xbfe2da24) at mysqld.cc:4587

The tablespaces before and after recovery will be uploaded shortly.

 Comments   
Comment by Philip Stoev (Inactive) [ 2010-07-06 ]

Re: Assertion "crc" == "failure in REDO_INDEX" on Maria engine recovery

Comment by Philip Stoev (Inactive) [ 2010-07-06 ]

Vardir before and after recovery + core file + binary
LPexportBug602169_var-mariabug602169.zip

Comment by Philip Stoev (Inactive) [ 2010-07-06 ]

Re: Assertion "crc" == "failure in REDO_INDEX" on Maria engine recovery
[philips@eve mysql-test]$ bzr version-info
revision-id: psergey@askmonty.org-20100614111754-355l5i07xlq51r05
date: 2010-06-14 15:17:54 +0400
build-date: 2010-07-06 01:21:22 -0700
revno: 2789
branch-nick: maria

Comment by Philip Stoev (Inactive) [ 2010-07-21 ]

Re: RQG: Assertion "crc" == "failure in REDO_INDEX" on Maria engine recovery

Comment by Philip Stoev (Inactive) [ 2010-07-21 ]

Trace , core , binary , vardir for bug 602169
LPexportBug602169_var-bug602169trace.zip

Comment by Philip Stoev (Inactive) [ 2010-07-21 ]

Re: RQG: Assertion "crc" == "failure in REDO_INDEX" on Maria engine recovery
Please ignore last attachment, it was for a different bug. Please use the first , original attachment when debugging this bug.

Comment by Philip Stoev (Inactive) [ 2010-08-25 ]

Re: RQG: Assertion "crc" == "failure in REDO_INDEX" on Maria engine recovery
RQG command line:

  1. 2010-08-25T02:11:48 # /home/buildbot/randgen/runall.pl \
  2. 2010-08-25T02:11:48 # --basedir=. \
  3. 2010-08-25T02:11:48 # --vardir=../../vardir-maria_varchar \
  4. 2010-08-25T02:11:48 # --grammar=/home/buildbot/randgen/conf/engines/varchar.yy \
  5. 2010-08-25T02:11:48 # --gendata=/home/buildbot/randgen/conf/engines/varchar.zz \
  6. 2010-08-25T02:11:48 # --reporter=Backtrace,ErrorLog,Recovery,Shutdown \
  7. 2010-08-25T02:11:48 # --duration=240 \
  8. 2010-08-25T02:11:48 # --queries=1M \
  9. 2010-08-25T02:11:48 # --engine=Maria \
  10. 2010-08-25T02:11:48 # -mysqld=-maria-checkpoint-interval=0 \
  11. 2010-08-25T02:11:48 # -mysqld=-log-output=file \
  12. 2010-08-25T02:11:48 # --seed=time \
  13. 2010-08-25T02:11:48 # -mysqld=-loose-skip-innodb \
  14. 2010-08-25T02:11:48 # -mysqld=-loose-pbxt=OFF

This bug is readily repeatable in buildbot on the varchar.yy test.

Comment by Philip Stoev (Inactive) [ 2010-08-27 ]

Re: RQG: Assertion "crc" == "failure in REDO_INDEX" on Maria engine recovery

Comment by Philip Stoev (Inactive) [ 2010-08-27 ]

datadir with latest maria debuging code
LPexportBug602169_var-bug602169-2.zip

Comment by Rasmus Johansson (Inactive) [ 2010-09-09 ]

Launchpad bug id: 602169

Generated at Thu Feb 08 06:46:48 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.