Solution: Zabbix 4.0.1 export template - nothing happens

IT & Software | Other
5.0 (1 ratings)
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
Description
Reboot machine and try again..
on November 23rd, 2018 (9:54 pm)
All coments
After restart log ok. Thanks
on November 25th, 2018 (9:55 pm)
Good work. Thank you.
on January 01st, 2019 (5:42 pm)
You must sign in to comment!! LOGIN
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