MySQL Bugs: #90163: crash on lots of inserts

Bug #90163	crash on lots of inserts
Submitted:	21 Mar 2018 14:56	Modified:	22 Apr 2018 21:53
Reporter:	Patrick Oberdorf	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.7.21	OS:	Ubuntu (16.04)
Assigned to:	MySQL Verification Team	CPU Architecture:	x86
Tags:	crash

Description:
MySQL Server crashes randomly. Happens after a lot of INSERTS and UPDATES.

How to repeat:
I don't know if it is reproducible, because it happens randomly.

crash log

Attachment: mysql-stacktrace.txt (text/plain), 2.44 KiB.

key_buffer_size=16777216
read_buffer_size=131072
max_used_connections=5
max_threads=151
thread_count=1
connection_count=1
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 76385 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x7f40a407fd80
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 7f4100085e70 thread_stack 0x40000
/usr/sbin/mysqld(my_print_stacktrace+0x3b)[0xe8f29b]
/usr/sbin/mysqld(handle_fatal_signal+0x489)[0x787029]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7f419d8a1390]
/usr/sbin/mysqld[0xc1b708]
/usr/sbin/mysqld(_Z21join_read_const_tableP8JOIN_TABP11st_position+0x243)[0xc1f573]
/usr/sbin/mysqld(_ZN4JOIN29extract_func_dependent_tablesEv+0x3e7)[0xc3cdb7]
/usr/sbin/mysqld(_ZN4JOIN14make_join_planEv+0x102a)[0xc4472a]
/usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0x709)[0xc45849]
/usr/sbin/mysqld(_ZN13st_select_lex8optimizeEP3THD+0x682)[0xc8dcb2]
/usr/sbin/mysqld(_Z12handle_queryP3THDP3LEXP12Query_resultyy+0x20c)[0xc8df2c]
/usr/sbin/mysqld[0x750b34]
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THDb+0x492e)[0xc5004e]
/usr/sbin/mysqld(_Z11mysql_parseP3THDP12Parser_state+0x3ad)[0xc524ad]
/usr/sbin/mysqld(_Z16dispatch_commandP3THDPK8COM_DATA19enum_server_command+0x102a)[0xc535ea]
/usr/sbin/mysqld(_Z10do_commandP3THD+0x1c7)[0xc54aa7]
/usr/sbin/mysqld(handle_connection+0x288)[0xd15bc8]
/usr/sbin/mysqld(pfs_spawn_thread+0x1b4)[0x11bc964]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f419d8976ba]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f419cd2c41d]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7f40a4011cc0): is an invalid pointer
Connection ID (thread ID): 423
Status: NOT_KILLED

Hi,

There's not enough data in the bug report to let us figure out what might be the problem. The crash is during a join from what I see, so probbly a SELECT but does not have to be. 

Can you get us more stack traces from more crashes (you say you get them randomly)?

Could you copy the datadir to a test machine and do some tests to reproduce on a testing system instead on a production one?

thanks
Bogdan

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".