(RADIATOR) Question about Radius and SQL

[Martin Edge]

Hey Guys,

 

Having a few issues, as we are unable to easily find out where the cause of the slowdown's we get when a "avalanche" scenario occurs.

 

(where the amount of requests coming in, is faster than the processing power to complete them..)

 

Is this necessarily an SQL timeout, or could there be other attributing factors to these errors:

 

If so, how would we go about finding these out..

 

I tried LogMicroseconds in a <Log FILE> routine, and this is the output below.. (although I dont see any milliseconds results..)

 

Thanks for your help,

Martin

 

 

---- snip ----

Fri Jan 25 17:42:13 2002 32431: ERR: Could not connect to any SQL database. Requ
est is ignored. Backing off for 10 seconds
Fri Jan 25 17:42:28 2002 911157: ERR: Execute failed for 'Sp_fetchUserPassword '
clouston'': SQL Timeout
Fri Jan 25 17:42:32 2002 481065: ERR: Execute failed for 'Sp_fetchUserPassword '
clouston'': SQL Timeout
Fri Jan 25 17:42:36 2002 960943: ERR: Could not connect to SQL database with DBI
->connect dbi:Sybase:server=notus.izone.net.au;database=nb9901, netbeans, beans2
000: timeout at /usr/local/lib/perl5/site_perl/5.6.1/Radius/Util.pm line 507.

 

Fri Jan 25 17:42:36 2002 982364: ERR: Could not connect to any SQL database. Req
uest is ignored. Backing off for 10 seconds
Fri Jan 25 17:42:50 2002 371277: ERR: Execute failed for 'Sp_fetchUserPassword '
office'': SQL Timeout
Fri Jan 25 17:42:52 2002 391393: ERR: Could not connect to SQL database with DBI
->connect dbi:Sybase:server=notus.izone.net.au;database=nb9901, netbeans, beans2
000: timeout at /usr/local/lib/perl5/site_perl/5.6.1/Radius/Util.pm line 507.

 

Fri Jan 25 17:42:52 2002 421577: ERR: Could not connect to any SQL database. Req
uest is ignored. Backing off for 10 seconds
Fri Jan 25 17:43:07 2002 361641: ERR: Could not connect to SQL database with DBI
->connect dbi:Sybase:server=notus.izone.net.au;database=nb9901, netbeans, beans2
000: timeout at /usr/local/lib/perl5/site_perl/5.6.1/Radius/Util.pm line 507.

 

Fri Jan 25 17:43:07 2002 411189: ERR: Could not connect to any SQL database. Req
uest is ignored. Backing off for 10 seconds
Fri Jan 25 17:43:21 2002 671671: ERR: Execute failed for 'Sp_fetchUserPassword '
simona'': SQL Timeout
Fri Jan 25 17:43:23 2002 691896: ERR: Could not connect to SQL database with DBI
->connect dbi:Sybase:server=notus.izone.net.au;database=nb9901, netbeans, beans2
000: timeout at /usr/local/lib/perl5/site_perl/5.6.1/Radius/Util.pm line 507.

 

Fri Jan 25 17:43:23 2002 716376: ERR: Could not connect to any SQL database. Req
uest is ignored. Backing off for 10 seconds
Fri Jan 25 17:43:39 2002 561994: ERR: Execute failed for 'Sp_fetchUserPassword '
themoodies'': SQL Timeout
Fri Jan 25 17:43:42 2002 501985: ERR: Execute failed for 'Sp_fetchUserPassword '
themoodies'': SQL Timeout
Fri Jan 25 17:43:45 2002 382053: ERR: Execute failed for 'Sp_fetchUserPassword '
clouston'': SQL Timeout
Fri Jan 25 17:43:47 2002 972065: ERR: Execute failed for 'Sp_fetchUserPassword '
clouston'': SQL Timeout
Fri Jan 25 17:43:50 2002 742074: ERR: Execute failed for 'Sp_fetchUserPassword '
themoodies'': SQL Timeout
Fri Jan 25 17:43:53 2002 321952: ERR: Execute failed for 'Sp_fetchUserPassword '
themoodies'': SQL Timeout
Fri Jan 25 17:43:55 2002 722314: ERR: Execute failed for 'Sp_fetchUserPassword '
shields'': SQL Timeout
Fri Jan 25 17:43:58 2002 32217: ERR: Execute failed for 'Sp_fetchUserPassword 's
hields'': SQL Timeout
Fri Jan 25 17:44:00 2002 532429: ERR: Execute failed for 'Sp_fetchUserPassword '
blp04395'': SQL Timeout
Fri Jan 25 17:44:02 2002 832373: ERR: Execute failed for 'Sp_fetchUserPassw

-----------------------------------------

Martin Edge

Technical Services Co-ordinator

Phoneware Online

eMail: [EMAIL PROTECTED]

Phone: +613 9640 4140 ext. 193

 

"In the end, it's speed, price and customer service."

-----------------------------------------