MDEV-5750 RQG test temporal_functions.yy crashes on sql_time.cc:1114 at time_to_daytime_interval(MYSQL_TIME*): Assertion `ltime->year == 0' about mariadb-5.5 HOT 6 CLOSED

Here is the stack trace from this crash:

140226 22:39:40 [ERROR] mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.

Thread pointer: 0x0x7fe26d928060
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x7fe26e2d0e28 thread_stack 0x48000
mysys/stacktrace.c:246(my_print_stacktrace)[0xb879c8]
sql/signal_handler.cc:155(handle_fatal_signal)[0x6ecb94]
/lib/x86_64-linux-gnu/libpthread.so.0(+0xfbb0)[0x7fe288d1bbb0]
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0x37)[0x7fe288372f77]
/lib/x86_64-linux-gnu/libc.so.6(abort+0x148)[0x7fe2883765e8]
/lib/x86_64-linux-gnu/libc.so.6(+0x2fd43)[0x7fe28836bd43]
/lib/x86_64-linux-gnu/libc.so.6(+0x2fdf2)[0x7fe28836bdf2]
sql/sql_time.cc:1115(time_to_daytime_interval(st_mysql_time_))[0x640a8c]
sql/item_timefunc.cc:2149(Item_extract::val_int())[0x78deff]
sql/item.cc:1304(Item::get_date(st_mysql_time_, unsigned long long))[0x700e37]
sql/item_func.h:162(Item_func::get_arg0_time(st_mysql_time_))[0x78b007]
sql/item_cmpfunc.cc:906(get_datetime_value(THD_, Item_, Item__, Item_, bool_))[0x71f356]
sql/item_cmpfunc.cc:961(Arg_comparator::compare_datetime())[0x71fdd0]
sql/item_cmpfunc.cc:1908(Item_func_gt::val_int())[0x71af4f]
sql/item.cc:215(Item::val_bool())[0x6ff95d]
sql/item_cmpfunc.cc:4695(Item_cond_and::val_int())[0x718f01]
sql/item.cc:215(Item::val_bool())[0x6ff95d]
sql/item_cmpfunc.cc:4713(Item_cond_or::val_int())[0x718e73]
sql/sql_class.h:2657(THD::is_error() const)[0x5bece4]
sql/sql_select.cc:16799(sub_select(JOIN_, st_join_table_, bool))[0x5c864b]
sql/sql_select.cc:16461(do_select)[0x5d8835]
sql/sql_select.cc:2859(JOIN::exec())[0x5ed7b4]
sql/sql_select.cc:3081(mysql_select(THD_, Item, TABLE_LIST, unsigned int, List&, Item_, unsigned int, st_order_, st_order_, Item_, st_order_, unsigned long long, select_result_, st_select_lex_unit_, st_select_lex_))[0x5e7339]
sql/sql_select.cc:319(handle_select(THD_, LEX_, select_result_, unsigned long))[0x5ede0a]
sql/sql_parse.cc:4702(execute_sqlcom_select)[0x59007b]
sql/sql_parse.cc:2235(mysql_execute_command(THD_))[0x595eee]
sql/sql_parse.cc:5813(mysql_parse(THD_, char_, unsigned int, Parser_state_))[0x59d7c5]
sql/sql_parse.cc:1072(dispatch_command(enum_server_command, THD_, char_, unsigned int))[0x59e356]
sql/sql_parse.cc:797(do_command(THD_))[0x59fbaa]
sql/sql_connect.cc:1266(do_handle_one_connection(THD*))[0x660fc6]
sql/sql_connect.cc:1183(handle_one_connection)[0x6610b8]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x7f6e)[0x7fe288d13f6e]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7fe2884369cd]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x7fe24adff078): SELECT GREATEST( '0000-00-00 00:00:00' , '0000-00-00 00:00:00' ) AS c1 , col_int_key AS c2 , col_date_key AS c3 FROM C WHERE col_varchar_nokey >= DATE( '0000-00-00' ) AND col_datetime_nokey < col_int_key OR col_datetime_key > CAST( EXTRACT( DAY_MINUTE FROM GREATEST( col_time_nokey , FROM_DAYS( 8 ) , UTC_DATE() ) ) AS TIME ) AND col_int_key < UTC_DATE() ORDER BY 1

from mariadb-5.5.

Here is the show table status output confirming the table 'C' is indeed a TokuDB table:

MariaDB [test]> show table status;
+-------+--------+---------+-------------+------+----------------+-------------+---------------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------+
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment |
+-------+--------+---------+-------------+------+----------------+-------------+---------------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------+
| A | TokuDB | 10 | tokudb_zlib | 1 | 0 | 0 | 9223372036854775807 | 0 | 73728 | 1 | 2014-02-26 14:51:49 | 2014-02-26 14:51:49 | NULL | latin1_swedish_ci | NULL | | |
| AA | TokuDB | 10 | tokudb_zlib | 1 | 0 | 0 | 9223372036854775807 | 0 | 73728 | 10 | 2014-02-26 14:51:49 | 2014-02-26 14:51:49 | NULL | latin1_swedish_ci | NULL | | |
| B | TokuDB | 10 | tokudb_zlib | 1 | 46 | 46 | 9223372036854775807 | 52 | 73728 | 2 | 2014-02-26 14:51:49 | 2014-02-26 14:51:50 | NULL | latin1_swedish_ci | NULL | | |
| BB | TokuDB | 10 | tokudb_zlib | 1 | 46 | 46 | 9223372036854775807 | 55 | 73728 | 11 | 2014-02-26 14:51:49 | 2014-02-26 14:51:49 | NULL | latin1_swedish_ci | NULL | | |
| C | TokuDB | 10 | tokudb_zlib | 20 | 45 | 914 | 9223372036854775807 | 1085 | 73728 | 21 | 2014-02-26 14:51:49 | 2014-02-2

from mariadb-5.5.

I will attempt to reproduce using InnoDB.

from mariadb-5.5.

Core file is located at:

tokuspare-1:/mnt/ssd/mysql/vardir1/master-data/core

from mariadb-5.5.

Refiled as https://mariadb.atlassian.net/browse/MDEV-5750. Test case is in the JIRA report.

from mariadb-5.5.

Moved to Jira as https://tokutek.atlassian.net/browse/DB-516

from mariadb-5.5.