Post reply

abrupt SQL Server restarts

  • February 27, 2013 at 4:18 am

    #271354

    I have recently installed a SQL Server 2012 instance and have deployed a few databases on it.

    However, the server is restaring abruptly and nothing is clear from SQL Server logs.

    I see some wierd messages in event viewer like the below ones:

    Product: SQL Server 2012 Database Engine Services - Update '{402234FB3-7241-4B6D-83A4-92323BCS3DC8}' could not be installed. Error code 1642. Windows Installer can create logs to help troubleshoot issues with installing software packages. Use the following link for instructions on turning on logging support: http://go.microsoft.com/fwlink/?LinkId=23127

    Windows detected your registry file is still in use by other applications or services. The file will be unloaded now. The applications or services that hold your registry file may not function properly afterwards.

    DETAIL -

    2 user registry handles leaked from \Registry\User\S-1-5-80-1651743498233-604422593-37299121234-4324324703093-311232196992:

    Process 6056 (\Device\HarddiskVolume3\Windows\System32\conhost.exe) has opened key \REGISTRY\USER\S-1-5-80-16517234234233-12334442-3729906164-4251703093-3124596992\Control Panel\International

    Process 6044 (\Device\HarddiskVolume4\Program Files\Microsoft SQL Server\MSSQL11.DEV\MSSQL\Binn\fdhost.exe) has opened key \REGISTRY\USER\S-1-5-80-1651231233-6021312593-31232139906164-42556757573093-3124596992\Control Panel\International

    Whats the reason for the SQL restart? Would a Service pack upgrade help?

  • February 27, 2013 at 5:56 am

    #1591506

    Friends,

    need urgent help on this.

  • February 27, 2013 at 6:50 am

    #1591532

    If you need urgent help on a rather odd problem, open a case with Microsoft support.

    We're all volunteers here, we post in our spare time.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 27, 2013 at 7:26 am

    #1591548

    Benki Chendu (2/27/2013)

    I have recently installed a SQL Server 2012 instance and have deployed a few databases on it.

    However, the server is restaring abruptly and nothing is clear from SQL Server logs.

    I see some wierd messages in event viewer like the below ones:

    Product: SQL Server 2012 Database Engine Services - Update '{402234FB3-7241-4B6D-83A4-92323BCS3DC8}' could not be installed. Error code 1642. Windows Installer can create logs to help troubleshoot issues with installing software packages. Use the following link for instructions on turning on logging support: http://go.microsoft.com/fwlink/?LinkId=23127

    Windows detected your registry file is still in use by other applications or services. The file will be unloaded now. The applications or services that hold your registry file may not function properly afterwards.

    DETAIL -

    2 user registry handles leaked from \Registry\User\S-1-5-80-1651743498233-604422593-37299121234-4324324703093-311232196992:

    Process 6056 (\Device\HarddiskVolume3\Windows\System32\conhost.exe) has opened key \REGISTRY\USER\S-1-5-80-16517234234233-12334442-3729906164-4251703093-3124596992\Control Panel\International

    Process 6044 (\Device\HarddiskVolume4\Program Files\Microsoft SQL Server\MSSQL11.DEV\MSSQL\Binn\fdhost.exe) has opened key \REGISTRY\USER\S-1-5-80-1651231233-6021312593-31232139906164-42556757573093-3124596992\Control Panel\International

    Whats the reason for the SQL restart? Would a Service pack upgrade help?

    I agree with Gail on this one. This is one for the folks at MS.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • February 27, 2013 at 7:44 am

    #1591558

    Hi Gail,

    Sorry.I didnt mean to pressurize people here.

    Do you have any idea on this? Would a service pack upgrade help here?

  • February 27, 2013 at 7:54 am

    #1591565

    Benki Chendu (2/27/2013)

    Do you have any idea on this? Would a service pack upgrade help here?

    No idea whatsoever. Call MS support and open a case with them (yes, there is a cost).

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 27, 2013 at 8:00 am

    #1591570

    Sure Gail. I will do it. Thanks

  • April 2, 2013 at 11:45 am

    #1602910

    Did you ever find a reason for this?

    I'm seeing it on my 2008 server, 2008 R2 SQL.

    That server has frequent mysterious failovers - I'm wondering if this is a symptom or a clue that something bigger is going on?

  • April 2, 2013 at 12:03 pm

    #1602918

    Could you post your 2008 problem in a new thread (in the 2008 forum) and include the last portion of the error log from before an abrupt restart?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply