[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: |
![]() |
Description |
Upgrade server from 5.2.4 to 5.2.6 Result: [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. |
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. Manually works fine for both proxy hosts. DB: |
Comment by Andrei Gushchin (Inactive) [ 2021 Apr 15 ] |
Thank you. 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. |