search

bitnami / vms

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

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

Closed LuisArcos closed 5 months ago

LuisArcos commented 6 months ago

Name and Version

bitnami-wordpress-5-9-3-26-r15-linux-debian-10-x86-64-nami

What architecture are you using?

amd64

What steps will reproduce the bug?

i use Bitnami on Google Cloud Plaform

My site http://34.95.233.109/ it's broken with the "Error establishing a database connection" message, when I connected through SSH mysql -u root -p using the VM credentials shows the following error:

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

Tried to restart the service with sudo /opt/bitnami/ctlscript.sh restart mysql but doesn't work. It shows "Failed to restart mariadb: Failed to restart mariadb"

What do you see instead?

ERROR 2002 (HY000): Can't connect to local server through socket '/opt/bitnami/mariadb/tmp/mysql.sock' (111)
gongomgra commented 5 months ago

Hi @LuisArcos,

Can you run the bndiagnostic tool and share the generated code with us so we can take a look to the Bitnami services logs?

https://docs.bitnami.com/general/how-to/understand-bndiagnostic/

LuisArcos commented 5 months ago

The diagnostic bundle was uploaded successfully, here is the code: 32d814ff-2c3b-9860-b991-656104c9fbd1

This is the log file:

`2024-04-11 4:11:42 0 [Note] InnoDB: !!! innodb_force_recovery is set to 1 !!! 2024-04-11 4:11:42 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2024-04-11 4:11:42 0 [Note] InnoDB: Using transactional memory 2024-04-11 4:11:42 0 [Note] InnoDB: Number of pools: 1 2024-04-11 4:11:42 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2024-04-11 4:11:42 0 [Note] InnoDB: Using Linux native AIO 2024-04-11 4:11:42 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728 2024-04-11 4:11:42 0 [Note] InnoDB: Completed initialization of buffer pool 2024-04-11 4:11:42 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=3709806468,3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring unknown log record at LSN 3709806468 024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709806468 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring unknown log record at LSN 3709809015 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring unknown log record at LSN 3709809015 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709809015 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709809015 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709809015 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709809015 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709809015 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709809015 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709809015 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709809015 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709809015 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709809015 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709809015 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709809015 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709809015 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709809015 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709809015 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709809015 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709809015 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709809015 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709809015 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709809015 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709809015 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709809015 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709809015 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709809015 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709809015 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709809015 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709809015 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709809015 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709809015 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709809015 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709809015 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709809015 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709809015 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709809015 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709809015 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709817167 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 3709817167 2024-04-11 4:11:42 0 [Warning] InnoDB: Ignoring malformed log record at LSN 3709817167 2024-04-11 4:11:43 0 [ERROR] InnoDB: Missing FILE_CHECKPOINT at 3709806468 between the checkpoint 3709806468 a$ 2024-04-11 4:11:43 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2024-04-11 4:11:43 0 [Note] InnoDB: Starting shutdown... 2024-04-11 4:11:43 0 [ERROR] Plugin 'InnoDB' init function returned error. 2024-04-11 4:11:43 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2024-04-11 4:11:43 0 [Note] Plugin 'FEEDBACK' is disabled. 2024-04-11 4:11:43 0 [ERROR] Unknown/unsupported storage engine: InnoDB 2024-04-11 4:11:43 0 [ERROR] Aborting

gongomgra commented 5 months ago

Hi @LuisArcos,

Thanks for the info. According to the MariaDB logs, there is an issue with the MariaDB data and the service can't start. Did you perform any change in the server before getting this errors? We recommend you to create a server backup so you can easily restore the current state, and then look for help in a more specialized forums. Sorry for the inconveniences.

github-actions[bot] commented 5 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 5 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.