Page 1 of 2

Apply Configuration never completes

Posted: Mon Jan 11, 2016 3:08 pm
by ChathamDaleJ
I have rolled back to previous snapshots.
I have repaired databases.
I have rebooted.
I've pulled hair, but I'm guessing that really is unproductive.

I'm hoping we don't have to restore a mysqldump.

Re: Apply Configuration never completes

Posted: Mon Jan 11, 2016 3:15 pm
by ChathamDaleJ
Actually, eventually it does. I think this is the reason:

-rw-rw---- 1 mysql mysql 1.1G Jan 11 12:14 /var/lib/mysql/nagiosxi/xi_meta.MYD

Re: Apply Configuration never completes

Posted: Mon Jan 11, 2016 3:19 pm
by hsmith
Oh man..

How long has yours been running?

Code: Select all

-rw-rw---- 1 mysql mysql 8.6K Jan  4 15:10 xi_meta.frm
-rw-rw---- 1 mysql mysql 2.1M Jan 11 14:08 xi_meta.MYD
-rw-rw---- 1 mysql mysql  31K Jan 11 14:08 xi_meta.MYI

Re: Apply Configuration never completes

Posted: Mon Jan 11, 2016 3:43 pm
by ChathamDaleJ
40 days since we instantiated the machine. Rebooted about an hour ago.

Re: Apply Configuration never completes

Posted: Mon Jan 11, 2016 5:48 pm
by rkennedy
Is Apply configuration working now that you've rebooted?

Re: Apply Configuration never completes

Posted: Tue Jan 12, 2016 7:19 am
by ChathamDaleJ
The large xi table file still exists: -rw-rw---- 1 mysql mysql 1.1G Jan 12 04:17 xi_meta.MYD


It is sitll at the very least taking an inordinate amount of time for an apply to finish.

I suspect that this table will not refill if I truncate it.

EDIT:
In desparation, I truncated this table. It is rebuilding as new info is added, doesn't seem to be critical to checking hosts/services.

But, apply is still taking an inordinate amount of time. Considering truncating services table and importing from /usr/local/nagios/etc/services/*

I will wait untilyou weigh in though.

EDIT:
this is quickly approaching urgent. Do you have any idea what is going on?

Re: Apply Configuration never completes

Posted: Tue Jan 12, 2016 11:56 am
by jolson
Was there any circumstance that seemed to correspond with your Apply Configurations taking a large amount of time to complete?

Are you currently a customer of ours? Posting in the General Support board typically reduces out response time. If you're a customer and this is urgent, I strongly recommend you send an email to [email protected] so that we could get a remote session going - troubleshooting this over the forum could take several days due to the ambiguity of the problem. Let me know if you need any help with the above process.

When you send in your ticket, please be sure to reference this forum post and request a remote session and a technician will get one scheduled with you. Thank you!

Re: Apply Configuration never completes

Posted: Tue Jan 12, 2016 1:07 pm
by ChathamDaleJ
We are paying customers, email rejected.


Customer ID: 38328

Re: Apply Configuration never completes

Posted: Tue Jan 12, 2016 1:09 pm
by hsmith
Can you please send an email to [email protected] to get that sorted out?

Re: Apply Configuration never completes

Posted: Tue Jan 12, 2016 1:54 pm
by ChathamDaleJ
On its way.