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

[Draft] Assertion `dec <= 6' failed in my_datetime_binary_length

    XMLWordPrintable

Details

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

    Description

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

      10.3 c0f5addecb672477dc553b3587ab4d517053b1ee

      mysqld: /home/travis/src/sql/compat56.cc:285: uint my_datetime_binary_length(uint): Assertion `dec <= 6' failed.
      180408 15:25:42 [ERROR] mysqld got signal 6 ;
       
      Query (0x7ff9580e59f0): SELECT * FROM `view_AA` INTO OUTFILE 'load_view_AA'  /* QNO 3798 CON_ID 19 */
      Connection ID (thread ID): 19
      Status: NOT_KILLED
      

      #7  0x00007ff9abc9aca2 in __GI___assert_fail (assertion=0x555fdfe2af24 "dec <= 6", file=0x555fdfe2aee0 "/home/travis/src/sql/compat56.cc", line=285, function=0x555fdfe2b1c0 <my_datetime_binary_length(unsigned int)::__PRETTY_FUNCTION__> "uint my_datetime_binary_length(uint)") at assert.c:101
      #8  0x0000555fdf42c3b5 in my_datetime_binary_length (dec=1275612616) at /home/travis/src/sql/compat56.cc:285
      #9  0x0000555fdf45b84d in Field_datetimef::pack_length (this=0x7ff9581209e8) at /home/travis/src/sql/field.h:3072
      #10 0x0000555fdf450986 in Field::eq_def (this=0x7ff9581209e8, field=0x7ff958131d48) at /home/travis/src/sql/field.cc:9313
      #11 0x0000555fdf45a87c in Field_temporal::eq_def (this=0x7ff9581209e8, field=0x7ff958131d48) at /home/travis/src/sql/field.h:2414
      #12 0x0000555fdf1e99cc in create_tmp_field (thd=0x7ff95800b390, table=0x7ff9581303b8, item=0x7ff9580e9438, type=Item::FIELD_ITEM, copy_func=0x7ff9a82b1a00, from_field=0x7ff9581315c8, default_field=0x7ff958131540, group=false, modify_item=false, table_cant_handle_bit_fields=false, make_copy_field=false) at /home/travis/src/sql/sql_select.cc:16835
      #13 0x0000555fdf1eb11d in create_tmp_table (thd=0x7ff95800b390, param=0x7ff95801fa60, fields=..., group=0x0, distinct=false, save_sum_fields=true, select_options=2416188160, rows_limit=18446744073709551615, table_alias=0x7ff9580e5cb8, do_not_open=true, keep_row_order=false) at /home/travis/src/sql/sql_select.cc:17281
      #14 0x0000555fdf26c26f in select_unit::create_result_table (this=0x7ff95801fa28, thd_arg=0x7ff95800b390, column_types=0x7ff9580e7388, is_union_distinct=false, options=2416188160, alias=0x7ff9580e5cb8, bit_fields_as_long=false, create_table=false, keep_row_order=false, hidden=0) at /home/travis/src/sql/sql_union.cc:380
      #15 0x0000555fdf1363ee in mysql_derived_prepare (thd=0x7ff95800b390, lex=0x7ff9580e4278, derived=0x7ff9580e5c70) at /home/travis/src/sql/sql_derived.cc:804
      #16 0x0000555fdf134d85 in mysql_handle_derived (lex=0x7ff9580e4278, phases=35) at /home/travis/src/sql/sql_derived.cc:121
      #17 0x0000555fdf0f643f in open_normal_and_derived_tables (thd=0x7ff95800b390, tables=0x7ff9580e5c70, flags=512, dt_phases=35) at /home/travis/src/sql/sql_base.cc:4971
      #18 0x0000555fdf1a04a2 in mysql_test_select (stmt=0x7ff958057e90, tables=0x7ff9580e5c70) at /home/travis/src/sql/sql_prepare.cc:1520
      #19 0x0000555fdf1a1f24 in check_prepared_statement (stmt=0x7ff958057e90) at /home/travis/src/sql/sql_prepare.cc:2319
      #20 0x0000555fdf1a5bd6 in Prepared_statement::prepare (this=0x7ff958057e90, packet=0x7ff958017711 "SELECT * FROM `view_AA` INTO OUTFILE 'load_view_AA'  /* QNO 3798 CON_ID 19 */ ", packet_len=78) at /home/travis/src/sql/sql_prepare.cc:3963
      #21 0x0000555fdf1a2600 in mysqld_stmt_prepare (thd=0x7ff95800b390, packet=0x7ff958017711 "SELECT * FROM `view_AA` INTO OUTFILE 'load_view_AA'  /* QNO 3798 CON_ID 19 */ ", packet_length=78) at /home/travis/src/sql/sql_prepare.cc:2596
      #22 0x0000555fdf17764f in dispatch_command (command=COM_STMT_PREPARE, thd=0x7ff95800b390, packet=0x7ff958017711 "SELECT * FROM `view_AA` INTO OUTFILE 'load_view_AA'  /* QNO 3798 CON_ID 19 */ ", packet_length=78, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1799
      #23 0x0000555fdf1763ca in do_command (thd=0x7ff95800b390) at /home/travis/src/sql/sql_parse.cc:1387
      #24 0x0000555fdf2dbb71 in do_handle_one_connection (connect=0x555fe3822400) at /home/travis/src/sql/sql_connect.cc:1402
      #25 0x0000555fdf2db8fe in handle_one_connection (arg=0x555fe3822400) at /home/travis/src/sql/sql_connect.cc:1308
      #26 0x00007ff9ac85c184 in start_thread (arg=0x7ff9a82b3700) at pthread_create.c:312
      #27 0x00007ff9abd6903d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
      

      experimental 4feb78e17fbecf7fc7f2847b49b8c66b54879629

      perl /home/travis/rqg/runall-new.pl --duration=350 --threads=6 --seed=1523200963 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --views --redefine=conf/mariadb/versioning.yy --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/bulk_insert.yy --redefine=conf/mariadb/sequences.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=--default-storage-engine=MyISAM --grammar=conf/mariadb/optimizer.yy --ps-protocol --transformers=ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsExcept,ExecuteAsInsertSelect,ExecuteAsIntersect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsSPTwice --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.