disk suddenly full, postgres using all space

[dmorris]

Hi sichow,

Our recommendation is still to email support at support@untangle.com with your UID and enable remote support and we will help, even if you are a free user.

[Mathiau]

Originally Posted by arthurbovolon

I am also paying for the Premium Package, and in my humble opinion, I noticed a certain neglect of the topic here in the forum. It seems that they are not believing that there is a bug in its new version.
The strange thing is that this error only happens for those who migrated to 9.1 through the UT.
I did a clean install from the beginning with version 9.1 64bit iso, and apparently everything is working as it should. I will follow this evening to see how it will behave.
Anyone with urgency in the solution, I recommend downloading the new version 9.1, 32bit or 64bit and do the reinstallation. Do not forget to have a corresponding version of the backup to restore your settings.

i updated through UT going on 2 days now and my HD size hasn't filled over night and i have 13 racks, most modules and other goods, i have manually ran the generating report option twice and i am sitting at 63G out of 75G free..but i also dont run captive portal.

maybe they didn't post on the forum because it is not a "bug" so to speak as opposed to a bad upgrade or something else, what can they post if they dont know details or better to make people contact support to get the script to fix something because far too many people go off and run anything and end up causing more problems than they fix.

[longgage]

we meet the same problem that the disk is full soon every 30 minutes. and send the email to support@untangle.com, and waiting for the response.

[Merome]

Build: 9.1.1~svn20111222r30591release9.1-1lenny

Java: 1.6.0_20

This week, my UT Box was angry.
nodes.log et node-4.log run out of disk space, wednesday, then thursday, it's postgres with symptoms very similar as those described here.

So I try to launch the patches, but they are dedicated to 9.1.0 and I'm on 9.1.1

Trying manual VACUUM FULL ...

[johnsonx42]

did you run the disk space analyzer?

curl http://www.untangle.com/download/patches/generic/diskuse.sh | dash

if it doesn't show the problem is in the captive portal events tables, then your problem is different (which it probably is, this thread is old). you should post a new thread with the diskuse.sh output. the nodes.log problem is different as well.

[boy412]

Originally Posted by bowerj01

Having the same problem, 136gb folder:- var/lib/postgresql/8.3/main/base/16387

Build: 9.1.0~svn20111209r30408release9.1-1lenny

Any ideas would be greatly appreciated, don't fancy a 200 mile round trip to default the server.

Thanks in advance for any help.

Is there a way to get the System info from the command line? The Web GUI is hosed and I can't reboot the VM until this Sunday. I want to confirm which version I am running and if I am another victim of this postgres issue.

Originally Posted by johnsonx42

did you run the disk space analyzer?

curl http://www.untangle.com/download/patches/generic/diskuse.sh | dash

I tried running the diskuse.sh script and it gave me this error:

./diskuse.sh: line 20: `psql -U postgres uvm -c "SELECT nspname || '.' || relname AS "relation", pg_size_pretty(pg_relation_size(C.oid)) AS "size" FROM pg_class C LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace) WHERE nspname NOT IN ('pg_catalog', 'information_schema') ORDER BY pg_relation_size(C.oid) DESC LIMIT 30;"'

[jcoffin]

Originally Posted by boy412

Is there a way to get the System info from the command line? The Web GUI is hosed and I can't reboot the VM until this Sunday. I want to confirm which version I am running and if I am another victim of this postgres issue.

This will give you the system version from the command line.

dpkg -l | grep untangle-vm

[boy412]

Originally Posted by jcoffin

This will give you the system version from the command line.

dpkg -l | grep untangle-vm

Thanks!

~ # dpkg -l | grep untangle-vm
ii  untangle-vm  8.1.0~svn20110122r28325release8.1-1lenny

I was able to get back 93% of my disk space (74GB drive) by dumping the events cascade table as mentioned in the beginning of this thread.

[jcoffin]

Originally Posted by boy412

Thanks!

~ # dpkg -l | grep untangle-vm
ii  untangle-vm  8.1.0~svn20110122r28325release8.1-1lenny

I was able to get back 93% of my disk space (74GB drive) by dumping the events cascade table as mentioned in the beginning of this thread.

We fixed a ton of database issues since then. I would suggest upgrading to 9.2.1 soon.

[boy412]

Originally Posted by jcoffin

We fixed a ton of database issues since then. I would suggest upgrading to 9.2.1 soon.

I will certainly look into it. Strangely when i go into Config/Upgrades it says there are no upgrades available. Looks like I'll be doing this upgrade to 9.2 manually...

Thanks again for the assistance.