This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

All Reports broken

I am on the latest version and every once in a while my system reporting stops working.  All reports on the "Reports" page change to "No Record Found".  I can re-install the firmware and restore my backup and it fixes it for a while but then it happens again.  No changes are made at the time this occurs.



This thread was automatically locked due to age.
Parents
  • Hey Nitr01,

     

    I wanted to bring this back up as I'm now experiencing the same issue you are. I've recently upgrade to 17.5.3 MR-3 and the next day I it was working just fine. Over the weekend, it must of died as when I came into work Monday it was showing "No record found" for everything. I haven't tired re-installing firmware or restoring the backup as I wish to stay away from downtime if possible.

     

    I've followed the steps on here: community.sophos.com/.../123209

     

     SFV4C6_SO01_SFOS 17.5.3 MR-3# service -S
    lcdd UNTOUCHED
    postgres RUNNING
    sigdb RUNNING
    reportdb RUNNING
    crreport UNREGISTERED
    awarrensmtp UNREGISTERED
    smtpd RUNNING
    nasm RUNNING
    ntpclient RUNNING
    garner RUNNING

    console> show on-box-reports
    Local Reporting : on

    console> system diagnostics show disk
    Partition Utilization(%)
    ===============================
    configuration 18%
    content 1%
    report 37%

    SFV4C6_SO01_SFOS 17.5.3 MR-3# df -h
    Filesystem Size Used Available Use% Mounted on
    rootfs 301.9M 2.6M 279.3M 1% /
    df: /newroot: No such file or directory
    df: /newroot/dev: No such file or directory
    df: /newrootrw: No such file or directory
    none 301.9M 2.6M 279.3M 1% /
    none 11.7G 40.0K 11.7G 0% /dev
    none 11.7G 54.3M 11.7G 0% /tmp
    none 11.7G 14.6M 11.7G 0% /dev/shm
    /dev/conf 385.4M 68.6M 316.7M 18% /conf
    /dev/content 43.6G 378.0M 43.2G 1% /content
    /dev/var 368.7G 136.5G 232.2G 37% /var

     

    To verify, this is what the problem looks like.

    and yes, logging is enabled for almost all of my firewall rules. 

Reply
  • Hey Nitr01,

     

    I wanted to bring this back up as I'm now experiencing the same issue you are. I've recently upgrade to 17.5.3 MR-3 and the next day I it was working just fine. Over the weekend, it must of died as when I came into work Monday it was showing "No record found" for everything. I haven't tired re-installing firmware or restoring the backup as I wish to stay away from downtime if possible.

     

    I've followed the steps on here: community.sophos.com/.../123209

     

     SFV4C6_SO01_SFOS 17.5.3 MR-3# service -S
    lcdd UNTOUCHED
    postgres RUNNING
    sigdb RUNNING
    reportdb RUNNING
    crreport UNREGISTERED
    awarrensmtp UNREGISTERED
    smtpd RUNNING
    nasm RUNNING
    ntpclient RUNNING
    garner RUNNING

    console> show on-box-reports
    Local Reporting : on

    console> system diagnostics show disk
    Partition Utilization(%)
    ===============================
    configuration 18%
    content 1%
    report 37%

    SFV4C6_SO01_SFOS 17.5.3 MR-3# df -h
    Filesystem Size Used Available Use% Mounted on
    rootfs 301.9M 2.6M 279.3M 1% /
    df: /newroot: No such file or directory
    df: /newroot/dev: No such file or directory
    df: /newrootrw: No such file or directory
    none 301.9M 2.6M 279.3M 1% /
    none 11.7G 40.0K 11.7G 0% /dev
    none 11.7G 54.3M 11.7G 0% /tmp
    none 11.7G 14.6M 11.7G 0% /dev/shm
    /dev/conf 385.4M 68.6M 316.7M 18% /conf
    /dev/content 43.6G 378.0M 43.2G 1% /content
    /dev/var 368.7G 136.5G 232.2G 37% /var

     

    To verify, this is what the problem looks like.

    and yes, logging is enabled for almost all of my firewall rules. 

Children