SP_Errorlog

Question

SP_Errorlog

sudhakara

SSCrazy Eights

Points: 9425
More actions
June 2, 2010 at 3:44 am

#387060

Hi,
while trying to get the detilas of the errorlog its throwing the following error mesages
Query Results:
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
From Error Log file:
Exception happened when running extended stored procedure 'xp_readerrorlog' in the library 'xpstar90.dll'. SQL Server is terminating process 146. Exception type: Win32 exception; Exception code: 0xc0000005.
Please let me know how to resolve this issue.
Thanks in Advance .

Brandie Tarvin SSC Guru Points: 173080 More actions · Answer 1

Describ the steps you're taking to read the error log, please.

Also, is the log file hard drive full? Have you recently run a diskscan to verify all the sectors are good?

Check your Server Event Viewer to see if there are any other errors from around the same time as you checked the SQL Error Log. These might point you in the right direction.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

sudhakara SSCrazy Eights Points: 9425 More actions · Answer 2

Brandie Tarvin (6/2/2010)
Describ the steps you're taking to read the error log, please.
Also, is the log file hard drive full? Have you recently run a diskscan to verify all the sectors are good?
Check your Server Event Viewer to see if there are any other errors from around the same time as you checked the SQL Error Log. These might point you in the right direction.

Error message at Event view.

Exception happened when running extended stored procedure 'xp_readerrorlog' in the library 'xpstar90.dll'. SQL Server is terminating process 147. Exception type: Win32 exception; Exception code: 0xc0000005.

i tried in the google but i could not find the solution and reason for this issue.

Brandie Tarvin SSC Guru Points: 173080 More actions · Answer 3

All,

This is a duplicate thread. Responses can be found at Fatal Error.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

sudhakara SSCrazy Eights Points: 9425 More actions · Answer 4

Brandie Tarvin (6/3/2010)
All,
This is a duplicate thread. Responses can be found at Fatal Error.

Hi,

This is not duplicate thread.Both issues are not simliar.Please update your post to resovle this.

Thanks

Packer SSC Enthusiast Points: 129 More actions · Answer 5

Packer

SSC Enthusiast

Points: 129

February 23, 2011 at 2:37 pm

#1290644

Did you ever find a solution to this problem?

DBA328 Hall of Fame Points: 3952 More actions · Answer 6

I suspect the dll file has problem. You can try to backup this 'xpstar90.dll' and copy a new one from other server then register it. After that reboot the server and re-run the sp_readerrorlog.

Packer SSC Enthusiast Points: 129 More actions · Answer 7

I tried to copy the dll from our development (good working order) server to production, but wasn't able to unregister/register the dll. I received the following error: LoadLibrary("XPStar90.DLL") failed - Invalid access to memory location.

I have spent days troubleshooting this. I think I might go ahead and reinstall SQL Server.

Thanks,

Matt