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


SQL Server shutdown error


SQL Server shutdown error

Author
Message
kwitzell
kwitzell
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2142 Visits: 758

We have a SQL 2000 SP3a database on a dual processor non-clustered server with 4 GB of ram. Just today the application analyst told me that SQL server had shut itself down. I had never heard of this and upon checking the error logs found the following:

2007-05-02 15:29:25.04 spid201 Stack Signature for the dump is 0xD1F283AA
2007-05-02 15:29:26.87 spid201 Error: 3314, Severity: 21, State: 4
2007-05-02 15:29:26.87 spid201 Error while undoing logged operation in database 'tempdb'. Error at log record ID (47:15496:339)..
2007-05-02 15:29:26.87 spid201 Error: 3449, Severity: 21, State: 1
2007-05-02 15:29:26.87 spid201 An error has occurred that requires SQL Server to shut down so that recovery can be performed on database ID .. 2

2007-05-02 15:29:24.29 spid201 Stack Signature for the dump is 0xC07D52BA
2007-05-02 15:29:24.34 spid201 Error: 3448, Severity: 21, State: 1
2007-05-02 15:29:24.34 spid201 Could not undo log record (47:15496:339), for transaction ID (0:87990), on page (3:21958),database 'tempdb' (database ID 2). Page information: LSN = (43:24736:1), type = 7. Log information: OpCode = 2, context 1..
2007-05-02 15:29:24.34 spid201 ex_raise2: Exception raised, major=34, minor=48, severity=25, attempting to create symptom dump
2007-05-02 15:29:24.34 spid201 Using 'dbghelp.dll' version '4.0.5'
*Dump thread - spid = 201, PSS = 0x38d15808, EC = 0x38d15b38
*
* User initiated stack dump. This is not a server exception dump.
*
*Stack Dump being sent to g:\PerformanceData\MSSQL\log\SQLDump0221.txt
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 05/02/07 15:29:24 spid 201
*
* ex_raise2: Exception raised, major=34, minor=48, severity=25

The system is back up and running with no apparent problems, but this is the second time this has occured in the last couple of days. Has anyone ever seen anything like this? If so what is the problem and how did you correct it? Any help will be greatlly appreciated! Thanks

Ken





Randolph West
Randolph West
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1391 Visits: 464
I'm just guessing here, but it sounds like the transaction log is getting corrupted, or you're running out of space on the drive where tempdb is stored. Another suggestion is to check the growth limits on tempdb and its log file.

Check the Event Viewer for other errors in the Application and System logs.
EdVassie
EdVassie
SSC Guru
SSC Guru (56K reputation)SSC Guru (56K reputation)SSC Guru (56K reputation)SSC Guru (56K reputation)SSC Guru (56K reputation)SSC Guru (56K reputation)SSC Guru (56K reputation)SSC Guru (56K reputation)

Group: General Forum Members
Points: 56656 Visits: 3986

Definitely check that tempdb has enough space to grow.

If you are sure that tempdb can get all the space it needs, then I would report this problem to Microsoft.



Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005. 14 Mar 2017: now over 40,000 downloads.Disclaimer: All information provided is a personal opinion that may not match reality.Quote: When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist. - Archbishop Hélder Câmara
kwitzell
kwitzell
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2142 Visits: 758

Thanks for the feed back, the tempdb is on a drive with about 1.5 TB of freespace, so I don't think the disk is filling, I will give Microsoft a call. Thanks again!

Ken





Steve Jones
Steve Jones
SSC Guru
SSC Guru (652K reputation)SSC Guru (652K reputation)SSC Guru (652K reputation)SSC Guru (652K reputation)SSC Guru (652K reputation)SSC Guru (652K reputation)SSC Guru (652K reputation)SSC Guru (652K reputation)

Group: Administrators
Points: 652683 Visits: 21485
I agree with the call PSS advice. If it's not something simple like space, which it doesn't look like.

Might try shutting down SQL and defragging the OS drive as well. It might move the tempdb files and mark bad sectors for you.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
kwitzell
kwitzell
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2142 Visits: 758

Thanks Steve,

We had been tossing around the idea of a hardware issue, this might be something to look at. While looking at the problem, I found that someone had added another tempdb file on another disk. So we now have two. The disk the second file is on has 45GB free. If one file fills will SQL Server switch to another avaliable file? Just wondering..

Ken





Hans Lindgren
Hans Lindgren
SSCrazy Eights
SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)

Group: General Forum Members
Points: 9524 Visits: 438

I would say turn off any AV on your system. You could look in your dumpfile if this is wrecking havoc to your SQL Server process space. (Is likely depending on your AV vendor)

Hanslindgren





kwitzell
kwitzell
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2142 Visits: 758
Ok thanks for the suggestion!



Kobus-467674
Kobus-467674
SSC-Enthusiastic
SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)

Group: General Forum Members
Points: 183 Visits: 4

Hi Ken,

Did you manage to solve this problem? What is the solution?

I have the same problems, but mine started after a hard drive failure on my RAID 5, a corrupted System Registry Hive and a few other problems in between.

When I finally had everything restored/fixed up so that I can boot into the server, everything was working besides SQL.

In the mean time I'll try the chkdsk again and the defrag option, as I had some problems with the file system during this whole process.

Is there a way of restoring another temp db using another sql server instance to replace the one on the server that is currently experiencing problems?

Running Windows 2003 R2, SP2.
SQL Server 2000 MSDE SP4 (Version: 8.00.2039)

Any help would be appreciated.

Thank you.

Kobus


Kobus-467674
Kobus-467674
SSC-Enthusiastic
SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)

Group: General Forum Members
Points: 183 Visits: 4
An update:
Neither the Defrag or chkdsk produced any results.

If only I could run the database consistency checks somehow to make sure that the tempdb is OK.

Came across this error as well. Could this have an influence, especially if the Local System Account is used for the service account?

Event Type: Error
Event Source: Userenv
Event Category: None
Event ID: 1508
Date: 2007/07/21
Time: 17:19:21
User: NT AUTHORITY\SYSTEM
Computer: ServerName
Description:
Windows was unable to load the registry. This is often caused by insufficient memory or insufficient security rights.

DETAIL - The configuration registry database is corrupt. for C:\Documents and Settings\LocalService\ntuser.dat

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Event Type: Error
Event Source: Userenv
Event Category: None
Event ID: 1510
Date: 2007/07/21
Time: 17:19:21
User: NT AUTHORITY\LOCAL SERVICE
Computer: ServerName
Description:
Windows cannot load your profile because it may be corrupted. Contact your administrator.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

I changed the logon account credentials, and SQL started up and shut down again as before.

As you can see, I am beginnig to become desperate.

If all else fails, I guess I'll have to re-install SQL?
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