Description:
2017-10-27T23:39:30.297610Z 0 [Note] /sda/MS201017-mysql-8.0.3-rc-linux-x86_64-debug/bin/mysqld: ready for connections. Version: '8.0.3-rc-debug-log' socket: '/sda/MS201017-mysql-8.0.3-rc-linux-x86_64-debug/socket.sock' port: 16654 MySQL Community Server (GPL)
mysqld: /git/mysql-server_dbg/sql/field.cc:1633: type_conversion_status Field::check_constraints(int): Assertion `type() != MYSQL_TYPE_TIMESTAMP' failed.
23:39:43 UTC - mysqld got signal 6 ;
Core was generated by `/sda/MS201017-mysql-8.0.3-rc-linux-x86_64-debug/bin/mysqld --no-defaults --sql_'.
Program terminated with signal 6, Aborted.
#0 0x00007fd521c1e9b1 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
61 val = INTERNAL_SYSCALL (tgkill, err, 3, THREAD_GETMEM (THREAD_SELF, pid),
(gdb) bt
#0 0x00007fd521c1e9b1 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1 0x000000000369e428 in my_write_core (sig=6) at /git/mysql-server_dbg/mysys/stacktrace.cc:291
#2 0x000000000286b8f6 in handle_fatal_signal (sig=6) at /git/mysql-server_dbg/sql/signal_handler.cc:234
#3 <signal handler called>
#4 0x00007fd51ff361f7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
#5 0x00007fd51ff378e8 in __GI_abort () at abort.c:90
#6 0x00007fd51ff2f266 in __assert_fail_base (fmt=0x7fd520081e68 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n",
assertion=assertion@entry=0x44259f8 "type() != MYSQL_TYPE_TIMESTAMP",
file=file@entry=0x44258f0 "/git/mysql-server_dbg/sql/field.cc", line=line@entry=1633,
function=function@entry=0x4427d00 <Field::check_constraints(int)::__PRETTY_FUNCTION__> "type_conversion_status Field::check_constraints(int)") at assert.c:92
#7 0x00007fd51ff2f312 in __GI___assert_fail (assertion=0x44259f8 "type() != MYSQL_TYPE_TIMESTAMP",
file=0x44258f0 "/git/mysql-server_dbg/sql/field.cc", line=1633,
function=0x4427d00 <Field::check_constraints(int)::__PRETTY_FUNCTION__> "type_conversion_status Field::check_constraints(int)")
at assert.c:101
#8 0x0000000002986707 in Field::check_constraints (this=0x7fd4d94d9c58, mysql_errno=1048) at /git/mysql-server_dbg/sql/field.cc:1633
#9 0x000000000242b2e8 in check_inserting_record (thd=0x7fd4d9419000, ptr=0x7fd4d94d9c50)
at /git/mysql-server_dbg/sql/sql_base.cc:10112
#10 0x000000000242bbc8 in fill_record_n_invoke_before_triggers (thd=0x7fd4d9419000, ptr=0x7fd4d94d9c48, values=...,
table=0x7fd4d9465c20, event=TRG_EVENT_INSERT, num_fields=1) at /git/mysql-server_dbg/sql/sql_base.cc:10451
#11 0x0000000002c10b77 in Sql_cmd_insert_values::execute_inner (this=0x7fd4d94300f8, thd=0x7fd4d9419000)
at /git/mysql-server_dbg/sql/sql_insert.cc:645
#12 0x0000000002512627 in Sql_cmd_dml::execute (this=0x7fd4d94300f8, thd=0x7fd4d9419000) at /git/mysql-server_dbg/sql/sql_select.cc:605
#13 0x00000000024bad4d in mysql_execute_command (thd=0x7fd4d9419000, first_level=true) at /git/mysql-server_dbg/sql/sql_parse.cc:3441
#14 0x00000000024c042b in mysql_parse (thd=0x7fd4d9419000, parser_state=0x7fd5221c42f0) at /git/mysql-server_dbg/sql/sql_parse.cc:5414
#15 0x00000000024b68e7 in dispatch_command (thd=0x7fd4d9419000, com_data=0x7fd5221c4b80, command=COM_QUERY)
at /git/mysql-server_dbg/sql/sql_parse.cc:1708
#16 0x00000000024b53f5 in do_command (thd=0x7fd4d9419000) at /git/mysql-server_dbg/sql/sql_parse.cc:1291
#17 0x000000000285b2d6 in handle_connection (arg=0x7fd50e2eb3c0)
at /git/mysql-server_dbg/sql/conn_handler/connection_handler_per_thread.cc:328
#18 0x00000000036ec54d in pfs_spawn_thread (arg=0x7fd50e392620) at /git/mysql-server_dbg/storage/perfschema/pfs.cc:2985
#19 0x00007fd521c19e25 in start_thread (arg=0x7fd5221c5700) at pthread_create.c:308
#20 0x00007fd51fff934d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113
How to repeat:
# mysqld options required for replay: --sql_mode=
CREATE DATABASE test;
USE test;
CREATE TABLE t1(pk TIMESTAMP DEFAULT '1971-01-01 00:00:00.0',PRIMARY KEY (pk)) ENGINE=none DEFAULT CHARSET=latin1;
CREATE TRIGGER bi BEFORE INSERT ON t1 FOR EACH ROW SET @a=1;
INSERT INTO t1 VALUES(NULL);
Description: 2017-10-27T23:39:30.297610Z 0 [Note] /sda/MS201017-mysql-8.0.3-rc-linux-x86_64-debug/bin/mysqld: ready for connections. Version: '8.0.3-rc-debug-log' socket: '/sda/MS201017-mysql-8.0.3-rc-linux-x86_64-debug/socket.sock' port: 16654 MySQL Community Server (GPL) mysqld: /git/mysql-server_dbg/sql/field.cc:1633: type_conversion_status Field::check_constraints(int): Assertion `type() != MYSQL_TYPE_TIMESTAMP' failed. 23:39:43 UTC - mysqld got signal 6 ; Core was generated by `/sda/MS201017-mysql-8.0.3-rc-linux-x86_64-debug/bin/mysqld --no-defaults --sql_'. Program terminated with signal 6, Aborted. #0 0x00007fd521c1e9b1 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61 61 val = INTERNAL_SYSCALL (tgkill, err, 3, THREAD_GETMEM (THREAD_SELF, pid), (gdb) bt #0 0x00007fd521c1e9b1 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61 #1 0x000000000369e428 in my_write_core (sig=6) at /git/mysql-server_dbg/mysys/stacktrace.cc:291 #2 0x000000000286b8f6 in handle_fatal_signal (sig=6) at /git/mysql-server_dbg/sql/signal_handler.cc:234 #3 <signal handler called> #4 0x00007fd51ff361f7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56 #5 0x00007fd51ff378e8 in __GI_abort () at abort.c:90 #6 0x00007fd51ff2f266 in __assert_fail_base (fmt=0x7fd520081e68 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x44259f8 "type() != MYSQL_TYPE_TIMESTAMP", file=file@entry=0x44258f0 "/git/mysql-server_dbg/sql/field.cc", line=line@entry=1633, function=function@entry=0x4427d00 <Field::check_constraints(int)::__PRETTY_FUNCTION__> "type_conversion_status Field::check_constraints(int)") at assert.c:92 #7 0x00007fd51ff2f312 in __GI___assert_fail (assertion=0x44259f8 "type() != MYSQL_TYPE_TIMESTAMP", file=0x44258f0 "/git/mysql-server_dbg/sql/field.cc", line=1633, function=0x4427d00 <Field::check_constraints(int)::__PRETTY_FUNCTION__> "type_conversion_status Field::check_constraints(int)") at assert.c:101 #8 0x0000000002986707 in Field::check_constraints (this=0x7fd4d94d9c58, mysql_errno=1048) at /git/mysql-server_dbg/sql/field.cc:1633 #9 0x000000000242b2e8 in check_inserting_record (thd=0x7fd4d9419000, ptr=0x7fd4d94d9c50) at /git/mysql-server_dbg/sql/sql_base.cc:10112 #10 0x000000000242bbc8 in fill_record_n_invoke_before_triggers (thd=0x7fd4d9419000, ptr=0x7fd4d94d9c48, values=..., table=0x7fd4d9465c20, event=TRG_EVENT_INSERT, num_fields=1) at /git/mysql-server_dbg/sql/sql_base.cc:10451 #11 0x0000000002c10b77 in Sql_cmd_insert_values::execute_inner (this=0x7fd4d94300f8, thd=0x7fd4d9419000) at /git/mysql-server_dbg/sql/sql_insert.cc:645 #12 0x0000000002512627 in Sql_cmd_dml::execute (this=0x7fd4d94300f8, thd=0x7fd4d9419000) at /git/mysql-server_dbg/sql/sql_select.cc:605 #13 0x00000000024bad4d in mysql_execute_command (thd=0x7fd4d9419000, first_level=true) at /git/mysql-server_dbg/sql/sql_parse.cc:3441 #14 0x00000000024c042b in mysql_parse (thd=0x7fd4d9419000, parser_state=0x7fd5221c42f0) at /git/mysql-server_dbg/sql/sql_parse.cc:5414 #15 0x00000000024b68e7 in dispatch_command (thd=0x7fd4d9419000, com_data=0x7fd5221c4b80, command=COM_QUERY) at /git/mysql-server_dbg/sql/sql_parse.cc:1708 #16 0x00000000024b53f5 in do_command (thd=0x7fd4d9419000) at /git/mysql-server_dbg/sql/sql_parse.cc:1291 #17 0x000000000285b2d6 in handle_connection (arg=0x7fd50e2eb3c0) at /git/mysql-server_dbg/sql/conn_handler/connection_handler_per_thread.cc:328 #18 0x00000000036ec54d in pfs_spawn_thread (arg=0x7fd50e392620) at /git/mysql-server_dbg/storage/perfschema/pfs.cc:2985 #19 0x00007fd521c19e25 in start_thread (arg=0x7fd5221c5700) at pthread_create.c:308 #20 0x00007fd51fff934d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113 How to repeat: # mysqld options required for replay: --sql_mode= CREATE DATABASE test; USE test; CREATE TABLE t1(pk TIMESTAMP DEFAULT '1971-01-01 00:00:00.0',PRIMARY KEY (pk)) ENGINE=none DEFAULT CHARSET=latin1; CREATE TRIGGER bi BEFORE INSERT ON t1 FOR EACH ROW SET @a=1; INSERT INTO t1 VALUES(NULL);