[MDEV-3400] LP:636872 - "Record at pos: is not remove-marked' and "record delete-link-chain corrupted' after Aria recovery Created: 2010-09-13  Updated: 2012-10-04  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: Not a Bug Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug636872.xml     Zip Archive LPexportBug636872_var-bug636872.zip    

 Description   

After recovering using mysqld from the SMF RQG scenario, the server reported the following:

  1. 2010-09-13T09:13:39 100913 9:13:39 [Warning] Checking table: './smf2/smf_boards'
  2. 2010-09-13T09:13:39 100913 9:13:39 [Warning] Recovering table: './smf2/smf_boards'
  3. 2010-09-13T09:13:39 100913 9:13:39 [Note] Found 296 of 287 rows when repairing './smf2/smf_boards'

CHECK TABLE EXTENDED reported the following:
Record at pos: 66248 is not remove-marked
record delete-link-chain corrupted

bzr version-info:

revision-id: <email address hidden>
date: 2010-09-12 21:25:57 -0700
build-date: 2010-09-13 08:44:46 +0300
revno: 2931
branch-nick: 5.1

RQG command line:

/home/buildbot/randgen/runall.pl \
--queries=1M \
--engine=Maria \
-mysqld=-safe-mode \
-mysqld=-sync-sys=0 \
-mysqld=-log-output=file \
-mysqld=-maria_log_purge_type=at_flush \
--reporters=ErrorLog,Backtrace,Recovery,Shutdown \
--duration=120 \
--threads=20 \
--rows=10 \
--mask-level=2 \
-mysqld=-maria-repair-threads=2 \
-mysqld=-loose-maria-group-commit=hard \
-mysqld=-loose-maria_group_commit_interval=0 \
-mysqld=-maria-checkpoint-interval=0 \
-mysqld=-maria-block-size=4K \
--mask=35049 \
--queries=100000000 \
--mask=35049 \
--seed=time \
--basedir=. \
-mysqld=-init-file=/home/buildbot/randgen/conf/smf/smf2.sql \
--grammar=conf/smf/smf2.yy

 Comments   
Comment by Philip Stoev (Inactive) [ 2010-09-13 ]

Re: "Record at pos: is not remove-marked' and "record delete-link-chain corrupted' after Aria recovery

Comment by Philip Stoev (Inactive) [ 2010-09-13 ]

datadir , logs , etc.
LPexportBug636872_var-bug636872.zip

Comment by Philip Stoev (Inactive) [ 2010-09-13 ]

Re: "Record at pos: is not remove-marked' and "record delete-link-chain corrupted' after Aria recovery
.yy and .sql files are at hasky.askmonty.org://home/pstoev/bug636872

Comment by Philip Stoev (Inactive) [ 2010-09-13 ]

Re: "Record at pos: is not remove-marked' and "record delete-link-chain corrupted' after Aria recovery
It turns out that the problematic tables were MyISAM, so their recovery is not guaranteed.

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

Launchpad bug id: 636872

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