bitnami / vms

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

Critical Bug on mariadb - Wordpress on GCP VM #1570

Closed jsy11 closed 3 months ago

jsy11 commented 3 months ago

Platform

Google Cloud Platform

bndiagnostic ID know more about bndiagnostic ID

0d4f77e7-c545-4dfb-b2cd-b18a37c943f6

bndiagnostic output

No response

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

This is not related with the issue.

Describe your issue as much as you can

Hello, We've purchased Bitnami VM from GCP Marketplace and has been using this for a while.

From a few months ago, we had experience on 503 error and we had to restart the VM and it worked fine.

But this time, it wasn't working and we contacted GCP support and turns out GCP VM is just fine but the issue is coming from Bitnami VM.

Bascially, our wp website is no longer accessible and getting "Error establishing a database connection"

It turns out the issue is related with mariadb. It's not related with GCP VM as it's working just fine.

Again we didn't touch anything on wordpress and didn't change anything but this issue is happening from yesterday.

I expect binami support to fix this cause we are paying for this binami monthly fee.

===

systemctl status bitnami

So we tried to start the service using the below command and noticed that the service is failing for each restart. I conveyed that the website is not accessible because the bitnami service is failing to start.

We also tried to stop and start the bitnami service using the below command, however this also failed to start.

/opt/bitnami/ctlscript.sh stop

/opt/bitnami/ctlscript.sh start

You informed me that the similar issue happened during the last month and stop/start of the VM helped to resolve the issue. Now we tried stopping and starting the VM, but that also didn't help.

Moving further, I checked the serial console logs of the VM and could see that bitnami is starting three services: php-fpm, mariadb and apache. The bitnami is able to start the php-fpm, but it has failed to start the mariadb service with the error [1].

We along tried to start the mariadb service with the above "/opt/bitnami/ctlscript.sh", but that also failed. I went through the github link [2] for the same issue, but this doesn't have any clean steps to fix it.

Here, I conveyed that we (GCP support engineers) don't have much expertise on the wordpress bitnami related issue, so I suggested you reach bitnami support [3] or create the new github issue [4] to assist you further on this case.

Lastly, I also informed you that you will get the technical bitnami support if you directly use the wordpress bitnami from the cloud marketplace.

With this, I hope the above information helps to address your concern. Please feel free to reply back if you have any other questions or clarifications. I am glad to assist you.

Have a great day ahead!!

Reference:-


[1]
[   88.686518] bitnami[489]: [38;5;6mmariadb [38;5;5m05:39:32.40 [0m[38;5;1mERROR[0m ==> mariadb did not start
Jun 18 05:39:32 wordpress-bitnami-vm bitnami[489]: #033[38;5;6mmariadb #033[38;5;5m05:39:32.40 #033[0m#033[38;5;1mERROR#033[0m ==> mariadb did not start
[   88.687257] bitnami[489]: 2024-06-18T05:39:32.402Z - error: Unable to perform start operation Export start for mariadb failed with exit code 1
Jun 18 05:39:32 wordpress-bitnami-vm bitnami[489]: 2024-06-18T05:39:32.402Z - error: Unable to perform start operation Export start for mariadb failed with exit code 1
[   88.697173] bitnami[885]: ## 2024-06-18 05:39:32+00:00 ## INFO ## Running /opt/bitnami/var/init/post-start/010_bitnami_agent_extra...
Jun 18 05:39:32 wordpress-bitnami-vm bitnami[885]: ## 2024-06-18 05:39:32+00:00 ## INFO ## Running /opt/bitnami/var/init/post-start/010_bitnami_agent_extra...
[   88.715531] bitnami[885]: ## 2024-06-18 05:39:32+00:00 ## INFO ## Running /opt/bitnami/var/init/post-start/020_bitnami_agent...
Jun 18 05:39:32 wordpress-bitnami-vm bitnami[885]: ## 2024-06-18 05:39:32+00:00 ## INFO ## Running /opt/bitnami/var/init/post-start/020_bitnami_agent...
[   88.731620] bitnami[885]: ## 2024-06-18 05:39:32+00:00 ## INFO ## Running /opt/bitnami/var/init/post-start/030_update_welcome_file...
Jun 18 05:39:32 wordpress-bitnami-vm bitnami[885]: ## 2024-06-18 05:39:32+00:00 ## INFO ## Running /opt/bitnami/var/init/post-start/030_update_welcome_file...
[   88.734022] bitnami[885]: ## 2024-06-18 05:39:32+00:00 ## INFO ## Running /opt/bitnami/var/init/post-start/040_bitnami_credentials_file...
Jun 18 05:39:32 wordpress-bitnami-vm bitnami[885]: ## 2024-06-18 05:39:32+00:00 ## INFO ## Running /opt/bitnami/var/init/post-start/040_bitnami_credentials_file...
[   88.770467] bitnami[885]: ## 2024-06-18 05:39:32+00:00 ## INFO ## Running /opt/bitnami/var/init/post-start/050_clean_metadata...
Jun 18 05:39:32 wordpress-bitnami-vm bitnami[885]: ## 2024-06-18 05:39:32+00:00 ## INFO ## Running /opt/bitnami/var/init/post-start/050_clean_metadata...
Jun 18 05:39:32 wordpress-bitnami-vm systemd[1]: bitnami.service: Control process exited, code=exited, status=1/FAILURE
Jun 18 05:39:32 wordpress-bitnami-vm systemd[1]: bitnami.service: Failed with result 'exit-code'.

[2]
https://github.com/bitnami/vms/issues/87

[3]
https://bitnami.com/support/google

[4]
https://github.com/bitnami/vms/issues
==
gongomgra commented 3 months ago

@jsy11 we can't find the bndiagnostic data in our registries. Can you run the tool again and share the updated code with us?

jsy11 commented 3 months ago

The issue was out of space and outdated DB. the issue has been resolved.