Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 19 replies
  • Subscribers 2 subscribers
  • Views 38311 views
  • Users 0 members are here
Options
Suggested
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

yualme
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
  • 0
    There shouldn't be any noticible interruption when rebuilding the databases, but I agree with Barry that it's not likely to help.

    I'm not sure I buy the response from support unless you have a very, very old 525 - even then, I'm suspicious.  I have a client with a new UTM 120 - they have 883 total definitions and I don't have any problem with the info button.

    I suspect that you should insist on escalation of your problem.  Please give us the counts of DNS Hosts & Groups, Services definitions,  Firewall rules, NAT rules, users, daily volumes of maxes and mins for traffic, number of emails scanned, number of Web Filtering Profiles, etc.

    Cheers - Bob
     
    Sophos UTM Community Moderator
    Sophos Certified Architect - UTM
    Sophos Certified Engineer - XG
    Gold Solution Partner since 2005
    MediaSoft, Inc. USA
Reply
  • 0
    There shouldn't be any noticible interruption when rebuilding the databases, but I agree with Barry that it's not likely to help.

    I'm not sure I buy the response from support unless you have a very, very old 525 - even then, I'm suspicious.  I have a client with a new UTM 120 - they have 883 total definitions and I don't have any problem with the info button.

    I suspect that you should insist on escalation of your problem.  Please give us the counts of DNS Hosts & Groups, Services definitions,  Firewall rules, NAT rules, users, daily volumes of maxes and mins for traffic, number of emails scanned, number of Web Filtering Profiles, etc.

    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
Unfiltered HTML