April 30, 2010 at 11:36 am
The SQL Server 2005 (MSSQLSERVER) Service Terminated unexpectedly.
I am running SQL Server 2005 SP2 in a Microsoft cluster.
Can anyone please shed some light on this for me?
April 30, 2010 at 11:43 am
jason.nodarse (4/30/2010)
The SQL Server 2005 (MSSQLSERVER) Service Terminated unexpectedly.I am running SQL Server 2005 SP2 in a Microsoft cluster.
Can anyone please shed some light on this for me?
Not without more information...
The system event log will provide details about other things that happend at around that time. The App Event log will be useful to. And finally, don't forget to look at the cluster.log file
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 30, 2010 at 11:45 am
I looked at the System amd Application log files and this is where I found the 7034 error. I have not looked at the cluster.log as of yet.
April 30, 2010 at 11:45 am
This is a very good tool for looking at the cluster log
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 30, 2010 at 11:50 am
jason.nodarse (4/30/2010)
I looked at the System amd Application log files and this is where I found the 7034 error. I have not looked at the cluster.log as of yet.
Could you paste the text of the error?
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 30, 2010 at 11:58 am
This is what I see in my Cluster.log
464:b24.04/27[01:52:26.169](000000) INFO [Qfs] QfsFindFirstFile \\6500OH-CLUSQL2\__NtBackup_cluster\* => 2649568, error 0
464:034.04/27[03:20:24.756](052939) WARN [LM] LogpReset:: deleting previous checkpoint file Z:\MSCS\chkCEBF.tmp
464:904.04/27[03:45:48.445](052939) ERR VSS: Got Component: 0x0026c438
464:904.04/27[03:45:48.445](052939) ERR VSS: Got component: Cluster Database
464:9fc.04/27[03:45:48.789](052939) INFO [Qfs] QfsFindFirstFile \\6500OH-CLUSQL1\__NtBackup_cluster\* => f1730, error 0
168:784.04/27[06:00:51.024](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 1 by Windows NT in attempt #-10. LastError = 170.
168:784.04/27[06:05:41.018](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 1 by Windows NT in attempt #-10. LastError = 170.
168:174.04/27[06:06:40.903](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 1 by Windows NT in attempt #-10. LastError = 170.
168:174.04/27[06:11:36.191](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 3 by Windows NT in attempt #-10. LastError = 170.
168:174.04/27[06:12:11.204](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 3 by Windows NT in attempt #-10. LastError = 170.
168:174.04/27[06:12:41.215](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 4 by Windows NT in attempt #-10. LastError = 170.
168:174.04/27[10:00:20.282](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 4 by Windows NT in attempt #-10. LastError = 170.
168:174.04/27[16:03:48.681](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 3 by Windows NT in attempt #-10. LastError = 170.
168:174.04/28[00:33:05.949](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 3 by Windows NT in attempt #-10. LastError = 170.
464:b50.04/28[01:57:57.843](052939) INFO [Qfs] QfsFindFirstFile \\6500OH-CLUSQL2\__NtBackup_cluster\* => f2998, error 0
464:6e0.04/28[03:52:31.539](052939) ERR VSS: Got Component: 0x0026c438
464:6e0.04/28[03:52:31.539](052939) ERR VSS: Got component: Cluster Database
464:904.04/28[03:52:32.024](052939) INFO [Qfs] QfsFindFirstFile \\6500OH-CLUSQL1\__NtBackup_cluster\* => f2998, error 0
168:174.04/28[04:05:38.696](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 4 by Windows NT in attempt #-10. LastError = 170.
168:174.04/28[06:01:15.094](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 2 by Windows NT in attempt #-10. LastError = 170.
168:174.04/28[06:02:50.389](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 1 by Windows NT in attempt #-10. LastError = 170.
168:174.04/28[06:03:25.498](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 1 by Windows NT in attempt #-10. LastError = 170.
168:784.04/28[06:03:45.888](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 1 by Windows NT in attempt #-10. LastError = 170.
168:174.04/28[06:04:10.669](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 4 by Windows NT in attempt #-10. LastError = 170.
168:174.04/28[06:06:46.135](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 2 by Windows NT in attempt #-10. LastError = 170.
168:174.04/28[06:08:11.414](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 4 by Windows NT in attempt #-10. LastError = 170.
168:784.04/28[06:11:20.880](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 1 by Windows NT in attempt #-10. LastError = 170.
168:174.04/28[06:11:32.004](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 3 by Windows NT in attempt #-10. LastError = 170.
168:784.04/28[06:11:35.879](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 1 by Windows NT in attempt #-10. LastError = 170.
168:174.04/28[06:13:52.439](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 3 by Windows NT in attempt #-10. LastError = 170.
168:174.04/28[06:15:32.750](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 3 by Windows NT in attempt #-10. LastError = 170.
168:174.04/28[06:16:32.936](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 3 by Windows NT in attempt #-10. LastError = 170.
168:174.04/28[21:20:02.434](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 3 by Windows NT in attempt #-10. LastError = 170.
464:a84.04/29[02:02:10.344](052939) INFO [Qfs] QfsFindFirstFile \\6500OH-CLUSQL2\__NtBackup_cluster\* => 14be68, error 0
464:738.04/29[04:11:29.168](052939) ERR VSS: Got Component: 0x0026c438
464:738.04/29[04:11:29.168](052939) ERR VSS: Got component: Cluster Database
464:ce4.04/29[04:11:29.450](052939) INFO [Qfs] QfsFindFirstFile \\6500OH-CLUSQL1\__NtBackup_cluster\* => 267fb50, error 0
168:174.04/29[05:15:26.657](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 3 by Windows NT in attempt #-10. LastError = 170.
168:174.04/29[06:01:45.260](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 3 by Windows NT in attempt #-10. LastError = 170.
168:784.04/29[06:02:10.760](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 1 by Windows NT in attempt #-10. LastError = 170.
168:174.04/29[06:02:50.462](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 3 by Windows NT in attempt #-10. LastError = 170.
168:174.04/29[06:03:35.602](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 1 by Windows NT in attempt #-10. LastError = 170.
168:174.04/29[06:03:38.102](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 3 by Windows NT in attempt #-10. LastError = 170.
168:174.04/29[06:04:15.773](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 3 by Windows NT in attempt #-10. LastError = 170.
168:174.04/29[06:05:05.944](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 4 by Windows NT in attempt #-10. LastError = 170.
168:174.04/29[06:05:10.944](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 4 by Windows NT in attempt #-10. LastError = 170.
168:174.04/29[06:06:41.223](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 3 by Windows NT in attempt #-10. LastError = 170.
168:174.04/29[06:08:41.596](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 1 by Windows NT in attempt #-10. LastError = 170.
168:784.04/29[06:09:15.751](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 1 by Windows NT in attempt #-10. LastError = 170.
168:784.04/29[06:09:55.751](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 1 by Windows NT in attempt #-10. LastError = 170.
168:174.04/29[06:11:32.124](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 3 by Windows NT in attempt #-10. LastError = 170.
168:174.04/29[06:12:32.310](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 3 by Windows NT in attempt #-10. LastError = 170.
168:174.04/29[06:16:28.040](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 3 by Windows NT in attempt #-10. LastError = 170.
168:174.04/29[12:10:23.882](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 3 by Windows NT in attempt #-10. LastError = 170.
168:174.04/29[15:57:36.922](052939) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 1 by Windows NT in attempt #-10. LastError = 170.
168:174.04/29[17:20:12.265](052947) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 1 by Windows NT in attempt #-10. LastError = 170.
464:034.04/29[19:20:23.876](052947) WARN [LM] LogpReset:: deleting previous checkpoint file Z:\MSCS\chkCEC7.tmp
464:9c0.04/30[01:56:25.446](052947) INFO [Qfs] QfsFindFirstFile \\6500OH-CLUSQL2\__NtBackup_cluster\* => 267bce8, error 0
464:7e8.04/30[03:50:31.330](052947) ERR VSS: Got Component: 0x0026c438
464:7e8.04/30[03:50:31.330](052947) ERR VSS: Got component: Cluster Database
464:7e4.04/30[03:50:31.768](052947) INFO [Qfs] QfsFindFirstFile \\6500OH-CLUSQL1\__NtBackup_cluster\* => 267bce8, error 0
168:174.04/30[04:07:13.452](052947) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 4 by Windows NT in attempt #-10. LastError = 170.
168:174.04/30[04:12:44.352](052947) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 4 by Windows NT in attempt #-10. LastError = 170.
168:174.04/30[04:18:45.501](052947) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 4 by Windows NT in attempt #-10. LastError = 170.
168:174.04/30[04:22:16.372](052947) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 4 by Windows NT in attempt #-10. LastError = 170.
168:174.04/30[06:01:04.477](052947) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 2 by Windows NT in attempt #-10. LastError = 170.
168:174.04/30[06:01:49.617](052947) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 1 by Windows NT in attempt #-10. LastError = 170.
168:784.04/30[06:06:05.112](052947) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 1 by Windows NT in attempt #-10. LastError = 170.
168:174.04/30[06:06:50.548](052947) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 3 by Windows NT in attempt #-10. LastError = 170.
168:174.04/30[06:07:35.688](052947) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 3 by Windows NT in attempt #-10. LastError = 170.
168:784.04/30[06:11:05.106](052947) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 1 by Windows NT in attempt #-10. LastError = 170.
168:174.04/30[06:11:46.465](052947) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 3 by Windows NT in attempt #-10. LastError = 170.
168:174.04/30[06:15:52.226](052947) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 3 by Windows NT in attempt #-10. LastError = 170.
168:174.04/30[06:17:12.474](052947) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 3 by Windows NT in attempt #-10. LastError = 170.
168:174.04/30[06:17:37.552](052947) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 3 by Windows NT in attempt #-10. LastError = 170.
168:174.04/30[06:17:40.052](052947) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 3 by Windows NT in attempt #-9. LastError = 170.
168:784.04/30[15:21:09.962](052947) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 1 by Windows NT in attempt #-10. LastError = 170.
220:0fc.04/30[15:41:30.532](052947) ERR SQL Server <SQL Server>: [sqsrvres] CheckServiceAlive: Service is dead
220:0fc.04/30[15:41:30.532](052947) ERR SQL Server <SQL Server>: [sqsrvres] CheckServiceAlive: Service is dead
220:0fc.04/30[15:41:30.532](052947) ERR SQL Server <SQL Server>: [sqsrvres] OnlineThread: service stopped while waiting for QP.
220:0fc.04/30[15:41:30.579](052947) ERR SQL Server <SQL Server>: [sqsrvres] OnlineThread: Error 1 bringing resource online.
220:22c.04/30[15:41:33.673](052947) ERR SQL Server <SQL Server>: [sqsrvres] CheckServiceAlive: Service is dead
464:030.04/30[15:41:33.704](052947) WARN [FM] FmpHandleResourceTransition: Resource Name = feb63f41-3d61-4b1b-b685-58da3ea4d4a6 [SQL Server] old state=2 new state=4
220:9d0.04/30[15:41:33.704](052948) ERR SQL Server <SQL Server>: [sqsrvres] CheckServiceAlive: Service is dead
168:174.04/30[15:45:13.887](052954) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 1 by Windows NT in attempt #-10. LastError = 170.
168:784.04/30[15:51:49.927](052954) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 1 by Windows NT in attempt #-10. LastError = 170.
168:174.04/30[16:10:17.969](000464) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 1 by Windows NT in attempt #-10. LastError = 170.
April 30, 2010 at 12:03 pm
The Primary Server is the 6500oh-CLUSQL1 server I think all these errors in the cluster.log are from the CLUSQL2 server and not from the one that is currently active.
April 30, 2010 at 12:08 pm
This is the primary piece of the log file that has the issue in question.
464:7e4.04/30[03:50:31.768](052947) INFO [Qfs] QfsFindFirstFile \\6500OH-CLUSQL1\__NtBackup_cluster\* => 267bce8, error 0
168:174.04/30[04:07:13.452](052947) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 4 by Windows NT in attempt #-10. LastError = 170.
168:174.04/30[04:12:44.352](052947) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 4 by Windows NT in attempt #-10. LastError = 170.
168:174.04/30[04:18:45.501](052947) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 4 by Windows NT in attempt #-10. LastError = 170.
168:174.04/30[04:22:16.372](052947) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 4 by Windows NT in attempt #-10. LastError = 170.
168:174.04/30[06:01:04.477](052947) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 2 by Windows NT in attempt #-10. LastError = 170.
168:174.04/30[06:01:49.617](052947) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 1 by Windows NT in attempt #-10. LastError = 170.
168:784.04/30[06:06:05.112](052947) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 1 by Windows NT in attempt #-10. LastError = 170.
168:174.04/30[06:06:50.548](052947) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 3 by Windows NT in attempt #-10. LastError = 170.
168:174.04/30[06:07:35.688](052947) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 3 by Windows NT in attempt #-10. LastError = 170.
168:784.04/30[06:11:05.106](052947) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 1 by Windows NT in attempt #-10. LastError = 170.
168:174.04/30[06:11:46.465](052947) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 3 by Windows NT in attempt #-10. LastError = 170.
168:174.04/30[06:15:52.226](052947) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 3 by Windows NT in attempt #-10. LastError = 170.
168:174.04/30[06:17:12.474](052947) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 3 by Windows NT in attempt #-10. LastError = 170.
168:174.04/30[06:17:37.552](052947) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 3 by Windows NT in attempt #-10. LastError = 170.
168:174.04/30[06:17:40.052](052947) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 3 by Windows NT in attempt #-9. LastError = 170.
168:784.04/30[15:21:09.962](052947) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 1 by Windows NT in attempt #-10. LastError = 170.
220:0fc.04/30[15:41:30.532](052947) ERR SQL Server <SQL Server>: [sqsrvres] CheckServiceAlive: Service is dead
220:0fc.04/30[15:41:30.532](052947) ERR SQL Server <SQL Server>: [sqsrvres] CheckServiceAlive: Service is dead
220:0fc.04/30[15:41:30.532](052947) ERR SQL Server <SQL Server>: [sqsrvres] OnlineThread: service stopped while waiting for QP.
220:0fc.04/30[15:41:30.579](052947) ERR SQL Server <SQL Server>: [sqsrvres] OnlineThread: Error 1 bringing resource online.
220:22c.04/30[15:41:33.673](052947) ERR SQL Server <SQL Server>: [sqsrvres] CheckServiceAlive: Service is dead
464:030.04/30[15:41:33.704](052947) WARN [FM] FmpHandleResourceTransition: Resource Name = feb63f41-3d61-4b1b-b685-58da3ea4d4a6 [SQL Server] old state=2 new state=4
220:9d0.04/30[15:41:33.704](052948) ERR SQL Server <SQL Server>: [sqsrvres] CheckServiceAlive: Service is dead
168:174.04/30[15:45:13.887](052954) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 1 by Windows NT in attempt #-10. LastError = 170.
168:784.04/30[15:51:49.927](052954) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 1 by Windows NT in attempt #-10. LastError = 170.
168:174.04/30[16:10:17.969](000464) ERR ServeRAID Logical Disk: IPSHAReadVerify FAILED on merge id - 1 by Windows NT in attempt #-10. LastError = 170.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply