Foremost, thanks @stuckinthehouse and @Joe for all the advice. While I added a mysql user for a manual install of WordPress on my machine, and it seemed like it may be the cause, I elected to first check my logs which were basically a repeat of:
021-07-28T05:11:31.575895Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.26-0ubuntu0.20.04.2) starting as process 3679524
2021-07-28T05:11:31.586448Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-28T05:12:10.435065Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-07-28T05:12:13.436727Z 4 [System] [MY-013381] [Server] Server upgrade from '80025' to '80026' started.
2021-07-28T05:12:51.222903Z 4 [ERROR] [MY-013178] [Server] Execution of server-side SQL statement '-- Copyright (c) 2015, 2021, Oracle and/or its affiliates. -- -- This program is free software; you can redistribute it and/or modify -- it under the terms of the GNU General Public License as published by -- the Free Software Foundation; version 2 of the License. -- -- This program is distributed in the hope that it will be useful, -- but WITHOUT ANY WARRANTY; without even the implied warranty of -- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the -- GNU General Public License for more details. -- -- You should have received a copy of the GNU General Public License -- along with this program; if not, write to the Free Software -- Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA -- NOTE: This needs to be replicated within the sys_config_clean.inc file INSERT IGNORE INTO sys.sys_config (variable, value) VALUES ('statement_truncate_len', 64), ('statement_performance_analyzer.limit', 100), ('statement_performance_analyzer.view', NULL), ('diagnostics.allow_i_s_tables', 'OFF'), ('diagnostics.include_raw', 'OFF'), ('ps_thread_trx_info.max_length', 65535); ' failed with error code = 1436, error message = 'Thread stack overrun: 12384 bytes used of a 131072 byte stack, and 160000 bytes needed. Use 'mysqld --thread_stack=#' to specify a bigger stack.'.
2021-07-28T05:12:51.224420Z 0 [ERROR] [MY-013380] [Server] Failed to upgrade server.
2021-07-28T05:12:51.225515Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-07-28T05:12:52.794979Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.26-0ubuntu0.20.04.2) (Ubuntu).
What particularly caught my eyes was: ('ps_thread_trx_info.max_length', 65535); ' failed with error code = 1436, error message = 'Thread stack overrun: 12384 bytes used of a 131072 byte stack, and 160000 bytes needed. Use 'mysqld --thread_stack=#' to specify a bigger stack.'. but attempting to specify a bigger stack didn’t worked so I did the following:
- Went to
etc/mysql/mysql.conf.d/mysqld.cnf
- Manually changed the value of
thread_stack
- Used
sudo service mysql restart to restart the service.
This seems to have resolved the issue as the service appears to be running and sites that depended on a SQL db have returned. In my case, the resolution was simple and probably because I’m just an idiot, but either way my upmost gratitude again, @joe and @stuckinthehouse!
