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

Segmentation fault (Signal 11) in INSERT SELECT (change_item_list_context)

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.11.5
    • N/A
    • Parser

    Description

      Hello Team,

      We have observed DB2 crash on 2nd OCT with Segmentation fault -Signal 11 error and VIP got shifted to DB1

      As we are facing this issue frequently kindly provide the solution for this issue.

      Kindly find below details for your reference

      [root@ALEPO-DB2-ILB tmp]# systemctl status mysqld
      ● mariadb.service - MariaDB 10.11.5 database server
         Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
        Drop-In: /etc/systemd/system/mariadb.service.d
                 └─migrated-from-my.cnf-settings.conf
         Active: active (running) since Wed 2024-10-02 16:06:54 PKT; 6 days ago
           Docs: man:mariadbd(8)
                 https://mariadb.com/kb/en/library/systemd/
        Process: 7607 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCES>
        Process: 7256 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/gal>
        Process: 7253 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
       Main PID: 7476 (mariadbd)
         Status: "Taking your SQL requests now..."
          Tasks: 486 (limit: 3298736)
         Memory: 461.2G
         CGroup: /system.slice/mariadb.service
                 └─7476 /usr/sbin/mariadbd
       
      [root@ALEPO-DB2-ILB mysql]# mysql --version
      mysql  Ver 15.1 Distrib 10.11.5-MariaDB, for Linux (x86_64) using readline 5.1
      

      var/log/messages
      Oct  2 16:06:27 ALEPO-DB2-ILB systemd[1]: mariadb.service: Main process exited, code=killed, status=11/SEGV
      Oct  2 16:06:27 ALEPO-DB2-ILB systemd[1]: mariadb.service: Failed with result 'signal'.
      Oct  2 16:06:32 ALEPO-DB2-ILB systemd[1]: mariadb.service: Service RestartSec=5s expired, scheduling restart.
      Oct  2 16:06:32 ALEPO-DB2-ILB systemd[1]: mariadb.service: Scheduled restart job, restart counter is at 1.
      Oct  2 16:06:32 ALEPO-DB2-ILB systemd[1]: Stopped MariaDB 10.11.5 database server.
      Oct  2 16:06:32 ALEPO-DB2-ILB systemd[1]: Starting MariaDB 10.11.5 database server...
      Oct  2 16:06:33 ALEPO-DB2-ILB mariadbd[7476]: 2024-10-02 16:06:33 0 [Warning] Could not increase number of max_open_files to more than 32768 (request: 65535)
      Oct  2 16:06:34 ALEPO-DB2-ILB NetworkManager[1266]: <info>  [1727867194.0230] device (enp9s0): state change: ip-config -> failed (reason 'ip-config-unavailable', sys-iface-state: 'managed')
      Oct  2 16:06:34 ALEPO-DB2-ILB NetworkManager[1266]: <warn>  [1727867194.0235] device (enp9s0): Activation: failed for connection 'opt-net'
      Oct  2 16:06:34 ALEPO-DB2-ILB NetworkManager[1266]: <info>  [1727867194.0237] device (enp9s0): state change: failed -> disconnected (reason 'none', sys-iface-state: 'managed')
      Oct  2 16:06:34 ALEPO-DB2-ILB NetworkManager[1266]: <info>  [1727867194.0337] dhcp4 (enp9s0): canceled DHCP transaction
      Oct  2 16:06:34 ALEPO-DB2-ILB NetworkManager[1266]: <info>  [1727867194.0345] policy: auto-activating connection 'opt-net' (3cd38034-58b2-40cd-8cc7-5afcda959b31)
      Oct  2 16:06:34 ALEPO-DB2-ILB NetworkManager[1266]: <info>  [1727867194.0349] device (enp9s0): Activation: starting connection 'opt-net' (3cd38034-58b2-40cd-8cc7-5afcda959b31)
      

      Kindly find attached mysql logs, gdb output and sar report.

      Please let us know if you required any additional information to debug the issue.

      Attachments

        1. gdb_db2_02OCT.txt.gz
          198 kB
        2. mysqld.log_DB2_02OCT
          14 kB
        3. sar_db2_02oct.txt
          8 kB
        4. sar_memory_db2_02_oct.txt
          13 kB

        Issue Links

          Activity

            People

              Unassigned Unassigned
              Priya Kunte Priya Kunte
              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.