Bug #80094 Assertion `type() != MYSQL_TYPE_TIMESTAMP' failed in sql/field.cc:1615
Description:
Version: '5.7.10-debug' socket: '/dev/shm/1453361979/socket.sock' port: 39846 MySQL Community Server (GPL)
mysqld: /sda/mysql-server_dbg/sql/field.cc:1615: type_conversion_status Field::check_constraints(int): Assertion `type() != MYSQL_TYPE_TIMESTAMP' failed.
09:36:10 UTC - mysqld got signal 6 ;
#0 0x00007f20d753d741 in pthread_kill () from /lib64/libpthread.so.0
#1 0x00000000017ef51c in my_write_core (sig=6) at /sda/mysql-server_dbg/mysys/stacktrace.c:247
#2 0x0000000000e583e4 in handle_fatal_signal (sig=6) at /sda/mysql-server_dbg/sql/signal_handler.cc:220
#3 <signal handler called>
#4 0x00007f20d56ca5f7 in raise () from /lib64/libc.so.6
#5 0x00007f20d56cbce8 in abort () from /lib64/libc.so.6
#6 0x00007f20d56c3566 in __assert_fail_base () from /lib64/libc.so.6
#7 0x00007f20d56c3612 in __assert_fail () from /lib64/libc.so.6
#8 0x0000000000e95b21 in Field::check_constraints (this=0x7f209a4aa340, mysql_errno=1048) at /sda/mysql-server_dbg/sql/field.cc:1615
#9 0x000000000146ba7b in check_record (thd=0x7f209a419000, ptr=0x7f209a4aa338) at /sda/mysql-server_dbg/sql/sql_base.cc:9246
#10 0x000000000146c23a in fill_record_n_invoke_before_triggers (thd=0x7f209a419000, ptr=0x7f209a4aa330, values=..., table=0x7f209a45c420, event=TRG_EVENT_INSERT, num_fields=1) at /sda/mysql-server_dbg/sql/sql_base.cc:9543
#11 0x00000000016e2200 in Sql_cmd_insert::mysql_insert (this=0x7f209a42c3d8, thd=0x7f209a419000, table_list=0x7f209a42be48) at /sda/mysql-server_dbg/sql/sql_insert.cc:762
#12 0x00000000016e88f6 in Sql_cmd_insert::execute (this=0x7f209a42c3d8, thd=0x7f209a419000) at /sda/mysql-server_dbg/sql/sql_insert.cc:3082
#13 0x00000000014e5b7f in mysql_execute_command (thd=0x7f209a419000, first_level=true) at /sda/mysql-server_dbg/sql/sql_parse.cc:3510
#14 0x00000000014eb3dd in mysql_parse (thd=0x7f209a419000, parser_state=0x7f20d7af3560) at /sda/mysql-server_dbg/sql/sql_parse.cc:5508
#15 0x00000000014e0d17 in dispatch_command (thd=0x7f209a419000, com_data=0x7f20d7af3cb0, command=COM_QUERY) at /sda/mysql-server_dbg/sql/sql_parse.cc:1425
#16 0x00000000014dfbe1 in do_command (thd=0x7f209a419000) at /sda/mysql-server_dbg/sql/sql_parse.cc:993
#17 0x000000000160adc7 in handle_connection (arg=0x7f20c4bfce00) at /sda/mysql-server_dbg/sql/conn_handler/connection_handler_per_thread.cc:301
#18 0x000000000188e1b8 in pfs_spawn_thread (arg=0x7f20b4fef120) at /sda/mysql-server_dbg/storage/perfschema/pfs.cc:2192
#19 0x00007f20d7538dc5 in start_thread () from /lib64/libpthread.so.0
#20 0x00007f20d578b21d in clone () from /lib64/libc.so.6
How to repeat:
Testcase
DROP DATABASE test;CREATE DATABASE test;USE test;
set session explicit_defaults_for_timestamp=true;
CREATE TABLE t1(a TIMESTAMP NOT NULL);
CREATE TRIGGER t1_au AFTER UPDATE ON t1 FOR EACH ROW SET @x=5/0;
create temporary TABLE t1(f int);
DROP TABLE t1;
insert INTO t1 values(null),(null),(null),(null);
The attached tarball (1453361979_bug_bundle.tar.gz) gives the testcase as an exact match of our system, including some handy utilities
$ vi 1453361979_mybase # STEP1: Update the base path in this file (usually the only change required!). If you use a non-binary distribution, please update SOURCE_DIR location also
$ ./1453361979_init # STEP2: Initializes the data dir
$ ./1453361979_start # STEP3: Starts mysqld
$ ./1453361979_cl # STEP4: To check mysqld is up
$ ./1453361979_run_pquery # STEP5: Run the testcase with the pquery binary
$ ./1453361979_run # OPTIONAL: Run the testcase with the mysql CLI (may not reproduce the issue, as the pquery binary was used for the original testcase reduction)
$ vi /dev/shm/1453361979/error.log.out # STEP6: Verify the error log
$ ./1453361979_gdb # OPTIONAL: Brings you to a gdb prompt with gdb attached to the used mysqld and attached to the generated core
$ ./1453361979_parse_core # STEP7: Creates 1453361979_STD.gdb and 1453361979_FULL.gdb; standard and full variables gdb stack traces
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.055 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.