SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Stack dump error and SQL service gets restarted


Stack dump error and SQL service gets restarted

Author
Message
ebenraja
ebenraja
SSC-Enthusiastic
SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)

Group: General Forum Members
Points: 196 Visits: 258
All,

I am using a SQL7.0 version server and recently for the past 1 week my SQL related services goes for a restart early morning at the same time daily.

When i verified my Error log i was able to find the following 'Stack dump' listed below.

The service pack for the SQL7.0 version is SP4 and i am not sure if this is related with the application..is it memory related ..please help me with this


--------------------------------------------------------------------------------------------------------------------------------------------------


2009-05-25 03:22:57.53 spid21 Using 'sqlimage.dll' version '4.0.5'

Dump thread - spid = 21, PSS = 0x4a0df100, EC = 0x4a0df2b0

Stack Dump being sent to F:\MSSQL7\log\SQL00199.dmp

*******************************************************************************

*

* BEGIN STACK DUMP:

* 05/25/09 03:22:58 spid 21

*

* Input Buffer 3080 bytes -

* S E T L O C K _ T I M E O U T 2 0 0 0 0 S E T I M P L I C I T _

* T R A N S A C T I O N S O F F i f @ @ T R A N C O U N T > 0

* C O M M I T T R A N S A C T I O N

* S E T L a n g u a g e u s _ e n g l i s h

* S E T A N S I _ W A R N I N G S O F F

* S E T C U R S O R _ C L O S E _ O N _ C O M M I T O F F

* S E T Q U E R Y _ G O V E R N O R _ C O S T _ L I M I T 0

* S E T T R A N S A C T I O N I S O L A T I O N L E V E L R E A D

* U N C O M M I T T E D

* s e t n o c o u n t o n

* s e t d a t e f i r s t 1 i f ( s e l e c t c o u n t ( * )

* f r o m # T a b l e D e t a i l s ) > 0 a n d ( s e l e c t

* d a t e p a r t ( d w , g e t d a t e ( ) ) ) i n ( 0 , 1 , 2 , 3 ,

* 4 , 5 , 6 , 7 ) b e g i n d e c l a r e @ c o m m a n d v a r c

* h a r ( 2 0 4 8 ) , @ d b n a m e v a r c h a r ( 2 5 5 ) , @ m o

* d e s m a l l i n t , @ d b i d s m a l l i n t , @ t a b l e i

* d i n t d e c l a r e R e o r g C u r s o r i n s e n s i t i v

* e c u r s o r f o r s e l e c t t . D B N a m e , t . D B I D

* , t . T a b l e I D f r o m # T a b l e D e t a i l s t ( n o

* l o c k ) w h e r e l o w e r ( t . D B N a m e ) n o t i n (

* ' # $ 0 ' , ' m a s t e r ' , ' m o d e l ' , ' n o r t h w i n d ' , '

* p u b s ' , ' t e m p d b ' ) a n d u p p e r ( t . T a b l e T y p

* e ) i n ( ' B ' , ' U ' ) a n d ( t . I n d e x I D = 1 o

* r t . I n d e x I D = 2 5 6 ) a n d t . N u m R o w s > 0

* o r d e r b y D B N a m e , T a b l e N a m e , T a b l e O w

* n e r f o r r e a d o n l y

* o p e n R e o r g C u r s o r f e t c h R e o r g C u r s o r i

* n t o @ d b n a m e , @ d b i d , @ t a b l e i d w h i l e @

* @ f e t c h _ s t a t u s = 0 b e g i n i f ( s e l e c t c

* o u n t ( * ) f r o m m a s t e r . . s y s l o c k i n f o ( n o

* l o c k ) w h e r e r s c _ d b i d = @ d b i d a n d r e q

* _ m o d e n o t i n ( 3 , 8 ) a n d ( r s c _ t y p e = 2

* o r ( r s c _ t y p e = 5 a n d r s c _ o b j i d = @ t

* a b l e i d ) ) ) = 0 s e l e c t @ c o m m a n d = ' u s e

* [ ' + r e p l a c e ( @ d b n a m e , c h a r ( 9 3 ) , c h a r (

* 9 3 ) + c h a r ( 9 3 ) ) + ' ] d b c c s h o w c o n t i g ( '

* + c o n v e r t ( v a r c h a r ( 2 0 ) , @ t a b l e i d ) +

* ' ) ' e l s e s e l e c t @ c o m m a n d = ' u s e [ ' +

* r e p l a c e ( @ d b n a m e , c h a r ( 9 3 ) , c h a r ( 9 3 ) + c

* h a r ( 9 3 ) ) + ' ] s e l e c t ' ' T a b l e n o t a c c

* e s s i b l e ' ' , o b j e c t _ n a m e ( ' + c o n v e r t ( v a

* r c h a r ( 2 0 ) , @ t a b l e i d ) + ' ) ' e x e c u t e ( @

* c o m m a n d ) f e t c h R e o r g C u r s o r i n t o @ d b n

* a m e , @ d b i d , @ t a b l e i d E n d C l o s e R e o r g

* C u r s o r d e a l l o c a t e R e o r g C u r s o r T r u n c a

* t e t a b l e # T a b l e D e t a i l s e n d

*

*

*******************************************************************************

-------------------------------------------------------------------------------

Short Stack Dump

0x77f8850f Module(ntdll+850f) (LdrUnloadDll+36)

0x007826f6 Module(sqlservr+3826f6) (ex_terminator+37)

0x78006942 Module(MSVCRT+6942) (_unDNameEx+575)

0x7800686a Module(MSVCRT+686a) (_unDNameEx+49d)

0x7800699e Module(MSVCRT+699e) (_unDNameEx+5d1)

0x780071b7 Module(MSVCRT+71b7) (_unDNameEx+dea)

0x77fbb272 Module(ntdll+3b272) (wcstombs+13a4)

0x77facdaa Module(ntdll+2cdaa) (RtlQueryTagHeap+22)

0x7800716a Module(MSVCRT+716a) (_unDNameEx+d9d)

0x78006c3c Module(MSVCRT+6c3c) (_unDNameEx+86f)

0x78006b7c Module(MSVCRT+6b7c) (_unDNameEx+7af)

0x780069fb Module(MSVCRT+69fb) (_unDNameEx+62e)

0x780071b7 Module(MSVCRT+71b7) (_unDNameEx+dea)

0x77fbb272 Module(ntdll+3b272) (wcstombs+13a4)

0x77facc28 Module(ntdll+2cc28) (RtlSetUserFlagsHeap+1e2)

0x77f91bc6 Module(ntdll+11bc6) (RtlSetEnvironmentVariable+cf)

0x78007108 Module(MSVCRT+7108) (_unDNameEx+d3b)

0x004f8998 Module(sqlservr+f8998) (SetEcFlagAndThrow+38)

0x004f879e Module(sqlservr+f879e) (ex_raise2+332)

0x004f8616 Module(sqlservr+f8616) (ex_raise+5f)

0x00535dbc Module(sqlservr+135dbc) (SendRstatusStream+44)

0x0040fd80 Module(sqlservr+fd80) (CParamExchange:TonguerocessReturnStatus+4c)

0x0040e5d6 Module(sqlservr+e5d6) (CMsqlExecContext::Execute+328)

0x0040ddb0 Module(sqlservr+ddb0) (CSQLSource::Execute+232)

0x00503fae Module(sqlservr+103fae) (CStmtExecStr::XretExecute+271)

0x0040e9ab Module(sqlservr+e9ab) (CMsqlExecContext::ExecuteStmts+11b)

0x0040e4c0 Module(sqlservr+e4c0) (CMsqlExecContext::Execute+1bb)



-------------------------------------------------------------------------------------------
Jonathan Kehayias
Jonathan Kehayias
SSCertifiable
SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)

Group: General Forum Members
Points: 6595 Visits: 1818
SQL 7.... That is gonna be tough to get good help with since it has been out of it service life for a number of years now. SQL 2000 is fast becoming a legacy already since it is out of its service life as well.

What happens if you run the TSQL in the input buffer manually upon restarting the SQL Services? Does it dump out again? If so, you may need to contact Microsoft and open a support case for this, which will likely be expensive since it is beyond extended support.

Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs
ebenraja
ebenraja
SSC-Enthusiastic
SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)

Group: General Forum Members
Points: 196 Visits: 258
Thanks dude..it was my application tool that was causing the issue . Its checked

Thanks Eben
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search