Crash in _ma_bitmap_set_full_page_bits on Aria recovery

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

Bug Description

After getting this assertion

mysqld: ma_key_recover.c:68: _ma_unpin_all_pages: Assertion `!pinned_page->changed || undo_lsn != ((LSN)0) || !info->s->now_transactional' failed.

Aria engine was unable to recover and crashed with the following log and backtrace:

recovered pages: 0% 10% 20% 30% 40% 50% 49% 59% 69% 79% 89% 99% 100% (7.6 seconds); transactions to roll back: 1100809 21:05:57 [ERROR] mysqld got signal 11 ;
# 2010-08-09T21:05:57 stack_bottom = (nil) thread_stack 0x48000
# 2010-08-09T21:05:57 /home/buildbot/rqg-buildbot-slave/rqg-perpush-mariaengine/build/mysql-test//../sql/mysqld(my_print_stacktrace+0x35)[0xb84505]
# 2010-08-09T21:05:57 /home/buildbot/rqg-buildbot-slave/rqg-perpush-mariaengine/build/mysql-test//../sql/mysqld(handle_segfault+0x2ee)[0x66c40b]
# 2010-08-09T21:05:57 Recovery has apparently crashed.
# 2010-08-09T21:05:57 /lib64/libpthread.so.0[0x307ba0f440]
# 2010-08-09T21:05:57 /home/buildbot/rqg-buildbot-slave/rqg-perpush-mariaengine/build/mysql-test//../sql/mysqld(_ma_bitmap_set_full_page_bits+0x1c6)[0x9964d3]
# 2010-08-09T21:05:57 /home/buildbot/rqg-buildbot-slave/rqg-perpush-mariaengine/build/mysql-test//../sql/mysqld[0x984f2e]
# 2010-08-09T21:05:57 /home/buildbot/rqg-buildbot-slave/rqg-perpush-mariaengine/build/mysql-test//../sql/mysqld[0x9891a4]
# 2010-08-09T21:05:57 /home/buildbot/rqg-buildbot-slave/rqg-perpush-mariaengine/build/mysql-test//../sql/mysqld(_ma_apply_undo_row_update+0x88c)[0x99256c]
# 2010-08-09T21:05:57 /home/buildbot/rqg-buildbot-slave/rqg-perpush-mariaengine/build/mysql-test//../sql/mysqld[0x9dcc86]
# 2010-08-09T21:05:57 /home/buildbot/rqg-buildbot-slave/rqg-perpush-mariaengine/build/mysql-test//../sql/mysqld[0x9de3bc]
# 2010-08-09T21:05:57 /home/buildbot/rqg-buildbot-slave/rqg-perpush-mariaengine/build/mysql-test//../sql/mysqld(maria_apply_log+0x394)[0x9d875b]
# 2010-08-09T21:05:57 /home/buildbot/rqg-buildbot-slave/rqg-perpush-mariaengine/build/mysql-test//../sql/mysqld(maria_recovery_from_log+0x116)[0x9d8344]
# 2010-08-09T21:05:57 /home/buildbot/rqg-buildbot-slave/rqg-perpush-mariaengine/build/mysql-test//../sql/mysqld[0x9574e4]
# 2010-08-09T21:05:57 /home/buildbot/rqg-buildbot-slave/rqg-perpush-mariaengine/build/mysql-test//../sql/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0xb5)[0x7b7f34]
# 2010-08-09T21:05:57 /home/buildbot/rqg-buildbot-slave/rqg-perpush-mariaengine/build/mysql-test//../sql/mysqld[0x882e88]
# 2010-08-09T21:05:57 /home/buildbot/rqg-buildbot-slave/rqg-perpush-mariaengine/build/mysql-test//../sql/mysqld(_Z11plugin_initPiPPci+0x628)[0x88372f]
# 2010-08-09T21:05:57 /home/buildbot/rqg-buildbot-slave/rqg-perpush-mariaengine/build/mysql-test//../sql/mysqld[0x66ee0a]
# 2010-08-09T21:05:57 /home/buildbot/rqg-buildbot-slave/rqg-perpush-mariaengine/build/mysql-test//../sql/mysqld(main+0x259)[0x66f92c]
# 2010-08-09T21:05:57 /lib64/libc.so.6(__libc_start_main+0xfd)[0x307b61ec5d]
# 2010-08-09T21:05:57 /home/buildbot/rqg-buildbot-slave/rqg-perpush-mariaengine/build/mysql-test//../sql/mysqld[0x57b7f9]

RQG command line:

# 2010-08-09T21:04:38 # /home/buildbot/randgen/runall.pl \
# 2010-08-09T21:04:38 # --basedir=. \
# 2010-08-09T21:04:38 # --vardir=../../vardir-maria_many_indexes \
# 2010-08-09T21:04:38 # --grammar=/home/buildbot/randgen/conf/engines/many_indexes.yy \
# 2010-08-09T21:04:38 # --gendata=/home/buildbot/randgen/conf/engines/many_indexes.zz \
# 2010-08-09T21:04:38 # --rows=10000 \
# 2010-08-09T21:04:38 # --reporter=Backtrace,ErrorLog,Recovery,Shutdown \
# 2010-08-09T21:04:38 # --duration=240 \
# 2010-08-09T21:04:38 # --queries=1M \
# 2010-08-09T21:04:38 # --engine=Maria \
# 2010-08-09T21:04:38 # --rows=10000 \
# 2010-08-09T21:04:38 # --mysqld=--maria-checkpoint-interval=0 \
# 2010-08-09T21:04:38 # --mysqld=--log-output=file \
# 2010-08-09T21:04:38 # --seed=time

buildbot log:

http://buildbot.askmonty.org/buildbot/builders/rqg-perpush-mariaengine/builds/67/steps/rqg_maria_many_indexes/logs/stdio

Changed in maria:
assignee: nobody → Michael Widenius (monty)
milestone: none → 5.1
importance: Undecided → High
Revision history for this message
Philip Stoev (pstoev-askmonty) wrote :
Michael Widenius (monty)
Changed in maria:
status: New → In Progress
Revision history for this message
Michael Widenius (monty) wrote :

Fix commited in 5.1 tree. Will be in 5.2 shortly (doing merge just now)

Changed in maria:
status: In Progress → Fix Committed
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.

Other bug subscribers