Solution: Zabbix 4.0.1 export template - nothing happens

IT & Software | Other
  • 5.0 (1 ratings)
Last updated 11/2018
Description
I see the error in the log:

 17977:20181122:113307.391 enabling Zabbix agent checks on host "zabbix-server": host became available
 17960:20181122:120113.352 executing housekeeper
 17960:20181122:120113.356 housekeeper [deleted 0 hist/trends, 0 items/triggers, 0 events, 0 problems, 0 sessions, 0 alarms, 0 audit items in 0.001972 sec, idle for 1 hour(s)]
 17960:20181122:130113.886 executing housekeeper
 17960:20181122:130113.889 housekeeper [deleted 0 hist/trends, 0 items/triggers, 0 events, 0 problems, 0 sessions, 0 alarms, 0 audit items in 0.001933 sec, idle for 1 hour(s)]
 17976:20181122:132758.383 [Z3005] query failed: [1] Can't create/write to file '/var/tmp/#sql_4588_0.MAI' (Errcode: 2) [select distinct t.triggerid,t.description,t.expression,t.status,t.type,t.priority,t.comments,t.url,t.recovery_expression,t.recovery_mode,t.correlation_mode,t.correlation_tag,t.manual_close from triggers t,functions f,items i,item_discovery id where t.triggerid=f.triggerid and f.itemid=i.itemid and i.itemid=id.itemid and id.parent_itemid=23278]
 17972:20181122:132759.379 [Z3005] query failed: [1] Can't create/write to file '/var/tmp/#sql_4588_0.MAI' (Errcode: 2) [select distinct t.triggerid,t.description,t.expression,t.status,t.type,t.priority,t.comments,t.url,t.recovery_expression,t.recovery_mode,t.correlation_mode,t.correlation_tag,t.manual_close from triggers t,functions f,items i,item_discovery id where t.triggerid=f.triggerid and f.itemid=i.itemid and i.itemid=id.itemid and id.parent_itemid=23279]
 17960:20181122:140114.423 executing housekeeper
 17960:20181122:140114.426 housekeeper [deleted 0 hist/trends, 0 items/triggers, 0 events, 0 problems, 0 sessions, 0 alarms, 0 audit items in 0.002069 sec, idle for 1 hour(s)]
 17973:20181122:142758.247 [Z3005] query failed: [1] Can't create/write to file '/var/tmp/#sql_4588_0.MAI' (Errcode: 2) [select distinct t.triggerid,t.description,t.expression,t.status,t.type,t.priority,t.comments,t.url,t.recovery_expression,t.recovery_mode,t.correlation_mode,t.correlation_tag,t.manual_close from triggers t,functions f,items i,item_discovery id where t.triggerid=f.triggerid and f.itemid=i.itemid and i.itemid=id.itemid and id.parent_itemid=23278]
 17972:20181122:142759.249 [Z3005] query failed: [1] Can't create/write to file '/var/tmp/#sql_4588_0.MAI' (Errcode: 2) [select distinct t.triggerid,t.description,t.expression,t.status,t.type,t.priority,t.comments,t.url,t.recovery_expression,t.recovery_mode,t.correlation_mode,t.correlation_tag,t.manual_close from triggers t,functions f,items i,item_discovery id where t.triggerid=f.triggerid and f.itemid=i.itemid and i.itemid=id.itemid and id.parent_itemid=23279]
 17960:20181122:150114.954 executing housekeeper
 17960:20181122:150114.957 housekeeper [deleted 0 hist/trends, 0 items/triggers, 0 events, 0 problems, 0 sessions, 0 alarms, 0 audit items in 0.002040 sec, idle for 1 hour(s)]
 17976:20181122:152758.109 [Z3005] query failed: [1] Can't create/write to file '/var/tmp/#sql_4588_0.MAI' (Errcode: 2) [select distinct t.triggerid,t.description,t.expression,t.status,t.type,t.priority,t.comments,t.url,t.recovery_expression,t.recovery_mode,t.correlation_mode,t.correlation_tag,t.manual_close from triggers t,functions f,items i,item_discovery id where t.triggerid=f.triggerid and f.itemid=i.itemid and i.itemid=id.itemid and id.parent_itemid=23278]
 17975:20181122:152759.112 [Z3005] query failed: [1] Can't create/write to file '/var/tmp/#sql_4588_0.MAI' (Errcode: 2) [select distinct t.triggerid,t.description,t.expression,t.status,t.type,t.priority,t.comments,t.url,t.recovery_expression,t.recovery_mode,t.correlation_mode,t.correlation_tag,t.manual_close from triggers t,functions f,items i,item_discovery id where t.triggerid=f.triggerid and f.itemid=i.itemid and i.itemid=id.itemid and id.parent_itemid=23279]
 17960:20181122:160115.478 executing housekeeper
 17960:20181122:160115.481 housekeeper [deleted 0 hist/trends, 0 items/triggers, 0 events, 0 problems, 0 sessions, 0 alarms, 0 audit items in 0.002099 sec, idle for 1 hour(s)]
 17976:20181122:162758.983 [Z3005] query failed: [1] Can't create/write to file '/var/tmp/#sql_4588_0.MAI' (Errcode: 2) [select distinct t.triggerid,t.description,t.expression,t.status,t.type,t.priority,t.comments,t.url,t.recovery_expression,t.recovery_mode,t.correlation_mode,t.correlation_tag,t.manual_close from triggers t,functions f,items i,item_discovery id where t.triggerid=f.triggerid and f.itemid=i.itemid and i.itemid=id.itemid and id.parent_itemid=23278]
 17973:20181122:162759.986 [Z3005] query failed: [1] Can't create/write to file '/var/tmp/#sql_4588_0.MAI' (Errcode: 2) [select distinct t.triggerid,t.description,t.expression,t.status,t.type,t.priority,t.comments,t.url,t.recovery_expression,t.recovery_mode,t.correlation_mode,t.correlation_tag,t.manual_close from triggers t,functions f,items i,item_discovery id where t.triggerid=f.triggerid and f.itemid=i.itemid and i.itemid=id.itemid and id.parent_itemid=23279] 
Attachments
No attachments.
Solutions
Reboot machine and try again..
on November 23rd, 2018 (9:54 pm)
What masters said
You must sign in to comment!!
All comments
After restart log ok. Thanks
on November 25th, 2018 (9:55 pm)
We use cookies to give you the best possible experience on our site. By continuing to use the site you agree to our use of cookies. Find out more Accept