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

MariaDB 10.11.16 crashed signal 11

    XMLWordPrintable

Details

    • Bug
    • Status: Needs Feedback (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.11.16
    • None
    • Prepared Statements
    • None

    Description

      Hello Team,

      MariaDB 10.11.16 crashed signal 11 .
      Core dump is stored at https://upload.alepo.net/core_db1_may29.zst

      MariaDB binary is present as attached

      MariaDB Logs

      260529 22:45:13 [ERROR] /usr/sbin/mariadbd got signal 11 ;
      Sorry, we probably made a mistake, and this is a bug.

      Your assistance in bug reporting will enable us to fix this for the next release.
      To report this bug, see https://mariadb.com/kb/en/reporting-bugs about how to report
      a bug on https://jira.mariadb.org/.

      Please include the information from the server start above, to the end of the
      information below.

      Server version: 10.11.16-MariaDB-log source revision: 3218602d3100db9ce7a875511a591cddc173cc16

      The information page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/
      contains instructions to obtain a better version of the backtrace below.
      Following these instructions will help MariaDB developers provide a fix quicker.

      Attempting backtrace. Include this in the bug report.
      (note: Retrieving this information may fail)

      Thread pointer: 0x7fc639b6baf8
      stack_bottom = 0x7feffac2f000 thread_stack 0x49000
      2026-05-29 22:45:16 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
      2026-05-29 22:45:16 976753 [Note] Error reading relay log event: slave SQL thread was killed
      2026-05-29 22:45:16 976753 [Note] Slave SQL thread exiting, replication stopped in log 'db2-binary.655919' at position 136333511, master: 10.76.24.77:3306
      2026-05-29 22:45:16 976752 [Note] Slave I/O thread exiting, read up to log 'db2-binary.655919', position 136333511, master 10.76.24.77:3306
      2026-05-29 22:45:16 976755 [Note] Master 's-db4': Slave SQL thread exiting, replication stopped in log 'db4-binary.635541' at position 59234527, master: 10.76.25.11:3306
      2026-05-29 22:45:16 976754 [Note] Master 's-db4': Slave I/O thread exiting, read up to log 'db4-binary.635541', position 59260968, master 10.76.25.11:3306
      /usr/sbin/mariadbd(my_print_stacktrace+0x2e)[0x555fd2e7808e]
      /usr/sbin/mariadbd(handle_fatal_signal+0x2fd)[0x555fd29331ad]
      /lib64/libpthread.so.0(+0x12cf0)[0x7ff014777cf0]
      /usr/sbin/mariadbd(_Z12setup_fieldsP3THD20Bounds_checked_arrayIP4ItemER4ListIS2_E17enum_column_usagePS6_S9_b9THD_WHERE+0x15f)[0x555fd2666d1f]
      /usr/sbin/mariadbd(_ZN18Prepared_statement7prepareEPKcj+0x1d05)[0x555fd26f9e55]
      /usr/sbin/mariadbd(_Z19mysqld_stmt_prepareP3THDPKcj+0xc8)[0x555fd26faae8]
      /usr/sbin/mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0x1e2d)[0x555fd26d64df]
      /usr/sbin/mariadbd(_Z10do_commandP3THDb+0x138)[0x555fd26d77f6]
      /usr/sbin/mariadbd(_Z24do_handle_one_connectionP7CONNECTb+0x3d5)[0x555fd2802d75]
      /usr/sbin/mariadbd(handle_one_connection+0x5d)[0x555fd28030cd]
      /usr/sbin/mariadbd(+0xcbb4b5)[0x555fd2b564b5]
      /lib64/libpthread.so.0(+0x81ca)[0x7ff01476d1ca]
      2026-05-29 22:45:36 0 [Warning] /usr/sbin/mariadbd: Thread 22985313 (user : 'alepoaaaems') did not exit

      /lib64/libc.so.6(clone+0x43)[0x7ff0138a5e73]

      Connection ID (thread ID): 22985313
      Status: KILL_SERVER
      Query (0x7fc63a5ec820): update users set userId=?, Password=?, passwordSource=?, groupName=?, userService=?, userIp=?, filterName=?, startDate=?, userExpiryDate=?, userActive=?, callBackNumber=?, callerID=?, lockout=?, lockoutTime=?, lockoutCount=?, pseudoIdentity=?, passwordEncryptionMethod=?, sessionLimit=?, usertokens=?, maxUserSessions=?, skipPasswordCheck=?, hotLineStatus=?, barringStatus=?, barringReason=?, maxVolumeCap=?, allowedAccessTypes=?, copyRadiusRequests=?, subNetIp=?, subNetMask=?, cidr=?, customField1=?, customField2=?, customField3=?, customField4=?, customField5=?, customField6=?, customField7=?, customField8=?, customField9=?, customField10=?, customNumField1=?, customNumField2=?, customNumField3=?, customNumField4=?, customNumField5=?, customNumField6=?, customNumField7=?, customNumField8=?, customNumField9=?, customNumField10=?, firstLogon=?, framedInterfaceId=?, framedIPv6Prefix=?, periodicTimeUsage=?, periodicVolumeUsage=?, timeUsageTriggerThresholds=?, volumeUsageTriggerThresholds=?, customReplylist=?, customChecklist=?, billingSystemCorrelationId=?, chargingSystemCorrelationId=?, chargingMode=?, customDate1=?, customDate2=?, customDate3=?, customDate4=?, customDate5=?, createdBy=?, tenantID=?, lastModify=?, passwordDate=?, restrictedLocations=?, maxtimecap=?, sessionLimitUnit=?, lastLogoffTime=?, lastUsageCharged=?, portId=?, speedMapName=?, userIpv6=?, networkService=?, customField11=?, customField12=?, customField13=?, customField14=?, customField15=?, createDate=? where userIndex=?

      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,cset_narrowing=off

      Writing a core file...
      Working directory at /var/lib/mysql
      Resource Limits (excludes unlimited resources):
      Limit Soft Limit Hard Limit Units
      Max stack size 8388608 unlimited bytes
      Max processes 2061710 2061710 processes
      Max open files 32768 32768 files
      Max locked memory 65536 65536 bytes
      Max pending signals 2061710 2061710 signals
      Max msgqueue size 819200 819200 bytes
      Max nice priority 0 0
      Max realtime priority 0 0
      Core pattern: /var/crash/core_%e_%p_%h_%t

      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

      2026-05-29 22:46:06 0 [Note] Starting MariaDB 10.11.16-MariaDB-log source revision 3218602d3100db9ce7a875511a591cddc173cc16 server_uid y/JvzKhpJaI5Rcq3mhSJzBiPOEs= as process 2243491
      2026-05-29 22:46:06 0 [Note] mariadbd: Aria engine: starting recovery
      recovered pages: 0% 10% 20% 38% 50% 60% 70% 80% 90% 100% (0.1 seconds); tables to flush: 4 3 2 1 0
      (0.0 seconds);
      2026-05-29 22:46:06 0 [Note] mariadbd: Aria engine: recovery done
      2026-05-29 22:46:06 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
      2026-05-29 22:46:06 0 [Note] InnoDB: Number of transaction pools: 1
      2026-05-29 22:46:06 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
      2026-05-29 22:46:06 0 [Note] InnoDB: Using Linux native AIO
      2026-05-29 22:46:06 0 [Note] InnoDB: innodb_buffer_pool_size_max=153600m, innodb_buffer_pool_size=153600m
      2026-05-29 22:46:07 0 [Note] InnoDB: Completed initialization of buffer pool
      2026-05-29 22:46:08 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
      2026-05-29 22:46:08 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=119750119242141
      2026-05-29 22:46:11 0 [Note] InnoDB: End of log at LSN=119750457305574
      2026-05-29 22:46:12 0 [Note] InnoDB: To recover: 154355 pages
      2026-05-29 22:46:23 0 [Note] InnoDB: Last binlog file './db1-binary.658319', position 111473893
      2026-05-29 22:46:23 0 [Note] InnoDB: 128 rollback segments are active.
      2026-05-29 22:46:24 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
      2026-05-29 22:46:24 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
      2026-05-29 22:46:24 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
      2026-05-29 22:46:24 0 [Note] InnoDB: log sequence number 119750457305574; transaction id 397275276996
      2026-05-29 22:46:24 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
      2026-05-29 22:46:24 0 [Note] Plugin 'FEEDBACK' is disabled.
      2026-05-29 22:46:24 0 [Warning] 'thread-concurrency' was removed. It does nothing now and exists only for compatibility with old my.cnf files.
      2026-05-29 22:46:24 0 [Warning] 'innodb-thread-concurrency' was removed. It does nothing now and exists only for compatibility with old my.cnf files.
      2026-05-29 22:46:24 0 [Warning] 'innodb-log-files-in-group' was removed. It does nothing now and exists only for compatibility with old my.cnf files.
      2026-05-29 22:46:24 0 [Note] Recovering after a crash using db1-binary
      2026-05-29 22:46:24 0 [Note] Starting table crash recovery...
      2026-05-29 22:46:24 0 [Note] Crash table recovery finished.
      2026-05-29 22:46:24 0 [Note] Server socket created on IP: '0.0.0.0', port: '3306'.
      2026-05-29 22:46:24 0 [Note] Server socket created on IP: '::', port: '3306'.
      2026-05-29 22:46:24 0 [Warning] 'user' entry '@alepo-db2-ilb' ignored in --skip-name-resolve mode.
      2026-05-29 22:46:24 0 [Warning] 'user' entry 'root@localhost.localdomain' ignored in --skip-name-resolve mode.
      2026-05-29 22:46:24 0 [Warning] 'proxies_priv' entry '@% root@alepo-db2-ilb' ignored in --skip-name-resolve mode.
      2026-05-29 22:46:24 3 [Note] Reading Master_info: 'master-s@002ddb3.info' Relay_info:'relay-log-s@002ddb3.info'
      2026-05-29 22:46:24 3 [Note] Initialized Master_info from 'master-s@002ddb3.info'
      2026-05-29 22:46:24 4 [Note] Master 's-db3': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
      2026-05-29 22:46:24 4 [ERROR] Master 's-db3': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
      2026-05-29 22:46:24 4 [Note] Master 's-db3': Slave I/O thread killed while connecting to master
      2026-05-29 22:46:24 4 [Note] Master 's-db3': Slave I/O thread exiting, read up to log 'FIRST', position 4, master :3306
      2026-05-29 22:46:24 3 [Note] Started replication for 's-db3'
      2026-05-29 22:46:24 5 [Note] Master 's-db3': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log './db1-relay-s@002ddb3.000074' position: 4
      2026-05-29 22:46:24 3 [Note] Reading Master_info: 'master-s@002ddb4.info' Relay_info:'relay-log-s@002ddb4.info'
      2026-05-29 22:46:24 3 [Note] Initialized Master_info from 'master-s@002ddb4.info'
      2026-05-29 22:46:24 18 [Note] Master 's-db4': Slave I/O thread: Start asynchronous replication to master 'gtid@10.76.25.11:3306' in log 'db4-binary.635541' at position 59260968
      2026-05-29 22:46:24 3 [Note] Started replication for 's-db4'
      2026-05-29 22:46:24 3 [Note] Reading Master_info: 'master-s@002ddb2.info' Relay_info:'relay-log-s@002ddb2.info'
      2026-05-29 22:46:24 19 [Note] Master 's-db4': Slave SQL thread initialized, starting replication in log 'db4-binary.635541' at position 59234527, relay log './db1-relay-s@002ddb4.071349' position: 783
      2026-05-29 22:46:24 3 [Note] Initialized Master_info from 'master-s@002ddb2.info'
      2026-05-29 22:46:24 20 [Note] Master 's-db2': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
      2026-05-29 22:46:24 20 [ERROR] Master 's-db2': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
      2026-05-29 22:46:24 20 [Note] Master 's-db2': Slave I/O thread killed while connecting to master
      2026-05-29 22:46:24 20 [Note] Master 's-db2': Slave I/O thread exiting, read up to log 'FIRST', position 4, master :3306
      2026-05-29 22:46:24 3 [Note] Started replication for 's-db2'
      2026-05-29 22:46:24 3 [Note] Reading Master_info: 'master-s@002ddb5.info' Relay_info:'relay-log-s@002ddb5.info'
      2026-05-29 22:46:24 21 [Note] Master 's-db2': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log './db1-relay-s@002ddb2.000073' position: 4
      2026-05-29 22:46:24 3 [Note] Initialized Master_info from 'master-s@002ddb5.info'
      2026-05-29 22:46:24 22 [Note] Master 's-db5': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
      2026-05-29 22:46:24 22 [ERROR] Master 's-db5': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
      2026-05-29 22:46:24 22 [Note] Master 's-db5': Slave I/O thread killed while connecting to master
      2026-05-29 22:46:24 22 [Note] Master 's-db5': Slave I/O thread exiting, read up to log 'FIRST', position 4, master :3306
      2026-05-29 22:46:24 3 [Note] Started replication for 's-db5'
      2026-05-29 22:46:24 23 [Note] Master 's-db5': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log './db1-relay-s@002ddb5.000065' position: 4
      2026-05-29 22:46:24 25 [Note] Slave I/O thread: Start asynchronous replication to master 'gtid@10.76.24.77:3306' in log 'db2-binary.655919' at position 136333511
      2026-05-29 22:46:24 0 [Note] /usr/sbin/mariadbd: ready for connections.
      Version: '10.11.16-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
      2026-05-29 22:46:24 26 [Note] Slave SQL thread initialized, starting replication in log 'db2-binary.655919' at position 136333511, relay log './db1-relay.162361' position: 783
      2026-05-29 22:46:24 25 [Note] Slave I/O thread: connected to master 'gtid@10.76.24.77:3306',replication started in log 'db2-binary.655919' at position 136333511
      2026-05-29 22:46:24 18 [Note] Master 's-db4': Slave I/O thread: connected to master 'gtid@10.76.25.11:3306',replication started in log 'db4-binary.635541' at position 59260968
      2026-05-29 22:46:54 189 [Note] Start binlog_dump to slave_server(3), pos(db1-binary.658319, 111473893), using_gtid(0), gtid('')
      2026-05-29 22:46:54 188 [Note] Start binlog_dump to slave_server(2), pos(db1-binary.658319, 111473893), using_gtid(0), gtid('')
      2026-05-29 22:46:54 191 [Note] Start binlog_dump to slave_server(4), pos(db1-binary.658319, 111473893), using_gtid(0), gtid('')
      2026-05-29 22:49:19 0 [Note] InnoDB: Buffer pool(s) load completed at 260529 22:49:19

      /var/log/messages
      May 28 22:45:12 ALEPO-DB1-ILB systemd[1896032]: Stopped target Sockets.
      May 28 22:45:12 ALEPO-DB1-ILB systemd[1896032]: Closed D-Bus User Message Bus Socket.
      May 28 22:45:12 ALEPO-DB1-ILB systemd[1896032]: Stopped target Paths.
      May 28 22:45:12 ALEPO-DB1-ILB systemd[1896032]: Reached target Shutdown.
      May 28 22:45:12 ALEPO-DB1-ILB systemd[1896032]: Started Exit the Session.
      May 28 22:45:12 ALEPO-DB1-ILB systemd[1896032]: Reached target Exit the Session.
      May 28 22:45:12 ALEPO-DB1-ILB systemd[1]: user@0.service: Succeeded.
      May 28 22:45:12 ALEPO-DB1-ILB systemd[1]: Stopped User Manager for UID 0.
      May 28 22:45:12 ALEPO-DB1-ILB systemd[1]: Stopping User runtime directory /run/user/0...
      May 28 22:45:12 ALEPO-DB1-ILB systemd[1]: run-user-0.mount: Succeeded.
      May 28 22:45:12 ALEPO-DB1-ILB systemd[1]: user-runtime-dir@0.service: Succeeded.
      May 28 22:45:12 ALEPO-DB1-ILB systemd[1]: Stopped User runtime directory /run/user/0.
      May 28 22:45:12 ALEPO-DB1-ILB systemd[1]: Removed slice User Slice of UID 0.
      May 28 22:45:40 ALEPO-DB1-ILB NetworkManager[1281]: <info> [1779990340.9165] device (enp9s0): state change: ip-config -> failed (reason 'ip-config-unavailable', sys-iface-state: 'managed')
      May 28 22:45:40 ALEPO-DB1-ILB NetworkManager[1281]: <warn> [1779990340.9171] device (enp9s0): Activation: failed for connection 'opt-net'
      May 28 22:45:40 ALEPO-DB1-ILB NetworkManager[1281]: <info> [1779990340.9172] device (enp9s0): state change: failed -> disconnected (reason 'none', sys-iface-state: 'managed')
      May 28 22:45:40 ALEPO-DB1-ILB NetworkManager[1281]: <info> [1779990340.9370] dhcp4 (enp9s0): canceled DHCP transaction
      May 28 22:45:40 ALEPO-DB1-ILB NetworkManager[1281]: <info> [1779990340.9383] policy: auto-activating connection 'opt-net' (38c00c03-2f91-40f7-a4bb-1a9c28006b7b)
      May 28 22:45:40 ALEPO-DB1-ILB NetworkManager[1281]: <info> [1779990340.9388] device (enp9s0): Activation: starting connection 'opt-net' (38c00c03-2f91-40f7-a4bb-1a9c28006b7b)
      May 28 22:45:40 ALEPO-DB1-ILB NetworkManager[1281]: <info> [1779990340.9389] device (enp9s0): state change: disconnected -> prepare (reason 'none', sys-iface-state: 'managed')
      May 28 22:45:40 ALEPO-DB1-ILB NetworkManager[1281]: <info> [1779990340.9391] device (enp9s0): state change: prepare -> config (reason 'none', sys-iface-state: 'managed')
      May 28 22:45:40 ALEPO-DB1-ILB NetworkManager[1281]: <info> [1779990340.9464] device (enp9s0): state change: config -> ip-config (reason 'none', sys-iface-state: 'managed')
      May 28 22:45:40 ALEPO-DB1-ILB NetworkManager[1281]: <info> [1779990340.9468] dhcp4 (enp9s0): activation: beginning transaction (timeout in 45 seconds)
      May 28 22:46:25 ALEPO-DB1-ILB snmpd[2992269]: truncating integer value > 32 bits
      May 28 22:46:25 ALEPO-DB1-ILB NetworkManager[1281]: <info> [1779990385.9178] device (enp9s0): state change: ip-config -> failed (reason 'ip-config-unavailable', sys-iface-state: 'managed')
      May 28 22:46:25 ALEPO-DB1-ILB NetworkManager[1281]: <warn> [1779990385.9181] device (enp9s0): Activation: failed for connection 'opt-net'
      May 28 22:46:25 ALEPO-DB1-ILB NetworkManager[1281]: <info> [1779990385.9183] device (enp9s0): state change: failed -> disconnected (reason 'none', sys-iface-state: 'managed')
      May 28 22:46:25 ALEPO-DB1-ILB NetworkManager[1281]: <info> [1779990385.9290] dhcp4 (enp9s0): canceled DHCP transaction
      May 28 22:46:25 ALEPO-DB1-ILB NetworkManager[1281]: <info> [1779990385.9296] policy: auto-activating connection 'opt-net' (38c00c03-2f91-40f7-a4bb-1a9c28006b7b)
      May 28 22:46:25 ALEPO-DB1-ILB NetworkManager[1281]: <info> [1779990385.9299] device (enp9s0): Activation: starting connection 'opt-net' (38c00c03-2f91-40f7-a4bb-1a9c28006b7b)
      May 28 22:46:25 ALEPO-DB1-ILB NetworkManager[1281]: <info> [1779990385.9299] device (enp9s0): state change: disconnected -> prepare (reason 'none', sys-iface-state: 'managed')
      May 28 22:46:25 ALEPO-DB1-ILB NetworkManager[1281]: <info> [1779990385.9301] device (enp9s0): state change: prepare -> config (reason 'none', sys-iface-state: 'managed')
      May 28 22:46:25 ALEPO-DB1-ILB NetworkManager[1281]: <info> [1779990385.9354] device (enp9s0): state change: config -> ip-config (reason 'none', sys-iface-state: 'managed')
      May 28 22:46:25 ALEPO-DB1-ILB NetworkManager[1281]: <info> [1779990385.9357] dhcp4 (enp9s0): activation: beginning transaction (timeout in 45 seconds)
      May 28 22:46:52 ALEPO-DB1-ILB snmpd[2992269]: truncating integer value > 32 bits
      May 28 22:47:10 ALEPO-DB1-ILB NetworkManager[1281]: <info> [1779990430.9176] device (enp9s0): state change: ip-config -> failed (reason 'ip-config-unavailable', sys-iface-state: 'managed')
      May 28 22:47:10 ALEPO-DB1-ILB NetworkManager[1281]: <warn> [1779990430.9180] device (enp9s0): Activation: failed for connection 'opt-net'
      May 28 22:47:10 ALEPO-DB1-ILB NetworkManager[1281]: <info> [1779990430.9181] device (enp9s0): state change: failed -> disconnected (reason 'none', sys-iface-state: 'managed')
      May 28 22:47:10 ALEPO-DB1-ILB NetworkManager[1281]: <info> [1779990430.9350] dhcp4 (enp9s0): canceled DHCP transaction
      May 28 22:49:25 ALEPO-DB1-ILB snmpd[2992269]: truncating integer value > 32 bits
      May 28 22:50:00 ALEPO-DB1-ILB systemd[1]: Starting system activity accounting tool...
      May 28 22:50:00 ALEPO-DB1-ILB systemd[1]: sysstat-collect.service: Succeeded.
      May 28 22:50:00 ALEPO-DB1-ILB systemd[1]: Started system activity accounting tool.
      May 28 22:50:01 ALEPO-DB1-ILB systemd[1]: Created slice User Slice of UID 0.
      May 28 22:46:25 ALEPO-DB1-ILB snmpd[2992269]: truncating integer value > 32 bits

      GDB Logs Analayis

      [root@ALEPO-DB1-ILB crash]# gdb /usr/sbin/mariadbd -c core_mariadbd_3010635_ALEPO-DB1-ILB_1780076739
      GNU gdb (GDB) Red Hat Enterprise Linux 8.2-19.el8
      Copyright (C) 2018 Free Software Foundation, Inc.
      License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
      This is free software: you are free to change and redistribute it.
      There is NO WARRANTY, to the extent permitted by law.
      Type "show copying" and "show warranty" for details.
      This GDB was configured as "x86_64-redhat-linux-gnu".
      Type "show configuration" for configuration details.
      For bug reporting instructions, please see:
      <http://www.gnu.org/software/gdb/bugs/>.
      Find the GDB manual and other documentation resources online at:
      <http://www.gnu.org/software/gdb/documentation/>.

      For help, type "help".
      Type "apropos word" to search for commands related to "word"...
      Reading symbols from /usr/sbin/mariadbd...Reading symbols from .gnu_debugdata for /usr/sbin/mariadbd...(no debugging symbols found)...done.
      (no debugging symbols found)...done.

      warning: Can't open file (null) during file-backed mapping note processing
      [New LWP 1874771]
      [New LWP 3058228]
      [New LWP 2237914]
      [New LWP 3010680]
      [New LWP 2231350]
      [New LWP 2240264]
      [New LWP 2237178]
      [New LWP 2239908]
      [New LWP 3012717]
      [New LWP 3012277]
      [New LWP 2235519]
      [New LWP 2241407]
      [New LWP 2241748]
      [New LWP 2223177]
      [New LWP 3010694]
      [New LWP 3012381]
      [New LWP 2241476]
      [New LWP 2237924]
      [New LWP 3010693]
      [New LWP 2242297]
      [New LWP 3012275]
      [New LWP 2241766]
      [New LWP 2241477]
      [New LWP 2240873]
      [New LWP 2240091]
      [New LWP 3012716]
      [New LWP 2242758]
      [New LWP 2232196]
      [New LWP 2242338]
      [New LWP 2230445]
      [New LWP 3010635]
      [New LWP 3011865]
      [New LWP 2240100]
      [Thread debugging using libthread_db enabled]
      Using host libthread_db library "/lib64/libthread_db.so.1".
      Core was generated by `/usr/sbin/mariadbd'.
      Program terminated with signal SIGSEGV, Segmentation fault.
      #0 0x00007ff014774a35 in pthread_kill () from /lib64/libpthread.so.0
      [Current thread is 1 (Thread 0x7feffac2e700 (LWP 1874771))]
      Missing separate debuginfos, use: yum debuginfo-install MariaDB-server-10.11.16-1.el8.x86_64
      (gdb) bt full
      #0 0x00007ff014774a35 in pthread_kill () from /lib64/libpthread.so.0
      No symbol table info available.
      #1 0x0000555fd29331c8 in handle_fatal_signal ()
      No symbol table info available.
      #2 <signal handler called>
      No symbol table info available.
      #3 0x0000555fd2666d1f in setup_fields(THD*, Bounds_checked_array<Item*>, List<Item>&, enum_column_usage, List<Item>, List<Item>, bool, THD_WHERE) ()
      No symbol table info available.
      #4 0x0000555fd26f9e55 in Prepared_statement::prepare(char const*, unsigned int) ()
      No symbol table info available.
      #5 0x0000555fd26faae8 in mysqld_stmt_prepare(THD*, char const*, unsigned int) ()
      No symbol table info available.
      #6 0x0000555fd26d64df in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool) ()
      No symbol table info available.
      #7 0x0000555fd26d77f6 in do_command(THD*, bool) ()
      No symbol table info available.
      #8 0x0000555fd2802d75 in do_handle_one_connection(CONNECT*, bool) ()
      No symbol table info available.
      #9 0x0000555fd28030cd in handle_one_connection ()
      No symbol table info available.
      #10 0x0000555fd2b564b5 in pfs_spawn_thread ()
      No symbol table info available.
      #11 0x00007ff01476d1ca in start_thread () from /lib64/libpthread.so.0
      No symbol table info available.
      #12 0x00007ff0138a5e73 in clone () from /lib64/libc.so.6
      No symbol table info available.
      (gdb) bt
      #0 0x00007ff014774a35 in pthread_kill () from /lib64/libpthread.so.0
      #1 0x0000555fd29331c8 in handle_fatal_signal ()
      #2 <signal handler called>
      #3 0x0000555fd2666d1f in setup_fields(THD*, Bounds_checked_array<Item*>, List<Item>&, enum_column_usage, List<Item>, List<Item>, bool, THD_WHERE) ()
      #4 0x0000555fd26f9e55 in Prepared_statement::prepare(char const*, unsigned int) ()
      #5 0x0000555fd26faae8 in mysqld_stmt_prepare(THD*, char const*, unsigned int) ()
      #6 0x0000555fd26d64df in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool) ()
      #7 0x0000555fd26d77f6 in do_command(THD*, bool) ()
      #8 0x0000555fd2802d75 in do_handle_one_connection(CONNECT*, bool) ()
      #9 0x0000555fd28030cd in handle_one_connection ()
      #10 0x0000555fd2b564b5 in pfs_spawn_thread ()
      #11 0x00007ff01476d1ca in start_thread () from /lib64/libpthread.so.0
      #12 0x00007ff0138a5e73 in clone () from /lib64/libc.so.6
      (gdb) where
      #0 0x00007ff014774a35 in pthread_kill () from /lib64/libpthread.so.0
      #1 0x0000555fd29331c8 in handle_fatal_signal ()
      #2 <signal handler called>
      #3 0x0000555fd2666d1f in setup_fields(THD*, Bounds_checked_array<Item*>, List<Item>&, enum_column_usage, List<Item>, List<Item>, bool, THD_WHERE) ()
      #4 0x0000555fd26f9e55 in Prepared_statement::prepare(char const*, unsigned int) ()
      #5 0x0000555fd26faae8 in mysqld_stmt_prepare(THD*, char const*, unsigned int) ()
      #6 0x0000555fd26d64df in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool) ()
      #7 0x0000555fd26d77f6 in do_command(THD*, bool) ()
      #8 0x0000555fd2802d75 in do_handle_one_connection(CONNECT*, bool) ()
      #9 0x0000555fd28030cd in handle_one_connection ()
      #10 0x0000555fd2b564b5 in pfs_spawn_thread ()
      #11 0x00007ff01476d1ca in start_thread () from /lib64/libpthread.so.0
      #12 0x00007ff0138a5e73 in clone () from /lib64/libc.so.6

      (gdb) frame 5
      #5 0x0000555fd26faae8 in mysqld_stmt_prepare(THD*, char const*, unsigned int) ()
      (gdb) print thd->query_string
      No symbol "thd" in current context.
      (gdb) frame 4
      #4 0x0000555fd26f9e55 in Prepared_statement::prepare(char const*, unsigned int) ()
      (gdb) print yyvsp[-2].item
      No symbol "yyvsp" in current context.

      Attachments

        1. mariadbd.gz
          8.60 MB
          ashish
        2. mdev-39809.opt
          0.2 kB
          Shipra Jain
        3. mdev-39809.test
          2 kB
          Shipra Jain

        Issue Links

          Activity

            People

              shipjain Shipra Jain
              ashishcyrus ashish
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 0.75d
                  0.75d

                  Git Integration

                    Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.