Re: [Perfparse-users] Tables cleanup

[Ciro I. <cy...@gm...>]

2007/1/18, Florian Gleixner <fl...@bi...>:
>
> I think it depends on how long the cleanup lasts. I'm not sure, but i
> think mysql uses table locks and data inserts hang until the table is
> unlocked. So if the cleanup takes hours you might have a problem with
> nagios creating hundreds of processes waiting to insert data. You can
> also let nagios write the data in a file meanwhile and make a script to
> feed the data later to perfparse(d).
>
> Flo
>
> Ciro Iriarte wrote:
> > Hi, i'm running 106.1, and i have a doubt, i don't use the daemon to
> > submit the results, instead i run the DB insert with every check. I
> > would like to now if it's posible to launch the table cleanup while
> > nagios is inserting data or should i stop nagios the whole time the
> > procedure takes?
> >
> > Atte
> > Ciro
> >
PHP:
Ok, i tried the PHP interfase to set the deletion policies,  i click
on the link but it doesn't load a new page.

CGI:
I can access the CGI page and set the Raw Default Policy, although i
got this error sometimes:
---------------
An error occured with the SQL:

  "UPDATE perfdata_service SET raw_delete_policy_name = 'Raw Default'
WHERE raw_delete_policy_type = 'template' AND raw_delete_policy_name
IS NULL"

Failure Message:

  "Deadlock found when trying to get lock; try restarting transaction"
---------------
I don't have luck when trying to change the policy deletion per host,
i select the drop down boxes, and submit changes, but after reloading
the page, data isn't changed.

Then i try to run the db-purge, but all i get is this:

ope2:~ # /usr/sbin/perfparse-db-purge -r
+-----------------------------------------------------------------------------+
| There are no Plugins, Unique Key or Metrics marked for deletion today.      |
+---------------------------------------------------+--------------+----------+
+---------------------------------------------------+--------------+----------+


Am i doing something wrong?

Ciro