Question Problem with Innodes command Free

[Shasam]

Hello,

I have a problem because my partition is full see below.

Filesystem Inodes IUsed IFree IUse% Mounted on
/dev/vda1 6553600 6547393 6207 100% /

I found the following article
Plesk upgrade/update fails: No space left on device

vzctl set <CT> --save --diskinodes 850000:900000

But I can not exactly adapt the command in SSH for my server

I am on a server Centos 6

Thank you for your help.

JC

 

[IgorG]

vzctl set <CT> --save --diskinodes 850000:900000

You must run this command on Virtuozzo hardware node for your container (CT) and can't use it inside the container.

 

[Shasam]

Hello Igor,

I was able to solve the problem of inodes.
I made a repair yesterday with the command plesk repair all -y
and then it does not work anymore.

Nevertheless I still have a problem the fileir mysql.sock no longer exists.
Below are the last logs of the mysqld.log file

180720 6:01:23 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
180720 6:01:23 InnoDB: The InnoDB memory heap is disabled
180720 6:01:23 InnoDB: Mutexes and rw_locks use GCC atomic builtins
180720 6:01:23 InnoDB: Compressed tables use zlib 1.2.3
180720 6:01:23 InnoDB: Using Linux native AIO
180720 6:01:23 InnoDB: Initializing buffer pool, size = 128.0M
180720 6:01:23 InnoDB: Completed initialization of buffer pool
180720 6:01:23 InnoDB: highest supported file format is Barracuda.
180720 6:01:23 InnoDB: Waiting for the background threads to start
180720 6:01:24 InnoDB: 5.5.50 started; log sequence number 86808901391
180720 6:01:24 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
180720 6:01:24 [Note] - '0.0.0.0' resolves to '0.0.0.0';
180720 6:01:24 [Note] Server socket created on IP: '0.0.0.0'.
180720 6:01:24 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
180720 06:01:24 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
180720 06:06:25 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
180720 6:06:26 [Note] libgovernor.so not found
180720 6:06:26 [Note] /usr/libexec/mysqld (mysqld 5.5.50-cll-lve) starting as process 5946 ...
180720 6:06:26 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
180720 6:06:26 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
180720 6:06:26 InnoDB: The InnoDB memory heap is disabled
180720 6:06:26 InnoDB: Mutexes and rw_locks use GCC atomic builtins
180720 6:06:26 InnoDB: Compressed tables use zlib 1.2.3
180720 6:06:26 InnoDB: Using Linux native AIO
180720 6:06:26 InnoDB: Initializing buffer pool, size = 128.0M
180720 6:06:26 InnoDB: Completed initialization of buffer pool
180720 6:06:26 InnoDB: highest supported file format is Barracuda.
180720 6:06:26 InnoDB: Waiting for the background threads to start
180720 6:06:27 InnoDB: 5.5.50 started; log sequence number 86808901391
180720 6:06:27 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
180720 6:06:27 [Note] - '0.0.0.0' resolves to '0.0.0.0';
180720 6:06:27 [Note] Server socket created on IP: '0.0.0.0'.
180720 6:06:27 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
180720 06:06:27 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended


and here is the screenshot Plesk



Thank you in advance for your help

JC

 

[IgorG]

Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

Try to fix it with

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -u admin --host localhost --port 3306

 

[Shasam]

Igor,

here is the error message back

MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -u admin --host localhost --port 3306

Looking for 'mysql' as: mysql

Looking for 'mysqlcheck' as: mysqlcheck

Error: Failed while fetching Server version! Could be due to unauthorized access.

FATAL ERROR: Upgrade failed

 

[IgorG]

The issue with MySQL service is caused by the package update from Atomic repository.
To fix the issue, perform the following steps on the server:

Execute the following command:
# install -m 0700 -o mysql -g mysql -d /var/lib/mysql-files

Start MySQL service:
# service mysqld start

 

[Shasam]

Igor,

it does not work, here is the error message back

# install -m 0700 -o mysql -g mysql -d /var/lib/mysql-files

# service mysqld start

MySQL Daemon failed to start.

Démarrage de mysqld : [ÉCHOUÉ]

Thank you for you precious help

JC

 

[IgorG]

Any related error messages in mysql log after an attempt to start?

 

[Shasam]

Igor,

Here are the logs

180720 06:06:27 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
180720 09:51:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
180720 9:51:28 [Note] libgovernor.so not found
180720 9:51:28 [Note] /usr/libexec/mysqld (mysqld 5.5.50-cll-lve) starting as process 18172 ...
180720 9:51:28 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
180720 9:51:28 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
180720 9:51:28 InnoDB: The InnoDB memory heap is disabled
180720 9:51:28 InnoDB: Mutexes and rw_locks use GCC atomic builtins
180720 9:51:28 InnoDB: Compressed tables use zlib 1.2.3
180720 9:51:28 InnoDB: Using Linux native AIO
180720 9:51:28 InnoDB: Initializing buffer pool, size = 128.0M
180720 9:51:28 InnoDB: Completed initialization of buffer pool
180720 9:51:28 InnoDB: highest supported file format is Barracuda.
180720 9:51:28 InnoDB: Waiting for the background threads to start
180720 9:51:29 InnoDB: 5.5.50 started; log sequence number 86808901391
180720 9:51:29 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
180720 9:51:29 [Note] - '0.0.0.0' resolves to '0.0.0.0';
180720 9:51:29 [Note] Server socket created on IP: '0.0.0.0'.
180720 9:51:29 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
180720 09:51:29 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended


JC

 

[Shasam]

Igor,

Did you receive the logs?

180720 09:51:29 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
180720 10:47:12 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
180720 10:47:12 [Note] libgovernor.so not found
180720 10:47:12 [Note] /usr/libexec/mysqld (mysqld 5.5.50-cll-lve) starting as process 21146 ...
180720 10:47:12 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
180720 10:47:12 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
180720 10:47:12 InnoDB: The InnoDB memory heap is disabled
180720 10:47:12 InnoDB: Mutexes and rw_locks use GCC atomic builtins
180720 10:47:12 InnoDB: Compressed tables use zlib 1.2.3
180720 10:47:12 InnoDB: Using Linux native AIO
180720 10:47:12 InnoDB: Initializing buffer pool, size = 128.0M
180720 10:47:12 InnoDB: Completed initialization of buffer pool
180720 10:47:12 InnoDB: highest supported file format is Barracuda.
180720 10:47:12 InnoDB: Waiting for the background threads to start
180720 10:47:13 InnoDB: 5.5.50 started; log sequence number 86808901391
180720 10:47:13 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
180720 10:47:13 [Note] - '0.0.0.0' resolves to '0.0.0.0';
180720 10:47:13 [Note] Server socket created on IP: '0.0.0.0'.
180720 10:47:13 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
180720 10:47:13 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

JC

 

[IgorG]

For some reason, you have broken MySQL service. You can try to fix it with help of following recommendation, for example, Fatal error: Can’t open and lock privilege tables: Table ‘mysql.host’ doesn’t - General Linux - Admin-Ahead Community

 

[Shasam]

Igor,

Ok I applied the recommendation. Good news mysql restarts

# whereis mysql
mysql: /usr/bin/mysql /usr/lib64/mysql /usr/share/mysql /usr/share/man/man1/mysql.1.gz

i changed my.cnf
datadir=/usr/lib64/mysql

# service mysqld start
Démarrage de mysqld : [ OK ]

I tried to apply a repair. I still have the following error:
# plesk repair all -y

[2018-07-20 11:18:07.909] ERR [panel] Cannot load settings: SQLSTATE[HY000] [1045] Access denied for user 'admin'@'localhost' (using password: YES)
SQLSTATE[HY000] [1045] Access denied for user 'admin'@'localhost' (using password: YES)
exit status 3

Thank you for you help.

JC

 

[IgorG]

Access denied for user 'admin'@'localhost' (using password: YES)

It was discussed a lot of times on this forum and there are several related KB articles. Please try to use search.

 

[Shasam]

Igor,

I followed the procedure below in automatic mode without success.
And in manual mode I have an error at this level. I can not solve the problem

Unable to access Plesk on Linux: Access denied for user 'admin'@'localhost' (using password: YES)

Arrêt de mysqld : [ OK ]
*** glibc detected *** /usr/libexec/mysqld: double free or corruption (fasttop): 0x00007f531c004a40 ***
======= Backtrace: =========

This the log :

The manual page at MySQL :: MySQL 8.0 Reference Manual :: B.5.3.3 What to Do If MySQL Keeps Crashing contains
information that should help you find out what is causing the crash.
180720 12:36:37 mysqld_safe Number of processes running now: 0
180720 12:36:37 mysqld_safe mysqld restarted
180720 12:36:37 [Note] libgovernor.so not found
180720 12:36:37 [Note] /usr/libexec/mysqld (mysqld 5.5.50-cll-lve) starting as process 10756 ...
180720 12:36:37 [Note] Plugin 'FEDERATED' is disabled.
180720 12:36:37 InnoDB: The InnoDB memory heap is disabled
180720 12:36:37 InnoDB: Mutexes and rw_locks use GCC atomic builtins
180720 12:36:37 InnoDB: Compressed tables use zlib 1.2.3
180720 12:36:37 InnoDB: Using Linux native AIO
180720 12:36:37 InnoDB: Initializing buffer pool, size = 128.0M
180720 12:36:37 InnoDB: Completed initialization of buffer pool
180720 12:36:37 InnoDB: highest supported file format is Barracuda.
180720 12:36:37 InnoDB: Waiting for the background threads to start
180720 12:36:38 InnoDB: 5.5.50 started; log sequence number 1595675
180720 12:36:38 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
180720 12:36:38 [Note] - '0.0.0.0' resolves to '0.0.0.0';
180720 12:36:38 [Note] Server socket created on IP: '0.0.0.0'.
180720 12:36:38 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.50-cll-lve' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) by Atomicorp
10:36:39 UTC - mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

key_buffer_size=8388608
read_buffer_size=131072
max_used_connections=1
max_threads=151
thread_count=0
connection_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 338555 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x19bf230
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 7f8ac821dd98 thread_stack 0x40000
/usr/libexec/mysqld(my_print_stacktrace+0x2e)[0x79601e]
/usr/libexec/mysqld(handle_fatal_signal+0x493)[0x67db03]
/lib64/libpthread.so.0(+0xf7e0)[0x7f8acdb447e0]
/lib64/libc.so.6(gsignal+0x35)[0x7f8acbf884f5]
/lib64/libc.so.6(abort+0x175)[0x7f8acbf89cd5]
/lib64/libc.so.6(+0x70417)[0x7f8acbfc6417]
/lib64/libc.so.6(+0x75e5e)[0x7f8acbfcbe5e]
/lib64/libc.so.6(+0x78cad)[0x7f8acbfcecad]
/usr/libexec/mysqld(_ZN16Security_context7destroyEv+0xbc)[0x56304c]
/usr/libexec/mysqld(_ZN3THDD1Ev+0x13d)[0x566c7d]
/usr/libexec/mysqld(_ZN3THDD0Ev+0x9)[0x567059]
/usr/libexec/mysqld(_Z10unlink_thdP3THD+0xfa)[0x518a9a]
/usr/libexec/mysqld(_Z29one_thread_per_connection_endP3THDb+0x16)[0x518b06]
/usr/libexec/mysqld(_Z24do_handle_one_connectionP3THD+0x139)[0x622519]
/usr/libexec/mysqld(handle_one_connection+0x5b)[0x6225fb]
/lib64/libpthread.so.0(+0x7aa1)[0x7f8acdb3caa1]
/lib64/libc.so.6(clone+0x6d)[0x7f8acc03ec4d]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0): is an invalid pointer
Connection ID (thread ID): 1
Status: KILL_CONNECTION

The manual page at MySQL :: MySQL 8.0 Reference Manual :: B.5.3.3 What to Do If MySQL Keeps Crashing contains
information that should help you find out what is causing the crash.
180720 12:36:39 mysqld_safe Number of processes running now: 0
180720 12:36:39 mysqld_safe mysqld restarted
180720 12:36:39 [Note] libgovernor.so not found
180720 12:36:39 [Note] /usr/libexec/mysqld (mysqld 5.5.50-cll-lve) starting as process 10789 ...
180720 12:36:39 [Note] Plugin 'FEDERATED' is disabled.
180720 12:36:39 InnoDB: The InnoDB memory heap is disabled
180720 12:36:39 InnoDB: Mutexes and rw_locks use GCC atomic builtins
180720 12:36:39 InnoDB: Compressed tables use zlib 1.2.3
180720 12:36:39 InnoDB: Using Linux native AIO
180720 12:36:39 InnoDB: Initializing buffer pool, size = 128.0M
180720 12:36:39 InnoDB: Completed initialization of buffer pool
180720 12:36:39 InnoDB: highest supported file format is Barracuda.
180720 12:36:39 InnoDB: Waiting for the background threads to start
180720 12:36:40 InnoDB: 5.5.50 started; log sequence number 1595675
180720 12:36:40 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
180720 12:36:40 [Note] - '0.0.0.0' resolves to '0.0.0.0';
180720 12:36:40 [Note] Server socket created on IP: '0.0.0.0'.
180720 12:36:40 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.50-cll-lve' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) by Atomicorp