Issue System Error 11 in mysqldump

[dosmasdos]

No, i not kicked out...

This error starts with the last minor version update (not MU, minor version)

 

[dosmasdos]

- When you run the backup and at the same time watch the output of
> show processlist;
of your database server, do you see many "waiting on table lock" entries?

- Does the database server stay online all through the backup process or are you kicked out of "# plesk db" while running the backup or creating dumps?

MariaDB [psa]> show processlist;
+--------+-------------+-----------+---------------+---------+------+----------+------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+--------+-------------+-----------+---------------+---------+------+----------+------------------+----------+
| 4 | admin | localhost | psa | Sleep | 33 | | NULL | 0.000 |
| 5 | admin | localhost | psa | Sleep | 14 | | NULL | 0.000 |
| 148947 | es_ilorbqf | localhost | emailsecurity | Sleep | 291 | | NULL | 0.000 |
| 149337 | es_ilorbqf | localhost | emailsecurity | Sleep | 1377 | | NULL | 0.000 |
| 149587 | es_ilorbqf | localhost | emailsecurity | Sleep | 230 | | NULL | 0.000 |
| 152178 | es_ilorbqf | localhost | emailsecurity | Sleep | 2592 | | NULL | 0.000 |
| 153477 | es_ilorbqf | localhost | emailsecurity | Sleep | 1307 | | NULL | 0.000 |
| 154126 | es_ilorbqf | localhost | emailsecurity | Sleep | 260 | | NULL | 0.000 |
| 157922 | es_ilorbqf | localhost | emailsecurity | Sleep | 1482 | | NULL | 0.000 |
| 159698 | es_ilorbqf | localhost | emailsecurity | Sleep | 395 | | NULL | 0.000 |
| 161226 | es_ilorbqf | localhost | emailsecurity | Sleep | 1021 | | NULL | 0.000 |
| 161482 | es_ilorbqf | localhost | emailsecurity | Sleep | 1162 | | NULL | 0.000 |
| 166578 | admin | localhost | psa | Sleep | 505 | | NULL | 0.000 |
| 166872 | moodle_aero | localhost | moodle | Sleep | 0 | | NULL | 0.000 |
| 166875 | admin | localhost | psa | Query | 0 | starting | show processlist | 0.000 |
| 166912 | moodle_aero | localhost | moodle | Sleep | 0 | | NULL | 0.000 |
| 166942 | admin | localhost | psa | Sleep | 37 | | NULL | 0.000 |
| 166950 | moodle_aero | localhost | moodle | Sleep | 0 | | NULL | 0.000 |
| 166960 | admin | localhost | psa | Sleep | 0 | | NULL | 0.000 |
+--------+-------------+-----------+---------------+---------+------+----------+------------------+----------+

 

[Peter Debik]

Do you by chance know whether you have one or more database tables in which BLOBs with large content are stored, e.g. high resolution images? It is thinkable that MariaDB cannot get enough RAM from your system to process that content on dumps.

If you cannot verify this I suggest to let Plesk support staff look at it. It surely needs to be checked on the server.

To sign-in to support please go to https://support.plesk.com

If you experience login issues, please see this KB article:
https://support.plesk.com/hc/en-us/...rt-plesk-com-and-password-reset-does-not-work

If you bought your license from a reseller, your reseller should provide support for you. If the reseller does not provide support, here is an alternative:
https://support.plesk.com/hc/en-us/articles/12388090147095-How-to-get-support-directly-from-Plesk-

 

[dosmasdos]

Do you by chance know whether you have one or more database tables in which BLOBs with large content are stored, e.g. high resolution images? It is thinkable that MariaDB cannot get enough RAM from your system to process that content on dumps.

If you cannot verify this I suggest to let Plesk support staff look at it. It surely needs to be checked on the server.

To sign-in to support please go to https://support.plesk.com

If you experience login issues, please see this KB article:
https://support.plesk.com/hc/en-us/...rt-plesk-com-and-password-reset-does-not-work

If you bought your license from a reseller, your reseller should provide support for you. If the reseller does not provide support, here is an alternative:
https://support.plesk.com/hc/en-us/articles/12388090147095-How-to-get-support-directly-from-Plesk-

 

[dosmasdos]

Do you by chance know whether you have one or more database tables in which BLOBs with large content are stored, e.g. high resolution images? It is thinkable that MariaDB cannot get enough RAM from your system to process that content on dumps.

If you cannot verify this I suggest to let Plesk support staff look at it. It surely needs to be checked on the server.

To sign-in to support please go to https://support.plesk.com

If you experience login issues, please see this KB article:
https://support.plesk.com/hc/en-us/...rt-plesk-com-and-password-reset-does-not-work

If you bought your license from a reseller, your reseller should provide support for you. If the reseller does not provide support, here is an alternative:
https://support.plesk.com/hc/en-us/articles/12388090147095-How-to-get-support-directly-from-Plesk-

 

[dosmasdos]

Do you by chance know whether you have one or more database tables in which BLOBs with large content are stored, e.g. high resolution images? It is thinkable that MariaDB cannot get enough RAM from your system to process that content on dumps.

If you cannot verify this I suggest to let Plesk support staff look at it. It surely needs to be checked on the server.

To sign-in to support please go to https://support.plesk.com

If you experience login issues, please see this KB article:
https://support.plesk.com/hc/en-us/...rt-plesk-com-and-password-reset-does-not-work

If you bought your license from a reseller, your reseller should provide support for you. If the reseller does not provide support, here is an alternative:
https://support.plesk.com/hc/en-us/articles/12388090147095-How-to-get-support-directly-from-Plesk-

The error ocurrs with all databases including that 1.55MB database.

 

[Peter Debik]

When you hit "Exportar volcado", can you dump the database or does not dump not work either? (my question is whether only dumps from the backup utility don't work or whether simple dumps don't work at all). Can you dump it when you use the export feature of phpMyAdmin?

 

[dosmasdos]

When you hit "Exportar volcado", can you dump the database or does not dump not work either? (my question is whether only dumps from the backup utility don't work or whether simple dumps don't work at all). Can you dump it when you use the export feature of phpMyAdmin?

Yes i can export it and the backup its ok...
////////
-- MariaDB dump 10.19 Distrib 10.6.16-MariaDB, for Linux (x86_64)
--
-- Host: localhost Database: congalsa360
-- ------------------------------------------------------
-- Server version 10.6.16-MariaDB

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `encuestas`
--

DROP TABLE IF EXISTS `encuestas`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `encuestas` (
`encuesta` int(11) NOT NULL AUTO_INCREMENT,
`usuario` varchar(100) NOT NULL,
`rol` varchar(100) NOT NULL,
`url` varchar(500) DEFAULT NULL,
`nombre` varchar(200) NOT NULL,
`apellidos` varchar(200) NOT NULL,
`hash` varchar(100) NOT NULL,
[.....]

 

[dosmasdos]

i think its a problem with mysqldump and the new minor version of plesk but
plesk repair all -y -v
dont solve the problem

 

[dosmasdos]

i try...
[root@srv7000 ~]# yum reinstall MariaDB-client
Last metadata expiration check: 0:05:03 ago on Mon 04 Dec 2023 04:34:44 PM CET.
Dependencies resolved.
================================================================================
Package Architecture Version Repository Size
================================================================================
Reinstalling:
MariaDB-client x86_64 10.6.16-1.el8 mariadb 15 M

Transaction Summary
================================================================================

Total download size: 15 M
Installed size: 76 M
Is this ok [y/N]: y
Downloading Packages:
MariaDB-client-10.6.16-1.el8.x86_64.rpm 11 MB/s | 15 MB 00:01
--------------------------------------------------------------------------------
Total 11 MB/s | 15 MB 00:01
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Running scriptlet: MariaDB-client-10.6.16-1.el8.x86_64 1/2
Reinstalling : MariaDB-client-10.6.16-1.el8.x86_64 1/2
Running scriptlet: MariaDB-client-10.6.16-1.el8.x86_64 1/2
Running scriptlet: MariaDB-client-10.6.16-1.el8.x86_64 2/2
Cleanup : MariaDB-client-10.6.16-1.el8.x86_64 2/2
Running scriptlet: MariaDB-client-10.6.16-1.el8.x86_64 2/2
Verifying : MariaDB-client-10.6.16-1.el8.x86_64 1/2
Verifying : MariaDB-client-10.6.16-1.el8.x86_64 2/2

Reinstalled:
MariaDB-client-10.6.16-1.el8.x86_64

Complete!

 

[dosmasdos]

[root@srv7000 ~]# ls -la /usr/bin/mysqldump
lrwxrwxrwx 1 root root 12 Nov 8 22:10 /usr/bin/mysqldump -> mariadb-dump

 

[Peter Debik]

The minor update did not change anything in the backup feature. If the issue was in Plesk, at least a few other users would have reported the same. I still think it will be necessary that an expert checks the situation directly on your server.