[ZBX-3970] proxy crashes after database connection to postgresql is recovered Created: 2011 Jul 20  Updated: 2017 May 30  Resolved: 2012 Aug 09

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Proxy (P)
Affects Version/s: 1.8.5rc1
Fix Version/s: 1.8.8, 1.9.6 (beta), 2.0.0

Type: Incident report Priority: Critical
Reporter: Aleksandrs Saveljevs Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: postgresql, proxy
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

Zabbix proxy crashed with the following messages in its log file:

1788:20110719:122213.173 [Z3001] Connection to database 'zabbix_proxy' failed: [0] could not connect to server: No route to host
Is the server running on host "192.168.X.X" and accepting
TCP/IP connections on port 5432?
1788:20110719:122213.173 Database is down. Reconnecting in 10 seconds
1791:20110719:122213.173 Database is down. Reconnecting in 10 seconds
1783:20110719:122213.173 [Z3001] Connection to database 'zabbix_proxy' failed: [0] could not connect to server: No route to host
Is the server running on host "192.168.X.X" and accepting
TCP/IP connections on port 5432?
1783:20110719:122213.174 Database is down. Reconnecting in 10 seconds
1790:20110719:122219.179 ERROR: commit without transaction. Please report it to Zabbix Team.
zabbix_proxy: db.c:513: zbx_db_commit: Assertion `0' failed.
1776:20110719:122219.185 One child process died (PID:1790,exitcode/signal:6). Exiting ...
1776:20110719:122221.189 Syncing history data...
1776:20110719:122221.235 Syncing history data... done.
1776:20110719:122221.236 Syncing trends data...
1776:20110719:122221.236 Syncing trends data... done.
1776:20110719:122221.236 Zabbix Proxy stopped. Zabbix 1.8.5rc1 (revision

{ZABBIX_REVISION}

).

 Comments   
Comment by Denis Kochergin (Inactive) [ 2011 Aug 26 ]

not all zbx_db_begin results were handled, ZBX_DB_FAIL caused DBbegin to exit without starting transaction.

Comment by Denis Kochergin (Inactive) [ 2011 Aug 26 ]

Fixed in ZBX-3970 dev branch

Comment by Alexander Vladishev [ 2011 Sep 05 ]

Fidex in version pre1.8.8, r21450.

Generated at Tue Apr 23 10:23:07 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.