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

Galera cluster received "mariadbd[2354817]: segfault" Error

    XMLWordPrintable

Details

    Description

      Hi Team,

      Customer got segfault error on db nodes. Here I have attached the backtrace report. It looks like two complex selects and one of them crashed while accessing some wrong memory area while in Aria temporary table related code.

      Please check the attached backtrace report.

      mariadbd[2354817]: segfault at 7f5ac5fb8862 ip 00007f5a8d127764 sp 00007f5a80438468 error 4 in libc-2.28.so[7f5a8cfc7000+1bc000]
       
      [Tue Oct  5 15:24:37 2021] Core dump to |/opt/dynatrace/oneagent/agent/rdp -p 3204035 -P 3204035 -e mariadbd -s 11 pipe failed
      [Tue Oct  5 15:24:54 2021] mariadbd[3205298]: segfault at 3dd0 ip 000055ca9186ca60 sp 00007f855c1fe508 error 4 in mariadbd[55ca91147000+1536000]
      [Tue Oct  5 15:24:54 2021] Code: 00 00 00 00 00 00 5b 41 5c 5d c3 0f 1f 80 00 00 00 00 48 83 bb 50 02 00 00 00 0f 85 00 ff ff ff e9 4e ff ff ff 0f 1f 44 00 00 <48> 8b 87 d0 3d 00 00 c3 0f 1f 84 00 00 00 00 00 8b 97 f4 3d 00 00
      [Tue Oct  5 15:24:54 2021] Core dump to |/opt/dynatrace/oneagent/agent/rdp -p 3205291 -P 3205291 -e mariadbd -s 11 pipe failed
      [Tue Oct  5 15:25:14 2021] mariadbd[3206416]: segfault at 3dd0 ip 0000555794a11a60 sp 00007fdffc0c1508 error 4 in mariadbd[5557942ec000+1536000]
      

      Attachments

        1. full_bt_all_threads.txt
          392 kB
        2. db02dmesg.txt
          18 kB
        3. alf_node (1).txt
          2 kB
        4. alf_node_aspects (1).txt
          0.5 kB
        5. alf_node_properties (1).txt
          1 kB
        6. alf_node_aspects_data.sql
          10 kB
        7. alf_node_data.sql
          111 kB
        8. alf_node_properties_data.sql
          54 kB

        Activity

          People

            monty Michael Widenius
            ponsuresh.pandians Pon Suresh Pandian (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            7 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.