Ok, I keep getting SQL Server assertions in the event log, with the
following stack dump message in the SQL Server logs. Any ideas?
DBCC CHECKDB reveals no problems.
* ----
2004-04-02 04:03:13.39 spid234 Stack Signature for the dump is 0x2EF0EDAD
2004-04-02 04:03:13.39 spid234 SQL Server Assertion: File: <insert.c>,
line=573
Failed Assertion = 'sdesP->m_pIndex->indindid == CLUSTIND'.
2004-04-02 04:03:13.39 spid234 Error: 3624, Severity: 20, State: 1.
*Dump thread - spid = 84, PSS = 0x3e049238, EC = 0x3e049560
*Stack Dump being sent to I:\Microsoft SQL Server\MSSQL\log\SQLDump0033.txt
*
************************************************** **************************
***
Thanks in advance,
Jerry Dennany
Jerry,
If you search MS site for error 3624, which is mentioned in the stack dump,
you will find plenty of articles
(http://search.microsoft.com/search/r...1&s=0&c=3&st=b
&qu=3624&na=32). There are many possible reasons for this error. Just by
reading the article titles I guess you will be able to narrow the search to
your problem.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Jerry Dennany" <jerry@.dennany.org> wrote in message
news:uMM$BVDJEHA.556@.TK2MSFTNGP10.phx.gbl...
>
> Ok, I keep getting SQL Server assertions in the event log, with the
> following stack dump message in the SQL Server logs. Any ideas?
> DBCC CHECKDB reveals no problems.
>
>
* ----
> --
> 2004-04-02 04:03:13.39 spid234 Stack Signature for the dump is
0x2EF0EDAD
> 2004-04-02 04:03:13.39 spid234 SQL Server Assertion: File: <insert.c>,
> line=573
> Failed Assertion = 'sdesP->m_pIndex->indindid == CLUSTIND'.
> 2004-04-02 04:03:13.39 spid234 Error: 3624, Severity: 20, State: 1.
> *Dump thread - spid = 84, PSS = 0x3e049238, EC = 0x3e049560
> *Stack Dump being sent to I:\Microsoft SQL
Server\MSSQL\log\SQLDump0033.txt
> *
>
************************************************** **************************
> ***
>
> Thanks in advance,
> Jerry Dennany
>
|||I suppose that I should have mentioned that I've already performed the
typical google and support.microsoft.com searches, without finding anything
applicable. Any other ideas?
Thanks,
Jerry Dennany
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > wrote in
message news:OTZriQGJEHA.3704@.TK2MSFTNGP11.phx.gbl...
> Jerry,
> If you search MS site for error 3624, which is mentioned in the stack
dump,
> you will find plenty of articles
>
(http://search.microsoft.com/search/r...1&s=0&c=3&st=b
> &qu=3624&na=32). There are many possible reasons for this error. Just by
> reading the article titles I guess you will be able to narrow the search
to
> your problem.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> "Jerry Dennany" <jerry@.dennany.org> wrote in message
> news:uMM$BVDJEHA.556@.TK2MSFTNGP10.phx.gbl...
>
* ----
> 0x2EF0EDAD
> Server\MSSQL\log\SQLDump0033.txt
>
************************************************** **************************
>
|||> I suppose that I should have mentioned that I've already performed the
> typical google and support.microsoft.com searches, without finding
anything
> applicable. Any other ideas?
Sorry, not directly. Maybe you can track down what happens before this
error, which command makes the problem? It would be nice if the problem
would be reproducable.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
|||The following is the SqlException our code got when that happens. What Jerry and I don't understand is that the error message "Duplicate key was ignored" should be associated with SQL error 3604, which is only on severity level 16 that will not throw the exception, (while error 3624 is on level 20).
The database table has a composit unique index (Odometer, QueueID) with "Ignore duplicate key", and a composit cluster index (QueuedTime, Odometer). The Odometer column (int) is involved in both indexes.
Also, the server has 4 physical CPUs with hypertheading to 8 virtual processors.
Error: 3624
General message:
Location: insert.c:573
Expression: sdesP->m_pIndex->indindid == CLUSTIND
SPID: 168
Process ID: 2920
Duplicate key was ignored.
Detailed message: ELKUpdateStatusFromAnyStatus:System.Data.SqlClient .SqlException:
Location: insert.c:573
Expression: sdesP->m_pIndex->indindid == CLUSTIND
SPID: 168
Process ID: 2920
Duplicate key was ignored.
at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at ?RunCommand@.@.$$FYAXHPADPAV?$list@.PAU_PARAM@.@.V?$all ocator@.PAU_PARAM@.@.@.std@.@.@.std@.@.W4COMMANDTYPE@.@.@.Z(In t32
Yang Cao
MCSD, MCDBA
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > wrote in message news:ecsLMESJEHA.3068@.TK2MSFTNGP10.phx.gbl...
> anything
> Sorry, not directly. Maybe you can track down what happens before this
> error, which command makes the problem? It would be nice if the problem
> would be reproducable.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
>
|||Can you send me the code directly to my e-mail (just take out the "_please_reply..." part out of the address and I will try to reproduce the error? BTW, which versions of SQL Server and .NET Framework are you using?
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Yang Cao" <yang@.yangcao88.com> wrote in message news:uu3i%23lUJEHA.3436@.tk2msftngp13.phx.gbl...
The following is the SqlException our code got when that happens. What Jerry and I don't understand is that the error message "Duplicate key was ignored" should be associated with SQL error 3604, which is only on severity level 16 that will not throw the exception, (while error 3624 is on level 20).
The database table has a composit unique index (Odometer, QueueID) with "Ignore duplicate key", and a composit cluster index (QueuedTime, Odometer). The Odometer column (int) is involved in both indexes.
Also, the server has 4 physical CPUs with hypertheading to 8 virtual processors.
Error: 3624
General message:
Location: insert.c:573
Expression: sdesP->m_pIndex->indindid == CLUSTIND
SPID: 168
Process ID: 2920
Duplicate key was ignored.
Detailed message: ELKUpdateStatusFromAnyStatus:System.Data.SqlClient .SqlException:
Location: insert.c:573
Expression: sdesP->m_pIndex->indindid == CLUSTIND
SPID: 168
Process ID: 2920
Duplicate key was ignored.
at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at ?RunCommand@.@.$$FYAXHPADPAV?$list@.PAU_PARAM@.@.V?$all ocator@.PAU_PARAM@.@.@.std@.@.@.std@.@.W4COMMANDTYPE@.@.@.Z(In t32
Yang Cao
MCSD, MCDBA
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > wrote in message news:ecsLMESJEHA.3068@.TK2MSFTNGP10.phx.gbl...
> anything
> Sorry, not directly. Maybe you can track down what happens before this
> error, which command makes the problem? It would be nice if the problem
> would be reproducable.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
>
Showing posts with label dump. Show all posts
Showing posts with label dump. Show all posts
Thursday, March 22, 2012
Error: 3624 - SQL Server Assertion
Ok, I keep getting SQL Server assertions in the event log, with the
following stack dump message in the SQL Server logs. Any ideas?
DBCC CHECKDB reveals no problems.
* ----
--
2004-04-02 04:03:13.39 spid234 Stack Signature for the dump is 0x2EF0EDAD
2004-04-02 04:03:13.39 spid234 SQL Server Assertion: File: <insert.c>,
line=573
Failed Assertion = 'sdesP->m_pIndex->indindid == CLUSTIND'.
2004-04-02 04:03:13.39 spid234 Error: 3624, Severity: 20, State: 1.
*Dump thread - spid = 84, PSS = 0x3e049238, EC = 0x3e049560
*Stack Dump being sent to I:\Microsoft SQL Server\MSSQL\log\SQLDump0033.txt
*
****************************************
************************************
***
Thanks in advance,
Jerry DennanyJerry,
If you search MS site for error 3624, which is mentioned in the stack dump,
you will find plenty of articles
(http://search.microsoft.com/search/...=1&s=0&c=3&st=b
&qu=3624&na=32). There are many possible reasons for this error. Just by
reading the article titles I guess you will be able to narrow the search to
your problem.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Jerry Dennany" <jerry@.dennany.org> wrote in message
news:uMM$BVDJEHA.556@.TK2MSFTNGP10.phx.gbl...
>
> Ok, I keep getting SQL Server assertions in the event log, with the
> following stack dump message in the SQL Server logs. Any ideas?
> DBCC CHECKDB reveals no problems.
>
>
* ----
> --
> 2004-04-02 04:03:13.39 spid234 Stack Signature for the dump is
0x2EF0EDAD
> 2004-04-02 04:03:13.39 spid234 SQL Server Assertion: File: <insert.c>,
> line=573
> Failed Assertion = 'sdesP->m_pIndex->indindid == CLUSTIND'.
> 2004-04-02 04:03:13.39 spid234 Error: 3624, Severity: 20, State: 1.
> *Dump thread - spid = 84, PSS = 0x3e049238, EC = 0x3e049560
> *Stack Dump being sent to I:\Microsoft SQL
Server\MSSQL\log\SQLDump0033.txt
> *
>
****************************************
************************************[vbc
ol=seagreen]
> ***
>
> Thanks in advance,
> Jerry Dennany
>[/vbcol]|||I suppose that I should have mentioned that I've already performed the
typical google and support.microsoft.com searches, without finding anything
applicable. Any other ideas?
Thanks,
Jerry Dennany
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:OTZriQGJEHA.3704@.TK2MSFTNGP11.phx.gbl...
> Jerry,
> If you search MS site for error 3624, which is mentioned in the stack
dump,
> you will find plenty of articles
>
(http://search.microsoft.com/search/...=1&s=0&c=3&st=b
> &qu=3624&na=32). There are many possible reasons for this error. Just by
> reading the article titles I guess you will be able to narrow the search
to
> your problem.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> "Jerry Dennany" <jerry@.dennany.org> wrote in message
> news:uMM$BVDJEHA.556@.TK2MSFTNGP10.phx.gbl...
>
* ----
> 0x2EF0EDAD
> Server\MSSQL\log\SQLDump0033.txt
>
****************************************
************************************[vbc
ol=seagreen]
>[/vbcol]|||> I suppose that I should have mentioned that I've already performed the
> typical google and support.microsoft.com searches, without finding
anything
> applicable. Any other ideas?
Sorry, not directly. Maybe you can track down what happens before this
error, which command makes the problem? It would be nice if the problem
would be reproducable.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com|||The following is the SqlException our code got when that happens. What Jerr
y and I don't understand is that the error message "Duplicate key was ignore
d" should be associated with SQL error 3604, which is only on severity level
16 that will not throw the exception, (while error 3624 is on level 20).
The database table has a composit unique index (Odometer, QueueID) with "Ign
ore duplicate key", and a composit cluster index (QueuedTime, Odometer). Th
e Odometer column (int) is involved in both indexes.
Also, the server has 4 physical CPUs with hypertheading to 8 virtual process
ors.
Error: 3624
General message:
Location: insert.c:573
Expression: sdesP->m_pIndex->indindid == CLUSTIND
SPID: 168
Process ID: 2920
Duplicate key was ignored.
Detailed message: ELKUpdateStatusFromAnyStatus:System.Data.SqlClient.SqlExce
ption:
Location: insert.c:573
Expression: sdesP->m_pIndex->indindid == CLUSTIND
SPID: 168
Process ID: 2920
Duplicate key was ignored.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavio
r, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at ?RunCommand@.@.$$FYAXHPADPAV?$list@.PAU_PARAM@.@.V?$allocator@.PAU_PARAM@.@.@.std@.
@.@.std@.@.W4COMMANDTYPE@.@.@.Z(Int32
Yang Cao
MCSD, MCDBA
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in message news:ecsL
MESJEHA.3068@.TK2MSFTNGP10.phx.gbl...
> anything
>
> Sorry, not directly. Maybe you can track down what happens before this
> error, which command makes the problem? It would be nice if the problem
> would be reproducable.
>
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
>
>|||Can you send me the code directly to my e-mail (just take out the "_please_r
eply..." part out of the address and I will try to reproduce the error? BTW,
which versions of SQL Server and .NET Framework are you using?
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Yang Cao" <yang@.yangcao88.com> wrote in message news:uu3i%23lUJEHA.3436@.tk2
msftngp13.phx.gbl...
The following is the SqlException our code got when that happens. What Jerr
y and I don't understand is that the error message "Duplicate key was ignore
d" should be associated with SQL error 3604, which is only on severity level
16 that will not throw the exception, (while error 3624 is on level 20).
The database table has a composit unique index (Odometer, QueueID) with "Ign
ore duplicate key", and a composit cluster index (QueuedTime, Odometer). Th
e Odometer column (int) is involved in both indexes.
Also, the server has 4 physical CPUs with hypertheading to 8 virtual process
ors.
Error: 3624
General message:
Location: insert.c:573
Expression: sdesP->m_pIndex->indindid == CLUSTIND
SPID: 168
Process ID: 2920
Duplicate key was ignored.
Detailed message: ELKUpdateStatusFromAnyStatus:System.Data.SqlClient.SqlExce
ption:
Location: insert.c:573
Expression: sdesP->m_pIndex->indindid == CLUSTIND
SPID: 168
Process ID: 2920
Duplicate key was ignored.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavio
r, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at ?RunCommand@.@.$$FYAXHPADPAV?$list@.PAU_PARAM@.@.V?$allocator@.PAU_PARAM@.@.@.std@.
@.@.std@.@.W4COMMANDTYPE@.@.@.Z(Int32
Yang Cao
MCSD, MCDBA
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in message news:ecsL
MESJEHA.3068@.TK2MSFTNGP10.phx.gbl...
> anything
>
> Sorry, not directly. Maybe you can track down what happens before this
> error, which command makes the problem? It would be nice if the problem
> would be reproducable.
>
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
>
>
following stack dump message in the SQL Server logs. Any ideas?
DBCC CHECKDB reveals no problems.
* ----
--
2004-04-02 04:03:13.39 spid234 Stack Signature for the dump is 0x2EF0EDAD
2004-04-02 04:03:13.39 spid234 SQL Server Assertion: File: <insert.c>,
line=573
Failed Assertion = 'sdesP->m_pIndex->indindid == CLUSTIND'.
2004-04-02 04:03:13.39 spid234 Error: 3624, Severity: 20, State: 1.
*Dump thread - spid = 84, PSS = 0x3e049238, EC = 0x3e049560
*Stack Dump being sent to I:\Microsoft SQL Server\MSSQL\log\SQLDump0033.txt
*
****************************************
************************************
***
Thanks in advance,
Jerry DennanyJerry,
If you search MS site for error 3624, which is mentioned in the stack dump,
you will find plenty of articles
(http://search.microsoft.com/search/...=1&s=0&c=3&st=b
&qu=3624&na=32). There are many possible reasons for this error. Just by
reading the article titles I guess you will be able to narrow the search to
your problem.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Jerry Dennany" <jerry@.dennany.org> wrote in message
news:uMM$BVDJEHA.556@.TK2MSFTNGP10.phx.gbl...
>
> Ok, I keep getting SQL Server assertions in the event log, with the
> following stack dump message in the SQL Server logs. Any ideas?
> DBCC CHECKDB reveals no problems.
>
>
* ----
> --
> 2004-04-02 04:03:13.39 spid234 Stack Signature for the dump is
0x2EF0EDAD
> 2004-04-02 04:03:13.39 spid234 SQL Server Assertion: File: <insert.c>,
> line=573
> Failed Assertion = 'sdesP->m_pIndex->indindid == CLUSTIND'.
> 2004-04-02 04:03:13.39 spid234 Error: 3624, Severity: 20, State: 1.
> *Dump thread - spid = 84, PSS = 0x3e049238, EC = 0x3e049560
> *Stack Dump being sent to I:\Microsoft SQL
Server\MSSQL\log\SQLDump0033.txt
> *
>
****************************************
************************************[vbc
ol=seagreen]
> ***
>
> Thanks in advance,
> Jerry Dennany
>[/vbcol]|||I suppose that I should have mentioned that I've already performed the
typical google and support.microsoft.com searches, without finding anything
applicable. Any other ideas?
Thanks,
Jerry Dennany
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:OTZriQGJEHA.3704@.TK2MSFTNGP11.phx.gbl...
> Jerry,
> If you search MS site for error 3624, which is mentioned in the stack
dump,
> you will find plenty of articles
>
(http://search.microsoft.com/search/...=1&s=0&c=3&st=b
> &qu=3624&na=32). There are many possible reasons for this error. Just by
> reading the article titles I guess you will be able to narrow the search
to
> your problem.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> "Jerry Dennany" <jerry@.dennany.org> wrote in message
> news:uMM$BVDJEHA.556@.TK2MSFTNGP10.phx.gbl...
>
* ----
> 0x2EF0EDAD
> Server\MSSQL\log\SQLDump0033.txt
>
****************************************
************************************[vbc
ol=seagreen]
>[/vbcol]|||> I suppose that I should have mentioned that I've already performed the
> typical google and support.microsoft.com searches, without finding
anything
> applicable. Any other ideas?
Sorry, not directly. Maybe you can track down what happens before this
error, which command makes the problem? It would be nice if the problem
would be reproducable.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com|||The following is the SqlException our code got when that happens. What Jerr
y and I don't understand is that the error message "Duplicate key was ignore
d" should be associated with SQL error 3604, which is only on severity level
16 that will not throw the exception, (while error 3624 is on level 20).
The database table has a composit unique index (Odometer, QueueID) with "Ign
ore duplicate key", and a composit cluster index (QueuedTime, Odometer). Th
e Odometer column (int) is involved in both indexes.
Also, the server has 4 physical CPUs with hypertheading to 8 virtual process
ors.
Error: 3624
General message:
Location: insert.c:573
Expression: sdesP->m_pIndex->indindid == CLUSTIND
SPID: 168
Process ID: 2920
Duplicate key was ignored.
Detailed message: ELKUpdateStatusFromAnyStatus:System.Data.SqlClient.SqlExce
ption:
Location: insert.c:573
Expression: sdesP->m_pIndex->indindid == CLUSTIND
SPID: 168
Process ID: 2920
Duplicate key was ignored.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavio
r, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at ?RunCommand@.@.$$FYAXHPADPAV?$list@.PAU_PARAM@.@.V?$allocator@.PAU_PARAM@.@.@.std@.
@.@.std@.@.W4COMMANDTYPE@.@.@.Z(Int32
Yang Cao
MCSD, MCDBA
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in message news:ecsL
MESJEHA.3068@.TK2MSFTNGP10.phx.gbl...
> anything
>
> Sorry, not directly. Maybe you can track down what happens before this
> error, which command makes the problem? It would be nice if the problem
> would be reproducable.
>
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
>
>|||Can you send me the code directly to my e-mail (just take out the "_please_r
eply..." part out of the address and I will try to reproduce the error? BTW,
which versions of SQL Server and .NET Framework are you using?
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Yang Cao" <yang@.yangcao88.com> wrote in message news:uu3i%23lUJEHA.3436@.tk2
msftngp13.phx.gbl...
The following is the SqlException our code got when that happens. What Jerr
y and I don't understand is that the error message "Duplicate key was ignore
d" should be associated with SQL error 3604, which is only on severity level
16 that will not throw the exception, (while error 3624 is on level 20).
The database table has a composit unique index (Odometer, QueueID) with "Ign
ore duplicate key", and a composit cluster index (QueuedTime, Odometer). Th
e Odometer column (int) is involved in both indexes.
Also, the server has 4 physical CPUs with hypertheading to 8 virtual process
ors.
Error: 3624
General message:
Location: insert.c:573
Expression: sdesP->m_pIndex->indindid == CLUSTIND
SPID: 168
Process ID: 2920
Duplicate key was ignored.
Detailed message: ELKUpdateStatusFromAnyStatus:System.Data.SqlClient.SqlExce
ption:
Location: insert.c:573
Expression: sdesP->m_pIndex->indindid == CLUSTIND
SPID: 168
Process ID: 2920
Duplicate key was ignored.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavio
r, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at ?RunCommand@.@.$$FYAXHPADPAV?$list@.PAU_PARAM@.@.V?$allocator@.PAU_PARAM@.@.@.std@.
@.@.std@.@.W4COMMANDTYPE@.@.@.Z(Int32
Yang Cao
MCSD, MCDBA
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in message news:ecsL
MESJEHA.3068@.TK2MSFTNGP10.phx.gbl...
> anything
>
> Sorry, not directly. Maybe you can track down what happens before this
> error, which command makes the problem? It would be nice if the problem
> would be reproducable.
>
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
>
>
Error: 3624 - SQL Server Assertion
Ok, I keep getting SQL Server assertions in the event log, with the
following stack dump message in the SQL Server logs. Any ideas?
DBCC CHECKDB reveals no problems.
* ----
--
2004-04-02 04:03:13.39 spid234 Stack Signature for the dump is 0x2EF0EDAD
2004-04-02 04:03:13.39 spid234 SQL Server Assertion: File: <insert.c>,
line=573
Failed Assertion = 'sdesP->m_pIndex->indindid == CLUSTIND'.
2004-04-02 04:03:13.39 spid234 Error: 3624, Severity: 20, State: 1.
*Dump thread - spid = 84, PSS = 0x3e049238, EC = 0x3e049560
*Stack Dump being sent to I:\Microsoft SQL Server\MSSQL\log\SQLDump0033.txt
*
****************************************************************************
***
Thanks in advance,
Jerry DennanyJerry,
If you search MS site for error 3624, which is mentioned in the stack dump,
you will find plenty of articles
(http://search.microsoft.com/search/results.aspx?View=en-us&p=1&s=0&c=3&st=b
&qu=3624&na=32). There are many possible reasons for this error. Just by
reading the article titles I guess you will be able to narrow the search to
your problem.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Jerry Dennany" <jerry@.dennany.org> wrote in message
news:uMM$BVDJEHA.556@.TK2MSFTNGP10.phx.gbl...
>
> Ok, I keep getting SQL Server assertions in the event log, with the
> following stack dump message in the SQL Server logs. Any ideas?
> DBCC CHECKDB reveals no problems.
>
>
* ----
> --
> 2004-04-02 04:03:13.39 spid234 Stack Signature for the dump is
0x2EF0EDAD
> 2004-04-02 04:03:13.39 spid234 SQL Server Assertion: File: <insert.c>,
> line=573
> Failed Assertion = 'sdesP->m_pIndex->indindid == CLUSTIND'.
> 2004-04-02 04:03:13.39 spid234 Error: 3624, Severity: 20, State: 1.
> *Dump thread - spid = 84, PSS = 0x3e049238, EC = 0x3e049560
> *Stack Dump being sent to I:\Microsoft SQL
Server\MSSQL\log\SQLDump0033.txt
> *
>
****************************************************************************
> ***
>
> Thanks in advance,
> Jerry Dennany
>|||I suppose that I should have mentioned that I've already performed the
typical google and support.microsoft.com searches, without finding anything
applicable. Any other ideas?
Thanks,
Jerry Dennany
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:OTZriQGJEHA.3704@.TK2MSFTNGP11.phx.gbl...
> Jerry,
> If you search MS site for error 3624, which is mentioned in the stack
dump,
> you will find plenty of articles
>
(http://search.microsoft.com/search/results.aspx?View=en-us&p=1&s=0&c=3&st=b
> &qu=3624&na=32). There are many possible reasons for this error. Just by
> reading the article titles I guess you will be able to narrow the search
to
> your problem.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> "Jerry Dennany" <jerry@.dennany.org> wrote in message
> news:uMM$BVDJEHA.556@.TK2MSFTNGP10.phx.gbl...
> >
> >
> > Ok, I keep getting SQL Server assertions in the event log, with the
> > following stack dump message in the SQL Server logs. Any ideas?
> >
> > DBCC CHECKDB reveals no problems.
> >
> >
> >
>
* ----
> > --
> > 2004-04-02 04:03:13.39 spid234 Stack Signature for the dump is
> 0x2EF0EDAD
> > 2004-04-02 04:03:13.39 spid234 SQL Server Assertion: File: <insert.c>,
> > line=573
> > Failed Assertion = 'sdesP->m_pIndex->indindid == CLUSTIND'.
> > 2004-04-02 04:03:13.39 spid234 Error: 3624, Severity: 20, State: 1.
> > *Dump thread - spid = 84, PSS = 0x3e049238, EC = 0x3e049560
> > *Stack Dump being sent to I:\Microsoft SQL
> Server\MSSQL\log\SQLDump0033.txt
> > *
> >
>
****************************************************************************
> > ***
> >
> >
> > Thanks in advance,
> >
> > Jerry Dennany
> >
> >
>|||> I suppose that I should have mentioned that I've already performed the
> typical google and support.microsoft.com searches, without finding
anything
> applicable. Any other ideas?
Sorry, not directly. Maybe you can track down what happens before this
error, which command makes the problem? It would be nice if the problem
would be reproducable.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com|||This is a multi-part message in MIME format.
--=_NextPart_000_01B4_01C42527.F1365AC0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
The following is the SqlException our code got when that happens. What =Jerry and I don't understand is that the error message "Duplicate key =was ignored" should be associated with SQL error 3604, which is only on =severity level 16 that will not throw the exception, (while error 3624 =is on level 20).
The database table has a composit unique index (Odometer, QueueID) with ="Ignore duplicate key", and a composit cluster index (QueuedTime, =Odometer). The Odometer column (int) is involved in both indexes.
Also, the server has 4 physical CPUs with hypertheading to 8 virtual =processors.
Error: 3624
General message: Location: insert.c:573
Expression: sdesP->m_pIndex->indindid =3D=3D CLUSTIND
SPID: 168
Process ID: 2920
Duplicate key was ignored. Detailed message: =ELKUpdateStatusFromAnyStatus:System.Data.SqlClient.SqlException: Location: insert.c:573
Expression: sdesP->m_pIndex->indindid =3D=3D CLUSTIND
SPID: 168
Process ID: 2920
Duplicate key was ignored.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior =cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at =?RunCommand@.@.$$FYAXHPADPAV?$list@.PAU_PARAM@.@.V?$allocator@.PAU_PARAM@.@.@.std@.=@.@.std@.@.W4COMMANDTYPE@.@.@.Z(Int32
Yang Cao
MCSD, MCDBA
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote =in message news:ecsLMESJEHA.3068@.TK2MSFTNGP10.phx.gbl...
> > I suppose that I should have mentioned that I've already performed =the
> > typical google and support.microsoft.com searches, without finding
> anything
> > applicable. Any other ideas?
> > Sorry, not directly. Maybe you can track down what happens before this
> error, which command makes the problem? It would be nice if the =problem
> would be reproducable.
> > -- > Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> >
--=_NextPart_000_01B4_01C42527.F1365AC0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
The following is the SqlException our =code got when that happens. What Jerry and I don't understand is that the error =message "Duplicate key was ignored" should be associated with SQL error 3604, =which is only on severity level 16 that will not throw the exception, (while =error 3624 is on level 20). The database table has a composit unique index (Odometer, QueueID) with "Ignore duplicate key", and a composit cluster =index (QueuedTime, Odometer). The Odometer column (int) is involved in =both indexes.Also, the server has 4 physical CPUs with hypertheading =to 8 virtual processors. Error: 3624General message: Location: insert.c:573Expression: sdesP->m_pIndex->indindid =3D=3D =CLUSTINDSPID: 168Process ID: 2920Duplicate =key was ignored. Detailed message: ELKUpdateStatusFromAnyStatus:System.Data.SqlClient.SqlException: Location: insert.c:573Expression: sdesP->m_pIndex->indindid =3D=3D CLUSTINDSPID: =168Process ID: 2920Duplicate key was ignored. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior =cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ?RunCommand@.@.$$FYAXHPADPAV?$list@.PAU_PARAM@.@.V?$allocator@.PAU_PARAM@.@.@.std@.=@.@.std@.@.W4COMMANDTYPE@.@.@.Z(Int32
Yang CaoMCSD, =MCDBA"Dejan Sarka" wrote in =message news:ecsLMESJEHA.3068@.TK2MSFTNGP10.phx.gbl...> > I suppose =that I should have mentioned that I've already performed the> > =typical google and support.microsoft.com searches, without finding> anything> > applicable. Any other ideas?> => Sorry, not directly. Maybe you can track down what happens before this> =error, which command makes the problem? It would be nice if the problem> =would be reproducable.> > -- > Dejan Sarka, SQL Server MVP> Associate Mentor> Solid Quality Learning> More =than just Training> www.SolidQualityLearning.com> >
--=_NextPart_000_01B4_01C42527.F1365AC0--|||This is a multi-part message in MIME format.
--=_NextPart_000_003E_01C425F6.395B16F0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Can you send me the code directly to my e-mail (just take out the ="_please_reply..." part out of the address and I will try to reproduce =the error? BTW, which versions of SQL Server and .NET Framework are you =using?
-- Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Yang Cao" <yang@.yangcao88.com> wrote in message =news:uu3i%23lUJEHA.3436@.tk2msftngp13.phx.gbl...
The following is the SqlException our code got when that happens. =What Jerry and I don't understand is that the error message "Duplicate =key was ignored" should be associated with SQL error 3604, which is only =on severity level 16 that will not throw the exception, (while error =3624 is on level 20).
The database table has a composit unique index (Odometer, QueueID) =with "Ignore duplicate key", and a composit cluster index (QueuedTime, =Odometer). The Odometer column (int) is involved in both indexes.
Also, the server has 4 physical CPUs with hypertheading to 8 virtual =processors.
Error: 3624
General message: Location: insert.c:573
Expression: sdesP->m_pIndex->indindid =3D=3D CLUSTIND
SPID: 168
Process ID: 2920
Duplicate key was ignored. Detailed message: =ELKUpdateStatusFromAnyStatus:System.Data.SqlClient.SqlException: Location: insert.c:573
Expression: sdesP->m_pIndex->indindid =3D=3D CLUSTIND
SPID: 168
Process ID: 2920
Duplicate key was ignored.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior =cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at =?RunCommand@.@.$$FYAXHPADPAV?$list@.PAU_PARAM@.@.V?$allocator@.PAU_PARAM@.@.@.std@.=@.@.std@.@.W4COMMANDTYPE@.@.@.Z(Int32
Yang Cao
MCSD, MCDBA
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> =wrote in message news:ecsLMESJEHA.3068@.TK2MSFTNGP10.phx.gbl...
> > I suppose that I should have mentioned that I've already performed =the
> > typical google and support.microsoft.com searches, without finding
> anything
> > applicable. Any other ideas?
> > Sorry, not directly. Maybe you can track down what happens before =this
> error, which command makes the problem? It would be nice if the =problem
> would be reproducable.
> > -- > Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> >
--=_NextPart_000_003E_01C425F6.395B16F0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Can you send me the code directly to my =e-mail (just take out the "_please_reply..." part out of the address and I will =try to reproduce the error? BTW, which versions of SQL Server and .NET =Framework are you using?
-- Dejan Sarka, SQL Server =MVPAssociate MentorSolid Quality LearningMore than just Traininghttp://www.SolidQualityLearning.com">www.SolidQualityLearning.com= "Yang Cao" wrote in =message news:uu3i%23lUJEHA.=3436@.tk2msftngp13.phx.gbl...
The following is the SqlException our =code got when that happens. What Jerry and I don't understand is that the =error message "Duplicate key was ignored" should be associated with SQL =error 3604, which is only on severity level 16 that will not throw the exception, =(while error 3624 is on level 20). The database table has a composit =unique index (Odometer, QueueID) with "Ignore duplicate key", and a composit =cluster index (QueuedTime, Odometer). The Odometer column (int) is =involved in both indexes.Also, the server has 4 physical CPUs with =hypertheading to 8 virtual processors. Error: 3624General message: Location: insert.c:573Expression: sdesP->m_pIndex->indindid ==3D=3D CLUSTINDSPID: 168Process ID: =2920Duplicate key was ignored. Detailed message: ELKUpdateStatusFromAnyStatus:System.Data.SqlClient.SqlException: = Location: insert.c:573Expression: sdesP->m_pIndex->indindid =3D=3D CLUSTINDSPID: 168Process ID: 2920Duplicate key was =ignored. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior =cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at =?RunCommand@.@.$$FYAXHPADPAV?$list@.PAU_PARAM@.@.V?$allocator@.PAU_PARAM@.@.@.std@.=@.@.std@.@.W4COMMANDTYPE@.@.@.Z(Int32
Yang CaoMCSD, =MCDBA"Dejan Sarka" wrote in =message news:ecsLMESJEHA.3068@.TK2MSFTNGP10.phx.gbl...> > I suppose =that I should have mentioned that I've already performed the> > =typical google and support.microsoft.com searches, without finding> anything> > applicable. Any other ideas?> => Sorry, not directly. Maybe you can track down what happens before =this> error, which command makes the problem? It would be nice if the problem> would be reproducable.> > -- > =Dejan Sarka, SQL Server MVP> Associate Mentor> Solid Quality Learning> More than just Training> www.SolidQualityLearning.com> >
--=_NextPart_000_003E_01C425F6.395B16F0--sql
following stack dump message in the SQL Server logs. Any ideas?
DBCC CHECKDB reveals no problems.
* ----
--
2004-04-02 04:03:13.39 spid234 Stack Signature for the dump is 0x2EF0EDAD
2004-04-02 04:03:13.39 spid234 SQL Server Assertion: File: <insert.c>,
line=573
Failed Assertion = 'sdesP->m_pIndex->indindid == CLUSTIND'.
2004-04-02 04:03:13.39 spid234 Error: 3624, Severity: 20, State: 1.
*Dump thread - spid = 84, PSS = 0x3e049238, EC = 0x3e049560
*Stack Dump being sent to I:\Microsoft SQL Server\MSSQL\log\SQLDump0033.txt
*
****************************************************************************
***
Thanks in advance,
Jerry DennanyJerry,
If you search MS site for error 3624, which is mentioned in the stack dump,
you will find plenty of articles
(http://search.microsoft.com/search/results.aspx?View=en-us&p=1&s=0&c=3&st=b
&qu=3624&na=32). There are many possible reasons for this error. Just by
reading the article titles I guess you will be able to narrow the search to
your problem.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Jerry Dennany" <jerry@.dennany.org> wrote in message
news:uMM$BVDJEHA.556@.TK2MSFTNGP10.phx.gbl...
>
> Ok, I keep getting SQL Server assertions in the event log, with the
> following stack dump message in the SQL Server logs. Any ideas?
> DBCC CHECKDB reveals no problems.
>
>
* ----
> --
> 2004-04-02 04:03:13.39 spid234 Stack Signature for the dump is
0x2EF0EDAD
> 2004-04-02 04:03:13.39 spid234 SQL Server Assertion: File: <insert.c>,
> line=573
> Failed Assertion = 'sdesP->m_pIndex->indindid == CLUSTIND'.
> 2004-04-02 04:03:13.39 spid234 Error: 3624, Severity: 20, State: 1.
> *Dump thread - spid = 84, PSS = 0x3e049238, EC = 0x3e049560
> *Stack Dump being sent to I:\Microsoft SQL
Server\MSSQL\log\SQLDump0033.txt
> *
>
****************************************************************************
> ***
>
> Thanks in advance,
> Jerry Dennany
>|||I suppose that I should have mentioned that I've already performed the
typical google and support.microsoft.com searches, without finding anything
applicable. Any other ideas?
Thanks,
Jerry Dennany
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:OTZriQGJEHA.3704@.TK2MSFTNGP11.phx.gbl...
> Jerry,
> If you search MS site for error 3624, which is mentioned in the stack
dump,
> you will find plenty of articles
>
(http://search.microsoft.com/search/results.aspx?View=en-us&p=1&s=0&c=3&st=b
> &qu=3624&na=32). There are many possible reasons for this error. Just by
> reading the article titles I guess you will be able to narrow the search
to
> your problem.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> "Jerry Dennany" <jerry@.dennany.org> wrote in message
> news:uMM$BVDJEHA.556@.TK2MSFTNGP10.phx.gbl...
> >
> >
> > Ok, I keep getting SQL Server assertions in the event log, with the
> > following stack dump message in the SQL Server logs. Any ideas?
> >
> > DBCC CHECKDB reveals no problems.
> >
> >
> >
>
* ----
> > --
> > 2004-04-02 04:03:13.39 spid234 Stack Signature for the dump is
> 0x2EF0EDAD
> > 2004-04-02 04:03:13.39 spid234 SQL Server Assertion: File: <insert.c>,
> > line=573
> > Failed Assertion = 'sdesP->m_pIndex->indindid == CLUSTIND'.
> > 2004-04-02 04:03:13.39 spid234 Error: 3624, Severity: 20, State: 1.
> > *Dump thread - spid = 84, PSS = 0x3e049238, EC = 0x3e049560
> > *Stack Dump being sent to I:\Microsoft SQL
> Server\MSSQL\log\SQLDump0033.txt
> > *
> >
>
****************************************************************************
> > ***
> >
> >
> > Thanks in advance,
> >
> > Jerry Dennany
> >
> >
>|||> I suppose that I should have mentioned that I've already performed the
> typical google and support.microsoft.com searches, without finding
anything
> applicable. Any other ideas?
Sorry, not directly. Maybe you can track down what happens before this
error, which command makes the problem? It would be nice if the problem
would be reproducable.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com|||This is a multi-part message in MIME format.
--=_NextPart_000_01B4_01C42527.F1365AC0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
The following is the SqlException our code got when that happens. What =Jerry and I don't understand is that the error message "Duplicate key =was ignored" should be associated with SQL error 3604, which is only on =severity level 16 that will not throw the exception, (while error 3624 =is on level 20).
The database table has a composit unique index (Odometer, QueueID) with ="Ignore duplicate key", and a composit cluster index (QueuedTime, =Odometer). The Odometer column (int) is involved in both indexes.
Also, the server has 4 physical CPUs with hypertheading to 8 virtual =processors.
Error: 3624
General message: Location: insert.c:573
Expression: sdesP->m_pIndex->indindid =3D=3D CLUSTIND
SPID: 168
Process ID: 2920
Duplicate key was ignored. Detailed message: =ELKUpdateStatusFromAnyStatus:System.Data.SqlClient.SqlException: Location: insert.c:573
Expression: sdesP->m_pIndex->indindid =3D=3D CLUSTIND
SPID: 168
Process ID: 2920
Duplicate key was ignored.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior =cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at =?RunCommand@.@.$$FYAXHPADPAV?$list@.PAU_PARAM@.@.V?$allocator@.PAU_PARAM@.@.@.std@.=@.@.std@.@.W4COMMANDTYPE@.@.@.Z(Int32
Yang Cao
MCSD, MCDBA
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote =in message news:ecsLMESJEHA.3068@.TK2MSFTNGP10.phx.gbl...
> > I suppose that I should have mentioned that I've already performed =the
> > typical google and support.microsoft.com searches, without finding
> anything
> > applicable. Any other ideas?
> > Sorry, not directly. Maybe you can track down what happens before this
> error, which command makes the problem? It would be nice if the =problem
> would be reproducable.
> > -- > Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> >
--=_NextPart_000_01B4_01C42527.F1365AC0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
The following is the SqlException our =code got when that happens. What Jerry and I don't understand is that the error =message "Duplicate key was ignored" should be associated with SQL error 3604, =which is only on severity level 16 that will not throw the exception, (while =error 3624 is on level 20). The database table has a composit unique index (Odometer, QueueID) with "Ignore duplicate key", and a composit cluster =index (QueuedTime, Odometer). The Odometer column (int) is involved in =both indexes.Also, the server has 4 physical CPUs with hypertheading =to 8 virtual processors. Error: 3624General message: Location: insert.c:573Expression: sdesP->m_pIndex->indindid =3D=3D =CLUSTINDSPID: 168Process ID: 2920Duplicate =key was ignored. Detailed message: ELKUpdateStatusFromAnyStatus:System.Data.SqlClient.SqlException: Location: insert.c:573Expression: sdesP->m_pIndex->indindid =3D=3D CLUSTINDSPID: =168Process ID: 2920Duplicate key was ignored. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior =cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ?RunCommand@.@.$$FYAXHPADPAV?$list@.PAU_PARAM@.@.V?$allocator@.PAU_PARAM@.@.@.std@.=@.@.std@.@.W4COMMANDTYPE@.@.@.Z(Int32
Yang CaoMCSD, =MCDBA"Dejan Sarka" wrote in =message news:ecsLMESJEHA.3068@.TK2MSFTNGP10.phx.gbl...> > I suppose =that I should have mentioned that I've already performed the> > =typical google and support.microsoft.com searches, without finding> anything> > applicable. Any other ideas?> => Sorry, not directly. Maybe you can track down what happens before this> =error, which command makes the problem? It would be nice if the problem> =would be reproducable.> > -- > Dejan Sarka, SQL Server MVP> Associate Mentor> Solid Quality Learning> More =than just Training> www.SolidQualityLearning.com> >
--=_NextPart_000_01B4_01C42527.F1365AC0--|||This is a multi-part message in MIME format.
--=_NextPart_000_003E_01C425F6.395B16F0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Can you send me the code directly to my e-mail (just take out the ="_please_reply..." part out of the address and I will try to reproduce =the error? BTW, which versions of SQL Server and .NET Framework are you =using?
-- Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Yang Cao" <yang@.yangcao88.com> wrote in message =news:uu3i%23lUJEHA.3436@.tk2msftngp13.phx.gbl...
The following is the SqlException our code got when that happens. =What Jerry and I don't understand is that the error message "Duplicate =key was ignored" should be associated with SQL error 3604, which is only =on severity level 16 that will not throw the exception, (while error =3624 is on level 20).
The database table has a composit unique index (Odometer, QueueID) =with "Ignore duplicate key", and a composit cluster index (QueuedTime, =Odometer). The Odometer column (int) is involved in both indexes.
Also, the server has 4 physical CPUs with hypertheading to 8 virtual =processors.
Error: 3624
General message: Location: insert.c:573
Expression: sdesP->m_pIndex->indindid =3D=3D CLUSTIND
SPID: 168
Process ID: 2920
Duplicate key was ignored. Detailed message: =ELKUpdateStatusFromAnyStatus:System.Data.SqlClient.SqlException: Location: insert.c:573
Expression: sdesP->m_pIndex->indindid =3D=3D CLUSTIND
SPID: 168
Process ID: 2920
Duplicate key was ignored.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior =cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at =?RunCommand@.@.$$FYAXHPADPAV?$list@.PAU_PARAM@.@.V?$allocator@.PAU_PARAM@.@.@.std@.=@.@.std@.@.W4COMMANDTYPE@.@.@.Z(Int32
Yang Cao
MCSD, MCDBA
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> =wrote in message news:ecsLMESJEHA.3068@.TK2MSFTNGP10.phx.gbl...
> > I suppose that I should have mentioned that I've already performed =the
> > typical google and support.microsoft.com searches, without finding
> anything
> > applicable. Any other ideas?
> > Sorry, not directly. Maybe you can track down what happens before =this
> error, which command makes the problem? It would be nice if the =problem
> would be reproducable.
> > -- > Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> >
--=_NextPart_000_003E_01C425F6.395B16F0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Can you send me the code directly to my =e-mail (just take out the "_please_reply..." part out of the address and I will =try to reproduce the error? BTW, which versions of SQL Server and .NET =Framework are you using?
-- Dejan Sarka, SQL Server =MVPAssociate MentorSolid Quality LearningMore than just Traininghttp://www.SolidQualityLearning.com">www.SolidQualityLearning.com= "Yang Cao"
The following is the SqlException our =code got when that happens. What Jerry and I don't understand is that the =error message "Duplicate key was ignored" should be associated with SQL =error 3604, which is only on severity level 16 that will not throw the exception, =(while error 3624 is on level 20). The database table has a composit =unique index (Odometer, QueueID) with "Ignore duplicate key", and a composit =cluster index (QueuedTime, Odometer). The Odometer column (int) is =involved in both indexes.Also, the server has 4 physical CPUs with =hypertheading to 8 virtual processors. Error: 3624General message: Location: insert.c:573Expression: sdesP->m_pIndex->indindid ==3D=3D CLUSTINDSPID: 168Process ID: =2920Duplicate key was ignored. Detailed message: ELKUpdateStatusFromAnyStatus:System.Data.SqlClient.SqlException: = Location: insert.c:573Expression: sdesP->m_pIndex->indindid =3D=3D CLUSTINDSPID: 168Process ID: 2920Duplicate key was =ignored. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior =cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at =?RunCommand@.@.$$FYAXHPADPAV?$list@.PAU_PARAM@.@.V?$allocator@.PAU_PARAM@.@.@.std@.=@.@.std@.@.W4COMMANDTYPE@.@.@.Z(Int32
Yang CaoMCSD, =MCDBA"Dejan Sarka" wrote in =message news:ecsLMESJEHA.3068@.TK2MSFTNGP10.phx.gbl...> > I suppose =that I should have mentioned that I've already performed the> > =typical google and support.microsoft.com searches, without finding> anything> > applicable. Any other ideas?> => Sorry, not directly. Maybe you can track down what happens before =this> error, which command makes the problem? It would be nice if the problem> would be reproducable.> > -- > =Dejan Sarka, SQL Server MVP> Associate Mentor> Solid Quality Learning> More than just Training> www.SolidQualityLearning.com> >
--=_NextPart_000_003E_01C425F6.395B16F0--sql
Wednesday, March 21, 2012
Error: 17883, Severity: 1, State: 0
MS SQL Server 2000 sp4 Got a series of errors:
Sleeping until external dump process completes.
Resuming after waiting on external debug process for 8 seconds.
Stack Signature for the dump is 0x00000000
Error: 17883, Severity: 1, State: 0
Process 104:0 (fd4) UMS Context 0x0775B548 appears to be non-yielding on
Scheduler 0.
SQL Server has encountered 37 occurrence(s) of IO requests taking longer
than 15 seconds to complete on file [e:\Microsoft SQL
Server\\webslog631_2.mdf] in database [webslog631_2] (35). The OS file handle
is 0x0000071C. The offset of the latest long IO is: 0x0000007e6b8000
Looks like there is a post sp4 hotfix to fix this..
http://support.microsoft.com/kb/909734
how do I contacty MS without having to give them a Credit Card number?"itsonlyme4" wrote:
> MS SQL Server 2000 sp4 Got a series of errors:
> Sleeping until external dump process completes.
> Resuming after waiting on external debug process for 8 seconds.
> Stack Signature for the dump is 0x00000000
> Error: 17883, Severity: 1, State: 0
> Process 104:0 (fd4) UMS Context 0x0775B548 appears to be non-yielding on
> Scheduler 0.
> SQL Server has encountered 37 occurrence(s) of IO requests taking longer
> than 15 seconds to complete on file [e:\Microsoft SQL
> Server\\webslog631_2.mdf] in database [webslog631_2] (35). The OS file handle
> is 0x0000071C. The offset of the latest long IO is: 0x0000007e6b8000
> Looks like there is a post sp4 hotfix to fix this..
> http://support.microsoft.com/kb/909734
> how do I contacty MS without having to give them a Credit Card number?
>
Hi
The cumulative update pack is publically available and will contain this fix
http://support.microsoft.com/kb/916287/
John
Sleeping until external dump process completes.
Resuming after waiting on external debug process for 8 seconds.
Stack Signature for the dump is 0x00000000
Error: 17883, Severity: 1, State: 0
Process 104:0 (fd4) UMS Context 0x0775B548 appears to be non-yielding on
Scheduler 0.
SQL Server has encountered 37 occurrence(s) of IO requests taking longer
than 15 seconds to complete on file [e:\Microsoft SQL
Server\\webslog631_2.mdf] in database [webslog631_2] (35). The OS file handle
is 0x0000071C. The offset of the latest long IO is: 0x0000007e6b8000
Looks like there is a post sp4 hotfix to fix this..
http://support.microsoft.com/kb/909734
how do I contacty MS without having to give them a Credit Card number?"itsonlyme4" wrote:
> MS SQL Server 2000 sp4 Got a series of errors:
> Sleeping until external dump process completes.
> Resuming after waiting on external debug process for 8 seconds.
> Stack Signature for the dump is 0x00000000
> Error: 17883, Severity: 1, State: 0
> Process 104:0 (fd4) UMS Context 0x0775B548 appears to be non-yielding on
> Scheduler 0.
> SQL Server has encountered 37 occurrence(s) of IO requests taking longer
> than 15 seconds to complete on file [e:\Microsoft SQL
> Server\\webslog631_2.mdf] in database [webslog631_2] (35). The OS file handle
> is 0x0000071C. The offset of the latest long IO is: 0x0000007e6b8000
> Looks like there is a post sp4 hotfix to fix this..
> http://support.microsoft.com/kb/909734
> how do I contacty MS without having to give them a Credit Card number?
>
Hi
The cumulative update pack is publically available and will contain this fix
http://support.microsoft.com/kb/916287/
John
Subscribe to:
Posts (Atom)