Bug #93726 | handle_fatal_signal (sig=11) in safe_mutex_lock | mysys/thr_mutex.cc:70 | ||
---|---|---|---|
Submitted: | 21 Dec 2018 18:36 | Modified: | 14 May 2019 17:35 |
Reporter: | Ramesh Sivaraman | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Locking | Severity: | S6 (Debug Builds) |
Version: | 8.0.13 | OS: | Ubuntu |
Assigned to: | CPU Architecture: | Any | |
Tags: | debug |
[21 Dec 2018 18:36]
Ramesh Sivaraman
[21 Dec 2018 20:46]
MySQL Verification Team
Thank you for the bug report. Verified with debug built. miguel@tikal:~/bug $ /home/miguel/bug/8.0/bin/mysqld --no-defaults --basedir=/home/miguel/bug/8.0 --datadir=/home/miguel/bug/8.0/data --performance-schema-digests-size=1125899906842624 --performance-schema-max-sql-text-length=1125899906842624 20:33:54 UTC - mysqld got signal 11 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. Attempting to collect some information that could help diagnose the problem. As this is a crash and something is definitely wrong, the information collection process might fail. key_buffer_size=8388608 read_buffer_size=131072 max_used_connections=0 max_threads=151 thread_count=1 connection_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 67884 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x55a8e7cdf580 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 = 7f4cfea74d48 thread_stack 0x46000 /home/miguel/bug/8.0/bin/mysqld(my_print_stacktrace(unsigned char*, unsigned long)+0x55) [0x55a8e45cd3d1] /home/miguel/bug/8.0/bin/mysqld(handle_fatal_signal+0x3f2) [0x55a8e3284487] /lib/x86_64-linux-gnu/libpthread.so.0(+0x12dd0) [0x7f4cff517dd0] /lib/x86_64-linux-gnu/libpthread.so.0(__pthread_mutex_lock+0) [0x7f4cff50f960] /home/miguel/bug/8.0/bin/mysqld(+0x41910ac) [0x55a8e45d10ac] /home/miguel/bug/8.0/bin/mysqld(safe_mutex_lock(safe_mutex_t*, bool, char const*, unsigned int)+0x25) [0x55a8e45d11d0] /home/miguel/bug/8.0/bin/mysqld(+0x48be977) [0x55a8e4cfe977] /home/miguel/bug/8.0/bin/mysqld(+0x48bea4c) [0x55a8e4cfea4c] /home/miguel/bug/8.0/bin/mysqld(PFS_dynamic_table_shares::lock_share_list()+0x28) [0x55a8e4cfeb8a] /home/miguel/bug/8.0/bin/mysqld(+0x48b982d) [0x55a8e4cf982d] /home/miguel/bug/8.0/bin/mysqld(ha_perfschema::index_flags(unsigned int, unsigned int, bool) const+0x1c) [0x55a8e4cfdfd0] /home/miguel/bug/8.0/bin/mysqld(setup_key_part_field(TABLE_SHARE*, handler*, unsigned int, KEY*, unsigned int, unsigned int, unsigned int*, bool)+0x123) [0x55a8e32073b4] /home/miguel/bug/8.0/bin/mysqld(+0x2f60937) [0x55a8e33a0937] /home/miguel/bug/8.0/bin/mysqld(open_table_def(THD*, TABLE_SHARE*, dd::Table const&)+0x12c) [0x55a8e33a8f4d] /home/miguel/bug/8.0/bin/mysqld(get_table_share(THD*, char const*, char const*, char const*, unsigned long, bool, bool)+0x8a3) [0x55a8e30079c2] /home/miguel/bug/8.0/bin/mysqld(+0x2bc7e84) [0x55a8e3007e84] /home/miguel/bug/8.0/bin/mysqld(open_table(THD*, TABLE_LIST*, Open_table_context*)+0x107a) [0x55a8e300d92a] /home/miguel/bug/8.0/bin/mysqld(+0x2bd1f24) [0x55a8e3011f24] /home/miguel/bug/8.0/bin/mysqld(open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*)+0x3bc) [0x55a8e30134e4] /home/miguel/bug/8.0/bin/mysqld(+0x2f5c4a9) [0x55a8e339c4a9] /home/miguel/bug/8.0/bin/mysqld(+0x2f5d845) [0x55a8e339d845] /home/miguel/bug/8.0/bin/mysqld(+0x2f5d25b) [0x55a8e339d25b] /home/miguel/bug/8.0/bin/mysqld(update_referencing_views_metadata(THD*, char const*, char const*, bool, Uncommitted_tables_guard*)+0xa5) [0x55a8e339d4df] /home/miguel/bug/8.0/bin/mysqld(+0x409b610) [0x55a8e44db610] /home/miguel/bug/8.0/bin/mysqld(plugin_foreach_with_mask(THD*, bool (**)(THD*, st_plugin_int**, void*), int, unsigned int, void*)+0x3bf) [0x55a8e30f6e1b] /home/miguel/bug/8.0/bin/mysqld(plugin_foreach_with_mask(THD*, bool (*)(THD*, st_plugin_int**, void*), int, unsigned int, void*)+0x5e) [0x55a8e30f6ee9] /home/miguel/bug/8.0/bin/mysqld(+0x409bc1c) [0x55a8e44dbc1c] /home/miguel/bug/8.0/bin/mysqld(dd::info_schema::update_I_S_metadata(THD*)+0x28) [0x55a8e44dc627] /home/miguel/bug/8.0/bin/mysqld(+0x2f57fe5) [0x55a8e3397fe5] /home/miguel/bug/8.0/bin/mysqld(+0x48c17ee) [0x55a8e4d017ee] /lib/x86_64-linux-gnu/libpthread.so.0(+0x8164) [0x7f4cff50d164] /lib/x86_64-linux-gnu/libc.so.6(clone+0x3f) [0x7f4cfeb95def] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0): Connection ID (thread ID): 2 Status: NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. miguel@tikal:~/bug $ 8.0/bin/mysqld --version /home/miguel/bug/8.0/bin/mysqld Ver 8.0.15-debug for Linux on x86_64 (Source distribution) =================================================================================================================== miguel@tikal:~/bug $ /home/miguel/bug/8.0/bin/mysqld --no-defaults --basedir=/home/miguel/bug/8.0 --datadir=/home/miguel/bug/8.0/data --performance-schema-digests-size=1125899906842624 --performance-schema-max-sql-text-length=1125899906842624 2018-12-21T20:42:03.759303Z 0 [Warning] [MY-000080] [Server] option 'performance_schema_digests_size': signed value 1125899906842624 adjusted to 1048576. 2018-12-21T20:42:03.759324Z 0 [Warning] [MY-000080] [Server] option 'performance_schema_max_sql_text_length': signed value 1125899906842624 adjusted to 1048576. 2018-12-21T20:42:08.611715Z 0 [Warning] [MY-011041] [Server] Failed to allocate 1099511627776 bytes for buffer '' due to out-of-memory. 2018-12-21T20:42:09.042980Z 0 [Warning] [MY-010170] [Server] Performance schema disabled (reason: init failed). 2018-12-21T20:42:09.482435Z 0 [System] [MY-010116] [Server] /home/miguel/bug/8.0/bin/mysqld (mysqld 8.0.15) starting as process 7241 2018-12-21T20:42:14.684818Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2018-12-21T20:42:15.000777Z 0 [System] [MY-010931] [Server] /home/miguel/bug/8.0/bin/mysqld: ready for connections. Version: '8.0.15' socket: '/tmp/mysql.sock' port: 3306 Source distribution. 2018-12-21T20:42:15.250239Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/tmp/mysqlx.sock' bind-address: '::' port: 33060
[14 May 2019 17:35]
Paul DuBois
Posted by developer: Fixed in 8.0.17. If the server was started with Performance Schema parameters that caused an out-of-memory condition, startup failed.