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

mysqld crash with coredump on start up

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.4.11
    • N/A
    • Server
    • CentOS 7.7

    Description

      On start as an galera cluster member it will crash with an coredump.

      Attachments

        Issue Links

          Activity

            mariaTux Frank added a comment -

            The coredump is compressed with xz, because it is 90MB Big.

            mariaTux Frank added a comment - The coredump is compressed with xz, because it is 90MB Big.
            danblack Daniel Black added a comment -

            gdb bt from core

            (gdb) bt
            #0  my_read (Filedes=11, 
                Buffer=0x7f275a7f8e20 "Limit", ' ' <repeats 21 times>, "Soft Limit", ' ' <repeats 11 times>, "Hard Limit", ' ' <repeats 11 times>, "Units     \nMax cpu time", ' ' <repeats 14 times>, "unlimited", ' ' <repeats 12 times>, "unlimited", ' ' <repeats 12 times>, "seconds   \nMax file size", ' ' <repeats 13 times>, "unlimited       "..., Count=4096, MyFlags=<optimized out>)
                at /usr/src/debug/MariaDB-10.4.11/src_0/mysys/my_read.c:63
            #1  0x000055a31a0aa13d in output_core_info () at /usr/src/debug/MariaDB-10.4.11/src_0/sql/signal_handler.cc:66
            #2  0x000055a31a0aa530 in handle_fatal_signal (sig=11) at /usr/src/debug/MariaDB-10.4.11/src_0/sql/signal_handler.cc:339
            #3  0x00007f276edfc5f0 in funlockfile () from /lib64/libpthread.so.0
            #4  0x0000000000000000 in ?? ()
            (gdb) bt full
            #0  my_read (Filedes=11, 
                Buffer=0x7f275a7f8e20 "Limit", ' ' <repeats 21 times>, "Soft Limit", ' ' <repeats 11 times>, "Hard Limit", ' ' <repeats 11 times>, "Units     \nMax cpu time", ' ' <repeats 14 times>, "unlimited", ' ' <repeats 12 times>, "unlimited", ' ' <repeats 12 times>, "seconds   \nMax file size", ' ' <repeats 13 times>, "unlimited       "..., Count=4096, MyFlags=<optimized out>)
                at /usr/src/debug/MariaDB-10.4.11/src_0/mysys/my_read.c:63
                    got_errno = <optimized out>
                    readbytes = 1323
                    save_count = 0
            #1  0x000055a31a0aa13d in output_core_info () at /usr/src/debug/MariaDB-10.4.11/src_0/sql/signal_handler.cc:66
                    buff = "Limit", ' ' <repeats 21 times>, "Soft Limit", ' ' <repeats 11 times>, "Hard Limit", ' ' <repeats 11 times>, "Units     \nMax cpu time", ' ' <repeats 14 times>, "unlimited", ' ' <repeats 12 times>, "unlimited", ' ' <repeats 12 times>, "seconds   \nMax file size", ' ' <repeats 13 times>, "unlimited", ' ' <repeats 12 times>...
                    len = <optimized out>
                    fd = 11
            #2  0x000055a31a0aa530 in handle_fatal_signal (sig=11) at /usr/src/debug/MariaDB-10.4.11/src_0/sql/signal_handler.cc:339
                    curr_time = 1580201858
                    tm = {tm_sec = 38, tm_min = 57, tm_hour = 9, tm_mday = 28, tm_mon = 0, tm_year = 120, tm_wday = 2, tm_yday = 27, tm_isdst = 0, tm_gmtoff = 3600, tm_zone = 0x55a31d0121a0 "CET"}
                    print_invalid_query_pointer = false
            #3  0x00007f276edfc5f0 in funlockfile () from /lib64/libpthread.so.0
            No symbol table info available.
            #4  0x0000000000000000 in ?? ()
            No symbol table info available.
            

            This is a known (and I believe fixed) problem with the signal handler. I can't see the original cause however

            (gdb) info threads
              Id   Target Id         Frame 
              8    Thread 0x7f275affc700 (LWP -1) (Exiting) PC register is not available
             
            (gdb) p thread_list 
            $3 = {{m_key = 0x55a31b072520 <key_worker_thread>, m_name = 0x55a31a7f2c14 "worker_thread", m_flags = 0}, {m_key = 0x55a31b072518 <key_timer_thread>, m_name = 0x55a31a7e8ac5 "timer_thread", 
                m_flags = 1}}
            (gdb) p thread_list[0]
            $4 = {m_key = 0x55a31b072520 <key_worker_thread>, m_name = 0x55a31a7f2c14 "worker_thread", m_flags = 0}
            (gdb) p thread_list[1]
            $5 = {m_key = 0x55a31b072518 <key_timer_thread>, m_name = 0x55a31a7e8ac5 "timer_thread", m_flags = 1}
            

            I'm sorry, I'm stuck getting any useful information out of this.

            danblack Daniel Black added a comment - gdb bt from core (gdb) bt #0 my_read (Filedes=11, Buffer=0x7f275a7f8e20 "Limit", ' ' <repeats 21 times>, "Soft Limit", ' ' <repeats 11 times>, "Hard Limit", ' ' <repeats 11 times>, "Units \nMax cpu time", ' ' <repeats 14 times>, "unlimited", ' ' <repeats 12 times>, "unlimited", ' ' <repeats 12 times>, "seconds \nMax file size", ' ' <repeats 13 times>, "unlimited "..., Count=4096, MyFlags=<optimized out>) at /usr/src/debug/MariaDB-10.4.11/src_0/mysys/my_read.c:63 #1 0x000055a31a0aa13d in output_core_info () at /usr/src/debug/MariaDB-10.4.11/src_0/sql/signal_handler.cc:66 #2 0x000055a31a0aa530 in handle_fatal_signal (sig=11) at /usr/src/debug/MariaDB-10.4.11/src_0/sql/signal_handler.cc:339 #3 0x00007f276edfc5f0 in funlockfile () from /lib64/libpthread.so.0 #4 0x0000000000000000 in ?? () (gdb) bt full #0 my_read (Filedes=11, Buffer=0x7f275a7f8e20 "Limit", ' ' <repeats 21 times>, "Soft Limit", ' ' <repeats 11 times>, "Hard Limit", ' ' <repeats 11 times>, "Units \nMax cpu time", ' ' <repeats 14 times>, "unlimited", ' ' <repeats 12 times>, "unlimited", ' ' <repeats 12 times>, "seconds \nMax file size", ' ' <repeats 13 times>, "unlimited "..., Count=4096, MyFlags=<optimized out>) at /usr/src/debug/MariaDB-10.4.11/src_0/mysys/my_read.c:63 got_errno = <optimized out> readbytes = 1323 save_count = 0 #1 0x000055a31a0aa13d in output_core_info () at /usr/src/debug/MariaDB-10.4.11/src_0/sql/signal_handler.cc:66 buff = "Limit", ' ' <repeats 21 times>, "Soft Limit", ' ' <repeats 11 times>, "Hard Limit", ' ' <repeats 11 times>, "Units \nMax cpu time", ' ' <repeats 14 times>, "unlimited", ' ' <repeats 12 times>, "unlimited", ' ' <repeats 12 times>, "seconds \nMax file size", ' ' <repeats 13 times>, "unlimited", ' ' <repeats 12 times>... len = <optimized out> fd = 11 #2 0x000055a31a0aa530 in handle_fatal_signal (sig=11) at /usr/src/debug/MariaDB-10.4.11/src_0/sql/signal_handler.cc:339 curr_time = 1580201858 tm = {tm_sec = 38, tm_min = 57, tm_hour = 9, tm_mday = 28, tm_mon = 0, tm_year = 120, tm_wday = 2, tm_yday = 27, tm_isdst = 0, tm_gmtoff = 3600, tm_zone = 0x55a31d0121a0 "CET"} print_invalid_query_pointer = false #3 0x00007f276edfc5f0 in funlockfile () from /lib64/libpthread.so.0 No symbol table info available. #4 0x0000000000000000 in ?? () No symbol table info available. This is a known (and I believe fixed) problem with the signal handler. I can't see the original cause however (gdb) info threads Id Target Id Frame 8 Thread 0x7f275affc700 (LWP -1) (Exiting) PC register is not available   (gdb) p thread_list $3 = {{m_key = 0x55a31b072520 <key_worker_thread>, m_name = 0x55a31a7f2c14 "worker_thread", m_flags = 0}, {m_key = 0x55a31b072518 <key_timer_thread>, m_name = 0x55a31a7e8ac5 "timer_thread", m_flags = 1}} (gdb) p thread_list[0] $4 = {m_key = 0x55a31b072520 <key_worker_thread>, m_name = 0x55a31a7f2c14 "worker_thread", m_flags = 0} (gdb) p thread_list[1] $5 = {m_key = 0x55a31b072518 <key_timer_thread>, m_name = 0x55a31a7e8ac5 "timer_thread", m_flags = 1} I'm sorry, I'm stuck getting any useful information out of this.

            danblack should we just close this?

            masonmariadb Mason Sharp (Inactive) added a comment - danblack should we just close this?
            danblack Daniel Black added a comment -

            Its been fixed in the duplicate task MDEV-30613

            danblack Daniel Black added a comment - Its been fixed in the duplicate task MDEV-30613

            People

              danblack Daniel Black
              mariaTux Frank
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.