Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.11.5
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
Issue Links
- relates to
-
MDEV-35113 DB1 crashed with segmentation fault (Signal 11) error on next day of DB2 crash
-
- Closed
-