Re: [Perfparse-users] db-purge kills perfparsed

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

the purge binary has the --no_transactions option. Try this one.

Andrew Tjang schrieb:
> Dear Flo,
> 
> Thanks for the answer!
> 
> I suspect that you are right. I've been doing some debugging, and it
> seems that the lock applied to the transaction is timeing out the pipe
> operation. I've tried to disable innodb-locks in the my.cnf and I will
> see if this solves it (I realize this is not the greatest solution). 
> 
> -Andrew
> 
> -----Original Message-----
> From: Florian Gleixner [mailto:fl...@bi...] 
> Sent: Tuesday, October 31, 2006 6:57 AM
> To: Andrew Tjang
> Cc: per...@li...
> Subject: Re: [Perfparse-users] db-purge kills perfparsed
> 
> Hi,
> 
> i could not really check until now, but i suspect that the purge action
> starts a very long transaction and perfparsed gets a sql error which is
> uncaught. Can you check if you get a error message if you start
> perfparsed withthe --error-log option?
> Probably the problem disappears if you purge more frequently so that the
> purge transaction does not take that long?
> 
> I'm redesigning the database schema for the next version so that purges
> will not take that long too :-)
> 
> Flo
> 
> Andrew Tjang wrote:
>>
>> Hello all,
>>
>> I have successfully set up perfparse to work with nagios, and 
>> everything seems to be working as expected.
>>
>> However, when I attempt to purge the DB (I have the policy sent to 10
>> days) the purge occurs successfully, but it kills the perfparsed 
>> daemon in the process. I have nagios and perfparse set up in pipe 
>> mode, so when perfparsed dies, nagios continues to fork threads, and 
>> eventually the machine dies.
>>
>> Is it normal behavior for db-purge to kill perfparsed?
>> if it is, how do i prevent the above mentioned problem?
>>
>> Thanks in advance for your help!
>> -Andrew
>>
>>
>> ----------------------------------------------------------------------
>> --
>>
>> ----------------------------------------------------------------------
>> --- Using Tomcat but need to do more? Need to support web services, 
>> security?
>> Get stuff done quickly with pre-integrated technology to make your job
> 
>> easier Download IBM WebSphere Application Server v.1.0.1 based on 
>> Apache Geronimo
>> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=1216
>> 42
>>
>>
>> ----------------------------------------------------------------------
>> --
>>
>> _______________________________________________
>> Perfparse-users mailing list
>> Per...@li...
>> https://lists.sourceforge.net/lists/listinfo/perfparse-users
> 
>