| Author |
Topic |
|
albertkohl
Aged Yak Warrior
740 Posts |
 Posted - 2009-04-16 : 20:51:39
|
i found: 2009-04-16 12:33:27.76 Server Using 'dbghelp.dll' version '4.0.5'2009-04-16 12:33:27.78 Server **Dump thread - spid = 0, EC = 0x00000000000000002009-04-16 12:33:27.78 Server ***Stack Dump being sent to E:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\LOG\SQLDump0009.txt2009-04-16 12:33:27.78 Server * *******************************************************************************2009-04-16 12:33:27.78 Server *2009-04-16 12:33:27.78 Server * BEGIN STACK DUMP:2009-04-16 12:33:27.78 Server * 04/16/09 12:33:27 spid 14162009-04-16 12:33:27.78 Server *2009-04-16 12:33:27.78 Server * Non-yielding IOCP Listener2009-04-16 12:33:27.78 Server *2009-04-16 12:33:27.78 Server * *******************************************************************************2009-04-16 12:33:27.78 Server * -------------------------------------------------------------------------------2009-04-16 12:33:27.78 Server * Short Stack Dump2009-04-16 12:33:27.81 Server Stack Signature for the dump is 0x00000000000001E02009-04-16 12:33:28.29 Server External dump process return code 0x20000001.External dump process returned no errors. in the error logs... the server lost power this morning, and has been rolling back a huge update ever since.any ideas? should i worry, or just keep trying to connect to it until it's successful?also, this error followed right after, and it's been nothing but the following error (with increasing intervals) since:2009-04-16 12:33:28.29 Server IO Completion Listener (0x5b8) Worker 0x000000000802A1A0 appears to be non-yielding on Node 0. Approx CPU Used: kernel 0 ms, user 0 ms, Interval: 15140. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
albertkohl
Aged Yak Warrior
740 Posts |
Posted - 2009-04-16 : 22:01:26
|
| lol that sounds like GREAT news... :D i am the customer. (it's our own server)i googled a little, and looks like some ppl are saying it's a problem w/ the subsystem. problem is, there is no sub-system, all storage is attached locally. this only happened after i tried to switch a table to emergency to get some old scripts out of it, i restarted the server, ssms has allowed me to gain access. so i'm getting my scripts off the server, and then i'll go from there.this is my test server, so i can run it over with a truck for all i care, just want my scripts off it :D |
 |
|
|
albertkohl
Aged Yak Warrior
740 Posts |
Posted - 2009-04-16 : 22:06:22
|
| is there anyway to access stored procedures or anything while a database is in recovery? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
albertkohl
Aged Yak Warrior
740 Posts |
Posted - 2009-04-16 : 23:28:36
|
| well i guess it's a good thing then, that since i rebooted it, it's already @ 81%... thanks for the answer though! |
|
|
|
albertkohl
Aged Yak Warrior
740 Posts |
Posted - 2009-04-17 : 00:23:28
|
quick question, looks like the database just finished recovery, but i noticed it said that it rolled back 1 transaction.isnt the following supposed to run 1 transaction per 4,000,000 rows? or am i mistaken?declare @max intdeclare @counter intselect @max=MAX(uid) from test.dbo.consumerset @counter=1while @counter<=@maxbeginupdate c set c.fname = substring(c.fname,1,len(fname)) from test.dbo.mytable c where c.uid between @counter and @counter + 4000000 set @counter=@counter+4000000 select @counterEND reason for doing this, is right now, our table is imported fixed-format.seems like DTS imports the blank space, so it imports "ALBERT " instead of "ALBERT"Thanks! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
albertkohl
Aged Yak Warrior
740 Posts |
Posted - 2009-04-17 : 00:46:39
|
| oic, duh... guess i didnt think about that. tx! |
|
|
|
|
cannot connect to SSMS, stack dump?