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

[Draft] Server crashed in Type_std_attributes::set

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.3
    • None
    • Admin statements
    • None

    Description

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

      10.2 d70573564cb2701076083ea7f55ae9539fad13b4

      #3  <signal handler called>
      #4  0x000055706f1b7970 in Type_std_attributes::set (this=0x7f3f1c4174e8, field=0x7f3f1c409250) at /home/travis/src/sql/sql_type.cc:165
      #5  0x000055706f2e2a24 in Item_field::set_field (this=0x7f3f1c4174e0, field_par=0x7f3f1c409250) at /home/travis/src/sql/item.cc:3227
      #6  0x000055706f2eb89b in Item_field::fix_fields (this=0x7f3f1c4174e0, thd=0x7f3f1c000c70, reference=0x7f3f1c417630) at /home/travis/src/sql/item.cc:6266
      #7  0x000055706ef5c926 in setup_fields (thd=0x7f3f1c000c70, ref_pointer_array=..., fields=..., column_usage=MARK_COLUMNS_READ, sum_func_list=0x7f3f1c3aef20, pre_fix=0x7f3f1c415dc0, allow_sum_func=true) at /home/travis/src/sql/sql_base.cc:7311
      #8  0x000055706f016bda in JOIN::prepare (this=0x7f3f1c3aec00, tables_init=0x7f3f1c4181e8, wild_num=0, conds_init=0x0, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7f3f1c415c80, unit_arg=0x7f3f1c415508) at /home/travis/src/sql/sql_select.cc:1128
      #9  0x000055706f0c525d in st_select_lex_unit::prepare_join (this=0x7f3f1c415508, thd_arg=0x7f3f1c000c70, sl=0x7f3f1c415c80, tmp_result=0x7f3f1c418870, additional_options=0, is_union_select=false) at /home/travis/src/sql/sql_union.cc:675
      #10 0x000055706f0c6617 in st_select_lex_unit::prepare (this=0x7f3f1c415508, thd_arg=0x7f3f1c000c70, sel_result=0x7f3f1c418870, additional_options=0) at /home/travis/src/sql/sql_union.cc:947
      #11 0x000055706ef96d81 in mysql_derived_prepare (thd=0x7f3f1c000c70, lex=0x7f3f7c18c910, derived=0x7f3f1c4143b0) at /home/travis/src/sql/sql_derived.cc:769
      #12 0x000055706ef95881 in mysql_handle_derived (lex=0x7f3f7c18c910, phases=35) at /home/travis/src/sql/sql_derived.cc:121
      #13 0x000055706ef56def in open_normal_and_derived_tables (thd=0x7f3f1c000c70, tables=0x7f3f1c410b38, flags=1090, dt_phases=35) at /home/travis/src/sql/sql_base.cc:4971
      #14 0x000055706ef56fae in open_tables_only_view_structure (thd=0x7f3f1c000c70, table_list=0x7f3f1c410b38, can_deadlock=false) at /home/travis/src/sql/sql_base.cc:5027
      #15 0x000055706f074b7b in fill_schema_table_by_open (thd=0x7f3f1c000c70, mem_root=0x7f3f7c18e1c0, is_show_fields_or_keys=false, table=0x7f3f1c179ca8, schema_table=0x557070523060 <schema_tables+320>, orig_db_name=0x7f3f1c4e9980, orig_table_name=0x7f3f1c4d9ec8, open_tables_state_backup=0x7f3f7c18e210, can_deadlock=false) at /home/travis/src/sql/sql_show.cc:4576
      #16 0x000055706f07688a in get_all_tables (thd=0x7f3f1c000c70, tables=0x7f3f1c0187b0, cond=0x7f3f1c3abaf0) at /home/travis/src/sql/sql_show.cc:5276
      #17 0x000055706f08700e in get_schema_tables_result (join=0x7f3f1c36dbc0, executed_place=PROCESSED_BY_JOIN_EXEC) at /home/travis/src/sql/sql_show.cc:8786
      #18 0x000055706f021154 in JOIN::exec_inner (this=0x7f3f1c36dbc0) at /home/travis/src/sql/sql_select.cc:3950
      #19 0x000055706f0207fa in JOIN::exec (this=0x7f3f1c36dbc0) at /home/travis/src/sql/sql_select.cc:3781
      #20 0x000055706f0c8469 in st_select_lex_unit::exec (this=0x7f3f1c004aa8) at /home/travis/src/sql/sql_union.cc:1435
      #21 0x000055706f0c35b8 in mysql_union (thd=0x7f3f1c000c70, lex=0x7f3f1c0049e0, result=0x7f3f1c178d98, unit=0x7f3f1c004aa8, setup_tables_done_option=0) at /home/travis/src/sql/sql_union.cc:41
      #22 0x000055706f013c68 in handle_select (thd=0x7f3f1c000c70, lex=0x7f3f1c0049e0, result=0x7f3f1c178d98, setup_tables_done_option=0) at /home/travis/src/sql/sql_select.cc:360
      #23 0x000055706efdee68 in execute_sqlcom_select (thd=0x7f3f1c000c70, all_tables=0x7f3f1c014b70) at /home/travis/src/sql/sql_parse.cc:6552
      #24 0x000055706efd5471 in mysql_execute_command (thd=0x7f3f1c000c70) at /home/travis/src/sql/sql_parse.cc:3763
      #25 0x000055706efe282a in mysql_parse (thd=0x7f3f1c000c70, rawbuf=0x7f3f1c013b88 "(  SELECT * FROM (INFORMATION_SCHEMA.`COLUMNS` AS table1 RIGHT JOIN INFORMATION_SCHEMA.`PARAMETERS` AS table2 ON ( table2.`COLLATION_NAME` = table1.`PRIVILEGES` ) ) WHERE ( ( ( table1.`NUMERIC_PRECISI"..., length=907, parser_state=0x7f3f7c1905e0, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:8009
      #26 0x000055706efcff23 in dispatch_command (command=COM_QUERY, thd=0x7f3f1c000c70, packet=0x7f3f1c00b3c1 "(  SELECT * FROM (INFORMATION_SCHEMA.`COLUMNS` AS table1 RIGHT JOIN INFORMATION_SCHEMA.`PARAMETERS` AS table2 ON ( table2.`COLLATION_NAME` = table1.`PRIVILEGES` ) ) WHERE ( ( ( table1.`NUMERIC_PRECISI"..., packet_length=908, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1838
      #27 0x000055706efce96f in do_command (thd=0x7f3f1c000c70) at /home/travis/src/sql/sql_parse.cc:1383
      #28 0x000055706f133bef in do_handle_one_connection (connect=0x557072b57050) at /home/travis/src/sql/sql_connect.cc:1402
      #29 0x000055706f13397c in handle_one_connection (arg=0x557072b57050) at /home/travis/src/sql/sql_connect.cc:1308
      #30 0x00007f3f7e6e5184 in start_thread (arg=0x7f3f7c191700) at pthread_create.c:312
      #31 0x00007f3f7dbf203d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
      

      2018-03-05 21:53:57 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-fce066d6-ad01-44b3-88b0-8b13c9abc6e6' or '--log-bin=mysql-bin' to avoid this problem.
      Version: '10.3.6-MariaDB-debug-log'  socket: '/home/travis/logs/vardir1_3/mysql.sock'  port: 19300  Source distribution
      2018-03-05 21:54:08 19 [Warning] Sort aborted, host: localhost, user: rqg, thread: 19, query: SELECT * FROM mysql.`tables_priv` AS table1 WHERE ( ( ( ( ( ( table1.`User` = table1.`User` OR table1.`Db` != table1.`Column_priv`) OR table1.`Host` <= '1979-11-05 05:06:00.026645') AND table1.`Column_priv` = table1.`Db`) AND table1.`Host` >= table1.`User`) AND table1.`Db` <= 2) OR table1.`Table_name` <> table1.`Column_priv`) HAVING table1.`Column_priv` > 'z' ORDER BY table1.`Host` /* QNO 2021 CON_ID 19 */  LIMIT ROWS EXAMINED 22 /* TRANSFORM_OUTCOME_SUBSET */ /* QNO 2070 CON_ID 19 */
      2018-03-05 21:54:55 17 [Warning] Sort aborted, host: localhost, user: rqg, thread: 17, query: SELECT * FROM test.`view_CC` AS table1 WHERE table1.`col_time_key` = table1.`col_datetime_nokey` HAVING table1.`col_time_nokey` < '2010-07-04 21:50:19.060175' ORDER BY table1.`col_date_key` LIMIT 7 ROWS EXAMINED 32 /* QNO 8528 CON_ID 17 */  /* TRANSFORM_OUTCOME_SUBSET */ /* QNO 8576 CON_ID 17 */
      2018-03-05 21:55:19 21 [Warning] Sort aborted, host: localhost, user: rqg, thread: 21, query: SELECT * FROM INFORMATION_SCHEMA.`TABLE_PRIVILEGES` AS table1 WHERE table1.`GRANTEE` <> table1.`IS_GRANTABLE` ORDER BY table1.`TABLE_NAME` /* QNO 8471 CON_ID 21 */  LIMIT ROWS EXAMINED 32 /* TRANSFORM_OUTCOME_SUBSET */ /* QNO 8525 CON_ID 21 */
      2018-03-05 21:55:20 20 [Warning] Sort aborted, host: localhost, user: rqg, thread: 20, query: SELECT * FROM test.`E` AS table1 WHERE ( table1.`col_varchar_nokey` <> 'sl' AND table1.`col_int_key` >= 8) ORDER BY table1.`col_time_nokey` /* QNO 6503 CON_ID 20 */  LIMIT ROWS EXAMINED 1357 /* TRANSFORM_OUTCOME_SUBSET */ /* QNO 6553 CON_ID 20 */
      2018-03-05 21:56:34 17 [Warning] Sort aborted, host: localhost, user: rqg, thread: 17, query: SELECT * FROM INFORMATION_SCHEMA.`PLUGINS` AS table1 WHERE ( ( ( ( ( table1.`PLUGIN_LICENSE` = table1.`PLUGIN_AUTH_VERSION` OR table1.`PLUGIN_NAME` < 'm') OR table1.`PLUGIN_LICENSE` <> table1.`PLUGIN_AUTH_VERSION`) AND table1.`PLUGIN_STATUS` <> 'sn') AND table1.`PLUGIN_TYPE_VERSION` <= table1.`PLUGIN_LICENSE`) OR table1.`PLUGIN_DESCRIPTION` != 3) ORDER BY table1.`PLUGIN_AUTHOR` LIMIT 2 ROWS EXAMINED 73 /* QNO 18368 CON_ID 17 */  /* TRANSFORM_OUTCOME_SUBSET */ /* QNO 18415 CON_ID 17 */
      180305 21:56:34 [ERROR] mysqld got signal 11 ;
       
      Some pointers may be invalid and cause the dump to abort.
      Query (0x7f3f1c013b88): (  SELECT * FROM (INFORMATION_SCHEMA.`COLUMNS` AS table1 RIGHT JOIN INFORMATION_SCHEMA.`PARAMETERS` AS table2 ON ( table2.`COLLATION_NAME` = table1.`PRIVILEGES` ) ) WHERE ( ( ( table1.`NUMERIC_PRECISION` <> table2.`ROUTINE_TYPE` AND table1.`DATETIME_PRECISION` <= 8) OR table1.`IS_GENERATED` < '1990-07-24 06:14:46.049390') AND table2.`PARAMETER_MODE` != table1.`COLLATION_NAME`) LIMIT 6 /* QNO 17889 CON_ID 18 */  ) UNION DISTINCT (  SELECT * FROM (INFORMATION_SCHEMA.`COLUMNS` AS table1 RIGHT JOIN INFORMATION_SCHEMA.`PARAMETERS` AS table2 ON ( table2.`COLLATION_NAME` = table1.`PRIVILEGES` ) ) WHERE ( ( ( table1.`NUMERIC_PRECISION` <> table2.`ROUTINE_TYPE` AND table1.`DATETIME_PRECISION` <= 8) OR table1.`IS_GENERATED` < '1990-07-24 06:14:46.049390') AND table2.`PARAMETER_MODE` != table1.`COLLATION_NAME`) LIMIT 6 /* QNO 17889 CON_ID 18 */  ) /* TRANSFORM_OUTCOME_DISTINCT */ /* QNO 17911 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,split_materialized=on
      

      experimental e42a181399012909fbda32f7e9b7be8b416175c9

      perl /home/travis/rqg/runall-new.pl --duration=350 --threads=6 --seed=1520286834 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ConvertSubqueriesToViews,ConvertTablesToDerived,Count,DisableOptimizations,Distinct,EnableOptimizations,ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsDerived,ExecuteAsExcept,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsIntersect,ExecuteAsSelectItem,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsWhereSubquery,Having,InlineSubqueries,LimitRowsExamined,OrderBy,StraightJoin,ExecuteAsPreparedTwice,ExecuteAsTrigger,ExecuteAsSPTwice,ExecuteAsFunctionTwice --redefine=conf/mariadb/general-workarounds.yy --mysqld=--log_output=FILE --mysqld=--log_bin_trust_function_creators=1 --mysqld=--log-bin --mysqld=--max-statement-time=30 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --views --redefine=conf/mariadb/versioning.yy --basedir=/home/travis/server --grammar=conf/runtime/information_schema.yy --engine=MyISAM --mysqld=--default-storage-engine=MyISAM --vardir=/home/travis/logs/vardir1_3
      

      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.