Re: [opsview-users] Extreme slowdown in reload after upgrade to 3.7.0

2010-05-28 Thread Ton Voon
On 28 May 2010, at 13:03, Jose Luis Martinez wrote: Mmm... sounds neat... which databases would it cover, though? I understand that 'opsview' is of a managaeble size... but runtime gets pretty big, and odw is even bigger! opsview only. You're right, there's no way you could upload runtime

Re: [opsview-users] Extreme slowdown in reload after upgrade to 3.7.0

2010-05-28 Thread Jose Luis Martinez
Oh yeah! Opsview swag! Spread the shirt! Jose Luis El 28/05/2010 12:29, p...@topmaf.org escribió: Yes! T-shirts! the best way to 'spread the word' Thanks a lot for your help Ton and Duncan! And the database is right, we use Opsview since version 2.9, about 2,5 years now. And we are still ve

Re: [opsview-users] Extreme slowdown in reload after upgrade to 3.7.0

2010-05-28 Thread Jose Luis Martinez
El 28/05/2010 11:53, Ton Voon escribió: I was thinking we might provide a service where you can upload your db and we run an upgrade against it, to check if there will be any problems in future, including if the schema is correct. This will allow us to proactively work out any development issues

Re: [opsview-users] Extreme slowdown in reload after upgrade to 3.7.0

2010-05-28 Thread paul
Yes! T-shirts! the best way to 'spread the word' > > Thanks a lot for your help Ton and Duncan! > And the database is right, we use Opsview since version 2.9, about 2,5 > years now. And we are still very happy with it. > > Excellent. Spread the word! > > Got T-Shirts? ;-) > > Toni > __

Re: [opsview-users] Extreme slowdown in reload after upgrade to 3.7.0

2010-05-28 Thread Toni Van Remortel
I did the database schema fix, and the diff was pretty huge. I was thinking we might provide a service where you can upload your db and we run an upgrade against it, to check if there will be any problems in future, including if the schema is correct. This will allow us to proactively work out

Re: [opsview-users] Extreme slowdown in reload after upgrade to 3.7.0

2010-05-28 Thread Ton Voon
On 28 May 2010, at 09:54, Toni Van Remortel wrote: Wow! [2010/05/28 10:49:12] [opsviewd] [INFO] Running 'web_reload' with args: [2010/05/28 10:49:14] [create_and_send_configs] [INFO] Starting overall [2010/05/28 10:51:14] [create_and_send_configs] [INFO] Ending overall with error=0 Tha

Re: [opsview-users] Extreme slowdown in reload after upgrade to 3.7.0

2010-05-28 Thread Toni Van Remortel
onderdag 27 mei 2010 17:21 To: Opsview Users Subject: Re: [opsview-users] Extreme slowdown in reload after upgrade to 3.7.0 Toni, OK, I think we've fixed this now. I think we lost the "stripping of unused contactgroups" logic when we did the notification profiles work. The number

Re: [opsview-users] Extreme slowdown in reload after upgrade to 3.7.0

2010-05-27 Thread Ton Voon
Toni,OK, I think we've fixed this now. I think we lost the "stripping of unused contactgroups" logic when we did the notification profiles work.The number of contactgroups generated has now reduced from 2 to 379. The validation time has dropped from 6 minutes down to 0.5 seconds.The patch is he

Re: [opsview-users] Extreme slowdown in reload after upgrade to 3.7.0

2010-05-26 Thread Toni Van Remortel
On 26 May 2010, at 11:37, James Peel wrote: We're currently investigating this issue: https://secure.opsera.com/jira/browse/OPS-1168 I have just updated this ticket with my findings. If you have any comments or observations please post here. I do have some comments about this (as the described

Re: [opsview-users] Extreme slowdown in reload after upgrade to 3.7.0

2010-05-26 Thread Duncan Ferguson
On 26 May 2010, at 11:37, James Peel wrote:We're currently investigating this issue:https://secure.opsera.com/jira/browse/OPS-1168I have just updated this ticket with my findings.If you have any comments or observations please post here.   Duncs -- Duncan FergusonSenior DeveloperOpsera Limited | Un

Re: [opsview-users] Extreme slowdown in reload after upgrade to 3.7.0

2010-05-26 Thread James Peel
I would appreciate any guidance (or experiences) the group my provide with 3.7.0 and distributed setups. We're currently investigating this issue: https://secure.opsera.com/jira/browse/OPS-1168 -- James___ Opsview-users mailing list Opsview-use

Re: [opsview-users] Extreme slowdown in reload after upgrade to 3.7.0

2010-05-26 Thread Toni Van Remortel
I had a quick look at the contacts.cfg file, and it shows me a possible source of the problem: large amount of host groups (163) and service groups (143) associated with various contacts. I have many groups that are eg about Servers, but for every site I create a separate group. So I have 9 host

Re: [opsview-users] Extreme slowdown in reload after upgrade to 3.7.0

2010-05-25 Thread Duncan Ferguson
On 25 May 2010, at 09:09, Ton Voon wrote:Just to let you know that I've reproduced the problem and Nagios stalls in the conf.d directory. Must be a bug somewhere in Nagios for reading subdirectories. Haven't had a chance to look at this yet, but will try and get this into 3.7.1.To confirm - I have

Re: [opsview-users] Extreme slowdown in reload after upgrade to 3.7.0

2010-05-25 Thread James Whittington
0 and distributed setups. James Whittington VC3, Inc. From: opsview-users-boun...@lists.opsview.org [mailto:opsview-users-boun...@lists.opsview.org] On Behalf Of Ton Voon Sent: Tuesday, May 25, 2010 4:09 AM To: Opsview Users Subject: Re: [opsview-users] Extreme slowdown in reload after upgrade to

Re: [opsview-users] Extreme slowdown in reload after upgrade to 3.7.0

2010-05-25 Thread Ton Voon
On 22 May 2010, at 15:46, Toni Van Remortel wrote: On 20 May 2010, at 14:19, Toni Van Remortel wrote: I had a quick look at the contacts.cfg file, and it shows me a possible source of the problem: large amount of host groups (163) and service groups (143) associated with various contacts.

Re: [opsview-users] Extreme slowdown in reload after upgrade to 3.7.0

2010-05-22 Thread Toni Van Remortel
On 20 May 2010, at 14:19, Toni Van Remortel wrote: I had a quick look at the contacts.cfg file, and it shows me a possible source of the problem: large amount of host groups (163) and service groups (143) associated with various contacts. I have many groups that are eg about Servers, but for ev

Re: [opsview-users] Extreme slowdown in reload after upgrade to 3.7.0

2010-05-21 Thread Ton Voon
On 20 May 2010, at 14:19, Toni Van Remortel wrote: Attached the latest create_and_send_configs.debug file. Still a long verify for some nodes … If my interpretation is right, then I think the problem is at Nagios. Can you provide your Nagios configuration files on node5 (sent privately)

Re: [opsview-users] Extreme slowdown in reload after upgrade to 3.7.0

2010-05-20 Thread Ton Voon
On 20 May 2010, at 14:19, Toni Van Remortel wrote: I had a quick look at the contacts.cfg file, and it shows me a possible source of the problem: large amount of host groups (163) and service groups (143) associated with various contacts. I have many groups that are eg about Servers, but for

Re: [opsview-users] Extreme slowdown in reload after upgrade to 3.7.0

2010-05-20 Thread Toni Van Remortel
A 10x increase is very extreme. Can you send the output of /usr/local/nagios/var/log/create_and_send_configs.debug? I attached it as it is a bit too large to post here. This debug tells me it is not the scp that is taking the most time - the longest scp is to node9 which took 1.14 seconds. So I

Re: [opsview-users] Extreme slowdown in reload after upgrade to 3.7.0

2010-05-20 Thread Ton Voon
On 20 May 2010, at 11:37, Toni Van Remortel wrote: A 10x increase is very extreme. Can you send the output of /usr/ local/nagios/var/log/create_and_send_configs.debug? I attached it as it is a bit too large to post here. This debug tells me it is not the scp that is taking the most time -

Re: [opsview-users] Extreme slowdown in reload after upgrade to 3.7.0

2010-05-20 Thread Toni Van Remortel
A 10x increase is very extreme. Can you send the output of /usr/local/nagios/var/log/create_and_send_configs.debug? I attached it as it is a bit too large to post here. There's an import into ODW in the middle (import_runtime) which is irrelevant. There's lots of event handler calls to slave_n

Re: [opsview-users] Extreme slowdown in reload after upgrade to 3.7.0

2010-05-20 Thread Ton Voon
On 19 May 2010, at 14:21, Toni Van Remortel wrote: I upgraded my Opsview yesterday to 3.7.0 After I made my changes in the contacts (merging all separate ‘contacts’ for each person into 1 contact with some profiles connected to it), the reload of the entire system went from 3 minutes 50 s

[opsview-users] Extreme slowdown in reload after upgrade to 3.7.0

2010-05-19 Thread Toni Van Remortel
Hi, I upgraded my Opsview yesterday to 3.7.0 After I made my changes in the contacts (merging all separate 'contacts' for each person into 1 contact with some profiles connected to it), the reload of the entire system went from 3 minutes 50 seconds to almost 30 minutes. When I watch the process