Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-06-20 : 09:41:44
|
| jack_low writes "window 2000 serverSQL server 2000service pack 2I have an error message in sql server 2000 and it has cause the sql server stop responding and i need to reboot the server whenever it happen . See below * BEGIN STACK DUMP: * 06/15/06 10:25:56 spid 156 * * Exception Address = 00403431 (lck_lock(class LockRequest const &,class LockRes const &,class LockInfo *) + 0000008D Line 0+00000000) * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION * Access Violation occurred reading address 20202028 * Input Buffer 370 bytes - * SELECT * FROM INVMAS WHERE SGLOT1 = 'Z' and SGLOT2 = 'PO' and SGLOT3 = ' * 6' and SGLOT4 = '05' and SGLOT5 = '9351' and SGLOT6 = '' and SG = '1 * ' and CHOP = 'SZ0697' and SGWTH = '67' -------------------------------------------------------------------------------Short Stack Dump 00403431 Module(sqlservr+00003431) (lck_lock(class LockRequest const &,class LockRes const &,class LockInfo *)+0000008D) 0040325E Module(sqlservr+0000325E) (SDES::GetLock(class LockRes const &,enum LCK_MODE,enum ERROR_CONTROL,int,int,int,class LockInfo *)+000001AB) 00408074 Module(sqlservr+00008074) (SDES::AcquireRowLockForScan(struct BUF *,int,class LockRes &,int &,int &,int)+0000017B) " |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2006-06-20 : 12:02:14
|
| This is a bug. I checked our internal database and don't see anything with this signature that was fixed in SP3 or SP4. Please contact Product Support to assist you. Tell them to contact Paul Randal in the SQL Server team in Redmond for more info.ThanksPaul RandalLead Program Manager, Microsoft SQL Server Storage Engine + SQL Express(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
 |
|
|
|
|
|
|
|
EXCEPTION_ACCESS_VIOLATION