That is sql 7.0 that is sucking the processor I have the same problem and I had to upgrade my machine.
But I also get the same SQL error. I think it happens when it tries to insert a duplicate key
Michael Saunders
-----Original Message-----
From: Michael Hobach [SMTP:mhobach@cyberlynk.net]
Sent: Sunday, 6 June 1999 1:50
To: radiusnt@iea-software.com
Subject: [RadiusNT] SQL 7.0 problems...
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
------ =_NextPart_000_01BEB028.88259F60
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64
eJ8+Ig4EAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEkAYA0AEAAAEAAAAQAAAAAwAAMAIAAAAL
AA8OAAAAAAIB/w8BAAAAUQAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAAAHJhZGl1c250QGllYS1z
b2Z0d2FyZS5jb20AU01UUAByYWRpdXNudEBpZWEtc29mdHdhcmUuY29tAAAAAB4AAjABAAAABQAA
AFNNVFAAAAAAHgADMAEAAAAaAAAAcmFkaXVzbnRAaWVhLXNvZnR3YXJlLmNvbQAAAAMAFQwBAAAA
AwD+DwYAAAAeAAEwAQAAABwAAAAncmFkaXVzbnRAaWVhLXNvZnR3YXJlLmNvbScAAgELMAEAAAAf
AAAAU01UUDpSQURJVVNOVEBJRUEtU09GVFdBUkUuQ09NAAADAAA5AAAAAAsAQDoBAAAAHgD2XwEA
AAAaAAAAcmFkaXVzbnRAaWVhLXNvZnR3YXJlLmNvbQAAAAIB918BAAAAUQAAAAAAAACBKx+kvqMQ
GZ1uAN0BD1QCAAAAAHJhZGl1c250QGllYS1zb2Z0d2FyZS5jb20AU01UUAByYWRpdXNudEBpZWEt
c29mdHdhcmUuY29tAAAAAAMA/V8BAAAAAwD/XwAAAAACAfYPAQAAAAQAAAAAAAACuWgBBIABACMA
AABSRTogW1JhZGl1c05UXSBTUUwgNy4wIHByb2JsZW1zLi4uAIYKAQWAAwAOAAAAzwcGAAYADgAa
AAwAAAAWAQEggAMADgAAAM8HBgAGAA4AGQAFAAAADgEBCYABACEAAAAxMkE1REE3MzMyMUJEMzEx
ODA0NzAwMTBBNEYyMTEwMgC+BgEDkAYAZAwAACEAAAALAAIAAQAAAAsAIwAAAAAAAwAmAAAAAAAL
ACkAAAAAAAMALgAAAAAAAwA2AAAAAABAADkAoEy5tdSvvgEeAHAAAQAAACMAAABSRTogW1JhZGl1
c05UXSBTUUwgNy4wIHByb2JsZW1zLi4uAAACAXEAAQAAABYAAAABvq/UtYZz2qUTGzIR04BHABCk
8hECAAAeAB4MAQAAAAUAAABTTVRQAAAAAB4AHwwBAAAADAAAAG1pY2tAdHNuLmNjAAMABhA38WPn
AwAHEOoEAAAeAAgQAQAAAGUAAABUSEFUSVNTUUw3MFRIQVRJU1NVQ0tJTkdUSEVQUk9DRVNTT1JJ
SEFWRVRIRVNBTUVQUk9CTEVNQU5ESUhBRFRPVVBHUkFERU1ZTUFDSElORUJVVElBTFNPR0VUVEhF
U0FNRVNRAAAAAAIBCRABAAAARQkAAEEJAABYFQAATFpGdUBL7CkDAAoAcmNwZzEyNXIyDGBjMQMw
AQcLYG6RDhAwMzMPFmZlD5JPAfcCpANjAgBjaArAc4RldALRcHJxMgAAkioKoW5vElAgMAHQhQHQ
Ng+gMDUwNBQh8wHQFBA0fQdtAoMAUAPU+xH/EwtiE+EUUBOyGPQU0K8HEwKAApEI5jsJbzAa3/pl
DjA1HAodIRzfHekb9P8eEhx/IE8gDR+PHb8cDxBg/DI4Jdom8SavJ7kb9CfivyZPKh8p3SlfJ48r
VDkOUB8upDABKCMwAAKCc3R56mwHkGgJ4HQAABNQA/BQZGN0bAqxXDJYYZhkanUxcAUQZ2gFQq8W
MgwBD1IUEDgAUGMJwMMyYAMwc25leBcwB7AXBbAAwAJzcwBQc2IySxRQMWBhE/BcawngcL8LkDI/
MqMIYDKQC4BlMaD+djnwAUAzmwwwNGQoADTnNzfQBKALgGcn8TV2YmH9FxBkAiA2MDXWMdAzkDyx
/CAxMTMOUDcvOD85TwBR/zqMAKA0bz0fPi4xJA/AP69/QL9Bzw5QOn9EL0U/PkwzewKCExBjNvBN
4TOQPtB0Emk6ICBEARBhdWwVBUBQCsBhCcBhcGgcIEYCITa0JUBmaS11D5A4TEFpUnNIvzKjYj0L
IHIJUFSSFqBUknc0+yVBFwBwAdBPsjO/TE9NX29SEFDQBRACMC1RcANhOgggVG9agFN1YmoFBZB0
WoBEYXRlOv02tDZSP1NPVF9Vb1Z5McD/PsMOIU3hO0YOUFevWL9ZxuZSOhEXASBIPrEEkDa0/jdc
P11PXl9fbTmfYI8PkMts0AjQYgqwdDhLrg+QP0fAYx9kJm1gZTALUHkv71GAX4ALEWWlcza0KABm
n/9nr2i/X39Wj2KPbz9wTlqie1pEW3k5cx8zPwMwbRM5D3b/eA9kF36QRG9jdf8HgAIwBdBRQBoB
fMJ8IHxg+3SxAYBuWwAAYAnwT+CBgHcCATZwYSJlAPCBgDGAcEkegFx2CJB3awuAZP9uoIUiBPAH
QBBhAUAOAHSC9z6ihoUCEG8FQhchEvJbkAZtC1FbkCBDOlxc9VnQb1EhbVFwAxAHkIkwJk0N4ANg
c28BgCBP1wEgDeCEcFyK5kUAwAMQ+i5NsHSCUBcQfGA1sWrSjngBQD6iBJB5NzB78GeHoo21COFz
eI3ig4Fu7zHQGvCMhFB0YwMgEvMAgPkFkGx2QsFIgA5wNnCRAv8BkAAgkZKFcYHBAcGRARbgnw9w
AABIgAzQAZAgLhoS/5D4DlCRslCwfLCSL5M/lE+/D8BIgAWBle+W/5gPbG6g3UiAbJWvmm+bdSmU
fCVAx5lPni+bZGIgKAKRn0//kUNcIJz/ob+iz6PfkXBmcP+lIpH/po+nn5R8KAClL6qv/6u/rM+R
cHvwqa+vP7BPsVQ/CvkDMHwffS9+vzVle1RHFuAFQAQAIHNxAyA3+i42MHS6tg5whWE/ALugvxOA
F3CBgAeQipAFwEk+kP5hUDG8okgAB4C80gJgiJAeIABwNbC9gjWwdG8gjnUOAFEAAQAgbXnAQLUA
0Ghq4S4KhQqFQmqwZ71xB0CKkCBnFyC96FOYUUwgBJADYHIuvXG7u6ALgGu64AVAFuBwhOD9BjF3
MdADoMSRuKEHkb+hzwuAFxAAIL7wIGS/0GrQ94YQiOFIUHnBDAqFthS233u37wVAe4pBFuBrAAYB
df+zwRcAyC/JM2rQtBLJj8qfHwAAD1c1czYwEvJia21ya7MjIF+CAAMQW3Fh9H0t0zJPuLELgAdA
BdD7vSFREGXTM8ibtnZmXXKA/85fdB91L2qfa69sv23PukTf0K9aQwyCBdDLxUi+oMCRACBbU01U
UDptwmjhQ0BjeWIEkHCQ5cRgLjXwdF3U39Xkchv/1x/YL9k/dh+5P96lDDDQvj8GYAIw4FQCkeuP
zFFheeAsIDYgSsxQE4Av8PvvUD8QOhQwyJbrT9GBWqG37N/RRcABaekwAjBACJC8YS2KknDxwOAF
oG3v30/tq1sE8c/RRVtS81NOnFRdw1O7Yr6Fcy76QP/jb7ayzh/PL+lvuczNL/vv+/z/y2NXE4D0
YfMwzFA8oscH8Pi1RxAuNS5mYFmwFxDgB7AEsDS7cVNQNL/FMFAAUWD5RcD9A1FtS2A/UQBbkL+D
+UYRkr7xIEG+Y70SxtDS8U1yvvBi2nHdxrFtEOFRYFEQb8PwB9L//9WywD6wCGO8scNiCkcJU1cN
NoYAS1BwutFukKB1/7PQNbAGM7yiiMIxcMFmZVL+aU3A7rC/AryhxXGIoBqB3w0FCkIOOAndwP1T
D4HAMe5vhSC8cgi0d+8gvaM2AH+E4MXRFlE1sGWAZVHT4W+/T+PF8PpI/9WJ0BGgdO6w4QYzT0RC
QxCQiXDTsf28gXU8kAhxEdIXcUhSwoL/UBA+8cOjuwAb0ghx2qBIUMvBDBuDRcOyOjJ/gNyg4SCg
NjI3Ov/V4ZCKR9xdWxuDw2LsgHJlUVBQz0tQZVEigCL4XVYRwIjBCxHBBUBmUNBSSU1B5FJZwWZL
RSYAjtCzEQNRAFnxICdwa19D+4YgjvAnw/AnwAPgh8HGVf/G68ZBBUBbAydwJ8UfLyA2/jON4CDh
ZmAg8CFvIn8jj/0j0kzase+BvXAPkMPQj8DtKnFz4uAKYHjBZjXwABHeJyr/FcZbIAVQZBHxCuPv
BVAWYZvAF3BlxHAOly809wvAxfTckSW82f/V2oCMEOxpeiUTC+FTv6DE4AQL7b8CQ47gHsBGBIAl
Mk2w18XxKHHAsWcL4UnGocThvwAQuwD/1bujvKL4oUyJcP/GAQpw2uDAccBg4qC8lr6z/1ogs9Da
4B2zPn/BZudARuH/xgG+Ai804VHEcIKR+5C/oZ8Mwdqg/cDHIIkAUFU5C//MvwB/AY/K+rqhxGC7
APuB/f2Adr8AiyD6TkffSO/LJ/9LxYpAHw5LxdMzUY9SOE9HreDbPOIP4xI+S8VD4pKuTOLhBXCI
EHfD0GvusNcxQcD2ISAxBhBXY7A8kv+/oAmxF8Fa4MSQiPFcEEvFLfigY9qx7rBXvYAgNUgzNDBa
Jig0WIAp8CA4ODRyUt0wetAyIQ9cKltgS8X+EHRwOi/8L3dfIPSQ4pr3YNG2g4Ez0olLxn0AYkBi
cAAAAAMAEBAAAAAAAwAREAAAAAADAIAQ/////0AABzCgmbeN1K++AUAACDCgmbeN1K++AQsAAIAI
IAYAAAAAAMAAAAAAAABGAAAAAAOFAAAAAAAAAwACgAggBgAAAAAAwAAAAAAAAEYAAAAAEIUAAAAA
AAADAAWACCAGAAAAAADAAAAAAAAARgAAAABShQAAtw0AAB4AJYAIIAYAAAAAAMAAAAAAAABGAAAA
AFSFAAABAAAABAAAADguMAADACaACCAGAAAAAADAAAAAAAAARgAAAAABhQAAAAAAAAsAL4AIIAYA
AAAAAMAAAAAAAABGAAAAAA6FAAAAAAAAAwAwgAggBgAAAAAAwAAAAAAAAEYAAAAAEYUAAAAAAAAD
ADKACCAGAAAAAADAAAAAAAAARgAAAAAYhQAAAAAAAB4AQYAIIAYAAAAAAMAAAAAAAABGAAAAADaF
AAABAAAAAQAAAAAAAAAeAEKACCAGAAAAAADAAAAAAAAARgAAAAA3hQAAAQAAAAEAAAAAAAAAHgBD
gAggBgAAAAAAwAAAAAAAAEYAAAAAOIUAAAEAAAABAAAAAAAAAB4APQABAAAABQAAAFJFOiAAAAAA
AwANNP03AAB2YQ==
------ =_NextPart_000_01BEB028.88259F60--