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

parts.alter_table asserts on MacOSX

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 11.4, 13.0
    • N/A
    • Partitioning
    • 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

          Activity

            People

              Unassigned Unassigned
              gkodinov Georgi Kodinov
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.