[Z3005] query failed: [1114] The table 'history_uint' is full

[Alfista]

Hi,

I use Zabbix 3.4.5 appliance and today i receive this error message in Zabbix front end:

• mysqli_query(): (HY000/3): Error writing file '/tmp/MY4vhsPE' (Errcode: 28 - No space left on device) [hosts.php:1128 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CTrigger->get() → DBselect() → mysqli_query() in include/db.inc.php:364]
• Error in query [SELECT DISTINCT COUNT(DISTINCT t.triggerid) AS rowscount,i.hostid FROM triggers t,functions f,items i WHERE (i.hostid BETWEEN '10364' AND '10368' OR i.hostid IN ('10084','10291','10320','10329','10330','10333',' 10334','10335','10336','10342','10344','10398','10 404')) AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND t.flags IN ('0','4') GROUP BY i.hostid] [Error writing file '/tmp/MY4vhsPE' (Errcode: 28 - No space left on device)]

In logs was:

[Z3005] query failed: [1114] The table 'history_uint' is full [insert into history_uint (itemid,clock,ns,value) values (...

I found that the device /dev/mapper/zabbix--vg-root is full.

I tried to run houskeeper but without any change. I use the Appliance for about 2 months only and only with about 10 monitored devices, while I learn it and try to configure it.

Please can one help me how can I extend it size, or what i need to do that it work again?

Thanks for help

[kloczek]

Your db just reached size of the available storage on the db backend host.
BTW: you should have implemented dis space monitoring to receive early alarms about shortage available to use disk space.

[Alfista]

Hi Kloczek,

I'm new in Zabbix, I only learn it.
Please is possible to tell me how to extend the database capacity and also as I can monitor the DB storage size, while the zabbix has full only 50% of his storage.

Thanks.