Re: FR-1.1.2 dies with error

2006-08-16 Thread Alexander Serkin
Alan DeKok wrote: Alexander Serkin [EMAIL PROTECTED] wrote: And i feel that Oracle is not good production server for radius accounting. Or the DB structure is not optimal for our application. I know of Oracle installations with 400k users. And the default schema works with installations of

Re: FR-1.1.2 dies with error

2006-08-16 Thread Nicolas Baradakis
Alexander Serkin wrote: And i feel that Oracle is not good production server for radius accounting. Or the DB structure is not optimal for our application. Does anybody in the list use the FROracle for the systems serving about 4500 simultaneous connections? It's really not much, but...

Re: FR-1.1.2 dies with error

2006-08-16 Thread Alexander Serkin
Nicolas Baradakis wrote: Alexander Serkin wrote: And i feel that Oracle is not good production server for radius accounting. Or the DB structure is not optimal for our application. Does anybody in the list use the FROracle for the systems serving about 4500 simultaneous connections? It's

Re: FR-1.1.2 dies with error

2006-08-16 Thread Alan DeKok
Alexander Serkin [EMAIL PROTECTED] wrote: I know of Oracle installations with 400k users. And the default schema works with installations of millions of users. do you mean 400k active simultaneous connections? And do they use accounting updates (Interim-Update records)? There are no

Re: FR-1.1.2 dies with error

2006-08-16 Thread Alexander Serkin
Alan DeKok wrote: Alexander Serkin [EMAIL PROTECTED] wrote: I know of Oracle installations with 400k users. And the default schema works with installations of millions of users. do you mean 400k active simultaneous connections? And do they use accounting updates (Interim-Update records)?

Re: FR-1.1.2 dies with error

2006-08-15 Thread Alexander Serkin
Alan DeKok wrote: Alexander Serkin [EMAIL PROTECTED] wrote: I'm still trying to investigate the problem with one of my AAA servers. It's a problem with the DB, not with the server. I understand this, Alan. My experiments with hiding assertion strings in request_list.c came into failure.

Re: FR-1.1.2 dies with error

2006-08-15 Thread Alan DeKok
Alexander Serkin [EMAIL PROTECTED] wrote: And i feel that Oracle is not good production server for radius accounting. Or the DB structure is not optimal for our application. I know of Oracle installations with 400k users. And the default schema works with installations of millions of users.

Re: FR-1.1.2 dies with error

2006-08-14 Thread Alexander Serkin
Hi all, Alan DeKok wrote: Alexander Serkin [EMAIL PROTECTED] wrote: Do you mean just comment out line 1012 in request_list.c ? Yes. I think i'll try this first because speeding up DB is not a trivial task by now. But it's the real source of the problem... I'm still trying to

Re: FR-1.1.2 dies with error

2006-08-14 Thread Alan DeKok
Alexander Serkin [EMAIL PROTECTED] wrote: I'm still trying to investigate the problem with one of my AAA servers. It's a problem with the DB, not with the server. Is it possible to tell on wich request assertion fails? No. We have two servers and use load-balancing between them

Re: FR-1.1.2 dies with error

2006-08-06 Thread Alexander Serkin
Laker Netman wrote: How large a DB is this? And what type of link is there between FR and the DB? It's about 36 million records since april 2005. Unless there are, literally, (tens of) thousands of records and/or a *slow* link (think dial-up) and/or ancient hardware there should be some

Re: FR-1.1.2 dies with error

2006-08-05 Thread Laker Netman
--- Alan DeKok [EMAIL PROTECTED] wrote: Alexander Serkin [EMAIL PROTECTED] wrote: Do you mean just comment out line 1012 in request_list.c ? Yes. I think i'll try this first because speeding up DB is not a trivial task by now. But it's the real source of the problem...

Re: FR-1.1.2 dies with error

2006-08-04 Thread Alexander Serkin
Alan DeKok пишет: It's probably because your DB is slow. See the logs for messages about unresponsive child. The code path to the assertion is taken only when the request has been marked done, but there is still a child thread blocked, and working on it. Either fix the DB, or delete the

Re: FR-1.1.2 dies with error

2006-08-04 Thread Alan DeKok
Alexander Serkin [EMAIL PROTECTED] wrote: Do you mean just comment out line 1012 in request_list.c ? Yes. I think i'll try this first because speeding up DB is not a trivial task by now. But it's the real source of the problem... Alan DeKok. -- http://deployingradius.com -

FR-1.1.2 dies with error

2006-08-03 Thread Alexander Serkin
Hi all. We have some trouble with fr-1.1.2 Oracle-9.2.0.6 Solaris 9. The process dies periodically with the error: Thu Aug 3 14:27:43 2006 : Error: Assertion failed in request_list.c, line 1012 FR is built with the following configuration: ./configure \ --with-ltdl-lib=libltdl \

Re: FR-1.1.2 dies with error

2006-08-03 Thread Alan DeKok
Alexander Serkin [EMAIL PROTECTED] wrote: We have some trouble with fr-1.1.2 Oracle-9.2.0.6 Solaris 9. The process dies periodically with the error: Thu Aug 3 14:27:43 2006 : Error: Assertion failed in request_list.c, line 1012 It's probably because your DB is slow. See the logs for