Zabbix 3.4.13 Auto Registration not working after upgrade

[jgshier]

Having issues with Auto Registration, We were running Zabbix 3.2 upgraded to 3.4.13 and now none of our Auto Registration Actions work. I turned up the logging on the server side and can see it says "Insert" but I never seems to really insert. This is what the server side log shows and it just repeats.

10016:20180904:093443.058 trapper got '{"request":"active checks","host":"Kalispell - PFS","host_metadata":"PFS","ip":"x.x.x.x"}'
10016:20180904:093443.058 In is_ip4() ip:'x.x.x.x'
10016:20180904:093443.060 query [txnlev:1] [insert into autoreg_host (autoreg_hostid,proxy_hostid,host,listen_ip,listen _dns,listen_port,host_metadata) values (74259,null,'Kalispell - PFS','64.91.118.225','x.x.x.x .stat.centurytel.net',10050,'PFS');
10016:20180904:093443.066 query [txnlev:1] [insert into interface (interfaceid,hostid,main,type,useip,ip,dns,port) values (314,10423,1,1,1,x.x.x.x','x.x.x.x.stat.centurytel .net',10050)]
10016:20180904:093443.160 cannot send list of active checks to "x.x.x.x": host [Kalispell - PFS] not found

In looking at the Database I can confirm it does not insert.

Example Client Config is simple for testing:

Server=x.x.x.x
ServerActive=x.x.x.x:10051
Hostname=Kalispell - PFS
ListenIP=x.x.x.x
ListenPort=10050
RefreshActiveChecks=120
DebugLevel=3
PidFile=/var/run/zabbix-agent/zabbix_agentd.pid
LogFile=/var/log/zabbix-agent/zabbix_agentd.log
LogFileSize=1
Timeout=3
BufferSend=5
BufferSize=100
StartAgents=3
TLSConnect=unencrypted
TLSAccept=unencrypted
HostMetadata=PFS

Where else can I look to see what is going on?

[jgshier]

So I was able to filter out the server log more. I see at the end "commit called on failed transaction, doing a rollback instead"

Here is the full log i believe. I have other clients hitting this box.

1679:20180904:221827.600 trapper got '{"request":"active checks","host":"Kalispell - PFS","host_metadata":"PFSense","ip":"x.x.x.x"}'
1679:20180904:221827.600 In send_list_of_active_checks_json()
1679:20180904:221827.600 In is_ip4() ip:'x.x.x.x'
1679:20180904:221827.600 End of is_ip4():SUCCEED
1679:20180904:221827.600 In get_hostid_by_host() host:'Kalispell - PFS'
1679:20180904:221827.601 query [txnlev:0] [select hostid,status,tls_accept,tls_issuer,tls_subject,tl s_psk_identity from hosts where host='Kalispell - PFS' and status in (0,1) and flags<>2 and proxy_hostid is null]
1679:20180904:221827.602 query [txnlev:1] [begin;]
--
1679:20180904:221827.603 End of DBregister_host_active():SUCCEED
1679:20180904:221827.603 query [txnlev:1] [select autoreg_hostid,host from autoreg_host where proxy_hostid is null and host='Kalispell - PFS']
1679:20180904:221827.603 In DCget_nextid() table:'autoreg_host' num:1
1679:20180904:221827.603 End of DCget_nextid() table:'autoreg_host' [74265:74265]
1679:20180904:221827.604 query [txnlev:1] [insert into autoreg_host (autoreg_hostid,proxy_hostid,host,listen_ip,listen _dns,listen_port,host_metadata) values (74265,null,'Kalispell - PFS','x.x.x.x','64-91-118-22 .stat.centurytel.net',10050,'PFSense');
]
1679:20180904:221827.604 In process_events() events_num:1
1679:20180904:221827.604 In DCget_nextid() table:'events' num:1
1679:20180904:221827.604 End of DCget_nextid() table:'events' [1113832:1113832]
--
1679:20180904:221827.612 query [txnlev:1] [select nextid from ids where table_name='interface' and field_name='interfaceid']
1679:20180904:221827.613 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='interface' and field_name='interfaceid']
1679:20180904:221827.613 query [txnlev:1] [select nextid from ids where table_name='interface' and field_name='interfaceid']
1679:20180904:221827.613 End of DBget_nextid():314 table:'interface' recid:'interfaceid'
1679:20180904:221827.613 query [txnlev:1] [insert into interface (interfaceid,hostid,main,type,useip,ip,dns,port) values (314,10423,1,1,1,'x.x.x.x','x.x.x.x.stat.centuryte l.net',10050)]
1679:20180904:221827.614 End of DBadd_interface():314
1679:20180904:221827.614 In add_discovered_host_groups()
1679:20180904:221827.614 query [txnlev:1] [select groupid from hosts_groups where hostid=10423 and groupid=19]
1679:20180904:221827.615 In DBget_nextid() tablename:'hosts_groups'
--
1679:20180904:221827.791 End of DBregister_host_flush()
1679:20180904:221827.791 commit called on failed transaction, doing a rollback instead
1679:20180904:221827.791 query [txnlev:1] [rollback;]
1679:20180904:221827.804 End of get_hostid_by_host():FAIL
1679:20180904:221827.804 cannot send list of active checks to "x.x.x.x": host [Kalispell - PFS] not found
1679:20180904:221827.804 send_list_of_active_checks_json() sending [{"response":"failed","info":"host [Kalispell - PFS] not found"}]
1679:20180904:221827.804 End of send_list_of_active_checks_json():SUCCEED
1679:20180904:221827.804 __zbx_zbx_setproctitle() title:'trapper #5 [processed data in 0.204139 sec, waiting for connection]'
1676:20180904:221827.825 __zbx_zbx_setproctitle() title:'trapper #2 [processing data]'

[kloczek]

Do you have in list of items of this host at east one item listed as "zabbix (active) agent" type?

[jgshier]

Looks like its a bug, I removed the linked template and it will register.

https://support.zabbix.com/browse/ZBX-14614