I mean after update to 17.5.14 MR-14-1 (CR50iNG) asi red services indicator and detail say crreport dead. Trying start crreport service say 503 Service Failed. Command tail -f crreportdb.log show this:
9390 2020-09-23 14:29:50.341 CESTLOG: database system is shut down9465 2020-09-23 14:30:06.079 CESTLOG: database system was shut down at 2020-09-23 14:29:50 CEST9464 2020-09-23 14:30:06.144 CESTLOG: database system is ready to accept connections9468 2020-09-23 14:30:06.144 CESTLOG: autovacuum launcher started9471 2020-09-23 14:30:06.643 CESTFATAL: role "pgroot" does not exist9464 2020-09-23 14:30:06.654 CESTLOG: received fast shutdown request9464 2020-09-23 14:30:06.654 CESTLOG: aborting any active transactions9468 2020-09-23 14:30:06.654 CESTLOG: autovacuum launcher shutting down9466 2020-09-23 14:30:06.655 CESTLOG: shutting down9466 2020-09-23 14:30:06.920 CESTLOG: database system is shut down
I mean role pgroot does not exist is problem? What to do?
Thank you for contacting the Sophos Community!
I will be moving this thread to the correct group which is Sophos XG.
As per the issue, you are having this is a known issue and there is patch…
Hi, its a same issue with us here with CR50iNG and here is the case ID: 03163397
Thank you for the Case ID I have added a note to the case, could you please add to the case the screenshot of the following: Monitor & Analize >> Control Center >> Click on the Services Icon and take a screenshot, it would show the crreport.
Additionally to this please also send the output of the command:
# service -S
I do have the very same issue. My output from # service -S is below:
CR750iNG-XP_WP01_SFOS 17.5.14 MR-14-1# service -S lcdd RUNNING postgres RUNNING sigdb RUNNING reportdb RUNNING crreport DEAD awarrensmtp RUNNING smtpd RUNNING nasm RUNNING ntpclient RUNNING garner RUNNING skein RUNNING awarrenhttp RUNNING WINGc RUNNING nsxld RUNNING warren RUNNING ftpproxy RUNNING ctipd UNTOUCHED antispam UNREGISTERED ips RUNNING ripd RUNNING ospfd RUNNING bgpd RUNNING zebra RUNNING dgd RUNNING dhcpd RUNNING dhcpd6 RUNNING ipsec-monitor RUNNING strongswan RUNNING strongswan-ctl UNTOUCHED ddc RUNNING networkd RUNNING dyniface UNTOUCHED gateway RUNNING tomcat RUNNING ssod UNTOUCHED apache RUNNING antivirus RUNNING sandbox_reportd RUNNING sandboxd RUNNING dnsd RUNNING sslvpn RUNNING clientless_acce RUNNING pptpd UNREGISTERED l2tpd RUNNING mrouting UNREGISTERED pimd UNREGISTERED msync UNTOUCHED WAF UNREGISTERED red_client UNTOUCHED red UNREGISTERED supportaccess UNTOUCHED heartbeat UNREGISTERED enhancedappctrl UNREGISTERED hwmon UNREGISTERED csd UNTOUCHED access_server RUNNING bwm RUNNING fwm UNTOUCHED radvd UNREGISTERED fqdnd RUNNING fwlog RUNNING pktcapd RUNNING hostapd UNTOUCHED mdev UNREGISTERED awed UNREGISTERED hotspotd RUNNING policyroute RUNNING cfs RUNNING listener RUNNING timer RUNNING shm RUNNING dbh RUNNING CR750iNG-XP_WP01_SFOS 17.5.14 MR-14-1#
Hello Otsa IT,
Please open a case with Support and ask to have the patch applied for NC-63560.
You can send me the Case ID once you open it, so I can follow up!
Hello! the Case ID is 03245025
Thank you for the Case ID, I have left a note in the case.