Error logs for mariadb

Locked
lmarcos
Posts: 78
Joined: Sun 26. Jan 2020, 12:55

Error logs for mariadb

Post by lmarcos »

Hi, my mariadb server has run into problems and I can't find error logs. More exactly, If I go to /var/log/mysql the error.log file is 0 bytes. Can someone help me? Btyw, I'm asking here because the latests updates seem to have been triggered in databases modified by Keyhelp and not in my main database. Would a server reboot log me out of the command line panel?

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
journalctl

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)
User avatar
Alexander
Keyweb AG
Posts: 3810
Joined: Wed 20. Jan 2016, 02:23

Re: Error logs for mariadb

Post by Alexander »

Hello,

KeyHelp did not trigger any changes to the database server with the recent updates. It updates the content of its own database `keyhelp`, that is correct, but these changes have no effect on the database server. Beside of content updates that no changes where made.

The MariaDB Version you mentioned was released 2 days ago, and probably got automatically installed by the maintenance interval job "Update server services", which performs the apt-get update && apt-get upgrade regularly.

I would point your questions to the MariaDB girls/guys, because like I said, there where no changes made to the database servers by KeyHelp.
They definitely currenlty have problems with their last update (an other example: https://www.google.com/search?q=General ... e&ie=UTF-8)
Mit freundlichen Grüßen / Best regards
Alexander Mahr

**************************************************************
Keyweb AG - Die Hosting Marke
Neuwerkstr. 45/46, 99084 Erfurt / Germany
http://www.keyweb.de - http://www.keyhelp.de
**************************************************************
lmarcos
Posts: 78
Joined: Sun 26. Jan 2020, 12:55

Re: Error logs for mariadb

Post by lmarcos »

Hi Alexander, any tip on where to find the right error log? As I mentioned before, the only file I found has 0 bytes.
User avatar
Alexander
Keyweb AG
Posts: 3810
Joined: Wed 20. Jan 2016, 02:23

Re: Error logs for mariadb

Post by Alexander »

This should hopefully answer all questions regarding logs and how to enable them: https://mariadb.com/kb/en/error-log/
Mit freundlichen Grüßen / Best regards
Alexander Mahr

**************************************************************
Keyweb AG - Die Hosting Marke
Neuwerkstr. 45/46, 99084 Erfurt / Germany
http://www.keyweb.de - http://www.keyhelp.de
**************************************************************
lmarcos
Posts: 78
Joined: Sun 26. Jan 2020, 12:55

Re: Error logs for mariadb

Post by lmarcos »

Thanks, Alexander.
Locked