Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-3283

LP:616253 - Crash in _ma_bitmap_set_full_page_bits on Aria recovery

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      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

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            philipstoev Philip Stoev added a comment -

            core, binary , vardir
            LPexportBug616253_var-bug616253.zip

            Show
            philipstoev Philip Stoev added a comment - core, binary , vardir LPexportBug616253_var-bug616253.zip
            Hide
            philipstoev Philip Stoev added a comment -

            Re: Crash in _ma_bitmap_set_full_page_bits on Aria recovery

            Show
            philipstoev Philip Stoev added a comment - Re: Crash in _ma_bitmap_set_full_page_bits on Aria recovery
            Hide
            monty Michael Widenius added a comment -

            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)

            Show
            monty Michael Widenius added a comment - 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)
            Hide
            ratzpo Rasmus Johansson added a comment -

            Launchpad bug id: 616253

            Show
            ratzpo Rasmus Johansson added a comment - Launchpad bug id: 616253

              People

              • Assignee:
                monty Michael Widenius
                Reporter:
                philipstoev Philip Stoev
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: