[ZBX-19238] PGRES_FATAL_ERROR select lastaccess from hosts Created: 2021 Apr 12  Updated: 2021 Jun 16  Resolved: 2021 Jun 16

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: None
Affects Version/s: 5.2.6
Fix Version/s: None

Type: Problem report Priority: Trivial
Reporter: Yurii Polenok Assignee: Andrei Gushchin (Inactive)
Resolution: Won't fix Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: Zip Archive log_ps.zip    

 Description   

Upgrade server from 5.2.4 to 5.2.6

Result:
Errors in zabbix-server log

[root@zabbix-01 ~]# grep -A 3 'PGRES_FATAL_ERROR' /var/log/zabbix/zabbix_server.log
125181:20210412:090102.004 [Z3005] query failed: [0] PGRES_FATAL_ERROR:server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
 [select lastaccess from hosts where host='zabbix-proxy-01.perf.com' and status in (5,6)]
--
125181:20210412:093202.714 [Z3005] query failed: [0] PGRES_FATAL_ERROR:server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
 [select lastaccess from hosts where host='zabbix-proxy-01.perf.com' and status in (5,6)]
--
125183:20210412:095801.860 [Z3005] query failed: [0] PGRES_FATAL_ERROR:server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
 [select lastaccess from hosts where host='zabbix-proxy-01.mondev.com' and status in (5,6)]
--
125181:20210412:102101.003 [Z3005] query failed: [0] PGRES_FATAL_ERROR:server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
 [select lastaccess from hosts where host='zabbix-proxy-01.mondev.com' and status in (5,6)]
--
125182:20210412:111402.003 [Z3005] query failed: [0] PGRES_FATAL_ERROR:server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
 [select lastaccess from hosts where host='zabbix-proxy-01.perf.com' and status in (5,6)]
--
125183:20210412:121501.006 [Z3005] query failed: [0] PGRES_FATAL_ERROR:server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
 [select lastaccess from hosts where host='zabbix-proxy-01.mondev.com' and status in (5,6)]
--
125182:20210412:124002.948 [Z3005] query failed: [0] PGRES_FATAL_ERROR:server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
 [select lastaccess from hosts where host='zabbix-proxy-01.perf.com' and status in (5,6)]
--
125179:20210412:124301.981 [Z3005] query failed: [0] PGRES_FATAL_ERROR:server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
 [select lastaccess from hosts where host='zabbix-proxy-01.mondev.com' and status in (5,6)]
--
125180:20210412:124502.005 [Z3005] query failed: [0] PGRES_FATAL_ERROR:server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
 [select lastaccess from hosts where host='zabbix-proxy-01.perf.com' and status in (5,6)]
--
125182:20210412:134901.007 [Z3005] query failed: [0] PGRES_FATAL_ERROR:server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
 [select lastaccess from hosts where host='zabbix-proxy-01.mondev.com' and status in (5,6)]


 Comments   
Comment by Andrei Gushchin (Inactive) [ 2021 Apr 15 ]

Hello Yurii,

Thank you for reporting this issue.
Does that log lines happens every time or only once?
If you run that query manually, it works?

Comment by Yurii Polenok [ 2021 Apr 15 ]

Hello Andrei,

Zabbix-server started more than 2 days ago and and there are still errors in the log.
160+ errors from 2 proxies, it seems at a completely random time.

Manually works fine for both proxy hosts.

DB:
CentOS 8.1.1911
PostgreSQL 12.3
timescaledb 1.7.1

Comment by Andrei Gushchin (Inactive) [ 2021 Apr 15 ]

Thank you.
Can you please attach here the zabbix_server.log?
Additionally to know what processes writes this need output of the command:

ps ax | grep server
Comment by Yurii Polenok [ 2021 Apr 15 ]

Log and ps output attached.

Comment by Adam Splitt [ 2021 Apr 18 ]

I have just a small suggestion, to check PostgreSQL logs, because sometimes errors inside DB can lead to problems like this.

Comment by Yurii Polenok [ 2021 Apr 19 ]

No errors were found on the database side.

Comment by Andrei Gushchin (Inactive) [ 2021 Jun 16 ]

It more all looks like there were some DB issues. Not really related to some Zabbix issue. Probably issue could be closed as won't fix.

Generated at Tue May 13 10:24:23 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.