(RADIATOR) reloading Radiator & AddressAllocator's ReclaimQuery
Mariano Absatz
radiator at lists.com.ar
Mon Sep 10 10:46:20 CDT 2001
Hi,
I have noticed a bug (or is it a feature? :-) by means of which I end up with
lots of queries to my database.
I'm using <AuthBy DYNADDRESS> with an <AddressAllocator SQL>.
I defined my ReclaimQuery as follows:
LeaseReclaimInterval 10800
ReclaimQuery UPDATE POOL_IP \
SET OCUPADA = 0, TIME_STAMP = %0 \
WHERE OCUPADA != 0 AND EXPIRA < %0
(which is similar to the default with table & fields names changed)
The point is that I see this queries in my trace 4 every 3 hours... until I
reload radiator (SIGHUP). After doing this, It keeps doing the query
following the 3 hours period since I orininally started Radiator and adds
ANOTHER cicle starting at the time I reloaded...
As I've been fiddling with reloads through SNMP and the like, I've ended up
with about 30 queries every 3 hours (see log below).
I guess the "reload" process is Radius::Select::add_timeout()'ing the
recently read ReclaimQuery, but isn't Radius::Select::remove_timeout()'ing
the old one...
Does this has a solution?
TIA.
Mon Sep 10 05:28:45 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 05:28:45 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000110525 WHERE OCUPADA != 0 AND EXPIRA < 1000110525
Mon Sep 10 05:28:51 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 05:28:51 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000110531 WHERE OCUPADA != 0 AND EXPIRA < 1000110531
Mon Sep 10 05:28:53 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 05:28:53 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000110533 WHERE OCUPADA != 0 AND EXPIRA < 1000110533
Mon Sep 10 05:28:53 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 05:28:53 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000110533 WHERE OCUPADA != 0 AND EXPIRA < 1000110533
Mon Sep 10 05:28:54 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 05:28:54 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000110534 WHERE OCUPADA != 0 AND EXPIRA < 1000110534
Mon Sep 10 05:28:55 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 05:28:55 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000110535 WHERE OCUPADA != 0 AND EXPIRA < 1000110535
Mon Sep 10 05:28:56 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 05:28:56 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000110536 WHERE OCUPADA != 0 AND EXPIRA < 1000110536
Mon Sep 10 05:29:49 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 05:29:49 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000110589 WHERE OCUPADA != 0 AND EXPIRA < 1000110589
Mon Sep 10 05:29:50 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 05:29:50 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000110590 WHERE OCUPADA != 0 AND EXPIRA < 1000110590
Mon Sep 10 05:29:51 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 05:29:51 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000110591 WHERE OCUPADA != 0 AND EXPIRA < 1000110591
Mon Sep 10 05:29:53 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 05:29:53 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000110593 WHERE OCUPADA != 0 AND EXPIRA < 1000110593
Mon Sep 10 05:29:53 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 05:29:53 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000110593 WHERE OCUPADA != 0 AND EXPIRA < 1000110593
Mon Sep 10 05:29:54 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 05:29:54 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000110594 WHERE OCUPADA != 0 AND EXPIRA < 1000110594
Mon Sep 10 05:30:23 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 05:30:23 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000110623 WHERE OCUPADA != 0 AND EXPIRA < 1000110623
Mon Sep 10 05:30:24 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 05:30:24 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000110624 WHERE OCUPADA != 0 AND EXPIRA < 1000110624
Mon Sep 10 05:30:25 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 05:30:25 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000110625 WHERE OCUPADA != 0 AND EXPIRA < 1000110625
Mon Sep 10 05:30:26 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 05:30:26 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000110626 WHERE OCUPADA != 0 AND EXPIRA < 1000110626
Mon Sep 10 05:30:27 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 05:30:27 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000110627 WHERE OCUPADA != 0 AND EXPIRA < 1000110627
Mon Sep 10 05:31:49 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 05:31:49 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000110709 WHERE OCUPADA != 0 AND EXPIRA < 1000110709
Mon Sep 10 05:31:54 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 05:31:54 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000110714 WHERE OCUPADA != 0 AND EXPIRA < 1000110714
Mon Sep 10 05:31:59 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 05:31:59 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000110719 WHERE OCUPADA != 0 AND EXPIRA < 1000110719
Mon Sep 10 05:32:04 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 05:32:04 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000110724 WHERE OCUPADA != 0 AND EXPIRA < 1000110724
Mon Sep 10 05:32:09 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 05:32:09 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000110729 WHERE OCUPADA != 0 AND EXPIRA < 1000110729
Mon Sep 10 05:32:15 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 05:32:15 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000110735 WHERE OCUPADA != 0 AND EXPIRA < 1000110735
Mon Sep 10 05:32:32 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 05:32:32 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000110752 WHERE OCUPADA != 0 AND EXPIRA < 1000110752
Mon Sep 10 05:32:43 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 05:32:43 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000110763 WHERE OCUPADA != 0 AND EXPIRA < 1000110763
Mon Sep 10 05:36:10 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 05:36:10 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000110970 WHERE OCUPADA != 0 AND EXPIRA < 1000110970
Mon Sep 10 05:36:21 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 05:36:21 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000110981 WHERE OCUPADA != 0 AND EXPIRA < 1000110981
Mon Sep 10 05:36:51 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 05:36:51 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000111011 WHERE OCUPADA != 0 AND EXPIRA < 1000111011
Mon Sep 10 08:28:45 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 08:28:45 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000121325 WHERE OCUPADA != 0 AND EXPIRA < 1000121325
Mon Sep 10 08:28:51 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 08:28:51 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000121331 WHERE OCUPADA != 0 AND EXPIRA < 1000121331
Mon Sep 10 08:28:53 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 08:28:53 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000121333 WHERE OCUPADA != 0 AND EXPIRA < 1000121333
Mon Sep 10 08:28:53 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 08:28:53 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000121333 WHERE OCUPADA != 0 AND EXPIRA < 1000121333
Mon Sep 10 08:28:54 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 08:28:54 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000121334 WHERE OCUPADA != 0 AND EXPIRA < 1000121334
Mon Sep 10 08:28:55 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 08:28:55 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000121335 WHERE OCUPADA != 0 AND EXPIRA < 1000121335
Mon Sep 10 08:28:56 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 08:28:56 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000121336 WHERE OCUPADA != 0 AND EXPIRA < 1000121336
Mon Sep 10 08:29:49 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 08:29:49 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000121389 WHERE OCUPADA != 0 AND EXPIRA < 1000121389
Mon Sep 10 08:29:50 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 08:29:50 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000121390 WHERE OCUPADA != 0 AND EXPIRA < 1000121390
Mon Sep 10 08:29:51 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 08:29:51 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000121391 WHERE OCUPADA != 0 AND EXPIRA < 1000121391
Mon Sep 10 08:29:53 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 08:29:53 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000121393 WHERE OCUPADA != 0 AND EXPIRA < 1000121393
Mon Sep 10 08:29:53 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 08:29:53 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000121393 WHERE OCUPADA != 0 AND EXPIRA < 1000121393
Mon Sep 10 08:29:54 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 08:29:54 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000121394 WHERE OCUPADA != 0 AND EXPIRA < 1000121394
Mon Sep 10 08:30:23 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 08:30:23 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000121423 WHERE OCUPADA != 0 AND EXPIRA < 1000121423
Mon Sep 10 08:30:24 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 08:30:24 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000121424 WHERE OCUPADA != 0 AND EXPIRA < 1000121424
Mon Sep 10 08:30:25 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 08:30:25 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000121425 WHERE OCUPADA != 0 AND EXPIRA < 1000121425
Mon Sep 10 08:30:26 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 08:30:26 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000121426 WHERE OCUPADA != 0 AND EXPIRA < 1000121426
Mon Sep 10 08:30:27 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 08:30:27 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000121427 WHERE OCUPADA != 0 AND EXPIRA < 1000121427
Mon Sep 10 08:31:49 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 08:31:49 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000121509 WHERE OCUPADA != 0 AND EXPIRA < 1000121509
Mon Sep 10 08:31:54 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 08:31:54 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000121514 WHERE OCUPADA != 0 AND EXPIRA < 1000121514
Mon Sep 10 08:31:59 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 08:31:59 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000121519 WHERE OCUPADA != 0 AND EXPIRA < 1000121519
Mon Sep 10 08:32:04 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 08:32:04 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000121524 WHERE OCUPADA != 0 AND EXPIRA < 1000121524
Mon Sep 10 08:32:09 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 08:32:09 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000121529 WHERE OCUPADA != 0 AND EXPIRA < 1000121529
Mon Sep 10 08:32:15 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 08:32:15 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000121535 WHERE OCUPADA != 0 AND EXPIRA < 1000121535
Mon Sep 10 08:32:32 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 08:32:32 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000121552 WHERE OCUPADA != 0 AND EXPIRA < 1000121552
Mon Sep 10 08:32:43 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 08:32:43 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000121563 WHERE OCUPADA != 0 AND EXPIRA < 1000121563
Mon Sep 10 08:36:10 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 08:36:10 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000121770 WHERE OCUPADA != 0 AND EXPIRA < 1000121770
Mon Sep 10 08:36:21 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 08:36:21 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000121781 WHERE OCUPADA != 0 AND EXPIRA < 1000121781
Mon Sep 10 08:36:51 2001: DEBUG: Reclaiming expired leases
Mon Sep 10 08:36:51 2001: DEBUG: do query is: UPDATE POOL_IP SET OCUPADA = 0,
TIME_STAMP = 1000121811 WHERE OCUPADA != 0 AND EXPIRA < 1000121811
--
Mariano Absatz
El Baby
----------------------------------------------------------
Ladies and gentlemen, I stand before you to
stand behind you to tell you something I know
nothing about. Thursday, which is Good Friday,
we're having a Father's Day party for mothers only.
Admission is free, pay at the door, pull out a chair
and sit on the floor.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.
More information about the radiator
mailing list