Zabbix stopped working: Database error, connection refused

[Ikram SLIMANI]

Hello,

I have installed Zabbix and adding few nodes that generate large amount of traffic.
When I try to login I get "database error: connection refused" error on the login page.
I have logged into zabbix VM and can see mysql is out of space and the harddrive went full.
Then I restarted the system. Nothing happened, just a blinking cursor after the screen went black.
Then turned off the power and added 4 extra GB RAM and changed the harddrive space from 50 to 100 GB.
And each time the harddrive went full.
I went through many forums and I followed every recommendation but none of them could solve my issue.
Please find attached the output of the Zabbix logs size.
Thanks for any help!

[Ikram SLIMANI]

Any help !!

[tim.mooney]

I have installed Zabbix and adding few nodes that generate large amount of traffic.
When I try to login I get "database error: connection refused" error on the login page.
I have logged into zabbix VM and can see mysql is out of space and the harddrive went full.
Then I restarted the system. Nothing happened, just a blinking cursor after the screen went black.
Then turned off the power and added 4 extra GB RAM and changed the harddrive space from 50 to 100 GB.
And each time the harddrive went full.
I went through many forums and I followed every recommendation but none of them could solve my issue.
Please find attached the output of the Zabbix logs size.
Thanks for any help!

If part of the problem is that the log files in /var/log/zabbix are taking up a lot of space and it's filling your /var volume, then remove the log files, at least the old ones (anything with a number or number.gz appended to the log file). You can download them to your PC if you want to save them and review their contents, but you don't need to keep the old log files on the Zabbix server.

If the filesystem when your active database has its database files became completely full, then the database may have corruption issues. You generally want to try avoid filling up a volume containing an active database. Perhaps monitor the % free space on that volume.

If you grew the size of the VM's disk volume after it was created, that is probably only the first step in what you need to do to get more space within the Linux install. The filesystems that were originally created on the Linux install don't automatically grow to take up additional space when the VM disk volume grows. You need to use Linux tools to expand one or more of the filesystems within the install.

If you search these forums and other places using your favorite web search engine, you want to search for documentation on how to grow or resize a Linux filesystem after expanding VM disk. There are examples elsewhere in these forums of people using a bootable ISO containing 'gparted' to boot into a "live image" that can help with resizing the partitions on an existing VM.