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

Crash seen during handling of replication filter

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 11.4.7
    • None
    • Replication, Server
    • None

    Description

      There have been some issues seen in the replication filter in the galera cluster in 11.4.7.

      There was another issue seen and raised as a bug MDEV-38511. This issue is not similar to that, hence created a new bug for this to be given its own attention. We couldn't capture the core dump but the logs shows the stack trace.

      ###########################################################################################
      2026-03-08 17:54:56 3 [Note] WSREP: SST received
      2026-03-08 17:54:56 3 [Note] WSREP: Server status change joiner -> initializing
      2026-03-08 17:54:56 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
      2026-03-08 17:54:56 0 [Note] InnoDB: Using transactional memory
      2026-03-08 17:54:56 0 [Note] InnoDB: Number of transaction pools: 1
      2026-03-08 17:54:56 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
      2026-03-08 17:54:56 0 [Note] mariadbd: O_TMPFILE is not supported on /mariadb/tmp (disabling future attempts)
      2026-03-08 17:54:56 0 [Warning] mariadbd: io_uring_queue_init() failed with ENOSYS: check seccomp filters, and the kernel version (newer than 5.1 required)
      2026-03-08 17:54:56 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
      2026-03-08 17:54:56 0 [Note] InnoDB: innodb_buffer_pool_size_max=2048m, innodb_buffer_pool_size=2048m
      2026-03-08 17:54:57 0 [Note] InnoDB: Completed initialization of buffer pool
      2026-03-08 17:54:57 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
      2026-03-08 17:54:57 0 [Note] InnoDB: End of log at LSN=748839
      2026-03-08 17:54:57 0 [Note] InnoDB: Resizing redo log from 12.016KiB to 128.000MiB; LSN=748839
      2026-03-08 17:54:57 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
      2026-03-08 17:54:57 0 [Note] InnoDB: Opened 3 undo tablespaces
      2026-03-08 17:54:57 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
      2026-03-08 17:54:57 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
      2026-03-08 17:54:57 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
      2026-03-08 17:54:57 0 [Note] InnoDB: log sequence number 748839; transaction id 527
      2026-03-08 17:54:57 0 [Note] Plugin 'FEEDBACK' is disabled.
      2026-03-08 17:54:57 0 [Note] InnoDB: Loading buffer pool(s) from /mariadb/data/ib_buffer_pool
      2026-03-08 17:54:57 0 [Note] InnoDB: Cannot open '/mariadb/data/ib_buffer_pool' for reading: No such file or directory
      2026-03-08 17:54:57 0 [Warning] 'innodb-log-files-in-group' was removed. It does nothing now and exists only for compatibility with old my.cnf files.
      2026-03-08 17:54:57 0 [Warning] 'innodb-file-format' was removed. It does nothing now and exists only for compatibility with old my.cnf files.
      2026-03-08 17:54:57 0 [Note] Recovering after a crash using mysql-bin
      2026-03-08 17:54:57 0 [Note] Starting table crash recovery...
      2026-03-08 17:54:57 0 [Note] Crash table recovery finished.
      2026-03-08 17:54:58 0 [Note] Server socket created on IP: '0.0.0.0'.
      2026-03-08 17:54:59 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
      2026-03-08 17:54:59 0 [Note] WSREP: wsrep_init_schema_and_SR (nil)
      2026-03-08 17:54:59 0 [Note] WSREP: Server initialized
      2026-03-08 17:54:59 0 [Note] WSREP: Server status change initializing -> initialized
      2026-03-08 17:54:59 3 [Note] WSREP: Recovered position from storage: 5a2620d1-1a96-11f1-902d-e24838fe69db:231
      2026-03-08 17:54:59 3 [Note] WSREP: Server status change initialized -> joined
      2026-03-08 17:54:59 7 [Note] WSREP: Starting applier thread 7
      260308 17:54:59 [ERROR] 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: 11.4.7-MariaDB-log source revision: 118cfcf82107188f2295631193658b2ef94f4f3f

      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: 0x7f89c4000c58
      2026-03-08 17:54:59 6 [Note] WSREP: Starting applier thread 6
      stack_bottom = 0x7f8a7c3f6000 thread_stack 0x49000
      2026-03-08 17:54:59 0 [Note] mariadbd: ready for connections.
      Version: '11.4.7-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
      2026-03-08 17:54:59 0 [Note] mariadbd (initiated by: unknown): Normal shutdown
      2026-03-08 17:54:59 0 [Note] WSREP: Shutdown replication
      2026-03-08 17:54:59 0 [Note] WSREP: Server status change joined -> disconnecting
      2026-03-08 17:54:59 0 [Note] WSREP: Closing send monitor...
      2026-03-08 17:54:59 0 [Note] WSREP: Closed send monitor.
      2026-03-08 17:54:59 0 [Note] WSREP: gcomm: terminating thread
      2026-03-08 17:54:59 0 [Note] WSREP: gcomm: joining thread
      2026-03-08 17:54:59 0 [Note] WSREP: gcomm: closing backend
      2026-03-08 17:54:59 3 [Note] WSREP: Recovered view from SST:
      id: 5a2620d1-1a96-11f1-902d-e24838fe69db:231
      status: primary
      protocol_version: 4
      capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO
      final: no
      own_index: 0
      members(2):
      0: 5a24ce7a-1a96-11f1-b371-42f67175fc2d, nrd-db-mariadb-0
      1: b070f190-1a96-11f1-a731-3f09c384fa66, nrd-db-mariadb-0

      addr2line: 'mariadbd': No such file
      Printing to addr2line failed
      mariadbd(my_print_stacktrace+0x2e)[0x55d4457ff55e]
      mariadbd(handle_fatal_signal+0x305)[0x55d4452d9ea5]
      2026-03-08 17:54:59 11 [Note] WSREP: Recovered cluster id 5a2620d1-1a96-11f1-902d-e24838fe69db
      /lib64/libc.so.6(+0x3fc30)[0x7f8b772d5c30]
      2026-03-08 17:54:59 3 [Note] WSREP: SST received: 5a2620d1-1a96-11f1-902d-e24838fe69db:231
      2026-03-08 17:54:59 3 [Note] WSREP: SST succeeded for position 5a2620d1-1a96-11f1-902d-e24838fe69db:231
      2026-03-08 17:54:59 2 [Note] WSREP: Installed new state from SST: 5a2620d1-1a96-11f1-902d-e24838fe69db:231
      2026-03-08 17:54:59 0 [Note] WSREP: Joiner monitor thread ended with total time 25 sec
      2026-03-08 17:54:59 2 [Note] WSREP: Cert. index preload up to 231
      2026-03-08 17:54:59 0 [Note] WSREP: ####### IST applying starts with 232
      2026-03-08 17:54:59 0 [Note] WSREP: ####### IST current seqno initialized to 130
      2026-03-08 17:54:59 0 [Note] WSREP: Receiving IST... 0.0% (0/102 events) complete.
      2026-03-08 17:54:59 0 [Note] WSREP: IST preload starting at 130
      2026-03-08 17:54:59 0 [Note] WSREP: Service thread queue flushed.
      2026-03-08 17:54:59 0 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:129, protocol version: 6
      addr2line: 'mariadbd': No such file
      mariadbd(_ZN10Rpl_filter26table_rule_ent_hash_to_strEP6StringP7st_hashb+0x40)[0x55d444f7dac0]
      mariadbd(Z19copy_filter_settingP10Rpl_filterS0+0xff)[0x55d4451802bf]
      mariadbd(_ZN11Master_infoC1EP25st_mysql_const_lex_stringb+0x2dd)[0x55d44518315d]
      mariadbd(_ZN27Wsrep_high_priority_serviceC2EP3THD+0x22a)[0x55d44557c79a]
      mariadbd(_ZN21Wsrep_applier_serviceC2EP3THD+0x1f)[0x55d44557d26f]
      mariadbd(+0xdc2d17)[0x55d44559ad17]
      mariadbd(_Z15start_wsrep_THDPv+0x256)[0x55d445589636]
      mariadbd(+0xd3eb29)[0x55d445516b29]
      /lib64/libc.so.6(+0x8b2ea)[0x7f8b773212ea]
      /lib64/libc.so.6(clone+0x44)[0x7f8b773a55f4]

      Connection ID (thread ID): 9
      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 238913 238913 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 %e
      ######################################################################

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              Sahai Har Gagan
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.