Worrying Log Entries
-
Has anyone seen anything like this before?? I have a server (SQL Server 7) which has been happy for a long time, very stable logs with no unusual messages. Yesterday however when I looked at the sql log it is full of strange things - I have included a sample below.
Some entries have no date next to them, and when I asked our techy to check the event logs on the actual server they are blank (although you can highlight rows as if there is white text on white background). He says it's like nothing he's ever seen, and so we are a bit stumped. I'm not sure how to interpret the SQL server logs, or how to investigate, so can someone please tell me where I start, if any of you have been through this before. A fast reply would be greatly appreciated!!!
Many thanks!!!!
0x00411481 Module(sqlservr+11481) (CQScanRowset::WakeUp+63)
0x00420671 Module(sqlservr+20671) (CQScanRange:
pen+1c)0x004272d7 Module(sqlservr+272d7) (CQScan:
pen+1c)0x004272d7 Module(sqlservr+272d7) (CQScan:
pen+1c)0x00427372 Module(sqlservr+27372) (CQScanRowset:
pen+12)0x004272d7 Module(sqlservr+272d7) (CQScan:
pen+1c)0x00422c0b Module(sqlservr+22c0b) (CQScanDelay:
pen+e)0x00422377 Module(sqlservr+22377) (CQScanNLJoin:
pen+15)0x004272d7 Module(sqlservr+272d7) (CQScan:
pen+1c)0x00427372 Module(sqlservr+27372) (CQScanRowset:
pen+12)0x004272d7 Module(sqlservr+272d7) (CQScan:
pen+1c)0x004272d7 Module(sqlservr+272d7) (CQScan:
pen+1c)2005-08-15 14:50:47.16 spid17 Error: 0, Severity: 19, State: 0
2005-08-15 14:50:47.16 spid17 language_exec: Process 17 generated an access violation. SQL Server is terminating this process.
.
2005-08-15 14:50:47.30 spid17 Using 'sqlimage.dll' version '4.0.5'
Stack Dump being sent to D:\MSSQL7\log\SQL00014.dmp
2005-08-15 14:50:48.27 spid17 Error: 0, Severity: 19, State: 0
2005-08-15 14:50:48.27 spid17 SqlDumpExceptionHandler: Process 17 generated fatal exception c000008e EXCEPTION_FLT_DIVIDE_BY_ZERO. SQL Server is terminating this process.
-
Ha ha, I did not put those faces in, but hey it looks good!
-
I don't know if this helps or not, but I've seen something similar in the past when running 7.0. A few times, when a user would do something wierd I'd start seeing all these query results start to fill up the log. It was pretty much like something you'd see in a trace result. If I did'nt catch it in time, SQL Server would eventually restart itself and the problem would be resolved.
We eventually wrote this off to a memory overflow problem and did some user retraining making sure they did not kick off the same process multiple times. It looks like you have something similar going on because of the Access Violation message. I have not seen this since we moved to 2000. Hope this helps.
My hovercraft is full of eels.
-
Hi agree with previous post, you can find more info by looking in the dumpfile that you will find in the sql server error log directory c:\program files\mssql\LOG or whatever path you chose during sql server install. In addition to the normal log files you will find dump logs. In these logs you should find date time entries at the same time you see the errors in the SQL error log. These may assist in determining what caused the errors. I have seen these errors occur from bad app queries and memory problems on a server. I would also check for corresponding time / errrors in the sql agent error log also, I reckon you will find entries here too if you have memory or other server issues. A reboot of the server often fixes these, I have seen instances that occur when a server has been up for extended periods. After reboot all good until several months pass and they begin to re-occur, not sure of cause, maybe memory leaks etc etc. Ensure currentl patch levels are applied to SQL Server as a precaution.
Derek
-
Access violations are not good. What SP are you on ? Could you upgrade to SQL2000 ? It's possible that you are being 'bit' by a fixable 'bug(s)'. Have you 'googled' for some answers yet ? Tried opening a case with MS PSS (if you have support) ? Just throwing out the general things first ... casting a wide net so to speak ...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply