How to fix this error: No request delivery notification has been received from LSAPI application, possible dead lock

mo

moneysite March 28, 2023, 6:45 p.m. #1

Hi,
My server is broken down with several error like this:
“No request delivery notification has been received from LSAPI application, possible dead lock.”
What is that and how can I fix that?
My server:

Ubuntu 20.04.6
CyberPanel lastest version (upgraded)
Wordpress
PHP 7.4
I am dying with those error logs and my site is down.

jo

josephgodwinke March 28, 2023, 6:59 p.m. #2

Happy New Year @moneysite

See this

mo

moneysite March 29, 2023, 10:18 a.m. #4

After fix following your instruction, I see there is no this kind of message in my logs again.
But from the beginning, my server is fully loaded 100% CPU which /usr/sbin/mysqld always consume 200% CPU usage.
How can I find out what is the root cause and fix?

jo

josephgodwinke March 29, 2023, 11:28 a.m. #5

Install htop through terminal

apt-get install htop || yum install htop || wget https://github.com/htop-dev/htop/releases/download/3.2.1/htop-3.2.1.tar.xz && unxz htop-3.2.1.tar.xz && tar -zxvf htop-3.2.1.tar.gz && cd htop && ./configure && make && make install

Reboot your server and open htop using command htop and look out for memory usage indicated by Mem% and respective process e.g. see highlighted mysqld process in light blue

SImultaneously run some tasks on cyberpanel or open two of your websites side-by-side with htop running.

Post screenshots here of htop like seen above