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

Intermittent signal11 seen with parallel execution

    XMLWordPrintable

Details

    • Can result in hang or crash
    • Q4/2026 Server Maintenance

    Description

      Intermittent signal11 seen with parallel execution

      Version details:

      ----------------------
      Branch: bb-13.2-MDEV-40012-refactored-input3
      Commit:fcf80b7794ee57993cf7001a288a53b47a7e74ed
      Version:13.1.0

      Stack trace:

      ----------------------

      #0  __pthread_kill_implementation (no_tid=0, signo=11, threadid=<optimized out>) at ./nptl/pthread_kill.c:44
      #1  __pthread_kill_internal (signo=11, threadid=<optimized out>) at ./nptl/pthread_kill.c:78
      #2  __GI___pthread_kill (threadid=<optimized out>, signo=11) at ./nptl/pthread_kill.c:89
      #3  handle_fatal_signal ()
      #4  <signal handler called>
      #5  TABLE::unlock_hlindexes() ()
      #6  handler::ha_external_lock(THD*, int) ()
      #7  pwt_worker::execute_and_handoff() ()
      #8  pwt_worker::execute_and_signal_manager() ()
      #9  pwt_worker::thread_func() ()
      #10 pwt_thread::init_and_run_thread_func() ()
      #11 pwt_thread_func(void*) ()
      #12 pfs_spawn_thread ()
      #13 start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:447
      #14 clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
      

      How to repro: (Note : Issue is intermittent, coudn't repro issue consistently with repro steps)

      source tables.sql
      source queries.sql
      

      Server log:

      -----------
      261012 14:27:34 [ERROR] ./sql/mariadbd got signal 11 ;

      Query (0x6c0984bc8941): Parallel Worker 75 For Thread ID 4

      Last query run details from General log:

      -------------------

      SET parallel_worker_threads=100;
      ( SELECT t1.col_int_key, COUNT(*), SUM( t1.col_int ) FROM G t1 WHERE NOT t1.col_int > 1 GROUP BY t1.col_int_key ) UNION DISTINCT ( SELECT t1.col_int_key, COUNT(*), SUM( t1.col_int ) FROM C t1 WHERE t1.col_decimal_10_2 = 1 GROUP BY t1.col_int_key ) ORDER BY 1,2,3 LIMIT 0;
      

      Note:

      Ran above query twice
      Current client session terminated with below
      ERROR 2026 (HY000): TLS/SSL error: unexpected eof while reading

      New client connection rejected,however server was still up.
      ERROR 2013 (HY000): Lost connection to server at 'handshake: reading initial communication packet', system error: 104

      Again issue is intermittent.

      Attachments

        1. tables.sql
          3.61 MB
        2. queries.sql
          151 kB

        Issue Links

          Activity

            People

              Johnston Rex Johnston
              mariadb-pavithrapandith Pavithra Pandith
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 1.6d Original Estimate - 1.6d
                  1.6d
                  Remaining:
                  Time Spent - 1d Remaining Estimate - 1.6d
                  1.6d
                  Logged:
                  Time Spent - 1d Remaining Estimate - 1.6d
                  1d

                  Git Integration

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