[MDEV-3283] LP:616253 - Crash in _ma_bitmap_set_full_page_bits on Aria recovery Created: 2010-08-11  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: Major
Reporter: Philip Stoev (Inactive) Assignee: Michael Widenius
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug616253.xml     Zip Archive LPexportBug616253_var-bug616253.zip    

 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 ;

  1. 2010-08-09T21:05:57 stack_bottom = (nil) thread_stack 0x48000
  2. 2010-08-09T21:05:57 /home/buildbot/rqg-buildbot-slave/rqg-perpush-mariaengine/build/mysql-test//../sql/mysqld(my_print_stacktrace+0x35)[0xb84505]
  3. 2010-08-09T21:05:57 /home/buildbot/rqg-buildbot-slave/rqg-perpush-mariaengine/build/mysql-test//../sql/mysqld(handle_segfault+0x2ee)[0x66c40b]
  4. 2010-08-09T21:05:57 Recovery has apparently crashed.
  5. 2010-08-09T21:05:57 /lib64/libpthread.so.0[0x307ba0f440]
  6. 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]
  7. 2010-08-09T21:05:57 /home/buildbot/rqg-buildbot-slave/rqg-perpush-mariaengine/build/mysql-test//../sql/mysqld[0x984f2e]
  8. 2010-08-09T21:05:57 /home/buildbot/rqg-buildbot-slave/rqg-perpush-mariaengine/build/mysql-test//../sql/mysqld[0x9891a4]
  9. 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]
  10. 2010-08-09T21:05:57 /home/buildbot/rqg-buildbot-slave/rqg-perpush-mariaengine/build/mysql-test//../sql/mysqld[0x9dcc86]
  11. 2010-08-09T21:05:57 /home/buildbot/rqg-buildbot-slave/rqg-perpush-mariaengine/build/mysql-test//../sql/mysqld[0x9de3bc]
  12. 2010-08-09T21:05:57 /home/buildbot/rqg-buildbot-slave/rqg-perpush-mariaengine/build/mysql-test//../sql/mysqld(maria_apply_log+0x394)[0x9d875b]
  13. 2010-08-09T21:05:57 /home/buildbot/rqg-buildbot-slave/rqg-perpush-mariaengine/build/mysql-test//../sql/mysqld(maria_recovery_from_log+0x116)[0x9d8344]
  14. 2010-08-09T21:05:57 /home/buildbot/rqg-buildbot-slave/rqg-perpush-mariaengine/build/mysql-test//../sql/mysqld[0x9574e4]
  15. 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]
  16. 2010-08-09T21:05:57 /home/buildbot/rqg-buildbot-slave/rqg-perpush-mariaengine/build/mysql-test//../sql/mysqld[0x882e88]
  17. 2010-08-09T21:05:57 /home/buildbot/rqg-buildbot-slave/rqg-perpush-mariaengine/build/mysql-test//../sql/mysqld(_Z11plugin_initPiPPci+0x628)[0x88372f]
  18. 2010-08-09T21:05:57 /home/buildbot/rqg-buildbot-slave/rqg-perpush-mariaengine/build/mysql-test//../sql/mysqld[0x66ee0a]
  19. 2010-08-09T21:05:57 /home/buildbot/rqg-buildbot-slave/rqg-perpush-mariaengine/build/mysql-test//../sql/mysqld(main+0x259)[0x66f92c]
  20. 2010-08-09T21:05:57 /lib64/libc.so.6(__libc_start_main+0xfd)[0x307b61ec5d]
  21. 2010-08-09T21:05:57 /home/buildbot/rqg-buildbot-slave/rqg-perpush-mariaengine/build/mysql-test//../sql/mysqld[0x57b7f9]

RQG command line:

  1. 2010-08-09T21:04:38 # /home/buildbot/randgen/runall.pl \
  2. 2010-08-09T21:04:38 # --basedir=. \
  3. 2010-08-09T21:04:38 # --vardir=../../vardir-maria_many_indexes \
  4. 2010-08-09T21:04:38 # --grammar=/home/buildbot/randgen/conf/engines/many_indexes.yy \
  5. 2010-08-09T21:04:38 # --gendata=/home/buildbot/randgen/conf/engines/many_indexes.zz \
  6. 2010-08-09T21:04:38 # --rows=10000 \
  7. 2010-08-09T21:04:38 # --reporter=Backtrace,ErrorLog,Recovery,Shutdown \
  8. 2010-08-09T21:04:38 # --duration=240 \
  9. 2010-08-09T21:04:38 # --queries=1M \
  10. 2010-08-09T21:04:38 # --engine=Maria \
  11. 2010-08-09T21:04:38 # --rows=10000 \
  12. 2010-08-09T21:04:38 # -mysqld=-maria-checkpoint-interval=0 \
  13. 2010-08-09T21:04:38 # -mysqld=-log-output=file \
  14. 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



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

Re: Crash in _ma_bitmap_set_full_page_bits on Aria recovery

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

core, binary , vardir
LPexportBug616253_var-bug616253.zip

Comment by Michael Widenius [ 2010-08-24 ]

Re: Crash in _ma_bitmap_set_full_page_bits on Aria recovery
Fix commited in 5.1 tree. Will be in 5.2 shortly (doing merge just now)

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

Launchpad bug id: 616253

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