PDA

View Full Version : 2 triggers on same key...causes "Unable to get value for functionid"


dp4
23-12-2005, 04:20
1.1beta4

"014758:20051222:191900 Expression [{11214}>10] cannot be evaluated [Unable to get value for functionid [11214]]"

i have not read the code, but i got this error in the server log when i added a 2nd trigger on one of my keys for the same host. i looked at the data in functions and found duplicate itemids. i'm assuming that the code expects this to be a unique key (does mysql support unique keys?)

anyway, i deleted the triggers and now the errors are gone and zabbix appears to be happy again.

so is this a bug or is it by design?...that you cannot have 2 triggers on the same key?

thanks

Alexei
23-12-2005, 07:27
This is perfercly OK. You may have N triggers using the same key(s). Not sure what caused the problem though...