-
Incident report
-
Resolution: Cannot Reproduce
-
Minor
-
None
-
1.8.14
-
None
Changing application name in template linked to many hosts generates message:
Application updated:
[...]
Application "hd302:Memory" updated
Application "hd369:Memory" updated
No host with with hostid=[10815]
There a few such hostsid in the message.
There is no "hostid" 10815 in DB "hosts" table:
> select * from hosts where hostid = 10815;
Empty set (0.00 sec)
There are records with "hostid" 10815 in the "applications" table:
> select * from applications where hostid = 10815;
-------------------------------------------+
applicationid | hostid | name | templateid |
-------------------------------------------+
30305 | 10815 | CPU | 13938 |
30307 | 10815 | FTP | 28947 |
30308 | 10815 | HTTP | 26690 |
30310 | 10815 | LXC | 26059 |
30311 | 10815 | memory | 13941 |
30312 | 10815 | MTA | 26842 |
30313 | 10815 | MySQL | 26994 |
30314 | 10815 | MySQL stats | 13942 |
30315 | 10815 | netstat | 13943 |
30316 | 10815 | network eth0 | 13944 |
30318 | 10815 | Performance | 13946 |
30319 | 10815 | PgSQL | 28467 |
30323 | 10815 | swap | 25766 |
-------------------------------------------+
How to manually fix the problem?
Is it enough to:
delete from applications where hostid = 10815;
?