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

mariadbd crash during SHOW ENGINES on SLES 16.0 VM (AMD64)

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 11.8.6, 12.2.2
    • N/A
    • Server
    • None
    • Not for Release Notes

    Description

      Where:

      Also happening on 12.2.2:

      Uploaded files for debugging:

      • gdb.txt (info threads; info registers; thread apply all bt full; frame 0)
      • journal.txt (mariadbd)
      • system_info.txt
      • core dump: mariadbd-11.8.6-sles1600-show-engines.core.zst

      What happened:

      Crashed during an MTR test for PAM plugin (line 150 in buildbot log):

      sudo su mysql -s /bin/sh -c 'perl mysql-test-run.pl --verbose-restart --force --vardir=/dev/shm/var_pam --suite=plugins --do-test=pam'
      

      It looks like the PAM tests are not the culprit, given that it fails during the 'check-testcase' phase before even starting the tests.

      The server [mysqld.1 - pid: 4582, winpid: 4582, exit: 256] crashed while running 'check testcase before test'
      

      How to reproduce:

      I was able to reproduce this on a fresh MariaDB Server install on a SLES 16.0 VM (AMD64) with a simple "SHOW ENGINES;" query:

      buildbot@bb-ro-apexis-bbw03-x64-sles-1600-amd64:~/buildbot/scripts> sudo mariadb
      Welcome to the MariaDB monitor.  Commands end with ; or \g.
      Your MariaDB connection id is 3
      Server version: 11.8.6-MariaDB MariaDB Server
       
      Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
       
      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
       
      MariaDB [(none)]> SHOW ENGINES;
      ERROR 2026 (HY000): TLS/SSL error: unexpected eof while reading
      

      From the journal:

      Jan 22 09:21:05 bb-ro-apexis-bbw03-x64-sles-1600-amd64 mariadbd[5050]: Connection ID (thread ID): 3
      Jan 22 09:21:05 bb-ro-apexis-bbw03-x64-sles-1600-amd64 mariadbd[5050]: Status: NOT_KILLED
      Jan 22 09:21:05 bb-ro-apexis-bbw03-x64-sles-1600-amd64 mariadbd[5050]: Query (0x55f5854799d0): SHOW ENGINES
      Jan 22 09:21:05 bb-ro-apexis-bbw03-x64-sles-1600-amd64 mariadbd[5050]: 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=on,sargable_casefold=on
      Jan 22 09:21:05 bb-ro-apexis-bbw03-x64-sles-1600-amd64 mariadbd[5050]: Writing a core file...
      Jan 22 09:21:05 bb-ro-apexis-bbw03-x64-sles-1600-amd64 mariadbd[5050]: Working directory at /var/lib/mysql
      Jan 22 09:21:05 bb-ro-apexis-bbw03-x64-sles-1600-amd64 mariadbd[5050]: Resource Limits (excludes unlimited resources):
      Jan 22 09:21:05 bb-ro-apexis-bbw03-x64-sles-1600-amd64 mariadbd[5050]: Limit                     Soft Limit           Hard Limit           Units
      Jan 22 09:21:05 bb-ro-apexis-bbw03-x64-sles-1600-amd64 mariadbd[5050]: Max stack size            8388608              unlimited            bytes
      Jan 22 09:21:05 bb-ro-apexis-bbw03-x64-sles-1600-amd64 mariadbd[5050]: Max processes             7658                 7658                 processes
      Jan 22 09:21:05 bb-ro-apexis-bbw03-x64-sles-1600-amd64 mariadbd[5050]: Max open files            32768                32768                files
      Jan 22 09:21:05 bb-ro-apexis-bbw03-x64-sles-1600-amd64 mariadbd[5050]: Max locked memory         524288               524288               bytes
      Jan 22 09:21:05 bb-ro-apexis-bbw03-x64-sles-1600-amd64 mariadbd[5050]: Max pending signals       7658                 7658                 signals
      Jan 22 09:21:05 bb-ro-apexis-bbw03-x64-sles-1600-amd64 mariadbd[5050]: Max msgqueue size         819200               819200               bytes
      Jan 22 09:21:05 bb-ro-apexis-bbw03-x64-sles-1600-amd64 mariadbd[5050]: Max nice priority         0                    0
      Jan 22 09:21:05 bb-ro-apexis-bbw03-x64-sles-1600-amd64 mariadbd[5050]: Max realtime priority     0                    0
      Jan 22 09:21:05 bb-ro-apexis-bbw03-x64-sles-1600-amd64 mariadbd[5050]: Core pattern: |/usr/lib/systemd/systemd-coredump %P %u %g %s %t %c %h %d %F
      Jan 22 09:21:05 bb-ro-apexis-bbw03-x64-sles-1600-amd64 mariadbd[5050]: Kernel version: Linux version 6.12.0-160000.5-default (geeko@buildhost) (gcc-13 (SUSE Linux) 13.4.0, GNU ld (GNU Binutils; SUSE Linux 16) 2.43.1.20241209-160000.2) #1 SMP PREEMPT_DYNAMIC Wed Sep 10 15:26:25 UTC 2025 (3545bbd)
      Jan 22 09:21:06 bb-ro-apexis-bbw03-x64-sles-1600-amd64 systemd-coredump[5111]: [🡕] Process 5050 (mariadbd) of user 475 dumped core.
       
                                                                                     Stack trace of thread 5050:
                                                                                     #0  0x00007f38bbd0aa0f __poll (libc.so.6 + 0x104a0f)
                                                                                     #1  0x000055f547e3276a n/a (n/a + 0x0)
                                                                                     #2  0x000055f547e33e23 n/a (n/a + 0x0)
                                                                                     #3  0x00007f38bbc30340 __libc_start_call_main (libc.so.6 + 0x2a340)
                                                                                     #4  0x00007f38bbc30409 __libc_start_main@@GLIBC_2.34 (libc.so.6 + 0x2a409)
                                                                                     #5  0x000055f547e26d35 n/a (n/a + 0x0)
                                                                                     ELF object binary architecture: AMD x86-64
      

      Attachments

        1. gdb.txt
          107 kB
          Varzaru Razvan-Liviu
        2. journal.txt
          33 kB
          Varzaru Razvan-Liviu
        3. mariadbd-11.8.6-sles1600-show-engines.core.zst
          1.37 MB
          Varzaru Razvan-Liviu
        4. system_info.txt
          2 kB
          Varzaru Razvan-Liviu

        Issue Links

          Activity

            People

              Unassigned Unassigned
              rvarzaru Varzaru Razvan-Liviu
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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