Script causes SQL2005 to crash

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.

All Forums

General SQL Server Forums

Data Corruption Issues

Script causes SQL2005 to crash

Author

Topic

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2006-07-03 : 09:56:28

I am not sure if this is the right forum,
but a sql crash might cause data corruption ?!

Anyway I have tried this on 2 different sql2005 sp1 installations.
(Developer Edition)
And in both cases the last piece of code causes the sql server to stop cold (crash).

script originally posted here(afaik):
### link removed ###


####################
I removed the script
Didn't seem like a good idea to make this kind of thing public
####################

rockmoose

nr
SQLTeam MVY

12543 Posts

Posted - 2006-07-03 : 10:12:09

My first reaction is that it looks pretty simple but I'm not going to try it.
What happens if you remove the fmtonly?
What happens if you don't call StrConcatBack

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2006-07-03 : 10:17:07

If you remove the FMT ONLY it doesn't crash.

I haven't investigated further to see what the exact combination of commands that causes the crash is.

rockmoose

mr_mist
Grunnio

1870 Posts

Posted - 2006-07-03 : 10:26:25

It happily crashes my dev edition sp1 too.

-------
Moo. :)

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2006-07-03 : 10:46:06

Can a forum moderator chip in and say it is ok to put the code back / or not.

rockmoose

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2006-07-03 : 11:00:00

hey i'd like to see that too

Go with the flow & have fun! Else fight the flow

nr
SQLTeam MVY

12543 Posts

Posted - 2006-07-03 : 11:38:04

Could email it to paulrandal.
If you send it to me I'll get someone from microsoft to look at it next time I'm home (probably tomorrow evening).

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Kristen
Test

22859 Posts

Posted - 2006-07-03 : 13:17:05

"If you send it to me I'll get someone from microsoft to look at it next time I'm home"

Home = Microsoft? !!

nr
SQLTeam MVY

12543 Posts

Posted - 2006-07-03 : 13:31:08

quote:
Originally posted by Kristen

"If you send it to me I'll get someone from microsoft to look at it next time I'm home"

Home = Microsoft? !!

Nope - where I am at the moment I can't log in using passport so can't access any microsoft stuff.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-07-04 : 04:10:00

i wanna see the script too... pretty please

--------------------
keeping it simple...

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2006-07-05 : 18:11:43

Just back from vacation - please email me the script - thanks

Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine + SQL Express
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2006-07-05 : 18:41:28

I have posted the script to PR

rockmoose

nr
SQLTeam MVY

12543 Posts

Posted - 2006-07-05 : 19:07:54

Bob Ward (Microsoft) is also looking at it.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2006-07-05 : 19:42:44

Very interesting. This certainly could have nasty side-effects if it happened at the wrong time. I'll make sure its fixed for SP2.

Does anyone know if the customer who hit this has opened a case with Product Support?

[Edit] I've hooked up with Bob Ward too.

Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine + SQL Express
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2006-07-06 : 10:29:55

After running the script sql service was still shown as running in Services but i couldn't connect to the server.
Stoping/Starting the service didn't help.
i had to restart the virtual machine i have SQL2005 SP1 on...

Go with the flow & have fun! Else fight the flow

blog thingie: http://weblogs.sqlteam.com/mladenp

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2006-07-06 : 14:18:23

Not the same behavior I got, it stopped in Services as well.
And there was no problem starting it again.

from sql log:

Date		2006-07-06 20:13:46
Log		SQL Server (Archive #1 - 2006-07-06 20:13:00)

Source		spid58

Message
SQL Server is terminating because of fatal exception c0000005. This error may be caused by an unhandled Win32 or C++ exception, or by an access violation encountered during exception handling. Check the SQL error log for any related stack dumps or messages. This exception forces SQL Server to shutdown. To recover from this error, restart the server (unless SQLAgent is configured to auto restart).

rockmoose

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-07-06 : 22:21:00

i downloaded the sp1 from the microsoft site but before installation can begin, it says hotfix.exe is not a valid win32 application

do i need to upgrade anything else before i can patch up?

--------------------
keeping it simple...

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-07-10 : 04:01:48

ok, here's what i gathered:

1. applied sp1, but error during patching encountered:

Product: Client Components
Client Components (RTM 1399 ENU) - Failure
Details: Unable to install Windows Installer MSP file

2. After reboot, all services are up

3. I issue THE SCRIPT, and encountered this error:

Msg 109, Level 20, State 0, Line 0
A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.)

--> the sql services shut down

4. looking at event viewer, here's the error message:

SQL Server is terminating because of fatal exception c0000005. This error may be caused by an unhandled Win32 or C++ exception, or by an access violation encountered during exception handling. Check the SQL error log for any related stack dumps or messages. This exception forces SQL Server to shutdown. To recover from this error, restart the server (unless SQLAgent is configured to auto restart).

5. I started the services and sql server is running again

any updates from MS?

--------------------
keeping it simple...

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2006-07-10 : 05:14:59

That looks what I got Jen.

This may be totally unrelated, but:
My Sql Server Agent is marked as "Auto Restart if stopped unexpectedly". (So is my Sql Server)
However, the Auto Restart never happens. I have to manually restart any services after unexpected shutdown.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2006-07-10 : 05:37:30

Same here.

Go with the flow & have fun! Else fight the flow

blog thingie: http://weblogs.sqlteam.com/mladenp

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-07-10 : 11:03:25

same here...

there are 3 tries for the services to try to startup... but based on the event log, it only tried once and didn't seem to persevere

when you ran the script, did you receive the error message or it never came to that point and totally crashed? quite interesting...

I can just hear the clatterings all the way at MS, engineers working double time to release sp2

--------------------
keeping it simple...

Next Page

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources