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

[Draft] Server crashes in my_charset_same / String::needs_conversion

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.3
    • None
    • Character Sets, Server
    • None

    Description

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

      10.3 d70573564cb2701076083ea7f55ae9539fad13b4

      #3  <signal handler called>
      #4  __strcmp_ssse3 () at ../sysdeps/x86_64/multiarch/../strcmp.S:282
      #5  0x000055e950e22e9c in my_charset_same (cs1=0x55e9519c6840 <my_charset_latin1>, cs2=0x55e9519c6841 <my_charset_latin1+1>) at /home/travis/src/mysys/charset.c:37
      #6  0x000055e950466cc1 in String::needs_conversion (arg_length=0, from_cs=0x55e9519c6840 <my_charset_latin1>, to_cs=0x55e9519c6841 <my_charset_latin1+1>, offset=0x7f1f8c41e81c) at /home/travis/src/sql/sql_string.cc:283
      #7  0x000055e95034f114 in THD::update_charset (this=0x7f1f6001b8d0) at /home/travis/src/sql/sql_class.cc:2586
      #8  0x000055e9502d450e in THD::update_charset (this=0x7f1f6001b8d0, character_set_client=0x55e9519c6840 <my_charset_latin1>, collation_connection=0x55e9519c6841 <my_charset_latin1+1>) at /home/travis/src/sql/sql_class.h:3831
      #9  0x000055e9504adf9b in Default_object_creation_ctx::change_env (this=0x7f1f60197b30, thd=0x7f1f6001b8d0) at /home/travis/src/sql/table.cc:140
      #10 0x000055e9504adddc in Object_creation_ctx::set_n_backup (this=0x7f1f60197b30, thd=0x7f1f6001b8d0) at /home/travis/src/sql/table.cc:102
      #11 0x000055e9503b9355 in parse_sql (thd=0x7f1f6001b8d0, parser_state=0x7f1f8c41ea50, creation_ctx=0x7f1f60197b30, do_pfs_digest=false) at /home/travis/src/sql/sql_parse.cc:10009
      #12 0x000055e9504a9e61 in mysql_make_view (thd=0x7f1f6001b8d0, share=0x7f1f581282f8, table=0x7f1f60196dc8, open_view_no_parse=false) at /home/travis/src/sql/sql_view.cc:1396
      #13 0x000055e9503229a0 in open_table (thd=0x7f1f6001b8d0, table_list=0x7f1f60196dc8, ot_ctx=0x7f1f8c41f6d0) at /home/travis/src/sql/sql_base.cc:1835
      #14 0x000055e950325c6d in open_and_process_table (thd=0x7f1f6001b8d0, lex=0x7f1f8c41f9d0, tables=0x7f1f60196dc8, counter=0x7f1f8c41f79c, flags=1090, prelocking_strategy=0x7f1f8c41f7a0, has_prelocking_list=false, ot_ctx=0x7f1f8c41f6d0) at /home/travis/src/sql/sql_base.cc:3512
      #15 0x000055e950326e41 in open_tables (thd=0x7f1f6001b8d0, options=..., start=0x7f1f8c41f780, counter=0x7f1f8c41f79c, flags=1090, prelocking_strategy=0x7f1f8c41f7a0) at /home/travis/src/sql/sql_base.cc:4032
      #16 0x000055e95031f2e6 in open_tables (thd=0x7f1f6001b8d0, tables=0x7f1f8c41f780, counter=0x7f1f8c41f79c, flags=1090, prelocking_strategy=0x7f1f8c41f7a0) at /home/travis/src/sql/sql_base.h:238
      #17 0x000055e950328dd6 in open_normal_and_derived_tables (thd=0x7f1f6001b8d0, tables=0x7f1f60196dc8, flags=1090, dt_phases=35) at /home/travis/src/sql/sql_base.cc:4970
      #18 0x000055e950328fae in open_tables_only_view_structure (thd=0x7f1f6001b8d0, table_list=0x7f1f60196dc8, can_deadlock=false) at /home/travis/src/sql/sql_base.cc:5027
      #19 0x000055e950446b7b in fill_schema_table_by_open (thd=0x7f1f6001b8d0, mem_root=0x7f1f8c421280, is_show_fields_or_keys=false, table=0x7f1f600f98d8, schema_table=0x55e9518f5060 <schema_tables+320>, orig_db_name=0x7f1f6018e220, orig_table_name=0x7f1f6018e498, open_tables_state_backup=0x7f1f8c4212d0, can_deadlock=false) at /home/travis/src/sql/sql_show.cc:4576
      #20 0x000055e95044888a in get_all_tables (thd=0x7f1f6001b8d0, tables=0x7f1f60030968, cond=0x7f1f6014b048) at /home/travis/src/sql/sql_show.cc:5276
      #21 0x000055e95045900e in get_schema_tables_result (join=0x7f1f6012ef20, executed_place=PROCESSED_BY_JOIN_EXEC) at /home/travis/src/sql/sql_show.cc:8786
      #22 0x000055e9503f3154 in JOIN::exec_inner (this=0x7f1f6012ef20) at /home/travis/src/sql/sql_select.cc:3950
      #23 0x000055e9503f27fa in JOIN::exec (this=0x7f1f6012ef20) at /home/travis/src/sql/sql_select.cc:3781
      #24 0x000055e9503f3a6e in mysql_select (thd=0x7f1f6001b8d0, tables=0x7f1f60030290, wild_num=1, fields=..., conds=0x7f1f60032400, og_num=0, order=0x0, group=0x0, having=0x7f1f60032bb0, proc_param=0x0, select_options=552440433408, result=0x7f1f6012ef00, unit=0x7f1f6001f708, select_lex=0x7f1f6001fe80) at /home/travis/src/sql/sql_select.cc:4186
      #25 0x000055e9503e5d41 in handle_select (thd=0x7f1f6001b8d0, lex=0x7f1f6001f640, result=0x7f1f6012ef00, setup_tables_done_option=0) at /home/travis/src/sql/sql_select.cc:382
      #26 0x000055e9503b0e68 in execute_sqlcom_select (thd=0x7f1f6001b8d0, all_tables=0x7f1f60030290) at /home/travis/src/sql/sql_parse.cc:6552
      #27 0x000055e9503a7471 in mysql_execute_command (thd=0x7f1f6001b8d0) at /home/travis/src/sql/sql_parse.cc:3763
      #28 0x000055e9503b482a in mysql_parse (thd=0x7f1f6001b8d0, rawbuf=0x7f1f6002f6b8 "SELECT * FROM (INFORMATION_SCHEMA.`ROUTINES` AS table1 INNER JOIN INFORMATION_SCHEMA.`COLUMNS` AS table2 ON ( table2.`EXTRA` = table1.`SECURITY_TYPE` ) ) WHERE ( (NOT table2.`NUMERIC_PRECISION` = 6 OR"..., length=382, parser_state=0x7f1f8c4235e0, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:8009
      #29 0x000055e9503a1f23 in dispatch_command (command=COM_QUERY, thd=0x7f1f6001b8d0, packet=0x7f1f60027581 " SELECT * FROM (INFORMATION_SCHEMA.`ROUTINES` AS table1 INNER JOIN INFORMATION_SCHEMA.`COLUMNS` AS table2 ON ( table2.`EXTRA` = table1.`SECURITY_TYPE` ) ) WHERE ( (NOT table2.`NUMERIC_PRECISION` = 6 O"..., packet_length=384, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1838
      #30 0x000055e9503a096f in do_command (thd=0x7f1f6001b8d0) at /home/travis/src/sql/sql_parse.cc:1383
      #31 0x000055e950505bef in do_handle_one_connection (connect=0x55e953966050) at /home/travis/src/sql/sql_connect.cc:1402
      #32 0x000055e95050597c in handle_one_connection (arg=0x55e953966050) at /home/travis/src/sql/sql_connect.cc:1308
      #33 0x00007f1fa3735184 in start_thread (arg=0x7f1f8c424700) at pthread_create.c:312
      #34 0x00007f1fa2c4203d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
      

      2018-03-05 16:16:36 0 [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-79f92be5-e822-45e0-b837-4c291da6a503' or '--log-bin=mysql-bin' to avoid this problem.
      Version: '10.3.6-MariaDB-debug-log'  socket: '/home/travis/logs/vardir1_2/mysql.sock'  port: 19300  Source distribution
      2018-03-05 16:16:45 0 [ERROR] InnoDB: Cannot save table statistics for table `transforms`.`insert_select_26240`: Lock wait timeout
      2018-03-05 16:16:46 20 [ERROR] InnoDB: Cannot save table statistics for table `transforms`.`delete_returning_26244`: Lock wait timeout
      2018-03-05 16:16:47 17 [Warning] InnoDB: Unable to delete statistics for table transforms.delete_returning_26238: Lock wait timeout. They can be deleted later using DELETE FROM mysql.innodb_index_stats WHERE database_name = 'transforms' AND table_name = 'delete_returning_26238'; DELETE FROM mysql.innodb_table_stats WHERE database_name = 'transforms' AND table_name = 'delete_returning_26238';
      180305 16:16:48 [ERROR] mysqld got signal 11 ;
       
      Query (0x7f1f6002f6b8): SELECT * FROM (INFORMATION_SCHEMA.`ROUTINES` AS table1 INNER JOIN INFORMATION_SCHEMA.`COLUMNS` AS table2 ON ( table2.`EXTRA` = table1.`SECURITY_TYPE` ) ) WHERE ( (NOT table2.`NUMERIC_PRECISION` = 6 OR table1.`COLLATION_CONNECTION` <> table2.`CHARACTER_MAXIMUM_LENGTH`) OR table1.`ROUTINE_TYPE` >= 'd') HAVING table1.`CHARACTER_SET_NAME` = 'p' IS NULL LIMIT 3 /* QNO 576 CON_ID 21 */
      Connection ID (thread ID): 21
      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,split_materialized=on
      

      experimental e42a181399012909fbda32f7e9b7be8b416175c9

      perl /home/travis/rqg/runall-new.pl --duration=350 --threads=6 --seed=1520266593 --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/runtime/information_schema.yy --gendata-advanced --skip-gendata --engine=InnoDB --vardir=/home/travis/logs/vardir1_2
      

      Not reproducible right away.

      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.