Hey,
It looks like mariadb server crashed while I was updating, and now my domain login page is showing Internal Server Error. I have tried to recover it using the rollback command but it did not work.
I have a backup of the database and pushed it back, but I am still getting the error. Upon looking at the error logs on the database server, I found the following:
Log found in /var/log/mysql/error.log
2021-06-29 5:27:34 0 [Note] InnoDB: Using Linux native AIO
2021-06-29 5:27:34 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-06-29 5:27:34 0 [Note] InnoDB: Uses event mutexes
2021-06-29 5:27:34 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-06-29 5:27:34 0 [Note] InnoDB: Number of pools: 1
2021-06-29 5:27:34 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-06-29 5:27:34 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2021-06-29 5:27:34 0 [Note] InnoDB: Completed initialization of buffer pool
2021-06-29 5:27:34 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can $
2021-06-29 5:27:34 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-06-29 5:27:34 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-06-29 5:27:34 0 [Note] InnoDB: Setting file ‘./ibtmp1’ size to 12 MB. Physically writing the file full; Plea$
2021-06-29 5:27:34 0 [Note] InnoDB: File ‘./ibtmp1’ size is now 12 MB.
2021-06-29 5:27:34 0 [Note] InnoDB: 10.3.23 started; log sequence number 16897056309; transaction id 3423216
2021-06-29 5:27:34 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2021-06-29 5:27:34 0 [Note] Plugin ‘FEEDBACK’ is disabled.
2021-06-29 5:27:34 0 [Note] Server socket created on IP: ‘0.0.0.0’.
2021-06-29 5:27:34 0 [Note] Reading of all Master_info entries succeeded
2021-06-29 5:27:34 0 [Note] Added new Master_info ‘’ to hash table
2021-06-29 5:27:34 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: ‘10.3.23-MariaDB-0+deb10u1’ socket: ‘/run/mysqld/mysqld.sock’ port: 3306 Debian 10
2021-06-29 5:27:34 0 [Note] InnoDB: Buffer pool(s) load completed at 210629 5:27:34
2021-06-29 5:27:34 8 [Warning] Access denied for user ‘root’@‘localhost’ (using password: NO)
What other logs do I check? And how can I fix it? Thank you.