[MDEV-3577] LP:608369 - (M)Aria engine recovery failure: "Page: 1 Found wrong page type 0' on CHECK TABLE EXTENDED Created: 2010-07-21  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 LPexportBug608369.xml     Zip Archive LPexportBug608369_var-bug608369-2.zip     Zip Archive LPexportBug608369_var-bug608369.zip    

 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.

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

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

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

Vardir, binary for bug 608369
LPexportBug608369_var-bug608369.zip

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

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

revision-id: monty@askmonty.org-20100907165839-hbgfbzsuytbxtzn2
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:

  1. 2010-09-09T07:15:19 # /home/buildbot/randgen/runall.pl \
  2. 2010-09-09T07:15:19 # --queries=1M \
  3. 2010-09-09T07:15:19 # --engine=Maria \
  4. 2010-09-09T07:15:19 # -mysqld=-log-output=file \
  5. 2010-09-09T07:15:19 # -mysqld=-maria_log_purge_type=at_flush \
  6. 2010-09-09T07:15:19 # --reporters=ErrorLog,Backtrace,Recovery,Shutdown \
  7. 2010-09-09T07:15:19 # --duration=30 \
  8. 2010-09-09T07:15:19 # --threads=1 \
  9. 2010-09-09T07:15:19 # --rows=1000 \
  10. 2010-09-09T07:15:19 # --mask-level=1 \
  11. 2010-09-09T07:15:19 # -mysqld=-loose-maria-group-commit=hard \
  12. 2010-09-09T07:15:19 # -mysqld=-loose-maria_group_commit_interval=0 \
  13. 2010-09-09T07:15:19 # -mysqld=-maria-checkpoint-interval=1 \
  14. 2010-09-09T07:15:19 # -mysqld=-maria-block-size=4K \
  15. 2010-09-09T07:15:19 # --grammar=conf/engines/varchar.yy \
  16. 2010-09-09T07:15:19 # --gendata=conf/engines/varchar.zz \
  17. 2010-09-09T07:15:19 # --mask=30809 \
  18. 2010-09-09T07:15:19 # --queries=100000000 \
  19. 2010-09-09T07:15:19 # --mask=30809 \
  20. 2010-09-09T07:15:19 # --basedir=. \
  21. 2010-09-09T07:15:19 # --seed=time \
  22. 2010-09-09T07:15:19 # --vardir=/home/buildbot/rqg-buildbot-slave/rqg-weekend/vardir-maria_recovery_weekend/current
Comment by Philip Stoev (Inactive) [ 2010-10-04 ]

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

revision-id: sergii@pisem.net-20100928164723-z1je1n4525knvk2s
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 <sergii@pisem.net>
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'

Comment by Michael Widenius [ 2010-10-04 ]

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

Hi!

>>>>> "Philip" == Philip Stoev <608369@bugs.launchpad.net> writes:

Philip> Still repeatable with:
Philip> revision-id: sergii@pisem.net-20100928164723-z1je1n4525knvk2s
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 <sergii@pisem.net>
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

Comment by Michael Widenius [ 2010-10-06 ]

Re: (M)Aria engine recovery failure: "Page: 1 Found wrong page type 0' on CHECK TABLE EXTENDED
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?

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

Re: (M)Aria engine recovery failure: "Page: 1 Found wrong page type 0' on CHECK TABLE EXTENDED
A Fresh vardir from a recent MariaDB 5.1

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

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

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

recent datadir
LPexportBug608369_var-bug608369-2.zip

Comment by Michael Widenius [ 2010-10-13 ]

Re: (M)Aria engine recovery failure: "Page: 1 Found wrong page type 0' on CHECK TABLE EXTENDED
Found one problem running the test suite that could explain this issue.
Fix is pushed in 5.1

Comment by Rasmus Johansson (Inactive) [ 2010-12-17 ]

Launchpad bug id: 608369

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