SQL 7.0 is a great platform. The only problem is your machine will have to be upgraded as SQL is a lot more intensive than access
Michael Saunders
-----Original Message-----
From: Michael Hobach [SMTP:mhobach@cyberlynk.net]
Sent: Thursday, 10 June 1999 9:40
To: radiusnt@iea-software.com
Cc: Network Operation Center
Subject: Re: [RadiusNT] SQL 7.0 problems...
Dale,
We checked the time-out in all of our TNT's/MAX's - we have a TNT and 5
MAX 4000/6000 - they are all set to 10 seconds. We are still getting the
"'pk_Calls'. Cannot insert duplicate key in object 'Calls'" error.
Checked on triggers on the calls table - looked under the 'triggers' for the
calls table and found nothing! Where should we find them, and what
triggers should be there?
We created an Index as suggested by Mike Miller in a post on 3/17/99 as
CREATE INDEX index_AcctSessionId ON Calls(AcctSessionId)
This was done earlier - we have had several 100% CPU incidences since!
We have been using the Access DB version of RadiusNT since you first
introduced it - we have had to do absolutely no maintenance on the system -
since we introduced MS SQL we have had to spend a lot of time learning
the internal problems and specifics of SQL - I'll be glad to get this to settle
down again!!! I'm thinking that maybe MS SQL was not the best choice -
maybe we should have considered ORACLE?
Any thoughts?
----------------
Email from: Dale E. Reed Jr. <radiusnt@iea-software.com>
On 8 Jun 99, at 10:43, Dale E. Reed Jr. wrote
> Michael Hobach wrote:
> >
> > Any thoughts on this previous post?
> > This 100% thing is driving us crazy...
>
> > > 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'.
>
> This just means RadiusNT already has the accounting record. Its normal,
> but you shouldn't see it a lot. If you do, then check your timeouts and
> the response times of RadiusNT.
>
> > > ODBC Error:37000:170:
> > > [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax
> > > near 's'.
>
> This is typically someone putting a ' in a username or such.
>
> > > 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.
>
> Someone reported this a while back on SQL7. It has to do with the
> trigger. There was a posted workaround for it, but I don't remember
> the exact problem. I think it had to do with aliasing (or lack thereof)
> the update table vs. using the table name. What does your trigger
> on your calls table look like?
>
>
> --
>
> Dale E. Reed Jr. Emerald and RadiusNT
> __________________________________________
> IEA Software, Inc. www.iea-software.com
--------------------------------
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_01BEB38E.8404FD40
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64
eJ8+IjEMAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEkAYA0AEAAAEAAAAQAAAAAwAAMAIAAAAL
AA8OAAAAAAIB/w8BAAAAUQAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAAAHJhZGl1c250QGllYS1z
b2Z0d2FyZS5jb20AU01UUAByYWRpdXNudEBpZWEtc29mdHdhcmUuY29tAAAAAB4AAjABAAAABQAA
AFNNVFAAAAAAHgADMAEAAAAaAAAAcmFkaXVzbnRAaWVhLXNvZnR3YXJlLmNvbQAAAAMAFQwBAAAA
AwD+DwYAAAAeAAEwAQAAABwAAAAncmFkaXVzbnRAaWVhLXNvZnR3YXJlLmNvbScAAgELMAEAAAAf
AAAAU01UUDpSQURJVVNOVEBJRUEtU09GVFdBUkUuQ09NAAADAAA5AAAAAAsAQDoBAAAAHgD2XwEA
AAAaAAAAcmFkaXVzbnRAaWVhLXNvZnR3YXJlLmNvbQAAAAIB918BAAAAUQAAAAAAAACBKx+kvqMQ
GZ1uAN0BD1QCAAAAAHJhZGl1c250QGllYS1zb2Z0d2FyZS5jb20AU01UUAByYWRpdXNudEBpZWEt
c29mdHdhcmUuY29tAAAAAAMA/V8BAAAAAwD/XwAAAAACAfYPAQAAAAQAAAAAAAACuWgBBIABACMA
AABSRTogW1JhZGl1c05UXSBTUUwgNy4wIHByb2JsZW1zLi4uAIYKAQWAAwAOAAAAzwcGAAoAFgAN
ADAABAA9AQEggAMADgAAAM8HBgAKABYADAA7AAQARwEBCYABACEAAABCNzhBNTM3RjgxMUZEMzEx
ODA0NzAwMTBBNEYyMTEwMgDVBgEDkAYAYBAAACEAAAALAAIAAQAAAAsAIwAAAAAAAwAmAAAAAAAL
ACkAAAAAAAMALgAAAAAAAwA2AAAAAABAADkAgKqYsTqzvgEeAHAAAQAAACMAAABSRTogW1JhZGl1
c05UXSBTUUwgNy4wIHByb2JsZW1zLi4uAAACAXEAAQAAABYAAAABvrM6sX5/U4q4H4ER04BHABCk
8hECAAAeAB4MAQAAAAUAAABTTVRQAAAAAB4AHwwBAAAADAAAAG1pY2tAdHNuLmNjAAMABhCJb3SF
AwAHEIIJAAAeAAgQAQAAAGUAAABTUUw3MElTQUdSRUFUUExBVEZPUk1USEVPTkxZUFJPQkxFTUlT
WU9VUk1BQ0hJTkVXSUxMSEFWRVRPQkVVUEdSQURFREFTU1FMSVNBTE9UTU9SRUlOVEVOU0lWRVRI
QU5BQ0NFAAAAAAIBCRABAAAAQQ0AAD0NAADMHQAATFpGde6rU5IDAAoAcmNwZzEyNXIyDGBjMQMw
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+vzVle1NgUUwgNy42MAQAILebwAnBW4AgiLKD8i5akP0x0CAC
IHCQu8ADYAJgiJBVuxJ5CGEgAMFoauEgHQPwbAMgFuBQMXRvIPpiE4B1DgBRAAEANbBNgP8GALqx
uyMJAAVABGAa8LsQvwIwCfAAkL7ymxG7QGOLIH8EEAqFwry2FLbft+8FQHvvikEW4GsABgF1s8EX
AMMv/8QzatC0EsSPxZ8AAA9XNXNDNjAS8mJrbWuzIyCOX4IAAxBbcWF9Lc4yfk+4sQuAB0AF0MKB
URBl/84zw5u2dmZdcoDJX3QfdS//ap9rr2y/bc+6RMuvWkMMghsF0MbFSL0gvhEgW1NATVRQOm1o
3ENADGN5v1DT4Hluay75NfB0Xc/f0ORyG9If0y//1D92H7k/2aUMMMu+BmACMB/bVAKRy768cAhw
c2Rh7HksPxA2MErHUBOAL/Dx6oAgOToUUMOW5k/pIm9asOffzEW/sWnkMAIwQJkIkGEtipJw8WUu
BaDmbesPzAlDY+zvzDYHwPvvcAWwa4rQhOBRAFAQAiD/iQCBwQSQ8A/m2lr18f/MRRNlMFqAW1Lu
g05UXefAM7rivQVzLvqg3m+2sv/JH8ov5G+5zMgv/E/9X8Zj61twMaAswrxXE4AW0Fsg30hQNbDC
AL8BB3Et1XHBUV+7QL6hiqC8oL3RVPlgJ6BzL01BWAdwIFogfncTgL7Tm8AHQbtAg5Agt1mwCoUH
oSAUUNegLxPw/9egB/EFkbzg75EGgxcRvxLXT5GMkRDgZPqQIATSCyJ/MXC+ks9gEQA+4gWSADUi
ICdwa19DBpFzJ3u8UA8wbhNQBkIXEM1hZP+/gNWghhCI4UhQCwD74b0gyVsSICcPNCIgPICKcPZy
DLHCvEMFJfRh/jLPYP8XABRzvIGGEY7wvxDbgDGguwfxwNBvBVLHUwWDJxS2/Ccgg/EOKhW6CQKH
oMdR5iAP4b4xZyEMwY+iC5B/3RBQoDWwCCFyMAkRBZFt++nQCQJ3CFCH0AA1FLcbpfe/UQWRJfA/
x78A3wHvxfqvBOK7gr/i+/BJs8F4wALcc3UU4TFwv+FiCwCKQP9IUNuhvqAXMQZiu8CKgIfQ6fRh
My9mYC/qkU2AH/8PIQ8iH8ZjE5ZSRUFUYkUkQE5ERQnws7J4dF9BwmB054DPMPRRSVk1sE9OD6EP
USgtCyn/wry8cLshcPC7ME2x6lA+sP/icIUwveAICGExC5FlUc7hpdeRJYkAUFXBUWMpYM+DgMJx
C5AzgWUhBA8IU/+/UIOAv3A0MQ4ULQHCgVBQ/EIgZVL0UgbR+QY0JL2i/xwx45AdZ1nxinAQkIsg
JABfUAAxjb8hTbC7QGKKkGz/1YDcAAsAD+C98cFjwiA48fkVRXN5JTGJsM/GOLUIIfk6OU1T+ZM7
PeOgg4HApf8G0QXSwMAxEbOhRwAdhryB/8FiQ3DO4fomCPNCATOgiwHPFSEG4LqiWiBJJ76hv1H+
Z/vAO9MNscHxuyFB0g3BrxZBJ+WCkcIxZ7ahIUpQ/wzARxCJsBrChWEOEruhvgD/3ZFAl8ARD+IF
kr9QJuEFEP5vi5EH8SflS8QIIR6FCFMPDGHBsMdxv+FPUkFD5ExFH31BbgsAwgAGIP198XMffSfl
zjNUGSfli+N3GEB69RZBRbxQZTC/4UqtEuE87n/vhj7DHU/78PfYMOoh6rA5HNGH0Onw6tD2M+nQ
Vk93inB7YFLMWPD7271cczpdN1j3X4JR+hU0v7shvQDV8PRQ/hAmsz9fuv8wMzLzGsO7EuJgwcBL
MmIh8bLAYXp5+qhfq1jwidC/OYHp0ClQwgAt0DdQQ8DB/xTgSzPpcHlQFGJncREScHD/DacSo7sw
aDK/4dWgETBmWstmW2fjRRKyOjJ/gNeg8W2wNjI3XwYoXylvxc3nZsTckIpHXVtn47qi54B+cjeB
gWBkoRKgcwBzeF2OVvRQiME3xVBSSQegPFJZbn9vj3CfcalLRf5ZT+P+MD1CEgAPDxAfES//e7Rl
zzAk/gK98DEQwaA4KPsDwLuBZAsACFAV8byBwlG/GlEN44/AjtCHcAyxSWER33xQstADwAP2WPBi
BjE5Iv0ehG4XoAuRwUGH0MCzg8L/BuA5IjDA6dAFkfvwBRO9pP8F0gYhRYNdNwWSj8DjoFABnwW0
RmP5Bn7/bL8zN23ivydgbgBmW3Jfc290fEy+Qv4x+NAkUIOBg2GGMd3gzUD+eGZb1cBTAQdwfu9j
Nkhy/HlwfUG+oAsAkCCJEb5R/nDVgA3jm8AYMCZz/hBEsv9DERhhJOAFEBL4Zj3ngAxifRzRYgYi
9GA48QigHBBln/PQBZK6onyxkUJnb4tB/wvjMxG9AcJyGGBmW9WAzcCsaXr0MwyxUwvgcJdQt0Oh
gSgJEUM8gCQARjZB//RhMMCLQRqlg8O7QKHAMRHfwqZmxEtzBZL5AUxoQBX2/0vBHuW890bws9DV
4A3npqv/ZlviQEsxglSeFdxR89BJs+8L4YHR1aANUWMzM6C6mp//xyCX5YHQirCzUAVjuyMdMP/N
wDXRrHL0YbqhuuCkg4Iz/zwDZ5MOOYohFMQMsbxxwTH/MIImpL/h86JTABpTGFI64Hvp0IUySTCy
hiGB0AXwbf/dobQZvIEkgMJQu7G9FLxQ/7fwSuM60ju4Z5OtUSfASzL+KBhh+8CIcR8jkDAvRook
730Q6aB9cRYUdgyhNkgWFP+ZogyyHUKjs4ikFMRdN/Rh/4ijFboWkmszH3ZfqV03zjD/xa9Y8Ftv
ySNVgDKiJAIkAPv5Bl03X8tfzG/M5Xafd6/7eL9xpUkr8K/h72Tp0JMx9ckTd9LwLu8Pzg/PH9Av
nyspU6/ZL1TKXc08bU2wOV5iQGNL4eJwk+BrLtWVAHRsNkPckkzc4fNm59JU1DVuMDE0BNAnwGQS
ewvg+/BBCHH2sDrg6lBDfDE21DX5ADOglQDp0Febt/AJMDPq4OF2KDTf0OIpWhA4NC3p8OPQEwA+
RpQQ42visNQ1/nB0cHg6Ly/S8tyL94D3kCqZ9YBrbX2gCRFfTVWhiwOwlAB91DZ9AADpsAAAAAMA
EBAAAAAAAwAREAAAAAADAIAQ/////0AABzAgE1OUOrO+AUAACDAgE1OUOrO+AQsAAIAIIAYAAAAA
AMAAAAAAAABGAAAAAAOFAAAAAAAAAwACgAggBgAAAAAAwAAAAAAAAEYAAAAAEIUAAAAAAAADAAWA
CCAGAAAAAADAAAAAAAAARgAAAABShQAAtw0AAB4AJYAIIAYAAAAAAMAAAAAAAABGAAAAAFSFAAAB
AAAABAAAADguMAADACaACCAGAAAAAADAAAAAAAAARgAAAAABhQAAAAAAAAsAL4AIIAYAAAAAAMAA
AAAAAABGAAAAAA6FAAAAAAAAAwAwgAggBgAAAAAAwAAAAAAAAEYAAAAAEYUAAAAAAAADADKACCAG
AAAAAADAAAAAAAAARgAAAAAYhQAAAAAAAB4AQYAIIAYAAAAAAMAAAAAAAABGAAAAADaFAAABAAAA
AQAAAAAAAAAeAEKACCAGAAAAAADAAAAAAAAARgAAAAA3hQAAAQAAAAEAAAAAAAAAHgBDgAggBgAA
AAAAwAAAAAAAAEYAAAAAOIUAAAEAAAABAAAAAAAAAB4APQABAAAABQAAAFJFOiAAAAAAAwANNP03
AACBJw==
------ =_NextPart_000_01BEB38E.8404FD40--