Issue Broken after reboot

[BrinsleyP]

Hello to every

In my server DEBIAN 10 after reboot the server crash the MariaDB 10.3 and i cant repair.

when i try plesk repair db the console return

DB query failed: SQLSTATE[HY000] [2002] No such file or directory
exit status 1

in prints i see some error but cant repair.












So how to fix this ?

 

[IgorG]

So how to fix this ?

Try to find solution in many related KB articles: Search results – Plesk Help Center

 

[BrinsleyP]

Try to find solution in many related KB articles: Search results – Plesk Help Center

Hello, i try these topics but anyone work fine.

 

[sebgonzes]

Supose that you can't use plesk repair db if your database server is down, you need to review why your db server is down, can you give us information about your mariadb log?

 

[sebgonzes]

What content do you have in /var/lib/mysql ?

 

[BrinsleyP]

What content do you have in /var/lib/mysql ?

Only see the db users and these anothers files.

 

[sebgonzes]

And your complete mariadb log (review path in /etc/my.cnf ) ?

 

[BrinsleyP]

Supose that you can't use plesk repair db if your database server is down, you need to review why your db server is down, can you give us information about your mariadb log?

2021-06-29 10:13:59 0 [Note] InnoDB: Using Linux native AIO 2021-06-29 10:13:59 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-06-29 10:13:59 0 [Note] InnoDB: Uses event mutexes 2021-06-29 10:13:59 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-06-29 10:13:59 0 [Note] InnoDB: Number of pools: 1 2021-06-29 10:13:59 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-06-29 10:13:59 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2021-06-29 10:13:59 0 [Note] InnoDB: Completed initialization of buffer pool 2021-06-29 10:13:59 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-06-29 10:13:59 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2021-06-29 10:13:59 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-06-29 10:13:59 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-06-29 10:13:59 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-06-29 10:13:59 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-06-29 10:13:59 0 [Note] InnoDB: 10.3.29 started; log sequence number 215420064140; transaction id 72275874 2021-06-29 10:13:59 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2021-06-29 10:13:59 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-06-29 10:13:59 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded 2021-06-29 10:13:59 0 [Note] Recovering after a crash using tc.log 2021-06-29 10:13:59 0 [Note] Starting crash recovery... 2021-06-29 10:13:59 0 [Note] Crash recovery finished. 2021-06-29 10:13:59 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 2021-06-29 10:13:59 0 [Note] Server socket created on IP: '127.0.0.1'. 2021-06-29 10:13:59 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

These lines repeat in a loop on log...

 

[sebgonzes]

ls -l /var/lib/mysql/mysql ? Do you have some HDD crash?

 

[sebgonzes]

ls -l /var/lib/mysql/mysql ? Do you have some HDD crash?

Also you have free space on your var partition?

 

[weltonw]

What kind of reboot did you run? This behavior looks more like someone pulled the power on the instance lol.

 

[BrinsleyP]

ls -l /var/lib/mysql/mysql ? Do you have some HDD crash?

Hello, no hdd crashed... i just reboot the serve after updates

 

[BrinsleyP]

What kind of reboot did you run? This behavior looks more like someone pulled the power on the instance lol.

Hello,,, i just reboot after updates.

 

[pleskpanel]

What does your my.cnf look like?

On that note, do you by any chance have a back up of either the servers table?

 

[pleskpanel]

If that table is truly corrupt, take a backup of it and then try these steps before restarting your MariaDB instance.

 

[sebgonzes]

Can you give the result of ls -l /var/lib/mysql/mysql ?

 

[BrinsleyP]

Can you give the result of ls -l /var/lib/mysql/mysql ?

ls: cannot access '/var/lib/mysql/mysql': No such file or directory

 

[sebgonzes]

ls: cannot access '/var/lib/mysql/mysql': No such file or directory

Ok, this is the problem... your vital mysql database have been deleted... Try to restore files of this database from your most recent backup (owner should be mysql)

 

[BrinsleyP]

Ok, this is the problem... your vital mysql database have been deleted... Try to restore files of this database from your most recent backup (owner should be mysql)

Have some how to or tutorial about this ?

 

[sebgonzes]

Have some how to or tutorial about this ?

Do you have some backup (tar/gzip file)?