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

[Andrew T. <and...@as...>]

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).=20

-Andrew

-----Original Message-----
From: Florian Gleixner [mailto:fl...@bi...]=20
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:
>=20
>=20
> Hello all,
>=20
> I have successfully set up perfparse to work with nagios, and=20
> everything seems to be working as expected.
>=20
> 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=20
> daemon in the process. I have nagios and perfparse set up in pipe=20
> mode, so when perfparsed dies, nagios continues to fork threads, and=20
> eventually the machine dies.
>=20
> Is it normal behavior for db-purge to kill perfparsed?
> if it is, how do i prevent the above mentioned problem?
>=20
> Thanks in advance for your help!
> -Andrew
>=20
>=20
> ----------------------------------------------------------------------
> --
>=20
> ----------------------------------------------------------------------
> --- Using Tomcat but need to do more? Need to support web services,=20
> 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=20
> Apache Geronimo
> =
http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=3D=
1216
> 42
>=20
>=20
> ----------------------------------------------------------------------
> --
>=20
> _______________________________________________
> Perfparse-users mailing list
> Per...@li...
> https://lists.sourceforge.net/lists/listinfo/perfparse-users