Bug #88273 | Assertion `has_error == thd->get_stmt_da()->is_error()' failed. | ||
---|---|---|---|
Submitted: | 28 Oct 2017 4:14 | Modified: | 1 Mar 2018 17:00 |
Reporter: | Roel Van de Paar | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S6 (Debug Builds) |
Version: | 8.0.3 RC | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | debug |
[28 Oct 2017 4:14]
Roel Van de Paar
[28 Oct 2017 18:21]
MySQL Verification Team
Thank you for the bug report. Verified as described.
[11 Jan 2018 12:46]
Sivert Sørumgård
Posted by developer: A warning is set in Field_double::val_int() and promoted to error in strict mode. On 5.7, a subsequent check for THD::is_error() in sql_insert.cc caught this correctly. On 8.0, this code is modified. Thus, a fix is to check for 'THD::is_error()' after calling 'table->next_number_field->val_int()'.
[1 Mar 2018 17:00]
Paul DuBois
Posted by developer: Fixed in 8.0.5. In strict SQL mode, assignment of invalid values to AUTO_INCREMENT columns could be handled incorrectly, resulting in an assertion being raised.
[6 Mar 2019 14:20]
Hrvoje Matijakovic
I'm still able to reproduce this on 8.0.15 with a bit different sql: # mysqld options required for replay: --sql_mode= CREATE DATABASE test; USE test; create table t5(cint int,c1 date)engine=''partition by list(cint) subpartition by hash(year(c1)-1990) subpartitions 2 (partition p0 values in (1,2,3,4,5,6,7,8,9,10),partition p1 values in (11,12,13,14,15,16,17,18,19,20),partition p2 values in (21,22,23,24,25,26,27,28,29,30),partition p3 values in (31,32,33,34,35,36,37,38,39,40),partition p4 values in (41,42,43,44,45,46,47,48,49,50),partition p5 values in (51,52,53,54,55,56,57,58,59,60)); INSERT INTO t5 VALUES(2,'master only'); gdb: (gdb) bt +bt #0 0x00007f97c08549d1 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:59 #1 0x0000000004406705 in my_write_core (sig=6) at /sdc/MS-8.0.15_dbg/mysys/stacktrace.cc:278 #2 0x00000000031b298c in handle_fatal_signal (sig=6) at /sdc/MS-8.0.15_dbg/sql/signal_handler.cc:249 #3 <signal handler called> #4 0x00007f97be958207 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:55 #5 0x00007f97be9598f8 in __GI_abort () at abort.c:90 #6 0x00007f97be951026 in __assert_fail_base (fmt=0x7f97beaabea0 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x5646e18 "has_error == thd->get_stmt_da()->is_error()", file=file@entry=0x5646c38 "/sdc/MS-8.0.15_dbg/sql/sql_insert.cc", line=line@entry=619, function=function@entry=0x5647aa0 <Sql_cmd_insert_values::execute_inner(THD*)::__PRETTY_FUNCTION__> "virtual bool Sql_cmd_insert_values::execute_inner(THD*)") at assert.c:92 #7 0x00007f97be9510d2 in __GI___assert_fail (assertion=0x5646e18 "has_error == thd->get_stmt_da()->is_error()", file=0x5646c38 "/sdc/MS-8.0.15_dbg/sql/sql_insert.cc", line=619, function=0x5647aa0 <Sql_cmd_insert_values::execute_inner(THD*)::__PRETTY_FUNCTION__> "virtual bool Sql_cmd_insert_values::execute_inner(THD*)") at assert.c:101 #8 0x000000000358845d in Sql_cmd_insert_values::execute_inner (this=0x7f976946a288, thd=0x7f9769419000) at /sdc/MS-8.0.15_dbg/sql/sql_insert.cc:619 #9 0x000000000306a73c in Sql_cmd_dml::execute (this=0x7f976946a288, thd=0x7f9769419000) at /sdc/MS-8.0.15_dbg/sql/sql_select.cc:593 #10 0x00000000030083bb in mysql_execute_command (thd=0x7f9769419000, first_level=true) at /sdc/MS-8.0.15_dbg/sql/sql_parse.cc:3375 #11 0x000000000300da08 in mysql_parse (thd=0x7f9769419000, parser_state=0x7f97bd1f9b20, force_primary_storage_engine=false) at /sdc/MS-8.0.15_dbg/sql/sql_parse.cc:5105 #12 0x0000000003003aec in dispatch_command (thd=0x7f9769419000, com_data=0x7f97bd1fab90, command=COM_QUERY) at /sdc/MS-8.0.15_dbg/sql/sql_parse.cc:1715 #13 0x00000000030020b0 in do_command (thd=0x7f9769419000) at /sdc/MS-8.0.15_dbg/sql/sql_parse.cc:1263 #14 0x000000000319ea92 in handle_connection (arg=0x7f97a96be240) at /sdc/MS-8.0.15_dbg/sql/conn_handler/connection_handler_per_thread.cc:305 #15 0x0000000004af9c8a in pfs_spawn_thread (arg=0x7f97bc81b420) at /sdc/MS-8.0.15_dbg/storage/perfschema/pfs.cc:2836 #16 0x00007f97c084fdd5 in start_thread (arg=0x7f97bd1fb700) at pthread_create.c:307 #17 0x00007f97bea1fead in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111 Can't repeat on 5.7.25