"Unable to get value for functionid"

[MrKen]

Funny, it's gone away in 1.6 on my setup. I'm running the stable 6169 build right now. Well worth getting a very recent build.

- cal

Strange how these things affect some people and not others. Leads me to wonder if this could be a problem with my Mysql and how it deals with NULL values.
I'd be interested to here from others with or without this problem who are using the same mysql as me.

On Zabbix 1.4.2 => mysql Ver 14.12 Distrib 5.0.22
On Zabbix 1.6 => mysql Ver 14.12 Distrib 5.0.45

MrKen

[tekknokrat]

Strange how these things affect some people and not others. Leads me to wonder if this could be a problem with my Mysql and how it deals with NULL values.
I'd be interested to here from others with or without this problem who are using the same mysql as me.

On Zabbix 1.4.2 => mysql Ver 14.12 Distrib 5.0.22
On Zabbix 1.6 => mysql Ver 14.12 Distrib 5.0.45

MrKen

also an issue with postgresql:

  6421:20081017:144647 Expression [{12493}>0] cannot be evaluated [Unable to get function value: function.lastvalue IS NULL for functionid [12493]]
  6419:20081017:144648 Sending configuration data to proxy. Datalen 22630
  6421:20081017:144652 Expression [{12483}>0] cannot be evaluated [Unable to get function value: function.lastvalue IS NULL for functionid [12483]]
  6421:20081017:144652 Expression [{12481}>0] cannot be evaluated [Unable to get function value: function.lastvalue IS NULL for functionid [12481]]

Did someone just did a check what kind of functions these are? I have userdefined which give back multiline text.

[MrKen]

[/code]Did someone just did a check what kind of functions these are?

Found this on another thread when I was resolving this problem.

You could check:
select * from functions where functionid = 12493; [* to get itemid *]
select * from items where itemid = "itemid-from-above";
Look at hostid, description and key_.
select * from hosts where hostid = "hostid-from-above";

Now you should know what function isn't available to trigger evaluation
on which host.

MrKen

[Daniel Carnevalli]

I have the zabbix 1.6.1 and the same problem occurs.

I don't know what I do. The first solution may be ok, but we need to execute every tim we add a new trigger.

Anyone resolved definitely?

Tks\