Re: [Sqlgrey-users] Problem with count-subroutines

[Michael S. <Mic...@lr...>]

On Thu, 15 Feb 2007, Dan Faerch wrote:

> Michael Storz wrote:
> > last_seen > $self->past_tstamp($self->{sqlgrey}{awl_age},'DAY')
> >
> > However, this is not the case with all of the count subroutines, though
> > they are semantically and syntactically nearly identical.
> >
> How on earth did you stumble upon this? ;) Ive just looked through the

Through code analysis ;)

> source and i see what you mean, but i dont see it causing any problems.
> Or am i wrong?

It is normally not a severe problem. But imagine the case of throttling.
If you cleanup your database only once every 24 hours, e.g midnight, then
you can have the case, that throttling for an IP address is done 24 hours
longer than it should.

Actually the problem was, that I got inconsistent results between using
memcached and the SQL database.

> It would be "cleaner" if this is fixed, so ill put it on my TODO list..
>
> - Dan

Michael Storz
--
======================================================
Leibniz-Rechenzentrum      |    <mailto:St...@lr...>
Boltzmannstr. 1            |    Fax: +49 89 35831-9700
85748 Garching / Germany   |    Tel: +49 89 35831-8840
======================================================