MySql Error  [SOLVED]

Discussions about the usage of KeyHelp.
Post Reply
Pedrope
Posts: 13
Joined: Sun 10. Apr 2022, 22:17

MySql Error  [SOLVED]

Post by Pedrope »

I'm not sure if this post is in the right section

Hi, I try to access my server today, but it was not possible at the first try. After several attempts It worked, and the php-error.log has a lot of this lines
#3 /home/keyhelp/www/keyhelp/cronjob/mastercronjob.php(75): DatabaseConnection->__construct()
#4 {main}
thrown in /home/keyhelp/www/keyhelp/core/Database/DatabaseConnection.php on line 244
[02-Sep-2022 01:53:01 America/New_York] PHP Warning: MySQL - Connection Error: 2002 (Connection refused) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 286
[02-Sep-2022 01:53:01 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[02-Sep-2022 01:53:01 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[02-Sep-2022 01:53:01 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[02-Sep-2022 01:53:01 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 111
[02-Sep-2022 01:53:01 America/New_York] PHP Warning: DBConnection::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 112
[02-Sep-2022 01:53:01 America/New_York] PHP Warning: mysqli::ping(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 122
[02-Sep-2022 01:53:02 America/New_York] PHP Notice: DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 131
[02-Sep-2022 01:53:02 America/New_York] PHP Warning: mysqli::close(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 93
[02-Sep-2022 01:53:02 America/New_York] PHP Warning: MySQL - Connection Error: 2002 (Connection refused) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 286
[02-Sep-2022 01:53:02 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[02-Sep-2022 01:53:02 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[02-Sep-2022 01:53:02 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[02-Sep-2022 01:53:02 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 111

My virtual server

KVM Virtual system (VPS)
KeyHelp 22.2
Debian 11.5 (64-bit)
MariaDB 10.5.15
Apache 2.4.54
PHP 7.4.30

Any help is appreciated

Thanks in advance
Pedrope
User avatar
Florian
Keyweb AG
Posts: 1243
Joined: Wed 20. Jan 2016, 02:28

Re: MySql Error

Post by Florian »

Hallo,

it seems that the MySQL Server was not running or at max connection limit.
Mit freundlichen Grüßen / Best regards
Florian Cheno

**************************************************************
Keyweb AG - Die Hosting Marke
Neuwerkstr. 45/46, 99084 Erfurt / Germany
http://www.keyweb.de - http://www.keyhelp.de
**************************************************************
Pedrope
Posts: 13
Joined: Sun 10. Apr 2022, 22:17

Re: MySql Error

Post by Pedrope »

Hi, thanks for your answer Florian, but the MySql server is OK.

It doesn't always happen

Thanks

Pedrope
Pedrope
Posts: 13
Joined: Sun 10. Apr 2022, 22:17

Re: MySql Error

Post by Pedrope »

Hi, again happend :? . I try to access my server today, but it was not possible because the MariaDB was down, and the php-error.log has a lot of this lines
[04-Nov-2022 07:45:01 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[04-Nov-2022 07:45:01 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[04-Nov-2022 07:45:01 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 136
[04-Nov-2022 07:45:01 America/New_York] PHP Warning: DBConnection::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 137
[04-Nov-2022 07:45:01 America/New_York] PHP Warning: mysqli::ping(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 146
[04-Nov-2022 07:45:02 America/New_York] PHP Notice: DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 155
[04-Nov-2022 07:45:02 America/New_York] PHP Warning: mysqli::close(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 93
[04-Nov-2022 07:45:02 America/New_York] PHP Warning: MySQL - Connection Error: 2002 (Connection refused) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[04-Nov-2022 07:45:02 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[04-Nov-2022 07:45:02 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[04-Nov-2022 07:45:02 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[04-Nov-2022 07:45:02 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 136
[04-Nov-2022 07:45:02 America/New_York] PHP Warning: DBConnection::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 137
[04-Nov-2022 07:45:02 America/New_York] PHP Warning: mysqli::ping(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 146
[04-Nov-2022 07:45:03 America/New_York] PHP Notice: DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 155
[04-Nov-2022 07:45:03 America/New_York] PHP Warning: mysqli::close(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 93
[04-Nov-2022 07:45:03 America/New_York] PHP Warning: MySQL - Connection Error: 2002 (Connection refused) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[04-Nov-2022 07:45:03 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[04-Nov-2022 07:45:03 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[04-Nov-2022 07:45:03 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[04-Nov-2022 07:45:03 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 136
[04-Nov-2022 07:45:03 America/New_York] PHP Warning: DBConnection::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 137
[04-Nov-2022 07:45:03 America/New_York] PHP Warning: mysqli::ping(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 146
[04-Nov-2022 07:45:04 America/New_York] PHP Notice: DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 155
[04-Nov-2022 07:45:04 America/New_York] PHP Warning: mysqli::close(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 93
[04-Nov-2022 07:45:04 America/New_York] PHP Warning: MySQL - Connection Error: 2002 (Connection refused) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[04-Nov-2022 07:45:04 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[04-Nov-2022 07:45:04 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[04-Nov-2022 07:45:04 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[04-Nov-2022 07:45:04 America/New_York] PHP Warning: MySQL - Query Error: () in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[04-Nov-2022 07:45:04 America/New_York] PHP Notice: Undefined index: version in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 426
[04-Nov-2022 07:45:04 America/New_York] PHP Warning: Database error: SQLSTATE[HY000] [2002] Connection refused in /home/keyhelp/www/keyhelp/core/Database/DatabaseConnection.php on line 490
[04-Nov-2022 07:45:04 America/New_York] PHP Fatal error: Uncaught Error: Call to a member function prepare() on null in /home/keyhelp/www/keyhelp/core/Database/DatabaseConnection.php:244
Stack trace:
#0 /home/keyhelp/www/keyhelp/core/Database/DatabaseConnection.php(334): DatabaseConnection->query()
#1 /home/keyhelp/www/keyhelp/core/Database/DatabaseConnection.php(604): DatabaseConnection->fetchColumn()
#2 /home/keyhelp/www/keyhelp/core/Database/DatabaseConnection.php(172): DatabaseConnection->loadServerInformation()
#3 /home/keyhelp/www/keyhelp/cronjob/mastercronjob.php(50): DatabaseConnection->__construct()
#4 {main}
thrown in /home/keyhelp/www/keyhelp/core/Database/DatabaseConnection.php on line 244
[04-Nov-2022 07:46:01 America/New_York] PHP Warning: MySQL - Connection Error: 2002 (Connection refused) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[04-Nov-2022 07:46:01 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[04-Nov-2022 07:46:01 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[04-Nov-2022 07:46:01 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[04-Nov-2022 07:46:01 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 136
[04-Nov-2022 07:46:01 America/New_York] PHP Warning: DBConnection::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 137
[04-Nov-2022 07:46:01 America/New_York] PHP Warning: mysqli::ping(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 146
[04-Nov-2022 07:46:02 America/New_York] PHP Notice: DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 155
[04-Nov-2022 07:46:02 America/New_York] PHP Warning: mysqli::close(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 93
[04-Nov-2022 07:46:02 America/New_York] PHP Warning: MySQL - Connection Error: 2002 (Connection refused) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[04-Nov-2022 07:46:02 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[04-Nov-2022 07:46:02 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[04-Nov-2022 07:46:02 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[04-Nov-2022 07:46:02 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 136
[04-Nov-2022 07:46:02 America/New_York] PHP Warning: DBConnection::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 137
[04-Nov-2022 07:46:02 America/New_York] PHP Warning: mysqli::ping(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 146
[04-Nov-2022 07:46:03 America/New_York] PHP Notice: DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 155
[04-Nov-2022 07:46:03 America/New_York] PHP Warning: mysqli::close(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 93
[04-Nov-2022 07:46:03 America/New_York] PHP Warning: MySQL - Connection Error: 2002 (Connection refused) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[04-Nov-2022 07:46:03 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[04-Nov-2022 07:46:03 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[04-Nov-2022 07:46:03 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[04-Nov-2022 07:46:03 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 136
[04-Nov-2022 07:46:03 America/New_York] PHP Warning: DBConnection::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 137
[04-Nov-2022 07:46:03 America/New_York] PHP Warning: mysqli::ping(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 146
[04-Nov-2022 07:46:04 America/New_York] PHP Notice: DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 155
[04-Nov-2022 07:46:04 America/New_York] PHP Warning: mysqli::close(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 93
[04-Nov-2022 07:46:04 America/New_York] PHP Warning: MySQL - Connection Error: 2002 (Connection refused) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[04-Nov-2022 07:46:04 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[04-Nov-2022 07:46:04 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[04-Nov-2022 07:46:04 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[04-Nov-2022 07:46:04 America/New_York] PHP Warning: MySQL - Query Error: () in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[04-Nov-2022 07:46:04 America/New_York] PHP Notice: Undefined index: version in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 426
[04-Nov-2022 07:46:04 America/New_York] PHP Warning: Database error: SQLSTATE[HY000] [2002] Connection refused in /home/keyhelp/www/keyhelp/core/Database/DatabaseConnection.php on line 490
[04-Nov-2022 07:46:04 America/New_York] PHP Fatal error: Uncaught Error: Call to a member function prepare() on null in /home/keyhelp/www/keyhelp/core/Database/DatabaseConnection.php:244
Stack trace:
#0 /home/keyhelp/www/keyhelp/core/Database/DatabaseConnection.php(334): DatabaseConnection->query()
#1 /home/keyhelp/www/keyhelp/core/Database/DatabaseConnection.php(604): DatabaseConnection->fetchColumn()
#2 /home/keyhelp/www/keyhelp/core/Database/DatabaseConnection.php(172): DatabaseConnection->loadServerInformation()
#3 /home/keyhelp/www/keyhelp/cronjob/mastercronjob.php(50): DatabaseConnection->__construct()
#4 {main}
thrown in /home/keyhelp/www/keyhelp/core/Database/DatabaseConnection.php on line 244
[04-Nov-2022 07:47:02 America/New_York] PHP Warning: MySQL - Connection Error: 2002 (Connection refused) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[04-Nov-2022 07:47:02 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[04-Nov-2022 07:47:02 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[04-Nov-2022 07:47:02 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[04-Nov-2022 07:47:02 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 136
[04-Nov-2022 07:47:02 America/New_York] PHP Warning: DBConnection::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 137
[04-Nov-2022 07:47:02 America/New_York] PHP Warning: mysqli::ping(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 146
[04-Nov-2022 07:47:03 America/New_York] PHP Notice: DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 155
[04-Nov-2022 07:47:03 America/New_York] PHP Warning: mysqli::close(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 93
[04-Nov-2022 07:47:03 America/New_York] PHP Warning: MySQL - Connection Error: 2002 (Connection refused) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[04-Nov-2022 07:47:03 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[04-Nov-2022 07:47:03 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[04-Nov-2022 07:47:03 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[04-Nov-2022 07:47:03 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 136
[04-Nov-2022 07:47:03 America/New_York] PHP Warning: DBConnection::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 137
[04-Nov-2022 07:47:03 America/New_York] PHP Warning: mysqli::ping(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 146
[04-Nov-2022 07:47:04 America/New_York] PHP Notice: DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 155
[04-Nov-2022 07:47:04 America/New_York] PHP Warning: mysqli::close(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 93
My virtual server
KVM Virtual system (VPS)
KeyHelp 22.2
Debian 11.5 (64-bit)
MariaDB 10.5.15
Apache 2.4.54
PHP 7.4.30
Domains: 5


Any help is appreciated

Thanks in advance
Pedrope
User avatar
Florian
Keyweb AG
Posts: 1243
Joined: Wed 20. Jan 2016, 02:28

Re: MySql Error

Post by Florian »

Hallo,

check the logs of the mysql server and dmsg. Maybe the MySQL was killed by the OOM killer. Run mysqltuner to see if the settings of your MySQL server are OK.

But this is no Keyhelp related error.
Mit freundlichen Grüßen / Best regards
Florian Cheno

**************************************************************
Keyweb AG - Die Hosting Marke
Neuwerkstr. 45/46, 99084 Erfurt / Germany
http://www.keyweb.de - http://www.keyhelp.de
**************************************************************
Pedrope
Posts: 13
Joined: Sun 10. Apr 2022, 22:17

Re: MySql Error

Post by Pedrope »

Thanks Florian, I'll do it :shock:

One question... can I reinstall mariadb without causing problems on the server?
or is it better to reinstall the panel from scratch?

Thanks in advance

Pedrope
User avatar
24unix
Posts: 1560
Joined: Sun 21. Jun 2020, 17:16
Location: Kollmar
Contact:

Re: MySql Error

Post by 24unix »

Pedrope wrote: Fri 4. Nov 2022, 13:48 One question... can I reinstall mariadb without causing problems on the server?
Why do you want to reinstall?

That won't fix any misconfiguration.

First, check that you can connect to mysql with the credentials from /etc/keyhelp/config/config.json.
mfg Micha
--
If Bill Gates had a nickel for every time Windows crashed …
… oh wait, he does.
Pedrope
Posts: 13
Joined: Sun 10. Apr 2022, 22:17

Re: MySql Error

Post by Pedrope »

24unix, thanks for you response, Indeed I can connect without problems with the credentials.
The problem is that sometimes the Mysql goes down and I don't understand the reason.

I can't find the mysql server log (/var/log/mysql/ --> doesn't show anything), Where can I find this log file?

by the way, the dmesg command does not show anything related to mysql

I appreciate any help to solve this

Thanks

Pedrope
User avatar
24unix
Posts: 1560
Joined: Sun 21. Jun 2020, 17:16
Location: Kollmar
Contact:

Re: MySql Error

Post by 24unix »

You can try:

Code: Select all

journalctl -u mariadb.service -f
mfg Micha
--
If Bill Gates had a nickel for every time Windows crashed …
… oh wait, he does.
Pedrope
Posts: 13
Joined: Sun 10. Apr 2022, 22:17

Re: MySql Error

Post by Pedrope »

ok, this is the output
root@nautilus:/# journalctl -u mariadb.service
-- Journal begins at Sat 2022-10-22 00:50:58 EDT, ends at Fri 2022-11-04 10:25:30 EDT. --
oct 25 00:01:25 nautilus mariadbd[666]: 2022-10-25 0:01:25 78532 [Warning] Aborted connection 78532 to db: 'keyhelp' user: 'keyhelp' host: 'localhost' (Got an error r>
oct 25 00:01:25 nautilus mariadbd[666]: 2022-10-25 0:01:25 78533 [Warning] Aborted connection 78533 to db: 'keyhelp' user: 'keyhelp' host: 'localhost' (Got an error r>
oct 25 00:01:25 nautilus mariadbd[666]: 2022-10-25 0:01:25 78539 [Warning] Aborted connection 78539 to db: 'keyhelp' user: 'keyhelp' host: 'localhost' (Got an error r>
oct 25 00:01:25 nautilus mariadbd[666]: 2022-10-25 0:01:25 78538 [Warning] Aborted connection 78538 to db: 'keyhelp' user: 'keyhelp' host: 'localhost' (Got an error r>
oct 25 00:02:10 nautilus mariadbd[666]: 2022-10-25 0:02:10 78537 [Warning] Aborted connection 78537 to db: 'keyhelp' user: 'keyhelp' host: 'localhost' (Got an error r>
oct 25 00:02:11 nautilus mariadbd[666]: 2022-10-25 0:02:11 78540 [Warning] Aborted connection 78540 to db: 'keyhelp' user: 'keyhelp' host: 'localhost' (Got an error r>
nov 02 08:15:29 nautilus mariadbd[666]: 2022-11-02 8:15:28 131674 [Warning] Aborted connection 131674 to db: 'Tienda_BT' user: 'user_tienda_bt' host: 'localhost' (Got>
nov 04 01:00:43 nautilus systemd[1]: mariadb.service: A process of this unit has been killed by the OOM killer.
nov 04 01:00:43 nautilus systemd[1]: mariadb.service: Main process exited, code=killed, status=9/KILL
nov 04 01:00:43 nautilus systemd[1]: mariadb.service: Failed with result 'oom-kill'.
nov 04 01:00:43 nautilus systemd[1]: mariadb.service: Consumed 55min 6.692s CPU time.
nov 04 07:47:01 nautilus systemd[1]: Starting MariaDB 10.5.15 database server...
nov 04 07:47:01 nautilus mariadbd[1967755]: 2022-11-04 7:47:01 0 [Note] /usr/sbin/mariadbd (mysqld 10.5.15-MariaDB-0+deb11u1) starting as process 1967755 ...
nov 04 07:47:01 nautilus mariadbd[1967755]: 2022-11-04 7:47:01 0 [Warning] Could not increase number of max_open_files to more than 32768 (request: 131204)
nov 04 07:47:01 nautilus mariadbd[1967755]: 2022-11-04 7:47:01 0 [Note] mariadbd: Aria engine: starting recovery
nov 04 07:47:01 nautilus mariadbd[1967755]: recovered pages: 0% 34% 51% 85% 100% (0.0 seconds); tables to flush: 2 1 0
nov 04 07:47:01 nautilus mariadbd[1967755]: (0.0 seconds);
nov 04 07:47:01 nautilus mariadbd[1967755]: 2022-11-04 7:47:01 0 [Note] mariadbd: Aria engine: recovery done
nov 04 07:47:01 nautilus mariadbd[1967755]: 2022-11-04 7:47:01 0 [Note] InnoDB: Uses event mutexes
nov 04 07:47:01 nautilus mariadbd[1967755]: 2022-11-04 7:47:01 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
nov 04 07:47:01 nautilus mariadbd[1967755]: 2022-11-04 7:47:01 0 [Note] InnoDB: Number of pools: 1
nov 04 07:47:01 nautilus mariadbd[1967755]: 2022-11-04 7:47:01 0 [Note] InnoDB: Using generic crc32 instructions
nov 04 07:47:01 nautilus mariadbd[1967755]: 2022-11-04 7:47:01 0 [Note] InnoDB: Using Linux native AIO
nov 04 07:47:01 nautilus mariadbd[1967755]: 2022-11-04 7:47:01 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
nov 04 07:47:01 nautilus mariadbd[1967755]: 2022-11-04 7:47:01 0 [Note] InnoDB: Completed initialization of buffer pool
nov 04 07:47:01 nautilus mariadbd[1967755]: 2022-11-04 7:47:01 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=7569129297,7569129297
nov 04 07:47:02 nautilus mariadbd[1967755]: 2022-11-04 7:47:02 0 [Note] InnoDB: Starting final batch to recover 154 pages from redo log.
nov 04 07:47:03 nautilus mariadbd[1967755]: 2022-11-04 7:47:03 0 [Note] InnoDB: 128 rollback segments are active.
nov 04 07:47:03 nautilus mariadbd[1967755]: 2022-11-04 7:47:03 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
nov 04 07:47:03 nautilus mariadbd[1967755]: 2022-11-04 7:47:03 0 [Note] InnoDB: Creating shared tablespace for temporary tables
nov 04 07:47:03 nautilus mariadbd[1967755]: 2022-11-04 7:47:03 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait .>
nov 04 07:47:03 nautilus mariadbd[1967755]: 2022-11-04 7:47:03 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
nov 04 07:47:03 nautilus mariadbd[1967755]: 2022-11-04 7:47:03 0 [Note] InnoDB: 10.5.15 started; log sequence number 7622595104; transaction id 2329966
nov 04 07:47:03 nautilus mariadbd[1967755]: 2022-11-04 7:47:03 0 [Note] Plugin 'FEEDBACK' is disabled.
nov 04 07:47:03 nautilus mariadbd[1967755]: 2022-11-04 7:47:03 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
nov 04 07:47:03 nautilus mariadbd[1967755]: 2022-11-04 7:47:03 0 [Note] Server socket created on IP: '127.0.0.1'.
nov 04 07:47:03 nautilus mariadbd[1967755]: 2022-11-04 7:47:03 0 [Note] Reading of all Master_info entries succeeded
nov 04 07:47:03 nautilus mariadbd[1967755]: 2022-11-04 7:47:03 0 [Note] Added new Master_info '' to hash table
nov 04 07:47:03 nautilus mariadbd[1967755]: 2022-11-04 7:47:03 0 [Note] /usr/sbin/mariadbd: ready for connections.
nov 04 07:47:03 nautilus mariadbd[1967755]: Version: '10.5.15-MariaDB-0+deb11u1' socket: '/run/mysqld/mysqld.sock' port: 3306 Debian 11
nov 04 07:47:03 nautilus systemd[1]: Started MariaDB 10.5.15 database server.
nov 04 07:47:03 naut
Apparently here is the error :roll:


Pedrope
User avatar
24unix
Posts: 1560
Joined: Sun 21. Jun 2020, 17:16
Location: Kollmar
Contact:

Re: MySql Error

Post by 24unix »

Pedrope wrote: Fri 4. Nov 2022, 15:34 nov 04 01:00:43 nautilus systemd[1]: mariadb.service: A process of this unit has been killed by the OOM killer.
As Florian guessed OOM. (Out of memory)

What does

Code: Select all

free
output?
mfg Micha
--
If Bill Gates had a nickel for every time Windows crashed …
… oh wait, he does.
Pedrope
Posts: 13
Joined: Sun 10. Apr 2022, 22:17

Re: MySql Error

Post by Pedrope »

this is the output

Code: Select all

root@nautilus:/# free
               total        used        free      shared  buff/cache   available
Mem:          999824      518992      162076       84348      318756      256892
Swap:         262140      262088          52

it seems to be the memory, not having enough, kills the mysql processes to protect the server.
It is right?

Pedrope
User avatar
24unix
Posts: 1560
Joined: Sun 21. Jun 2020, 17:16
Location: Kollmar
Contact:

Re: MySql Error

Post by 24unix »

Pedrope wrote: Fri 4. Nov 2022, 15:43 this is the output

Code: Select all

root@nautilus:/# free
               total        used        free      shared  buff/cache   available
Mem:          999824      518992      162076       84348      318756      256892
Swap:         262140      262088          52

it seems to be the memory, not having enough, kills the mysql processes to protect the server.
It is right?

Pedrope
Yes, that's the job of the OOM killer.

You could try to decrease memory usage (antivirus stuff running?) or increase swap space.
But best solution would be to upgrade RAM.
mfg Micha
--
If Bill Gates had a nickel for every time Windows crashed …
… oh wait, he does.
Pedrope
Posts: 13
Joined: Sun 10. Apr 2022, 22:17

Re: MySql Error

Post by Pedrope »

Thanks 24unix, it's clear what I have to do, it's my job now.
I really appreciate your help :D

Can someone mark this thread as resolved?

Best regards

Pedrope
User avatar
Tobi
Community Moderator
Posts: 2812
Joined: Thu 5. Jan 2017, 13:24

Re: MySql Error

Post by Tobi »

In the log is a second error hidden which should be solved

Could not increase number of max_open_files to more than 32768 (request: 131204)
Gruß,
Tobi


-----------------------------
wewoco.de
Das Forum für Reseller, Digital-Agenturen, Bildschirmarbeiter und Mäuseschubser
Post Reply