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

[Draft] Assertion `share->now_transactional || (info->dup_key_trid == 0)' failed in maria_write

    XMLWordPrintable

Details

    Description

      https://api.travis-ci.org/v3/job/362396320/log.txt

      bb-10.2-compatibility 025aee64e0382e728bedc9e71da441be745d7650

      2018-04-05 11:31:58 140401006155648 [Warning] You need to use --log-bin to make --binlog-format work.
      Version: '10.2.14-MariaDB-debug-log'  socket: '/home/travis/logs/vardir1_1/mysql.sock'  port: 19300  Source distribution
      mysqld: /home/travis/src/storage/maria/ma_write.c:221: maria_write: Assertion `share->now_transactional || (info->dup_key_trid == 0)' failed.
      180405 11:32:14 [ERROR] mysqld got signal 6 ;
       
      Query (0x7fb0e00115d8): LOAD DATA INFILE 'load_view_d' REPLACE INTO TABLE view_d /* QNO 536 CON_ID 17 */
      Connection ID (thread ID): 17
      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,engine_condition_pushdown=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=on,mrr_cost_based=on,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_grouping_derived=on
      

      #7  0x00007fb1a5eebca2 in __GI___assert_fail (assertion=0x5611f5308ae8 "share->now_transactional || (info->dup_key_trid == 0)", file=0x5611f5308a20 "/home/travis/src/storage/maria/ma_write.c", line=221, function=0x5611f53091a8 <__PRETTY_FUNCTION__.15892> "maria_write") at assert.c:101
      #8  0x00005611f4e09ca4 in maria_write (info=0x7fb0dc2b30a0, record=0x7fb0dc2b1b68 "\374\377e") at /home/travis/src/storage/maria/ma_write.c:220
      #9  0x00005611f4d935ff in ha_maria::write_row (this=0x7fb0dc2b13e8, buf=0x7fb0dc2b1b68 "\374\377e") at /home/travis/src/storage/maria/ha_maria.cc:1290
      #10 0x00005611f480162f in handler::ha_write_row (this=0x7fb0dc2b13e8, buf=0x7fb0dc2b1b68 "\374\377e") at /home/travis/src/sql/handler.cc:6143
      #11 0x00005611f4504f04 in write_record (thd=0x7fb0e0000d30, table=0x7fb0dc2b07b0, info=0x7fb1a406f910) at /home/travis/src/sql/sql_insert.cc:1656
      #12 0x00005611f498de5d in read_sep_field (thd=0x7fb0e0000d30, info=..., table_list=0x7fb0e0011788, fields_vars=..., set_fields=..., set_values=..., read_info=..., enclosed=..., skip_lines=0, ignore_check_option_errors=false) at /home/travis/src/sql/sql_load.cc:1240
      #13 0x00005611f498c094 in mysql_load (thd=0x7fb0e0000d30, ex=0x7fb0e0011700, table_list=0x7fb0e0011788, fields_vars=..., set_fields=..., set_values=..., handle_duplicates=DUP_REPLACE, ignore=false, read_file_from_client=false) at /home/travis/src/sql/sql_load.cc:653
      #14 0x00005611f4538728 in mysql_execute_command (thd=0x7fb0e0000d30) at /home/travis/src/sql/sql_parse.cc:5091
      #15 0x00005611f454160e in mysql_parse (thd=0x7fb0e0000d30, rawbuf=0x7fb0e00115d8 "LOAD DATA INFILE 'load_view_d' REPLACE INTO TABLE view_d /* QNO 536 CON_ID 17 */", length=80, parser_state=0x7fb1a4071210, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:7978
      #16 0x00005611f452f28f in dispatch_command (command=COM_QUERY, thd=0x7fb0e0000d30, packet=0x7fb0e0008d61 " LOAD DATA INFILE 'load_view_d' REPLACE INTO TABLE view_d /* QNO 536 CON_ID 17 */ ", packet_length=82, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1835
      #17 0x00005611f452dbd3 in do_command (thd=0x7fb0e0000d30) at /home/travis/src/sql/sql_parse.cc:1383
      #18 0x00005611f4680e78 in do_handle_one_connection (connect=0x5611fd7049a0) at /home/travis/src/sql/sql_connect.cc:1335
      #19 0x00005611f4680c05 in handle_one_connection (arg=0x5611fd7049a0) at /home/travis/src/sql/sql_connect.cc:1241
      #20 0x00007fb1a6aad184 in start_thread (arg=0x7fb1a4072700) at pthread_create.c:312
      #21 0x00007fb1a5fba03d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
      

      experimental 4feb78e17fbecf7fc7f2847b49b8c66b54879629

      perl /home/travis/rqg/runall-new.pl --duration=450 --threads=6 --seed=1522927913 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --views --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/bulk_insert.yy --basedir=/home/travis/server --mysqld=--log_output=FILE --mysqld=--max-statement-time=30 --mysqld=--lock-wait-timeout=10 --mysqld=--loose-innodb-lock-wait-timeout=5 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --mysqld=--back-log=128 --mysqld=--binlog_cache_size=262144 --mysqld=--binlog_format=row --mysqld=--binlog_stmt_cache_size=131072 --mysqld=--character_set_server=utf8 --mysqld=--collation_server=utf8_bin --mysqld=--gtid_domain_id=1 --mysqld=--innodb_buffer_pool_instances=8 --mysqld=--innodb_buffer_pool_size=2G --mysqld=--innodb_lock_wait_timeout=600 --mysqld=--innodb_log_buffer_size=67108864 --mysqld=--innodb_log_file_size=100663296 --mysqld=--innodb_max_dirty_pages_pct=50 --mysqld=--innodb_page_cleaners=4 --mysqld=--innodb_print_all_deadlocks=ON --mysqld=--innodb_read_io_threads=8 --mysqld=--innodb_stats_sample_pages=32 --mysqld=--innodb_stats_transient_sample_pages=32 --mysqld=--innodb_write_io_threads=8 --mysqld=--join_buffer_size=4194304 --mysqld=--join_buffer_space_limit=4194304 --mysqld=--join_cache_level=6 --mysqld=--key_buffer_size=67108864 --mysqld=--log_bin_trust_function_creators=ON --mysqld=--log_slave_updates=ON --mysqld=--log_slow_verbosity=innodb,query_plan --mysqld=--log_warnings=1 --mysqld=--long_query_time=30 --mysqld=--lower_case_table_names=1 --mysqld=--master_verify_checksum=ON --mysqld=--max_allowed_packet=67108864 --mysqld=--max_binlog_size=262144000 --mysqld=--max_heap_table_size=33554432 --mysqld=--max_long_data_size=67108864 --mysqld=--max_relay_log_size=262144000 --mysqld=--myisam_recover_options=BACKUP,FORCE --mysqld=--myisam_sort_buffer_size=67108864 --mysqld=--optimizer_search_depth=0 --mysqld=--optimizer_switch=index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=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=on,mrr_cost_based=on,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_grouping_derived=on --mysqld=--plugin_maturity=gamma --mysqld=--query_cache_size=0 --mysqld=--relay_log_recovery=ON --mysqld=--replicate_events_marked_for_skip=FILTER_ON_MASTER --mysqld=--slave_parallel_threads=4 --mysqld=--slave_parallel_workers=4 --mysqld=--slow_query_log=ON --mysqld=--sql_mode=STRICT_TRANS_TABLES --mysqld=--sync_binlog=1 --mysqld=--thread_pool_size=4 --mysqld=--tmp_memory_table_size=33554432 --mysqld=--tmp_table_size=33554432 --mysqld=--transaction_isolation=READ-COMMITTED --mysqld=--use_stat_tables=PREFERABLY --mysqld=--userstat=ON --mysqld=--default-storage-engine=Aria --grammar=conf/partitioning/partitions.yy --transformers=ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsExcept,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsIntersect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsPreparedTwice,ExecuteAsSPTwice,ExecuteAsTrigger,ExecuteAsFunctionTwice --vardir=/home/travis/logs/vardir1_1
      

      Could not reproduce so far because I keep running onto MDEV-15878 instead.

      Attachments

        Activity

          People

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