(Fwd) (RADIATOR) reloading Radiator & AddressAllocator's Recla

Mariano Absatz radiator at lists.com.ar
Sat Sep 15 13:07:38 CDT 2001


------- Forwarded message follows -------
From:         	"Mariano Absatz" <radiator at lists.com.ar>
To:           	Radiator List <radiator at open.com.au>
Date:         	Mon, 10 Sep 2001 12:46:20 -0300
Subject:      	(RADIATOR) reloading Radiator & AddressAllocator's ReclaimQuery
X-Mailer:     	Pegasus Mail for Win32 (v3.12c)
Sender:       	owner-radiator at open.com.au

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.
------- End of forwarded message -------
--
Mariano Absatz
El Baby
----------------------------------------------------------
Question: If someone with multiple personalities tries 
to commit suicide, do the police consider it a hostage 
situation? 

===
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