"Unable to get value for functionid"

[just2blue4u]

I constantly get this errors in my server.log:

010236:20061127:104138 Evaluation of expression [{11528}=0] failed [Unable to get value for functionid [11528]]
010236:20061127:104138 Expression [{11528}=0] cannot be evaluated [Unable to get value for functionid [11528]]
010236:20061127:104138 Evaluation of expression [{11514}=0] failed [Unable to get value for functionid [11514]]
010236:20061127:104138 Expression [{11514}=0] cannot be evaluated [Unable to get value for functionid [11514]]
010236:20061127:104138 Evaluation of expression [{11536}=0] failed [Unable to get value for functionid [11536]]
010236:20061127:104138 Expression [{11536}=0] cannot be evaluated [Unable to get value for functionid [11536]]
010236:20061127:104138 Evaluation of expression [{11545}=0] failed [Unable to get value for functionid [11545]]
010236:20061127:104138 Expression [{11545}=0] cannot be evaluated [Unable to get value for functionid [11545]]
010236:20061127:104138 Evaluation of expression [{11554}=0] failed [Unable to get value for functionid [11554]]
010236:20061127:104138 Expression [{11554}=0] cannot be evaluated [Unable to get value for functionid [11554]]
010236:20061127:104138 Evaluation of expression [{11563}=0] failed [Unable to get value for functionid [11563]]
010236:20061127:104138 Expression [{11563}=0] cannot be evaluated [Unable to get value for functionid [11563]]

After searching this board, it seems to be a problem with my triggers and templates. As the found posts are a bit old and not really helpful, i think it's the best to mention this issue again.

So how can i get rid of this lines?
The Function ID belongs to icmpping, which is in my default template and is inherited by every other template.

Server is V1.1.3

Thx 4 reading!

[amcorreia]

well,

I get same messages.
And zabbix shutdown after this.

[just2blue4u]

My Zabbix keeps running, but it fills the logfile with this ugly crap...

"Help!"

[netod]

I constantly get this errors in my server.log:


After searching this board, it seems to be a problem with my triggers and templates. As the found posts are a bit old and not really helpful, i think it's the best to mention this issue again.

So how can i get rid of this lines?
The Function ID belongs to icmpping, which is in my default template and is inherited by every other template.

Server is V1.1.3

Thx 4 reading!

As far as I know zabbix 1.1.x doesn't support many to many template relationships... Could be wrong though. Alexi can you clarify?

[just2blue4u]

My templates are created as follows:

standard
 |- Windows
 |- Linux
     |- Web
     |- Mail
     |- Databases

So it's only 3 Layers. I don't think this is the problem.
How many "generations" may I set up?

[MGajardo]

Unable to get value for functionid

same thing here....

005216:20061207:145816 Evaluation of expression [{21805}>1] failed [Unable to get value for functionid [21805]]
005216:20061207:145816 Expression [{21805}>1] cannot be evaluated [Unable to get value for functionid [21805]]
005216:20061207:145818 Evaluation of expression [{21817}>1] failed [Unable to get value for functionid [21817]]
005216:20061207:145818 Expression [{21817}>1] cannot be evaluated [Unable to get value for functionid [21817]]
005216:20061207:145819 Evaluation of expression [{21811}>1] failed [Unable to get value for functionid [21811]]
005216:20061207:145819 Expression [{21811}>1] cannot be evaluated [Unable to get value for functionid [21811]]

Please, does anyone could you tell me what happen?

This is my trigger: {SNMP_t:lcpuPercentBusy.delta(0)}>1

I am using version 1.1.4.-

[fmtaylor2]

I do this

to get rid of the messages..

[root@bofh zabbix]# mysql -uUSERID -pXXXXX

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 718052 to server version: 4.1.20

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use zabbix

Database changed
mysql> update functions set lastvalue=0 where lastvalue is null \g

[just2blue4u]

Thank you very much!

Now my log looks much nicer! The Error has gone.

But nevertheless I must warn everyone who wants to follow the workaround above:
Be clever and turn off all user's media in zabbix before updating the DB table: In my case the trigger that produced the errors became true ( -> alert!!! ) and i got email for every host which had the trigger!
After deactivating and activating the trigger again, everything was good again.

That was kind of shocking!

[just2blue4u]

I'm sorry i must tell you that this workaround has its issues...

A few minutes ago i added a new host into monitoring, which got the trigger, too.
As soon as the first values were in, the trigger became active.
I had to modify the trigger's expression and then set the old expr. again to get it false again.

Here's my trigger expression! Perhaps someone has a clue?

{tmpl_ux:system.cpu.util[,idle].avg(300)}<5 | {tmpl_ux:system.cpu.load.last(0)} > 15 | {tmpl_ux:system.cpu.load.avg(300)}>10

==============================


Update:
After i had temporarily changed the expression, i started the zabbix_agent of 2 of my monitored hosts. Yesterday (when i modified the MySQL-Table) these hosts were offline. Now the interesting thing:
I expected the trigger to become true again, as it did when the new created host came up (see above). But the trigger kept false for both hosts i started.
Is this because that hosts already had values in DB which just were a bit old, or is it any kind of odd behaviour?

[just2blue4u]

when i looked into my server.log today, i had to realize, that the errors are logged again.
This time it was always the same functionid. after some mysql-querying, i found out it belongs to a new host, added after i updated the db with the statement above.

Now my question:
May i change the table "functions" so that the default value for "lastvalue" isn't NULL but "0" ? or should i better let it be?

[mike_k]

I got same messages in log too. That sql statement fixed already existing functions, but every function change (zabbix creates new one, not modifying existing) or trigger add results in trigger state being 'unknown' because it contains NULL, not '0'.

That began happening at some point between upgrades maybe...
Is it a bug? Can it be fixed in zabbix source code?

[MGajardo]

No actions found

to get rid of the messages..

[root@bofh zabbix]# mysql -uUSERID -pXXXXX

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 718052 to server version: 4.1.20

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use zabbix

Database changed
mysql> update functions set lastvalue=0 where lastvalue is null \g

Thanks fmtaylor2, no more log error but, a new problem I am getting on, No actions found ! when the trigger get ON, I should receive an email, but it is not working. <br>I checked Action/Send message and I do not detected problem. I also checked postfix and from shell I could mailing to me, I checked mail log and there were not register from zabbix<br>
Please, help me !

[RobertS]

Is there already a solution for the problem? Is there somebody who can answer the question from just2blue4u?

May i change the table "functions" so that the default value for "lastvalue" isn't NULL but "0" ? or should i better let it be?

I dont like to enter the SQL statement every time a trigger is added or changed.

[scott]

Any Updates?

Thanks to all who have worked on this issue.

I am currently running v1.1.5 on BSD and am experiencing this issue. Is the workaround posted above the best option at this point in time? Any plans to repair this in 1.4?

[tpyro]

Sorry for the me-too post, but "me too"! I can't trust that my notifications will be sent. This is version 1.1.6.

Also I had renamed a trigger but the old name sticks in the Overview and Latest Data screens (even though the Latest Data does update).

014830:20070330:172113 Expression [{11276}#1] cannot be evaluated [Unable to get value for functionid [11276]]

Will do any troubleshooting/testing necessary to help resolve this!

Thanks...