Re: [Perfparse-users] Tables cleanup

[Florian G. <fl...@bi...>]

Hi,

The PHP interface will have full functionality in the next version of
Perfparse. At 106.1 this part simply was not finished.
With the cgi interface the menu "View / Edit Hosts Deletion Policy"
works for me.

Try to set one policy there and rerun the purge to see if it works.

Flo

Ciro Iriarte wrote:
> 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
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Perfparse-users mailing list
> Per...@li...
> https://lists.sourceforge.net/lists/listinfo/perfparse-users
>