sql-common/my_time.c:1819: TIME_to_longlong_datetime_packed: Assertion `!check_datetime_range(ltime)' failed. | abort (sig=6) in TIME_to_longlong_datetime_packed

Bug #1385043 reported by Roel Van de Paar
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL Server
Unknown
Unknown
Percona Server moved to https://jira.percona.com/projects/PS
Status tracked in 5.7
5.1
Won't Fix
Undecided
Unassigned
5.5
New
Undecided
Unassigned
5.6
Triaged
Medium
Unassigned
5.7
Fix Released
Medium
Unassigned

Bug Description

2014-10-20 15:10:17 11543 [Warning] Did not write failed 'revoke grant option on test.* from mysqltest_3@localhost' into binary log while granting/revoking privileges in databases.
2014-10-20 15:10:17 11543 [Note] InnoDB: Dirtying page:0 of space:0
mysqld: /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql-common/my_time.c:1819: TIME_to_longlong_datetime_packed: Assertion `!check_datetime_range(ltime)' failed.
04:10:17 UTC - mysqld got signal 6 ;
[...]
Query (7fd5c8004e90): SELECT ADDTIME(CAST(a AS DATETIME(0)), 100000) FROM t2 ORDER BY a
Connection ID (thread ID): 4

Single threaded run, single mysqld involved

Thread 1 (Thread 0x7fd61153e700 (LWP 11681)):
+bt
#0 0x00007fd62a8eb771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000ab7586 in my_write_core (sig=6) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/mysys/stacktrace.c:422
#2 0x000000000072f9ff in handle_fatal_signal (sig=6) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/signal_handler.cc:236
#3 <signal handler called>
#4 0x00007fd6294ef5c9 in raise () from /lib64/libc.so.6
#5 0x00007fd6294f0cd8 in abort () from /lib64/libc.so.6
#6 0x00007fd6294e8536 in __assert_fail_base () from /lib64/libc.so.6
#7 0x00007fd6294e85e2 in __assert_fail () from /lib64/libc.so.6
#8 0x00000000008d4e7d in TIME_to_longlong_datetime_packed (ltime=0x7fd61153b480) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql-common/my_time.c:1819
#9 0x00000000009201d7 in Field_datetimef::store_internal (this=0x7fd5c811d428, ltime=0x7fd61153b480, warnings=0x7fd61153b22c) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/field.cc:6509
#10 0x000000000091c60c in Field_temporal_with_date::store_internal_with_round (this=0x7fd5c811d428, ltime=0x7fd61153b480, warnings=0x7fd61153b22c) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/field.cc:5171
#11 0x000000000091c32e in Field_temporal_with_date::store_time (this=0x7fd5c811d428, ltime=0x7fd61153b480, dec_arg=0 '\000') at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/field.cc:5113
#12 0x0000000000655e5a in Item::save_date_in_field (this=0x7fd5c80052e0, field=0x7fd5c811d428) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/item.cc:515
#13 0x00000000006f8b67 in Item_temporal_hybrid_func::save_in_field (this=0x7fd5c80052e0, field=0x7fd5c811d428, no_conversions=true) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/item_timefunc.cc:839
#14 0x0000000000674ebb in Item_result_field::save_in_result_field (this=0x7fd5c80052e0, no_conversions=true) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/item.h:3112
#15 0x00000000007b1b3a in copy_funcs (func_ptr=0x7fd5c81185d8, thd=0x3642b50) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_executor.cc:553
#16 0x00000000007b7156 in end_write (join=0x7fd5c8005c50, join_tab=0x7fd5c811b6b8, end_of_records=false) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_executor.cc:2995
#17 0x00000000007baa24 in QEP_tmp_table::put_record (this=0x7fd5c8006cf8, end_of_records=false) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_executor.cc:4307
#18 0x00000000007bb59b in QEP_tmp_table::put_record (this=0x7fd5c8006cf8) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_executor.h:241
#19 0x00000000007b2eab in sub_select_op (join=0x7fd5c8005c50, join_tab=0x7fd5c811b6b8, end_of_records=false) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_executor.cc:1067
#20 0x00000000007b3bbe in evaluate_join_record (join=0x7fd5c8005c50, join_tab=0x7fd5c811b3b8) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_executor.cc:1601
#21 0x00000000007b31a0 in sub_select (join=0x7fd5c8005c50, join_tab=0x7fd5c811b3b8, end_of_records=false) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_executor.cc:1276
#22 0x00000000007b2a6d in do_select (join=0x7fd5c8005c50) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_executor.cc:933
#23 0x00000000007b09c9 in JOIN::exec (this=0x7fd5c8005c50) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_executor.cc:194
#24 0x000000000081401b in mysql_execute_select (thd=0x3642b50, select_lex=0x36457b0, free_join=true) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_select.cc:1100
#25 0x0000000000814317 in mysql_select (thd=0x3642b50, tables=0x7fd5c80054b0, wild_num=0, fields=..., conds=0x0, order=0x3645978, group=0x36458b0, having=0x0, select_options=71003669248, result=0x7fd5c8005c28, unit=0x3645168, select_lex=0x36457b0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_select.cc:1221
#26 0x00000000008123a6 in handle_select (thd=0x3642b50, result=0x7fd5c8005c28, setup_tables_done_option=0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_select.cc:110
#27 0x00000000007ea892 in execute_sqlcom_select (thd=0x3642b50, all_tables=0x7fd5c80054b0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:5597
#28 0x00000000007e2de9 in mysql_execute_command (thd=0x3642b50) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:2958
#29 0x00000000007ed193 in mysql_parse (thd=0x3642b50, rawbuf=0x7fd5c8004e90 "SELECT ADDTIME(CAST(a AS DATETIME(0)), 100000) FROM t2 ORDER BY a", length=65, parser_state=0x7fd61153cd50) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:6773
#30 0x00000000007df5fc in dispatch_command (command=COM_QUERY, thd=0x3642b50, packet=0x3e3d921 "", packet_length=66) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:1432
#31 0x00000000007de528 in do_command (thd=0x3642b50) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:1049
#32 0x00000000008c2c30 in threadpool_process_request (thd=0x3642b50) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/threadpool_common.cc:311
#33 0x00000000008c5572 in handle_event (connection=0x3ccf1c0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/threadpool_unix.cc:1553
#34 0x00000000008c57a2 in worker_main (param=0x1898400 <all_groups+2048>) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/threadpool_unix.cc:1606
#35 0x0000000000dc5bac in pfs_spawn_thread (arg=0x3df6110) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/perfschema/pfs.cc:1860
#36 0x00007fd62a8e6df3 in start_thread () from /lib64/libpthread.so.0
#37 0x00007fd6295b001d in clone () from /lib64/libc.so.6

Tags: qa
Revision history for this message
Roel Van de Paar (roel11) wrote :
Revision history for this message
Roel Van de Paar (roel11) wrote :

Upstream. Bug #74599 Assertion `!check_datetime_range(ltime)' failed TIME_to_longlong_datetime_packed

Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

What is the testcase?

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1565

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.