Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
11.4, 13.0
-
None
-
Not for Release Notes
Description
blackbook:~/dev/server-main/bld/mysql-test$./mtr parts.alter_table
|
Logging: /Users/gkodinov/dev/server-main/mysql-test/mariadb-test-run.pl parts.alter_table
|
VS config:
|
vardir: /Users/gkodinov/dev/server-main/bld/mysql-test/var
|
Checking leftover processes...
|
Removing old var directory...
|
Creating var directory '/Users/gkodinov/dev/server-main/bld/mysql-test/var'...
|
Checking supported features...
|
MariaDB Version 13.0.1-MariaDB-debug
|
- SSL connections supported
|
- binaries are debug compiled
|
Collecting tests...
|
Installing system database...
|
|
|
==============================================================================
|
|
|
TEST RESULT TIME (ms) or COMMENT
|
--------------------------------------------------------------------------
|
|
|
worker[01] Using MTR_BUILD_THREAD 300, with reserved ports 19000..19029
|
parts.alter_table 'aria,lcase1,range' [ pass ] 186
|
parts.alter_table 'aria,lcase1,list' [ pass ] 185
|
parts.alter_table 'aria,lcase2,range' [ fail ]
|
Test ended at 2026-04-03 10:32:43
|
|
|
CURRENT_TEST: parts.alter_table
|
mysqltest: At line 236: query 'alter table t1 convert partition p3 to table EXISTENT.TP3' failed: <Unknown> (2013): Lost connection to server during query
|
|
|
The result from queries just before the failure was:
|
< snip >
|
t1 CREATE TABLE `t1` (
|
`x` int(11) DEFAULT NULL
|
) ENGINE=X DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
|
PARTITION BY RANGE (`x`)
|
(PARTITION `p1` VALUES LESS THAN (10) ENGINE = X,
|
PARTITION `p3` VALUES LESS THAN (30) ENGINE = X,
|
PARTITION `p4` VALUES LESS THAN (40) ENGINE = X,
|
PARTITION `p5` VALUES LESS THAN (50) ENGINE = X,
|
PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = X)
|
select * from t1 order by x;
|
x
|
2
|
22
|
32
|
42
|
52
|
alter table t1 convert partition p3 to table inexistent.tp3;
|
ERROR 42000: Unknown database 'inexistent'
|
create database EXISTENT;
|
alter table t1 convert partition p3 to table EXISTENT.TP3;
|
|
|
More results from queries before failure can be found in /Users/gkodinov/dev/server-main/bld/mysql-test/var/log/alter_table.log
|
|
|
|
|
Server [mysqld.1 - pid: 45475, winpid: 45475, exit: 256] failed during test run
|
Server log from this test:
|
----------SERVER LOG START-----------
|
$ /Users/gkodinov/dev/server-main/bld/sql/mariadbd --defaults-group-suffix=.1 --defaults-file=/Users/gkodinov/dev/server-main/bld/mysql-test/var/my.cnf --log-output=file --default-storage-engine=aria --lower_case_table_names=2 --loose-enable-partition --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-lock-waits --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-lock-waits --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual --core-file --loose-debug-sync-timeout=300
|
2026-04-03 10:32:43 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 32196)
|
2026-04-03 10:32:43 0 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 (was 151) table_cache: 421 (was 2000)
|
2026-04-03 10:32:43 0 [Note] Starting MariaDB 13.0.1-MariaDB-debug-log source revision 9fc925d77163f1d63e21a65654b0f59678abf08d server_uid Er70gjl5AIhtPxpS1AkrVwA/qdA= as process 45476
|
2026-04-03 10:32:43 0 [Note] Help others discover MariaDB. Star it on GitHub: https://github.com/MariaDB/server
|
2026-04-03 10:32:43 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
|
2026-04-03 10:32:43 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
|
2026-04-03 10:32:43 0 [Note] InnoDB: Number of transaction pools: 1
|
2026-04-03 10:32:43 0 [Note] InnoDB: Using generic crc32 instructions
|
2026-04-03 10:32:43 0 [Note] InnoDB: innodb_buffer_pool_size_max=8388608m, innodb_buffer_pool_size=8m
|
2026-04-03 10:32:43 0 [Note] InnoDB: Completed initialization of buffer pool
|
2026-04-03 10:32:43 0 [Note] InnoDB: End of log at LSN=54224
|
2026-04-03 10:32:43 0 [Note] InnoDB: Opened 3 undo tablespaces
|
2026-04-03 10:32:43 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
|
2026-04-03 10:32:43 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
|
2026-04-03 10:32:43 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
|
2026-04-03 10:32:43 0 [Note] InnoDB: log sequence number 54224; transaction id 16
|
2026-04-03 10:32:43 0 [Note] InnoDB: Loading buffer pool(s) from /Users/gkodinov/dev/server-main/bld/mysql-test/var/mysqld.1/data/ib_buffer_pool
|
2026-04-03 10:32:43 0 [Note] Plugin 'SEQUENCE' is disabled.
|
2026-04-03 10:32:43 0 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
|
2026-04-03 10:32:43 0 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
|
2026-04-03 10:32:43 0 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
|
2026-04-03 10:32:43 0 [Note] Plugin 'INNODB_CMP' is disabled.
|
2026-04-03 10:32:43 0 [Note] Plugin 'THREAD_POOL_WAITS' is disabled.
|
2026-04-03 10:32:43 0 [Note] InnoDB: Buffer pool(s) load completed at 260403 10:32:43
|
2026-04-03 10:32:43 0 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
|
2026-04-03 10:32:43 0 [Note] Plugin 'THREAD_POOL_QUEUES' is disabled.
|
2026-04-03 10:32:43 0 [Note] Plugin 'FEEDBACK' is disabled.
|
2026-04-03 10:32:43 0 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
|
2026-04-03 10:32:43 0 [Note] Plugin 'THREAD_POOL_GROUPS' is disabled.
|
2026-04-03 10:32:43 0 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
|
2026-04-03 10:32:43 0 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
|
2026-04-03 10:32:43 0 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
|
2026-04-03 10:32:43 0 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
|
2026-04-03 10:32:43 0 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
|
2026-04-03 10:32:43 0 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
|
2026-04-03 10:32:43 0 [Note] Plugin 'user_variables' is disabled.
|
2026-04-03 10:32:43 0 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.
|
2026-04-03 10:32:43 0 [Note] Plugin 'THREAD_POOL_STATS' is disabled.
|
2026-04-03 10:32:43 0 [Note] Plugin 'caching_sha2_password' is disabled.
|
2026-04-03 10:32:43 0 [Note] Plugin 'unix_socket' is disabled.
|
2026-04-03 10:32:43 0 [Note] Plugin 'parsec' is disabled.
|
2026-04-03 10:32:43 0 [Warning] /Users/gkodinov/dev/server-main/bld/sql/mariadbd: unknown option '--loose-pam-debug'
|
2026-04-03 10:32:43 0 [Warning] /Users/gkodinov/dev/server-main/bld/sql/mariadbd: unknown option '--loose-aria'
|
2026-04-03 10:32:43 0 [Note] Server socket created on IP: '127.0.0.1', port: '19000'.
|
2026-04-03 10:32:43 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
|
2026-04-03 10:32:43 0 [Note] /Users/gkodinov/dev/server-main/bld/sql/mariadbd: ready for connections.
|
Version: '13.0.1-MariaDB-debug-log' socket: '/Users/gkodinov/dev/server-main/bld/mysql-test/var/tmp/mysqld.1.sock' port: 19000 Source distribution
|
Assertion failed: (mdl_namespace_arg == USER_LOCK || Lex_ident_fs(db, m_db_name_length). ok_for_lower_case_names()), function <unknown>, file mdl.h, line 368.
|
260403 10:32:43 [ERROR] /Users/gkodinov/dev/server-main/bld/sql/mariadbd 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 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: 13.0.1-MariaDB-debug-log source revision: 9fc925d77163f1d63e21a65654b0f59678abf08d
|
|
|
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: 0xb19cf9088
|
stack_bottom = 0x16f67ee70 thread_stack 0x49000
|
Printing to addr2line failed
|
0 mariadbd 0x0000000101f0b58c my_print_stacktrace + 64
|
0 mariadbd 0x0000000100e28d2c handle_fatal_signal + 612
|
0 libsystem_platform.dylib 0x00000001980c5764 _sigtramp + 56
|
0 libsystem_pthread.dylib 0x00000001980bb888 pthread_kill + 296
|
0 libsystem_c.dylib 0x0000000197fc0850 abort + 124
|
0 libsystem_c.dylib 0x0000000197fbfa84 err + 0
|
0 mariadbd 0x0000000100f1194c _ZN7MDL_key12mdl_key_initENS_18enum_mdl_namespaceEPKcS2_ + 688
|
0 mariadbd 0x00000001015552ec _ZN11MDL_request16init_with_sourceEN7MDL_key18enum_mdl_namespaceEPKcS3_13enum_mdl_type17enum_mdl_durationS3_j + 72
|
0 mariadbd 0x0000000101439c30 _Z17mysql_alter_tableP3THDPK25st_mysql_const_lex_stringS3_P22Table_specification_stP10TABLE_LISTP13Recreate_infoP10Alter_infojP8st_orderbb + 3104
|
0 mariadbd 0x000000010154fa60 _ZN19Sql_cmd_alter_table7executeEP3THD + 2264
|
0 mariadbd 0x00000001012f5aec _Z21mysql_execute_commandP3THDb + 28752
|
0 mariadbd 0x00000001012e8dc0 _Z11mysql_parseP3THDPcjP12Parser_state + 940
|
0 mariadbd 0x00000001012e5d50 _Z16dispatch_command19enum_server_commandP3THDPcjb + 3584
|
0 mariadbd 0x00000001012e988c _Z10do_commandP3THDb + 1568
|
0 mariadbd 0x000000010153e904 _Z24do_handle_one_connectionP7CONNECTb + 396
|
0 mariadbd 0x000000010153e63c handle_one_connection + 100
|
0 mariadbd 0x00000001018bd9e0 pfs_spawn_thread + 284
|
0 libsystem_pthread.dylib 0x00000001980bbc08 _pthread_start + 136
|
0 libsystem_pthread.dylib 0x00000001980b6ba8 thread_start + 8
|
|
|
Connection ID (thread ID): 4
|
Status: NOT_KILLED
|
Query (0xb1aff00a0): alter table t1 convert partition p3 to table EXISTENT.TP3
|
|
|
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,duplicateweedout=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,reorder_outer_joins=off
|
|
|
Core pattern: /cores/core.%P
|
----------SERVER LOG END-------------
|
|
|
|
|
- saving '/Users/gkodinov/dev/server-main/bld/mysql-test/var/log/parts.alter_table-aria,lcase2,range/' to '/Users/gkodinov/dev/server-main/bld/mysql-test/var/log/parts.alter_table-aria,lcase2,range/'
|
|
|
Only 3 of 18 completed.
|
--------------------------------------------------------------------------
|
The servers were restarted 1 times
|
Spent 0.371 of 9 seconds executing testcases
|
|
|
Failure: Failed 1/3 tests, 66.67% were successful.
|
|
|
Failing test(s): parts.alter_table
|
|
|
The log files in var/log may give you some hint of what went wrong.
|
|
|
If you want to report this error, MariaDB's bug tracker is found at
|
https://jira.mariadb.org
|
This is compiled on MacOSX with the following cmake flags:
"cmake.configureArgs": [
|
"-DENABLE_GCOV=OFF",
|
"-DCMAKE_C_FLAGS=-fno-color-diagnostics",
|
"-DCMAKE_CXX_FLAGS=-fno-color-diagnostics",
|
"-DCMAKE_COLOR_MAKEFILE=OFF",
|
"-DCMAKE_VERBOSE_MAKEFILE=OFF",
|
"-DCMAKE_BUILD_TYPE=Debug",
|
"-DCMAKE_EXPORT_COMPILE_COMMANDS=ON",
|
"-DMYSQL_MAINTAINER_MODE=OFF",
|
"-DPLUGIN_ARCHIVE=NO",
|
"-DPLUGIN_MROONGA=NO",
|
"-DPLUGIN_CONNECT=NO",
|
"-DPLUGIN_SPIDER=NO",
|
"-DPLUGIN_ROCKSDB=NO",
|
"-DPLUGIN_OQGRAPH=NO",
|
"-DPLUGIN_TOKUDB=NO",
|
"-DWITH_ASAN=OFF",
|
"-DWITH_MSAN=OFF",
|
"-DWITH_SAFEMALLOC=ON",
|
"-DWITH_MARIABACKUP=ON",
|
"-DWITH_EMBEDDED_SERVER=OFF",
|
"-DWITH_UNIT_TESTS=OFF",
|
"-DCONC_WITH_UNITTEST=OFF",
|
"-DWITH_WSREP=OFF",
|
"-DWITHOUT_DYNAMIC_PLUGINS=0",
|
"-DWITH_SSL=bundled",
|
"-DWITH_PCRE=bundled"
|
]
|
blackbook:~/dev/mdev-39028$sw_vers
|
ProductName: macOS
|
ProductVersion: 26.3.1
|
ProductVersionExtra: (a)
|
BuildVersion: 25D771280a
|
blackbook:~/dev/mdev-39028$cc --version
|
Apple clang version 17.0.0 (clang-1700.6.4.2)
|
Target: arm64-apple-darwin25.3.0
|
Thread model: posix
|
InstalledDir: /Library/Developer/CommandLineTools/usr/bin
|
Attachments
Issue Links
- duplicates
-
MDEV-37739 parts test suite fails on case-insensitive filesystems, debug assertions, wrong results
-
- Confirmed
-
- relates to
-
MDEV-28154 parts.alter_table fails on hfs+, Assertion `mdl_namespace_arg == USER_LOCK || ok_for_lower_case_names(db)' failed in MDL_key::mdl_key_init
-
- Open
-