Mysql crashed due to interruption

Keywords: WordPress - Microsoft Azure - Technical issue - Other
bnsupport ID: 2b94561e-a9b3-a478-e410-f3aeca42c409
Description:
I restart my services, and now mysql is not running

Plz help me as soon as possible.

Hi @classicprogrammer15,

If you open the MySQL’s log file

https://docs.bitnami.com/azure/apps/wordpress/troubleshooting/debug-errors-mysql/

You can see this error message

2020-11-20T04:01:24.005221Z 1 [ERROR] [MY-012639] [InnoDB] Write to file ./ibtmp1 failed at offset 10485760, 1048576 bytes should have been written, only 499712 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.
2020-11-20T04:01:24.005324Z 1 [ERROR] [MY-012640] [InnoDB] Error number 28 means 'No space left on device'
2020-11-20T04:01:24.005528Z 1 [ERROR] [MY-012267] [InnoDB] Could not set the file size of './ibtmp1'. Probably out of disk space

As the error message says, the instance ran out of space

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

Output:

Filesystem      Size  Used Avail Use% Mounted on
udev            1.7G     0  1.7G   0% /dev
tmpfs           345M   35M  310M  11% /run
/dev/sda1        30G   28G     0 100% /
tmpfs           1.7G     0  1.7G   0% /dev/shm
tmpfs           5.0M     0  5.0M   0% /run/lock
tmpfs           1.7G     0  1.7G   0% /sys/fs/cgroup
/dev/sda15      124M  262K  124M   1% /boot/efi
/dev/sdb1        49G   53M   47G   1% /mnt/resource
tmpfs           345M     0  345M   0% /run/user/1000

It seems MySQL is using most of the data and that’s because of the binary logging

-----------------------------------
Find biggest directories in installdir
-----------------------------------
Running: du -h . -d 1 | sort -h
In: /opt/bitnami

Output:

8.0K__./img
52K_./config
108K__./var
132K__./scripts
1.6M__./licenses
3.0M__./stats
3.6M__./sqlite
3.6M__./varnish
4.2M__./bnhelper
27M_./bncert
32M_./letsencrypt
63M_./bnsupport
82M_./php
145M__./common
149M__./apache2
1.3G__./apps
25G_./mysql
27G_.

You can disable and remove them by following this guide

https://docs.bitnami.com/azure/apps/wordpress/troubleshooting/disable-binary-logging-mysql/

Happy to help!


Was my answer helpful? Click on :heart:

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