Guys,
does anyone know what to do when you get this kind of
error message: My server is windows 2000 sp4, sql2000
sp3a, Here is the min and max memory configuration in
sp_config
min memory per query (KB) 512 2147483647
min server memory (MB) 0 2147483647
WARNING: Failed to reserve contiguous memory of Size= 65536.
Buffer Distribution: Stolen=4294948690 Free=412
Procedures=142775
Inram=0 Dirty=1232 Kept=0
I/O=0, Latched=41, Other=105186
Does anyone know what needs to be done. It happened
yester at 4pm and hasn't happened again. Let me know
please. Thanks.
Mary LouChances are it is related to one of these:
http://support.microsoft.com/default.aspx?scid=kb;en-us;832674&Product=sql2k
http://support.microsoft.com/default.aspx?scid=kb;en-us;818095&Product=sql2k
http://support.microsoft.com/default.aspx?scid=kb;en-us;316749&Product=sql2k
Andrew J. Kelly SQL MVP
"Mary Lou" <anonymous@.discussions.microsoft.com> wrote in message
news:197a01c4a25a$62bf7f50$a301280a@.phx.gbl...
> Guys,
> does anyone know what to do when you get this kind of
> error message: My server is windows 2000 sp4, sql2000
> sp3a, Here is the min and max memory configuration in
> sp_config
> min memory per query (KB) 512 2147483647
> min server memory (MB) 0 2147483647
>
> WARNING: Failed to reserve contiguous memory of Size=> 65536.
> Buffer Distribution: Stolen=4294948690 Free=412
> Procedures=142775
> Inram=0 Dirty=1232 Kept=0
> I/O=0, Latched=41, Other=105186
>
> Does anyone know what needs to be done. It happened
> yester at 4pm and hasn't happened again. Let me know
> please. Thanks.
> Mary Lou
Showing posts with label sp3a. Show all posts
Showing posts with label sp3a. Show all posts
Thursday, March 29, 2012
Wednesday, March 21, 2012
Failed to connect to server - Need expert advise
Hello All,
We use MSDE SP3a and are having a strange problem.
We have an ADO-based application that fails depending on the domain
that we use to login to the machine. It works if I login to DOMAIN_A
but it fails to connect to the server if I am physically logged in into
the DOMAIN_B. In both cases the server and the database is local. The
message that I get is the usual:
Error Number: 80004005 [DBNETLIB][ConnectionOpen (Connect()).]SQL
Server does not exist or access denied.
I could not find any other errors in the event viewer, logs, etc.
Any help or ideas would be deeply appreciated as I ran out of them...
Thanks
- CD
How are you connecting ot the server Windows Authentication or SQL
Server Authentication ?
-Jens Suessmeyer.
We use MSDE SP3a and are having a strange problem.
We have an ADO-based application that fails depending on the domain
that we use to login to the machine. It works if I login to DOMAIN_A
but it fails to connect to the server if I am physically logged in into
the DOMAIN_B. In both cases the server and the database is local. The
message that I get is the usual:
Error Number: 80004005 [DBNETLIB][ConnectionOpen (Connect()).]SQL
Server does not exist or access denied.
I could not find any other errors in the event viewer, logs, etc.
Any help or ideas would be deeply appreciated as I ran out of them...
Thanks
- CD
How are you connecting ot the server Windows Authentication or SQL
Server Authentication ?
-Jens Suessmeyer.
Failed to connect to server - Need expert advise
Hello All,
We use MSDE SP3a and are having a strange problem.
We have an ADO-based application that fails depending on the domain
that we use to login to the machine. It works if I login to DOMAIN_A
but it fails to connect to the server if I am physically logged in into
the DOMAIN_B. In both cases the server and the database is local. The
message that I get is the usual:
Error Number: 80004005 [DBNETLIB][ConnectionOpen (Connect()).]SQL
Server does not exist or access denied.
I could not find any other errors in the event viewer, logs, etc.
Any help or ideas would be deeply appreciated as I ran out of them...
Thanks
- CDHow are you connecting ot the server Windows Authentication or SQL
Server Authentication ?
-Jens Suessmeyer.sql
We use MSDE SP3a and are having a strange problem.
We have an ADO-based application that fails depending on the domain
that we use to login to the machine. It works if I login to DOMAIN_A
but it fails to connect to the server if I am physically logged in into
the DOMAIN_B. In both cases the server and the database is local. The
message that I get is the usual:
Error Number: 80004005 [DBNETLIB][ConnectionOpen (Connect()).]SQL
Server does not exist or access denied.
I could not find any other errors in the event viewer, logs, etc.
Any help or ideas would be deeply appreciated as I ran out of them...
Thanks
- CDHow are you connecting ot the server Windows Authentication or SQL
Server Authentication ?
-Jens Suessmeyer.sql
Monday, March 19, 2012
Failed on installation of SQL Server SP3a on Failover Cluster
Platform: Windows 2003 ent failover cluster
SQL Server 2k ent
Process: apply SQL server 2k SP3a
We did installation of SQL Server 2k ent successfully. We are using Mixed
mode which allow both NT and SQL authentication. We assigned sa password.
We are able to start/stop/start SQL servrices.
Right after SQL Server 2k ent installation, we started to apply SP3a. But we
got error in middle of serivce pack: Setup was unable to verify the state of
the server for an upgrade. Verify the server is able to start and that you
provide a valid sa password and restart setup.
We foolowed the instruction on article ID 330022 and readme come with CD but
it still doesn't work
Thanks.
Check for:
PRB: Error Message: "Setup was unable to validate the logged user..."
Occurs When You Install SQL Server 2000 Service Pack 3 (SP3)
http://support.microsoft.com/?id=814844
PRB: "Setup Was Unable to Verify the State of the Server for an Upgrade"
Error Message When SQL Server Service Pack 2 Setup Stops Responding
http://support.microsoft.com/?id=328290
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||I referenced both articles but they are not really applied to our case. Our
platform is on WINDOWS 2003. We are implementing Failover Clustering. Our
MDAC is 2.8 version above. We didn't have any problem to install sql sp3a on
any other win2k or win2k3 ent platform. Only this time is Windows 2003 ent
FAILOVER CLUSTERING. We got SQL server 2k ent ed installed and we tried to
apply sql sp3a immediately after installation base on the recommendation.
But we got error in middle of serivce pack: Setup was unable to verify the
state of the server for an upgrade. Verify the server is able to start and
that you provide a valid sa password and restart setup.
"Fany Vargas [MSFT]" wrote:
> Check for:
> PRB: Error Message: "Setup was unable to validate the logged user..."
> Occurs When You Install SQL Server 2000 Service Pack 3 (SP3)
> http://support.microsoft.com/?id=814844
>
> PRB: "Setup Was Unable to Verify the State of the Server for an Upgrade"
> Error Message When SQL Server Service Pack 2 Setup Stops Responding
> http://support.microsoft.com/?id=328290
>
> Fany Vargas
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
> Microsoft software to better protect against viruses and security
> vulnerabilities. The easiest way to do this is to visit the following
> websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
|||1. Ensure that all NON-essential services are stopped. You can reference KB
for a list of services which need to stay running: INF: Order of
Installation for SQL Server 7.0 Clustering Setup - ID: 219264 (I realize
this is a 7.0 article). Also stop any antivirus or backup software in case
this is interfering with setup.
It is possible some other service is taking hold of the single user
conenction sql server starts with while applying the service pack. Also,
check any *.out files created by setup especially cnfsvr.out - they may
have more detailed errors.
2. If necessary, you can post your SQLSP.log file ( this is the setup log
file - fyi, it will contain your machine name, user name, virtual
servername,etc - it should not have any passwords though)
Thanks,
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||Also check that in "Environment Variables" (Right click on
My Computer -> Advanced) the variable TEMP has an actual
physycal path like c:\Temp and is not like %vari...%
Works for me every time
SQL Server 2k ent
Process: apply SQL server 2k SP3a
We did installation of SQL Server 2k ent successfully. We are using Mixed
mode which allow both NT and SQL authentication. We assigned sa password.
We are able to start/stop/start SQL servrices.
Right after SQL Server 2k ent installation, we started to apply SP3a. But we
got error in middle of serivce pack: Setup was unable to verify the state of
the server for an upgrade. Verify the server is able to start and that you
provide a valid sa password and restart setup.
We foolowed the instruction on article ID 330022 and readme come with CD but
it still doesn't work
Thanks.
Check for:
PRB: Error Message: "Setup was unable to validate the logged user..."
Occurs When You Install SQL Server 2000 Service Pack 3 (SP3)
http://support.microsoft.com/?id=814844
PRB: "Setup Was Unable to Verify the State of the Server for an Upgrade"
Error Message When SQL Server Service Pack 2 Setup Stops Responding
http://support.microsoft.com/?id=328290
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||I referenced both articles but they are not really applied to our case. Our
platform is on WINDOWS 2003. We are implementing Failover Clustering. Our
MDAC is 2.8 version above. We didn't have any problem to install sql sp3a on
any other win2k or win2k3 ent platform. Only this time is Windows 2003 ent
FAILOVER CLUSTERING. We got SQL server 2k ent ed installed and we tried to
apply sql sp3a immediately after installation base on the recommendation.
But we got error in middle of serivce pack: Setup was unable to verify the
state of the server for an upgrade. Verify the server is able to start and
that you provide a valid sa password and restart setup.
"Fany Vargas [MSFT]" wrote:
> Check for:
> PRB: Error Message: "Setup was unable to validate the logged user..."
> Occurs When You Install SQL Server 2000 Service Pack 3 (SP3)
> http://support.microsoft.com/?id=814844
>
> PRB: "Setup Was Unable to Verify the State of the Server for an Upgrade"
> Error Message When SQL Server Service Pack 2 Setup Stops Responding
> http://support.microsoft.com/?id=328290
>
> Fany Vargas
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
> Microsoft software to better protect against viruses and security
> vulnerabilities. The easiest way to do this is to visit the following
> websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
|||1. Ensure that all NON-essential services are stopped. You can reference KB
for a list of services which need to stay running: INF: Order of
Installation for SQL Server 7.0 Clustering Setup - ID: 219264 (I realize
this is a 7.0 article). Also stop any antivirus or backup software in case
this is interfering with setup.
It is possible some other service is taking hold of the single user
conenction sql server starts with while applying the service pack. Also,
check any *.out files created by setup especially cnfsvr.out - they may
have more detailed errors.
2. If necessary, you can post your SQLSP.log file ( this is the setup log
file - fyi, it will contain your machine name, user name, virtual
servername,etc - it should not have any passwords though)
Thanks,
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||Also check that in "Environment Variables" (Right click on
My Computer -> Advanced) the variable TEMP has an actual
physycal path like c:\Temp and is not like %vari...%
Works for me every time
Monday, March 12, 2012
Failed Assertion?
When going through my logs this morning I found this curious error. Anybody
know what I've got going here? Currently running SQL 2000 sp3a.
*Dump thread - spid = 55, PSS = 0xbca77230, EC = 0xbca77558
*Stack Dump being sent to H:\Program Files\Microsoft SQL
Server\MSSQL\log\SQLDump0063.txt
*
************************************************** **************************
***
*
* BEGIN STACK DUMP:
* 12/06/04 06:50:37 spid 55
*
*
*
* Input Buffer 48 bytes -
* exec Spot_GeneralDBStats
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00B2CFFF 0072d000
* ntdll 77F80000 77FFCFFF 0007d000
* KERNEL32 7C570000 7C622FFF 000b3000
* ADVAPI32 7C2D0000 7C331FFF 00062000
* RPCRT4 77D30000 77DA0FFF 00071000
* USER32 77E10000 77E74FFF 00065000
* GDI32 77F40000 77F7AFFF 0003b000
* OPENDS60 41060000 41065FFF 00006000
* MSVCRT 78000000 78044FFF 00045000
* UMS 41070000 4107CFFF 0000d000
* SQLSORT 42AE0000 42B6FFFF 00090000
* MSVCIRT 780A0000 780B1FFF 00012000
* sqlevn70 41080000 41086FFF 00007000
* CLUSAPI 73930000 7393FFFF 00010000
* RESUTILS 689D0000 689DCFFF 0000d000
* USERENV 7C0F0000 7C150FFF 00061000
* NETAPI32 06890000 068DEFFF 0004f000
* Secur32 068E0000 068EEFFF 0000f000
* NTDSAPI 068F0000 06900FFF 00011000
* DNSAPI 06910000 06933FFF 00024000
* WSOCK32 06940000 06947FFF 00008000
* WS2_32 06950000 06963FFF 00014000
* WS2HELP 06970000 06977FFF 00008000
* WLDAP32 06980000 069A9FFF 0002a000
* NETRAP 069B0000 069B5FFF 00006000
* SAMLIB 069C0000 069CEFFF 0000f000
* ole32 07030000 0711EFFF 000ef000
* XOLEHLP 07120000 07127FFF 00008000
* MSDTCPRX 07130000 071E6FFF 000b7000
* MTXCLU 071F0000 071FFFFF 00010000
* VERSION 07200000 07206FFF 00007000
* LZ32 07210000 07215FFF 00006000
* mswsock 07220000 07231FFF 00012000
* msafd 07280000 0729DFFF 0001e000
* wshtcpip 072E0000 072E6FFF 00007000
* rnr20 072F0000 072FBFFF 0000c000
* iphlpapi 07340000 07352FFF 00013000
* ICMP 07360000 07364FFF 00005000
* MPRAPI 07370000 07386FFF 00017000
* OLEAUT32 07390000 0742AFFF 0009b000
* ACTIVEDS 07430000 0745EFFF 0002f000
* ADSLDPC 07460000 07482FFF 00023000
* RTUTILS 07490000 0749DFFF 0000e000
* SETUPAPI 074A0000 0752DFFF 0008e000
* RASAPI32 07530000 07562FFF 00033000
* RASMAN 07570000 07580FFF 00011000
* TAPI32 07590000 075B1FFF 00022000
* COMCTL32 075C0000 07643FFF 00084000
* SHLWAPI 07650000 076B8FFF 00069000
* DHCPCSVC 076C0000 076D8FFF 00019000
* winrnr 07B80000 07B87FFF 00008000
* msv1_0 07C10000 07C30FFF 00021000
* CRYPT32 07C40000 07CC6FFF 00087000
* MSASN1 07CD0000 07CDFFFF 00010000
* rasadhlp 07CE0000 07CE4FFF 00005000
* SSNETLIB 00BF0000 00C04FFF 00015000
* SSNMPN70 00C10000 00C15FFF 00006000
* security 08790000 08793FFF 00004000
* SSmsLPCn 08920000 08926FFF 00007000
* kerberos 08FB0000 08FE5FFF 00036000
* CRYPTDLL 08930000 0893DFFF 0000e000
* SQLFTQRY 00C70000 00CA1FFF 00032000
* CLBCATQ 087A0000 0882FFFF 00090000
* sqloledb 08710000 08782FFF 00073000
* MSDART 00CB0000 00CCEFFF 0001f000
* comdlg32 08840000 0887DFFF 0003e000
* SHELL32 08AD0000 08D14FFF 00245000
* MSDATL3 00CD0000 00CE4FFF 00015000
* oledb32 09E00000 09E65FFF 00066000
* OLEDB32R 08900000 0890FFFF 00010000
* xpsqlbot 08A40000 08A45FFF 00006000
* rsabase 09F80000 09FA2FFF 00023000
* xpstar 0A030000 0A076FFF 00047000
* SQLRESLD 08910000 08916FFF 00007000
* SQLSVC 08EF0000 08F06FFF 00017000
* ODBC32 0A080000 0A0B1FFF 00032000
* odbcbcp 08FA0000 08FA5FFF 00006000
* W95SCM 0A0C0000 0A0CBFFF 0000c000
* SQLUNIRL 0A0D0000 0A0FCFFF 0002d000
* WINSPOOL 0A100000 0A11DFFF 0001e000
* MPR 0A120000 0A12FFFF 00010000
* SHFOLDER 0A130000 0A137FFF 00008000
* odbcint 0A400000 0A415FFF 00016000
* NDDEAPI 0A420000 0A426FFF 00007000
* SQLSVC 0A430000 0A435FFF 00006000
* xpstar 0A440000 0A448FFF 00009000
* xplog70 07B90000 07BA1FFF 00012000
* xplog70 07BB0000 07BB3FFF 00004000
* srchadm 07BD0000 07C05FFF 00036000
* mssws 09D80000 09D87FFF 00008000
* msi 0B5F0000 0B7F3FFF 00204000
* athprxy 09D90000 09D97FFF 00008000
* adsldp 09D00000 09D21FFF 00022000
* adsmsext 09D30000 09D41FFF 00012000
* dbghelp 0BC00000 0BCB4FFF 000b5000
*
* Edi: BCA77558: BCA77230 BCA7755C BCA7755C BCA3D328 5AF67AE0 BC2D8030
* Esi: 00000000:
* Eax: 00000000:
* Ebx: BCA77230: 00000037 00000000 0111C7EF 000095B0 00000000 00000000
* Ecx: 0A84A840: 00000000 0001003F 00000000 00000000 00000000 00000000
* Edx: FFFFFFFF:
* Eip: 0087A90E: 4D830088 75FFFFFC 0875FF0C E8E04D8B 0000002D 64F04D8B
* Ebp: 0A84A824: 0A84B044 0087C41F BCA77230 0A84B1A8 0A84B417 780238AE
* SegCs: 0000001B:
* EFlags: 00010246: 004F0052 00450043 00530053 0052004F 003D0053 00000038
* Esp: 0A84A7F8: BCA77558 00000000 BCA77230 0A84A840 BCA77000 0A84A7F8
* SegSs: 00000023:
*
************************************************** **************************
***
* ----
* Short Stack Dump
* 0087A90E Module(sqlservr+0047A90E)
(CStackDump::GetContextAndDump+0000002E)
* 0087C41F Module(sqlservr+0047C41F) (stackTrace+00000223)
* 00931097 Module(sqlservr+00531097) (utassert_fail+000002E3)
* 00830207 Module(sqlservr+00430207) (DBLockCache::ReleaseDBLock+00000072)
* 004021F5 Module(sqlservr+000021F5) (unlockdb+00000024)
* 00404829 Module(sqlservr+00004829)
(XdesRMReadOnly::~XdesRMReadOnly+00000075)
* 0040479D Module(sqlservr+0000479D) (ReadOnlyXactImp::Rollback+0000009B)
* 00404490 Module(sqlservr+00004490) (AutoReadOnlyXact::Rollback+0000000E)
* 00404551 Module(sqlservr+00004551) (CSysScan::VRelease+00000069)
* 0045D0B0 Module(sqlservr+0005D0B0) (CObject::FResolveName+0000052D)
* 0045EB9F Module(sqlservr+0005EB9F) (CObject::FResolveName+0000003E)
* 0045EA3E Module(sqlservr+0005EA3E) (CAlgTable::FBind+000002BC)
* 0044F048 Module(sqlservr+0004F048) (FOpenAllRanges+000000DD)
* 0044EAD7 Module(sqlservr+0004EAD7) (find_all+000008DA)
* 0044E684 Module(sqlservr+0004E684) (colnames+00000078)
* 0044E5B4 Module(sqlservr+0004E5B4) (CProchdr::NormQuery+00000045)
* 0044ACF2 Module(sqlservr+0004ACF2) (CProchdr::FCompile+00000305)
* 0041BF21 Module(sqlservr+0001BF21) (CSQLSource::FTransform+0000034C)
* 0044CE55 Module(sqlservr+0004CE55) (CSQLStrings::FTransform+000001A1)
* 0041B8EF Module(sqlservr+0001B8EF) (CSQLSource::Execute+0000015B)
* 006040BD Module(sqlservr+002040BD) (CStmtExecStr::XretExecute+0000032E)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 0048A63B Module(sqlservr+0008A63B) (language_exec+000003E1)
* 0042708C Module(sqlservr+0002708C) (process_commands+0000010E)
* 41075002 Module(UMS+00005002) (ProcessWorkRequests+00000272)
* 41074698 Module(UMS+00004698) (ThreadStartRoutine+00000098)
* 78008454 Module(MSVCRT+00008454) (endthread+000000C1)
* 7C57B388 Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
* ----
2004-12-06 06:50:43.50 spid55 Stack Signature for the dump is 0xC84ECD88
2004-12-06 06:50:43.61 spid55 SQL Server Assertion: File: <dbtable.cpp>,
line=2612
Failed Assertion = 'm_refCount [slot] > 0'.
2004-12-06 06:50:43.61 spid55 Error: 3624, Severity: 20, State: 1.
2004-12-06 06:50:43.66 spid55 Using 'dbghelp.dll' version '4.0.5'
*Dump thread - spid = 55, PSS = 0xbca77230, EC = 0xbca77558
*Stack Dump being sent to H:\Program Files\Microsoft SQL
Server\MSSQL\log\SQLDump0064.txt
*
************************************************** **************************
***
*
* BEGIN STACK DUMP:
* 12/06/04 06:50:43 spid 55
*
*
*
* exec Spot_GeneralDBStats
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00B2CFFF 0072d000
* ntdll 77F80000 77FFCFFF 0007d000
* KERNEL32 7C570000 7C622FFF 000b3000
* ADVAPI32 7C2D0000 7C331FFF 00062000
* RPCRT4 77D30000 77DA0FFF 00071000
* USER32 77E10000 77E74FFF 00065000
* GDI32 77F40000 77F7AFFF 0003b000
* OPENDS60 41060000 41065FFF 00006000
* MSVCRT 78000000 78044FFF 00045000
* UMS 41070000 4107CFFF 0000d000
* SQLSORT 42AE0000 42B6FFFF 00090000
* MSVCIRT 780A0000 780B1FFF 00012000
* sqlevn70 41080000 41086FFF 00007000
* CLUSAPI 73930000 7393FFFF 00010000
* RESUTILS 689D0000 689DCFFF 0000d000
* USERENV 7C0F0000 7C150FFF 00061000
* NETAPI32 06890000 068DEFFF 0004f000
* Secur32 068E0000 068EEFFF 0000f000
* NTDSAPI 068F0000 06900FFF 00011000
* DNSAPI 06910000 06933FFF 00024000
* WSOCK32 06940000 06947FFF 00008000
* WS2_32 06950000 06963FFF 00014000
* WS2HELP 06970000 06977FFF 00008000
* WLDAP32 06980000 069A9FFF 0002a000
* NETRAP 069B0000 069B5FFF 00006000
* SAMLIB 069C0000 069CEFFF 0000f000
* ole32 07030000 0711EFFF 000ef000
* XOLEHLP 07120000 07127FFF 00008000
* MSDTCPRX 07130000 071E6FFF 000b7000
* MTXCLU 071F0000 071FFFFF 00010000
* VERSION 07200000 07206FFF 00007000
* LZ32 07210000 07215FFF 00006000
* mswsock 07220000 07231FFF 00012000
* msafd 07280000 0729DFFF 0001e000
* wshtcpip 072E0000 072E6FFF 00007000
* rnr20 072F0000 072FBFFF 0000c000
* iphlpapi 07340000 07352FFF 00013000
* ICMP 07360000 07364FFF 00005000
* MPRAPI 07370000 07386FFF 00017000
* OLEAUT32 07390000 0742AFFF 0009b000
* ACTIVEDS 07430000 0745EFFF 0002f000
* ADSLDPC 07460000 07482FFF 00023000
* RTUTILS 07490000 0749DFFF 0000e000
* SETUPAPI 074A0000 0752DFFF 0008e000
* RASAPI32 07530000 07562FFF 00033000
* RASMAN 07570000 07580FFF 00011000
* TAPI32 07590000 075B1FFF 00022000
* COMCTL32 075C0000 07643FFF 00084000
* SHLWAPI 07650000 076B8FFF 00069000
* DHCPCSVC 076C0000 076D8FFF 00019000
* winrnr 07B80000 07B87FFF 00008000
* msv1_0 07C10000 07C30FFF 00021000
* CRYPT32 07C40000 07CC6FFF 00087000
* MSASN1 07CD0000 07CDFFFF 00010000
* rasadhlp 07CE0000 07CE4FFF 00005000
* SSNETLIB 00BF0000 00C04FFF 00015000
* SSNMPN70 00C10000 00C15FFF 00006000
* security 08790000 08793FFF 00004000
* SSmsLPCn 08920000 08926FFF 00007000
* kerberos 08FB0000 08FE5FFF 00036000
* CRYPTDLL 08930000 0893DFFF 0000e000
* SQLFTQRY 00C70000 00CA1FFF 00032000
* CLBCATQ 087A0000 0882FFFF 00090000
* sqloledb 08710000 08782FFF 00073000
* MSDART 00CB0000 00CCEFFF 0001f000
* comdlg32 08840000 0887DFFF 0003e000
* SHELL32 08AD0000 08D14FFF 00245000
* MSDATL3 00CD0000 00CE4FFF 00015000
* oledb32 09E00000 09E65FFF 00066000
* OLEDB32R 08900000 0890FFFF 00010000
* xpsqlbot 08A40000 08A45FFF 00006000
* rsabase 09F80000 09FA2FFF 00023000
* xpstar 0A030000 0A076FFF 00047000
* SQLRESLD 08910000 08916FFF 00007000
* SQLSVC 08EF0000 08F06FFF 00017000
* ODBC32 0A080000 0A0B1FFF 00032000
* odbcbcp 08FA0000 08FA5FFF 00006000
* W95SCM 0A0C0000 0A0CBFFF 0000c000
* SQLUNIRL 0A0D0000 0A0FCFFF 0002d000
* WINSPOOL 0A100000 0A11DFFF 0001e000
* MPR 0A120000 0A12FFFF 00010000
* SHFOLDER 0A130000 0A137FFF 00008000
* odbcint 0A400000 0A415FFF 00016000
* NDDEAPI 0A420000 0A426FFF 00007000
* SQLSVC 0A430000 0A435FFF 00006000
* xpstar 0A440000 0A448FFF 00009000
* xplog70 07B90000 07BA1FFF 00012000
* xplog70 07BB0000 07BB3FFF 00004000
* srchadm 07BD0000 07C05FFF 00036000
* mssws 09D80000 09D87FFF 00008000
* msi 0B5F0000 0B7F3FFF 00204000
* athprxy 09D90000 09D97FFF 00008000
* adsldp 09D00000 09D21FFF 00022000
* adsmsext 09D30000 09D41FFF 00012000
* dbghelp 0BC00000 0BCB4FFF 000b5000
*
* Edi: BCA77558: BCA77230 BCA7755C BCA7755C BCA3D328 5AF67AE0 BC2D8030
* Esi: 00000000:
* Eax: 00000000:
* Ebx: BCA77230: 00060037 00000000 0111C7EF 000095B0 00000000 00000000
* Ecx: 0A848F8C: 00000000 0001003F 00000000 00000000 00000000 00000000
* Edx: FFFFFFFF:
* Eip: 0087A90E: 4D830088 75FFFFFC 0875FF0C E8E04D8B 0000002D 64F04D8B
* Ebp: 0A848F70: 0A849790 0087C41F BCA77230 0A8498F4 0A849B63 780238AE
* SegCs: 0000001B:
* EFlags: 00010246: 004F0052 00450043 00530053 0052004F 003D0053 00000038
* Esp: 0A848F44: BCA77558 00000000 BCA77230 0A848F8C BCA77000 0A848F44
* SegSs: 00000023:
*
************************************************** **************************
***
* ----
* Short Stack Dump
* 0087A90E Module(sqlservr+0047A90E)
(CStackDump::GetContextAndDump+0000002E)
* 0087C41F Module(sqlservr+0047C41F) (stackTrace+00000223)
* 00931097 Module(sqlservr+00531097) (utassert_fail+000002E3)
* 00830207 Module(sqlservr+00430207) (DBLockCache::ReleaseDBLock+00000072)
* 004021F5 Module(sqlservr+000021F5) (unlockdb+00000024)
* 004437D8 Module(sqlservr+000437D8) (dec_dbopen+0000000D)
* 0044377F Module(sqlservr+0004377F) (closedb+00000069)
* 004438BD Module(sqlservr+000438BD) (CAutoDb::SafeClose+00000027)
* 7800925D Module(MSVCRT+0000925D) (_doserrno+0000009E)
* 0045EB9F Module(sqlservr+0005EB9F) (CObject::FResolveName+0000003E)
* 0045EA3E Module(sqlservr+0005EA3E) (CAlgTable::FBind+000002BC)
* 0044F048 Module(sqlservr+0004F048) (FOpenAllRanges+000000DD)
* 0044EAD7 Module(sqlservr+0004EAD7) (find_all+000008DA)
* 0044E684 Module(sqlservr+0004E684) (colnames+00000078)
* 0044E5B4 Module(sqlservr+0004E5B4) (CProchdr::NormQuery+00000045)
* 0044ACF2 Module(sqlservr+0004ACF2) (CProchdr::FCompile+00000305)
* 0041BF21 Module(sqlservr+0001BF21) (CSQLSource::FTransform+0000034C)
* 0044CE55 Module(sqlservr+0004CE55) (CSQLStrings::FTransform+000001A1)
* 0041B8EF Module(sqlservr+0001B8EF) (CSQLSource::Execute+0000015B)
* 006040BD Module(sqlservr+002040BD) (CStmtExecStr::XretExecute+0000032E)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 0048A63B Module(sqlservr+0008A63B) (language_exec+000003E1)
* 0042708C Module(sqlservr+0002708C) (process_commands+0000010E)
* 41075002 Module(UMS+00005002) (ProcessWorkRequests+00000272)
* 41074698 Module(UMS+00004698) (ThreadStartRoutine+00000098)
* 78008454 Module(MSVCRT+00008454) (endthread+000000C1)
* 7C57B388 Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
* ----
2004-12-06 06:50:45.08 spid55 Stack Signature for the dump is 0xC2291C8B
2004-12-06 06:50:45.10 spid55 SQL Server Assertion: File: <dbtable.cpp>,
line=2612
Failed Assertion = 'm_refCount [slot] > 0'.
"Mike Johnson" <mj@.microsoft.com> wrote in message
news:upbtGP62EHA.1400@.TK2MSFTNGP11.phx.gbl...
> When going through my logs this morning I found this curious error.
Anybody
> know what I've got going here? Currently running SQL 2000 sp3a.
Sounds liek you've hit a bug. An assertion shouldn't show up in production
code.
Contact MS Server support.
know what I've got going here? Currently running SQL 2000 sp3a.
*Dump thread - spid = 55, PSS = 0xbca77230, EC = 0xbca77558
*Stack Dump being sent to H:\Program Files\Microsoft SQL
Server\MSSQL\log\SQLDump0063.txt
*
************************************************** **************************
***
*
* BEGIN STACK DUMP:
* 12/06/04 06:50:37 spid 55
*
*
*
* Input Buffer 48 bytes -
* exec Spot_GeneralDBStats
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00B2CFFF 0072d000
* ntdll 77F80000 77FFCFFF 0007d000
* KERNEL32 7C570000 7C622FFF 000b3000
* ADVAPI32 7C2D0000 7C331FFF 00062000
* RPCRT4 77D30000 77DA0FFF 00071000
* USER32 77E10000 77E74FFF 00065000
* GDI32 77F40000 77F7AFFF 0003b000
* OPENDS60 41060000 41065FFF 00006000
* MSVCRT 78000000 78044FFF 00045000
* UMS 41070000 4107CFFF 0000d000
* SQLSORT 42AE0000 42B6FFFF 00090000
* MSVCIRT 780A0000 780B1FFF 00012000
* sqlevn70 41080000 41086FFF 00007000
* CLUSAPI 73930000 7393FFFF 00010000
* RESUTILS 689D0000 689DCFFF 0000d000
* USERENV 7C0F0000 7C150FFF 00061000
* NETAPI32 06890000 068DEFFF 0004f000
* Secur32 068E0000 068EEFFF 0000f000
* NTDSAPI 068F0000 06900FFF 00011000
* DNSAPI 06910000 06933FFF 00024000
* WSOCK32 06940000 06947FFF 00008000
* WS2_32 06950000 06963FFF 00014000
* WS2HELP 06970000 06977FFF 00008000
* WLDAP32 06980000 069A9FFF 0002a000
* NETRAP 069B0000 069B5FFF 00006000
* SAMLIB 069C0000 069CEFFF 0000f000
* ole32 07030000 0711EFFF 000ef000
* XOLEHLP 07120000 07127FFF 00008000
* MSDTCPRX 07130000 071E6FFF 000b7000
* MTXCLU 071F0000 071FFFFF 00010000
* VERSION 07200000 07206FFF 00007000
* LZ32 07210000 07215FFF 00006000
* mswsock 07220000 07231FFF 00012000
* msafd 07280000 0729DFFF 0001e000
* wshtcpip 072E0000 072E6FFF 00007000
* rnr20 072F0000 072FBFFF 0000c000
* iphlpapi 07340000 07352FFF 00013000
* ICMP 07360000 07364FFF 00005000
* MPRAPI 07370000 07386FFF 00017000
* OLEAUT32 07390000 0742AFFF 0009b000
* ACTIVEDS 07430000 0745EFFF 0002f000
* ADSLDPC 07460000 07482FFF 00023000
* RTUTILS 07490000 0749DFFF 0000e000
* SETUPAPI 074A0000 0752DFFF 0008e000
* RASAPI32 07530000 07562FFF 00033000
* RASMAN 07570000 07580FFF 00011000
* TAPI32 07590000 075B1FFF 00022000
* COMCTL32 075C0000 07643FFF 00084000
* SHLWAPI 07650000 076B8FFF 00069000
* DHCPCSVC 076C0000 076D8FFF 00019000
* winrnr 07B80000 07B87FFF 00008000
* msv1_0 07C10000 07C30FFF 00021000
* CRYPT32 07C40000 07CC6FFF 00087000
* MSASN1 07CD0000 07CDFFFF 00010000
* rasadhlp 07CE0000 07CE4FFF 00005000
* SSNETLIB 00BF0000 00C04FFF 00015000
* SSNMPN70 00C10000 00C15FFF 00006000
* security 08790000 08793FFF 00004000
* SSmsLPCn 08920000 08926FFF 00007000
* kerberos 08FB0000 08FE5FFF 00036000
* CRYPTDLL 08930000 0893DFFF 0000e000
* SQLFTQRY 00C70000 00CA1FFF 00032000
* CLBCATQ 087A0000 0882FFFF 00090000
* sqloledb 08710000 08782FFF 00073000
* MSDART 00CB0000 00CCEFFF 0001f000
* comdlg32 08840000 0887DFFF 0003e000
* SHELL32 08AD0000 08D14FFF 00245000
* MSDATL3 00CD0000 00CE4FFF 00015000
* oledb32 09E00000 09E65FFF 00066000
* OLEDB32R 08900000 0890FFFF 00010000
* xpsqlbot 08A40000 08A45FFF 00006000
* rsabase 09F80000 09FA2FFF 00023000
* xpstar 0A030000 0A076FFF 00047000
* SQLRESLD 08910000 08916FFF 00007000
* SQLSVC 08EF0000 08F06FFF 00017000
* ODBC32 0A080000 0A0B1FFF 00032000
* odbcbcp 08FA0000 08FA5FFF 00006000
* W95SCM 0A0C0000 0A0CBFFF 0000c000
* SQLUNIRL 0A0D0000 0A0FCFFF 0002d000
* WINSPOOL 0A100000 0A11DFFF 0001e000
* MPR 0A120000 0A12FFFF 00010000
* SHFOLDER 0A130000 0A137FFF 00008000
* odbcint 0A400000 0A415FFF 00016000
* NDDEAPI 0A420000 0A426FFF 00007000
* SQLSVC 0A430000 0A435FFF 00006000
* xpstar 0A440000 0A448FFF 00009000
* xplog70 07B90000 07BA1FFF 00012000
* xplog70 07BB0000 07BB3FFF 00004000
* srchadm 07BD0000 07C05FFF 00036000
* mssws 09D80000 09D87FFF 00008000
* msi 0B5F0000 0B7F3FFF 00204000
* athprxy 09D90000 09D97FFF 00008000
* adsldp 09D00000 09D21FFF 00022000
* adsmsext 09D30000 09D41FFF 00012000
* dbghelp 0BC00000 0BCB4FFF 000b5000
*
* Edi: BCA77558: BCA77230 BCA7755C BCA7755C BCA3D328 5AF67AE0 BC2D8030
* Esi: 00000000:
* Eax: 00000000:
* Ebx: BCA77230: 00000037 00000000 0111C7EF 000095B0 00000000 00000000
* Ecx: 0A84A840: 00000000 0001003F 00000000 00000000 00000000 00000000
* Edx: FFFFFFFF:
* Eip: 0087A90E: 4D830088 75FFFFFC 0875FF0C E8E04D8B 0000002D 64F04D8B
* Ebp: 0A84A824: 0A84B044 0087C41F BCA77230 0A84B1A8 0A84B417 780238AE
* SegCs: 0000001B:
* EFlags: 00010246: 004F0052 00450043 00530053 0052004F 003D0053 00000038
* Esp: 0A84A7F8: BCA77558 00000000 BCA77230 0A84A840 BCA77000 0A84A7F8
* SegSs: 00000023:
*
************************************************** **************************
***
* ----
* Short Stack Dump
* 0087A90E Module(sqlservr+0047A90E)
(CStackDump::GetContextAndDump+0000002E)
* 0087C41F Module(sqlservr+0047C41F) (stackTrace+00000223)
* 00931097 Module(sqlservr+00531097) (utassert_fail+000002E3)
* 00830207 Module(sqlservr+00430207) (DBLockCache::ReleaseDBLock+00000072)
* 004021F5 Module(sqlservr+000021F5) (unlockdb+00000024)
* 00404829 Module(sqlservr+00004829)
(XdesRMReadOnly::~XdesRMReadOnly+00000075)
* 0040479D Module(sqlservr+0000479D) (ReadOnlyXactImp::Rollback+0000009B)
* 00404490 Module(sqlservr+00004490) (AutoReadOnlyXact::Rollback+0000000E)
* 00404551 Module(sqlservr+00004551) (CSysScan::VRelease+00000069)
* 0045D0B0 Module(sqlservr+0005D0B0) (CObject::FResolveName+0000052D)
* 0045EB9F Module(sqlservr+0005EB9F) (CObject::FResolveName+0000003E)
* 0045EA3E Module(sqlservr+0005EA3E) (CAlgTable::FBind+000002BC)
* 0044F048 Module(sqlservr+0004F048) (FOpenAllRanges+000000DD)
* 0044EAD7 Module(sqlservr+0004EAD7) (find_all+000008DA)
* 0044E684 Module(sqlservr+0004E684) (colnames+00000078)
* 0044E5B4 Module(sqlservr+0004E5B4) (CProchdr::NormQuery+00000045)
* 0044ACF2 Module(sqlservr+0004ACF2) (CProchdr::FCompile+00000305)
* 0041BF21 Module(sqlservr+0001BF21) (CSQLSource::FTransform+0000034C)
* 0044CE55 Module(sqlservr+0004CE55) (CSQLStrings::FTransform+000001A1)
* 0041B8EF Module(sqlservr+0001B8EF) (CSQLSource::Execute+0000015B)
* 006040BD Module(sqlservr+002040BD) (CStmtExecStr::XretExecute+0000032E)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 0048A63B Module(sqlservr+0008A63B) (language_exec+000003E1)
* 0042708C Module(sqlservr+0002708C) (process_commands+0000010E)
* 41075002 Module(UMS+00005002) (ProcessWorkRequests+00000272)
* 41074698 Module(UMS+00004698) (ThreadStartRoutine+00000098)
* 78008454 Module(MSVCRT+00008454) (endthread+000000C1)
* 7C57B388 Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
* ----
2004-12-06 06:50:43.50 spid55 Stack Signature for the dump is 0xC84ECD88
2004-12-06 06:50:43.61 spid55 SQL Server Assertion: File: <dbtable.cpp>,
line=2612
Failed Assertion = 'm_refCount [slot] > 0'.
2004-12-06 06:50:43.61 spid55 Error: 3624, Severity: 20, State: 1.
2004-12-06 06:50:43.66 spid55 Using 'dbghelp.dll' version '4.0.5'
*Dump thread - spid = 55, PSS = 0xbca77230, EC = 0xbca77558
*Stack Dump being sent to H:\Program Files\Microsoft SQL
Server\MSSQL\log\SQLDump0064.txt
*
************************************************** **************************
***
*
* BEGIN STACK DUMP:
* 12/06/04 06:50:43 spid 55
*
*
*
* exec Spot_GeneralDBStats
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00B2CFFF 0072d000
* ntdll 77F80000 77FFCFFF 0007d000
* KERNEL32 7C570000 7C622FFF 000b3000
* ADVAPI32 7C2D0000 7C331FFF 00062000
* RPCRT4 77D30000 77DA0FFF 00071000
* USER32 77E10000 77E74FFF 00065000
* GDI32 77F40000 77F7AFFF 0003b000
* OPENDS60 41060000 41065FFF 00006000
* MSVCRT 78000000 78044FFF 00045000
* UMS 41070000 4107CFFF 0000d000
* SQLSORT 42AE0000 42B6FFFF 00090000
* MSVCIRT 780A0000 780B1FFF 00012000
* sqlevn70 41080000 41086FFF 00007000
* CLUSAPI 73930000 7393FFFF 00010000
* RESUTILS 689D0000 689DCFFF 0000d000
* USERENV 7C0F0000 7C150FFF 00061000
* NETAPI32 06890000 068DEFFF 0004f000
* Secur32 068E0000 068EEFFF 0000f000
* NTDSAPI 068F0000 06900FFF 00011000
* DNSAPI 06910000 06933FFF 00024000
* WSOCK32 06940000 06947FFF 00008000
* WS2_32 06950000 06963FFF 00014000
* WS2HELP 06970000 06977FFF 00008000
* WLDAP32 06980000 069A9FFF 0002a000
* NETRAP 069B0000 069B5FFF 00006000
* SAMLIB 069C0000 069CEFFF 0000f000
* ole32 07030000 0711EFFF 000ef000
* XOLEHLP 07120000 07127FFF 00008000
* MSDTCPRX 07130000 071E6FFF 000b7000
* MTXCLU 071F0000 071FFFFF 00010000
* VERSION 07200000 07206FFF 00007000
* LZ32 07210000 07215FFF 00006000
* mswsock 07220000 07231FFF 00012000
* msafd 07280000 0729DFFF 0001e000
* wshtcpip 072E0000 072E6FFF 00007000
* rnr20 072F0000 072FBFFF 0000c000
* iphlpapi 07340000 07352FFF 00013000
* ICMP 07360000 07364FFF 00005000
* MPRAPI 07370000 07386FFF 00017000
* OLEAUT32 07390000 0742AFFF 0009b000
* ACTIVEDS 07430000 0745EFFF 0002f000
* ADSLDPC 07460000 07482FFF 00023000
* RTUTILS 07490000 0749DFFF 0000e000
* SETUPAPI 074A0000 0752DFFF 0008e000
* RASAPI32 07530000 07562FFF 00033000
* RASMAN 07570000 07580FFF 00011000
* TAPI32 07590000 075B1FFF 00022000
* COMCTL32 075C0000 07643FFF 00084000
* SHLWAPI 07650000 076B8FFF 00069000
* DHCPCSVC 076C0000 076D8FFF 00019000
* winrnr 07B80000 07B87FFF 00008000
* msv1_0 07C10000 07C30FFF 00021000
* CRYPT32 07C40000 07CC6FFF 00087000
* MSASN1 07CD0000 07CDFFFF 00010000
* rasadhlp 07CE0000 07CE4FFF 00005000
* SSNETLIB 00BF0000 00C04FFF 00015000
* SSNMPN70 00C10000 00C15FFF 00006000
* security 08790000 08793FFF 00004000
* SSmsLPCn 08920000 08926FFF 00007000
* kerberos 08FB0000 08FE5FFF 00036000
* CRYPTDLL 08930000 0893DFFF 0000e000
* SQLFTQRY 00C70000 00CA1FFF 00032000
* CLBCATQ 087A0000 0882FFFF 00090000
* sqloledb 08710000 08782FFF 00073000
* MSDART 00CB0000 00CCEFFF 0001f000
* comdlg32 08840000 0887DFFF 0003e000
* SHELL32 08AD0000 08D14FFF 00245000
* MSDATL3 00CD0000 00CE4FFF 00015000
* oledb32 09E00000 09E65FFF 00066000
* OLEDB32R 08900000 0890FFFF 00010000
* xpsqlbot 08A40000 08A45FFF 00006000
* rsabase 09F80000 09FA2FFF 00023000
* xpstar 0A030000 0A076FFF 00047000
* SQLRESLD 08910000 08916FFF 00007000
* SQLSVC 08EF0000 08F06FFF 00017000
* ODBC32 0A080000 0A0B1FFF 00032000
* odbcbcp 08FA0000 08FA5FFF 00006000
* W95SCM 0A0C0000 0A0CBFFF 0000c000
* SQLUNIRL 0A0D0000 0A0FCFFF 0002d000
* WINSPOOL 0A100000 0A11DFFF 0001e000
* MPR 0A120000 0A12FFFF 00010000
* SHFOLDER 0A130000 0A137FFF 00008000
* odbcint 0A400000 0A415FFF 00016000
* NDDEAPI 0A420000 0A426FFF 00007000
* SQLSVC 0A430000 0A435FFF 00006000
* xpstar 0A440000 0A448FFF 00009000
* xplog70 07B90000 07BA1FFF 00012000
* xplog70 07BB0000 07BB3FFF 00004000
* srchadm 07BD0000 07C05FFF 00036000
* mssws 09D80000 09D87FFF 00008000
* msi 0B5F0000 0B7F3FFF 00204000
* athprxy 09D90000 09D97FFF 00008000
* adsldp 09D00000 09D21FFF 00022000
* adsmsext 09D30000 09D41FFF 00012000
* dbghelp 0BC00000 0BCB4FFF 000b5000
*
* Edi: BCA77558: BCA77230 BCA7755C BCA7755C BCA3D328 5AF67AE0 BC2D8030
* Esi: 00000000:
* Eax: 00000000:
* Ebx: BCA77230: 00060037 00000000 0111C7EF 000095B0 00000000 00000000
* Ecx: 0A848F8C: 00000000 0001003F 00000000 00000000 00000000 00000000
* Edx: FFFFFFFF:
* Eip: 0087A90E: 4D830088 75FFFFFC 0875FF0C E8E04D8B 0000002D 64F04D8B
* Ebp: 0A848F70: 0A849790 0087C41F BCA77230 0A8498F4 0A849B63 780238AE
* SegCs: 0000001B:
* EFlags: 00010246: 004F0052 00450043 00530053 0052004F 003D0053 00000038
* Esp: 0A848F44: BCA77558 00000000 BCA77230 0A848F8C BCA77000 0A848F44
* SegSs: 00000023:
*
************************************************** **************************
***
* ----
* Short Stack Dump
* 0087A90E Module(sqlservr+0047A90E)
(CStackDump::GetContextAndDump+0000002E)
* 0087C41F Module(sqlservr+0047C41F) (stackTrace+00000223)
* 00931097 Module(sqlservr+00531097) (utassert_fail+000002E3)
* 00830207 Module(sqlservr+00430207) (DBLockCache::ReleaseDBLock+00000072)
* 004021F5 Module(sqlservr+000021F5) (unlockdb+00000024)
* 004437D8 Module(sqlservr+000437D8) (dec_dbopen+0000000D)
* 0044377F Module(sqlservr+0004377F) (closedb+00000069)
* 004438BD Module(sqlservr+000438BD) (CAutoDb::SafeClose+00000027)
* 7800925D Module(MSVCRT+0000925D) (_doserrno+0000009E)
* 0045EB9F Module(sqlservr+0005EB9F) (CObject::FResolveName+0000003E)
* 0045EA3E Module(sqlservr+0005EA3E) (CAlgTable::FBind+000002BC)
* 0044F048 Module(sqlservr+0004F048) (FOpenAllRanges+000000DD)
* 0044EAD7 Module(sqlservr+0004EAD7) (find_all+000008DA)
* 0044E684 Module(sqlservr+0004E684) (colnames+00000078)
* 0044E5B4 Module(sqlservr+0004E5B4) (CProchdr::NormQuery+00000045)
* 0044ACF2 Module(sqlservr+0004ACF2) (CProchdr::FCompile+00000305)
* 0041BF21 Module(sqlservr+0001BF21) (CSQLSource::FTransform+0000034C)
* 0044CE55 Module(sqlservr+0004CE55) (CSQLStrings::FTransform+000001A1)
* 0041B8EF Module(sqlservr+0001B8EF) (CSQLSource::Execute+0000015B)
* 006040BD Module(sqlservr+002040BD) (CStmtExecStr::XretExecute+0000032E)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 0048A63B Module(sqlservr+0008A63B) (language_exec+000003E1)
* 0042708C Module(sqlservr+0002708C) (process_commands+0000010E)
* 41075002 Module(UMS+00005002) (ProcessWorkRequests+00000272)
* 41074698 Module(UMS+00004698) (ThreadStartRoutine+00000098)
* 78008454 Module(MSVCRT+00008454) (endthread+000000C1)
* 7C57B388 Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
* ----
2004-12-06 06:50:45.08 spid55 Stack Signature for the dump is 0xC2291C8B
2004-12-06 06:50:45.10 spid55 SQL Server Assertion: File: <dbtable.cpp>,
line=2612
Failed Assertion = 'm_refCount [slot] > 0'.
"Mike Johnson" <mj@.microsoft.com> wrote in message
news:upbtGP62EHA.1400@.TK2MSFTNGP11.phx.gbl...
> When going through my logs this morning I found this curious error.
Anybody
> know what I've got going here? Currently running SQL 2000 sp3a.
Sounds liek you've hit a bug. An assertion shouldn't show up in production
code.
Contact MS Server support.
Failed Assertion?
When going through my logs this morning I found this curious error. Anybody
know what I've got going here? Currently running SQL 2000 sp3a.
*Dump thread - spid = 55, PSS = 0xbca77230, EC = 0xbca77558
*Stack Dump being sent to H:\Program Files\Microsoft SQL
Server\MSSQL\log\SQLDump0063.txt
*
****************************************************************************
***
*
* BEGIN STACK DUMP:
* 12/06/04 06:50:37 spid 55
*
*
*
* Input Buffer 48 bytes -
* exec Spot_GeneralDBStats
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00B2CFFF 0072d000
* ntdll 77F80000 77FFCFFF 0007d000
* KERNEL32 7C570000 7C622FFF 000b3000
* ADVAPI32 7C2D0000 7C331FFF 00062000
* RPCRT4 77D30000 77DA0FFF 00071000
* USER32 77E10000 77E74FFF 00065000
* GDI32 77F40000 77F7AFFF 0003b000
* OPENDS60 41060000 41065FFF 00006000
* MSVCRT 78000000 78044FFF 00045000
* UMS 41070000 4107CFFF 0000d000
* SQLSORT 42AE0000 42B6FFFF 00090000
* MSVCIRT 780A0000 780B1FFF 00012000
* sqlevn70 41080000 41086FFF 00007000
* CLUSAPI 73930000 7393FFFF 00010000
* RESUTILS 689D0000 689DCFFF 0000d000
* USERENV 7C0F0000 7C150FFF 00061000
* NETAPI32 06890000 068DEFFF 0004f000
* Secur32 068E0000 068EEFFF 0000f000
* NTDSAPI 068F0000 06900FFF 00011000
* DNSAPI 06910000 06933FFF 00024000
* WSOCK32 06940000 06947FFF 00008000
* WS2_32 06950000 06963FFF 00014000
* WS2HELP 06970000 06977FFF 00008000
* WLDAP32 06980000 069A9FFF 0002a000
* NETRAP 069B0000 069B5FFF 00006000
* SAMLIB 069C0000 069CEFFF 0000f000
* ole32 07030000 0711EFFF 000ef000
* XOLEHLP 07120000 07127FFF 00008000
* MSDTCPRX 07130000 071E6FFF 000b7000
* MTXCLU 071F0000 071FFFFF 00010000
* VERSION 07200000 07206FFF 00007000
* LZ32 07210000 07215FFF 00006000
* mswsock 07220000 07231FFF 00012000
* msafd 07280000 0729DFFF 0001e000
* wshtcpip 072E0000 072E6FFF 00007000
* rnr20 072F0000 072FBFFF 0000c000
* iphlpapi 07340000 07352FFF 00013000
* ICMP 07360000 07364FFF 00005000
* MPRAPI 07370000 07386FFF 00017000
* OLEAUT32 07390000 0742AFFF 0009b000
* ACTIVEDS 07430000 0745EFFF 0002f000
* ADSLDPC 07460000 07482FFF 00023000
* RTUTILS 07490000 0749DFFF 0000e000
* SETUPAPI 074A0000 0752DFFF 0008e000
* RASAPI32 07530000 07562FFF 00033000
* RASMAN 07570000 07580FFF 00011000
* TAPI32 07590000 075B1FFF 00022000
* COMCTL32 075C0000 07643FFF 00084000
* SHLWAPI 07650000 076B8FFF 00069000
* DHCPCSVC 076C0000 076D8FFF 00019000
* winrnr 07B80000 07B87FFF 00008000
* msv1_0 07C10000 07C30FFF 00021000
* CRYPT32 07C40000 07CC6FFF 00087000
* MSASN1 07CD0000 07CDFFFF 00010000
* rasadhlp 07CE0000 07CE4FFF 00005000
* SSNETLIB 00BF0000 00C04FFF 00015000
* SSNMPN70 00C10000 00C15FFF 00006000
* security 08790000 08793FFF 00004000
* SSmsLPCn 08920000 08926FFF 00007000
* kerberos 08FB0000 08FE5FFF 00036000
* CRYPTDLL 08930000 0893DFFF 0000e000
* SQLFTQRY 00C70000 00CA1FFF 00032000
* CLBCATQ 087A0000 0882FFFF 00090000
* sqloledb 08710000 08782FFF 00073000
* MSDART 00CB0000 00CCEFFF 0001f000
* comdlg32 08840000 0887DFFF 0003e000
* SHELL32 08AD0000 08D14FFF 00245000
* MSDATL3 00CD0000 00CE4FFF 00015000
* oledb32 09E00000 09E65FFF 00066000
* OLEDB32R 08900000 0890FFFF 00010000
* xpsqlbot 08A40000 08A45FFF 00006000
* rsabase 09F80000 09FA2FFF 00023000
* xpstar 0A030000 0A076FFF 00047000
* SQLRESLD 08910000 08916FFF 00007000
* SQLSVC 08EF0000 08F06FFF 00017000
* ODBC32 0A080000 0A0B1FFF 00032000
* odbcbcp 08FA0000 08FA5FFF 00006000
* W95SCM 0A0C0000 0A0CBFFF 0000c000
* SQLUNIRL 0A0D0000 0A0FCFFF 0002d000
* WINSPOOL 0A100000 0A11DFFF 0001e000
* MPR 0A120000 0A12FFFF 00010000
* SHFOLDER 0A130000 0A137FFF 00008000
* odbcint 0A400000 0A415FFF 00016000
* NDDEAPI 0A420000 0A426FFF 00007000
* SQLSVC 0A430000 0A435FFF 00006000
* xpstar 0A440000 0A448FFF 00009000
* xplog70 07B90000 07BA1FFF 00012000
* xplog70 07BB0000 07BB3FFF 00004000
* srchadm 07BD0000 07C05FFF 00036000
* mssws 09D80000 09D87FFF 00008000
* msi 0B5F0000 0B7F3FFF 00204000
* athprxy 09D90000 09D97FFF 00008000
* adsldp 09D00000 09D21FFF 00022000
* adsmsext 09D30000 09D41FFF 00012000
* dbghelp 0BC00000 0BCB4FFF 000b5000
*
* Edi: BCA77558: BCA77230 BCA7755C BCA7755C BCA3D328 5AF67AE0 BC2D8030
* Esi: 00000000:
* Eax: 00000000:
* Ebx: BCA77230: 00000037 00000000 0111C7EF 000095B0 00000000 00000000
* Ecx: 0A84A840: 00000000 0001003F 00000000 00000000 00000000 00000000
* Edx: FFFFFFFF:
* Eip: 0087A90E: 4D830088 75FFFFFC 0875FF0C E8E04D8B 0000002D 64F04D8B
* Ebp: 0A84A824: 0A84B044 0087C41F BCA77230 0A84B1A8 0A84B417 780238AE
* SegCs: 0000001B:
* EFlags: 00010246: 004F0052 00450043 00530053 0052004F 003D0053 00000038
* Esp: 0A84A7F8: BCA77558 00000000 BCA77230 0A84A840 BCA77000 0A84A7F8
* SegSs: 00000023:
*
****************************************************************************
***
* ----
--
* Short Stack Dump
* 0087A90E Module(sqlservr+0047A90E)
(CStackDump::GetContextAndDump+0000002E)
* 0087C41F Module(sqlservr+0047C41F) (stackTrace+00000223)
* 00931097 Module(sqlservr+00531097) (utassert_fail+000002E3)
* 00830207 Module(sqlservr+00430207) (DBLockCache::ReleaseDBLock+00000072)
* 004021F5 Module(sqlservr+000021F5) (unlockdb+00000024)
* 00404829 Module(sqlservr+00004829)
(XdesRMReadOnly::~XdesRMReadOnly+00000075)
* 0040479D Module(sqlservr+0000479D) (ReadOnlyXactImp::Rollback+0000009B)
* 00404490 Module(sqlservr+00004490) (AutoReadOnlyXact::Rollback+0000000E)
* 00404551 Module(sqlservr+00004551) (CSysScan::VRelease+00000069)
* 0045D0B0 Module(sqlservr+0005D0B0) (CObject::FResolveName+0000052D)
* 0045EB9F Module(sqlservr+0005EB9F) (CObject::FResolveName+0000003E)
* 0045EA3E Module(sqlservr+0005EA3E) (CAlgTable::FBind+000002BC)
* 0044F048 Module(sqlservr+0004F048) (FOpenAllRanges+000000DD)
* 0044EAD7 Module(sqlservr+0004EAD7) (find_all+000008DA)
* 0044E684 Module(sqlservr+0004E684) (colnames+00000078)
* 0044E5B4 Module(sqlservr+0004E5B4) (CProchdr::NormQuery+00000045)
* 0044ACF2 Module(sqlservr+0004ACF2) (CProchdr::FCompile+00000305)
* 0041BF21 Module(sqlservr+0001BF21) (CSQLSource::FTransform+0000034C)
* 0044CE55 Module(sqlservr+0004CE55) (CSQLStrings::FTransform+000001A1)
* 0041B8EF Module(sqlservr+0001B8EF) (CSQLSource::Execute+0000015B)
* 006040BD Module(sqlservr+002040BD) (CStmtExecStr::XretExecute+0000032E)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 0048A63B Module(sqlservr+0008A63B) (language_exec+000003E1)
* 0042708C Module(sqlservr+0002708C) (process_commands+0000010E)
* 41075002 Module(UMS+00005002) (ProcessWorkRequests+00000272)
* 41074698 Module(UMS+00004698) (ThreadStartRoutine+00000098)
* 78008454 Module(MSVCRT+00008454) (endthread+000000C1)
* 7C57B388 Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
* ----
--
2004-12-06 06:50:43.50 spid55 Stack Signature for the dump is 0xC84ECD88
2004-12-06 06:50:43.61 spid55 SQL Server Assertion: File: <dbtable.cpp>,
line=2612
Failed Assertion = 'm_refCount [slot] > 0'.
2004-12-06 06:50:43.61 spid55 Error: 3624, Severity: 20, State: 1.
2004-12-06 06:50:43.66 spid55 Using 'dbghelp.dll' version '4.0.5'
*Dump thread - spid = 55, PSS = 0xbca77230, EC = 0xbca77558
*Stack Dump being sent to H:\Program Files\Microsoft SQL
Server\MSSQL\log\SQLDump0064.txt
*
****************************************************************************
***
*
* BEGIN STACK DUMP:
* 12/06/04 06:50:43 spid 55
*
*
*
* exec Spot_GeneralDBStats
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00B2CFFF 0072d000
* ntdll 77F80000 77FFCFFF 0007d000
* KERNEL32 7C570000 7C622FFF 000b3000
* ADVAPI32 7C2D0000 7C331FFF 00062000
* RPCRT4 77D30000 77DA0FFF 00071000
* USER32 77E10000 77E74FFF 00065000
* GDI32 77F40000 77F7AFFF 0003b000
* OPENDS60 41060000 41065FFF 00006000
* MSVCRT 78000000 78044FFF 00045000
* UMS 41070000 4107CFFF 0000d000
* SQLSORT 42AE0000 42B6FFFF 00090000
* MSVCIRT 780A0000 780B1FFF 00012000
* sqlevn70 41080000 41086FFF 00007000
* CLUSAPI 73930000 7393FFFF 00010000
* RESUTILS 689D0000 689DCFFF 0000d000
* USERENV 7C0F0000 7C150FFF 00061000
* NETAPI32 06890000 068DEFFF 0004f000
* Secur32 068E0000 068EEFFF 0000f000
* NTDSAPI 068F0000 06900FFF 00011000
* DNSAPI 06910000 06933FFF 00024000
* WSOCK32 06940000 06947FFF 00008000
* WS2_32 06950000 06963FFF 00014000
* WS2HELP 06970000 06977FFF 00008000
* WLDAP32 06980000 069A9FFF 0002a000
* NETRAP 069B0000 069B5FFF 00006000
* SAMLIB 069C0000 069CEFFF 0000f000
* ole32 07030000 0711EFFF 000ef000
* XOLEHLP 07120000 07127FFF 00008000
* MSDTCPRX 07130000 071E6FFF 000b7000
* MTXCLU 071F0000 071FFFFF 00010000
* VERSION 07200000 07206FFF 00007000
* LZ32 07210000 07215FFF 00006000
* mswsock 07220000 07231FFF 00012000
* msafd 07280000 0729DFFF 0001e000
* wshtcpip 072E0000 072E6FFF 00007000
* rnr20 072F0000 072FBFFF 0000c000
* iphlpapi 07340000 07352FFF 00013000
* ICMP 07360000 07364FFF 00005000
* MPRAPI 07370000 07386FFF 00017000
* OLEAUT32 07390000 0742AFFF 0009b000
* ACTIVEDS 07430000 0745EFFF 0002f000
* ADSLDPC 07460000 07482FFF 00023000
* RTUTILS 07490000 0749DFFF 0000e000
* SETUPAPI 074A0000 0752DFFF 0008e000
* RASAPI32 07530000 07562FFF 00033000
* RASMAN 07570000 07580FFF 00011000
* TAPI32 07590000 075B1FFF 00022000
* COMCTL32 075C0000 07643FFF 00084000
* SHLWAPI 07650000 076B8FFF 00069000
* DHCPCSVC 076C0000 076D8FFF 00019000
* winrnr 07B80000 07B87FFF 00008000
* msv1_0 07C10000 07C30FFF 00021000
* CRYPT32 07C40000 07CC6FFF 00087000
* MSASN1 07CD0000 07CDFFFF 00010000
* rasadhlp 07CE0000 07CE4FFF 00005000
* SSNETLIB 00BF0000 00C04FFF 00015000
* SSNMPN70 00C10000 00C15FFF 00006000
* security 08790000 08793FFF 00004000
* SSmsLPCn 08920000 08926FFF 00007000
* kerberos 08FB0000 08FE5FFF 00036000
* CRYPTDLL 08930000 0893DFFF 0000e000
* SQLFTQRY 00C70000 00CA1FFF 00032000
* CLBCATQ 087A0000 0882FFFF 00090000
* sqloledb 08710000 08782FFF 00073000
* MSDART 00CB0000 00CCEFFF 0001f000
* comdlg32 08840000 0887DFFF 0003e000
* SHELL32 08AD0000 08D14FFF 00245000
* MSDATL3 00CD0000 00CE4FFF 00015000
* oledb32 09E00000 09E65FFF 00066000
* OLEDB32R 08900000 0890FFFF 00010000
* xpsqlbot 08A40000 08A45FFF 00006000
* rsabase 09F80000 09FA2FFF 00023000
* xpstar 0A030000 0A076FFF 00047000
* SQLRESLD 08910000 08916FFF 00007000
* SQLSVC 08EF0000 08F06FFF 00017000
* ODBC32 0A080000 0A0B1FFF 00032000
* odbcbcp 08FA0000 08FA5FFF 00006000
* W95SCM 0A0C0000 0A0CBFFF 0000c000
* SQLUNIRL 0A0D0000 0A0FCFFF 0002d000
* WINSPOOL 0A100000 0A11DFFF 0001e000
* MPR 0A120000 0A12FFFF 00010000
* SHFOLDER 0A130000 0A137FFF 00008000
* odbcint 0A400000 0A415FFF 00016000
* NDDEAPI 0A420000 0A426FFF 00007000
* SQLSVC 0A430000 0A435FFF 00006000
* xpstar 0A440000 0A448FFF 00009000
* xplog70 07B90000 07BA1FFF 00012000
* xplog70 07BB0000 07BB3FFF 00004000
* srchadm 07BD0000 07C05FFF 00036000
* mssws 09D80000 09D87FFF 00008000
* msi 0B5F0000 0B7F3FFF 00204000
* athprxy 09D90000 09D97FFF 00008000
* adsldp 09D00000 09D21FFF 00022000
* adsmsext 09D30000 09D41FFF 00012000
* dbghelp 0BC00000 0BCB4FFF 000b5000
*
* Edi: BCA77558: BCA77230 BCA7755C BCA7755C BCA3D328 5AF67AE0 BC2D8030
* Esi: 00000000:
* Eax: 00000000:
* Ebx: BCA77230: 00060037 00000000 0111C7EF 000095B0 00000000 00000000
* Ecx: 0A848F8C: 00000000 0001003F 00000000 00000000 00000000 00000000
* Edx: FFFFFFFF:
* Eip: 0087A90E: 4D830088 75FFFFFC 0875FF0C E8E04D8B 0000002D 64F04D8B
* Ebp: 0A848F70: 0A849790 0087C41F BCA77230 0A8498F4 0A849B63 780238AE
* SegCs: 0000001B:
* EFlags: 00010246: 004F0052 00450043 00530053 0052004F 003D0053 00000038
* Esp: 0A848F44: BCA77558 00000000 BCA77230 0A848F8C BCA77000 0A848F44
* SegSs: 00000023:
*
****************************************************************************
***
* ----
--
* Short Stack Dump
* 0087A90E Module(sqlservr+0047A90E)
(CStackDump::GetContextAndDump+0000002E)
* 0087C41F Module(sqlservr+0047C41F) (stackTrace+00000223)
* 00931097 Module(sqlservr+00531097) (utassert_fail+000002E3)
* 00830207 Module(sqlservr+00430207) (DBLockCache::ReleaseDBLock+00000072)
* 004021F5 Module(sqlservr+000021F5) (unlockdb+00000024)
* 004437D8 Module(sqlservr+000437D8) (dec_dbopen+0000000D)
* 0044377F Module(sqlservr+0004377F) (closedb+00000069)
* 004438BD Module(sqlservr+000438BD) (CAutoDb::SafeClose+00000027)
* 7800925D Module(MSVCRT+0000925D) (_doserrno+0000009E)
* 0045EB9F Module(sqlservr+0005EB9F) (CObject::FResolveName+0000003E)
* 0045EA3E Module(sqlservr+0005EA3E) (CAlgTable::FBind+000002BC)
* 0044F048 Module(sqlservr+0004F048) (FOpenAllRanges+000000DD)
* 0044EAD7 Module(sqlservr+0004EAD7) (find_all+000008DA)
* 0044E684 Module(sqlservr+0004E684) (colnames+00000078)
* 0044E5B4 Module(sqlservr+0004E5B4) (CProchdr::NormQuery+00000045)
* 0044ACF2 Module(sqlservr+0004ACF2) (CProchdr::FCompile+00000305)
* 0041BF21 Module(sqlservr+0001BF21) (CSQLSource::FTransform+0000034C)
* 0044CE55 Module(sqlservr+0004CE55) (CSQLStrings::FTransform+000001A1)
* 0041B8EF Module(sqlservr+0001B8EF) (CSQLSource::Execute+0000015B)
* 006040BD Module(sqlservr+002040BD) (CStmtExecStr::XretExecute+0000032E)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 0048A63B Module(sqlservr+0008A63B) (language_exec+000003E1)
* 0042708C Module(sqlservr+0002708C) (process_commands+0000010E)
* 41075002 Module(UMS+00005002) (ProcessWorkRequests+00000272)
* 41074698 Module(UMS+00004698) (ThreadStartRoutine+00000098)
* 78008454 Module(MSVCRT+00008454) (endthread+000000C1)
* 7C57B388 Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
* ----
--
2004-12-06 06:50:45.08 spid55 Stack Signature for the dump is 0xC2291C8B
2004-12-06 06:50:45.10 spid55 SQL Server Assertion: File: <dbtable.cpp>,
line=2612
Failed Assertion = 'm_refCount [slot] > 0'."Mike Johnson" <mj@.microsoft.com> wrote in message
news:upbtGP62EHA.1400@.TK2MSFTNGP11.phx.gbl...
> When going through my logs this morning I found this curious error.
Anybody
> know what I've got going here? Currently running SQL 2000 sp3a.
Sounds liek you've hit a bug. An assertion shouldn't show up in production
code.
Contact MS Server support.
know what I've got going here? Currently running SQL 2000 sp3a.
*Dump thread - spid = 55, PSS = 0xbca77230, EC = 0xbca77558
*Stack Dump being sent to H:\Program Files\Microsoft SQL
Server\MSSQL\log\SQLDump0063.txt
*
****************************************************************************
***
*
* BEGIN STACK DUMP:
* 12/06/04 06:50:37 spid 55
*
*
*
* Input Buffer 48 bytes -
* exec Spot_GeneralDBStats
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00B2CFFF 0072d000
* ntdll 77F80000 77FFCFFF 0007d000
* KERNEL32 7C570000 7C622FFF 000b3000
* ADVAPI32 7C2D0000 7C331FFF 00062000
* RPCRT4 77D30000 77DA0FFF 00071000
* USER32 77E10000 77E74FFF 00065000
* GDI32 77F40000 77F7AFFF 0003b000
* OPENDS60 41060000 41065FFF 00006000
* MSVCRT 78000000 78044FFF 00045000
* UMS 41070000 4107CFFF 0000d000
* SQLSORT 42AE0000 42B6FFFF 00090000
* MSVCIRT 780A0000 780B1FFF 00012000
* sqlevn70 41080000 41086FFF 00007000
* CLUSAPI 73930000 7393FFFF 00010000
* RESUTILS 689D0000 689DCFFF 0000d000
* USERENV 7C0F0000 7C150FFF 00061000
* NETAPI32 06890000 068DEFFF 0004f000
* Secur32 068E0000 068EEFFF 0000f000
* NTDSAPI 068F0000 06900FFF 00011000
* DNSAPI 06910000 06933FFF 00024000
* WSOCK32 06940000 06947FFF 00008000
* WS2_32 06950000 06963FFF 00014000
* WS2HELP 06970000 06977FFF 00008000
* WLDAP32 06980000 069A9FFF 0002a000
* NETRAP 069B0000 069B5FFF 00006000
* SAMLIB 069C0000 069CEFFF 0000f000
* ole32 07030000 0711EFFF 000ef000
* XOLEHLP 07120000 07127FFF 00008000
* MSDTCPRX 07130000 071E6FFF 000b7000
* MTXCLU 071F0000 071FFFFF 00010000
* VERSION 07200000 07206FFF 00007000
* LZ32 07210000 07215FFF 00006000
* mswsock 07220000 07231FFF 00012000
* msafd 07280000 0729DFFF 0001e000
* wshtcpip 072E0000 072E6FFF 00007000
* rnr20 072F0000 072FBFFF 0000c000
* iphlpapi 07340000 07352FFF 00013000
* ICMP 07360000 07364FFF 00005000
* MPRAPI 07370000 07386FFF 00017000
* OLEAUT32 07390000 0742AFFF 0009b000
* ACTIVEDS 07430000 0745EFFF 0002f000
* ADSLDPC 07460000 07482FFF 00023000
* RTUTILS 07490000 0749DFFF 0000e000
* SETUPAPI 074A0000 0752DFFF 0008e000
* RASAPI32 07530000 07562FFF 00033000
* RASMAN 07570000 07580FFF 00011000
* TAPI32 07590000 075B1FFF 00022000
* COMCTL32 075C0000 07643FFF 00084000
* SHLWAPI 07650000 076B8FFF 00069000
* DHCPCSVC 076C0000 076D8FFF 00019000
* winrnr 07B80000 07B87FFF 00008000
* msv1_0 07C10000 07C30FFF 00021000
* CRYPT32 07C40000 07CC6FFF 00087000
* MSASN1 07CD0000 07CDFFFF 00010000
* rasadhlp 07CE0000 07CE4FFF 00005000
* SSNETLIB 00BF0000 00C04FFF 00015000
* SSNMPN70 00C10000 00C15FFF 00006000
* security 08790000 08793FFF 00004000
* SSmsLPCn 08920000 08926FFF 00007000
* kerberos 08FB0000 08FE5FFF 00036000
* CRYPTDLL 08930000 0893DFFF 0000e000
* SQLFTQRY 00C70000 00CA1FFF 00032000
* CLBCATQ 087A0000 0882FFFF 00090000
* sqloledb 08710000 08782FFF 00073000
* MSDART 00CB0000 00CCEFFF 0001f000
* comdlg32 08840000 0887DFFF 0003e000
* SHELL32 08AD0000 08D14FFF 00245000
* MSDATL3 00CD0000 00CE4FFF 00015000
* oledb32 09E00000 09E65FFF 00066000
* OLEDB32R 08900000 0890FFFF 00010000
* xpsqlbot 08A40000 08A45FFF 00006000
* rsabase 09F80000 09FA2FFF 00023000
* xpstar 0A030000 0A076FFF 00047000
* SQLRESLD 08910000 08916FFF 00007000
* SQLSVC 08EF0000 08F06FFF 00017000
* ODBC32 0A080000 0A0B1FFF 00032000
* odbcbcp 08FA0000 08FA5FFF 00006000
* W95SCM 0A0C0000 0A0CBFFF 0000c000
* SQLUNIRL 0A0D0000 0A0FCFFF 0002d000
* WINSPOOL 0A100000 0A11DFFF 0001e000
* MPR 0A120000 0A12FFFF 00010000
* SHFOLDER 0A130000 0A137FFF 00008000
* odbcint 0A400000 0A415FFF 00016000
* NDDEAPI 0A420000 0A426FFF 00007000
* SQLSVC 0A430000 0A435FFF 00006000
* xpstar 0A440000 0A448FFF 00009000
* xplog70 07B90000 07BA1FFF 00012000
* xplog70 07BB0000 07BB3FFF 00004000
* srchadm 07BD0000 07C05FFF 00036000
* mssws 09D80000 09D87FFF 00008000
* msi 0B5F0000 0B7F3FFF 00204000
* athprxy 09D90000 09D97FFF 00008000
* adsldp 09D00000 09D21FFF 00022000
* adsmsext 09D30000 09D41FFF 00012000
* dbghelp 0BC00000 0BCB4FFF 000b5000
*
* Edi: BCA77558: BCA77230 BCA7755C BCA7755C BCA3D328 5AF67AE0 BC2D8030
* Esi: 00000000:
* Eax: 00000000:
* Ebx: BCA77230: 00000037 00000000 0111C7EF 000095B0 00000000 00000000
* Ecx: 0A84A840: 00000000 0001003F 00000000 00000000 00000000 00000000
* Edx: FFFFFFFF:
* Eip: 0087A90E: 4D830088 75FFFFFC 0875FF0C E8E04D8B 0000002D 64F04D8B
* Ebp: 0A84A824: 0A84B044 0087C41F BCA77230 0A84B1A8 0A84B417 780238AE
* SegCs: 0000001B:
* EFlags: 00010246: 004F0052 00450043 00530053 0052004F 003D0053 00000038
* Esp: 0A84A7F8: BCA77558 00000000 BCA77230 0A84A840 BCA77000 0A84A7F8
* SegSs: 00000023:
*
****************************************************************************
***
* ----
--
* Short Stack Dump
* 0087A90E Module(sqlservr+0047A90E)
(CStackDump::GetContextAndDump+0000002E)
* 0087C41F Module(sqlservr+0047C41F) (stackTrace+00000223)
* 00931097 Module(sqlservr+00531097) (utassert_fail+000002E3)
* 00830207 Module(sqlservr+00430207) (DBLockCache::ReleaseDBLock+00000072)
* 004021F5 Module(sqlservr+000021F5) (unlockdb+00000024)
* 00404829 Module(sqlservr+00004829)
(XdesRMReadOnly::~XdesRMReadOnly+00000075)
* 0040479D Module(sqlservr+0000479D) (ReadOnlyXactImp::Rollback+0000009B)
* 00404490 Module(sqlservr+00004490) (AutoReadOnlyXact::Rollback+0000000E)
* 00404551 Module(sqlservr+00004551) (CSysScan::VRelease+00000069)
* 0045D0B0 Module(sqlservr+0005D0B0) (CObject::FResolveName+0000052D)
* 0045EB9F Module(sqlservr+0005EB9F) (CObject::FResolveName+0000003E)
* 0045EA3E Module(sqlservr+0005EA3E) (CAlgTable::FBind+000002BC)
* 0044F048 Module(sqlservr+0004F048) (FOpenAllRanges+000000DD)
* 0044EAD7 Module(sqlservr+0004EAD7) (find_all+000008DA)
* 0044E684 Module(sqlservr+0004E684) (colnames+00000078)
* 0044E5B4 Module(sqlservr+0004E5B4) (CProchdr::NormQuery+00000045)
* 0044ACF2 Module(sqlservr+0004ACF2) (CProchdr::FCompile+00000305)
* 0041BF21 Module(sqlservr+0001BF21) (CSQLSource::FTransform+0000034C)
* 0044CE55 Module(sqlservr+0004CE55) (CSQLStrings::FTransform+000001A1)
* 0041B8EF Module(sqlservr+0001B8EF) (CSQLSource::Execute+0000015B)
* 006040BD Module(sqlservr+002040BD) (CStmtExecStr::XretExecute+0000032E)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 0048A63B Module(sqlservr+0008A63B) (language_exec+000003E1)
* 0042708C Module(sqlservr+0002708C) (process_commands+0000010E)
* 41075002 Module(UMS+00005002) (ProcessWorkRequests+00000272)
* 41074698 Module(UMS+00004698) (ThreadStartRoutine+00000098)
* 78008454 Module(MSVCRT+00008454) (endthread+000000C1)
* 7C57B388 Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
* ----
--
2004-12-06 06:50:43.50 spid55 Stack Signature for the dump is 0xC84ECD88
2004-12-06 06:50:43.61 spid55 SQL Server Assertion: File: <dbtable.cpp>,
line=2612
Failed Assertion = 'm_refCount [slot] > 0'.
2004-12-06 06:50:43.61 spid55 Error: 3624, Severity: 20, State: 1.
2004-12-06 06:50:43.66 spid55 Using 'dbghelp.dll' version '4.0.5'
*Dump thread - spid = 55, PSS = 0xbca77230, EC = 0xbca77558
*Stack Dump being sent to H:\Program Files\Microsoft SQL
Server\MSSQL\log\SQLDump0064.txt
*
****************************************************************************
***
*
* BEGIN STACK DUMP:
* 12/06/04 06:50:43 spid 55
*
*
*
* exec Spot_GeneralDBStats
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00B2CFFF 0072d000
* ntdll 77F80000 77FFCFFF 0007d000
* KERNEL32 7C570000 7C622FFF 000b3000
* ADVAPI32 7C2D0000 7C331FFF 00062000
* RPCRT4 77D30000 77DA0FFF 00071000
* USER32 77E10000 77E74FFF 00065000
* GDI32 77F40000 77F7AFFF 0003b000
* OPENDS60 41060000 41065FFF 00006000
* MSVCRT 78000000 78044FFF 00045000
* UMS 41070000 4107CFFF 0000d000
* SQLSORT 42AE0000 42B6FFFF 00090000
* MSVCIRT 780A0000 780B1FFF 00012000
* sqlevn70 41080000 41086FFF 00007000
* CLUSAPI 73930000 7393FFFF 00010000
* RESUTILS 689D0000 689DCFFF 0000d000
* USERENV 7C0F0000 7C150FFF 00061000
* NETAPI32 06890000 068DEFFF 0004f000
* Secur32 068E0000 068EEFFF 0000f000
* NTDSAPI 068F0000 06900FFF 00011000
* DNSAPI 06910000 06933FFF 00024000
* WSOCK32 06940000 06947FFF 00008000
* WS2_32 06950000 06963FFF 00014000
* WS2HELP 06970000 06977FFF 00008000
* WLDAP32 06980000 069A9FFF 0002a000
* NETRAP 069B0000 069B5FFF 00006000
* SAMLIB 069C0000 069CEFFF 0000f000
* ole32 07030000 0711EFFF 000ef000
* XOLEHLP 07120000 07127FFF 00008000
* MSDTCPRX 07130000 071E6FFF 000b7000
* MTXCLU 071F0000 071FFFFF 00010000
* VERSION 07200000 07206FFF 00007000
* LZ32 07210000 07215FFF 00006000
* mswsock 07220000 07231FFF 00012000
* msafd 07280000 0729DFFF 0001e000
* wshtcpip 072E0000 072E6FFF 00007000
* rnr20 072F0000 072FBFFF 0000c000
* iphlpapi 07340000 07352FFF 00013000
* ICMP 07360000 07364FFF 00005000
* MPRAPI 07370000 07386FFF 00017000
* OLEAUT32 07390000 0742AFFF 0009b000
* ACTIVEDS 07430000 0745EFFF 0002f000
* ADSLDPC 07460000 07482FFF 00023000
* RTUTILS 07490000 0749DFFF 0000e000
* SETUPAPI 074A0000 0752DFFF 0008e000
* RASAPI32 07530000 07562FFF 00033000
* RASMAN 07570000 07580FFF 00011000
* TAPI32 07590000 075B1FFF 00022000
* COMCTL32 075C0000 07643FFF 00084000
* SHLWAPI 07650000 076B8FFF 00069000
* DHCPCSVC 076C0000 076D8FFF 00019000
* winrnr 07B80000 07B87FFF 00008000
* msv1_0 07C10000 07C30FFF 00021000
* CRYPT32 07C40000 07CC6FFF 00087000
* MSASN1 07CD0000 07CDFFFF 00010000
* rasadhlp 07CE0000 07CE4FFF 00005000
* SSNETLIB 00BF0000 00C04FFF 00015000
* SSNMPN70 00C10000 00C15FFF 00006000
* security 08790000 08793FFF 00004000
* SSmsLPCn 08920000 08926FFF 00007000
* kerberos 08FB0000 08FE5FFF 00036000
* CRYPTDLL 08930000 0893DFFF 0000e000
* SQLFTQRY 00C70000 00CA1FFF 00032000
* CLBCATQ 087A0000 0882FFFF 00090000
* sqloledb 08710000 08782FFF 00073000
* MSDART 00CB0000 00CCEFFF 0001f000
* comdlg32 08840000 0887DFFF 0003e000
* SHELL32 08AD0000 08D14FFF 00245000
* MSDATL3 00CD0000 00CE4FFF 00015000
* oledb32 09E00000 09E65FFF 00066000
* OLEDB32R 08900000 0890FFFF 00010000
* xpsqlbot 08A40000 08A45FFF 00006000
* rsabase 09F80000 09FA2FFF 00023000
* xpstar 0A030000 0A076FFF 00047000
* SQLRESLD 08910000 08916FFF 00007000
* SQLSVC 08EF0000 08F06FFF 00017000
* ODBC32 0A080000 0A0B1FFF 00032000
* odbcbcp 08FA0000 08FA5FFF 00006000
* W95SCM 0A0C0000 0A0CBFFF 0000c000
* SQLUNIRL 0A0D0000 0A0FCFFF 0002d000
* WINSPOOL 0A100000 0A11DFFF 0001e000
* MPR 0A120000 0A12FFFF 00010000
* SHFOLDER 0A130000 0A137FFF 00008000
* odbcint 0A400000 0A415FFF 00016000
* NDDEAPI 0A420000 0A426FFF 00007000
* SQLSVC 0A430000 0A435FFF 00006000
* xpstar 0A440000 0A448FFF 00009000
* xplog70 07B90000 07BA1FFF 00012000
* xplog70 07BB0000 07BB3FFF 00004000
* srchadm 07BD0000 07C05FFF 00036000
* mssws 09D80000 09D87FFF 00008000
* msi 0B5F0000 0B7F3FFF 00204000
* athprxy 09D90000 09D97FFF 00008000
* adsldp 09D00000 09D21FFF 00022000
* adsmsext 09D30000 09D41FFF 00012000
* dbghelp 0BC00000 0BCB4FFF 000b5000
*
* Edi: BCA77558: BCA77230 BCA7755C BCA7755C BCA3D328 5AF67AE0 BC2D8030
* Esi: 00000000:
* Eax: 00000000:
* Ebx: BCA77230: 00060037 00000000 0111C7EF 000095B0 00000000 00000000
* Ecx: 0A848F8C: 00000000 0001003F 00000000 00000000 00000000 00000000
* Edx: FFFFFFFF:
* Eip: 0087A90E: 4D830088 75FFFFFC 0875FF0C E8E04D8B 0000002D 64F04D8B
* Ebp: 0A848F70: 0A849790 0087C41F BCA77230 0A8498F4 0A849B63 780238AE
* SegCs: 0000001B:
* EFlags: 00010246: 004F0052 00450043 00530053 0052004F 003D0053 00000038
* Esp: 0A848F44: BCA77558 00000000 BCA77230 0A848F8C BCA77000 0A848F44
* SegSs: 00000023:
*
****************************************************************************
***
* ----
--
* Short Stack Dump
* 0087A90E Module(sqlservr+0047A90E)
(CStackDump::GetContextAndDump+0000002E)
* 0087C41F Module(sqlservr+0047C41F) (stackTrace+00000223)
* 00931097 Module(sqlservr+00531097) (utassert_fail+000002E3)
* 00830207 Module(sqlservr+00430207) (DBLockCache::ReleaseDBLock+00000072)
* 004021F5 Module(sqlservr+000021F5) (unlockdb+00000024)
* 004437D8 Module(sqlservr+000437D8) (dec_dbopen+0000000D)
* 0044377F Module(sqlservr+0004377F) (closedb+00000069)
* 004438BD Module(sqlservr+000438BD) (CAutoDb::SafeClose+00000027)
* 7800925D Module(MSVCRT+0000925D) (_doserrno+0000009E)
* 0045EB9F Module(sqlservr+0005EB9F) (CObject::FResolveName+0000003E)
* 0045EA3E Module(sqlservr+0005EA3E) (CAlgTable::FBind+000002BC)
* 0044F048 Module(sqlservr+0004F048) (FOpenAllRanges+000000DD)
* 0044EAD7 Module(sqlservr+0004EAD7) (find_all+000008DA)
* 0044E684 Module(sqlservr+0004E684) (colnames+00000078)
* 0044E5B4 Module(sqlservr+0004E5B4) (CProchdr::NormQuery+00000045)
* 0044ACF2 Module(sqlservr+0004ACF2) (CProchdr::FCompile+00000305)
* 0041BF21 Module(sqlservr+0001BF21) (CSQLSource::FTransform+0000034C)
* 0044CE55 Module(sqlservr+0004CE55) (CSQLStrings::FTransform+000001A1)
* 0041B8EF Module(sqlservr+0001B8EF) (CSQLSource::Execute+0000015B)
* 006040BD Module(sqlservr+002040BD) (CStmtExecStr::XretExecute+0000032E)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 0048A63B Module(sqlservr+0008A63B) (language_exec+000003E1)
* 0042708C Module(sqlservr+0002708C) (process_commands+0000010E)
* 41075002 Module(UMS+00005002) (ProcessWorkRequests+00000272)
* 41074698 Module(UMS+00004698) (ThreadStartRoutine+00000098)
* 78008454 Module(MSVCRT+00008454) (endthread+000000C1)
* 7C57B388 Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
* ----
--
2004-12-06 06:50:45.08 spid55 Stack Signature for the dump is 0xC2291C8B
2004-12-06 06:50:45.10 spid55 SQL Server Assertion: File: <dbtable.cpp>,
line=2612
Failed Assertion = 'm_refCount [slot] > 0'."Mike Johnson" <mj@.microsoft.com> wrote in message
news:upbtGP62EHA.1400@.TK2MSFTNGP11.phx.gbl...
> When going through my logs this morning I found this curious error.
Anybody
> know what I've got going here? Currently running SQL 2000 sp3a.
Sounds liek you've hit a bug. An assertion shouldn't show up in production
code.
Contact MS Server support.
Failed Assertion
We're getting the following on a Windows 2003 Server, running SQL 2000 SP3a.
17066:
SQL Server Assertion: File: <diskio.c>, line=670
Failed Assertion = 'filepos + CBytes <= (DWORDLONG) m_size << PAGESIZEBITS'.
Any ideas?
Jeremy
Well I think by Failed Assertion means it failed some runtime check. Theres
no way to really know whats causing this error in your specific instance but
its probably some kind of database information inconsistency. Type DBCC
CHECKDB and see what it says. Your database probably isnt normalized well
enough.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200601/1
17066:
SQL Server Assertion: File: <diskio.c>, line=670
Failed Assertion = 'filepos + CBytes <= (DWORDLONG) m_size << PAGESIZEBITS'.
Any ideas?
Jeremy
Well I think by Failed Assertion means it failed some runtime check. Theres
no way to really know whats causing this error in your specific instance but
its probably some kind of database information inconsistency. Type DBCC
CHECKDB and see what it says. Your database probably isnt normalized well
enough.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200601/1
Failed Assertion
We're getting the following on a Windows 2003 Server, running SQL 2000 SP3a.
17066:
SQL Server Assertion: File: <diskio.c>, line=670
Failed Assertion = 'filepos + CBytes <= (DWORDLONG) m_size << PAGESIZEBITS'.
Any ideas?
JeremyWell I think by Failed Assertion means it failed some runtime check. Theres
no way to really know whats causing this error in your specific instance but
its probably some kind of database information inconsistency. Type DBCC
CHECKDB and see what it says. Your database probably isnt normalized well
enough.
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200601/1
17066:
SQL Server Assertion: File: <diskio.c>, line=670
Failed Assertion = 'filepos + CBytes <= (DWORDLONG) m_size << PAGESIZEBITS'.
Any ideas?
JeremyWell I think by Failed Assertion means it failed some runtime check. Theres
no way to really know whats causing this error in your specific instance but
its probably some kind of database information inconsistency. Type DBCC
CHECKDB and see what it says. Your database probably isnt normalized well
enough.
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200601/1
Failed Assertion
We're getting the following on a Windows 2003 Server, running SQL 2000 SP3a.
17066:
SQL Server Assertion: File: <diskio.c>, line=670
Failed Assertion = 'filepos + CBytes <= (DWORDLONG) m_size << PAGESIZEBITS'.
Any ideas?
JeremyWell I think by Failed Assertion means it failed some runtime check. Theres
no way to really know whats causing this error in your specific instance but
its probably some kind of database information inconsistency. Type DBCC
CHECKDB and see what it says. Your database probably isnt normalized well
enough.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200601/1
17066:
SQL Server Assertion: File: <diskio.c>, line=670
Failed Assertion = 'filepos + CBytes <= (DWORDLONG) m_size << PAGESIZEBITS'.
Any ideas?
JeremyWell I think by Failed Assertion means it failed some runtime check. Theres
no way to really know whats causing this error in your specific instance but
its probably some kind of database information inconsistency. Type DBCC
CHECKDB and see what it says. Your database probably isnt normalized well
enough.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200601/1
Subscribe to:
Posts (Atom)