1.Troubleshooting MySQL Connections , 2. troubleshooting possiblememory leak

[Stefan A.]

Hi all,

@Alan: yes, I do have indexes.

I still have the following issue:

Fri Oct 24 18:21:33 2008 : Info: rlm_sql (sql_accounting): There are no DB
handles to use! skipped 0, tried to connect 0
Fri Oct 24 18:21:34 2008 : Info: rlm_sql (sql_accounting): There are no DB
handles to use! skipped 0, tried to connect 0
Fri Oct 24 18:21:35 2008 : Info: rlm_sql (sql_accounting): There are no DB
handles to use! skipped 0, tried to connect 0
Fri Oct 24 18:21:36 2008 : Info: rlm_sql (sql_accounting): There are no DB
handles to use! skipped 0, tried to connect 0
Fri Oct 24 18:21:37 2008 : Info: rlm_sql (sql_accounting): There are no DB
handles to use! skipped 0, tried to connect 0
Fri Oct 24 18:21:39 2008 : Info: rlm_sql (sql_accounting): There are no DB
handles to use! skipped 0, tried to connect 0
Fri Oct 24 18:21:42 2008 : Info: rlm_sql (sql_accounting): There are no DB
handles to use! skipped 0, tried to connect 0
Fri Oct 24 18:21:57 2008 : Info: rlm_sql (sql_accounting): There are no DB
handles to use! skipped 0, tried to connect 0
Fri Oct 24 18:21:58 2008 : Info: rlm_sql (sql_accounting): There are no DB
handles to use! skipped 0, tried to connect 0
Fri Oct 24 18:21:59 2008 : Info: rlm_sql (sql_accounting): There are no DB
handles to use! skipped 0, tried to connect 0
Fri Oct 24 18:22:00 2008 : Info: rlm_sql (sql_accounting): There are no DB
handles to use! skipped 0, tried to connect 0
Fri Oct 24 18:22:01 2008 : Info: rlm_sql (sql_accounting): There are no DB
handles to use! skipped 0, tried to connect 0
Fri Oct 24 18:22:02 2008 : Info: rlm_sql (sql_accounting): There are no DB
handles to use! skipped 0, tried to connect 0
Fri Oct 24 18:22:03 2008 : Info: rlm_sql (sql_accounting): There are no DB
handles to use! skipped 0, tried to connect 0
Fri Oct 24 18:22:04 2008 : Info: rlm_sql (sql_accounting): There are no DB
handles to use! skipped 0, tried to connect 0
Fri Oct 24 18:22:05 2008 : Info: rlm_sql (sql_accounting): There are no DB
handles to use! skipped 0, tried to connect 0
Fri Oct 24 18:22:07 2008 : Info: rlm_sql (sql_accounting): There are no DB
handles to use! skipped 0, tri

While my server seems to be OK.

last pid: 18091;  load avg:  0.22,  0.21,  0.23;       up 44+02:44:36
18:22:33
82 processes: 81 sleeping, 1 on cpu
CPU states: 96.2% idle,  2.4% user,  1.4% kernel,  0.0% iowait,  0.0% swap
Memory: 8192M phys mem, 5979M free mem, 518M total swap, 518M free swap

   PID USERNAME LWP PRI NICE  SIZE   RES STATE    TIME    CPU COMMAND
 26627 mysql     59  59    0  585M  572M sleep  499.5H  2.29% mysqld
 12576 root       1  54    0   15M   12M sleep  437:52  0.57% perl
 11522 root      26  59    0   33M   29M sleep    0:27  0.32% radiusd
 12574 root       1  59    0   14M   11M sleep  530:58  0.04% perl

It handles about 100 Interim updates per second, but my client detects
something about 1000 losses per day.

Where exactly does the logfile message poit to? To me it says: I did not try
and therefore I did not skip anything....
While the server is workung like this, I'm able to do randamly update about
600 additional sets/s, using the statemants from dialup.conf in a perl
script....
I'm afraid to check more, because it is live traffic. So I'm not sure, if it
must be the database. Can set up a more detailed debug on this section? '-X'
literally stops my service...
Even that the log entry is marked as 'info', I'd like to understand, what's
going on.
 

Thank You.
Stefan


> -----Original Message-----
> From: 
> freeradius-users-bounces+a.freeradius=premit.de at lists.freeradi
> us.org 
> [mailto:freeradius-users-bounces+a.freeradius=premit.de at lists.
> freeradius.org] On Behalf Of Alan DeKok
> Sent: Wednesday, September 24, 2008 11:47 AM
> To: FreeRadius users mailing list
> Subject: Re: 1.Troubleshooting MySQL Connections , 2. 
> troubleshooting possiblememory leak
> 
> 
> Stefan A. wrote:
> > in my radiusd.log, I can see lots of these errors:
> > Wed Sep 24 09:40:54 2008 : Info: rlm_sql (sql_accounting): 
> There are no DB
> > handles to use! skipped 0, tried to connect 0
> 
>   Your database is probably slow.  Do you have indexes?
> 
> > FR is eating Memory and I do not know how to troubleshoot this.
> > It takes about 1 MB/ Minute which was about 3.5 GB over 
> some Days, before we
> > rcognized this.
> 
>   There were issues with older versions of the server, but 
> 2.1.0 should
> be fine.
> 
> > I configured the option to die a server after 500 packets, 
> but this does not
> > help for me.
> 
>   Because it stops the *thread*, not the *server*.  And all 
> threads use
> the same shared memory file.
> 
> > May I unconfigure radutmp? I think I do not need this.
> 
>   Delete all references to it from the configuration file.
> 
> > Do I really need the sqltrace-file? How my I unconfigure 
> it? Just deleting
> > the config line 
> 
>   Yes.
> 
>   Alan DeKok.
> -
> List info/subscribe/unsubscribe? See 
> http://www.freeradius.org/list/users.html
>