Update interval for discovery item prototype not working

[dwoodwoo]

Hello,

I'm using Zabbix 3.2.6. I have a database monitor discovery rule to find all non-model databases on SQL Server (select name AS dbname from sysdatabases where name != 'model'). The update interval is set to 3600s. This is working fine.

I'm trying to set a 300s update interval for an item prototype; however, it seems to be ignored. There is no custom interval defined. To prove it's not working ... I created a simple test item prototype:

Name: {#DBNAME} foo
Type: Database monitor
Key: db.odbc.select[foo_{#DBNAME},{HOST.NAME}]
SQL query: insert into foo values('{#DBNAME}',GetDate())
Update interval: 300

Results on SQL Server:

select TOP 5 * from foo where dbname = 'master' order by cdate desc

dbname cdate
master 2017-08-30 22:13:56.877
master 2017-08-30 22:12:56.723
master 2017-08-30 22:11:56.050
master 2017-08-30 22:10:56.633
master 2017-08-30 22:09:56.210

As you can see, it's running every minute, so the 300s update interval seems to be ignored. What am I doing wrong?

Thank you! David

[dwoodwoo]

I also tried:

• setting the update interval to 0
• creating a custom scheduling interval: m/5

Results are the same as before, it's running every minute, instead of every 5 minutes.

Any ideas?

[allexpetrov]

Have you tried to use flexible?

Interval: 300 Period: 1-7,00:00-24:00, also your Items would be recreated on the next LLD run.

Regards,
Alex!