My AWS Lightsail WP server crashes very often. when I check the reason, it shows the storage is full even not used

kiran 2020-03-18 11:52:34 UTC #1

Keywords: WordPress - AWS - Technical issue - Other
bnsupport ID: 544586ac-9775-9b4c-3eec-71ac70650ead
Description:
AWS Lightsail Bitnami server crashes very often saying no memory left, but its a very simple website and we haven't used 75% of the total space available in the server.
I'm able to restart the server after deleting some files using FTP, but same issue happens after few days, crashes again and not able to restart the server saying no space left.

What might be the reason for this auto-populated data usage?
How can I fix it?
Support Code: 544586ac-9775-9b4c-3eec-71ac70650ead

after runnig df -i, response:

Filesystem Inodes IUsed IFree IUse% Mounted on
udev 60319 324 59995 1% /dev
tmpfs 62293 444 61849 1% /run
/dev/xvda1 2560000 342784 2217216 14% /
tmpfs 62293 1 62292 1% /dev/shm
tmpfs 62293 3 62290 1% /run/lock
tmpfs 62293 16 62277 1% /sys/fs/cgroup
/dev/loop0 15 15 0 100% /snap/amazon-ssm-agent/1480
/dev/loop2 12847 12847 0 100% /snap/core/8689
/dev/loop3 12846 12846 0 100% /snap/core/8592
/dev/loop4 15 15 0 100% /snap/amazon-ssm-agent/1566
tmpfs 62293 4 62289 1% /run/user/1000

AWS Lightsail Wordpress instance unresponsive

MySQL Is not running.?

Bitnami + AWS + Wordpress NGINX + Mysql couldn't be started

kiran 2020-03-25 12:53:08 UTC #2

Can any one give a solution to solve this issue?

gongomgra 2020-03-25 17:06:01 UTC #3

Hi @kiran,

I checked your bnsupport bundle and according to it, your server is running out of space. Please note the command to check the actual disk space is the one below.

df -h

The command df -i shows the usage/availability of i-nodes, which is a different property of the system.

According to the bnsupport bundle, the /opt/bitnami/mysql directory's size is 14 GB out of the 20 GB of your disk space. Can you run the commands below to check which folder in the MySQL installation is the biggest one? Can you also run it into the new biggest directory?

cd /opt/bitnami/mysql
sudo du -h . -d 1 | sort -h

Apart from that, this error is usually related to WordPress plugins. Some plugins use the MySQL database as temporal storage and they do not properly clean it after that. Can you check your plugins? I see you have many plugins installed on your site.

kiran 2020-04-03 02:00:43 UTC #4

Hi gongomgra,

Thanks for your response. I checked and the results in attached screenshot.

It showing huge usage in MySQL->lib->mecab folder.

I have inactivated all the unnecessary plugins.

Could you suggest how to fix it?

Thanks,

Kiran

gongomgra 2020-04-03 09:47:56 UTC #5

Hi @kiran,

Sorry, I sent you a wrong command (it needs higher privileges). Can you run the command below? It should detect that the data directory is the biggest one inside the /opt/bitnami/mysql folder.

cd /opt/bitnami/mysql
sudo du -h . -d 1 | sort -h
cd /opt/bitnami/mysql/data
sudo du -h . -d 1 | sort -h

kiran 2020-04-04 06:02:16 UTC #6

Hi gongomgra,

I'm not able to access the data folder as showing permission denied.

Not able to change the permission as well, could help me how to fix it?

Screenshot attached.

Thanks,

Kiran

gongomgra 2020-04-06 09:40:13 UTC #7

Hi @kiran,

Can you try this command?

sudo du -h /opt/bitnami/mysql/data -d 1 | sort -h

kiran 2020-04-06 10:13:12 UTC #8

Hi,

Please find the output attached.

Thanks again,

Kiran

gongomgra 2020-04-06 10:24:38 UTC #9

Hi @kiran,

Can you run it one more time against the bitnami_wordpress folder to see the size of the files inside it?

sudo du -h /opt/bitnami/mysql/data/bitnami_wordpress

kiran 2020-04-06 10:59:29 UTC #10

Sure, please find the attached screenshot

gongomgra 2020-04-06 12:13:26 UTC #11

Hi @kiran,

I'd like to get the size of the files into that directory. Could you try running the next command?

sudo ls -larth /opt/bitnami/mysql/data/bitnami_wordpress/

kiran 2020-04-06 12:44:37 UTC #12

Thank you very much for your ongoing support.

Please find the attached screenshots.

Thanks,

kiran

gongomgra 2020-04-07 10:08:14 UTC #13

Hi @kiran,

Thanks for the screenshots. As you can see, the wp_options table is 13GB size. This is usually due to some plugins using it as temporary cache and not cleaning it after. You will need to identify which of your plugins is causing this and contact with its developers for help on how to prevent this.

kiran 2020-04-10 09:28:40 UTC #14

Hi,

Thanks for your help.

I removed all unwanted plugins, but still its crashing, I don't know how to fix this or find which plugin making the trouble.

Could you suggest me how to find which plugin is the trouble maker here?

It will be great help as nowadays website crashing everyday and no unwanted files left to delete to make extra space to restart the server.

I'm using same template and plugins in other 3-4 website and non of them having such issues since last 2 Years other than this one

Thanks,

Kiran

kiran 2020-04-10 10:45:04 UTC #15

Hi,

After using WP-Optimizer and Delete Expired Transients plugins, size reduced, but dont know if it bloat again.

Thanks,

Kiran

gongomgra 2020-04-13 08:40:35 UTC #16

Hi @kiran,

According to that screenshot, I think everything is fine now. Are you still facing issues?

kiran 2020-04-15 01:12:13 UTC #17

Hi,

So far its looking good.

Seems WP-Optimize plugin helping to fix it and check daily to optimise the table size.

Screenshot attached.

Thank you for your help and really appreciate your timely support.

Thanks,

Kiran

I install some plugin and now website is showing error Error 522

gongomgra 2020-04-15 08:57:21 UTC #18

Hi @kiran,

Thanks for the info. I'm glad you fixed your issue! We will close this thread as solved. Please do not hesitate to open a new one with any other questions you may have.

gongomgra 2020-04-15 08:57:26 UTC #19

Bitnami provides free all-in-one installers, virtual machines and cloud images for popular open source applications. Get them now!