Infos sur cluster

**janlouk** · 01/12/2017, 08h36

Bonjour à tous,

Je n'ai pas dû souvent travailler sur des instances en cluster, mais je me pose une question.

Je suis sur un cluster, que je n'ai pas installé. On me demande d'installer SSIS dessus, je le fais et je suis cette procédure :
http://www.sqltechnet.com/2013/06/co...rver-2012.html

Tout fonctionne bien quand je force le basculement via Failover Cluster Manager, les services démarrent bien sur le noeud2 et s'arrêtent sur le noeud1.

Mais quand je vais dans Configuration manager sur le noeud2, que j'arrête mon service SQL Server (MSSQLSERVER), il ne rebascule pas vers le noeud1.

Est-ce normal? Ca vient du Quorum? Il n'est pas censé basculé quand il y a un problème avec un des services?

Merci pour vos lumières.

**mikedavem** · 06/12/2017, 17h55

Hello,

Tu as quelque chose dans les logs du cluster?

++

**janlouk** · 08/12/2017, 10h04

Non, malheureusement je n'ai rien dans l'Event viewer qui me donnerait une piste.

**mikedavem** · 08/12/2017, 11h02

Pas dans l'event viewer mais dans les logs du cluster (en passant par la console de gestion du cluster directement ou en utilisant la commande PowerShell Get-ClusterLog)

++

**janlouk** · 08/12/2017, 14h22

Le soucis, c'est que je n'ai pas de trace précise dans mes emails ou autres qui me donne le moment où j'ai fait ce test. Donc je ne sais pas trop quoi chercher dans ces nombreuses lignes.

J'ai pris quelques morceaux mais je ne pense pas que ça aide... Et le cluster va bientôt passer en production, je vais essayer de voir si je peux refaire la même manip et voir mieux le log.

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
0000072c.00000a08::2017/11/30-12:25:16.878 INFO  [GEM] Node 1: Deleting [2:7170 , 2:7170] (both included) as it has been ack'd by every node
00000f1c.00000ca0::2017/11/30-12:25:17.066 INFO  [RES] Physical Disk: PNP: \\?\SCSI#Disk&Ven_Msft&Prod_Virtual_Disk#000100#{53f56307-b6bf-11d0-94f2-00a0c91efb8b} disk arrived
00000f1c.00000ca0::2017/11/30-12:25:22.020 INFO  [RES] Physical Disk: PNP: \\?\STORAGE#Volume#{f0884180-5759-11e7-80cc-001dd8b71c46}#0000000000100000#{53f5630d-b6bf-11d0-94f2-00a0c91efb8b} volume arrived
00000f1c.00000ca0::2017/11/30-12:25:22.020 INFO  [RES] Physical Disk: PnpAddVolume: Adding volume \\?\STORAGE#Volume#{f0884180-5759-11e7-80cc-001dd8b71c46}#0000000000100000#{53f5630d-b6bf-11d0-94f2-00a0c91efb8b}
00000f1c.00000ca0::2017/11/30-12:25:22.020 INFO  [RES] Physical Disk: PnpAddVolume: Add Volume exit, status 34
00000f1c.00000ca0::2017/11/30-12:25:22.036 INFO  [RES] Physical Disk: PNP: \\?\STORAGE#Volume#{f0884180-5759-11e7-80cc-001dd8b71c46}#0000000015F00000#{53f5630d-b6bf-11d0-94f2-00a0c91efb8b} volume arrived
00000f1c.00000ca0::2017/11/30-12:25:22.036 INFO  [RES] Physical Disk: PnpAddVolume: Adding volume \\?\STORAGE#Volume#{f0884180-5759-11e7-80cc-001dd8b71c46}#0000000015F00000#{53f5630d-b6bf-11d0-94f2-00a0c91efb8b}
00000f1c.00000ca0::2017/11/30-12:25:22.036 INFO  [RES] Physical Disk: PnpAddVolume: Add Volume exit, status 34
0000072c.00000a08::2017/11/30-12:25:23.291 INFO  [GUM] Node 1: Processing RequestLock 2:7093
0000072c.00000a08::2017/11/30-12:25:23.291 INFO  [GUM] Node 1: Processing GrantLock to 2 (sent by 1 gumid: 81635)
0000072c.00000f00::2017/11/30-12:25:23.291 INFO  [GUM] Node 1: Executing locally gumId: 81636, updates: 1, first action: /dm/update
0000072c.00000a08::2017/11/30-12:25:24.291 INFO  [GEM] Node 1: Deleting [2:7171 , 2:7172] (both included) as it has been ack'd by every node
00000f1c.00000ca0::2017/11/30-12:25:30.901 INFO  [RES] Physical Disk: PNP: \\?\STORAGE#Volume#{f0884180-5759-11e7-80cc-001dd8b71c46}#0000000000100000#{53f5630d-b6bf-11d0-94f2-00a0c91efb8b} volume disappeared
00000f1c.00000ca0::2017/11/30-12:25:30.901 INFO  [RES] Physical Disk: PnpRemoveVolume: Removing volume \\?\STORAGE#Volume#{f0884180-5759-11e7-80cc-001dd8b71c46}#0000000000100000#{53f5630d-b6bf-11d0-94f2-00a0c91efb8b}
00000f1c.00000ca0::2017/11/30-12:25:30.901 INFO  [RES] Physical Disk: PNP: \\?\STORAGE#Volume#{f0884180-5759-11e7-80cc-001dd8b71c46}#0000000015F00000#{53f5630d-b6bf-11d0-94f2-00a0c91efb8b} volume disappeared
00000f1c.00000ca0::2017/11/30-12:25:30.901 INFO  [RES] Physical Disk: PnpRemoveVolume: Removing volume \\?\STORAGE#Volume#{f0884180-5759-11e7-80cc-001dd8b71c46}#0000000015F00000#{53f5630d-b6bf-11d0-94f2-00a0c91efb8b}
00000f1c.00000ca0::2017/11/30-12:25:30.964 INFO  [RES] Physical Disk: PNP: \\?\SCSI#Disk&Ven_Msft&Prod_Virtual_Disk#000100#{53f56307-b6bf-11d0-94f2-00a0c91efb8b} disk disappeared
0000072c.0000121c::2017/11/30-12:26:23.315 INFO  [GUM] Node 1: Executing locally gumId: 81637, updates: 1, first action: /dm/update
0000072c.00000a08::2017/11/30-12:26:24.318 INFO  [GEM] Node 1: Deleting [2:7173 , 2:7173] (both included) as it has been ack'd by every node
0000072c.00000f00::2017/11/30-12:26:36.419 INFO  [DCM] HandleSweeperRecheck
 
0000072c.0000138c::2017/11/30-12:33:50.432 ERR   mscs::TopologyPersister::TryGetNetworkPrivateProperties: (2)' because of 'OpenSubKey failed.'
0000072c.0000138c::2017/11/30-12:33:50.432 ERR   mscs::TopologyPersister::TryGetNetworkPrivateProperties: (2)' because of 'OpenSubKey failed.'
0000072c.0000138c::2017/11/30-12:33:50.432 ERR   mscs::TopologyPersister::TryGetNetworkPrivateProperties: (2)' because of 'OpenSubKey failed.'
0000072c.0000138c::2017/11/30-12:33:50.432 ERR   mscs::TopologyPersister::TryGetNetworkPrivateProperties: (2)' because of 'OpenSubKey failed.'
0000072c.0000121c::2017/11/30-12:33:50.494 ERR   mscs::TopologyPersister::TryGetNetworkPrivateProperties: (2)' because of 'OpenSubKey failed.'
0000072c.0000121c::2017/11/30-12:33:50.541 ERR   mscs::TopologyPersister::TryGetNetworkPrivateProperties: (2)' because of 'OpenSubKey failed.'
0000072c.0000121c::2017/11/30-12:33:50.573 ERR   mscs::TopologyPersister::TryGetNetworkPrivateProperties: (2)' because of 'OpenSubKey failed.'
0000072c.0000121c::2017/11/30-12:33:50.619 ERR   mscs::TopologyPersister::TryGetNetworkPrivateProperties: (2)' because of 'OpenSubKey failed.'
0000072c.0000138c::2017/11/30-12:33:51.326 WARN  [RCM] ResourceTypeChaseTheOwnerLoop::DoCall: ResType MSMQ's DLL is not present on this node.  Attempting to find a good node...
0000072c.0000138c::2017/11/30-12:33:51.326 WARN  [RCM] ResourceTypeChaseTheOwnerLoop::DoCall: ResType MSMQTriggers's DLL is not present on this node.  Attempting to find a good node...
0000072c.00000edc::2017/11/30-12:33:51.341 WARN  [RCM] ResourceTypeChaseTheOwnerLoop::DoCall: ResType MSMQ's DLL is not present on this node.  Attempting to find a good node...
0000072c.00000edc::2017/11/30-12:33:51.357 WARN  [RCM] ResourceTypeChaseTheOwnerLoop::DoCall: ResType MSMQTriggers's DLL is not present on this node.  Attempting to find a good node...
0000072c.0000138c::2017/11/30-12:33:51.482 WARN  [RCM] ResourceTypeChaseTheOwnerLoop::DoCall: ResType MSMQ's DLL is not present on this node.  Attempting to find a good node...
0000072c.0000138c::2017/11/30-12:33:51.497 WARN  [RCM] ResourceTypeChaseTheOwnerLoop::DoCall: ResType MSMQTriggers's DLL is not present on this node.  Attempting to find a good node...
0000072c.0000138c::2017/11/30-12:33:51.513 WARN  [RCM] ResourceTypeChaseTheOwnerLoop::DoCall: ResType MSMQ's DLL is not present on this node.  Attempting to find a good node...
0000072c.0000138c::2017/11/30-12:33:51.513 WARN  [RCM] ResourceTypeChaseTheOwnerLoop::DoCall: ResType MSMQTriggers's DLL is not present on this node.  Attempting to find a good node...
0000072c.00000edc::2017/11/30-12:33:51.654 WARN  [RCM] ResourceTypeChaseTheOwnerLoop::DoCall: ResType MSMQ's DLL is not present on this node.  Attempting to find a good node...
0000072c.00000edc::2017/11/30-12:33:51.654 WARN  [RCM] ResourceTypeChaseTheOwnerLoop::DoCall: ResType MSMQTriggers's DLL is not present on this node.  Attempting to find a good node...
0000072c.0000138c::2017/11/30-12:33:51.685 WARN  [RCM] ResourceTypeChaseTheOwnerLoop::DoCall: ResType MSMQ's DLL is not present on this node.  Attempting to find a good node...
0000072c.0000138c::2017/11/30-12:33:51.685 WARN  [RCM] ResourceTypeChaseTheOwnerLoop::DoCall: ResType MSMQTriggers's DLL is not present on this node.  Attempting to find a good node...
0000072c.0000121c::2017/11/30-12:33:51.826 WARN  [RCM] ResourceTypeChaseTheOwnerLoop::DoCall: ResType MSMQ's DLL is not present on this node.  Attempting to find a good node...
0000072c.0000121c::2017/11/30-12:33:51.826 WARN  [RCM] ResourceTypeChaseTheOwnerLoop::DoCall: ResType MSMQTriggers's DLL is not present on this node.  Attempting to find a good node...
0000072c.00000edc::2017/11/30-12:33:51.841 WARN  [RCM] ResourceTypeChaseTheOwnerLoop::DoCall: ResType MSMQ's DLL is not present on this node.  Attempting to find a good node...
0000072c.00000edc::2017/11/30-12:33:51.841 WARN  [RCM] ResourceTypeChaseTheOwnerLoop::DoCall: ResType MSMQTriggers's DLL is not present on this node.  Attempting to find a good node...
0000072c.00000edc::2017/11/30-12:33:51.966 WARN  [RCM] ResourceTypeChaseTheOwnerLoop::DoCall: ResType MSMQ's DLL is not present on this node.  Attempting to find a good node...
0000072c.00000edc::2017/11/30-12:33:51.966 WARN  [RCM] ResourceTypeChaseTheOwnerLoop::DoCall: ResType MSMQTriggers's DLL is not present on this node.  Attempting to find a good node...
0000072c.00000edc::2017/11/30-12:33:51.997 WARN  [RCM] ResourceTypeChaseTheOwnerLoop::DoCall: ResType MSMQ's DLL is not present on this node.  Attempting to find a good node...
0000072c.00000edc::2017/11/30-12:33:51.997 WARN  [RCM] ResourceTypeChaseTheOwnerLoop::DoCall: ResType MSMQTriggers's DLL is not present on this node.  Attempting to find a good node...
 
0000072c.0000121c::2017/11/30-12:34:23.414 INFO  [GUM] Node 1: Executing locally gumId: 81645, updates: 1, first action: /dm/update
0000072c.00000a08::2017/11/30-12:34:24.414 INFO  [GEM] Node 1: Deleting [2:7181 , 2:7181] (both included) as it has been ack'd by every node
0000072c.0000121c::2017/11/30-12:34:45.562 INFO  [VSS] OnIdentify - Version X-1.4 Component Name Cluster Database
0000072c.0000121c::2017/11/30-12:34:45.562 INFO  [VSS] OnIdentify - Add Files To File Group target path %WINDIR%\cluster\
0000072c.00000edc::2017/11/30-12:34:45.562 INFO  [CSVWRT] OnIdentify: version X-1.0, writer 'Cluster Shared Volume VSS Writer'
 
0000072c.00000edc::2017/11/30-12:49:23.238 INFO  [RCM] beginning task set inspection. Blockcontext priority=2000 gname=SQL Server (MSSQLSERVER)
0000072c.00000edc::2017/11/30-12:49:23.238 INFO  [RCM] moved 0 tasks from staging set to task set.  TaskSetSize=0
0000072c.00000edc::2017/11/30-12:49:23.238 INFO  [RCM] rcm::RcmPriorityManager::StartGroups: [RCM] done, executed 1 tasks
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM] SQL Server (MSSQLSERVER): Removed Flags 16 from StatusInformation. New StatusInformation 0
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM-rbtr] giving default token to group SQL Server (MSSQLSERVER)
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM] rcm::RcmResource::Online: bringing SQL Server Agent's provider resource 'SQL Server' online.
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM] rcm::RcmResource::Online: bringing SQL Server Agent's provider resource 'Cluster Disk - Database' online.
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM] rcm::RcmResource::Online: bringing SQL Server Agent's provider resource 'Cluster Disk - Log' online.
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM] rcm::RcmResource::Online: bringing SQL Server Agent's provider resource 'Cluster Disk - TempDB' online.
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM] rcm::RcmResource::Online: bringing SQL Server Agent's provider resource 'Cluster Disk - Backup' online.
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM] rcm::RcmResource::Online: bringing SQL Server Agent's provider resource 'SQL Network Name (C32XXXXX4)' online.
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM] rcm::RcmResource::Online: bringing SQL Server Agent's provider resource 'SQL IP Address 1 (C32XXXXX4)' online.
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM-rbtr] giving default token to group SQL Server (MSSQLSERVER)
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM] Res SQL IP Address 1 (C32XXXXX4): Offline -> OnlineCallIssued( StateUnknown )
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM] TransitionToState(SQL IP Address 1 (C32XXXXX4)) Offline-->OnlineCallIssued.
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM] rcm::RcmGroup::UpdateStateIfChanged: (SQL Server (MSSQLSERVER), BringingToPersistentState --> Pending)
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM-rbtr] giving default token to group SQL Server (MSSQLSERVER)
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM] Res SQL Network Name (C32XXXXX4): Offline -> WaitingToComeOnline( StateUnknown )
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM] TransitionToState(SQL Network Name (C32XXXXX4)) Offline-->WaitingToComeOnline.
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM-rbtr] giving default token to group SQL Server (MSSQLSERVER)
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM-rbtr] giving default token to group SQL Server (MSSQLSERVER)
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM-rbtr] giving default token to group SQL Server (MSSQLSERVER)
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM] Res Cluster Disk - Backup: Offline -> OnlineCallIssued( StateUnknown )
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM] TransitionToState(Cluster Disk - Backup) Offline-->OnlineCallIssued.
0000072c.0000095c::2017/11/30-12:49:23.238 INFO  [RCM] ignored non-local state Pending for group SQL Server (MSSQLSERVER)
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM-rbtr] giving default token to group SQL Server (MSSQLSERVER)
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM] Res Cluster Disk - TempDB: Offline -> OnlineCallIssued( StateUnknown )
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM] TransitionToState(Cluster Disk - TempDB) Offline-->OnlineCallIssued.
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM-rbtr] giving default token to group SQL Server (MSSQLSERVER)
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM] Res Cluster Disk - Log: Offline -> OnlineCallIssued( StateUnknown )
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM] TransitionToState(Cluster Disk - Log) Offline-->OnlineCallIssued.
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM-rbtr] giving default token to group SQL Server (MSSQLSERVER)
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM] Res Cluster Disk - Database: Offline -> OnlineCallIssued( StateUnknown )
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM] TransitionToState(Cluster Disk - Database) Offline-->OnlineCallIssued.
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM-rbtr] giving default token to group SQL Server (MSSQLSERVER)
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM] Res SQL Server: Offline -> WaitingToComeOnline( StateUnknown )
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM] TransitionToState(SQL Server) Offline-->WaitingToComeOnline.
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM-rbtr] giving default token to group SQL Server (MSSQLSERVER)
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM-rbtr] giving default token to group SQL Server (MSSQLSERVER)
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM-rbtr] giving default token to group SQL Server (MSSQLSERVER)
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM] Res SQL Server Agent: Offline -> WaitingToComeOnline( StateUnknown )
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM] TransitionToState(SQL Server Agent) Offline-->WaitingToComeOnline.
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM-rbtr] giving default token to group SQL Server (MSSQLSERVER)
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM-rbtr] giving default token to group SQL Server (MSSQLSERVER)
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM-rbtr] giving default token to group SQL Server (MSSQLSERVER)
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM] rcm::RcmResource::Online: File Server (\\C32XXXXX4)'s provider 'SQL Network Name (C32XXXXX4)' is already coming online (state is WaitingToComeOnline).
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM] rcm::RcmResource::Online: File Server (\\C32XXXXX4)'s provider 'SQL IP Address 1 (C32XXXXX4)' is already coming online (state is OnlineCallIssued).
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM] rcm::RcmResource::Online: File Server (\\C32XXXXX4)'s provider 'Cluster Disk - Backup' is already coming online (state is OnlineCallIssued).
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM] rcm::RcmResource::Online: File Server (\\C32XXXXX4)'s provider 'Cluster Disk - Database' is already coming online (state is OnlineCallIssued).

**mikedavem** · 09/12/2017, 18h44

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
 
0000072c.0000138c::2017/11/30-12:49:23.238 INFO  [RCM] TransitionToState(SQL Server) Offline-->WaitingToComeOnline.

La ressource SQL Server est dans un état transitoire et le gestionnaire de ressources est en train d'attendre qu'il soit en ligne.
Il faudrait avoir la suite en réalité pour comprendre ce qu'il s'est passé.

Très peu de chance que cela vienne du quorum car tu aurais un message dans ce sens.

++

Infos sur cluster [2014]

Administration SQL Server

Vue hybride

Discussions similaires

Partager

Partager