Establishing a database connection Error

Keywords: WordPress - AWS - Technical issue - Permissions
bnsupport ID: 1e650e40-18c5-90f2-fa59-241d7715eeb5
Description:
Hi,
My site was working well. Then came the shocking problem, (Error establishing a database connection). Please help to solve this problem.

Hello @zaheera569,

The error is caused by insufficient space. Looking at your free space, your disk is almost full: You could try to increase your instance’s storage.

Filesystem      Size  Used Avail Use% Mounted on
/dev/xvda1      9.7G  9.3G     0 100% /

You will need to increase your storage space. We have a guide on how to Modify Elastic Block Storage (EBS) Volumes For Bitnami Applications On AWS that may be of help.

Regards,
Francisco de Paz

Sir, my hosting space 100GB.

Hello @zaheera569,

Are you sure the bnsupport ID corresponds to the affected instance? In the report it seems clear the issue is coming from not having space left with the instance’s space being 10GB:

-----------------------------------
Check free amount of disk space
-----------------------------------
Running: df -h
In: /opt/bitnami

Output:

Filesystem      Size  Used Avail Use% Mounted on
udev            486M     0  486M   0% /dev
tmpfs            99M  2.9M   96M   3% /run
/dev/xvda1      9.7G  9.3G     0 100% /
tmpfs           494M     0  494M   0% /dev/shm
tmpfs           5.0M     0  5.0M   0% /run/lock
tmpfs           494M     0  494M   0% /sys/fs/cgroup
/dev/xvda15     124M  278K  124M   1% /boot/efi
tmpfs            99M     0   99M   0% /run/user/1000

From MySQL’s logs we obtain the following error:

2021-04-02T05:24:06.623514Z 0 [System] [MY-010116] [Server] /opt/bitnami/mysql/bin/mysqld.bin (mysqld 8.0.23) starting as process 4960
2021-04-02T05:24:06.633044Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-04-02T05:24:07.006999Z 1 [Warning] [MY-012638] [InnoDB] Retry attempts for writing partial data failed.
2021-04-02T05:24:07.007142Z 1 [ERROR] [MY-012639] [InnoDB] Write to file ./ibtmp1 failed at offset 0, 1048576 bytes should have been written, only 0 were written. Operating system error number 28. Check that your OS and file system support files of this size. Check also that the disk is not full or a disk quota exceeded.
2021-04-02T05:24:07.007261Z 1 [ERROR] [MY-012640] [InnoDB] Error number 28 means 'No space left on device'
2021-04-02T05:24:07.007482Z 1 [ERROR] [MY-012267] [InnoDB] Could not set the file size of './ibtmp1'. Probably out of disk space
2021-04-02T05:24:07.007596Z 1 [ERROR] [MY-012926] [InnoDB] Unable to create the shared innodb_temporary.
2021-04-02T05:24:07.007716Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2021-04-02T05:24:07.245773Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2021-04-02T05:24:07.246054Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2021-04-02T05:24:07.246324Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-04-02T05:24:07.246880Z 0 [System] [MY-010910] [Server] /opt/bitnami/mysql/bin/mysqld.bin: Shutdown complete (mysqld 8.0.23)  MySQL Community Server - GPL.

You can check your instance’s space by running:

sudo df -h

Regards,
Francisco de Paz

New bnsupport ID: cfb8d0f7-68d9-013e-e921-6e4ec91ddf70

i run the commend. sudo df -h

Please check screenshoot:

And Root file i snot open:

Sir, I have connected Aws hosting to Bitnami Cloud Hosting. Where you can see everything. Please solve the problem.

Hello @zaheera569,

The last bnsupport ID indeed has 100GB of space. I have looked into the configuration and all the services seem to be up and running, with your website been reachable and working properly but your wp_options table seems to be corrupted and needs to be repaired:

2021-04-06T11:31:32.110016Z 191 [ERROR] [MY-013134] [Server] Table './bitnami_wordpress/wp_options' is marked as crashed and should be repaired
2021-04-06T11:31:59.658909Z 192 [ERROR] [MY-013134] [Server] Table './bitnami_wordpress/wp_options' is marked as crashed and should be repaired

Could you check this other post in this community forum and try repairing the affected table?

Regards,
Francisco de Paz

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.