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

After upgrading to 9.1, log disk shot to 100%

I upgraded to 9.1 UTM last night. Before that my logging was normal.
Immediately after the upgrade, the log drive started climbing up and by this morning it is 100% full and throwing errors.

I tried: /etc/init.d/postgresql rebuild
But it says "no such file or directory".

I am currently on 9.100-16

This thread was automatically locked due to age.

0 Remuflon over 12 years ago

I think the message in the log is
postgres[31315]: [1951940944-1] WARNING: concurrent insert in progress within table "websec_reqcat"

Repeated an infinite number of times...
Cancel
Vote Up 0 Vote Down

Cancel
0 BrucekConvergent over 12 years ago in reply to Remuflon

Sounds like you have a corrupt database. If this is a commercial install, create a support case... There are instructions on the board here describing how to rebuild the DB yourself; if it were me I'd just make a configuration backup, save it off to disk, etc. then reinstall the UTM, and reimport the backup.

CTO, Convergent Information Security Solutions, LLC

https://www.convergesecurity.com

Advice given as posted on this forum does not construe a support relationship or other relationship with Convergent Information Security Solutions, LLC or its subsidiaries. Use the advice given at your own risk.
Cancel
Vote Up 0 Vote Down

Cancel
0 Billybob over 12 years ago in reply to BrucekConvergent

How big is your log partition. They made some changes to the database and minimum hard drive required is 40 gb now.
Cancel
Vote Up 0 Vote Down

Cancel
0 Remuflon over 12 years ago

All,

This morning I cleared out the system messages log, and rebooted the firewall. Then I cleared it again.

Since then, everything has been normal. I wanted to wait to make sure before posting an update. Thanks for your help.

Billybob, my log partition is 150 gigs, btw.

Looks like maybe this was just a temporary glitch from upgrading.
Cancel
Vote Up 0 Vote Down

Cancel
0 BarryG over 12 years ago

Hi, it would be nice to know what was in the log that was making it so big.

Barry
Cancel
Vote Up 0 Vote Down

Cancel
0 pitonsxxl over 12 years ago

[:D] - nice update Sophos developers.
Looks like customers are "very happy" with version 9.1
Cancel
Vote Up 0 Vote Down

Cancel
0 Remuflon over 12 years ago

Update: I just woke up to the disk full again.
Same message in the log.

I guess this weekend I will have to reinstall.
Cancel
Vote Up 0 Vote Down

Cancel