The SQL cluster is a MS_SQL server fail over cluster one active one
passive setup. So all call are going to a single server. I currently have
a call in with Allaire. I am working on a code biased workaround since
<cferror> does catch the error. To give the user a new cfide and token
(delete there cookies) and redirect them back the application since new
cookies fix the problem. (and maybe truncate the tables.)
Daniel
-----Original Message-----
From: Nat Papovich [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 22, 2001 6:03 PM
To: Fusebox
Subject: RE: weird client variable problem
I had this error pop up once on a heavily-hit site, and since it didn't show
up again, I attributed it to an improper lock occuring on the client tables
in the DB.
What is your DB SQL cluster like? You did say _cluster_ of SQL servers,
right?
NAT
> -----Original Message-----
> From: Daniel Daugherty [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 22, 2001 9:02 AM
> To: Fusebox
> Subject: OT: weird client variable problem
>
>
> Has anyone see the following error before?
>
> ODBC Error Code = 23000 (Integrity constraint violation)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key
> row in object 'CDATA' with unique index 'id1'.
>
> We have had this error pop up on 3 or 4 occasions. The set up is 2 web
> server with Round Robin DNS and a 2 server SQL Cluster behind
> that. Client
> variables are being stored in a database on the SQL cluster. From what I
> can tell of the error some how it appears that CF Server is
> trying to insert
> the same client variable record into the database twice. The
> server are not
> under high load and everything else is functioning this error has just
> started appearing. If you have any ideas suggestion please let me know.
>
>
> Thanks
> Daniel Daugherty
> Nucleus Tech.
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
