We have been successfully running RadiusNT with SQL 6.5 for a long time.
We recently made the step of upgrading our SQL to 7.0. Since the 7.0
upgrade we are experiencing problems with inserting data into the calls
table. The following is a radius -x15 debug (some values replaced with x's
for security reasons):
SQL Statement: INSERT INTO Calls
(CallDate,UserName,NASIdentifier,NASPort,AcctS
tatusType,AcctSessionId,CallerId,FramedProtocol,FramedAddress) VALUES
(GetDate()
,'xxxxxx','xxx.xx.xx.xxx',20106,1,'275761391','770xxxxxxx',1,'xxx.xx.xx.xxx')
ODBC Error:S1T00:0:
[Microsoft][ODBC SQL Server Driver]Timeout expired
Resp Time: 15000 Auth: 54/0 -> 54 Acct: 0/19/0 ->
This problem is only affecting inserting into the calls table for
accounting. Inserts into radlogs, etc. are all working properly. When we
try to manually insert a record into the calls table using the Query
Analyzer, we get an error message telling us our query was chosen as the
"deadlock victim". We have also once received a message referring to a
server error 845: "Timeout occurred while waiting for buffer latch type 2
for page (1:45387)". It would appear that some process is locking the
calls table, but we are unable to identify the process. This problem will
occur with nothing but Radius accessing the database. We have already
eliminated the possibility of any outside sources creating the lock (such
as consolidation, etc.) by disabling them and watching the problem still
develop.
The only way to temporarly fix the problem we have found is to completely
drop and recreate an empty calls table (obviously not a good solution).
After doing so radius will run fine and insert records in the calls table
for several hours, but after that period of time the problem arises again.
We are getting the same results with both our upgraded database, and a
freshly created database used to attempt to diagnose this problem.
Does anyone know what is going on here and how to fix it?
Dale?
-Mike Miller
Abraxis Networks
--==================================================== /\ Mike A. Miller == /--\ \/ Abraxis Networks ==/ \ B R A /\ I S == / == N E T W O R K S michael@abraxis.com====================================================
For more information about this list, including removal, pleasesee this URL: http://www.iea-software.com/maillist.html