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

Database Rebuild

Hi Team,

My ASG 525 HA - 8.309 is taking too much time (unable to query the objects some time) to query the object - show where this object is in use and last change [IN network definition].

I have 1273 network definition hosts.

I'm thinking rebuild the database , is it gonna help me ??

/etc/init.d/postgresql rebuild  => what would be the effect of this command ??

will its gonna effect my web security logs ??

Or anything else is the fix of this issue

I have attached the snap of CPU & MEMORY UTILIZATION which is normal.

and also I'm continuously getting below mentioned logs in confd.log
var/HuirlwoAlxXZGpLqGpZh/downloads/singlelogfile/confd.log


2013:04:22-00:25:09 FW_INTRA_HO-2 confd[7872]: W main::cleanup_sessions:984() => id="3100" severity="warn" sys="System" sub="confd" name="timeout: removing session" sid="xLeXcQwSysmPCWFdBDQg"
2013:04:22-00:25:09 FW_INTRA_HO-2 confd[7872]: W main::cleanup_sessions:966() => id="3100" severity="warn" sys="System" sub="confd" name="removing corrupted session" sid="xLeXcQwSysmPCWFdBDQg.lock"

I have attached the snap of the query objects , which show that the process was  stopped.


This thread was automatically locked due to age.
Parents
  • I believe this is related to a bug.  Please have your reseller submit a support request to Sophos.

    The PostgreSQL rebuild doesn't touch your logs, only the databases used in reporting.  It's not clear to me when it erases the content of one of those by reinitializing it and when it doesn't.  If a rebuild helps you, please report it here.

    Cheers - Bob
     
    Sophos UTM Community Moderator
    Sophos Certified Architect - UTM
    Sophos Certified Engineer - XG
    Gold Solution Partner since 2005
    MediaSoft, Inc. USA
Reply
  • I believe this is related to a bug.  Please have your reseller submit a support request to Sophos.

    The PostgreSQL rebuild doesn't touch your logs, only the databases used in reporting.  It's not clear to me when it erases the content of one of those by reinitializing it and when it doesn't.  If a rebuild helps you, please report it here.

    Cheers - Bob
     
    Sophos UTM Community Moderator
    Sophos Certified Architect - UTM
    Sophos Certified Engineer - XG
    Gold Solution Partner since 2005
    MediaSoft, Inc. USA
Children
No Data