MariaDB

(M)Aria engine recovery failure: "Page: 1 Found wrong page type 0' on CHECK TABLE EXTENDED

Bug #608369 reported by Philip Stoev
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MariaDB
Fix Released
Medium
Michael Widenius
MariaDB 5.1

Bug Description

After recovery after kill -9 , CHECK TABLE EXTENDED on a (M)Aria table reports the following:

'Page: 1 Found wrong page type 0'

the error log says:

100721 19:13:29 [ERROR] mysqld: Table './test/table100_maria_key_pk_parts_2_int_autoinc#P#p0' is marked as crashed and should be repaired
19:13:29 [Note] Zerofilling table: './test/table100_maria_key_pk_parts_2_int_autoinc'
19:13:29 [Note] Zerofilling table: './test/table100_maria_key_pk_parts_2_int_autoinc'

RQG command line:

 /home/buildbot/randgen/runall.pl \
 --grammar=conf/engines/engine_stress.yy \
 --gendata=conf/engines/engine_stress.zz \
 --queries=1M \
 --engine=Maria \
 --mysqld=--log-output=file \
 --mysqld=--debug \
 --reporters=ErrorLog,Backtrace,Recovery,Shutdown \
 --duration=240 \
 --threads=5 \
 --rows=100 \
 --mask-level=2 \
 --mysqld=--maria-group-commit=hard \
 --mysqld=--maria_group_commit_interval=1 \
 --mysqld=--maria-checkpoint-interval=1 \
 --mysqld=--maria-block-size=16K \
 --mask=32308 \
 --queries=100000000 \
 --basedir=. \
 --seed=time \
 --vardir=/home/buildbot/rqg-buildbot-slave/rqg-weekend/vardir-maria_recovery_weekend/current

The datadir will be uploaded shortly.

Revision history for this message
Philip Stoev (pstoev-askmonty) wrote :
Changed in maria:
importance: Undecided → Medium
Revision history for this message
Philip Stoev (pstoev-askmonty) wrote :

Still repeatable with:

revision-id: <email address hidden>
date: 2010-09-07 19:58:39 +0300
build-date: 2010-09-09 10:49:08 +0300
revno: 2924
branch-nick: 5.1

RQG command line:

# 2010-09-09T07:15:19 # /home/buildbot/randgen/runall.pl \
# 2010-09-09T07:15:19 # --queries=1M \
# 2010-09-09T07:15:19 # --engine=Maria \
# 2010-09-09T07:15:19 # --mysqld=--log-output=file \
# 2010-09-09T07:15:19 # --mysqld=--maria_log_purge_type=at_flush \
# 2010-09-09T07:15:19 # --reporters=ErrorLog,Backtrace,Recovery,Shutdown \
# 2010-09-09T07:15:19 # --duration=30 \
# 2010-09-09T07:15:19 # --threads=1 \
# 2010-09-09T07:15:19 # --rows=1000 \
# 2010-09-09T07:15:19 # --mask-level=1 \
# 2010-09-09T07:15:19 # --mysqld=--loose-maria-group-commit=hard \
# 2010-09-09T07:15:19 # --mysqld=--loose-maria_group_commit_interval=0 \
# 2010-09-09T07:15:19 # --mysqld=--maria-checkpoint-interval=1 \
# 2010-09-09T07:15:19 # --mysqld=--maria-block-size=4K \
# 2010-09-09T07:15:19 # --grammar=conf/engines/varchar.yy \
# 2010-09-09T07:15:19 # --gendata=conf/engines/varchar.zz \
# 2010-09-09T07:15:19 # --mask=30809 \
# 2010-09-09T07:15:19 # --queries=100000000 \
# 2010-09-09T07:15:19 # --mask=30809 \
# 2010-09-09T07:15:19 # --basedir=. \
# 2010-09-09T07:15:19 # --seed=time \
# 2010-09-09T07:15:19 # --vardir=/home/buildbot/rqg-buildbot-slave/rqg-weekend/vardir-maria_recovery_weekend/current

Revision history for this message
Philip Stoev (pstoev-askmonty) wrote :

Still repeatable with:

revision-id: <email address hidden>
date: 2010-09-28 18:47:23 +0200
build-date: 2010-10-02 11:19:54 +0300
revno: 2872
branch-nick: 5.2
------------------------------------------------------------
revno: 2872
committer: Sergei Golubchik <email address hidden>
branch nick: 5.2
timestamp: Tue 2010-09-28 18:47:23 +0200
message:
  fixes for gcc 4.5

Message is 'Page: 249 Found wrong page type 0'

Revision history for this message
Michael Widenius (monty) wrote : [Bug 608369] Re: (M)Aria engine recovery failure: "Page: 1 Found wrong page type 0' on CHECK TABLE EXTENDED

Hi!

>>>>> "Philip" == Philip Stoev <email address hidden> writes:

Philip> Still repeatable with:
Philip> revision-id: <email address hidden>
Philip> date: 2010-09-28 18:47:23 +0200
Philip> build-date: 2010-10-02 11:19:54 +0300
Philip> revno: 2872
Philip> branch-nick: 5.2
Philip> ------------------------------------------------------------
Philip> revno: 2872
Philip> committer: Sergei Golubchik <email address hidden>
Philip> branch nick: 5.2
Philip> timestamp: Tue 2010-09-28 18:47:23 +0200
Philip> message:
Philip> fixes for gcc 4.5

Philip> Message is 'Page: 249 Found wrong page type 0'

I will look at this tomorrow.

Regards,
Monty

Revision history for this message
Michael Widenius (monty) wrote :

I did run the test 3-4 times, both with 5.1 and 5.2 but could not repeat it.

Could you please try to repeat it again and post the var directory for me to examine?

Revision history for this message
Philip Stoev (pstoev-askmonty) wrote :

A Fresh vardir from a recent MariaDB 5.1

Revision history for this message
Philip Stoev (pstoev-askmonty) wrote :
Revision history for this message
Michael Widenius (monty) wrote :

Found one problem running the test suite that could explain this issue.
Fix is pushed in 5.1

Changed in maria:
status: New → Fix Committed
assignee: nobody → Michael Widenius (monty)
Sergei Golubchik (sergii)
Changed in maria:
milestone: none → 5.1
Michael Widenius (monty)
Changed in maria:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.