Bug #96286 | mysql server crash when doning buf flushing | ||
---|---|---|---|
Submitted: | 23 Jul 2019 9:39 | Modified: | 14 Apr 2020 3:44 |
Reporter: | Dick Lin | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server | Severity: | S1 (Critical) |
Version: | 5.7.19 | OS: | Any |
Assigned to: | MySQL Verification Team | CPU Architecture: | Any |
[23 Jul 2019 9:39]
Dick Lin
[23 Jul 2019 12:17]
MySQL Verification Team
Hi, Not reproducing this. Can you share your config file? thanks
[26 Jul 2019 2:51]
Dick Lin
config file
Attachment: my.cnf (application/octet-stream, text), 6.78 KiB.
[30 Jul 2019 23:25]
MySQL Verification Team
Hi, I cannot reproduce this with 5.7.26 neither on linux (centos, rhel, ol and fedora) nor on macos (10.14.5). I created 30000 tables no problem, then I altered them, again no problem. With this many tables you want to increase table cache and max open files both on os and on mysql itself also not that file per table is default on
[14 Apr 2020 3:44]
Dick Lin
updated MySQL server to 5.7.26, and crashed again, with almost same error log: key_buffer_size=8388608 read_buffer_size=1048576 max_used_connections=6 max_threads=100001 thread_count=19 connection_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1740864893 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0 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 = 0 thread_stack 0x80000 /usr/local/mysql/bin/mysqld(my_print_stacktrace+0x2c)[0xee0ecc] /usr/local/mysql/bin/mysqld(handle_fatal_signal+0x461)[0xd21621] /lib64/libpthread.so.0[0x369ea0f7e0] /usr/local/mysql/bin/mysqld(_ZN13FlushObserver12notify_flushEP10buf_pool_tP10buf_page_t+0x18)[0x118dc68] /usr/local/mysql/bin/mysqld(_Z14buf_flush_pageP10buf_pool_tP10buf_page_t11buf_flush_tb+0x317)[0x118e207] /usr/local/mysql/bin/mysqld[0x118f103] /usr/local/mysql/bin/mysqld(_Z18buf_flush_do_batchP10buf_pool_t11buf_flush_tmmPm+0x57f)[0x119070f] /usr/local/mysql/bin/mysqld[0x1192f61] /usr/local/mysql/bin/mysqld(buf_flush_page_cleaner_worker+0x185)[0x1193255] /lib64/libpthread.so.0[0x369ea07aa1] /lib64/libc.so.6(clone+0x6d)[0x369e2e893d]
[14 Apr 2020 12:06]
MySQL Verification Team
Hi, Still can't reproduce this. Without a way to reproduce this there's little we can do. Maybe if you run a debug version of mysql server on your stage and can reproduce there we could gather some useful data. Thanks Bogdan