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

DB server crashing with Segmentation fault - Signal 11 error

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Incomplete
    • 11.3.2
    • N/A
    • None

    Description

      Hello Team,

      We are continuously observing DB server crash issue due to Segmentation fault - signal 11 error.

      Kindly check the issue on priority basis and provide the resolution.

      Kindly find attached log and gdb analysis for your reference.

      [root@ALEPO-DB1-ILB ~]# 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 Thu 2024-07-11 11:42:18 PKT; 30min ago
      Docs: man:mariadbd(8)
      https://mariadb.com/kb/en/library/systemd/
      Process: 679817 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
      Process: 679353 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && s>
      Process: 679351 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
      Main PID: 679579 (mariadbd)
      Status: "Taking your SQL requests now..."
      Tasks: 36 (limit: 3298736)
      Memory: 24.2G
      CGroup: /system.slice/mariadb.service
      ââ679579 /usr/sbin/mariadbd

      Jul 11 11:41:27 ALEPO-DB1-ILB systemd[1]: Starting MariaDB 10.11.5 database server...
      Jul 11 11:41:28 ALEPO-DB1-ILB mariadbd[679579]: 2024-07-11 11:41:28 0 [Warning] Could not increase number of max_open_files to more than 32768 (request: 655>
      Jul 11 11:42:18 ALEPO-DB1-ILB systemd[1]: Started MariaDB 10.11.5 database server.

      Kindly refer the below link for corefile.
      https://drive.google.com/file/d/13-qPpT9ms1oNx7S-vIXVOP-gbYqLZ2E0/view?usp=sharing

      Attachments

        1. gdb.txt
          3.02 MB
        2. gdb.txt.gz
          2.00 MB
        3. gdb-1.txt
          2.45 MB
        4. mariadbd (2).7z
          5.99 MB
        5. messages_110724
          8.29 MB
        6. mysqld110724.log
          615 kB

        Issue Links

          Activity

            People

              Gosselin Dave Gosselin
              Priya Kunte Priya Kunte
              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.