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
 ReadFileHdr: Operating system error 38(Reached the

Author  Topic 

iuseyew
Starting Member

4 Posts

Posted - 2007-09-07 : 17:39:46
i believe this is the right thread... i recently had an issue where my xpstar.dll would not register and i read to fix the issue to reapply the SP so i installed SP4 i now am getting this error... please help!

2007-09-07 14:24:19.24 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2007-09-07 14:24:19.24 server SQL Server is starting at priority class 'normal'(4 CPUs detected).
2007-09-07 14:24:19.36 server SQL Server configured for thread mode processing.
2007-09-07 14:24:19.38 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2007-09-07 14:24:19.40 server Attempting to initialize Distributed Transaction Coordinator.
2007-09-07 14:24:20.44 spid3 Starting up database 'master'.
2007-09-07 14:24:20.49 spid3 Error: 823, Severity: 24, State: 5.
2007-09-07 14:24:20.49 spid3 ReadFileHdr: Operating system error 38(Reached the end of the file.) encountered.
2007-09-07 14:24:20.49 spid3 Error: 5159, Severity: 16, State: 3.
2007-09-07 14:24:20.49 spid3 09/07/07 14:24:20 Stack Overflow Dump not possible - Exception c00000fd E at 0x00449CA1
2007-09-07 14:24:20.49 spid3 Address=449ca1 Exception Code = c00000fd
2007-09-07 14:24:20.49 spid3 eax=ba65a0de ebx=00000002 ecx=42ba8740 edx=0bb0a830
2007-09-07 14:24:20.49 spid3 esi=00000001 edi=42ba8740 eip=00449ca1 esp=0bb09fc4
2007-09-07 14:24:20.49 spid3 ebp=0bb0a56c efl=00010212
2007-09-07 14:24:20.49 spid3 cs=1b ss=23 ds=23 es=23 fs=3b gs=0
2007-09-07 14:24:20.49 spid3 1: Frame: 0BB0A56C Return Address 00449CA1
2007-09-07 14:24:20.49 spid3 2: Frame: 0BB0AD88 Return Address 00449E10
2007-09-07 14:24:20.49 spid3 3: Frame: 0BB0AD9C Return Address 0044A14B
2007-09-07 14:24:20.49 spid3 4: Frame: 0BB0ADAC Return Address 0044A17D
2007-09-07 14:24:20.49 spid3 5: Frame: 0BB0ADF8 Return Address 0044A19B
2007-09-07 14:24:20.49 spid3 6: Frame: 0BB0AE18 Return Address 004CD11C
2007-09-07 14:24:20.49 spid3 7: Frame: 0BB0B2A8 Return Address 005ED83E
2007-09-07 14:24:20.49 spid3 8: Frame: 0BB0B2FC Return Address 00405473
2007-09-07 14:24:20.49 spid3 9: Frame: 0BB0B324 Return Address 00449357
2007-09-07 14:24:20.49 spid3 10: Frame: 0BB0B350 Return Address 00449329
2007-09-07 14:24:20.49 spid3 11: Frame: 0BB0B378 Return Address 00448EE1
2007-09-07 14:24:20.49 spid3 12: Frame: 0BB0B3E0 Return Address 0060CFF5
2007-09-07 14:24:20.49 spid3 13: Frame: 0BB0BC04 Return Address 006D0991
2007-09-07 14:24:20.49 spid3 14: Frame: 0BB0BC18 Return Address 0044A14B
2007-09-07 14:24:20.49 spid3 15: Frame: 0BB0BC28 Return Address 0044A17D
2007-09-07 14:24:20.49 spid3 16: Frame: 0BB0BC74 Return Address 0044A19B
2007-09-07 14:24:20.49 spid3 17: Frame: 0BB0BC94 Return Address 004CD11C
2007-09-07 14:24:20.49 spid3 18: Frame: 0BB0C124 Return Address 005ED83E
2007-09-07 14:24:20.49 spid3 19: Frame: 0BB0C178 Return Address 00405473
2007-09-07 14:24:20.49 spid3 20: Frame: 0BB0C1A0 Return Address 00449357
2007-09-07 14:24:20.49 spid3
2007-09-07 14:24:20.49 spid3 TotalPhysicalMemory = 2146951168, AvailablePhysicalMemory = 1552097280
2007-09-07 14:24:20.49 spid3 AvailableVirtualMemory = 376274944, AvailablePagingFile = 3696713728

Kristen
Test

22859 Posts

Posted - 2007-09-07 : 19:10:21
"2007-09-07 14:24:20.44 spid3 Starting up database 'master'.
2007-09-07 14:24:20.49 spid3 Error: 823, Severity: 24, State: 5.
2007-09-07 14:24:20.49 spid3 ReadFileHdr: Operating system error 38(Reached the end of the file.) encountered.
"

Its possible that your master database is corrupted, have you got a backup that you could try restoring?

Before doing so I recommend that:

Stop the SQL Service
Copy the master.mdf and master.ldf to a safe location

If the restore fails, or does not improve things, then you could reinstate the current state by stopping SQL Server again and copying-back the saved files.

Kristen
Go to Top of Page

iuseyew
Starting Member

4 Posts

Posted - 2007-09-07 : 19:23:24
thank you for the info... i should have said that the reason i am checking the log file and seeing this error is because the "mssqlserver" service will not even start it terminates unexpectedly even when i manually try to start it. I also get an error on the "mssqlServerADhelper" service stating that the system cannot find the specified file. the enterprise manager will not even open the sql snapin as if the update did not complete... however the SP install did complete i rebooted the server and made sure the databases were still there everything looked ok. my most recent backup is missing but i am sure that i have a tape backup from a day or so ago. should i try to reinstall the SP?
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2007-09-07 : 19:35:24
Any chance you have a copy of the Master database files (MDF + LDF) from when the SQL Service was stopped?

(We now take a copy of these periodically for just such an eventuality).

Putting those in place (after having preserved the originals, as above) would allow you to get the system upright, and then you could look to restore a "real" backup from before the corruption - which would reinstate anything else that had been added recently - such as users, databases, and so on.

Can't guarantee this will work, just thinking out loud. Best to take all precautions you can think of to be able to reverse anything you try as a fix.

A fresh install of SQL Server would also give you "workable" master files, but they do need to be identical in terms of folders and so on.

Kristen
Go to Top of Page

iuseyew
Starting Member

4 Posts

Posted - 2007-09-07 : 19:48:40
i think a reinstall is needed none of the sql apps are functioning...
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-07 : 22:58:07
Tried rebuild master db?
Go to Top of Page

iuseyew
Starting Member

4 Posts

Posted - 2007-09-10 : 14:38:11
quote:
Originally posted by rmiao

Tried rebuild master db?



i am not a sql admin... but i do not think i can do that untill after i have sql functioning properly! i think there may be a raid card issue that caused this SP from applying properly so i need to wait for a local admin to verify first.. its a great time for vacations :\
Go to Top of Page
   

- Advertisement -