##lockinfo

None of my clients can connect to my database. They receive errors about
all available connections being used yet there are no connections to
the database and there are actually 50 available. This is not an
in-house application and as such I have also been in touch with the
application developers but need this sorting as soon as possible so
thought I would ask here as well.
Using the ODBC administrator tests to the database are successful which
shows basic level of communication is ok.
Using Enterprise Manager on the SQL server gives the following
information under Management - Locks/Processes: spid 51. In the right
hand pane this has the following info
Object:master.dbo.spt_values
Lock Type:TAB
Mode:Sch-S
Status:GRANT
Owner:Xact
Index:
Object:tempdb.dbo.##lockinfo51
Lock Type:TAB
Mode:X
Status:GRANT
Owner:Xact
Index:##lockinfo51
Both resource columns are blank.
Both those entries are also listed under Management | Locks/Objects
where they have the same information listed. Both have Process ID 51.
Is this the reason my database is locked and if so how can I clear this?
Any and all info is gratefully received and if you need any more
information please ask.Should also have said I'm using SQL2000 SP3 on Windows Server 2003.
Clients are 2000/XP.
Paul Gregory wrote:
> None of my clients can connect to my database. They receive errors about
> all available connections being used yet there are no connections to
> the database and there are actually 50 available. This is not an
> in-house application and as such I have also been in touch with the
> application developers but need this sorting as soon as possible so
> thought I would ask here as well.
> Using the ODBC administrator tests to the database are successful which
> shows basic level of communication is ok.
> Using Enterprise Manager on the SQL server gives the following
> information under Management - Locks/Processes: spid 51. In the right
> hand pane this has the following info
> Object:master.dbo.spt_values
> Lock Type:TAB
> Mode:Sch-S
> Status:GRANT
> Owner:Xact
> Index:
> Object:tempdb.dbo.##lockinfo51
> Lock Type:TAB
> Mode:X
> Status:GRANT
> Owner:Xact
> Index:##lockinfo51
> Both resource columns are blank.
> Both those entries are also listed under Management | Locks/Objects
> where they have the same information listed. Both have Process ID 51.
> Is this the reason my database is locked and if so how can I clear this?
> Any and all info is gratefully received and if you need any more
> information please ask.|||No...that's not the reason. Those entries you are looking at
in Enterprise Manager are for your connection when you are
checking the locks using Enterprise Manager. What you are
seeing is normal for what you are doing.
You would want to post the exact error message and error
number. You would also want to check the SQL Server error
log and the event logs on the SQL Server box. If you can
connect to the database from workstations without using the
application then it could be something in the application
itself. You could also run profiler and try a connection
using the application to see what is going on.
-Sue
On Mon, 04 Apr 2005 20:21:54 +0100, Paul Gregory
<nospam@.nospam.com> wrote:
>Should also have said I'm using SQL2000 SP3 on Windows Server 2003.
>Clients are 2000/XP.
>Paul Gregory wrote:
>> None of my clients can connect to my database. They receive errors about
>> all available connections being used yet there are no connections to
>> the database and there are actually 50 available. This is not an
>> in-house application and as such I have also been in touch with the
>> application developers but need this sorting as soon as possible so
>> thought I would ask here as well.
>> Using the ODBC administrator tests to the database are successful which
>> shows basic level of communication is ok.
>> Using Enterprise Manager on the SQL server gives the following
>> information under Management - Locks/Processes: spid 51. In the right
>> hand pane this has the following info
>> Object:master.dbo.spt_values
>> Lock Type:TAB
>> Mode:Sch-S
>> Status:GRANT
>> Owner:Xact
>> Index:
>> Object:tempdb.dbo.##lockinfo51
>> Lock Type:TAB
>> Mode:X
>> Status:GRANT
>> Owner:Xact
>> Index:##lockinfo51
>> Both resource columns are blank.
>> Both those entries are also listed under Management | Locks/Objects
>> where they have the same information listed. Both have Process ID 51.
>> Is this the reason my database is locked and if so how can I clear this?
>> Any and all info is gratefully received and if you need any more
>> information please ask.|||That makes sense - My SQL inexperience shone through brightly there.
Eventvwr and SQLErrorLog both show the following:-
2005-04-05 07:57:22.99 spid53 Stack Signature for the dump is 0x3D65CC92
2005-04-05 07:57:22.99 spid53 SQL Server Assertion: File: <recbase.cpp>,
line=1378
Failed Assertion = 'm_offBeginVar < m_SizeRec'.
2005-04-05 07:57:23.00 spid53 Error: 3624, Severity: 20, State: 1.
2005-04-05 08:00:45.79 spid54 Using 'xpstar.dll' version '2000.80.760' to
execute extended stored procedure 'sp_MSgetversion'.
2005-04-05 08:14:08.03 spid52 Using 'dbghelp.dll' version '4.0.5'
*Dump thread - spid = 52, PSS = 0x26ddf208, EC = 0x26ddf530
*Stack Dump being sent to d:\SQLData\MSSQL\log\SQLDump0028.txt
*
*******************************************************************************
*
* BEGIN STACK DUMP:
* 04/05/05 08:14:08 spid 52
*
*
*
* Input Buffer 136 bytes -
* Select Max(SecondAuditKey) from AUDITTRAIL Where ACUsrAuditKey = 016
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00B2CFFF 0072d000
* ntdll 77F40000 77FF9FFF 000ba000
* kernel32 77E40000 77F33FFF 000f4000
* ADVAPI32 77DA0000 77E2FFFF 00090000
* RPCRT4 77C50000 77CF4FFF 000a5000
* USER32 77D00000 77D8EFFF 0008f000
* GDI32 77C00000 77C43FFF 00044000
* OPENDS60 41060000 41065FFF 00006000
* MSVCRT 77BA0000 77BF3FFF 00054000
* UMS 41070000 4107CFFF 0000d000
* SQLSORT 42AE0000 42B6FFFF 00090000
* MSVCIRT 60020000 6002FFFF 00010000
* sqlevn70 41080000 41086FFF 00007000
* NETAPI32 71C40000 71C92FFF 00053000
* ole32 77160000 77285FFF 00126000
* XOLEHLP 01F80000 01F85FFF 00006000
* MSDTCPRX 61150000 611C1FFF 00072000
* OLEAUT32 770E0000 7715CFFF 0007d000
* MSVCP60 780C0000 78120FFF 00061000
* MTXCLU 74F40000 74F57FFF 00018000
* VERSION 77B90000 77B97FFF 00008000
* WSOCK32 71BB0000 71BB8FFF 00009000
* WS2_32 71C00000 71C17FFF 00018000
* WS2HELP 71BF0000 71BF7FFF 00008000
* CLUSAPI 74DE0000 74DF0FFF 00011000
* RESUTILS 74EF0000 74F01FFF 00012000
* USERENV 75970000 75A29FFF 000ba000
* MFC42u 72880000 72973FFF 000f4000
* secur32 76F50000 76F62FFF 00013000
* mswsock 71B20000 71B62FFF 00043000
* DNSAPI 76ED0000 76EF6FFF 00027000
* winrnr 76F70000 76F76FFF 00007000
* WLDAP32 76F10000 76F3EFFF 0002f000
* NWWS2NDS 66210000 66218FFF 00009000
* NETWIN32 02200000 02246FFF 00047000
* CLNWIN32 02250000 02264FFF 00015000
* LOCWIN32 02270000 0228FFFF 00020000
* NCPWIN32 02290000 022BAFFF 0002b000
* NWWS2SLP 66220000 6622BFFF 0000c000
* NWSRVLOC 02300000 02306FFF 00007000
* rasadhlp 76F80000 76F84FFF 00005000
* SSNETLIB 00C70000 00C84FFF 00015000
* SSNMPN70 410D0000 410D5FFF 00006000
* security 71F60000 71F63FFF 00004000
* wshtcpip 71AE0000 71AE7FFF 00008000
* SSmsLPCn 030B0000 030B6FFF 00007000
* ntdsapi 766F0000 76705FFF 00016000
* SQLFTQRY 02ED0000 02F01FFF 00032000
* CLBCatQ 76F90000 7700DFFF 0007e000
* COMRes 77010000 770D5FFF 000c6000
* sqloledb 03510000 03595FFF 00086000
* MSDART 74A50000 74A78FFF 00029000
* COMCTL32 70BC0000 70C4FFFF 00090000
* comdlg32 762B0000 762F6FFF 00047000
* SHLWAPI 77290000 772D8FFF 00049000
* SHELL32 77380000 77B5EFFF 007df000
* MSDATL3 61200000 61217FFF 00018000
* comctl32 70AD0000 70BB5FFF 000e6000
* oledb32 037A0000 0381CFFF 0007d000
* OLEDB32R 03010000 03020FFF 00011000
* rsaenh 0FFD0000 0FFFCFFF 0002d000
* PSAPI 76B70000 76B7AFFF 0000b000
* msv1_0 76C90000 76CB3FFF 00024000
* xpstar 410F0000 41136FFF 00047000
* SQLRESLD 42AC0000 42AC6FFF 00007000
* SQLSVC 038A0000 038B6FFF 00017000
* ODBC32 038C0000 038F9FFF 0003a000
* odbcbcp 03900000 03905FFF 00006000
* W95SCM 41140000 4114BFFF 0000c000
* SQLUNIRL 5BB30000 5BB5CFFF 0002d000
* WINSPOOL 73070000 73095FFF 00026000
* SHFOLDER 766D0000 766D8FFF 00009000
* odbcint 03A10000 03A26FFF 00017000
* NDDEAPI 75810000 75816FFF 00007000
* SQLSVC 03A40000 03A45FFF 00006000
* xpstar 03A50000 03A58FFF 00009000
* dbghelp 03CA0000 03D54FFF 000b5000
*
* Edi: 26DDF530: 26DDF208 24147BB0 26D71808 26D4E288 24147700
24146030
* Esi: 00000000:
* Eax: 00000000:
* Ebx: 26DDF208: 00000034 00000000 0087AE99 0000962D 00000000
00000000
* Ecx: 0348E508: 00000000 0001003F 00000000 00000000 00000000
00000000
* Edx: 7FFE0304: 0C819CC3 00010024 90C39D00 90909090 90909090
90909090
* Eip: 0087A90E: 4D830088 75FFFFFC 0875FF0C E8E04D8B 0000002D
64F04D8B
* Ebp: 0348E4EC: 0348ED0C 0087C41F 26DDF208 0348EE70 0348F0E3
77BCD86E
* SegCs: 0000001B:
* EFlags: 00010246: 00740073 006D0065 00320033 0043003B 005C003A
00490057
* Esp: 0348E4C0: 26DDF530 00000000 26DDF208 0348E508 26DDF000
0348E4C0
* 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)
* 007FC8A6 Module(sqlservr+003FC8A6) (RecBase::ReSizeVar+00000069)
* 00403B44 Module(sqlservr+00003B44) (RecBase::Resize+0000005B)
* 004079F0 Module(sqlservr+000079F0) (RecBase::IsNull+00000011)
* 004303D3 Module(sqlservr+000303D3)
(TCValSSInRow<58,1,1>::GetDataX+00000024)
* 00425A51 Module(sqlservr+00025A51) (CEs::FastCompare1+00000030)
* 00406011 Module(sqlservr+00006011) (SDES::GetBiDi+0000062D)
* 0042A639 Module(sqlservr+0002A639) (RowsetSS::FetchNextRow+0000009B)
* 0042A4F6 Module(sqlservr+0002A4F6)
(CQScanRowset::GetRowWithPrefetch+00000040)
* 0042C21B Module(sqlservr+0002C21B) (CQScanRange::GetRow+000000EF)
* 0043B405 Module(sqlservr+0003B405)
(CRowPrefetchDelayMgr::GetRowUnordered+000000DD)
* 0043B3A0 Module(sqlservr+0003B3A0) (CRowPrefetchDelayMgr::GetRow+0000001B)
* 006E212E Module(sqlservr+002E212E) (CQScanPreFetchDelay::GetRow+00000014)
* 0043AF9F Module(sqlservr+0003AF9F) (CQScanFetch::GetRow+00000048)
* 004301A9 Module(sqlservr+000301A9)
(CQScanStreamAggregate::GetRow+0000012F)
* 0042F735 Module(sqlservr+0002F735)
(CQScanStreamAggregate::GetCalculatedRow+00000011)
* 0042F71F Module(sqlservr+0002F71F) (CQScanStreamAggregate::Open+0000003B)
* 004214C4 Module(sqlservr+000214C4) (CQueryScan::Startup+0000010D)
* 0041D505 Module(sqlservr+0001D505) (CStmtQuery::ErsqExecuteQuery+0000026B)
* 00429DFF Module(sqlservr+00029DFF) (CStmtSelect::XretExecute+00000229)
* 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)
* 77BC90A2 Module(MSVCRT+000290A2) (endthread+000000A6)
* 77E4A990 Module(kernel32+0000A990) (FlsSetValue+00000779)
* ----
Hope that helps.
Thanks
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:d7o35194tp3p4ogmv5c2o2cstt9nfc6dhd@.4ax.com...
> No...that's not the reason. Those entries you are looking at
> in Enterprise Manager are for your connection when you are
> checking the locks using Enterprise Manager. What you are
> seeing is normal for what you are doing.
> You would want to post the exact error message and error
> number. You would also want to check the SQL Server error
> log and the event logs on the SQL Server box. If you can
> connect to the database from workstations without using the
> application then it could be something in the application
> itself. You could also run profiler and try a connection
> using the application to see what is going on.
> -Sue
> On Mon, 04 Apr 2005 20:21:54 +0100, Paul Gregory
> <nospam@.nospam.com> wrote:
>>Should also have said I'm using SQL2000 SP3 on Windows Server 2003.
>>Clients are 2000/XP.
>>Paul Gregory wrote:
>> None of my clients can connect to my database. They receive errors about
>> all available connections being used yet there are no connections to
>> the database and there are actually 50 available. This is not an
>> in-house application and as such I have also been in touch with the
>> application developers but need this sorting as soon as possible so
>> thought I would ask here as well.
>> Using the ODBC administrator tests to the database are successful which
>> shows basic level of communication is ok.
>> Using Enterprise Manager on the SQL server gives the following
>> information under Management - Locks/Processes: spid 51. In the right
>> hand pane this has the following info
>> Object:master.dbo.spt_values
>> Lock Type:TAB
>> Mode:Sch-S
>> Status:GRANT
>> Owner:Xact
>> Index:
>> Object:tempdb.dbo.##lockinfo51
>> Lock Type:TAB
>> Mode:X
>> Status:GRANT
>> Owner:Xact
>> Index:##lockinfo51
>> Both resource columns are blank.
>> Both those entries are also listed under Management | Locks/Objects
>> where they have the same information listed. Both have Process ID 51.
>> Is this the reason my database is locked and if so how can I clear this?
>> Any and all info is gratefully received and if you need any more
>> information please ask.
>|||Depends on what you are doing when you get this. An issue
with this which isn't picked up with DBCC Checkdb is fixed
with the latest service pack - SP3a.
-Sue
On Tue, 5 Apr 2005 08:38:53 +0100, "Paul Gregory"
<nospam@.nospam.com> wrote:
>That makes sense - My SQL inexperience shone through brightly there.
>Eventvwr and SQLErrorLog both show the following:-
>2005-04-05 07:57:22.99 spid53 Stack Signature for the dump is 0x3D65CC92
>2005-04-05 07:57:22.99 spid53 SQL Server Assertion: File: <recbase.cpp>,
>line=1378
>Failed Assertion = 'm_offBeginVar < m_SizeRec'.
>2005-04-05 07:57:23.00 spid53 Error: 3624, Severity: 20, State: 1.
>2005-04-05 08:00:45.79 spid54 Using 'xpstar.dll' version '2000.80.760' to
>execute extended stored procedure 'sp_MSgetversion'.
>2005-04-05 08:14:08.03 spid52 Using 'dbghelp.dll' version '4.0.5'
>*Dump thread - spid = 52, PSS = 0x26ddf208, EC = 0x26ddf530
>*Stack Dump being sent to d:\SQLData\MSSQL\log\SQLDump0028.txt
>*
>*******************************************************************************
>*
>* BEGIN STACK DUMP:
>* 04/05/05 08:14:08 spid 52
>*
>*
>*
>* Input Buffer 136 bytes -
>* Select Max(SecondAuditKey) from AUDITTRAIL Where ACUsrAuditKey = 016
>*
>*
>* MODULE BASE END SIZE
>* sqlservr 00400000 00B2CFFF 0072d000
>* ntdll 77F40000 77FF9FFF 000ba000
>* kernel32 77E40000 77F33FFF 000f4000
>* ADVAPI32 77DA0000 77E2FFFF 00090000
>* RPCRT4 77C50000 77CF4FFF 000a5000
>* USER32 77D00000 77D8EFFF 0008f000
>* GDI32 77C00000 77C43FFF 00044000
>* OPENDS60 41060000 41065FFF 00006000
>* MSVCRT 77BA0000 77BF3FFF 00054000
>* UMS 41070000 4107CFFF 0000d000
>* SQLSORT 42AE0000 42B6FFFF 00090000
>* MSVCIRT 60020000 6002FFFF 00010000
>* sqlevn70 41080000 41086FFF 00007000
>* NETAPI32 71C40000 71C92FFF 00053000
>* ole32 77160000 77285FFF 00126000
>* XOLEHLP 01F80000 01F85FFF 00006000
>* MSDTCPRX 61150000 611C1FFF 00072000
>* OLEAUT32 770E0000 7715CFFF 0007d000
>* MSVCP60 780C0000 78120FFF 00061000
>* MTXCLU 74F40000 74F57FFF 00018000
>* VERSION 77B90000 77B97FFF 00008000
>* WSOCK32 71BB0000 71BB8FFF 00009000
>* WS2_32 71C00000 71C17FFF 00018000
>* WS2HELP 71BF0000 71BF7FFF 00008000
>* CLUSAPI 74DE0000 74DF0FFF 00011000
>* RESUTILS 74EF0000 74F01FFF 00012000
>* USERENV 75970000 75A29FFF 000ba000
>* MFC42u 72880000 72973FFF 000f4000
>* secur32 76F50000 76F62FFF 00013000
>* mswsock 71B20000 71B62FFF 00043000
>* DNSAPI 76ED0000 76EF6FFF 00027000
>* winrnr 76F70000 76F76FFF 00007000
>* WLDAP32 76F10000 76F3EFFF 0002f000
>* NWWS2NDS 66210000 66218FFF 00009000
>* NETWIN32 02200000 02246FFF 00047000
>* CLNWIN32 02250000 02264FFF 00015000
>* LOCWIN32 02270000 0228FFFF 00020000
>* NCPWIN32 02290000 022BAFFF 0002b000
>* NWWS2SLP 66220000 6622BFFF 0000c000
>* NWSRVLOC 02300000 02306FFF 00007000
>* rasadhlp 76F80000 76F84FFF 00005000
>* SSNETLIB 00C70000 00C84FFF 00015000
>* SSNMPN70 410D0000 410D5FFF 00006000
>* security 71F60000 71F63FFF 00004000
>* wshtcpip 71AE0000 71AE7FFF 00008000
>* SSmsLPCn 030B0000 030B6FFF 00007000
>* ntdsapi 766F0000 76705FFF 00016000
>* SQLFTQRY 02ED0000 02F01FFF 00032000
>* CLBCatQ 76F90000 7700DFFF 0007e000
>* COMRes 77010000 770D5FFF 000c6000
>* sqloledb 03510000 03595FFF 00086000
>* MSDART 74A50000 74A78FFF 00029000
>* COMCTL32 70BC0000 70C4FFFF 00090000
>* comdlg32 762B0000 762F6FFF 00047000
>* SHLWAPI 77290000 772D8FFF 00049000
>* SHELL32 77380000 77B5EFFF 007df000
>* MSDATL3 61200000 61217FFF 00018000
>* comctl32 70AD0000 70BB5FFF 000e6000
>* oledb32 037A0000 0381CFFF 0007d000
>* OLEDB32R 03010000 03020FFF 00011000
>* rsaenh 0FFD0000 0FFFCFFF 0002d000
>* PSAPI 76B70000 76B7AFFF 0000b000
>* msv1_0 76C90000 76CB3FFF 00024000
>* xpstar 410F0000 41136FFF 00047000
>* SQLRESLD 42AC0000 42AC6FFF 00007000
>* SQLSVC 038A0000 038B6FFF 00017000
>* ODBC32 038C0000 038F9FFF 0003a000
>* odbcbcp 03900000 03905FFF 00006000
>* W95SCM 41140000 4114BFFF 0000c000
>* SQLUNIRL 5BB30000 5BB5CFFF 0002d000
>* WINSPOOL 73070000 73095FFF 00026000
>* SHFOLDER 766D0000 766D8FFF 00009000
>* odbcint 03A10000 03A26FFF 00017000
>* NDDEAPI 75810000 75816FFF 00007000
>* SQLSVC 03A40000 03A45FFF 00006000
>* xpstar 03A50000 03A58FFF 00009000
>* dbghelp 03CA0000 03D54FFF 000b5000
>*
>* Edi: 26DDF530: 26DDF208 24147BB0 26D71808 26D4E288 24147700
>24146030
>* Esi: 00000000:
>* Eax: 00000000:
>* Ebx: 26DDF208: 00000034 00000000 0087AE99 0000962D 00000000
>00000000
>* Ecx: 0348E508: 00000000 0001003F 00000000 00000000 00000000
>00000000
>* Edx: 7FFE0304: 0C819CC3 00010024 90C39D00 90909090 90909090
>90909090
>* Eip: 0087A90E: 4D830088 75FFFFFC 0875FF0C E8E04D8B 0000002D
>64F04D8B
>* Ebp: 0348E4EC: 0348ED0C 0087C41F 26DDF208 0348EE70 0348F0E3
>77BCD86E
>* SegCs: 0000001B:
>* EFlags: 00010246: 00740073 006D0065 00320033 0043003B 005C003A
>00490057
>* Esp: 0348E4C0: 26DDF530 00000000 26DDF208 0348E508 26DDF000
>0348E4C0
>* 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)
>* 007FC8A6 Module(sqlservr+003FC8A6) (RecBase::ReSizeVar+00000069)
>* 00403B44 Module(sqlservr+00003B44) (RecBase::Resize+0000005B)
>* 004079F0 Module(sqlservr+000079F0) (RecBase::IsNull+00000011)
>* 004303D3 Module(sqlservr+000303D3)
>(TCValSSInRow<58,1,1>::GetDataX+00000024)
>* 00425A51 Module(sqlservr+00025A51) (CEs::FastCompare1+00000030)
>* 00406011 Module(sqlservr+00006011) (SDES::GetBiDi+0000062D)
>* 0042A639 Module(sqlservr+0002A639) (RowsetSS::FetchNextRow+0000009B)
>* 0042A4F6 Module(sqlservr+0002A4F6)
>(CQScanRowset::GetRowWithPrefetch+00000040)
>* 0042C21B Module(sqlservr+0002C21B) (CQScanRange::GetRow+000000EF)
>* 0043B405 Module(sqlservr+0003B405)
>(CRowPrefetchDelayMgr::GetRowUnordered+000000DD)
>* 0043B3A0 Module(sqlservr+0003B3A0) (CRowPrefetchDelayMgr::GetRow+0000001B)
>* 006E212E Module(sqlservr+002E212E) (CQScanPreFetchDelay::GetRow+00000014)
>* 0043AF9F Module(sqlservr+0003AF9F) (CQScanFetch::GetRow+00000048)
>* 004301A9 Module(sqlservr+000301A9)
>(CQScanStreamAggregate::GetRow+0000012F)
>* 0042F735 Module(sqlservr+0002F735)
>(CQScanStreamAggregate::GetCalculatedRow+00000011)
>* 0042F71F Module(sqlservr+0002F71F) (CQScanStreamAggregate::Open+0000003B)
>* 004214C4 Module(sqlservr+000214C4) (CQueryScan::Startup+0000010D)
>* 0041D505 Module(sqlservr+0001D505) (CStmtQuery::ErsqExecuteQuery+0000026B)
>* 00429DFF Module(sqlservr+00029DFF) (CStmtSelect::XretExecute+00000229)
>* 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)
>* 77BC90A2 Module(MSVCRT+000290A2) (endthread+000000A6)
>* 77E4A990 Module(kernel32+0000A990) (FlsSetValue+00000779)
>* ----
>Hope that helps.
>Thanks
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:d7o35194tp3p4ogmv5c2o2cstt9nfc6dhd@.4ax.com...
>> No...that's not the reason. Those entries you are looking at
>> in Enterprise Manager are for your connection when you are
>> checking the locks using Enterprise Manager. What you are
>> seeing is normal for what you are doing.
>> You would want to post the exact error message and error
>> number. You would also want to check the SQL Server error
>> log and the event logs on the SQL Server box. If you can
>> connect to the database from workstations without using the
>> application then it could be something in the application
>> itself. You could also run profiler and try a connection
>> using the application to see what is going on.
>> -Sue
>> On Mon, 04 Apr 2005 20:21:54 +0100, Paul Gregory
>> <nospam@.nospam.com> wrote:
>>Should also have said I'm using SQL2000 SP3 on Windows Server 2003.
>>Clients are 2000/XP.
>>Paul Gregory wrote:
>> None of my clients can connect to my database. They receive errors about
>> all available connections being used yet there are no connections to
>> the database and there are actually 50 available. This is not an
>> in-house application and as such I have also been in touch with the
>> application developers but need this sorting as soon as possible so
>> thought I would ask here as well.
>> Using the ODBC administrator tests to the database are successful which
>> shows basic level of communication is ok.
>> Using Enterprise Manager on the SQL server gives the following
>> information under Management - Locks/Processes: spid 51. In the right
>> hand pane this has the following info
>> Object:master.dbo.spt_values
>> Lock Type:TAB
>> Mode:Sch-S
>> Status:GRANT
>> Owner:Xact
>> Index:
>> Object:tempdb.dbo.##lockinfo51
>> Lock Type:TAB
>> Mode:X
>> Status:GRANT
>> Owner:Xact
>> Index:##lockinfo51
>> Both resource columns are blank.
>> Both those entries are also listed under Management | Locks/Objects
>> where they have the same information listed. Both have Process ID 51.
>> Is this the reason my database is locked and if so how can I clear this?
>> Any and all info is gratefully received and if you need any more
>> information please ask.
>|||I backed up the existing DB and restored to a new one. Using dbcc
checkdb repair_rebuild could only fix 4 errors so I then moved on to
repair_allow_data_loss. After running this 4 times there were no errors
however I do realise that the potential is there to have lost data but I
think we are going to have to accept that.
Thanks for your time.
Sue Hoegemeier wrote:
> Depends on what you are doing when you get this. An issue
> with this which isn't picked up with DBCC Checkdb is fixed
> with the latest service pack - SP3a.
> -Sue
> On Tue, 5 Apr 2005 08:38:53 +0100, "Paul Gregory"
> <nospam@.nospam.com> wrote:
>
>>That makes sense - My SQL inexperience shone through brightly there.
>>Eventvwr and SQLErrorLog both show the following:-
>>2005-04-05 07:57:22.99 spid53 Stack Signature for the dump is 0x3D65CC92
>>2005-04-05 07:57:22.99 spid53 SQL Server Assertion: File: <recbase.cpp>,
>>line=1378
>>Failed Assertion = 'm_offBeginVar < m_SizeRec'.
>>2005-04-05 07:57:23.00 spid53 Error: 3624, Severity: 20, State: 1.
>>2005-04-05 08:00:45.79 spid54 Using 'xpstar.dll' version '2000.80.760' to
>>execute extended stored procedure 'sp_MSgetversion'.
>>2005-04-05 08:14:08.03 spid52 Using 'dbghelp.dll' version '4.0.5'
>>*Dump thread - spid = 52, PSS = 0x26ddf208, EC = 0x26ddf530
>>*Stack Dump being sent to d:\SQLData\MSSQL\log\SQLDump0028.txt
>>*
>>*******************************************************************************
>>*
>>* BEGIN STACK DUMP:
>>* 04/05/05 08:14:08 spid 52
>>*
>>*
>>*
>>* Input Buffer 136 bytes -
>>* Select Max(SecondAuditKey) from AUDITTRAIL Where ACUsrAuditKey = 016
>>*
>>*
>>* MODULE BASE END SIZE
>>* sqlservr 00400000 00B2CFFF 0072d000
>>* ntdll 77F40000 77FF9FFF 000ba000
>>* kernel32 77E40000 77F33FFF 000f4000
>>* ADVAPI32 77DA0000 77E2FFFF 00090000
>>* RPCRT4 77C50000 77CF4FFF 000a5000
>>* USER32 77D00000 77D8EFFF 0008f000
>>* GDI32 77C00000 77C43FFF 00044000
>>* OPENDS60 41060000 41065FFF 00006000
>>* MSVCRT 77BA0000 77BF3FFF 00054000
>>* UMS 41070000 4107CFFF 0000d000
>>* SQLSORT 42AE0000 42B6FFFF 00090000
>>* MSVCIRT 60020000 6002FFFF 00010000
>>* sqlevn70 41080000 41086FFF 00007000
>>* NETAPI32 71C40000 71C92FFF 00053000
>>* ole32 77160000 77285FFF 00126000
>>* XOLEHLP 01F80000 01F85FFF 00006000
>>* MSDTCPRX 61150000 611C1FFF 00072000
>>* OLEAUT32 770E0000 7715CFFF 0007d000
>>* MSVCP60 780C0000 78120FFF 00061000
>>* MTXCLU 74F40000 74F57FFF 00018000
>>* VERSION 77B90000 77B97FFF 00008000
>>* WSOCK32 71BB0000 71BB8FFF 00009000
>>* WS2_32 71C00000 71C17FFF 00018000
>>* WS2HELP 71BF0000 71BF7FFF 00008000
>>* CLUSAPI 74DE0000 74DF0FFF 00011000
>>* RESUTILS 74EF0000 74F01FFF 00012000
>>* USERENV 75970000 75A29FFF 000ba000
>>* MFC42u 72880000 72973FFF 000f4000
>>* secur32 76F50000 76F62FFF 00013000
>>* mswsock 71B20000 71B62FFF 00043000
>>* DNSAPI 76ED0000 76EF6FFF 00027000
>>* winrnr 76F70000 76F76FFF 00007000
>>* WLDAP32 76F10000 76F3EFFF 0002f000
>>* NWWS2NDS 66210000 66218FFF 00009000
>>* NETWIN32 02200000 02246FFF 00047000
>>* CLNWIN32 02250000 02264FFF 00015000
>>* LOCWIN32 02270000 0228FFFF 00020000
>>* NCPWIN32 02290000 022BAFFF 0002b000
>>* NWWS2SLP 66220000 6622BFFF 0000c000
>>* NWSRVLOC 02300000 02306FFF 00007000
>>* rasadhlp 76F80000 76F84FFF 00005000
>>* SSNETLIB 00C70000 00C84FFF 00015000
>>* SSNMPN70 410D0000 410D5FFF 00006000
>>* security 71F60000 71F63FFF 00004000
>>* wshtcpip 71AE0000 71AE7FFF 00008000
>>* SSmsLPCn 030B0000 030B6FFF 00007000
>>* ntdsapi 766F0000 76705FFF 00016000
>>* SQLFTQRY 02ED0000 02F01FFF 00032000
>>* CLBCatQ 76F90000 7700DFFF 0007e000
>>* COMRes 77010000 770D5FFF 000c6000
>>* sqloledb 03510000 03595FFF 00086000
>>* MSDART 74A50000 74A78FFF 00029000
>>* COMCTL32 70BC0000 70C4FFFF 00090000
>>* comdlg32 762B0000 762F6FFF 00047000
>>* SHLWAPI 77290000 772D8FFF 00049000
>>* SHELL32 77380000 77B5EFFF 007df000
>>* MSDATL3 61200000 61217FFF 00018000
>>* comctl32 70AD0000 70BB5FFF 000e6000
>>* oledb32 037A0000 0381CFFF 0007d000
>>* OLEDB32R 03010000 03020FFF 00011000
>>* rsaenh 0FFD0000 0FFFCFFF 0002d000
>>* PSAPI 76B70000 76B7AFFF 0000b000
>>* msv1_0 76C90000 76CB3FFF 00024000
>>* xpstar 410F0000 41136FFF 00047000
>>* SQLRESLD 42AC0000 42AC6FFF 00007000
>>* SQLSVC 038A0000 038B6FFF 00017000
>>* ODBC32 038C0000 038F9FFF 0003a000
>>* odbcbcp 03900000 03905FFF 00006000
>>* W95SCM 41140000 4114BFFF 0000c000
>>* SQLUNIRL 5BB30000 5BB5CFFF 0002d000
>>* WINSPOOL 73070000 73095FFF 00026000
>>* SHFOLDER 766D0000 766D8FFF 00009000
>>* odbcint 03A10000 03A26FFF 00017000
>>* NDDEAPI 75810000 75816FFF 00007000
>>* SQLSVC 03A40000 03A45FFF 00006000
>>* xpstar 03A50000 03A58FFF 00009000
>>* dbghelp 03CA0000 03D54FFF 000b5000
>>*
>>* Edi: 26DDF530: 26DDF208 24147BB0 26D71808 26D4E288 24147700
>>24146030
>>* Esi: 00000000:
>>* Eax: 00000000:
>>* Ebx: 26DDF208: 00000034 00000000 0087AE99 0000962D 00000000
>>00000000
>>* Ecx: 0348E508: 00000000 0001003F 00000000 00000000 00000000
>>00000000
>>* Edx: 7FFE0304: 0C819CC3 00010024 90C39D00 90909090 90909090
>>90909090
>>* Eip: 0087A90E: 4D830088 75FFFFFC 0875FF0C E8E04D8B 0000002D
>>64F04D8B
>>* Ebp: 0348E4EC: 0348ED0C 0087C41F 26DDF208 0348EE70 0348F0E3
>>77BCD86E
>>* SegCs: 0000001B:
>>* EFlags: 00010246: 00740073 006D0065 00320033 0043003B 005C003A
>>00490057
>>* Esp: 0348E4C0: 26DDF530 00000000 26DDF208 0348E508 26DDF000
>>0348E4C0
>>* 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)
>>* 007FC8A6 Module(sqlservr+003FC8A6) (RecBase::ReSizeVar+00000069)
>>* 00403B44 Module(sqlservr+00003B44) (RecBase::Resize+0000005B)
>>* 004079F0 Module(sqlservr+000079F0) (RecBase::IsNull+00000011)
>>* 004303D3 Module(sqlservr+000303D3)
>>(TCValSSInRow<58,1,1>::GetDataX+00000024)
>>* 00425A51 Module(sqlservr+00025A51) (CEs::FastCompare1+00000030)
>>* 00406011 Module(sqlservr+00006011) (SDES::GetBiDi+0000062D)
>>* 0042A639 Module(sqlservr+0002A639) (RowsetSS::FetchNextRow+0000009B)
>>* 0042A4F6 Module(sqlservr+0002A4F6)
>>(CQScanRowset::GetRowWithPrefetch+00000040)
>>* 0042C21B Module(sqlservr+0002C21B) (CQScanRange::GetRow+000000EF)
>>* 0043B405 Module(sqlservr+0003B405)
>>(CRowPrefetchDelayMgr::GetRowUnordered+000000DD)
>>* 0043B3A0 Module(sqlservr+0003B3A0) (CRowPrefetchDelayMgr::GetRow+0000001B)
>>* 006E212E Module(sqlservr+002E212E) (CQScanPreFetchDelay::GetRow+00000014)
>>* 0043AF9F Module(sqlservr+0003AF9F) (CQScanFetch::GetRow+00000048)
>>* 004301A9 Module(sqlservr+000301A9)
>>(CQScanStreamAggregate::GetRow+0000012F)
>>* 0042F735 Module(sqlservr+0002F735)
>>(CQScanStreamAggregate::GetCalculatedRow+00000011)
>>* 0042F71F Module(sqlservr+0002F71F) (CQScanStreamAggregate::Open+0000003B)
>>* 004214C4 Module(sqlservr+000214C4) (CQueryScan::Startup+0000010D)
>>* 0041D505 Module(sqlservr+0001D505) (CStmtQuery::ErsqExecuteQuery+0000026B)
>>* 00429DFF Module(sqlservr+00029DFF) (CStmtSelect::XretExecute+00000229)
>>* 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)
>>* 77BC90A2 Module(MSVCRT+000290A2) (endthread+000000A6)
>>* 77E4A990 Module(kernel32+0000A990) (FlsSetValue+00000779)
>>* ----
>>Hope that helps.
>>Thanks
>>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>>news:d7o35194tp3p4ogmv5c2o2cstt9nfc6dhd@.4ax.com...
>>No...that's not the reason. Those entries you are looking at
>>in Enterprise Manager are for your connection when you are
>>checking the locks using Enterprise Manager. What you are
>>seeing is normal for what you are doing.
>>You would want to post the exact error message and error
>>number. You would also want to check the SQL Server error
>>log and the event logs on the SQL Server box. If you can
>>connect to the database from workstations without using the
>>application then it could be something in the application
>>itself. You could also run profiler and try a connection
>>using the application to see what is going on.
>>-Sue
>>On Mon, 04 Apr 2005 20:21:54 +0100, Paul Gregory
>><nospam@.nospam.com> wrote:
>>
>>Should also have said I'm using SQL2000 SP3 on Windows Server 2003.
>>Clients are 2000/XP.
>>Paul Gregory wrote:
>>None of my clients can connect to my database. They receive errors about
>> all available connections being used yet there are no connections to
>>the database and there are actually 50 available. This is not an
>>in-house application and as such I have also been in touch with the
>>application developers but need this sorting as soon as possible so
>>thought I would ask here as well.
>>Using the ODBC administrator tests to the database are successful which
>>shows basic level of communication is ok.
>>Using Enterprise Manager on the SQL server gives the following
>>information under Management - Locks/Processes: spid 51. In the right
>>hand pane this has the following info
>>Object:master.dbo.spt_values
>>Lock Type:TAB
>>Mode:Sch-S
>>Status:GRANT
>>Owner:Xact
>>Index:
>>Object:tempdb.dbo.##lockinfo51
>>Lock Type:TAB
>>Mode:X
>>Status:GRANT
>>Owner:Xact
>>Index:##lockinfo51
>>Both resource columns are blank.
>>Both those entries are also listed under Management | Locks/Objects
>>where they have the same information listed. Both have Process ID 51.
>>Is this the reason my database is locked and if so how can I clear this?
>>Any and all info is gratefully received and if you need any more
>>information please ask.
>|||Hi
Once you have completed the DBCC, create a new DB (that will become your DB
you will use in the future), and copy all objects (data, tables etc) over
into this new DB.
Once a DB had corruption, I never trust it 100% again. Rather get all the
data out into a "clean" DB.
Just a recommendation.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Paul Gregory" <nospam@.nospam.com> wrote in message
news:u3sihlhOFHA.2680@.TK2MSFTNGP09.phx.gbl...
>I backed up the existing DB and restored to a new one. Using dbcc checkdb
>repair_rebuild could only fix 4 errors so I then moved on to
>repair_allow_data_loss. After running this 4 times there were no errors
>however I do realise that the potential is there to have lost data but I
>think we are going to have to accept that.
> Thanks for your time.
> Sue Hoegemeier wrote:
>> Depends on what you are doing when you get this. An issue
>> with this which isn't picked up with DBCC Checkdb is fixed
>> with the latest service pack - SP3a.
>> -Sue
>> On Tue, 5 Apr 2005 08:38:53 +0100, "Paul Gregory"
>> <nospam@.nospam.com> wrote:
>>
>>That makes sense - My SQL inexperience shone through brightly there.
>>Eventvwr and SQLErrorLog both show the following:-
>>2005-04-05 07:57:22.99 spid53 Stack Signature for the dump is
>>0x3D65CC92
>>2005-04-05 07:57:22.99 spid53 SQL Server Assertion: File:
>><recbase.cpp>, line=1378
>>Failed Assertion = 'm_offBeginVar < m_SizeRec'.
>>2005-04-05 07:57:23.00 spid53 Error: 3624, Severity: 20, State: 1.
>>2005-04-05 08:00:45.79 spid54 Using 'xpstar.dll' version '2000.80.760'
>>to execute extended stored procedure 'sp_MSgetversion'.
>>2005-04-05 08:14:08.03 spid52 Using 'dbghelp.dll' version '4.0.5'
>>*Dump thread - spid = 52, PSS = 0x26ddf208, EC = 0x26ddf530
>>*Stack Dump being sent to d:\SQLData\MSSQL\log\SQLDump0028.txt
>>*
>>*******************************************************************************
>>*
>>* BEGIN STACK DUMP:
>>* 04/05/05 08:14:08 spid 52
>>*
>>*
>>*
>>* Input Buffer 136 bytes -
>>* Select Max(SecondAuditKey) from AUDITTRAIL Where ACUsrAuditKey = 016
>>*
>>*
>>* MODULE BASE END SIZE
>>* sqlservr 00400000 00B2CFFF 0072d000
>>* ntdll 77F40000 77FF9FFF 000ba000
>>* kernel32 77E40000 77F33FFF 000f4000
>>* ADVAPI32 77DA0000 77E2FFFF 00090000
>>* RPCRT4 77C50000 77CF4FFF 000a5000
>>* USER32 77D00000 77D8EFFF 0008f000
>>* GDI32 77C00000 77C43FFF 00044000
>>* OPENDS60 41060000 41065FFF 00006000
>>* MSVCRT 77BA0000 77BF3FFF 00054000
>>* UMS 41070000 4107CFFF 0000d000
>>* SQLSORT 42AE0000 42B6FFFF 00090000
>>* MSVCIRT 60020000 6002FFFF 00010000
>>* sqlevn70 41080000 41086FFF 00007000
>>* NETAPI32 71C40000 71C92FFF 00053000
>>* ole32 77160000 77285FFF 00126000
>>* XOLEHLP 01F80000 01F85FFF 00006000
>>* MSDTCPRX 61150000 611C1FFF 00072000
>>* OLEAUT32 770E0000 7715CFFF 0007d000
>>* MSVCP60 780C0000 78120FFF 00061000
>>* MTXCLU 74F40000 74F57FFF 00018000
>>* VERSION 77B90000 77B97FFF 00008000
>>* WSOCK32 71BB0000 71BB8FFF 00009000
>>* WS2_32 71C00000 71C17FFF 00018000
>>* WS2HELP 71BF0000 71BF7FFF 00008000
>>* CLUSAPI 74DE0000 74DF0FFF 00011000
>>* RESUTILS 74EF0000 74F01FFF 00012000
>>* USERENV 75970000 75A29FFF 000ba000
>>* MFC42u 72880000 72973FFF 000f4000
>>* secur32 76F50000 76F62FFF 00013000
>>* mswsock 71B20000 71B62FFF 00043000
>>* DNSAPI 76ED0000 76EF6FFF 00027000
>>* winrnr 76F70000 76F76FFF 00007000
>>* WLDAP32 76F10000 76F3EFFF 0002f000
>>* NWWS2NDS 66210000 66218FFF 00009000
>>* NETWIN32 02200000 02246FFF 00047000
>>* CLNWIN32 02250000 02264FFF 00015000
>>* LOCWIN32 02270000 0228FFFF 00020000
>>* NCPWIN32 02290000 022BAFFF 0002b000
>>* NWWS2SLP 66220000 6622BFFF 0000c000
>>* NWSRVLOC 02300000 02306FFF 00007000
>>* rasadhlp 76F80000 76F84FFF 00005000
>>* SSNETLIB 00C70000 00C84FFF 00015000
>>* SSNMPN70 410D0000 410D5FFF 00006000
>>* security 71F60000 71F63FFF 00004000
>>* wshtcpip 71AE0000 71AE7FFF 00008000
>>* SSmsLPCn 030B0000 030B6FFF 00007000
>>* ntdsapi 766F0000 76705FFF 00016000
>>* SQLFTQRY 02ED0000 02F01FFF 00032000
>>* CLBCatQ 76F90000 7700DFFF 0007e000
>>* COMRes 77010000 770D5FFF 000c6000
>>* sqloledb 03510000 03595FFF 00086000
>>* MSDART 74A50000 74A78FFF 00029000
>>* COMCTL32 70BC0000 70C4FFFF 00090000
>>* comdlg32 762B0000 762F6FFF 00047000
>>* SHLWAPI 77290000 772D8FFF 00049000
>>* SHELL32 77380000 77B5EFFF 007df000
>>* MSDATL3 61200000 61217FFF 00018000
>>* comctl32 70AD0000 70BB5FFF 000e6000
>>* oledb32 037A0000 0381CFFF 0007d000
>>* OLEDB32R 03010000 03020FFF 00011000
>>* rsaenh 0FFD0000 0FFFCFFF 0002d000
>>* PSAPI 76B70000 76B7AFFF 0000b000
>>* msv1_0 76C90000 76CB3FFF 00024000
>>* xpstar 410F0000 41136FFF 00047000
>>* SQLRESLD 42AC0000 42AC6FFF 00007000
>>* SQLSVC 038A0000 038B6FFF 00017000
>>* ODBC32 038C0000 038F9FFF 0003a000
>>* odbcbcp 03900000 03905FFF 00006000
>>* W95SCM 41140000 4114BFFF 0000c000
>>* SQLUNIRL 5BB30000 5BB5CFFF 0002d000
>>* WINSPOOL 73070000 73095FFF 00026000
>>* SHFOLDER 766D0000 766D8FFF 00009000
>>* odbcint 03A10000 03A26FFF 00017000
>>* NDDEAPI 75810000 75816FFF 00007000
>>* SQLSVC 03A40000 03A45FFF 00006000
>>* xpstar 03A50000 03A58FFF 00009000
>>* dbghelp 03CA0000 03D54FFF 000b5000
>>*
>>* Edi: 26DDF530: 26DDF208 24147BB0 26D71808 26D4E288 24147700
>>24146030
>>* Esi: 00000000:
>>* Eax: 00000000:
>>* Ebx: 26DDF208: 00000034 00000000 0087AE99 0000962D 00000000
>>00000000
>>* Ecx: 0348E508: 00000000 0001003F 00000000 00000000 00000000
>>00000000
>>* Edx: 7FFE0304: 0C819CC3 00010024 90C39D00 90909090 90909090
>>90909090
>>* Eip: 0087A90E: 4D830088 75FFFFFC 0875FF0C E8E04D8B 0000002D
>>64F04D8B
>>* Ebp: 0348E4EC: 0348ED0C 0087C41F 26DDF208 0348EE70 0348F0E3
>>77BCD86E
>>* SegCs: 0000001B:
>>* EFlags: 00010246: 00740073 006D0065 00320033 0043003B 005C003A
>>00490057
>>* Esp: 0348E4C0: 26DDF530 00000000 26DDF208 0348E508 26DDF000
>>0348E4C0
>>* 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)
>>* 007FC8A6 Module(sqlservr+003FC8A6) (RecBase::ReSizeVar+00000069)
>>* 00403B44 Module(sqlservr+00003B44) (RecBase::Resize+0000005B)
>>* 004079F0 Module(sqlservr+000079F0) (RecBase::IsNull+00000011)
>>* 004303D3 Module(sqlservr+000303D3)
>>(TCValSSInRow<58,1,1>::GetDataX+00000024)
>>* 00425A51 Module(sqlservr+00025A51) (CEs::FastCompare1+00000030)
>>* 00406011 Module(sqlservr+00006011) (SDES::GetBiDi+0000062D)
>>* 0042A639 Module(sqlservr+0002A639) (RowsetSS::FetchNextRow+0000009B)
>>* 0042A4F6 Module(sqlservr+0002A4F6)
>>(CQScanRowset::GetRowWithPrefetch+00000040)
>>* 0042C21B Module(sqlservr+0002C21B) (CQScanRange::GetRow+000000EF)
>>* 0043B405 Module(sqlservr+0003B405)
>>(CRowPrefetchDelayMgr::GetRowUnordered+000000DD)
>>* 0043B3A0 Module(sqlservr+0003B3A0)
>>(CRowPrefetchDelayMgr::GetRow+0000001B)
>>* 006E212E Module(sqlservr+002E212E)
>>(CQScanPreFetchDelay::GetRow+00000014)
>>* 0043AF9F Module(sqlservr+0003AF9F) (CQScanFetch::GetRow+00000048)
>>* 004301A9 Module(sqlservr+000301A9)
>>(CQScanStreamAggregate::GetRow+0000012F)
>>* 0042F735 Module(sqlservr+0002F735)
>>(CQScanStreamAggregate::GetCalculatedRow+00000011)
>>* 0042F71F Module(sqlservr+0002F71F)
>>(CQScanStreamAggregate::Open+0000003B)
>>* 004214C4 Module(sqlservr+000214C4) (CQueryScan::Startup+0000010D)
>>* 0041D505 Module(sqlservr+0001D505)
>>(CStmtQuery::ErsqExecuteQuery+0000026B)
>>* 00429DFF Module(sqlservr+00029DFF) (CStmtSelect::XretExecute+00000229)
>>* 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)
>>* 77BC90A2 Module(MSVCRT+000290A2) (endthread+000000A6)
>>* 77E4A990 Module(kernel32+0000A990) (FlsSetValue+00000779)
>>* ----
>>Hope that helps.
>>Thanks
>>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>>news:d7o35194tp3p4ogmv5c2o2cstt9nfc6dhd@.4ax.com...
>>No...that's not the reason. Those entries you are looking at
>>in Enterprise Manager are for your connection when you are
>>checking the locks using Enterprise Manager. What you are
>>seeing is normal for what you are doing.
>>You would want to post the exact error message and error
>>number. You would also want to check the SQL Server error
>>log and the event logs on the SQL Server box. If you can
>>connect to the database from workstations without using the
>>application then it could be something in the application
>>itself. You could also run profiler and try a connection
>>using the application to see what is going on.
>>-Sue
>>On Mon, 04 Apr 2005 20:21:54 +0100, Paul Gregory
>><nospam@.nospam.com> wrote:
>>
>>Should also have said I'm using SQL2000 SP3 on Windows Server 2003.
>>Clients are 2000/XP.
>>Paul Gregory wrote:
>>None of my clients can connect to my database. They receive errors
>>about
>> all available connections being used yet there are no connections to
>>the database and there are actually 50 available. This is not an
>>in-house application and as such I have also been in touch with the
>>application developers but need this sorting as soon as possible so
>>thought I would ask here as well.
>>Using the ODBC administrator tests to the database are successful
>>which
>>shows basic level of communication is ok.
>>Using Enterprise Manager on the SQL server gives the following
>>information under Management - Locks/Processes: spid 51. In the right
>>hand pane this has the following info
>>Object:master.dbo.spt_values
>>Lock Type:TAB
>>Mode:Sch-S
>>Status:GRANT
>>Owner:Xact
>>Index:
>>Object:tempdb.dbo.##lockinfo51
>>Lock Type:TAB
>>Mode:X
>>Status:GRANT
>>Owner:Xact
>>Index:##lockinfo51
>>Both resource columns are blank.
>>Both those entries are also listed under Management | Locks/Objects
>>where they have the same information listed. Both have Process ID 51.
>>Is this the reason my database is locked and if so how can I clear
>>this?
>>Any and all info is gratefully received and if you need any more
>>information please ask.
>>|||That was always the plan but thanks for your input.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:OnhoQ1iOFHA.2568@.TK2MSFTNGP14.phx.gbl...
> Hi
> Once you have completed the DBCC, create a new DB (that will become your
> DB you will use in the future), and copy all objects (data, tables etc)
> over into this new DB.
> Once a DB had corruption, I never trust it 100% again. Rather get all the
> data out into a "clean" DB.
> Just a recommendation.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Paul Gregory" <nospam@.nospam.com> wrote in message
> news:u3sihlhOFHA.2680@.TK2MSFTNGP09.phx.gbl...
>>I backed up the existing DB and restored to a new one. Using dbcc checkdb
>>repair_rebuild could only fix 4 errors so I then moved on to
>>repair_allow_data_loss. After running this 4 times there were no errors
>>however I do realise that the potential is there to have lost data but I
>>think we are going to have to accept that.
>> Thanks for your time.
>> Sue Hoegemeier wrote:
>> Depends on what you are doing when you get this. An issue
>> with this which isn't picked up with DBCC Checkdb is fixed
>> with the latest service pack - SP3a.
>> -Sue
>> On Tue, 5 Apr 2005 08:38:53 +0100, "Paul Gregory"
>> <nospam@.nospam.com> wrote:
>>
>>That makes sense - My SQL inexperience shone through brightly there.
>>Eventvwr and SQLErrorLog both show the following:-
>>2005-04-05 07:57:22.99 spid53 Stack Signature for the dump is
>>0x3D65CC92
>>2005-04-05 07:57:22.99 spid53 SQL Server Assertion: File:
>><recbase.cpp>, line=1378
>>Failed Assertion = 'm_offBeginVar < m_SizeRec'.
>>2005-04-05 07:57:23.00 spid53 Error: 3624, Severity: 20, State: 1.
>>2005-04-05 08:00:45.79 spid54 Using 'xpstar.dll' version
>>'2000.80.760' to execute extended stored procedure 'sp_MSgetversion'.
>>2005-04-05 08:14:08.03 spid52 Using 'dbghelp.dll' version '4.0.5'
>>*Dump thread - spid = 52, PSS = 0x26ddf208, EC = 0x26ddf530
>>*Stack Dump being sent to d:\SQLData\MSSQL\log\SQLDump0028.txt
>>*
>>*******************************************************************************
>>*
>>* BEGIN STACK DUMP:
>>* 04/05/05 08:14:08 spid 52
>>*
>>*
>>*
>>* Input Buffer 136 bytes -
>>* Select Max(SecondAuditKey) from AUDITTRAIL Where ACUsrAuditKey = 016
>>*
>>*
>>* MODULE BASE END SIZE
>>* sqlservr 00400000 00B2CFFF 0072d000
>>* ntdll 77F40000 77FF9FFF 000ba000
>>* kernel32 77E40000 77F33FFF 000f4000
>>* ADVAPI32 77DA0000 77E2FFFF 00090000
>>* RPCRT4 77C50000 77CF4FFF 000a5000
>>* USER32 77D00000 77D8EFFF 0008f000
>>* GDI32 77C00000 77C43FFF 00044000
>>* OPENDS60 41060000 41065FFF 00006000
>>* MSVCRT 77BA0000 77BF3FFF 00054000
>>* UMS 41070000 4107CFFF 0000d000
>>* SQLSORT 42AE0000 42B6FFFF 00090000
>>* MSVCIRT 60020000 6002FFFF 00010000
>>* sqlevn70 41080000 41086FFF 00007000
>>* NETAPI32 71C40000 71C92FFF 00053000
>>* ole32 77160000 77285FFF 00126000
>>* XOLEHLP 01F80000 01F85FFF 00006000
>>* MSDTCPRX 61150000 611C1FFF 00072000
>>* OLEAUT32 770E0000 7715CFFF 0007d000
>>* MSVCP60 780C0000 78120FFF 00061000
>>* MTXCLU 74F40000 74F57FFF 00018000
>>* VERSION 77B90000 77B97FFF 00008000
>>* WSOCK32 71BB0000 71BB8FFF 00009000
>>* WS2_32 71C00000 71C17FFF 00018000
>>* WS2HELP 71BF0000 71BF7FFF 00008000
>>* CLUSAPI 74DE0000 74DF0FFF 00011000
>>* RESUTILS 74EF0000 74F01FFF 00012000
>>* USERENV 75970000 75A29FFF 000ba000
>>* MFC42u 72880000 72973FFF 000f4000
>>* secur32 76F50000 76F62FFF 00013000
>>* mswsock 71B20000 71B62FFF 00043000
>>* DNSAPI 76ED0000 76EF6FFF 00027000
>>* winrnr 76F70000 76F76FFF 00007000
>>* WLDAP32 76F10000 76F3EFFF 0002f000
>>* NWWS2NDS 66210000 66218FFF 00009000
>>* NETWIN32 02200000 02246FFF 00047000
>>* CLNWIN32 02250000 02264FFF 00015000
>>* LOCWIN32 02270000 0228FFFF 00020000
>>* NCPWIN32 02290000 022BAFFF 0002b000
>>* NWWS2SLP 66220000 6622BFFF 0000c000
>>* NWSRVLOC 02300000 02306FFF 00007000
>>* rasadhlp 76F80000 76F84FFF 00005000
>>* SSNETLIB 00C70000 00C84FFF 00015000
>>* SSNMPN70 410D0000 410D5FFF 00006000
>>* security 71F60000 71F63FFF 00004000
>>* wshtcpip 71AE0000 71AE7FFF 00008000
>>* SSmsLPCn 030B0000 030B6FFF 00007000
>>* ntdsapi 766F0000 76705FFF 00016000
>>* SQLFTQRY 02ED0000 02F01FFF 00032000
>>* CLBCatQ 76F90000 7700DFFF 0007e000
>>* COMRes 77010000 770D5FFF 000c6000
>>* sqloledb 03510000 03595FFF 00086000
>>* MSDART 74A50000 74A78FFF 00029000
>>* COMCTL32 70BC0000 70C4FFFF 00090000
>>* comdlg32 762B0000 762F6FFF 00047000
>>* SHLWAPI 77290000 772D8FFF 00049000
>>* SHELL32 77380000 77B5EFFF 007df000
>>* MSDATL3 61200000 61217FFF 00018000
>>* comctl32 70AD0000 70BB5FFF 000e6000
>>* oledb32 037A0000 0381CFFF 0007d000
>>* OLEDB32R 03010000 03020FFF 00011000
>>* rsaenh 0FFD0000 0FFFCFFF 0002d000
>>* PSAPI 76B70000 76B7AFFF 0000b000
>>* msv1_0 76C90000 76CB3FFF 00024000
>>* xpstar 410F0000 41136FFF 00047000
>>* SQLRESLD 42AC0000 42AC6FFF 00007000
>>* SQLSVC 038A0000 038B6FFF 00017000
>>* ODBC32 038C0000 038F9FFF 0003a000
>>* odbcbcp 03900000 03905FFF 00006000
>>* W95SCM 41140000 4114BFFF 0000c000
>>* SQLUNIRL 5BB30000 5BB5CFFF 0002d000
>>* WINSPOOL 73070000 73095FFF 00026000
>>* SHFOLDER 766D0000 766D8FFF 00009000
>>* odbcint 03A10000 03A26FFF 00017000
>>* NDDEAPI 75810000 75816FFF 00007000
>>* SQLSVC 03A40000 03A45FFF 00006000
>>* xpstar 03A50000 03A58FFF 00009000
>>* dbghelp 03CA0000 03D54FFF 000b5000
>>*
>>* Edi: 26DDF530: 26DDF208 24147BB0 26D71808 26D4E288 24147700
>>24146030
>>* Esi: 00000000:
>>* Eax: 00000000:
>>* Ebx: 26DDF208: 00000034 00000000 0087AE99 0000962D 00000000
>>00000000
>>* Ecx: 0348E508: 00000000 0001003F 00000000 00000000 00000000
>>00000000
>>* Edx: 7FFE0304: 0C819CC3 00010024 90C39D00 90909090 90909090
>>90909090
>>* Eip: 0087A90E: 4D830088 75FFFFFC 0875FF0C E8E04D8B 0000002D
>>64F04D8B
>>* Ebp: 0348E4EC: 0348ED0C 0087C41F 26DDF208 0348EE70 0348F0E3
>>77BCD86E
>>* SegCs: 0000001B:
>>* EFlags: 00010246: 00740073 006D0065 00320033 0043003B 005C003A
>>00490057
>>* Esp: 0348E4C0: 26DDF530 00000000 26DDF208 0348E508 26DDF000
>>0348E4C0
>>* 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)
>>* 007FC8A6 Module(sqlservr+003FC8A6) (RecBase::ReSizeVar+00000069)
>>* 00403B44 Module(sqlservr+00003B44) (RecBase::Resize+0000005B)
>>* 004079F0 Module(sqlservr+000079F0) (RecBase::IsNull+00000011)
>>* 004303D3 Module(sqlservr+000303D3)
>>(TCValSSInRow<58,1,1>::GetDataX+00000024)
>>* 00425A51 Module(sqlservr+00025A51) (CEs::FastCompare1+00000030)
>>* 00406011 Module(sqlservr+00006011) (SDES::GetBiDi+0000062D)
>>* 0042A639 Module(sqlservr+0002A639) (RowsetSS::FetchNextRow+0000009B)
>>* 0042A4F6 Module(sqlservr+0002A4F6)
>>(CQScanRowset::GetRowWithPrefetch+00000040)
>>* 0042C21B Module(sqlservr+0002C21B) (CQScanRange::GetRow+000000EF)
>>* 0043B405 Module(sqlservr+0003B405)
>>(CRowPrefetchDelayMgr::GetRowUnordered+000000DD)
>>* 0043B3A0 Module(sqlservr+0003B3A0)
>>(CRowPrefetchDelayMgr::GetRow+0000001B)
>>* 006E212E Module(sqlservr+002E212E)
>>(CQScanPreFetchDelay::GetRow+00000014)
>>* 0043AF9F Module(sqlservr+0003AF9F) (CQScanFetch::GetRow+00000048)
>>* 004301A9 Module(sqlservr+000301A9)
>>(CQScanStreamAggregate::GetRow+0000012F)
>>* 0042F735 Module(sqlservr+0002F735)
>>(CQScanStreamAggregate::GetCalculatedRow+00000011)
>>* 0042F71F Module(sqlservr+0002F71F)
>>(CQScanStreamAggregate::Open+0000003B)
>>* 004214C4 Module(sqlservr+000214C4) (CQueryScan::Startup+0000010D)
>>* 0041D505 Module(sqlservr+0001D505)
>>(CStmtQuery::ErsqExecuteQuery+0000026B)
>>* 00429DFF Module(sqlservr+00029DFF) (CStmtSelect::XretExecute+00000229)
>>* 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)
>>* 77BC90A2 Module(MSVCRT+000290A2) (endthread+000000A6)
>>* 77E4A990 Module(kernel32+0000A990) (FlsSetValue+00000779)
>>* ----
>>Hope that helps.
>>Thanks
>>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>>news:d7o35194tp3p4ogmv5c2o2cstt9nfc6dhd@.4ax.com...
>>No...that's not the reason. Those entries you are looking at
>>in Enterprise Manager are for your connection when you are
>>checking the locks using Enterprise Manager. What you are
>>seeing is normal for what you are doing.
>>You would want to post the exact error message and error
>>number. You would also want to check the SQL Server error
>>log and the event logs on the SQL Server box. If you can
>>connect to the database from workstations without using the
>>application then it could be something in the application
>>itself. You could also run profiler and try a connection
>>using the application to see what is going on.
>>-Sue
>>On Mon, 04 Apr 2005 20:21:54 +0100, Paul Gregory
>><nospam@.nospam.com> wrote:
>>
>>Should also have said I'm using SQL2000 SP3 on Windows Server 2003.
>>Clients are 2000/XP.
>>Paul Gregory wrote:
>>>None of my clients can connect to my database. They receive errors
>>>about
>>> all available connections being used yet there are no connections to
>>>the database and there are actually 50 available. This is not an
>>>in-house application and as such I have also been in touch with the
>>>application developers but need this sorting as soon as possible so
>>>thought I would ask here as well.
>>>
>>>Using the ODBC administrator tests to the database are successful
>>>which
>>>shows basic level of communication is ok.
>>>
>>>Using Enterprise Manager on the SQL server gives the following
>>>information under Management - Locks/Processes: spid 51. In the right
>>>hand pane this has the following info
>>>
>>>Object:master.dbo.spt_values
>>>Lock Type:TAB
>>>Mode:Sch-S
>>>Status:GRANT
>>>Owner:Xact
>>>Index:
>>>
>>>Object:tempdb.dbo.##lockinfo51
>>>Lock Type:TAB
>>>Mode:X
>>>Status:GRANT
>>>Owner:Xact
>>>Index:##lockinfo51
>>>
>>>Both resource columns are blank.
>>>
>>>Both those entries are also listed under Management | Locks/Objects
>>>where they have the same information listed. Both have Process ID 51.
>>>
>>>Is this the reason my database is locked and if so how can I clear
>>>this?
>>>
>>>Any and all info is gratefully received and if you need any more
>>>information please ask.
>>
>