Assertion `new_table != nullptr' failed.

[Roel Van de Paar]

This is a bug in 8.0.3 RC w/ Percona patches

2017-10-28T01:14:20.497825Z 0 [Note] /sda/PS161017-mysql-8.0.3-rc-linux-x86_64-debug/bin/mysqld: ready for connections. Version: '8.0.3-rc-debug-log' socket: '/sda/PS161017-mysql-8.0.3-rc-linux-x86_64-debug/socket.sock' port: 16149 MySQL Community Server (GPL)
mysqld: /git/mysql-8.0.3-percona-patches_dbg/sql/sql_insert.cc:3040: virtual bool Query_result_create::send_eof(): Assertion `new_table != nullptr' failed.
01:14:39 UTC - mysqld got signal 6 ;

(gdb) bt
#0 0x00007fdb8f0f99b1 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1 0x000000000369f5fa in my_write_core (sig=6) at /git/mysql-8.0.3-percona-patches_dbg/mysys/stacktrace.cc:291
#2 0x000000000286c62a in handle_fatal_signal (sig=6) at /git/mysql-8.0.3-percona-patches_dbg/sql/signal_handler.cc:234
#3 <signal handler called>
#4 0x00007fdb8d4111f7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
#5 0x00007fdb8d4128e8 in __GI_abort () at abort.c:90
#6 0x00007fdb8d40a266 in __assert_fail_base (fmt=0x7fdb8d55ce68 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n",
    assertion=assertion@entry=0x44b2265 "new_table != nullptr",
    file=file@entry=0x44b1780 "/git/mysql-8.0.3-percona-patches_dbg/sql/sql_insert.cc", line=line@entry=3040,
    function=function@entry=0x44b2f60 <Query_result_create::send_eof()::__PRETTY_FUNCTION__> "virtual bool Query_result_create::send_eof()") at assert.c:92
#7 0x00007fdb8d40a312 in __GI___assert_fail (assertion=0x44b2265 "new_table != nullptr",
    file=0x44b1780 "/git/mysql-8.0.3-percona-patches_dbg/sql/sql_insert.cc", line=3040,
    function=0x44b2f60 <Query_result_create::send_eof()::__PRETTY_FUNCTION__> "virtual bool Query_result_create::send_eof()")
    at assert.c:101
#8 0x0000000002c1807e in Query_result_create::send_eof (this=0x7fdb475d95a8)
    at /git/mysql-8.0.3-percona-patches_dbg/sql/sql_insert.cc:3040
#9 0x0000000002465470 in do_select (join=0x7fdb471569a0) at /git/mysql-8.0.3-percona-patches_dbg/sql/sql_executor.cc:1348
#10 0x0000000002462647 in JOIN::exec (this=0x7fdb471569a0) at /git/mysql-8.0.3-percona-patches_dbg/sql/sql_executor.cc:285
#11 0x0000000002512c4a in handle_query (thd=0x7fdb47419000, lex=0x7fdb4741b1e8, result=0x7fdb475d95a8, added_options=268435456,
    removed_options=0) at /git/mysql-8.0.3-percona-patches_dbg/sql/sql_select.cc:203
#12 0x0000000002c04dcd in Sql_cmd_create_table::execute (this=0x7fdb474ba868, thd=0x7fdb47419000)
    at /git/mysql-8.0.3-percona-patches_dbg/sql/sql_cmd_ddl_table.cc:331
#13 0x00000000024bc45d in mysql_execute_command (thd=0x7fdb47419000, first_level=true)
    at /git/mysql-8.0.3-percona-patches_dbg/sql/sql_parse.cc:3441
#14 0x00000000024c1b3b in mysql_parse (thd=0x7fdb47419000, parser_state=0x7fdb8f69f2f0)
    at /git/mysql-8.0.3-percona-patches_dbg/sql/sql_parse.cc:5414
#15 0x00000000024b7ff7 in dispatch_command (thd=0x7fdb47419000, com_data=0x7fdb8f69fb80, command=COM_QUERY)
    at /git/mysql-8.0.3-percona-patches_dbg/sql/sql_parse.cc:1708
#16 0x00000000024b6b05 in do_command (thd=0x7fdb47419000) at /git/mysql-8.0.3-percona-patches_dbg/sql/sql_parse.cc:1291
#17 0x000000000285c00a in handle_connection (arg=0x7fdb7b586900)
    at /git/mysql-8.0.3-percona-patches_dbg/sql/conn_handler/connection_handler_per_thread.cc:328
#18 0x00000000036ed71f in pfs_spawn_thread (arg=0x7fdb7b78b620) at /git/mysql-8.0.3-percona-patches_dbg/storage/perfschema/pfs.cc:2985
#19 0x00007fdb8f0f4e25 in start_thread (arg=0x7fdb8f6a0700) at pthread_create.c:308
#20 0x00007fdb8d4d434d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113

[Roel Van de Paar (roel11)]

See https://bugs.mysql.com/bug.php?id=88271

[Roel Van de Paar (roel11)]

After some research, I found that the crash/non-crash difference is in using --sql_mode= for mysqld. Thus, this is a duplicate of MS 88271

[Shahriyar Rzayev (rzayev-sehriyar)]

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