Sudden high load on 7.2

[yuanyudistira]

Oh my god,

I thought it was only me,

I got CPU load very high too, 7-15.

It happens after upgrade to 7.2,

Even I have tried to re-installed the box.

In the future do we have to turn off auto upgrade?
and upgrade only if everything is safe and tested?
I am talking about a production / live server ...,

I emailed to support, but didn't get any reply yet.


Please help....


Yuan

[neiby]

Oh my god,

I thought it was only me,

I got CPU load very high too, 7-15.

It happens after upgrade to 7.2,

Even I have tried to re-installed the box.

In the future do we have to turn off auto upgrade?
and upgrade only if everything is safe and tested?
I am talking about a production / live server ...,

I emailed to support, but didn't get any reply yet.


Please help....


Yuan

When did the high CPU usage begin? Was it immediately after the upgrade to 7.2 or did it start a few days after the upgrade? Do you know what your load average usually is?

[yuanyudistira]

Hi neiby,

email sent with update. I think its fixed. Sorry for the trouble.

As describe, the issue was a corrupution of the category-cache database. I'm not sure what caused this but I've opened a bug to track the issue:
http://bugzilla.untangle.com/show_bug.cgi?id=7623

Is this solved yet? please share ....

[neiby]

Is this solved yet? please share ....

The problem on my server was fixed. Follow the bug link that dmorris provided to read more about it. I had a corrupted database.

[yuanyudistira]

Hi
reading on
http://bugzilla.untangle.com/show_bug.cgi?id=7623

Do I have to do the following command to fixed the issue ?

rm -rf /usr/share/untangle/db && mkdir /usr/share/untangle/db &&
/etc/init.d/untangle-vm restart

[neiby]

Hi
reading on
http://bugzilla.untangle.com/show_bug.cgi?id=7623

Do I have to do the following command to fixed the issue ?

rm -rf /usr/share/untangle/db && mkdir /usr/share/untangle/db &&
/etc/init.d/untangle-vm restart

NO!! Do not do that. That was the ultimate solution in my case because I had a corrupted database. We have no idea if that's the problem you've got. Do not do anything like that unless directed to do so by Untangle support. Wait for them to get back to you so that proper troubleshooting can be done. Lots of things can cause high load.

[yuanyudistira]

When did the high CPU usage begin? Was it immediately after the upgrade to 7.2 or did it start a few days after the upgrade? Do you know what your load average usually is?

I set auto upgrade on every saturday.
I have no idea exactly when this happens, but i guess it is after i notice upgraded to 7.2

average load is 2-4, and everyone is happy, no complaints on slow browsing from users.

[yuanyudistira]

NO!! Do not do that. That was the ultimate solution in my case because I had a corrupted database. We have no idea if that's the problem you've got. Do not do anything like that unless directed to do so by Untangle support. Wait for them to get back to you so that proper troubleshooting can be done. Lots of things can cause high load.

The command is :
1. remove all files and directory of /usr/share/untangle/db
2. If successful then create new directory /usr/share/untangle/db
3. and restart the untangle vm

I follow the command

rm -rf /usr/share/untangle/db && mkdir /usr/share/untangle/db &&
/etc/init.d/untangle-vm restart

and everything on folder /usr/share/untangle/db


I notice, that CPU load drop to 2 - 3. Really do the trick.

May be that's not the real solutions, but at least it makes my life a little bit easier. :-)


Thanks

Yuan
Ps. Still waiting for a reply from support

[yuanyudistira]

After a few hours of relieve,
I notice the CPU LOAD jump high

Here I upload the screen shot of CPU load and TOP

any help ??

Thanks

Yuan

[SMNS]

Damn having the same problem on 2 boxes! Hope there will be a fix soon.