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
- Manually changed the value of
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!