Re: [RadiusNT] SQL 7.0 problems...

Michael Hobach ( (no email) )
Tue, 8 Jun 1999 12:44:04 -0500

Dale,

Any thoughts on this previous post?

This 100% thing is driving us crazy...

Mike

----------------
Email from: Michael Hobach <radiusnt@iea-software.com>

On 5 Jun 99, at 22:50, Michael Hobach wrote

> We are running RadiusNT 2.5.175 on NT 4.0 SP4 with SQL 7.0.
>
> We migrated to SQL 7.0 from an Access database about a month ago. We
> created the SQL database from the SQL script included with the latest
> version, and then imported the data from the Access database.
>
> Since moving to SQL we have experienced several oddities...
>
> First, with ODBC logging turned on, we keep getting errors logged like
>
> ODBC Error:23000:2627:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY
> KEY constraint 'pk_Calls'. Cannot insert duplicate key in object 'Calls'.
>
> ODBC Error:37000:170:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax
> near 's'.
>
>
> Second, about once a week the SQL server goes to 100% processor
> utilization. Stopping RadiusNT and Cold Fusion does nothing. It appears
> that the RadLogs table may be the problem - deleting the RadLogs table
> brings the server back down to realistic CPU utilization.
>
> Thanks in advance...
>
> Mike
>
>
> --------------------------------
> Michael Hobach <mhobach@cyberlynk.net>
> CyberLynk Network, Inc.
> 6214 Washington Ave Suite C16
> Racine, WI 53406
> (414) 884-1088 Fax (414) 884-1053
> http://www.cyberlynk.net

--------------------------------
Michael Hobach <mhobach@cyberlynk.net>
CyberLynk Network, Inc.
5801 Washington Ave
Racine, WI 53406
(414) 884-1088 Fax (414) 884-1053
http://www.cyberlynk.net