Re: [Help-gnu-radius] sql accounting problems

[Pavel Kuz]

On Fri, Jul 19, 2002 at 12:23:18PM +0300, Sergey Poznyakoff wrote:
> 
> > I see in details, that radius recieves all start and stop packets, but the 
> > interval between them is rather small (sometimes less then 100 msec).
> > The problem is that sql makes update on a table earlier then insert, and so 
> > it updates nothing.
> 
> Yes, this race condition is known (see postings from Lai Zit Seng on
> [Fri, 18 Jan 2002 00:35:44 +0800 (SGT)] and from Sergey Poznyakoff on
> [Thu, 17 Jan 2002 18:47:49 +0200]). The reason is that each request
> is served by a separate process which feeds it to SQL server. If the
> SQL server handles UPDATE request faster than INSERT, it may finish
> the former before the latter.
> 
> > Can I somehow make radius put all queries in FIFO exactly in order
> > it recieves them?
> 
> Currently the only way to force synchronous processing of the requests
> is to place `spawn no;' into `acct' clause of your raddb/config, e.g.:
> 
> acct {
>      spawn no;
>      ...
Hmm...
I tried this, but it looks like it doesn't help! I still get these errors. 

this is from my config

acct {  
        max-requests 127;
        request-cleanup-delay 2;
        detail yes;
        spawn no;
};

And again I see that in sql.log queries come in wrong order....

> 
> Notice however that this may have a negative impact on the performance
> of the server.
> 
> Regards,
> Sergey
> 
> 
> _______________________________________________
> Help-gnu-radius mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/help-gnu-radius
> 

-- 
--------
Regards,
Pavel.
"He's the kind of man for the times that need the kind of man he is ..."