./mtr --start-and-exit --mysqld=--innodb

../bin/mariadb -P19000 -h127.0.0.1 -uroot

# USE test + testcase paste

10.5.27-dbg>SET innodb_compression_default=1;

Query OK, 0 rows affected (0.000 sec)

10.5.27-dbg>CREATE TEMPORARY TABLE t (c INT);

Query OK, 0 rows affected (0.001 sec)

10.5.27-dbg>SET GLOBAL innodb_compression_level=0;

Query OK, 0 rows affected (0.000 sec)

10.5.27-dbg>TRUNCATE t;

ERROR 1030 (HY000): Got error 140 "Wrong create options" from storage engine InnoDB

10.5.27-dbg>DROP TABLE t;

ERROR 2013 (HY000): Lost connection to MySQL server during query

10.5.27-opt>TRUNCATE t;

ERROR 1030 (HY000): Got error 140 "Wrong create options" from storage engine InnoDB

10.5.27-opt>DROP TABLE t;

ERROR 1051 (42S02): Unknown table 'test.t'

10.6.20-opt>TRUNCATE t;

Query OK, 0 rows affected (0.000 sec)

10.6.20-opt>DROP TABLE t;

Query OK, 0 rows affected (0.000 sec)

2024-08-30 15:45:10 1 [Warning] Could not remove temporary table: '/var/folders/yj/8g2l7_c972s_kwvct7hqtlfw0000gn/T/#sql-temptable-13703-1-4', error: 2

Assertion failed: (thd->mdl_context.is_lock_owner(MDL_key::TABLE, db.str, table_name.str, MDL_SHARED)), function <unknown>, file sql_table.cc, line 1516.

240830 15:45:10 [ERROR] mysqld got signal 6 ;

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

We will try our best to scrape up some info that will hopefully help

diagnose the problem, but since we have already crashed,

something is definitely wrong and this may fail.

Server version: 11.4.3-MariaDB-debug source revision: 5ab81ffe0097a22a774957df28c5223cf0201de3

key_buffer_size=134217728

read_buffer_size=131072

max_used_connections=0

max_threads=153

thread_count=1

It is possible that mysqld could use up to

key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 468221 K  bytes of memory

Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x128812288

Attempting backtrace. You can use the following information to find out

where mysqld died. If you see no messages after this, something went

terribly wrong...

stack_bottom = 0x16d701940 thread_stack 0x49000

Printing to addr2line failed

0   mariadbd                            0x00000001038af614 my_print_stacktrace + 64

0   mariadbd                            0x00000001027fd834 handle_fatal_signal + 1164

0   libsystem_platform.dylib            0x0000000188867584 _sigtramp + 56

0   libsystem_pthread.dylib             0x0000000188836c20 pthread_kill + 288

2024-08-30 15:45:10 0 [Note] InnoDB: Data file .//undo001 did not exist: new to be created

2024-08-30 15:45:10 0 [Note] InnoDB: Setting file .//undo001 size to 10.000MiB

2024-08-30 15:45:10 0 [Note] InnoDB: Database physically writes the file full: wait...

0   libsystem_c.dylib                   0x0000000188743a30 abort + 180

0   libsystem_c.dylib                   0x0000000188742d20 err + 0

0   mariadbd                            0x0000000102da5b28 _Z23mysql_rm_table_no_locksP3THDP10TABLE_LISTPK25st_mysql_const_lex_stringP16st_ddl_log_statebbbbbb + 2644

0   mariadbd                            0x0000000102da4f74 _Z14mysql_rm_tableP3THDP10TABLE_LISTbbbb + 1196

0   mariadbd                            0x0000000102c71c20 _Z21mysql_execute_commandP3THDb + 22516

0   mariadbd                            0x0000000102c64728 _Z11mysql_parseP3THDPcjP12Parser_state + 1028

0   mariadbd                            0x0000000102c63fdc _Z9bootstrapP13st_mysql_file + 1732

0   mariadbd                            0x0000000102a608e8 _Z11mysqld_mainiPPc + 2832

0   mariadbd                            0x00000001026fe164 main + 36

0   dyld                                0x00000001884ae0e0 start + 2360

Trying to get some variables.

Some pointers may be invalid and cause the dump to abort.

Query (0x12881eaa0): DROP TABLE tmp_user_sys;

Connection ID (thread ID): 1

Status: NOT_KILLED

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

The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/ contains

information that should help you find out what is causing the crash.

Core pattern: /cores/core.%P

scripts/mariadb-install-db: line 567: 79619 Abort trap: 6           "$mysqld_bootstrap" $defaults $defaults_group_suffix "$mysqld_opt" --bootstrap $silent_startup "--basedir=$basedir" "--datadir=$ldata" --log-warnings=0 --enforce-storage-engine="" "--plugin-dir=${plugindir}" $args --max_allowed_packet=8M --net_buffer_length=16K

0x0000000102da5b28 mysql_rm_table_no_locks(THD*, TABLE_LIST*, st_mysql_const_lex_string const*, st_ddl_log_state*, bool, bool, bool, bool, bool, bool) + 2644

0x0000000102da4f74 mysql_rm_table(THD*, TABLE_LIST*, bool, bool, bool, bool) + 1196

0x0000000102c71c20 mysql_execute_command(THD*, bool) + 22516

0x0000000102c64728 mysql_parse(THD*, char*, unsigned int, Parser_state*) + 1028

0x0000000102c63fdc bootstrap(st_mysql_file*) + 1732

0x0000000102a608e8 mysqld_main(int, char**) + 2832

DROP TABLE tmp_user_sys;

    else if (!drop_temporary)

    {

      non_temp_tables_count++;

      DBUG_ASSERT(thd->mdl_context.is_lock_owner(MDL_key::TABLE, db.str,

                                                 table_name.str, MDL_SHARED));    # <<< Assert location

      alias= (lower_case_table_names == 2) ? table->alias : table_name;

      /* remove .frm file and engine files */

      path_length= build_table_filename(path, sizeof(path) - 1, db.str,

                                        alias.str, reg_ext, 0);

      path_end= path + path_length - reg_ext_length;

    }

bin/mariadb -A -uroot --force --binary-mode 

SIGABRT|mysql_rm_table_no_locks|mysql_rm_table|mysql_execute_command|mysql_parse

Core was generated by `/test/EMD230724-mariadb-11.4.2-1-linux-x86_64-dbg/bin/mariadbd --no-defaults --'.

Program terminated with signal SIGABRT, Aborted.

Download failed: Invalid argument.  Continuing without source file ./nptl/./nptl/pthread_kill.c.

#0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44

[Current thread is 1 (LWP 3135)]

(gdb) bt

#0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44

#1  __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78

#2  __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89

#3  0x000010c97e64526e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26

#4  0x000010c97e6288ff in __GI_abort () at ./stdlib/abort.c:79

#5  0x000010c97e62881b in __assert_fail_base (fmt=0x10c97e7d01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x59c80a968860 "thd->mdl_context.is_lock_owner(MDL_key::TABLE, db.str, table_name.str, MDL_SHARED)", file=file@entry=0x59c80a968330 "/test/11.4-enterprise_dbg/sql/sql_table.cc", line=line@entry=1525, function=function@entry=0x59c80a968758 "int mysql_rm_table_no_locks(THD*, TABLE_LIST*, const LEX_CSTRING*, DDL_LOG_STATE*, bool, bool, bool, bool, bool, bool)") at ./assert/assert.c:94

#6  0x000010c97e63b507 in __assert_fail (assertion=0x59c80a968860 "thd->mdl_context.is_lock_owner(MDL_key::TABLE, db.str, table_name.str, MDL_SHARED)", file=0x59c80a968330 "/test/11.4-enterprise_dbg/sql/sql_table.cc", line=1525, function=0x59c80a968758 "int mysql_rm_table_no_locks(THD*, TABLE_LIST*, const LEX_CSTRING*, DDL_LOG_STATE*, bool, bool, bool, bool, bool, bool)")at ./assert/assert.c:103

#7  0x000059c809cdfa0f in mysql_rm_table_no_locks (thd=thd@entry=0x59c80db3b248, tables=tables@entry=0x59c80db63d78, current_db=current_db@entry=0x59c80db3b2e8, ddl_log_state=0x7ffe79c34550, ddl_log_state@entry=0x0, if_exists=if_exists@entry=false, drop_temporary=drop_temporary@entry=false, drop_view=false, drop_sequence=false, dont_log_query=false, dont_free_locks=false)at /test/11.4-enterprise_dbg/sql/sql_table.cc:1525

#8  0x000059c809ce2138 in mysql_rm_table (thd=thd@entry=0x59c80db3b248, tables=tables@entry=0x59c80db63d78, if_exists=<optimized out>, drop_temporary=<optimized out>, drop_sequence=<optimized out>, dont_log_query=dont_log_query@entry=false)at /test/11.4-enterprise_dbg/sql/sql_table.cc:1211

#9  0x000059c809c085f3 in mysql_execute_command (thd=thd@entry=0x59c80db3b248, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false)at /test/11.4-enterprise_dbg/sql/sql_parse.cc:4765

#10 0x000059c809c0caa2 in mysql_parse (thd=0x59c80db3b248, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7ffe79c352c0)at /test/11.4-enterprise_dbg/sql/sql_parse.cc:7890

#11 0x000059c809c0d08d in bootstrap (file=0x59c80bd249d0 <instrumented_stdin>)at /test/11.4-enterprise_dbg/sql/sql_class.h:262

#12 0x000059c809ad9f0c in mysqld_main (argc=<optimized out>, argv=<optimized out>) at /test/11.4-enterprise_dbg/sql/mysqld.cc:5964

#13 0x000059c809acbd86 in main (argc=<optimized out>, argv=<optimized out>)at /test/11.4-enterprise_dbg/sql/main.cc:34

35024:handle_bootstrap: query: CREATE TEMPORARY TABLE tmp_user_sys LIKE global_priv;

36267:close_thread_tables: tcache: table: 'global_priv'  query_id: 0

36321:handle_bootstrap: query: INSERT INTO tmp_user_sys (Host,User,Priv) VALUES ('localhost','mariadb.sys','{"access":0,"plugin":"mysql_native_password","authentication_string":"","account_locked":true,"password_last_changed":0}');

36741:handle_bootstrap: query: INSERT IGNORE INTO global_priv SELECT * FROM tmp_user_sys WHERE 0 <> @need_sys_user_creation;

38421:check_integrity: THD::enter_stage: Waiting for query cache lock at local-mariadb/artifacts/sources/mariadb-mariadb-11.4.3/sql/sql_cache.cc:692

38447:close_thread_tables: tcache: table: 'global_priv'  query_id: 18

38510:handle_bootstrap: query: DROP TABLE tmp_user_sys;

fn_format: enter: name: /tmp/#sql-temptable-3da6b-1-3  dir:   extension: .MAI  flag: 4

dirname_part: enter: '/tmp/#sql-temptable-3da6b-1-3'

dirname_part: enter: '/tmp/'

cleanup_dirname: enter: from: '/tmp/'

cleanup_dirname: exit: to: '/tmp/'

my_realpath: info: executing realpath

my_load_path: enter: path: /tmp/#sql-temptable-3da6b-1-3.MAI  prefix:

my_load_path: exit: to: /tmp/#sql-temptable-3da6b-1-3.MAI

fn_format: enter: name: /tmp/#sql-temptable-3da6b-1-3  dir:   extension: .MAI  flag: 260

dirname_part: enter: '/tmp/#sql-temptable-3da6b-1-3'

dirname_part: enter: '/tmp/'

cleanup_dirname: enter: from: '/tmp/'

cleanup_dirname: exit: to: '/tmp/'

my_delete: my: name /tmp/#sql-temptable-3da6b-1-3.MAI MyFlags 16

my_error: my: nr: 6  MyFlags: 4  errno: 2

my_message_sql: error: error: 6  message: 'Error on delete of '/tmp/#sql-temptable-3da6b-1-3.MAI' (Errcode: 2 "No such file or directory")'  Flag: 4

fn_format: enter: name: /tmp/#sql-temptable-3da6b-1-3  dir:   extension: .MAD  flag: 260

dirname_part: enter: '/tmp/#sql-temptable-3da6b-1-3'

dirname_part: enter: '/tmp/' 

cleanup_dirname: enter: from: '/tmp/'

cleanup_dirname: exit: to: '/tmp/'

my_delete: my: name /tmp/#sql-temptable-3da6b-1-3.MAD MyFlags 16

my_error: my: nr: 6  MyFlags: 4  errno: 2

my_message_sql: error: error: 6  message: 'Error on delete of '/tmp/#sql-temptable-3da6b-1-3.MAD' (Errcode: 2 "No such file or directory")'  Flag: 4

fn_format: enter: name: /tmp/#sql-temptable-3da6b-1-3  dir:   extension: .TMD  flag: 260

dirname_part: enter: '/tmp/#sql-temptable-3da6b-1-3'

dirname_part: enter: '/tmp/'

cleanup_dirname: enter: from: '/tmp/'

cleanup_dirname: exit: to: '/tmp/'

my_delete: my: name /tmp/#sql-temptable-3da6b-1-3.TMD MyFlags 0

print_buffer_to_file: enter: buffer: Could not remove temporary table: '/tmp/#sql-temptable-3da6b-1-3', error: 2

print_buffer_to_file: mutex: LOCK_error_log (0x591cc9bbdf20) locking

print_buffer_to_file: mutex: LOCK_error_log (0x591cc9bbdf20) locked

print_buffer_to_file: mutex: LOCK_error_log (0x591cc9bbdf20) unlocking

my_delete: my: name /tmp/#sql-temptable-3da6b-1-3.frm MyFlags 48

free_table_share: enter: table: mysql.tmp_user_sys

TABLE_SHARE::destroy: info: db: mysql table: tmp_user_sys

my_hash_free: enter: hash:0x76644cf5c090  elements: 0

plugin_unlock: mutex: LOCK_plugin (0x591cc9bc60c0) locking

plugin_unlock: mutex: LOCK_plugin (0x591cc9bc60c0) locked

my_free: my: ptr: 0x7664268f5168

my_free: info: global thd memory_used: 258032  size: -32

intern_plugin_unlock: lock: thd: 0x76643bde3b88  plugin: "Aria" UNLOCK ref_count: 2

plugin_unlock: mutex: LOCK_plugin (0x591cc9bc60c0) unlocking

free_root: enter: root: 0x7ffc67e6a6c0  flags: 0

my_free: my: ptr: 0x766426979c88

my_free: info: thd memory_used: 69720  size: -1040

my_free: my: ptr: 0x766426a06a88

my_free: info: thd memory_used: 68680  size: -2112

my_free: my: ptr: 0x76643b87dc88

my_free: info: thd memory_used: 66568  size: -1216

my_free: my: ptr: 0x766426979788

my_free: info: thd memory_used: 65352  size: -1040

my_free: my: ptr: 0x76644cf5c088

my_free: info: global thd memory_used: 258000  size: -1768

mysql_rm_table_no_locks: error: handling fatal signal

CREATE TEMPORARY TABLE tmp_user_sys LIKE global_priv;

INSERT INTO tmp_user_sys (Host,User,Priv) VALUES ('localhost','mariadb.sys','{"access":0,"plugin":"mysql_native_password","authentication_string":"","account_locked":true,"password_last_changed":0}');

INSERT IGNORE INTO global_priv SELECT * FROM tmp_user_sys WHERE 0 <> @need_sys_user_creation;

DROP TABLE tmp_user_sys;

[mariadb]

log-bin

server-id=100

binlog_format=row

binlog_row_image=minimal

innodb_autoinc_lock_mode=2

# This makes `show engine innodb status` output current locks, helpful for debugging locks

innodb-status-output-locks=on

rm -rf data{1,2,3,4}

PATH=~/Projects/mariadb-server/build_local/install/bin:$PATH ~/Projects/mariadb-server/build_local/install/scripts/mariadb-install-db  --defaults-file=./primary.cnf --datadir=./data1 >> 1.log 2>&1 &

PATH=~/Projects/mariadb-server/build_local/install/bin:$PATH ~/Projects/mariadb-server/build_local/install/scripts/mariadb-install-db  --defaults-file=./primary.cnf --datadir=./data2 >> 2.log 2>&1 &

PATH=~/Projects/mariadb-server/build_local/install/bin:$PATH ~/Projects/mariadb-server/build_local/install/scripts/mariadb-install-db  --defaults-file=./primary.cnf --datadir=./data3 >> 3.log 2>&1 &

PATH=~/Projects/mariadb-server/build_local/install/bin:$PATH ~/Projects/mariadb-server/build_local/install/scripts/mariadb-install-db  --defaults-file=./primary.cnf --datadir=./data4 >> 4.log 2>&1 &

while true; do

  rm -rf data[0-9] [0-9].log

  for((i=0;i<10;i++)){

    ./scripts/mariadb-install-db --no-defaults --force --auth-root-authentication-method=normal --basedir=${PWD} --datadir=./data${i} >> ${i}.log 2>&1 &

  }

  wait %1 %2 %3 %4 %5 %6 %7 %8 %9 %10 2>/dev/null

  if grep -qi 'mysql_rm_table_no_locks' [0-9].log; then

    break

  fi

done

grep 'mysql_rm_table_no_locks' [0-9].log

while $BUILD/scripts/mariadb-install-db --builddir=$BUILD --srcdir=$SRC --defaults-file=/dev/shm/primary.cnf --datadir=/dev/shm/data

do

  rm -fr /dev/shm/data

done

@@ -561,7 +561,7 @@

 mysqld_bootstrap="${MYSQLD_BOOTSTRAP-$mysqld}"

 mysqld_install_cmd_line()

 {

-  "$mysqld_bootstrap" $defaults $defaults_group_suffix "$mysqld_opt" --bootstrap $silent_startup\

+  rr record "$mysqld_bootstrap" $defaults $defaults_group_suffix "$mysqld_opt" --bootstrap $silent_startup\

   "--basedir=$basedir" "--datadir=$ldata" --log-warnings=0 --enforce-storage-engine="" \

   "--plugin-dir=${plugindir}" \

   $args --max_allowed_packet=8M \

#!/bin/sh

exec rr record /path/to/mariadbd "$@"

/test/MD090924-mariadb-11.2.6-linux-x86_64-dbg$ while true; do

  rm -rf data[0-9] [0-9].log

  for((i=0;i<10;i++)){

    ./scripts/mariadb-install-db --no-defaults --force --auth-root-authentication-method=normal --basedir=${PWD} --datadir=./data${i} >> ${i}.log 2>&1 &

  }

  wait %1 %2 %3 %4 %5 %6 %7 %8 %9 %10 2>/dev/null

  if grep -qi 'mysql_rm_table_no_locks' [0-9].log; then

    break

  fi

done

grep 'mysql_rm_table_no_locks' [0-9].log

[1] 219032

[2] 219033

[3] 219034

[4] 219035

[5] 219037

[6] 219040

[7] 219042

[8] 219047

[9] 219049

[10] 219057

[1] 223819

[2] 223821

[3] 223822

[4] 223824

[5] 223826

[6] 223830

[7] 223833

[8] 223836

[9] 223845

[10] 223851

3.log:mariadbd: /test/11.2_dbg/sql/sql_table.cc:1524: int mysql_rm_table_no_locks(THD*, TABLE_LIST*, const LEX_CSTRING*, DDL_LOG_STATE*, bool, bool, bool, bool, bool, bool): Assertion `thd->mdl_context.is_lock_owner(MDL_key::TABLE, db.str, table_name.str, MDL_SHARED)' failed.

/test/MD090924-mariadb-11.2.6-linux-x86_64-dbg$ while true; do

  rm -rf data[0-9] [0-9].log

  for((i=0;i<10;i++)){

    ./scripts/mariadb-install-db --no-defaults --force --external-locking --auth-root-authentication-method=normal --basedir=${PWD} --datadir=./data${i} >> ${i}.log 2>&1 &

  }

  wait %1 %2 %3 %4 %5 %6 %7 %8 %9 %10 2>/dev/null

  if grep -qi 'mysql_rm_table_no_locks' [0-9].log; then

    break

  fi

done

grep 'mysql_rm_table_no_locks' [0-9].log

[1] 1702720

[2] 1702721

[3] 1702722

[4] 1702724

[5] 1702727

[6] 1702730

[7] 1702732

[8] 1702737

[9] 1702740

[10] 1702751

[1] 1704662

[2] 1704663

[3] 1704664

[4] 1704665

[5] 1704667

[6] 1704669

[7] 1704672

[8] 1704675

[9] 1704680

[10] 1704686

5.log:mariadbd: /test/11.2_dbg/sql/sql_table.cc:1524: int mysql_rm_table_no_locks(THD*, TABLE_LIST*, const LEX_CSTRING*, DDL_LOG_STATE*, bool, bool, bool, bool, bool, bool): Assertion `thd->mdl_context.is_lock_owner(MDL_key::TABLE, db.str, table_name.str, MDL_SHARED)' failed.

CREATE TEMPORARY TABLE tmp_user_sys LIKE global_priv;

INSERT INTO tmp_user_sys (Host,User,Priv) VALUES ('localhost','mariadb.sys','{"access":0,"plugin":"mysql_native_password","authentication_string":"","account_locked":true,"password_last_changed":0}');

INSERT IGNORE INTO global_priv SELECT * FROM tmp_user_sys WHERE 0 <> @need_sys_user_creation;

DROP TABLE tmp_user_sys;

while true; do

  rm -rf data[0-9] tmp[0-9] [0-9].log

  for((i=0;i<10;i++)){

    mkdir tmp${i}

  }

  for((i=0;i<10;i++)){

    scripts/mariadb-install-db --no-defaults --force --auth-root-authentication-method=normal --basedir=${PWD} --datadir=${PWD}/data${i} --tmpdir=${PWD}/tmp${i} >> ${i}.log 2>&1 &

  }

  wait %1 %2 %3 %4 %5 %6 %7 %8 %9 %10 2>/dev/null

  if grep -qi 'mysql_rm_table_no_locks' [0-9].log; then

    break

  fi

done

grep 'mysql_rm_table_no_locks' [0-9].log