Site from lightsail snapshot not working

[rahepler2]

Platform

AWS

bndiagnostic ID know more about bndiagnostic ID

c33467f0-18ba-e2ab-40b0-524ed02c0396

bndiagnostic output

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

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

[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]

Press [Enter] to continue:
Found recent error messages in the MariaDB error log:

2023-08-08 18:00:24 4623 [Warning] Aborted connection 4623 to db: 
'bitnami_wordpress' user: 'bn_wordpress' host: '**ip_address**' (Got an error 
reading communication packets)

Please check the following guide to troubleshoot MariaDB issues:

https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/debug-errors-m
ariadb/

[Processes]

One or more component's processes are not running:

mariadb not running php-fpm not running

You can try to restart the process with the following command:

$ sudo /opt/bitnami/ctlscript.sh start COMPONENT_NAME

[Apache]
Press [Enter] to continue:

Found recent error or warning messages in the Apache error log.

[Wed Aug 09 23:29:45.472370 2023] [proxy_fcgi:error] [pid 25463:tid 
140083537422080] [client **ip_address**:33358] AH01079: failed to make 
connection to backend: httpd-UDS
 [Wed Aug 09 23:29:45.658646 2023] [proxy:error] [pid 25463:tid 140084064687872] 
(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
 [Wed Aug 09 23:29:45.658675 2023] [proxy_fcgi:error] [pid 25463:tid 
140084064687872] [client **ip_address**:33538] AH01079: failed to make 
connection to backend: httpd-UDS

Please check the following guide to troubleshoot server issues:

https://docs.bitnami.com/general/apps/wordpress/troubleshooting/debug-erro
rs-apache/

===== End of bndiagnostic tool output =====

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

useful, but need assistnace

Describe your issue as much as you can

I created a snapshot of my old instance, and then created a new AWS lightsail from the snapshot where I re-routed my DNS to. It was giving me a 503 error and wouldn't let me access the site. When I renamed plugins and themes it was then giving me a too many redirects error.

I need to remove the let's encrypt stuff I believe since I'm using cloudflare, but I also don't know what else is wrong.

Any help is appreciated.

site it groovebudget.com

[mdhont]

Is it possible to access mariadb through the command line?

https://docs.bitnami.com/general/apps/wordpress/get-started/connect-mariadb/

[rahepler2]

I cannot, here are the errors I am seeing.

ERROR 2002 (HY000): Can't connect to local server through socket '/opt/bitnami/mariadb/tmp/mysql.sock' (2)

I also ran this: sudo /opt/bitnami/ctlscript.sh status , and got this

apache already running
mariadb not running
php-fpm not running

[rahepler2]

when opening the mysqld.log file I get:

2023-08-06 0:56:19 5914 [Warning] Aborted connection 5914 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Out of memory.)
2023-08-06 0:56:20 5915 [Warning] Aborted connection 5915 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Out of memory.)
2023-08-06 0:56:20 5916 [Warning] Aborted connection 5916 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Out of memory.)
2023-08-06 0:56:20 5917 [Warning] Aborted connection 5917 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Out of memory.)
2023-08-07 19:08:36 0 [Note] Starting MariaDB 10.6.12-MariaDB source revision 4c79e15cc3716f69c044d4287ad2160da8101cdc as process 3795
2023-08-07 19:08:36 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-08-07 19:08:36 0 [Note] InnoDB: Number of pools: 1
2023-08-07 19:08:36 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-08-07 19:08:36 0 [Note] InnoDB: Using Linux native AIO
2023-08-07 19:08:36 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728
2023-08-07 19:08:36 0 [Note] InnoDB: Completed initialization of buffer pool
2023-08-07 19:08:36 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=6792402470,6792402470
2023-08-07 19:08:41 0 [Note] InnoDB: Starting final batch to recover 1318 pages from redo log.
2023-08-07 19:08:41 0 [Note] InnoDB: 128 rollback segments are active.
2023-08-07 19:08:41 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2023-08-07 19:08:41 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-08-07 19:08:41 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-08-07 19:08:41 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2023-08-07 19:08:41 0 [Note] InnoDB: 10.6.12 started; log sequence number 6839108537; transaction id 2142404
2023-08-07 19:08:41 0 [Note] InnoDB: Loading buffer pool(s) from /bitnami/mariadb/data/ib_buffer_pool
2023-08-07 19:08:41 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-08-07 19:08:41 0 [Note] Server socket created on IP: '127.0.0.1'.
2023-08-07 19:08:41 0 [Warning] 'proxies_priv' entry '@% root@ip-172-26-13-203' ignored in --skip-name-resolve mode.
2023-08-07 19:08:42 0 [Note] InnoDB: Buffer pool(s) load completed at 230807 19:08:42
2023-08-07 19:08:42 0 [Note] /opt/bitnami/mariadb/sbin/mysqld: ready for connections.
Version: '10.6.12-MariaDB' socket: '/opt/bitnami/mariadb/tmp/mysql.sock' port: 3306 Source distribution
2023-08-08 18:00:04 4560 [Warning] Aborted connection 4560 to db: 'bitnami_wordpress' user: 'bn_wordpress' host: '127.0.0.1' (Got an error reading communi
cation packets)
Version: '10.6.12-MariaDB' socket: '/opt/bitnami/mariadb/tmp/mysql.sock' port: 3306 Source distribution
2023-08-08 18:00:04 4560 [Warning] Aborted connection 4560 to db: 'bitnami_wordpress' user: 'bn_wordpress' host: '127.0.0.1' (Got an error reading communi
cation packets)
2023-08-08 18:00:04 4540 [Warning] Aborted connection 4540 to db: 'bitnami_wordpress' user: 'bn_wordpress' host: '127.0.0.1' (Got an error reading communi
cation packets)
2023-08-08 18:00:24 4561 [Warning] Aborted connection 4561 to db: 'bitnami_wordpress' user: 'bn_wordpress' host: '127.0.0.1' (Got an error reading communi
cation packets)
2023-08-08 18:00:24 4541 [Warning] Aborted connection 4541 to db: 'bitnami_wordpress' user: 'bn_wordpress' host: '127.0.0.1' (Got an error reading communi
cation packets)
2023-08-08 18:00:24 4559 [Warning] Aborted connection 4559 to db: 'bitnami_wordpress' user: 'bn_wordpress' host: '127.0.0.1' (Got an error reading communi
cation packets)
2023-08-08 18:00:24 4562 [Warning] Aborted connection 4562 to db: 'bitnami_wordpress' user: 'bn_wordpress' host: '127.0.0.1' (Got an error reading communi
cation packets)
2023-08-08 18:00:24 4542 [Warning] Aborted connection 4542 to db: 'bitnami_wordpress' user: 'bn_wordpress' host: '127.0.0.1' (Got an error reading communi
cation packets)
2023-08-08 18:00:24 4539 [Warning] Aborted connection 4539 to db: 'bitnami_wordpress' user: 'bn_wordpress' host: '127.0.0.1' (Got an error reading communi
cation packets)
2023-08-08 18:00:24 4613 [Warning] Aborted connection 4613 to db: 'bitnami_wordpress' user: 'bn_wordpress' host: '127.0.0.1' (Got an error reading communi
cation packets)
2023-08-08 18:00:24 4623 [Warning] Aborted connection 4623 to db: 'bitnami_wordpress' user: 'bn_wordpress' host: '127.0.0.1' (Got an error reading communi
cation packets)
2023-08-08 18:00:26 0 [Note] /opt/bitnami/mariadb/sbin/mysqld (initiated by: unknown): Normal shutdown
2023-08-08 18:00:26 0 [Note] InnoDB: FTS optimize thread exiting.
2023-08-08 18:00:26 0 [Note] InnoDB: Starting shutdown...
2023-08-08 18:00:26 0 [Note] InnoDB: Dumping buffer pool(s) to /bitnami/mariadb/data/ib_buffer_pool
2023-08-08 18:00:26 0 [Note] InnoDB: Buffer pool(s) dump completed at 230808 18:00:26
2023-08-08 18:00:26 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2023-08-08 18:00:26 0 [Note] InnoDB: Shutdown completed; log sequence number 6918509894; transaction id 2170484
2023-08-08 18:00:26 0 [Note] /opt/bitnami/mariadb/sbin/mysqld: Shutdown complete

[rahepler2]

There was let's encrypt setup on the old instance, figured the snapshot would have brought over the SSL info as well. Would that be part of the issue?

[rahepler2]

RE-ran diagnostic report after starting mariadb and php-fpm

8dbec5a2-0430-b286-22cf-ca4275df73cb

seems like Apache and mariadb are still getting errors connecting to backend

[mdhont]

It seems to be caused by a lack of memory:

2023-08-06 0:56:19 5914 [Warning] Aborted connection 5914 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Out of memory.)
2023-08-06 0:56:20 5915 [Warning] Aborted connection 5915 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Out of memory.)
2023-08-06 0:56:20 5916 [Warning] Aborted connection 5916 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Out of memory.)
2023-08-06 0:56:20 5917 [Warning] Aborted connection 5917 to db: 'unconnected' user: 'unauthenticated' host: 'connecting host' (Out of memory.)

I recommend upgrading to a more powerful machine.

[github-actions]

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]

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.