November 20, 2007 at 9:54 am
We've been having alot of odd issues with a new server and opted to start over. We moved to 2003 Server x64 from 32 and intended to stick with SQL 32 SP3a which we've been running for quite a long time.
Unfortuantly we had to go to SP4 due to x64 server and its been a nightmare since.
We've attemped a few hot fixes that quieted a few issues down, 939317 won't install, so were trying to get 936232 installed right now.
Attached is the current errorlog and dump file
We're getting a few e-mails too. The error 0 is new, only seen it once, the 1203 has been pretty constant (every few minutes) but may have stopped now.
DESCRIPTION:Error: 0, Severity: 19, State: 0
SqlDumpExceptionHandler: Process 156 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
DESCRIPTION:Error: 1203, Severity: 20, State: 1
Process ID 203 attempting to unlock unowned resource KEY: 14:786205951:1 (8b00b714b110).
From the attached info, anyone have any advice to work out these problems.
We plan to goto 2005 as soon as possible, but we still use a fair amount of DTS packages, so we'll need to work around that before migrating.
IF its any help, the server is a PowerEdge 6800, Dual 3.4/16M Dual-core Xeons and 16 Gigs of ram (mirrored to 8)
3 Arrays (Mirror for OS, 6 disk raid 5 for database and a mirror for sql backups)
November 20, 2007 at 12:17 pm
I've had a couple of service pack installation problems recently, and I think the problem was that the account used to log onto the server did not have enough permissions. Check that you're an Server admin AND have full SQL access. At one point, BUILTIN|Administrators did not have SQL access on our box which caused problems.
November 20, 2007 at 12:51 pm
We finally got one of the latest hot fixes now.
The vast majority of our issue is now movenext in our code. It quits before reaching end of file, so there are tons of things not working and we'd prefer not to go back and update and compile dozens of custom apps.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply