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

Test compat/oracle.sp-package fails with crash on armhf

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • None
    • None
    • Tests, MTR
    • None

    Description

      Seen in a MariaDB 11.8.5 build at https://launchpadlibrarian.net/837235088/buildlog_ubuntu-resolute-armhf.mariadb_1%3A11.8.5-3~exp3~bpo26.04.1~1765580069.552e983e184+feature.extend.mtr.to.big_BUILDING.txt.gz

      compat/oracle.sp-package                 w7 [ fail ]
              Test ended at 2025-12-13 00:02:48
       
      CURRENT_TEST: compat/oracle.sp-package
      mysqltest: At line 2237: query 'SELECT p1.f1()' failed: <Unknown> (2013): Lost connection to server during query
       
      The result from queries just before the failure was:
      < snip >
      DROP PACKAGE p1;
      DROP TABLE t1;
      #
      # Package variables and XPath
      #
      CREATE PACKAGE p1 AS
      FUNCTION f1 RETURN TEXT;
      END;
      $$
      CREATE PACKAGE BODY p1 AS
      i INT:=0;
      xml TEXT:= '<a><b>b1</b><b>b2</b><b>b3</b></a>';
      FUNCTION f1 RETURN TEXT AS
      BEGIN
      SET i=i+1;
      RETURN ExtractValue(xml, '/a/b[$i]');
      END;
      END;
      $$
      SELECT p1.f1();
       
      More results from queries before failure can be found in /<<PKGBUILDDIR>>/builddir/mysql-test/var/7/log/sp-package.log
       
       
      Server [mysqld.1 - pid: 319746, winpid: 319746, exit: 256] failed during test run
      Server log from this test:
      ----------SERVER LOG START-----------
      251213  0:02:48 [ERROR] /<<PKGBUILDDIR>>/builddir/sql/mariadbd got signal 7 ;
      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.8.5-MariaDB-log source revision: a74edc42d080a73e20d5d94e1dd5beea400b507c
       
      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: 0xe3d00708
      stack_bottom = 0xe40b5000 thread_stack 0x49000
       
      Connection ID (thread ID): 226
      Status: NOT_KILLED
      Query (0xe3d12610): SELECT p1.f1()
       
      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
       
      Writing a core file...
      Working directory at /<<PKGBUILDDIR>>/builddir/mysql-test/var/7/mysqld.1/data
      Resource Limits (excludes unlimited resources):
      Limit                     Soft Limit           Hard Limit           Units     
      Max stack size            8388608              unlimited            bytes     
      Max processes             127820               127820               processes 
      Max open files            1024                 1024                 files     
      Max locked memory         8388608              8388608              bytes     
      Max pending signals       127820               127820               signals   
      Max msgqueue size         819200               819200               bytes     
      Max nice priority         0                    0                    
      Max realtime priority     0                    0                    
      Core pattern: |/usr/share/apport/apport -p%p -s%s -c%c -d%d -P%P -u%u -g%g -F%F -- %E
       
      Kernel version: Linux version 6.8.0-88-generic (buildd@bos03-arm64-004) (aarch64-linux-gnu-gcc-13 (Ubuntu 13.3.0-6ubuntu2~24.04) 13.3.0, GNU ld (GNU Binutils for Ubuntu) 2.42) #89-Ubuntu SMP PREEMPT_DYNAMIC Sat Oct 11 00:59:18 UTC 2025
       
      ----------SERVER LOG END-------------
      

      Retries also failed.

      However, on Debian buildd this test is passing fine:

      compat/oracle.sp-package                 w4 [ pass ]    286
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              otto Otto Kekäläinen
              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.