service crreport dead

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?

Parents
  • Hi, its a same issue with us here with CR50iNG and here is the case ID: 03163397

  • Hello Srinivas,

    Thank you for contacting the Sophos Community!

    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 

    Regards,


     
    Emmanuel (EmmoSophos)
    Community Support Engineer | Sophos Technical Support
    Sophos Support VideosProduct Documentation  |  @SophosSupport  | Sign up for SMS Alerts
    If a post solves your question use the 'Verify Answer' link.
  • Hello,

    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,

    Thank you for contacting the Sophos Community!

    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!

    Regards,


     
    Emmanuel (EmmoSophos)
    Community Support Engineer | Sophos Technical Support
    Sophos Support VideosProduct Documentation  |  @SophosSupport  | Sign up for SMS Alerts
    If a post solves your question use the 'Verify Answer' link.
Reply Children