ZABBIX STOPPED WITH MYSQL NO SPACE LEFT ERROR CODE:28

[admin]

About Zabbix
Zabbix is an open source network status monitoring tool used to monitor, servers, virtual machines, and cloud services etc. There are different protocols used by zabbix to collect information, normal way is SNMP(Simple Networking Monitoring Protocol). Those devices which doesn't have inbuilt defined agent, zabbix has its active agent which when installed communicate with server and update statuses.
Here is the link for details about zabbix: https://www.zabbix.com/.

Mysql Error
There is a limit for database size in zabbix setting.If the size increases beyond specified size zabbix stop collecting information. To avoid this some users used to increase limit in setting. But when size reaches beyond hard disk capacity, mysql stopped with error code:28(No space left in device).
I prefer to run zabbix in virtual machine in oracle virtualbox. If such problem is there that can be solved in following way.

1. Increase size of hard disk in virtual machine. Detail guide link is: https://www.howtogeek.com/124622/how-to ... or-vmware/.
2. Then using linux gparted resize the partition carrying /var/lib.mysql.

Code: Select all

parted

Code: Select all

print

Detect file system.

Code: Select all

-s /dev/sda resizepart 4 100%

Code: Select all

Yes

Code: Select all

-s /dev/sda resizepart 5 100%

Code: Select all

Yes

3. For file system type ext3 and ext4:

Code: Select all

resizes2fs /dev/sda5

For file system type xfs

Code: Select all

xfs_growfs /dev/sda5

4. Reboot
5. Check partitions using

Code: Select all

df -h

Now you will see the sda5 size increased.