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

[moneysite]

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.

[josephgodwinke]

Happy New Year @moneysite

See this

Possible dead lock [LSAPI application]

This is a php process issue It usually happens with some PHP script takes long time to finish, or have a bug causing an infinity loop. People keep refreshing that URL, all PHP worker processes are occupied by the long run script, cannot take new request any more. For some cases, increase the timeout or number of worker processes can help. The eventual fix is to fix the script. Usually it is not some thing can be taken care of automatically by web server. reference "No request delivery notifi…

[moneysite]

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?

[josephgodwinke]

@moneysite

How can I find out what is the root cause and fix?

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