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

[Draft] Server crashed in I_P_List<MDL_ticket, I_P_List_adapter<MDL_ticket, &MDL_ticket::next_in_lock, &MDL_ticket::prev_in_lock>, I_P_List_null_counter, I_P_List_fast_push_back<MDL_ticket> >::remove

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.2
    • N/A
    • Locking
    • None

    Description

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

      10.2 8f98835bb86550a68a6c412d8417cc169dfdc206

      #3  <signal handler called>
      #4  0x00005626ee327e29 in I_P_List<MDL_ticket, I_P_List_adapter<MDL_ticket, &MDL_ticket::next_in_lock, &MDL_ticket::prev_in_lock>, I_P_List_null_counter, I_P_List_fast_push_back<MDL_ticket> >::remove (this=0x7f94e011bca8, a=0x7f950c0241b0) at /home/travis/src/sql/sql_plist.h:128
      #5  0x00005626ee323e13 in MDL_lock::Ticket_list::remove_ticket (this=0x7f94e011bca8, ticket=0x7f950c0241b0) at /home/travis/src/sql/mdl.cc:1219
      #6  0x00005626ee324558 in MDL_lock::remove_ticket (this=0x7f94e011baa0, pins=0x5626f0aeaf00, list=&MDL_lock::m_granted, ticket=0x7f950c0241b0) at /home/travis/src/sql/mdl.cc:1654
      #7  0x00005626ee3261d7 in MDL_context::release_lock (this=0x7f950c008b78, duration=MDL_TRANSACTION, ticket=0x7f950c0241b0) at /home/travis/src/sql/mdl.cc:2627
      #8  0x00005626ee326367 in MDL_context::release_locks_stored_before (this=0x7f950c008b78, duration=MDL_TRANSACTION, sentinel=0x0) at /home/travis/src/sql/mdl.cc:2677
      #9  0x00005626ee3267fc in MDL_context::release_transactional_locks (this=0x7f950c008b78) at /home/travis/src/sql/mdl.cc:2846
      #10 0x00005626ee1d8667 in mysql_execute_command (thd=0x7f950c008a50) at /home/travis/src/sql/sql_parse.cc:6333
      #11 0x00005626ee1dcb2f in mysql_parse (thd=0x7f950c008a50, rawbuf=0x7f950c01b0f8 "DELETE FROM `table100_innodb_int_autoinc` WHERE `col_decimal_unsigned` > 'promise' LIMIT 1  /* QNO 225 CON_ID 18 */", length=115, parser_state=0x7f95480c7210, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:7902
      #12 0x00005626ee1caa65 in dispatch_command (command=COM_QUERY, thd=0x7f950c008a50, packet=0x7f950c012fc1 " DELETE FROM `table100_innodb_int_autoinc` WHERE `col_decimal_unsigned` > 'promise' LIMIT 1  /* QNO 225 CON_ID 18 */ ", packet_length=117, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1806
      #13 0x00005626ee1c93c8 in do_command (thd=0x7f950c008a50) at /home/travis/src/sql/sql_parse.cc:1360
      #14 0x00005626ee31890a in do_handle_one_connection (connect=0x5626f151f880) at /home/travis/src/sql/sql_connect.cc:1335
      #15 0x00005626ee318697 in handle_one_connection (arg=0x5626f151f880) at /home/travis/src/sql/sql_connect.cc:1241
      #16 0x00007f954a009184 in start_thread (arg=0x7f95480c8700) at pthread_create.c:312
      #17 0x00007f954951603d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
      

      2018-03-06  0:59:24 140279192409984 [Warning] No argument was provided to --log-bin and neither --log-basename or --log-bin-index where used;  This may cause repliction to break when this server acts as a master and has its hostname changed! Please use '--log-basename=travis-job-6444e430-2aa2-4344-8953-acda2bcca43e' or '--log-bin=mysql-bin' to avoid this problem.
      Version: '10.2.14-MariaDB-debug-log'  socket: '/home/travis/logs/vardir1_2/mysql.sock'  port: 19300  Source distribution
      2018-03-06  1:00:05 140278665422592 [Warning] Sort aborted, host: localhost, user: rqg, thread: 21, query: UPDATE `table0_innodb_int_autoinc` SET `col_set_utf8_key_default_null` = 6 WHERE `col_char_utf8_not_null` < 'suggest' ORDER BY `col_set_utf8`  /* QNO 139 CON_ID 21 */
      2018-03-06  1:00:06 140279135635200 [Warning] Sort aborted, host: localhost, user: rqg, thread: 18, query: UPDATE `view_table10_innodb_key_pk_parts_2_int_autoinc` SET `col_decimal_key` = @a ORDER BY `col_float_default_null` LIMIT 1  /* QNO 162 CON_ID 18 */
      180306  1:00:08 [ERROR] mysqld got signal 11 ;
       
      Query (0x7f950c01b0f8): DELETE FROM `table100_innodb_int_autoinc` WHERE `col_decimal_unsigned` > 'promise' LIMIT 1  /* QNO 225 CON_ID 18 */
      Connection ID (thread ID): 18
      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=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=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on
      

      experimental e42a181399012909fbda32f7e9b7be8b416175c9

      perl /home/travis/rqg/runall-new.pl --duration=350 --threads=6 --seed=1520297961 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsExcept,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsIntersect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsPreparedTwice,ExecuteAsSPTwice --redefine=conf/mariadb/general-workarounds.yy --mysqld=--log_output=FILE --views --vcols --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/bulk_insert.yy --redefine=conf/mariadb/xa.yy --basedir=/home/travis/server --mysqld=--log_bin_trust_function_creators=1 --mysqld=--log-bin --mysqld=--max-statement-time=30 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --grammar=conf/replication/replication.yy --gendata=conf/replication/replication-5.1.zz --engine=InnoDB --vardir=/home/travis/logs/vardir1_2
      

      Not reproducible right away.

      Attachments

        Issue Links

          Activity

            People

              elenst Elena Stepanova
              elenst Elena Stepanova
              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.