Post reply

Problem starting SQL - cpu 100% etc HELP!

  • May 7, 2009 at 1:52 am

    #384519

    Morning all (running SQL 2005)

    We had a problem yesterday with the c: drive of one of our database servers filling up. It now transpired that it was due to a massive error.log file which was in turn due to millions of the following messages (see below).

    Basically, when I start the server it all looks ok until it gets to a db called dbIWJRegister). At this point, the log starts to grow fast (300Mb in one hour) and sqlservr.exe hits 100% pretty much constantly. The server grineds to a halt and I have no option but to kill the process.

    So, it's a long shot but does anyone know what the below messages mean?

    And.... is there a way to tell SQL to just ingore this db on startup?

    Many thanks in advance

    Farren Minns

    Error">-8470Remote service has been dropped.'.

    2009-05-06 16:15:12.37 spid57s The query notification dialog on conversation handle '{2B9AD11F-3233-DE11-8FA6-0003FF86447F}.' closed due to the following error: '-8470Remote service has been dropped.'.

    2009-05-06 16:15:12.37 spid61s The query notification dialog on conversation handle '{B3448C8B-D633-DE11-8FA6-0003FF86447F}.' closed due to the following error: '-8470Remote service has been dropped.'.

    2009-05-06 16:15:12.38 spid52s The activated proc [Member].[SqlQueryNotificationStoredProcedure-b10492d6-4af2-4ec0-9f07-0bbc36ce170c] running on queue dbIWJRegister.Member.SqlQueryNotificationService-b10492d6-4af2-4ec0-9f07-0bbc36ce170c output the following: 'Cannot drop the queue 'SqlQueryNotificationService-b10492d6-4af2-4ec0-9f07-0bbc36ce170c', because it does not exist or you do not have permission.'

    2009-05-06 16:15:12.39 spid54s The activated proc [Member].[SqlQueryNotificationStoredProcedure-779ffc80-ecbd-4924-9edb-c044675c525f] running on queue dbIWJRegister.Member.SqlQueryNotificationService-779ffc80-ecbd-4924-9edb-c044675c525f output the following: 'Cannot drop the queue 'SqlQueryNotificationService-779ffc80-ecbd-4924-9edb-c044675c525f', because it does not exist or you do not have permission.'

    2009-05-06 16:15:12.39 spid62s The query notification dialog on conversation handle '{B95D6C78-D833-DE11-8FA6-0003FF86447F}.' closed due to the following error: '-8470Remote service has been dropped.'.

    2009-05-06 16:15:12.39 spid61s The activated proc [Member].[SqlQueryNotificationStoredProcedure-df4a4422-c1f6-44cb-8b8d-0eaeee9b605a] running on queue dbIWJRegister.Member.SqlQueryNotificationService-df4a4422-c1f6-44cb-8b8d-0eaeee9b605a output the following: 'Cannot drop the queue 'SqlQueryNotificationService-df4a4422-c1f6-44cb-8b8d-0eaeee9b605a', because it does not exist or you do not have permission.'

    2009-05-06 16:15:12.39 spid57s The activated proc [Member].[SqlQueryNotificationStoredProcedure-b1f05aba-58ff-4063-899c-a771f0e16fd1] running on queue dbIWJRegister.Member.SqlQueryNotificationService-b1f05aba-58ff-4063-899c-a771f0e16fd1 output the following: 'Cannot drop the queue 'SqlQueryNotificationService-b1f05aba-58ff-4063-899c-a771f0e16fd1', because it does not exist or you do not have permission.'

    2009-05-06 16:15:12.40 spid52s The query notification dialog on conversation handle '{C345A212-D833-DE11-8FA6-0003FF86447F}.' closed due to the following error: '-8470Remote service has been dropped.'.

    2009-05-06 16:15:12.40 spid62s The activated proc [Member].[SqlQueryNotificationStoredProcedure-64a5855d-3d3c-413f-984a-0288c9dd465f] running on queue dbIWJRegister.Member.SqlQueryNotificationService-64a5855d-3d3c-413f-984a-0288c9dd465f output the following: 'Cannot drop the queue 'SqlQueryNotificationService-64a5855d-3d3c-413f-984a-0288c9dd465f', because it does not exist or you do not have permission.'

    2009-05-06 16:15:12.40 spid54s The query notification dialog on conversation handle '{215D13DC-3D33-DE11-8FA6-0003FF86447F}.' closed due to the following error: '-8470Remote service has been dropped.'.

    2009-05-06 16:15:12.40 spid61s The query notification dialog on conversation handle '{B3448C8B-D633-DE11-8FA6-0003FF86447F}.' closed due to the following error: '-8470Remote service has been dropped.'.

    2009-05-06 16:15:12.41 spid52s The activated proc [Member].[SqlQueryNotificationStoredProcedure-b10492d6-4af2-4ec0-9f07-0bbc36ce170c] running on queue dbIWJRegister.Member.SqlQueryNotificationService-b10492d6-4af2-4ec0-9f07-0bbc36ce170c output the following: 'Cannot drop the queue 'SqlQueryNotificationService-b10492d6-4af2-4ec0-9f07-0bbc36ce170c', because it does not exist or you do not have permission.'

    2009-05-06 16:15:12.42 spid61s The activated proc [Member].[SqlQueryNotificationStoredProcedure-df4a4422-c1f6-44cb-8b8d-0eaeee9b605a] running on queue dbIWJRegister.Member.SqlQueryNotificationService-df4a4422-c1f6-44cb-8b8d-0eaeee9b605a output the following: 'Cannot drop the queue 'SqlQueryNotificationService-df4a4422-c1f6-44cb-8b8d-0eaeee9b605a', because it does not exist or you do not have permission.'

    2009-05-06 16:15:12.43 spid57s The query notification dialog on conversation handle '{2B9AD11F-3233-DE11-8FA6-0003FF86447F}.' closed due to the following error: '-8470Remote service has been dropped.'.

    2009-05-06 16:15:12.43 spid54s The activated proc [Member].[SqlQueryNotificationStoredProcedure-779ffc80-ecbd-4924-9edb-c044675c525f] running on queue dbIWJRegister.Member.SqlQueryNotificationService-779ffc80-ecbd-4924-9edb-c044675c525f output the following: 'Cannot drop the queue 'SqlQueryNotificationService-779ffc80-ecbd-4924-9edb-c044675c525f', because it does not exist or you do not have permission.'

    2009-05-06 16:15:12.43 spid62s The query notification dialog on conversation handle '{B95D6C78-D833-DE11-8FA6-0003FF86447F}.' closed due to the following error: '-8470Remote service has been dropped.'.

    2009-05-06 16:15:12.43 spid57s The activated proc [Member].[SqlQueryNotificationStoredProcedure-b1f05aba-58ff-4063-899c-a771f0e16fd1] running on queue dbIWJRegister.Member.SqlQueryNotificationService-b1f05aba-58ff-4063-899c-a771f0e16fd1 output the following: 'Cannot drop the queue 'SqlQueryNotificationService-b1f05aba-58ff-4063-899c-a771f0e16fd1', because it does not exist or you do not have permission.'

    2009-05-06 16:15:12.44 spid52s The query notification dialog on conversation handle '{C345A212-D833-DE11-8FA6-0003FF86447F}.' closed due to the following error: '-8470Remote service has been dropped.'.

    2009-05-06 16:15:12.44 spid54s The query notification dialog on conversation handle '{B3448C8B-D633-DE11-8FA6-0003FF86447F}.' closed due to the following error: '-8470Remote service has been dropped.'.

    2009-05-06 16:15:12.45 spid61s The query notification dialog on conversation handle '{215D13DC-3D33-DE11-8FA6-0003FF86447F}.' closed due to the following error: '-8470Remote service has been dropped.'.

    2009-05-06 16:15:12.45 spid62s The activated proc [Member].[SqlQueryNotificationStoredProcedure-64a5855d-3d3c-413f-984a-0288c9dd465f] running on queue dbIWJRegister.Member.SqlQueryNotificationService-64a5855d-3d3c-413f-984a-0288c9dd465f output the following: 'Cannot drop the queue 'SqlQueryNotificationService-64a5855d-3d3c-413f-984a-0288c9dd465f', because it does not exist or you do not have permission.'

    2009-05-06 16:15:12.46 spid52s The activated proc [Member].[SqlQueryNotificationStoredProcedure-b10492d6-4af2-4ec0-9f07-0bbc36ce170c] running on queue dbIWJRegister.Member.SqlQueryNotificationService-b10492d6-4af2-4ec0-9f07-0bbc36ce170c output the following: 'Cannot drop the queue 'SqlQueryNotificationService-b10492d6-4af2-4ec0-9f07-0bbc36ce170c', because it does not exist or you do not have permission.'

    2009-05-06 16:15:12.46 spid54s The activated proc [Member].[SqlQueryNotificationStoredProcedure-df4a4422-c1f6-44cb-8b8d-0eaeee9b605a] running on queue dbIWJRegister.Member.SqlQueryNotificationService-df4a4422-c1f6-44cb-8b8d-0eaeee9b605a output the following: 'Cannot drop the queue 'SqlQueryNotificationService-df4a4422-c1f6-44cb-8b8d-0eaeee9b605a', because it does not exist or you do not have permission.'

    2009-05-06 16:15:12.46 spid57s The query notification dialog on conversation handle '{2B9AD11F-3233-DE11-8FA6-0003FF86447F}.' closed due to the following error: '-8470Remote service has been dropped.'.

    2009-05-06 16:15:12.46 spid61s The activated proc [Member].[SqlQueryNotificationStoredProcedure-779ffc80-ecbd-4924-9edb-c044675c525f] running on queue dbIWJRegister.Member.SqlQueryNotificationService-779ffc80-ecbd-4924-9edb-c044675c525f output the following: 'Cannot drop the queue 'SqlQueryNotificationService-779ffc80-ecbd-4924-9edb-c044675c525f', because it does not exist or you do not have permission.'

    2009-05-06 16:15:12.47 spid57s The activated proc [Member].[SqlQueryNotificationStoredProcedure-b1f05aba-58ff-4063-899c-a771f0e16fd1] running on queue dbIWJRegister.Member.SqlQueryNotificationService-b1f05aba-58ff-4063-899c-a771f0e16fd1 output the following: 'Cannot drop the queue 'SqlQueryNotificationService-b1f05aba-58ff-4063-899c-a771f0e16fd1', because it does not exist or you do not have permission.'

    2009-05-06 16:15:12.48 spid52s The query notification dialog on conversation handle '{B95D6C78-D833-DE11-8FA6-0003FF86447F}.' closed due to the following error: '-8470Remote service has been dropped.'.

    2009-05-06 16:15:12.48 spid54s The query notification dialog on conversation handle '{B3448C8B-D633-DE11-8FA6-0003FF86447F}.' closed due to the following error: '-8470Remote service has been dropped.'.

    2009-05-06 16:15:12.49 spid62s The query notification dialog on conversation handle '{C345A212-D833-DE11-8FA6-0003FF86447F}.' closed due to the following error: '-8470Remote service has been dropped.'.

  • May 7, 2009 at 2:21 am

    #990178

    Actually I just found this..

    http://rusanu.com/2007/11/10/when-it-rains-it-pours/

    I have forwarded it to the application development team.

Viewing 2 posts - 1 through 1 (of 1 total)

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