failed to update local proxy configuration copy: invalid table name "interface_snmp"

[ruicruz]

Hello Everybody,

After updating my Zabbix Server and Zabbix Proxy on one of my customers, i started having the following issue:

29619:20200324:153428.729 received configuration data from server at "zabbix_server", datalen 310664
29619:20200324:153428.731 failed to update local proxy configuration copy: invalid table name "interface_snmp"

Also on another Proxy i get this:
3163:20200324:154546.308 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix_proxy`.`interface_snmp`, CONSTRAINT `c_interface_snmp_1` FOREIGN KEY (`interfaceid`) REFERENCES `interface` (`interfaceid`) ON DELETE CASCADE) [insert into interface_snmp (interfaceid,version,bulk,community,securityname,s ecuritylevel,authpassphrase,privpassphrase,authpro tocol,privprotocol,contextname) values (120,2,1,'{$SNMP_COMMUNITY}','',0,'','',0,0,''),(1 21,2,1,'{$SNMP_COMMUNITY}','',0,'','',0,0,'');

I am not being able to monitor anything behind the proxies due to this.

Does somebody know why is this happening ?

Thank you very much.

PS: I am using Zabbix Server and Proxy 5.0.0alpha3. I installed it from packages for version 4.5.1.

[Atsushi]

The table called interface_snmp seems to be the table added in 5.0.0alpha3. Is the Zabbix proxy database still at the old version?
Might improve by recreating the proxy database with a new version 5.0.0alpha3?

[ruicruz]

Hello Atsushi,
Thank you for your reply !

I tried today with a new fresh install from scratch, and i still get the same error.

I will have to say that maybe this is a bug ?

I don't have experience on working with Databases, otherwise i would attempt to correct the issue by myself.

Got any other tip ?

Thanks !