Assertion `new_table != nullptr' failed.

Bug #1728182 reported by Roel Van de Paar on 2017-10-28
8
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.5
Invalid
Undecided
Unassigned
5.6
Invalid
Undecided
Unassigned
5.7
Invalid
Undecided
Unassigned
8.0
Triaged
High
Unassigned

Bug Description

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) wrote :
description: updated
Changed in percona-server:
status: New → Triaged
importance: Undecided → High
assignee: nobody → Laurynas Biveinis (laurynas-biveinis)
tags: added: qa
Roel Van de Paar (roel11) wrote :

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

Changed in percona-server:
assignee: Laurynas Biveinis (laurynas-biveinis) → nobody
tags: added: upstream

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

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

Other bug subscribers

Remote bug watches

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