service crreport dead

Question

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 down 9465 2020-09-23 14:30:06.079 CESTLOG: database system was shut down at 2020-09-23 14:29:50 CEST 9464 2020-09-23 14:30:06.144 CESTLOG: database system is ready to accept connections 9468 2020-09-23 14:30:06.144 CESTLOG: autovacuum launcher started 9471 2020-09-23 14:30:06.643 CESTFATAL: role "pgroot" does not exist 9464 2020-09-23 14:30:06.654 CESTLOG: received fast shutdown request 9464 2020-09-23 14:30:06.654 CESTLOG: aborting any active transactions 9468 2020-09-23 14:30:06.654 CESTLOG: autovacuum launcher shutting down 9466 2020-09-23 14:30:06.655 CESTLOG: shutting down 9466 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?

emmosophos · Accepted Answer

Hello Ivan, 
 The crreport is for Cyberroam reporting data base, which contains the report data of cyberoam, the XG doesn't use this which is why it shows as Dead. It however shouldn't affect any daily function, and this will resolved on 17.5 MR16 (no ETA). 
 Regards,

emmosophos · Answer

Hello Ivan, 
 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 available, please open a support ticket and mention you would like the patch for NC-63560. 
 After you open the case please send me the Case ID so I can follow-up! 
 This only affects Cyberroam devices which never flushed their reports after migrating to SFOS. 
 Regards,

service crreport dead

Top Replies