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

[Draft] Assertion `(mem_root->flags & 4) == 0' failed in add_internal_tables

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Trivial
    • Resolution: Unresolved
    • 10.5
    • 10.5
    • Stored routines
    • None

    Description

      One of zillion memroot failures which aren't get fixed anyway, only this intermediate test case is also non-deterministic so far. Filing so that it can be ignored in tests and leaving till (if ever) somebody actually starts fixing them, otherwise finalizing and cleaning up is just a waste of time.

      Command-line options (also not simplified) in the test case.

      10.5 9b3413c71f16a3d738af358e288a0168f4c15827

      mariadbd: /data/bld/10.5-asan/mysys/my_alloc.c:212: alloc_root: Assertion `(mem_root->flags & 4) == 0' failed.
      241023 19:04:07 [ERROR] mysqld got signal 6 ;
       
      #9  0x00007fef8a853e32 in __GI___assert_fail (assertion=0x56257cdc3880 "(mem_root->flags & 4) == 0", file=0x56257cdc3580 "/data/bld/10.5-asan/mysys/my_alloc.c", line=212, function=0x56257cdc3ba0 <__PRETTY_FUNCTION__.0> "alloc_root") at ./assert/assert.c:101
      #10 0x000056257b9f3e6d in alloc_root (mem_root=0x62500010b978, length=1792) at /data/bld/10.5-asan/mysys/my_alloc.c:212
      #11 0x00005625798af4f6 in Query_arena::alloc (this=0x62b0000cb230, size=1792) at /data/bld/10.5-asan/sql/sql_class.h:1214
      #12 0x0000562579a27d84 in add_internal_tables (thd=0x62b0000cb218, prelocking_ctx=0x625000140140, tables=0x61d0002d96b8) at /data/bld/10.5-asan/sql/sql_base.cc:4613
      #13 0x0000562579a289a4 in DML_prelocking_strategy::handle_table (this=0x7fef68d597a0, thd=0x62b0000cb218, prelocking_ctx=0x625000140140, table_list=0x62500010ca48, need_prelocking=0x7fef68d59270) at /data/bld/10.5-asan/sql/sql_base.cc:4771
      #14 0x0000562579a22061 in extend_table_list (thd=0x62b0000cb218, tables=0x62500010ca48, prelocking_strategy=0x7fef68d597a0, has_prelocking_list=false) at /data/bld/10.5-asan/sql/sql_base.cc:3581
      #15 0x0000562579a2395a in open_and_process_table (thd=0x62b0000cb218, tables=0x62500010ca48, counter=0x7fef68d59690, flags=0, prelocking_strategy=0x7fef68d597a0, has_prelocking_list=false, ot_ctx=0x7fef68d59580) at /data/bld/10.5-asan/sql/sql_base.cc:3879
      #16 0x0000562579a2608a in open_tables (thd=0x62b0000cb218, options=..., start=0x7fef68d596a0, counter=0x7fef68d59690, flags=0, prelocking_strategy=0x7fef68d597a0) at /data/bld/10.5-asan/sql/sql_base.cc:4303
      #17 0x0000562579a2b1bf in open_and_lock_tables (thd=0x62b0000cb218, options=..., tables=0x62500010ca48, derived=true, flags=0, prelocking_strategy=0x7fef68d597a0) at /data/bld/10.5-asan/sql/sql_base.cc:5250
      #18 0x0000562579980bcc in open_and_lock_tables (thd=0x62b0000cb218, tables=0x62500010ca48, derived=true, flags=0) at /data/bld/10.5-asan/sql/sql_base.h:509
      #19 0x0000562579af7c34 in mysql_insert (thd=0x62b0000cb218, table_list=0x62500010ca48, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=true, result=0x0) at /data/bld/10.5-asan/sql/sql_insert.cc:760
      #20 0x0000562579bc456c in mysql_execute_command (thd=0x62b0000cb218) at /data/bld/10.5-asan/sql/sql_parse.cc:4650
      #21 0x0000562579968abe in sp_instr_stmt::exec_core (this=0x625000142008, thd=0x62b0000cb218, nextp=0x7fef68d5aa50) at /data/bld/10.5-asan/sql/sp_head.cc:3842
      #22 0x000056257996708b in sp_lex_keeper::reset_lex_and_exec_core (this=0x625000142050, thd=0x62b0000cb218, nextp=0x7fef68d5aa50, open_tables=false, instr=0x625000142008) at /data/bld/10.5-asan/sql/sp_head.cc:3564
      #23 0x0000562579968246 in sp_instr_stmt::execute (this=0x625000142008, thd=0x62b0000cb218, nextp=0x7fef68d5aa50) at /data/bld/10.5-asan/sql/sp_head.cc:3745
      #24 0x0000562579958db0 in sp_head::execute (this=0x62500010b938, thd=0x62b0000cb218, merge_da_on_success=true) at /data/bld/10.5-asan/sql/sp_head.cc:1442
      #25 0x000056257995f67a in sp_head::execute_procedure (this=0x62500010b938, thd=0x62b0000cb218, args=0x62b0000d0330) at /data/bld/10.5-asan/sql/sp_head.cc:2483
      #26 0x0000562579bb9870 in do_execute_sp (thd=0x62b0000cb218, sp=0x62500010b938) at /data/bld/10.5-asan/sql/sql_parse.cc:3110
      #27 0x0000562579bbb3ca in Sql_cmd_call::execute (this=0x62b0000d2318, thd=0x62b0000cb218) at /data/bld/10.5-asan/sql/sql_parse.cc:3356
      #28 0x0000562579bcfbc6 in mysql_execute_command (thd=0x62b0000cb218) at /data/bld/10.5-asan/sql/sql_parse.cc:6179
      #29 0x0000562579bdcf93 in mysql_parse (thd=0x62b0000cb218, rawbuf=0x62b0000d2238 "CALL sp1_69903", length=14, parser_state=0x7fef68d5cc70, is_com_multi=false, is_next_command=false) at /data/bld/10.5-asan/sql/sql_parse.cc:8237
      #30 0x0000562579bb2279 in dispatch_command (command=COM_QUERY, thd=0x62b0000cb218, packet=0x62900026c219 "CALL sp1_69903", packet_length=14, is_com_multi=false, is_next_command=false) at /data/bld/10.5-asan/sql/sql_parse.cc:1891
      #31 0x0000562579baec0c in do_command (thd=0x62b0000cb218) at /data/bld/10.5-asan/sql/sql_parse.cc:1375
      #32 0x000056257a008755 in do_handle_one_connection (connect=0x608000003d38, put_in_cache=true) at /data/bld/10.5-asan/sql/sql_connect.cc:1407
      #33 0x000056257a0082bb in handle_one_connection (arg=0x608000003d38) at /data/bld/10.5-asan/sql/sql_connect.cc:1319
      #34 0x000056257ac6506c in pfs_spawn_thread (arg=0x61500000e698) at /data/bld/10.5-asan/storage/perfschema/pfs.cc:2201
      #35 0x00007fef8a8a8044 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      #36 0x00007fef8a92861c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
      

      # Remaining options: --mysqld=--plugin-maturity=gamma --mysqld=--open-files-limit=32190 --mysqld=--local-infile=TRUE --mysqld=--secure-file-priv= --mysqld=--log-basename=poodle --mysqld=--debug-no-sync=FALSE --mysqld=--sort-buffer-size=2097152 --mysqld=--max-heap-table-size=16777216 --mysqld=--loose-aria-pagecache-buffer-size=134217728 --mysqld=--loose-feedback-debug-first-interval=86400 --mysqld=--loose-feedback-debug-interval=604800 --mysqld=--loose-innodb-buffer-pool-size=134217728 --mysqld=--loose-innodb-lru-scan-depth=1536 --mysqld=--loose-innodb-write-io-threads=4 --mysqld=--loose-innodb-log-buffer-size=16777216 --mysqld=--loose-innodb-log-file-size=100663296 --mysqld=--loose-innodb-stats-persistent=TRUE --mysqld=--loose-disable-performance-schema --mysqld=--loose-performance-schema-accounts-size=-1 --mysqld=--loose-performance-schema-hosts-size=-1 --mysqld=--loose-performance-schema-users-size=-1 --mysqld=--loose-performance-schema-max-mutex-instances=-1 --mysqld=--loose-performance-schema-max-rwlock-instances=-1 --mysqld=--loose-performance-schema-max-socket-instances=-1 --mysqld=--loose-performance-schema-max-table-instances=-1 --mysqld=--loose-performance-schema-max-table-handles=-1 --mysqld=--loose-performance-schema-setup-objects-size=-1 --mysqld=--loose-performance-schema-events-stages-history-size=-1 --mysqld=--loose-performance-schema-events-stages-history-long-size=-1 --mysqld=--loose-performance-schema-events-statements-history-size=-1 --mysqld=--loose-performance-schema-events-statements-history-long-size=-1 --mysqld=--loose-performance-schema-events-transactions-history-size=-1 --mysqld=--loose-performance-schema-max-thread-instances=-1 --mysqld=--loose-performance-schema-consumer-events-stages-current=FALSE --mysqld=--loose-performance-schema-consumer-events-stages-history=FALSE --mysqld=--loose-performance-schema-consumer-events-stages-history-long=FALSE --mysqld=--loose-performance-schema-consumer-events-statements-current=FALSE --mysqld=--loose-performance-schema-consumer-events-statements-history=FALSE --mysqld=--loose-performance-schema-consumer-events-statements-history-long=FALSE --mysqld=--loose-performance-schema-consumer-events-transactions-history=FALSE --mysqld=--loose-performance-schema-consumer-events-waits-history=FALSE --mysqld=--loose-performance-schema-consumer-global-instrumentation=TRUE --mysqld=--loose-performance-schema-consumer-thread-instrumentation=TRUE --mysqld=--default-storage-engine=InnoDB --mysqld=--use-stat-tables=PREFERABLY_FOR_QUERIES --mysqld=--loose-plugin-innodb --mysqld=--loose-plugin-innodb-buffer-page --mysqld=--loose-plugin-innodb-buffer-page-lru --mysqld=--loose-plugin-innodb-buffer-pool-stats --mysqld=--loose-plugin-innodb-cmp --mysqld=--loose-plugin-innodb-cmp-per-index --mysqld=--loose-plugin-innodb-cmp-per-index-reset --mysqld=--loose-plugin-innodb-cmp-reset --mysqld=--loose-plugin-innodb-cmpmem --mysqld=--loose-plugin-innodb-ft-being-deleted --mysqld=--loose-plugin-innodb-ft-default-stopword --mysqld=--loose-plugin-innodb-ft-deleted --mysqld=--loose-plugin-innodb-ft-index-cache --mysqld=--loose-plugin-innodb-lock-waits --mysqld=--loose-plugin-innodb-locks --mysqld=--loose-plugin-innodb-mutexes --mysqld=--loose-plugin-innodb-sys-columns --mysqld=--loose-plugin-innodb-sys-datafiles --mysqld=--loose-plugin-innodb-sys-fields --mysqld=--loose-plugin-innodb-sys-foreign --mysqld=--loose-plugin-innodb-sys-foreign-cols --mysqld=--loose-plugin-innodb-sys-indexes --mysqld=--loose-plugin-innodb-sys-semaphore-waits --mysqld=--loose-plugin-innodb-sys-tables --mysqld=--loose-plugin-innodb-sys-tablespaces --mysqld=--loose-plugin-innodb-sys-virtual --mysqld=--loose-plugin-innodb-trx --mysqld=--loose-plugin-partition --mysqld=--loose-plugin-sequence --mysqld=--loose-plugin-thread-pool-groups --mysqld=--loose-plugin-thread-pool-queues --mysqld=--loose-plugin-thread-pool-waits --mysqld=--loose-plugin-user-variables --mysqld=--general-log=FALSE --mysqld=--slow-query-log=FALSE --mysqld=--slow-query-log-file=poodle-slow.log --mysqld=--plugin-load-add=query_response_time --mysqld=--character-set-server=latin1 --mysqld=--collation-server=latin1_swedish_nopad_ci --mysqld=--max-statement-time=60 --mysqld=--lock-wait-timeout=30 --mysqld=--innodb-lock-wait-timeout=15 --mysqld=--plugin-maturity=experimental --mysqld=--slow_query_log=ON --mysqld=--completion_type=CHAIN --mysqld=--transaction-isolation=READ-COMMITTED --mysqld=--optimizer_search_depth=63 --mysqld=--skip-show-database=ON --mysqld=--loose-simple-password-check=off --mysqld=--loose-cracklib-password-check=off --mysqld=--loose-aria-block-size=8192 --mysqld=--lock-wait-timeout=0
      # Basedir: /data/bld/10.5-asan
      # Search pattern(s): (?^s:add_internal_tables)
       
      	 CREATE DATABASE IF NOT EXISTS oltp_db;
      	 USE oltp_db;
      	 CREATE TABLE `oltp8` (
       `id` int(10) unsigned NOT NULL auto_increment,
       PRIMARY KEY (`id`)) ENGINE=innodb;
      --connect (con3_1,localhost,root,,)
      --connect (con4_1,localhost,root,,)
      	  CREATE  SEQUENCE seq18 INCREMENT = 4;
       
      ALTER TABLE oltp_db.oltp8 MODIFY `id` INT DEFAULT(NEXTVAL(test.`seq18`)), ALGORITHM = COPY;
      	 USE oltp_db ;
      --connection con3_1
      	 USE oltp_db ;
      --delimiter |||
      	 CREATE PROCEDURE sp1_69903() BEGIN   INSERT IGNORE INTO `oltp8` ( `id` ) VALUES ( NULL ),( NULL ),( NULL ),( NULL ); END|||
      	 CREATE PROCEDURE sp1_69901() BEGIN   UPDATE IGNORE `oltp8` SET `k` = `k` + 1 WHERE `id` = 750; END |||
      --delimiter ;
      --connection con4_1
      	 CALL sp1_69903;
      --connection con3_1
      --error 1054
      	 CALL sp1_69901;
      --connection con4_1
      --send
      	 CALL sp1_69903;
      --connection con3_1
      --error 1054
      	 CALL sp1_69901;
      --connection con4_1
      --reap
      

      Attachments

        Activity

          People

            elenst Elena Stepanova
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.