bitnami / vms

Bitnami VMs
https://bitnami.com
Other
203 stars 43 forks source link

[Wordpress] CPU keeps spiking daily on my lightsail instance #1362

Closed Dannylegs closed 6 months ago

Dannylegs commented 7 months ago

Platform

AWS

bndiagnostic ID know more about bndiagnostic ID

N/A

bndiagnostic output

===== Begin of bndiagnostic tool output =====

? Resources: Found possible issues
? Connectivity: Found possible issues
? Mariadb: Found possible issues
✓ Processes: No issues found
✓ Wordpress: No issues found
? Apache: Found possible issues
✓ Php: No issues found

[Resources]

Your instance has little available RAM memory.

 total used free shared buff/cache available Mem: 3873 3153 109 149 611 312 
Swap: 0 0 0

You could try to increase your instance's memory. Please check your cloud provider's documentation for more information.

You can also enable swap memory to improve performance.

https://docs.bitnami.com/installer/faq/linux-faq/administration/increase-m emory-linux/

[Connectivity]

Server ports 22, 80 and/or 443 are not publicly accessible. Please check the following guide to open server ports for remote access:

https://docs.bitnami.com/general/faq/administration/use-firewall/

[Mariadb]

Found recent error messages in the MariaDB error log:

2024-01-14 12:12:18 18 [ERROR] mysqld: Table 
'./bitnami_wordpress/wp_fa_user_logins' is marked as crashed and should be 
repaired

bndiagnostic was not useful. Could you please tell us why?

AWS Lightsail instance freezes every other day...

Describe your issue as much as you can

Hosted many Wordpress websites on other providers but not had this issue for some reason.

Have currently setup an instance on Lightsail and the site freezes every other day and have to reboot - I check the metrics and the CPU keeps bursting.

Also check the error logs please see below...

============================================

[Sun Jan 14 11:35:01.577954 2024] [proxy_fcgi:error] [pid 30475:tid 139809280411392] [client 207.46.13.154:57509] AH01071: Got error 'PHP message: PHP Warning:  Undefined array key "new-chat" in /bitnami/wordpress/wp-content/themes/ann/page-create-chat-gpt.php on line 25; PHP message: PHP Warning:  Undefined array key "image" in /bitnami/wordpress/wp-content/themes/ann/page-create-chat-gpt.php on line 488; PHP message: PHP Warning:  Undefined array key "image" in /bitnami/wordpress/wp-content/themes/ann/page-create-chat-gpt.php on line 488; PHP message: PHP Warning:  Undefined array key "image" in /bitnami/wordpress/wp-content/themes/ann/page-create-chat-gpt.php on line 488; PHP message: PHP Warning:  Undefined array key "image" in /bitnami/wordpress/wp-content/themes/ann/page-create-chat-gpt.php on line 488'
[Sun Jan 14 11:52:33.003121 2024] [proxy_fcgi:error] [pid 29845:tid 139810513614592] (70007)The timeout specified has expired: [client 172.26.2.109:40364] AH01075: Error dispatching request to : (polling)
[Sun Jan 14 11:52:42.418905 2024] [proxy_fcgi:error] [pid 30344:tid 139809288804096] (70007)The timeout specified has expired: [client 172.26.32.69:38592] AH01075: Error dispatching request to : (polling)
[Sun Jan 14 11:53:15.904515 2024] [proxy_fcgi:error] [pid 30606:tid 139810068801280] (70007)The timeout specified has expired: [client 172.26.13.145:64928] AH01075: Error dispatching request to : (polling)
[Sun Jan 14 11:53:22.953388 2024] [proxy_fcgi:error] [pid 29830:tid 139810270226176] (70007)The timeout specified has expired: [client 172.26.25.70:31746] AH01075: Error dispatching request to : (polling)
[Sun Jan 14 11:54:01.856277 2024] [proxy_fcgi:error] [pid 29820:tid 139810496829184] (70007)The timeout specified has expired: [client 172.26.8.9:19858] AH01075: Error dispatching request to : (polling)
[Sun Jan 14 11:54:16.197601 2024] [proxy_fcgi:error] [pid 29830:tid 139810261833472] (70007)The timeout specified has expired: [client 172.26.32.69:40708] AH01075: Error dispatching request to : (polling)
[Sun Jan 14 11:55:04.663749 2024] [proxy_fcgi:error] [pid 29845:tid 139810505221888] (70007)The timeout specified has expired: [client 172.26.25.70:2128] AH01075: Error dispatching request to : (polling)
[Sun Jan 14 11:55:05.970513 2024] [proxy_fcgi:error] [pid 29830:tid 139810253440768] (70007)The timeout specified has expired: [client 172.26.13.145:32518] AH01075: Error dispatching request to : (polling)
[Sun Jan 14 11:55:42.036342 2024] [proxy_fcgi:error] [pid 30606:tid 139810253440768] (70007)The timeout specified has expired: [client 172.26.8.9:50958] AH01075: Error dispatching request to : (polling)
[Sun Jan 14 11:55:47.254975 2024] [proxy_fcgi:error] [pid 30344:tid 139809280411392] (70007)The timeout specified has expired: [client 172.26.32.69:12794] AH01075: Error dispatching request to : (polling)
[Sun Jan 14 11:56:25.498812 2024] [proxy_fcgi:error] [pid 29820:tid 139810488436480] (70007)The timeout specified has expired: [client 172.26.13.145:53448] AH01075: Error dispatching request to : (polling)
[Sun Jan 14 11:56:26.111208 2024] [proxy_fcgi:error] [pid 29845:tid 139810496829184] (70007)The timeout specified has expired: [client 172.26.25.70:48698] AH01075: Error dispatching request to : (polling)
[Sun Jan 14 11:57:49.710624 2024] [proxy_fcgi:error] [pid 30606:tid 139810102372096] (70007)The timeout specified has expired: [client 172.26.32.69:33264] AH01075: Error dispatching request to : (polling)
[Sun Jan 14 11:57:48.867494 2024] [proxy_fcgi:error] [pid 30475:tid 139809313982208] (70007)The timeout specified has expired: [client 172.26.8.9:1496] AH01075: Error dispatching request to : (polling)
[Sun Jan 14 11:58:58.918076 2024] [proxy_fcgi:error] [pid 29830:tid 139810245048064] (70007)The timeout specified has expired: [client 172.26.13.145:13702] AH01075: Error dispatching request to : (polling)
[Sun Jan 14 11:59:01.084804 2024] [proxy_fcgi:error] [pid 29845:tid 139810601760512] (70007)The timeout specified has expired: [client 172.26.25.70:11620] AH01075: Error dispatching request to : (polling)
[Sun Jan 14 12:00:01.953513 2024] [proxy_fcgi:error] [pid 29845:tid 139810610153216] (70007)The timeout specified has expired: [client 172.26.32.69:41280] AH01075: Error dispatching request to : (polling)
[Sun Jan 14 11:59:47.613005 2024] [proxy_fcgi:error] [pid 29845:tid 139810110961408] (70007)The timeout specified has expired: [client 172.26.8.9:9686] AH01075: Error dispatching request to : (polling)
[Sun Jan 14 12:00:06.260996 2024] [proxy:error] [pid 30606:tid 139810018445056] (2)No such file or directory: AH02454: FCGI: attempt to connect to Unix domain socket /opt/bitnami/php/var/run/www.sock (www-fpm:8000) failed
[Sun Jan 14 12:00:06.263075 2024] [proxy_fcgi:error] [pid 30606:tid 139810018445056] [client 172.26.25.70:31666] AH01079: failed to make connection to backend: httpd-UDS
[Sun Jan 14 12:00:07.231963 2024] [mpm_event:notice] [pid 794:tid 139811171286272] AH00491: caught SIGTERM, shutting down
[Sun Jan 14 12:10:46.245828 2024] [ssl:warn] [pid 763:tid 140147926052096] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Sun Jan 14 12:10:46.256720 2024] [ssl:warn] [pid 764:tid 140147926052096] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Sun Jan 14 12:10:46.258779 2024] [mpm_event:notice] [pid 764:tid 140147926052096] AH00489: Apache/2.4.57 (Unix) OpenSSL/1.1.1w configured -- resuming normal operations
[Sun Jan 14 12:10:46.258814 2024] [core:notice] [pid 764:tid 140147926052096] AH00094: Command line: '/opt/bitnami/apache/bin/httpd -f /opt/bitnami/apache/conf/httpd.conf'

============================================

Can someone shed any light on what I need to do to make it more stable and to prevent this from happening?

Any help I would appreciate it.

Dannylegs commented 7 months ago

FYI have repaired the wp_fa_user_logins table error.

gongomgra commented 7 months ago

Hi @Dannylegs,

Thanks for using Bitnami. Can you run the bndiagnostic tool again and share with us the new code so we can take a look to updated logs?

github-actions[bot] commented 7 months ago

This Issue has been automatically marked as "stale" because it has not had recent activity (for 15 days). It will be closed if no further activity occurs. Thanks for the feedback.

itify commented 7 months ago

@Dannylegs do you have elementor installed on this site?

Dannylegs commented 7 months ago

Yes I do

On Fri, 2 Feb 2024 at 22:36, itify @.***> wrote:

@Dannylegs https://github.com/Dannylegs do you have elementor installed on this site?

— Reply to this email directly, view it on GitHub https://github.com/bitnami/vms/issues/1362#issuecomment-1924812863, or unsubscribe https://github.com/notifications/unsubscribe-auth/BFLDLZ4OWZOXHOBAP7NHORLYRVS5RAVCNFSM6AAAAABB2ZWAXKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSMRUHAYTEOBWGM . You are receiving this because you were mentioned.Message ID: @.***>

gongomgra commented 7 months ago

Hi @Dannylegs,

Thanks for your message. We have seen many performance issues caused by some plugins/themes in the past. We recommend you to ask in the official plugin or WordPress forums for further help on this.

Dannylegs commented 7 months ago

Ok will investigate - thanks for your help

On Mon, 5 Feb 2024 at 10:49, Gonzalo Gómez Gracia @.***> wrote:

Hi @Dannylegs https://github.com/Dannylegs,

Thanks for your message. We have seen many performance issues caused by some plugins/themes in the past. We recommend you to ask in the official plugin or WordPress forums for further help on this.

— Reply to this email directly, view it on GitHub https://github.com/bitnami/vms/issues/1362#issuecomment-1926701172, or unsubscribe https://github.com/notifications/unsubscribe-auth/BFLDLZ4A34HZR2RWML6MK5LYSC2K3AVCNFSM6AAAAABB2ZWAXKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSMRWG4YDCMJXGI . You are receiving this because you were mentioned.Message ID: @.***>

github-actions[bot] commented 6 months ago

This Issue has been automatically marked as "stale" because it has not had recent activity (for 15 days). It will be closed if no further activity occurs. Thanks for the feedback.

github-actions[bot] commented 6 months ago

Due to the lack of activity in the last 5 days since it was marked as "stale", we proceed to close this Issue. Do not hesitate to reopen it later if necessary.