Maridb Crashed with Signal 11

Mariadb Logs

240717 10:41:33 [ERROR] mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.

To report this bug, see https://mariadb.com/kb/en/reporting-bugs

We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

Server version: 10.11.5-MariaDB-log source revision: 7875294b6b74b53dd3aaa723e6cc103d2bb47b2c
key_buffer_size=67108864
read_buffer_size=131072
max_used_connections=452
max_threads=802
thread_count=470
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1831964 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x7f7cb80008e8
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x7fcbccf2db98 thread_stack 0x49000
/usr/sbin/mariadbd(my_print_stacktrace+0x2e)[0x55c77cbc012e]
mysys/stacktrace.c:216(my_print_stacktrace)[0x55c77c6b95b5]
/lib64/libpthread.so.0(+0x12cf0)[0x7fcbe2e97cf0]
sql/sql_yacc.yy:9072(MYSQLparse(THD*))[0x55c77c63f117]
sql/sql_parse.cc:10394(parse_sql(THD*, Parser_state*, Object_creation_ctx*, bool))[0x55c77c46f81a]
sql/sql_parse.cc:7988(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x55c77c46ba1a]
sql/sql_parse.cc:1896(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x55c77c4756e6]
sql/sql_parse.cc:1407(do_command(THD*, bool))[0x55c77c476dab]
sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x55c77c58a977]
sql/sql_connect.cc:1318(handle_one_connection)[0x55c77c58acbd]
perfschema/pfs.cc:2204(MyCTX_nopad::finish(unsigned char*, unsigned int*))[0x55c77c8c0c9d]
/lib64/libpthread.so.0(+0x81ca)[0x7fcbe2e8d1ca]
/lib64/libc.so.6(clone+0x43)[0x7fcbe21dde73]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x7f7cb800b390): Select Users.UserIndex, UserID, Users.Password, GroupName, PasswordSource, UserService, UserIP, FilterName, UserActive, Users.StartDate, UserExpiryDate, CallBackNumber, CallerID, Lockout, Users.PasswordEncryptionMethod, MaxUserSessions, SkipPasswordCheck, HotlineStatus, BarringStatus, BarringReason, MaxVolumeCap, AllowedAccessTypes, CopyRadiusRequests, SubnetIP, SubnetMask, CIDR, CustomField1, CustomField2, CustomField3, CustomField4, CustomField5, CustomNumField1, CustomNumField2, CustomNumField3, CustomNumField4, CustomNumField5, SessionLimit, UserTokens, FirstLogon, FramedInterfaceId, FramedIPv6Prefix, PeriodicTimeUsage, PeriodicVolumeUsage, TimeUsageTriggerThresholds, VolumeUsageTriggerThresholds, CustomReplylist, CustomChecklist, BillingSystemCorrelationId, ChargingSystemCorrelationId, ChargingMode, LockOutTime, LockOutCount, Users.PseudoIdentity, CustomDate1, CustomDate2, CustomDate3, CustomDate4, CustomDate5, CustomField6, CustomField7, CustomField8, CustomField9, CustomField10, RestrictedLocations, MaxTimeCap, PortId, CustomNumField6, CustomNumField7, CustomNumField8, CustomNumField9, CustomNumField10,SpeedMapName,UserIPv6,NetworkService, CustomField11,CustomField12,CustomField13,CustomField14,CustomField15 , PasswordDate From Users Where UserID = '03344946559'

Connection ID (thread ID): 13937254
Status: NOT_KILLED

Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on,not_null_range_scan=off,hash_join_cardinality=off

The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
information that should help you find out what is causing the crash.
Writing a core file...
Working directory at /var/lib/mysql
Resource Limits:
Limit Soft Limit Hard Limit Units
Max cpu time unlimited unlimited seconds
Max file size unlimited unlimited bytes
Max data size unlimited unlimited bytes
Max stack size 8388608 unlimited bytes
Max core file size unlimited unlimited bytes
Max resident set unlimited unlimited bytes
Max processes 2061710 2061710 processes
Max open files 32768 32768 files
Max locked memory 65536 65536 bytes
Max address space unlimited unlimited bytes
Max file locks unlimited unlimited locks
Max pending signals 2061710 2061710 signals
Max msgqueue size 819200 819200 bytes
Max nice priority 0 0
Max realtime priority 0 0
Max realtime timeout unlimited unlimited us
Core pattern: /var/coredumps/core.%e.%p

Kernel version: Linux version 4.18.0-477.13.1.el8_8.x86_64 (mockbuild@x86-vm-08.build.eng.bos.redhat.com) (gcc version 8.5.0 20210514 (Red Hat 8.5.0-18) (GCC)) #1 SMP Thu May 18 10:27:05 EDT 2023

2024-07-17 10:42:21 0 [Note] Starting MariaDB 10.11.5-MariaDB-log source revision 7875294b6b74b53dd3aaa723e6cc103d2bb47b2c as process 2167842
2024-07-17 10:42:21 0 [Note] mariadbd: Aria engine: starting recovery
tables to flush: 2 1 0
(0.0 seconds);

/var/log/messages
Jul 17 10:40:11 ALEPO-DB2-ILB systemd[1]: Stopped User Manager for UID 0.
Jul 17 10:40:11 ALEPO-DB2-ILB systemd[1]: Stopping User runtime directory /run/user/0...
Jul 17 10:40:11 ALEPO-DB2-ILB systemd[1]: run-user-0.mount: Succeeded.
Jul 17 10:40:11 ALEPO-DB2-ILB systemd[1]: user-runtime-dir@0.service: Succeeded.
Jul 17 10:40:11 ALEPO-DB2-ILB systemd[1]: Stopped User runtime directory /run/user/0.
Jul 17 10:40:11 ALEPO-DB2-ILB systemd[1]: Removed slice User Slice of UID 0.
Jul 17 10:42:15 ALEPO-DB2-ILB systemd[1]: mariadb.service: Main process exited, code=killed, status=11/SEGV
Jul 17 10:42:15 ALEPO-DB2-ILB systemd[1]: mariadb.service: Failed with result 'signal'.
Jul 17 10:42:20 ALEPO-DB2-ILB systemd[1]: mariadb.service: Service RestartSec=5s expired, scheduling restart.
Jul 17 10:42:20 ALEPO-DB2-ILB systemd[1]: mariadb.service: Scheduled restart job, restart counter is at 12.
Jul 17 10:42:20 ALEPO-DB2-ILB systemd[1]: Stopped MariaDB 10.11.5 database server.
Jul 17 10:42:20 ALEPO-DB2-ILB systemd[1]: Starting MariaDB 10.11.5 database server...
Jul 17 10:42:21 ALEPO-DB2-ILB mariadbd[2167842]: 2024-07-17 10:42:21 0 [Warning] Could not increase number of max_open_files to more than 32768 (request: 65535)
Jul 17 10:42:45 ALEPO-DB2-ILB systemd[1]: Started MariaDB 10.11.5 database server.
Jul 17 10:44:19 ALEPO-DB2-ILB NetworkManager[1266]: <info> [1721195059.0381] policy: auto-activating connection 'opt-net' (3cd38034-58b2-40cd-8cc7-5afcda959b31)
Jul 17 10:44:19 ALEPO-DB2-ILB NetworkManager[1266]: <info> [1721195059.0388] device (enp9s0): Activation: starting connection 'opt-net' (3cd38034-58b2-40cd-8cc7-5afcda959b31)

07:00:00 AM kbmemfree kbavail kbmemused %memused kbbuffers kbcached kbcommit %commit kbactive kbinact kbdirty
07:10:00 AM 34215836 322876156 493619712 93.52 569984 262893528 332670724 59.26 1593404 482181112 33020
07:20:00 AM 33177656 322896864 494657892 93.71 571400 263858484 332542012 59.24 1594972 483190804 10960
07:30:00 AM 32102480 322310032 495733068 93.92 572764 264838492 332584244 59.24 1596544 484232352 21992
07:40:00 AM 30999052 321376392 496836496 94.13 574204 265860896 332491804 59.23 1598144 485303536 14120
07:50:00 AM 29917492 320407340 497918056 94.33 575632 266841028 332613472 59.25 1599732 486351736 13872
08:00:00 AM 28848732 319473704 498986816 94.53 577080 267826488 332294864 59.19 1601324 487388524 25412
08:10:00 AM 27689652 318517808 500145896 94.75 578624 268887536 332291396 59.19 1603032 488512288 2376
08:20:00 AM 26597764 317601032 501237784 94.96 580164 269881772 332587384 59.24 1604744 489572096 16996
08:30:00 AM 25526864 316659728 502308684 95.16 581624 270865896 332526028 59.23 1606392 490609216 30900
08:40:00 AM 24391860 315712276 503443688 95.38 583064 271916380 332371304 59.21 1607984 491710552 45352
08:50:00 AM 23307584 314763428 504527964 95.58 584544 272905720 332281748 59.19 1609752 492761376 2836
09:00:00 AM 22207020 313797024 505628528 95.79 585900 273904388 332371232 59.21 1611244 493827476 27012
09:10:00 AM 21020724 312886188 506814824 96.02 587340 274983840 332408836 59.21 1612852 494978520 26840
09:20:00 AM 19928652 311944236 507906896 96.22 588868 275989048 332643960 59.25 1614532 496036904 47040
09:30:00 AM 18858884 311002372 508976664 96.43 590244 276982764 332496892 59.23 1616076 497075200 23284
09:40:00 AM 17716364 310056104 510119184 96.64 591652 278030924 332242620 59.18 1617608 498184680 30760
09:50:00 AM 16612440 309091960 511223108 96.85 593120 279039212 332112824 59.16 1619256 499254040 1936
10:00:00 AM 15515748 308180360 512319800 97.06 594648 280044400 332379652 59.21 1620952 500318724 37200
10:10:00 AM 14315320 307228916 513520228 97.29 596172 281132700 332346520 59.20 1622636 501482884 42924
10:20:00 AM 13209984 306269312 514625564 97.50 597592 282146252 332492708 59.23 1624208 502553928 30084
10:30:00 AM 12118180 305335580 515717368 97.70 599048 283156688 332264624 59.19 1625848 503613004 54816
10:40:00 AM 10962300 304375880 516873248 97.92 600540 284222876 332449040 59.22 1627508 504734396 38772
10:50:00 AM 208299160 511418192 319536388 60.54 601180 295642140 331621992 59.07 3986368 305177692 38392
11:00:00 AM 207294532 511403240 320541016 60.73 603704 296602436 331879144 59.12 3993352 306143720 16572
11:10:00 AM 205729232 510869644 322106316 61.02 606860 297603272 331656916 59.08 4001340 307668700 35940
11:20:00 AM 204288824 510824272 323546724 61.30 611996 298824588 331953132 59.13 4010880 309006044 15484
11:30:00 AM 202882992 510459076 324952556 61.56 614852 299835092 332458348 59.22 4032340 310357540 5712
11:40:00 AM 202161312 510828172 325674236 61.70 617612 300893760 331614492 59.07 4038040 311043536 31164
11:50:00 AM 201160472 510824680 326675076 61.89 620172 301861808 331907640 59.12 4043008 312009324 14736
12:00:00 PM 200242736 510832148 327592812 62.06 622800 302759152 331820940 59.11 4047012 312897728 2904
12:10:00 PM 198867460 510883984 328968088 62.32 626184 304079540 331914856 59.12 4051936 314222324 9664
12:20:00 PM 197088144 510637656 330747404 62.66 628796 305582420 332109372 59.16 4062588 315955848 41540
Average: 66295242 347044608 461540306 87.44 562447 259413131 332347047 59.20 1903979 449964299 21006