[MDEV-3297] LP:607284 - Maria engine recovery failure: Record-count is not ok on CHECK TABLE EXTENDED Created: 2010-07-19  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: Minor
Reporter: Philip Stoev (Inactive) Assignee: Michael Widenius
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug607284.xml     Zip Archive LPexportBug607284_var-bug607284.zip    

 Description   

When executing CHECK TABLE EXTENDED after a kill -9 + recovery , the server reports:

Record-count is not ok; found 342 Should be: 438

The tablespace before and after recovery will be uploaded shortly

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

Re: Maria engine recovery failure: Record-count is not ok on CHECK TABLE EXTENDED
This issue has been observed 3 times so far, each time with --maria-block-size=1K

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

This issue has been observed 3 times so far, each time with --maria-block-size=1K
Datadir for bug 607284
LPexportBug607284_var-bug607284.zip

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

Re: Maria engine recovery failure: Record-count is not ok on CHECK TABLE EXTENDED
RQG command line:

perl runall.pl \
--grammar=conf/engines/engine_stress.yy \
--gendata=conf/engines/engine_stress.zz \
--queries=1M \
--engine=Maria \
-mysqld=-log-output=file \
-mysqld=-log-bin \
--reporters=ErrorLog,Backtrace,Recovery,Shutdown \
--duration=360 \
--threads=1 \
--rows=10 \
--mask-level=1 \
-mysqld=-maria-repair-threads=2 \
-mysqld=-loose-maria-group-commit=soft \
-mysqld=-loose-maria_group_commit_interval=1000000 \
-mysqld=-maria-checkpoint-interval=1 \
-mysqld=-maria-block-size=1K \
--mask=24165 \
--queries=100000000 \
--basedir=. \
--seed=1282735012

Comment by Michael Widenius [ 2012-03-27 ]

Re: Maria engine recovery failure: Record-count is not ok on CHECK TABLE EXTENDED
Have now run the test case for 2 hours on MariaDB 5.3 without any problems, so I have to assume that his bug has already been fixed.
(I am quite sure that other similar bugs has been fixed since this bug was reported).

Comment by Rasmus Johansson (Inactive) [ 2012-03-27 ]

Launchpad bug id: 607284

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