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

Mariadb server crashing during startup in galera cluster

    XMLWordPrintable

Details

    • Bug
    • Status: Needs Feedback (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 11.4.9
    • None
    • Galera
    • None

    Description

      During startup following crash is observed in the mariadb logs.

      This is one of the node in the galera cluster.

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

      Server version: 11.4.9-MariaDB-log source revision: aa6a2e6bf05d43c3bb44db50566937a5f97a6580

      WSREP: Suppressing further logging
      WSREP: Shutting down network communications

      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: 0x7f0e9c000c58
      2025-12-24 11:11:14 6 [Note] WSREP: Starting applier thread 6
      2025-12-24 11:11:14 9 [Note] WSREP: Starting applier thread 9
      stack_bottom = 0x7f0f7c22f000 thread_stack 0x49000
      2025-12-24 11:11:14 0 [Note] mariadbd: ready for connections.
      Version: '11.4.9-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
      2025-12-24 11:11:14 0 [Note] mariadbd (initiated by: unknown): Normal shutdown
      2025-12-24 11:11:14 0 [Note] WSREP: Shutdown replication
      2025-12-24 11:11:14 0 [Note] WSREP: Server status change joined -> disconnecting
      2025-12-24 11:11:14 0 [Note] WSREP: Closing send monitor...
      2025-12-24 11:11:14 0 [Note] WSREP: Closed send monitor.
      2025-12-24 11:11:14 0 [Note] WSREP: gcomm: terminating thread
      2025-12-24 11:11:14 0 [Note] WSREP: gcomm: joining thread
      2025-12-24 11:11:14 0 [Note] WSREP: gcomm: closing backend
      Printing to addr2line failed
      mariadbd(my_print_stacktrace+0x2e)[0x5567cc4d814e]
      2025-12-24 11:11:14 11 [Note] WSREP: Recovered cluster id 8b8b6399-e0ea-11f0-8d7d-96651cdf19cd
      2025-12-24 11:11:14 3 [Note] WSREP: SST received: 8b8b6399-e0ea-11f0-8d7d-96651cdf19cd:39
      2025-12-24 11:11:14 3 [Note] WSREP: SST succeeded for position 8b8b6399-e0ea-11f0-8d7d-96651cdf19cd:39
      2025-12-24 11:11:14 0 [Note] WSREP: Joiner monitor thread ended with total time 15 sec
      2025-12-24 11:11:14 2 [Note] WSREP: Installed new state from SST: 8b8b6399-e0ea-11f0-8d7d-96651cdf19cd:39
      mariadbd(handle_fatal_signal+0x305)[0x5567cbf964b5]
      2025-12-24 11:11:14 2 [Note] WSREP: Cert. index preload up to 39
      2025-12-24 11:11:14 0 [Note] WSREP: ####### IST applying starts with 40
      2025-12-24 11:11:14 0 [Note] WSREP: ####### IST current seqno initialized to 2
      2025-12-24 11:11:14 0 [Note] WSREP: Receiving IST... 0.0% (0/38 events) complete.
      2025-12-24 11:11:14 0 [Note] WSREP: IST preload starting at 2
      2025-12-24 11:11:14 0 [Note] WSREP: Service thread queue flushed.
      2025-12-24 11:11:14 0 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:1, protocol version: 6
      2025-12-24 11:11:14 0 [Note] WSREP: REPL Protocols: 11 (6)
      2025-12-24 11:11:14 0 [Note] WSREP: ####### Adjusting cert position: 38 -> 39
      2025-12-24 11:11:14 0 [Note] WSREP: Service thread queue flushed.
      2025-12-24 11:11:14 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 2
      2025-12-24 11:11:14 0 [Note] WSREP: Min available from gcache for CC from preload: 2
      2025-12-24 11:11:14 0 [Note] WSREP: Receiving IST... 100.0% (38/38 events) complete.
      2025-12-24 11:11:14 2 [Note] WSREP: IST received: 8b8b6399-e0ea-11f0-8d7d-96651cdf19cd:39
      /lib64/libc.so.6(+0x3fc30)[0x7f1055fcec30]
      mariadbd(my_hash_insert+0xd9)[0x5567cc4b8379]
      mariadbd(_ZN10Rpl_filter14add_table_ruleEP7st_hashPKc+0x99)[0x5567cbc3f649]
      mariadbd(_ZN10Rpl_filter17parse_filter_ruleEPKcMS_FiS1_E+0xcb)[0x5567cbc3f44b]
      mariadbd(_ZN10Rpl_filter16set_ignore_tableEPKc+0x26)[0x5567cbc3f546]
      mariadbd(Z19copy_filter_settingP10Rpl_filterS0+0x27f)[0x5567cbe3f16f]
      mariadbd(_ZN11Master_infoC1EP25st_mysql_const_lex_stringb+0x2dd)[0x5567cbe41e0d]
      mariadbd(_ZN27Wsrep_high_priority_serviceC2EP3THD+0x22a)[0x5567cc236b5a]
      mariadbd(_ZN21Wsrep_applier_serviceC2EP3THD+0x1f)[0x5567cc23762f]
      mariadbd(+0xdb8bf7)[0x5567cc255bf7]
      mariadbd(_Z15start_wsrep_THDPv+0x256)[0x5567cc243d16]
      mariadbd(+0xd33f09)[0x5567cc1d0f09]
      /lib64/libc.so.6(+0x8b2ea)[0x7f105601a2ea]
      /lib64/libc.so.6(clone+0x44)[0x7f105609e5e4]

      Connection ID (thread ID): 7
      Status: NOT_KILLED
      Query (0x0): (null)
      Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=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=on,cset_narrowing=off,sargable_casefold=on

      Writing a core file...
      Working directory at /mariadb/data
      Resource Limits (excludes unlimited resources):
      Limit Soft Limit Hard Limit Units
      Max stack size 8388608 unlimited bytes
      Max open files 1048576 1048576 files
      Max locked memory 65536 65536 bytes
      Max pending signals 2059065 2059065 signals
      Max msgqueue size 819200 819200 bytes
      Max nice priority 0 0
      Max realtime priority 0 0
      Core pattern: |/usr/lib/systemd/systemd-coredump %P %u %g %s %t %c %h %e

      Attachments

        Issue Links

          Activity

            People

              seppo Seppo Jaakola
              Sahai Har Gagan
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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