SQL Server Performance Forum – Threads Archive

SQL Named Instance Stack Dump on Startup

Microsoft SQL Server 2000 – 8.00.194 (Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Desktop Engine on Windows NT 5.0 (Build 2195: Service Pack 4) I have a SQL server for a document imaging application. SQL is installed along with a named instance that is necessary for the application. I was not involved in the installation or setup of this machine, but now the responsibility has fallen to me to maintain it. The named instance occasionally (once every other month) generates a stack dump upon startup. Generally all I have to do to "clean" this up is to stop and restart SQL and it’s services, or a reboot. Yesterday I found myself in this situation again, but the normal "fixes" did not resolve it. This morning I was searching the net for clues, and still attempting to shutdown and restart SQL, when SQL finally cooperated and started clean – the app works fine now. I have never found anything in the event viewer to give me a hint. The information in the logs has not provided me with any answers, though I am pretty inexperiened in that area. I have not been able to find any of the log contents in MSKB or elsewhere. I am confident enough to reinstall SQL, to see if any of this is fixed, but the application’s consultant is afraid that the app will break if I do that. I need to take the time to FIX this rather than band-aiding it when it breaks. I inherited this last summer, but the issue has been occurring for 2 years, and the server’s previous caretaker did not deal with it. The other hindrance is that our company will be closing this time next year, so the attitude here is to just keep things running, without any new investment. Any help with this is much appreciated! Thank-you!!! Part of the log is listed below:
—————
2005-03-22 08:37:42.80 server Microsoft SQL Server 2000 – 8.00.194 (Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Desktop Engine on Windows NT 5.0 (Build 2195: Service Pack 4) 2005-03-22 08:37:42.80 server Copyright (C) 1988-2000 Microsoft Corporation.
2005-03-22 08:37:42.80 server All rights reserved.
2005-03-22 08:37:42.80 server Server Process ID is 696.
2005-03-22 08:37:42.80 server Logging SQL Server messages in file ‘C

rogram FilesMicrosoft SQL ServerMSSQL$LASERFICHELOGERRORLOG’.
2005-03-22 08:37:42.82 server SQL Server is starting at priority class ‘normal'(2 CPUs detected).
2005-03-22 08:37:42.92 server SQL Server configured for thread mode processing.
2005-03-22 08:37:42.92 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2005-03-22 08:37:43.08 spid2 Starting up database ‘master’.
2005-03-22 08:37:43.17 spid2 0 transactions rolled back in database ‘master’ (1).
2005-03-22 08:37:43.17 spid2 Recovery is checkpointing database ‘master’ (1)
2005-03-22 08:37:43.21 server Using ‘SSNETLIB.DLL’ version ‘8.0.194’.
2005-03-22 08:37:43.21 spid5 Starting up database ‘model’.
2005-03-22 08:37:43.22 spid2 Server name is ‘HGINT10LASERFICHE’.
2005-03-22 08:37:43.28 spid8 Starting up database ‘msdb’.
2005-03-22 08:37:43.30 spid9 Starting up database ‘Reports’.
2005-03-22 08:37:43.39 spid5 Clearing tempdb database.
2005-03-22 08:37:44.88 server SQL server listening on TCP, Shared Memory, Named Pipes.
2005-03-22 08:37:44.88 server SQL server listening on 157.154.121.239:3977, 127.0.0.1:3977.
2005-03-22 08:37:44.88 server SQL Server is ready for client connections
2005-03-22 08:37:45.47 spid5 Starting up database ‘tempdb’.
2005-03-22 08:37:45.50 spid2 Recovery complete.
2005-03-22 08:37:58.50 server Using ‘sqlimage.dll’ version ‘4.0.5’
Stack Dump being sent to C

rogram FilesMicrosoft SQL ServerMSSQL$LASERFICHElogSQL00640.dmp
2005-03-22 08:37:58.50 server process_loginread: Process 2072 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
.
.
.
2005-03-22 09:00:52.91 server SQL Server is aborting. Fatal exception c0000005 caught. Karen "There are two documents in your in-box: tragedy and comedy. Your Pick." –Dale Dauten

First install SQL server service pack 3, because you don’t have install any services pack.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Thanks, I have tried numerous time to install the SP3 or 3a, but it never installs. This SQL server has SP3, but I am unable to apply the sp to the named instance. It has been at least 6 months since I tried last. At that time I posted messages for help in forums, and I searched the net for help, to no avail. I am not able to attempt an SP install for a few days, as it has to be after hours and I have plans. Karen "There are two documents in your in-box: tragedy and comedy. Your Pick." –Dale Dauten

Gee, I wish I had that flexibility. <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> If you were given the responsibility to manage this, then you need to arrange your schedule ASAP to get this onto the latest service pack. Until you do all that, you’re going to be: 1. Wasting your time trying to troubleshoot issues that have already been solved. 2. Wasting other people’s time. See number 1. <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> 3. Putting your company at a fairly serious security and data integrity risk. There have been significant upgrades since the original release, so I can’t overstate the importance of this. What were the errors you received when you tried the SP deployment. Is it possible the second instance is MSDE? If so, you would need to apply the service pack for that instead. You can find it here: http://www.microsoft.com/downloads/details.aspx?FamilyId=90DCD52C-0488-4E46-AFBF-ACACE5369FA3&displaylang=en</a> You need the sql2kdesksp3.exe download. MeanOldDBA [email protected] When life gives you a lemon, fire the DBA.

Thanks, Derrick. I can only do what I can within this job’s boundries. <img src=’/community/emoticons/emotion-6.gif’ alt=’

‘ /> I would love to drop everything and work on it, but I am not allowed to reboot during the day. Tonight I have an appt, so I can’t after work. I can’t come in early to work on it as that falls within the hours that reboots are prohibited. The higher ups are fully aware of the issues, but are willing to wait. If I had my way, I would have torn the server apart and started from scratch last summer when I inherited it. Last time I attempted to install the SP, it took hours, and as you can see, it did not take. How do I determine if the instance is really msde? Thanks much! Karen "There are two documents in your in-box: tragedy and comedy. Your Pick." –Dale Dauten

SELECT CONVERT(char(20), SERVERPROPERTY(‘edition’))
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

That’s it, Luis. I will apply the sp ASAP. Thanks! Karen "There are two documents in your in-box: tragedy and comedy. Your Pick." –Dale Dauten

<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> This is really aggravating for a lot of people. Microsoft should have the SP autodetect the version and direct you to the appropriate SP if you have the wrong version. MeanOldDBA [email protected] When life gives you a lemon, fire the DBA.

Hi Derrick, It would be nice if the error messages when trying to install the sp would indicate that you are installing the wrong version… but that would be too simple… <img src=’/community/emoticons/emotion-5.gif’ alt=’

‘ /> I find that life is full of lemons, so I suck them dry or make lemonade (‘rita?) and move on… life is too short to let them get in my way… Thanks! Karen "There are two documents in your in-box: tragedy and comedy. Your Pick." –Dale Dauten

Great reply. You’ll fit in just fine around here. <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> MeanOldDBA [email protected] When life gives you a lemon, fire the DBA.

Thank-you, thank-you very much… <img src=’/community/emoticons/emotion-5.gif’ alt=’

‘ /> Karen "There are two documents in your in-box: tragedy and comedy. Your Pick." –Dale Dauten

]]>