[MDEV-21582] mysqld crash with coredump on start up Created: 2020-01-28  Updated: 2023-10-19  Resolved: 2023-10-19

Status: Closed
Project: MariaDB Server
Component/s: Server
Affects Version/s: 10.4.11
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Frank Assignee: Daniel Black
Resolution: Duplicate Votes: 0
Labels: galera
Environment:

CentOS 7.7


Attachments: File coredump.xz    
Issue Links:
Duplicate
duplicates MDEV-30613 output_core_info crashes in my_read() Closed

 Description   

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



 Comments   
Comment by Frank [ 2020-01-28 ]

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

Comment by Daniel Black [ 2020-10-02 ]

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.

Comment by Mason Sharp [ 2023-10-19 ]

danblack should we just close this?

Comment by Daniel Black [ 2023-10-19 ]

Its been fixed in the duplicate task MDEV-30613

Generated at Thu Feb 08 09:08:14 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.