The first problem came at around midnight, with an INNODB table that might have gotten corrupted by an upgrade triggered by Keyhelp earlier in the day? (by looking for modifications besides the data added to the main database, I've seen in /var/lib/mysql that keyhelp folder shows date last modified 4/11, and mysql and performance schema a day later (5/11 at 4:09), with mysql_upgrade_info file also updated at the same time and showing 10.5.7-MariaDB).
After that, I was able to get mysql running for one or two minutes before it started returning a second error.
I've seen that /etc/mysql/mariadb.conf.d/99-enable-encryption.cnf.preset has been modified three days ago (maybe by Keyhelp as well?)
And the Keyhelp conf file for mariadb is still the one I updated in September:
Code: Select all
#
# KeyHelp Tuning Settings
# System-Memory > 2 GB
#
[mysqld]
# mySQL Tuning
max_connections = 200
#key_buffer_size = 250M
key_buffer_size = 500M
max_allowed_packet = 16M
thread_stack = 256K
tmp_table_size = 128M
max_heap_table_size = 128M
thread_cache_size = 150
table_cache = 8192
table_definition_cache = 4096
open_files_limit = 16544
# InnoDB Configuration
innodb_file_per_table = 1
innodb_buffer_pool_size = 500M
innodb_log_file_size = 128M
# Query Cache Configuration
query_cache_limit = 64M
query_cache_size = 512M
query_cache_type = 1
Code: Select all
Nov 06 09:25:26 servername mariadbd[2938310]: Max resident set unlimited unlimited bytes
Nov 06 09:25:26 servername mariadbd[2938310]: Max processes 15401 15401 processes
Nov 06 09:25:26 servername mariadbd[2938310]: Max open files 16384 16384 files
Nov 06 09:25:26 servername mariadbd[2938310]: Max locked memory 65536 65536 bytes
Nov 06 09:25:26 servername mariadbd[2938310]: Max address space unlimited unlimited bytes
Nov 06 09:25:26 servername mariadbd[2938310]: Max file locks unlimited unlimited locks
Nov 06 09:25:26 servername mariadbd[2938310]: Max pending signals 15401 15401 signals
Nov 06 09:25:26 servername mariadbd[2938310]: Max msgqueue size 819200 819200 bytes
Nov 06 09:25:26 servername mariadbd[2938310]: Max nice priority 0 0
Nov 06 09:25:26 servername mariadbd[2938310]: Max realtime priority 0 0
Nov 06 09:25:26 servername mariadbd[2938310]: Max realtime timeout unlimited unlimited us
Nov 06 09:25:26 servername mariadbd[2938310]: Core pattern: |/usr/share/apport/apport %p %s %c %d %P %E
Nov 06 09:25:27 servername systemd[1]: mariadb.service: Main process exited, code=dumped, status=6/ABRT
-- Subject: Unit process exited
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- An ExecStart= process belonging to unit mariadb.service has exited.
--
-- The process' exit code is 'dumped' and its exit status is 6.
Nov 06 09:25:27 servername systemd[1]: mariadb.service: Failed with result 'core-dump'.
-- Subject: Unit failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- The unit mariadb.service has entered the 'failed' state with result 'core-dump'.
Nov 06 09:25:27 neurona.abretelibro.com systemd[1]: Failed to start MariaDB 10.5.7 database server.
-- Subject: A start job for unit mariadb.service has failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- A start job for unit mariadb.service has finished with a failure.
--
-- The job identifier is 299478 and the job result is failed.
systemctl status mariadb.service
Code: Select all
● mariadb.service - MariaDB 10.5.7 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: activating (auto-restart) (Result: core-dump) since Fri 2020-11-06 09:27:02 CET; 4s ago
Docs: man:mariadbd(8)
https://mariadb.com/kb/en/library/systemd/
Process: 2940412 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 2940424 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 2940430 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl>
Process: 2940543 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=dumped, signal=ABRT)
Main PID: 2940543 (code=dumped, signal=ABRT)