[sql] pcs

Viewer

  1. /* CREATE TABLE */
  2. CREATE TABLE pcs_stst(
  3. `summarystack_type` VARCHAR(100),
  4. `summarycurrent_dc_present` VARCHAR(100),
  5. `summarycurrent_dc_version` VARCHAR(100),
  6. `summarycurrent_dc_name` VARCHAR(100),
  7. `summarycurrent_dc_id` DOUBLE,
  8. `summarycurrent_dc_with_quorum` VARCHAR(100),
  9. `summarylast_update_time` VARCHAR(100),
  10. `summarylast_change_time` VARCHAR(100),
  11. `summarylast_change_user` VARCHAR(100),
  12. `summarylast_change_client` VARCHAR(100),
  13. `summarylast_change_origin` VARCHAR(100),
  14. `summarynodes_configured_number` DOUBLE,
  15. `summaryresources_configured_number` DOUBLE,
  16. `summaryresources_configured_disabled` DOUBLE,
  17. `summaryresources_configured_blocked` DOUBLE,
  18. `summarycluster_options_stonithenabled` VARCHAR(100),
  19. `summarycluster_options_symmetriccluster` VARCHAR(100),
  20. `summarycluster_options_noquorumpolicy` VARCHAR(100),
  21. `summarycluster_options_maintenancemode` VARCHAR(100),
  22. `nodesnode0_name` VARCHAR(100),
  23. `nodesnode0_id` DOUBLE,
  24. `nodesnode0_online` VARCHAR(100),
  25. `nodesnode0_standby` VARCHAR(100),
  26. `nodesnode0_standby_onfail` VARCHAR(100),
  27. `nodesnode0_maintenance` VARCHAR(100),
  28. `nodesnode0_pending` VARCHAR(100),
  29. `nodesnode0_unclean` VARCHAR(100),
  30. `nodesnode0_shutdown` VARCHAR(100),
  31. `nodesnode0_expected_up` VARCHAR(100),
  32. `nodesnode0_is_dc` VARCHAR(100),
  33. `nodesnode0_resources_running` DOUBLE,
  34. `nodesnode0_type` VARCHAR(100),
  35. `nodesnode1_name` VARCHAR(100),
  36. `nodesnode1_id` DOUBLE,
  37. `nodesnode1_online` VARCHAR(100),
  38. `nodesnode1_standby` VARCHAR(100),
  39. `nodesnode1_standby_onfail` VARCHAR(100),
  40. `nodesnode1_maintenance` VARCHAR(100),
  41. `nodesnode1_pending` VARCHAR(100),
  42. `nodesnode1_unclean` VARCHAR(100),
  43. `nodesnode1_shutdown` VARCHAR(100),
  44. `nodesnode1_expected_up` VARCHAR(100),
  45. `nodesnode1_is_dc` VARCHAR(100),
  46. `nodesnode1_resources_running` DOUBLE,
  47. `nodesnode1_type` VARCHAR(100),
  48. `resourcesresource0node_name` VARCHAR(100),
  49. `resourcesresource0node_id` DOUBLE,
  50. `resourcesresource0node_cached` VARCHAR(100),
  51. `resourcesresource0_id` VARCHAR(100),
  52. `resourcesresource0_resource_agent` VARCHAR(100),
  53. `resourcesresource0_role` VARCHAR(100),
  54. `resourcesresource0_active` VARCHAR(100),
  55. `resourcesresource0_orphaned` VARCHAR(100),
  56. `resourcesresource0_blocked` VARCHAR(100),
  57. `resourcesresource0_managed` VARCHAR(100),
  58. `resourcesresource0_failed` VARCHAR(100),
  59. `resourcesresource0_failure_ignored` VARCHAR(100),
  60. `resourcesresource0_nodes_running_on` DOUBLE,
  61. `resourcesresource1node_name` VARCHAR(100),
  62. `resourcesresource1node_id` DOUBLE,
  63. `resourcesresource1node_cached` VARCHAR(100),
  64. `resourcesresource1_id` VARCHAR(100),
  65. `resourcesresource1_resource_agent` VARCHAR(100),
  66. `resourcesresource1_role` VARCHAR(100),
  67. `resourcesresource1_active` VARCHAR(100),
  68. `resourcesresource1_orphaned` VARCHAR(100),
  69. `resourcesresource1_blocked` VARCHAR(100),
  70. `resourcesresource1_managed` VARCHAR(100),
  71. `resourcesresource1_failed` VARCHAR(100),
  72. `resourcesresource1_failure_ignored` VARCHAR(100),
  73. `resourcesresource1_nodes_running_on` DOUBLE,
  74. `resourcesclone0resource0node_name` VARCHAR(100),
  75. `resourcesclone0resource0node_id` DOUBLE,
  76. `resourcesclone0resource0node_cached` VARCHAR(100),
  77. `resourcesclone0resource0_id` VARCHAR(100),
  78. `resourcesclone0resource0_resource_agent` VARCHAR(100),
  79. `resourcesclone0resource0_role` VARCHAR(100),
  80. `resourcesclone0resource0_active` VARCHAR(100),
  81. `resourcesclone0resource0_orphaned` VARCHAR(100),
  82. `resourcesclone0resource0_blocked` VARCHAR(100),
  83. `resourcesclone0resource0_managed` VARCHAR(100),
  84. `resourcesclone0resource0_failed` VARCHAR(100),
  85. `resourcesclone0resource0_failure_ignored` VARCHAR(100),
  86. `resourcesclone0resource0_nodes_running_on` DOUBLE,
  87. `resourcesclone0resource1node_name` VARCHAR(100),
  88. `resourcesclone0resource1node_id` DOUBLE,
  89. `resourcesclone0resource1node_cached` VARCHAR(100),
  90. `resourcesclone0resource1_id` VARCHAR(100),
  91. `resourcesclone0resource1_resource_agent` VARCHAR(100),
  92. `resourcesclone0resource1_role` VARCHAR(100),
  93. `resourcesclone0resource1_active` VARCHAR(100),
  94. `resourcesclone0resource1_orphaned` VARCHAR(100),
  95. `resourcesclone0resource1_blocked` VARCHAR(100),
  96. `resourcesclone0resource1_managed` VARCHAR(100),
  97. `resourcesclone0resource1_failed` VARCHAR(100),
  98. `resourcesclone0resource1_failure_ignored` VARCHAR(100),
  99. `resourcesclone0resource1_nodes_running_on` DOUBLE,
  100. `resourcesclone0_id` VARCHAR(100),
  101. `resourcesclone0_multi_state` VARCHAR(100),
  102. `resourcesclone0_unique` VARCHAR(100),
  103. `resourcesclone0_managed` VARCHAR(100),
  104. `resourcesclone0_failed` VARCHAR(100),
  105. `resourcesclone0_failure_ignored` VARCHAR(100),
  106. `resourcesclone1resource0node_name` VARCHAR(100),
  107. `resourcesclone1resource0node_id` DOUBLE,
  108. `resourcesclone1resource0node_cached` VARCHAR(100),
  109. `resourcesclone1resource0_id` VARCHAR(100),
  110. `resourcesclone1resource0_resource_agent` VARCHAR(100),
  111. `resourcesclone1resource0_role` VARCHAR(100),
  112. `resourcesclone1resource0_active` VARCHAR(100),
  113. `resourcesclone1resource0_orphaned` VARCHAR(100),
  114. `resourcesclone1resource0_blocked` VARCHAR(100),
  115. `resourcesclone1resource0_managed` VARCHAR(100),
  116. `resourcesclone1resource0_failed` VARCHAR(100),
  117. `resourcesclone1resource0_failure_ignored` VARCHAR(100),
  118. `resourcesclone1resource0_nodes_running_on` DOUBLE,
  119. `resourcesclone1resource1node_name` VARCHAR(100),
  120. `resourcesclone1resource1node_id` DOUBLE,
  121. `resourcesclone1resource1node_cached` VARCHAR(100),
  122. `resourcesclone1resource1_id` VARCHAR(100),
  123. `resourcesclone1resource1_resource_agent` VARCHAR(100),
  124. `resourcesclone1resource1_role` VARCHAR(100),
  125. `resourcesclone1resource1_active` VARCHAR(100),
  126. `resourcesclone1resource1_orphaned` VARCHAR(100),
  127. `resourcesclone1resource1_blocked` VARCHAR(100),
  128. `resourcesclone1resource1_managed` VARCHAR(100),
  129. `resourcesclone1resource1_failed` VARCHAR(100),
  130. `resourcesclone1resource1_failure_ignored` VARCHAR(100),
  131. `resourcesclone1resource1_nodes_running_on` DOUBLE,
  132. `resourcesclone1_id` VARCHAR(100),
  133. `resourcesclone1_multi_state` VARCHAR(100),
  134. `resourcesclone1_unique` VARCHAR(100),
  135. `resourcesclone1_managed` VARCHAR(100),
  136. `resourcesclone1_failed` VARCHAR(100),
  137. `resourcesclone1_failure_ignored` VARCHAR(100),
  138. `node_attributesnode0attribute0_name` VARCHAR(100),
  139. `node_attributesnode0attribute0_value` VARCHAR(100),
  140. `node_attributesnode0attribute1_name` VARCHAR(100),
  141. `node_attributesnode0attribute1_value` VARCHAR(100),
  142. `node_attributesnode0attribute2_name` VARCHAR(100),
  143. `node_attributesnode0attribute2_value` VARCHAR(100),
  144. `node_attributesnode0attribute3_name` VARCHAR(100),
  145. `node_attributesnode0attribute3_value` VARCHAR(100),
  146. `node_attributesnode0attribute4_name` VARCHAR(100),
  147. `node_attributesnode0attribute4_value` VARCHAR(100),
  148. `node_attributesnode0attribute5_name` VARCHAR(100),
  149. `node_attributesnode0attribute5_value` VARCHAR(100),
  150. `node_attributesnode0attribute6_name` VARCHAR(100),
  151. `node_attributesnode0attribute6_value` VARCHAR(100),
  152. `node_attributesnode0attribute7_name` VARCHAR(100),
  153. `node_attributesnode0attribute7_value` VARCHAR(100),
  154. `node_attributesnode0attribute8_name` VARCHAR(100),
  155. `node_attributesnode0attribute8_value` VARCHAR(100),
  156. `node_attributesnode0attribute9_name` VARCHAR(100),
  157. `node_attributesnode0attribute9_value` DOUBLE,
  158. `node_attributesnode0attribute10_name` VARCHAR(100),
  159. `node_attributesnode0attribute10_value` DOUBLE,
  160. `node_attributesnode0_name` VARCHAR(100),
  161. `node_attributesnode1attribute0_name` VARCHAR(100),
  162. `node_attributesnode1attribute0_value` VARCHAR(100),
  163. `node_attributesnode1attribute1_name` VARCHAR(100),
  164. `node_attributesnode1attribute1_value` VARCHAR(100),
  165. `node_attributesnode1attribute2_name` VARCHAR(100),
  166. `node_attributesnode1attribute2_value` VARCHAR(100),
  167. `node_attributesnode1attribute3_name` VARCHAR(100),
  168. `node_attributesnode1attribute3_value` VARCHAR(100),
  169. `node_attributesnode1attribute4_name` VARCHAR(100),
  170. `node_attributesnode1attribute4_value` VARCHAR(100),
  171. `node_attributesnode1attribute5_name` VARCHAR(100),
  172. `node_attributesnode1attribute5_value` VARCHAR(100),
  173. `node_attributesnode1attribute6_name` VARCHAR(100),
  174. `node_attributesnode1attribute6_value` VARCHAR(100),
  175. `node_attributesnode1attribute7_name` VARCHAR(100),
  176. `node_attributesnode1attribute7_value` VARCHAR(100),
  177. `node_attributesnode1attribute8_name` VARCHAR(100),
  178. `node_attributesnode1attribute8_value` VARCHAR(100),
  179. `node_attributesnode1attribute9_name` VARCHAR(100),
  180. `node_attributesnode1attribute9_value` DOUBLE,
  181. `node_attributesnode1attribute10_name` VARCHAR(100),
  182. `node_attributesnode1attribute10_value` DOUBLE,
  183. `node_attributesnode1_name` VARCHAR(100),
  184. `node_historynode0resource_history0operation_history0_call` DOUBLE,
  185. `node_historynode0resource_history0operation_history0_task` VARCHAR(100),
  186. `node_historynode0resource_history0operation_history0_lastrcchange` VARCHAR(100),
  187. `node_historynode0resource_history0operation_history0_lastrun` VARCHAR(100),
  188. `node_historynode0resource_history0operation_history0_exectime` VARCHAR(100),
  189. `node_historynode0resource_history0operation_history0_queuetime` VARCHAR(100),
  190. `node_historynode0resource_history0operation_history0_rc` DOUBLE,
  191. `node_historynode0resource_history0operation_history0_rc_text` VARCHAR(100),
  192. `node_historynode0resource_history0operation_history1_call` DOUBLE,
  193. `node_historynode0resource_history0operation_history1_task` VARCHAR(100),
  194. `node_historynode0resource_history0operation_history1_interval` VARCHAR(100),
  195. `node_historynode0resource_history0operation_history1_lastrcchange` VARCHAR(100),
  196. `node_historynode0resource_history0operation_history1_exectime` VARCHAR(100),
  197. `node_historynode0resource_history0operation_history1_queuetime` VARCHAR(100),
  198. `node_historynode0resource_history0operation_history1_rc` DOUBLE,
  199. `node_historynode0resource_history0operation_history1_rc_text` VARCHAR(100),
  200. `node_historynode0resource_history0_id` VARCHAR(100),
  201. `node_historynode0resource_history0_orphan` VARCHAR(100),
  202. `node_historynode0resource_history0_migrationthreshold` DOUBLE,
  203. `node_historynode0resource_history1operation_history0_call` DOUBLE,
  204. `node_historynode0resource_history1operation_history0_task` VARCHAR(100),
  205. `node_historynode0resource_history1operation_history0_lastrcchange` VARCHAR(100),
  206. `node_historynode0resource_history1operation_history0_lastrun` VARCHAR(100),
  207. `node_historynode0resource_history1operation_history0_exectime` VARCHAR(100),
  208. `node_historynode0resource_history1operation_history0_queuetime` VARCHAR(100),
  209. `node_historynode0resource_history1operation_history0_rc` DOUBLE,
  210. `node_historynode0resource_history1operation_history0_rc_text` VARCHAR(100),
  211. `node_historynode0resource_history1operation_history1_call` DOUBLE,
  212. `node_historynode0resource_history1operation_history1_task` VARCHAR(100),
  213. `node_historynode0resource_history1operation_history1_interval` VARCHAR(100),
  214. `node_historynode0resource_history1operation_history1_lastrcchange` VARCHAR(100),
  215. `node_historynode0resource_history1operation_history1_exectime` VARCHAR(100),
  216. `node_historynode0resource_history1operation_history1_queuetime` VARCHAR(100),
  217. `node_historynode0resource_history1operation_history1_rc` DOUBLE,
  218. `node_historynode0resource_history1operation_history1_rc_text` VARCHAR(100),
  219. `node_historynode0resource_history1_id` VARCHAR(100),
  220. `node_historynode0resource_history1_orphan` VARCHAR(100),
  221. `node_historynode0resource_history1_migrationthreshold` DOUBLE,
  222. `node_historynode0resource_history2operation_history0_call` DOUBLE,
  223. `node_historynode0resource_history2operation_history0_task` VARCHAR(100),
  224. `node_historynode0resource_history2operation_history0_lastrcchange` VARCHAR(100),
  225. `node_historynode0resource_history2operation_history0_lastrun` VARCHAR(100),
  226. `node_historynode0resource_history2operation_history0_exectime` VARCHAR(100),
  227. `node_historynode0resource_history2operation_history0_queuetime` VARCHAR(100),
  228. `node_historynode0resource_history2operation_history0_rc` DOUBLE,
  229. `node_historynode0resource_history2operation_history0_rc_text` VARCHAR(100),
  230. `node_historynode0resource_history2operation_history1_call` DOUBLE,
  231. `node_historynode0resource_history2operation_history1_task` VARCHAR(100),
  232. `node_historynode0resource_history2operation_history1_lastrcchange` VARCHAR(100),
  233. `node_historynode0resource_history2operation_history1_lastrun` VARCHAR(100),
  234. `node_historynode0resource_history2operation_history1_exectime` VARCHAR(100),
  235. `node_historynode0resource_history2operation_history1_queuetime` VARCHAR(100),
  236. `node_historynode0resource_history2operation_history1_rc` DOUBLE,
  237. `node_historynode0resource_history2operation_history1_rc_text` VARCHAR(100),
  238. `node_historynode0resource_history2operation_history2_call` DOUBLE,
  239. `node_historynode0resource_history2operation_history2_task` VARCHAR(100),
  240. `node_historynode0resource_history2operation_history2_interval` VARCHAR(100),
  241. `node_historynode0resource_history2operation_history2_lastrcchange` VARCHAR(100),
  242. `node_historynode0resource_history2operation_history2_exectime` VARCHAR(100),
  243. `node_historynode0resource_history2operation_history2_queuetime` VARCHAR(100),
  244. `node_historynode0resource_history2operation_history2_rc` DOUBLE,
  245. `node_historynode0resource_history2operation_history2_rc_text` VARCHAR(100),
  246. `node_historynode0resource_history2_id` VARCHAR(100),
  247. `node_historynode0resource_history2_orphan` VARCHAR(100),
  248. `node_historynode0resource_history2_migrationthreshold` DOUBLE,
  249. `node_historynode0_name` VARCHAR(100),
  250. `node_historynode1resource_history0operation_history0_call` DOUBLE,
  251. `node_historynode1resource_history0operation_history0_task` VARCHAR(100),
  252. `node_historynode1resource_history0operation_history0_interval` VARCHAR(100),
  253. `node_historynode1resource_history0operation_history0_lastrcchange` VARCHAR(100),
  254. `node_historynode1resource_history0operation_history0_exectime` VARCHAR(100),
  255. `node_historynode1resource_history0operation_history0_queuetime` VARCHAR(100),
  256. `node_historynode1resource_history0operation_history0_rc` DOUBLE,
  257. `node_historynode1resource_history0operation_history0_rc_text` VARCHAR(100),
  258. `node_historynode1resource_history0operation_history1_call` DOUBLE,
  259. `node_historynode1resource_history0operation_history1_task` VARCHAR(100),
  260. `node_historynode1resource_history0operation_history1_lastrcchange` VARCHAR(100),
  261. `node_historynode1resource_history0operation_history1_lastrun` VARCHAR(100),
  262. `node_historynode1resource_history0operation_history1_exectime` VARCHAR(100),
  263. `node_historynode1resource_history0operation_history1_queuetime` VARCHAR(100),
  264. `node_historynode1resource_history0operation_history1_rc` DOUBLE,
  265. `node_historynode1resource_history0operation_history1_rc_text` VARCHAR(100),
  266. `node_historynode1resource_history0_id` VARCHAR(100),
  267. `node_historynode1resource_history0_orphan` VARCHAR(100),
  268. `node_historynode1resource_history0_migrationthreshold` DOUBLE,
  269. `node_historynode1resource_history1operation_history0_call` DOUBLE,
  270. `node_historynode1resource_history1operation_history0_task` VARCHAR(100),
  271. `node_historynode1resource_history1operation_history0_lastrcchange` VARCHAR(100),
  272. `node_historynode1resource_history1operation_history0_lastrun` VARCHAR(100),
  273. `node_historynode1resource_history1operation_history0_exectime` VARCHAR(100),
  274. `node_historynode1resource_history1operation_history0_queuetime` VARCHAR(100),
  275. `node_historynode1resource_history1operation_history0_rc` DOUBLE,
  276. `node_historynode1resource_history1operation_history0_rc_text` VARCHAR(100),
  277. `node_historynode1resource_history1operation_history1_call` DOUBLE,
  278. `node_historynode1resource_history1operation_history1_task` VARCHAR(100),
  279. `node_historynode1resource_history1operation_history1_interval` VARCHAR(100),
  280. `node_historynode1resource_history1operation_history1_lastrcchange` VARCHAR(100),
  281. `node_historynode1resource_history1operation_history1_exectime` VARCHAR(100),
  282. `node_historynode1resource_history1operation_history1_queuetime` VARCHAR(100),
  283. `node_historynode1resource_history1operation_history1_rc` DOUBLE,
  284. `node_historynode1resource_history1operation_history1_rc_text` VARCHAR(100),
  285. `node_historynode1resource_history1_id` VARCHAR(100),
  286. `node_historynode1resource_history1_orphan` VARCHAR(100),
  287. `node_historynode1resource_history1_migrationthreshold` DOUBLE,
  288. `node_historynode1resource_history2operation_history0_call` DOUBLE,
  289. `node_historynode1resource_history2operation_history0_task` VARCHAR(100),
  290. `node_historynode1resource_history2operation_history0_lastrcchange` VARCHAR(100),
  291. `node_historynode1resource_history2operation_history0_lastrun` VARCHAR(100),
  292. `node_historynode1resource_history2operation_history0_exectime` VARCHAR(100),
  293. `node_historynode1resource_history2operation_history0_queuetime` VARCHAR(100),
  294. `node_historynode1resource_history2operation_history0_rc` DOUBLE,
  295. `node_historynode1resource_history2operation_history0_rc_text` VARCHAR(100),
  296. `node_historynode1resource_history2operation_history1_call` DOUBLE,
  297. `node_historynode1resource_history2operation_history1_task` VARCHAR(100),
  298. `node_historynode1resource_history2operation_history1_interval` VARCHAR(100),
  299. `node_historynode1resource_history2operation_history1_lastrcchange` VARCHAR(100),
  300. `node_historynode1resource_history2operation_history1_exectime` VARCHAR(100),
  301. `node_historynode1resource_history2operation_history1_queuetime` VARCHAR(100),
  302. `node_historynode1resource_history2operation_history1_rc` DOUBLE,
  303. `node_historynode1resource_history2operation_history1_rc_text` VARCHAR(100),
  304. `node_historynode1resource_history2_id` VARCHAR(100),
  305. `node_historynode1resource_history2_orphan` VARCHAR(100),
  306. `node_historynode1resource_history2_migrationthreshold` DOUBLE,
  307. `node_historynode1resource_history3operation_history0_call` DOUBLE,
  308. `node_historynode1resource_history3operation_history0_task` VARCHAR(100),
  309. `node_historynode1resource_history3operation_history0_lastrcchange` VARCHAR(100),
  310. `node_historynode1resource_history3operation_history0_lastrun` VARCHAR(100),
  311. `node_historynode1resource_history3operation_history0_exectime` VARCHAR(100),
  312. `node_historynode1resource_history3operation_history0_queuetime` VARCHAR(100),
  313. `node_historynode1resource_history3operation_history0_rc` DOUBLE,
  314. `node_historynode1resource_history3operation_history0_rc_text` VARCHAR(100),
  315. `node_historynode1resource_history3operation_history1_call` DOUBLE,
  316. `node_historynode1resource_history3operation_history1_task` VARCHAR(100),
  317. `node_historynode1resource_history3operation_history1_lastrcchange` VARCHAR(100),
  318. `node_historynode1resource_history3operation_history1_lastrun` VARCHAR(100),
  319. `node_historynode1resource_history3operation_history1_exectime` VARCHAR(100),
  320. `node_historynode1resource_history3operation_history1_queuetime` VARCHAR(100),
  321. `node_historynode1resource_history3operation_history1_rc` DOUBLE,
  322. `node_historynode1resource_history3operation_history1_rc_text` VARCHAR(100),
  323. `node_historynode1resource_history3operation_history2_call` DOUBLE,
  324. `node_historynode1resource_history3operation_history2_task` VARCHAR(100),
  325. `node_historynode1resource_history3operation_history2_interval` VARCHAR(100),
  326. `node_historynode1resource_history3operation_history2_lastrcchange` VARCHAR(100),
  327. `node_historynode1resource_history3operation_history2_exectime` VARCHAR(100),
  328. `node_historynode1resource_history3operation_history2_queuetime` VARCHAR(100),
  329. `node_historynode1resource_history3operation_history2_rc` DOUBLE,
  330. `node_historynode1resource_history3operation_history2_rc_text` VARCHAR(100),
  331. `node_historynode1resource_history3_id` VARCHAR(100),
  332. `node_historynode1resource_history3_orphan` VARCHAR(100),
  333. `node_historynode1resource_history3_migrationthreshold` DOUBLE,
  334. `node_historynode1_name` VARCHAR(100),
  335. `fence_historyfence_event0_status` VARCHAR(100),
  336. `fence_historyfence_event0_delegate` VARCHAR(100),
  337. `fence_historyfence_event0_action` VARCHAR(100),
  338. `fence_historyfence_event0_target` VARCHAR(100),
  339. `fence_historyfence_event0_client` VARCHAR(100),
  340. `fence_historyfence_event0_origin` VARCHAR(100),
  341. `fence_historyfence_event0_completed` VARCHAR(100),
  342. `fence_historyfence_event1_status` VARCHAR(100),
  343. `fence_historyfence_event1_delegate` VARCHAR(100),
  344. `fence_historyfence_event1_action` VARCHAR(100),
  345. `fence_historyfence_event1_target` VARCHAR(100),
  346. `fence_historyfence_event1_client` VARCHAR(100),
  347. `fence_historyfence_event1_origin` VARCHAR(100),
  348. `fence_historyfence_event1_completed` VARCHAR(100),
  349. `_version` VARCHAR(100)
  350. );
  351.  
  352. /* INSERT QUERY NO: 1 */
  353. INSERT INTO pcs_stst(`summarystack_type`, `summarycurrent_dc_present`, `summarycurrent_dc_version`, `summarycurrent_dc_name`, `summarycurrent_dc_id`, `summarycurrent_dc_with_quorum`, `summarylast_update_time`, `summarylast_change_time`, `summarylast_change_user`, `summarylast_change_client`, `summarylast_change_origin`, `summarynodes_configured_number`, `summaryresources_configured_number`, `summaryresources_configured_disabled`, `summaryresources_configured_blocked`, `summarycluster_options_stonithenabled`, `summarycluster_options_symmetriccluster`, `summarycluster_options_noquorumpolicy`, `summarycluster_options_maintenancemode`, `nodesnode0_name`, `nodesnode0_id`, `nodesnode0_online`, `nodesnode0_standby`, `nodesnode0_standby_onfail`, `nodesnode0_maintenance`, `nodesnode0_pending`, `nodesnode0_unclean`, `nodesnode0_shutdown`, `nodesnode0_expected_up`, `nodesnode0_is_dc`, `nodesnode0_resources_running`, `nodesnode0_type`, `nodesnode1_name`, `nodesnode1_id`, `nodesnode1_online`, `nodesnode1_standby`, `nodesnode1_standby_onfail`, `nodesnode1_maintenance`, `nodesnode1_pending`, `nodesnode1_unclean`, `nodesnode1_shutdown`, `nodesnode1_expected_up`, `nodesnode1_is_dc`, `nodesnode1_resources_running`, `nodesnode1_type`, `resourcesresource0node_name`, `resourcesresource0node_id`, `resourcesresource0node_cached`, `resourcesresource0_id`, `resourcesresource0_resource_agent`, `resourcesresource0_role`, `resourcesresource0_active`, `resourcesresource0_orphaned`, `resourcesresource0_blocked`, `resourcesresource0_managed`, `resourcesresource0_failed`, `resourcesresource0_failure_ignored`, `resourcesresource0_nodes_running_on`, `resourcesresource1node_name`, `resourcesresource1node_id`, `resourcesresource1node_cached`, `resourcesresource1_id`, `resourcesresource1_resource_agent`, `resourcesresource1_role`, `resourcesresource1_active`, `resourcesresource1_orphaned`, `resourcesresource1_blocked`, `resourcesresource1_managed`, `resourcesresource1_failed`, `resourcesresource1_failure_ignored`, `resourcesresource1_nodes_running_on`, `resourcesclone0resource0node_name`, `resourcesclone0resource0node_id`, `resourcesclone0resource0node_cached`, `resourcesclone0resource0_id`, `resourcesclone0resource0_resource_agent`, `resourcesclone0resource0_role`, `resourcesclone0resource0_active`, `resourcesclone0resource0_orphaned`, `resourcesclone0resource0_blocked`, `resourcesclone0resource0_managed`, `resourcesclone0resource0_failed`, `resourcesclone0resource0_failure_ignored`, `resourcesclone0resource0_nodes_running_on`, `resourcesclone0resource1node_name`, `resourcesclone0resource1node_id`, `resourcesclone0resource1node_cached`, `resourcesclone0resource1_id`, `resourcesclone0resource1_resource_agent`, `resourcesclone0resource1_role`, `resourcesclone0resource1_active`, `resourcesclone0resource1_orphaned`, `resourcesclone0resource1_blocked`, `resourcesclone0resource1_managed`, `resourcesclone0resource1_failed`, `resourcesclone0resource1_failure_ignored`, `resourcesclone0resource1_nodes_running_on`, `resourcesclone0_id`, `resourcesclone0_multi_state`, `resourcesclone0_unique`, `resourcesclone0_managed`, `resourcesclone0_failed`, `resourcesclone0_failure_ignored`, `resourcesclone1resource0node_name`, `resourcesclone1resource0node_id`, `resourcesclone1resource0node_cached`, `resourcesclone1resource0_id`, `resourcesclone1resource0_resource_agent`, `resourcesclone1resource0_role`, `resourcesclone1resource0_active`, `resourcesclone1resource0_orphaned`, `resourcesclone1resource0_blocked`, `resourcesclone1resource0_managed`, `resourcesclone1resource0_failed`, `resourcesclone1resource0_failure_ignored`, `resourcesclone1resource0_nodes_running_on`, `resourcesclone1resource1node_name`, `resourcesclone1resource1node_id`, `resourcesclone1resource1node_cached`, `resourcesclone1resource1_id`, `resourcesclone1resource1_resource_agent`, `resourcesclone1resource1_role`, `resourcesclone1resource1_active`, `resourcesclone1resource1_orphaned`, `resourcesclone1resource1_blocked`, `resourcesclone1resource1_managed`, `resourcesclone1resource1_failed`, `resourcesclone1resource1_failure_ignored`, `resourcesclone1resource1_nodes_running_on`, `resourcesclone1_id`, `resourcesclone1_multi_state`, `resourcesclone1_unique`, `resourcesclone1_managed`, `resourcesclone1_failed`, `resourcesclone1_failure_ignored`, `node_attributesnode0attribute0_name`, `node_attributesnode0attribute0_value`, `node_attributesnode0attribute1_name`, `node_attributesnode0attribute1_value`, `node_attributesnode0attribute2_name`, `node_attributesnode0attribute2_value`, `node_attributesnode0attribute3_name`, `node_attributesnode0attribute3_value`, `node_attributesnode0attribute4_name`, `node_attributesnode0attribute4_value`, `node_attributesnode0attribute5_name`, `node_attributesnode0attribute5_value`, `node_attributesnode0attribute6_name`, `node_attributesnode0attribute6_value`, `node_attributesnode0attribute7_name`, `node_attributesnode0attribute7_value`, `node_attributesnode0attribute8_name`, `node_attributesnode0attribute8_value`, `node_attributesnode0attribute9_name`, `node_attributesnode0attribute9_value`, `node_attributesnode0attribute10_name`, `node_attributesnode0attribute10_value`, `node_attributesnode0_name`, `node_attributesnode1attribute0_name`, `node_attributesnode1attribute0_value`, `node_attributesnode1attribute1_name`, `node_attributesnode1attribute1_value`, `node_attributesnode1attribute2_name`, `node_attributesnode1attribute2_value`, `node_attributesnode1attribute3_name`, `node_attributesnode1attribute3_value`, `node_attributesnode1attribute4_name`, `node_attributesnode1attribute4_value`, `node_attributesnode1attribute5_name`, `node_attributesnode1attribute5_value`, `node_attributesnode1attribute6_name`, `node_attributesnode1attribute6_value`, `node_attributesnode1attribute7_name`, `node_attributesnode1attribute7_value`, `node_attributesnode1attribute8_name`, `node_attributesnode1attribute8_value`, `node_attributesnode1attribute9_name`, `node_attributesnode1attribute9_value`, `node_attributesnode1attribute10_name`, `node_attributesnode1attribute10_value`, `node_attributesnode1_name`, `node_historynode0resource_history0operation_history0_call`, `node_historynode0resource_history0operation_history0_task`, `node_historynode0resource_history0operation_history0_lastrcchange`, `node_historynode0resource_history0operation_history0_lastrun`, `node_historynode0resource_history0operation_history0_exectime`, `node_historynode0resource_history0operation_history0_queuetime`, `node_historynode0resource_history0operation_history0_rc`, `node_historynode0resource_history0operation_history0_rc_text`, `node_historynode0resource_history0operation_history1_call`, `node_historynode0resource_history0operation_history1_task`, `node_historynode0resource_history0operation_history1_interval`, `node_historynode0resource_history0operation_history1_lastrcchange`, `node_historynode0resource_history0operation_history1_exectime`, `node_historynode0resource_history0operation_history1_queuetime`, `node_historynode0resource_history0operation_history1_rc`, `node_historynode0resource_history0operation_history1_rc_text`, `node_historynode0resource_history0_id`, `node_historynode0resource_history0_orphan`, `node_historynode0resource_history0_migrationthreshold`, `node_historynode0resource_history1operation_history0_call`, `node_historynode0resource_history1operation_history0_task`, `node_historynode0resource_history1operation_history0_lastrcchange`, `node_historynode0resource_history1operation_history0_lastrun`, `node_historynode0resource_history1operation_history0_exectime`, `node_historynode0resource_history1operation_history0_queuetime`, `node_historynode0resource_history1operation_history0_rc`, `node_historynode0resource_history1operation_history0_rc_text`, `node_historynode0resource_history1operation_history1_call`, `node_historynode0resource_history1operation_history1_task`, `node_historynode0resource_history1operation_history1_interval`, `node_historynode0resource_history1operation_history1_lastrcchange`, `node_historynode0resource_history1operation_history1_exectime`, `node_historynode0resource_history1operation_history1_queuetime`, `node_historynode0resource_history1operation_history1_rc`, `node_historynode0resource_history1operation_history1_rc_text`, `node_historynode0resource_history1_id`, `node_historynode0resource_history1_orphan`, `node_historynode0resource_history1_migrationthreshold`, `node_historynode0resource_history2operation_history0_call`, `node_historynode0resource_history2operation_history0_task`, `node_historynode0resource_history2operation_history0_lastrcchange`, `node_historynode0resource_history2operation_history0_lastrun`, `node_historynode0resource_history2operation_history0_exectime`, `node_historynode0resource_history2operation_history0_queuetime`, `node_historynode0resource_history2operation_history0_rc`, `node_historynode0resource_history2operation_history0_rc_text`, `node_historynode0resource_history2operation_history1_call`, `node_historynode0resource_history2operation_history1_task`, `node_historynode0resource_history2operation_history1_lastrcchange`, `node_historynode0resource_history2operation_history1_lastrun`, `node_historynode0resource_history2operation_history1_exectime`, `node_historynode0resource_history2operation_history1_queuetime`, `node_historynode0resource_history2operation_history1_rc`, `node_historynode0resource_history2operation_history1_rc_text`, `node_historynode0resource_history2operation_history2_call`, `node_historynode0resource_history2operation_history2_task`, `node_historynode0resource_history2operation_history2_interval`, `node_historynode0resource_history2operation_history2_lastrcchange`, `node_historynode0resource_history2operation_history2_exectime`, `node_historynode0resource_history2operation_history2_queuetime`, `node_historynode0resource_history2operation_history2_rc`, `node_historynode0resource_history2operation_history2_rc_text`, `node_historynode0resource_history2_id`, `node_historynode0resource_history2_orphan`, `node_historynode0resource_history2_migrationthreshold`, `node_historynode0_name`, `node_historynode1resource_history0operation_history0_call`, `node_historynode1resource_history0operation_history0_task`, `node_historynode1resource_history0operation_history0_interval`, `node_historynode1resource_history0operation_history0_lastrcchange`, `node_historynode1resource_history0operation_history0_exectime`, `node_historynode1resource_history0operation_history0_queuetime`, `node_historynode1resource_history0operation_history0_rc`, `node_historynode1resource_history0operation_history0_rc_text`, `node_historynode1resource_history0operation_history1_call`, `node_historynode1resource_history0operation_history1_task`, `node_historynode1resource_history0operation_history1_lastrcchange`, `node_historynode1resource_history0operation_history1_lastrun`, `node_historynode1resource_history0operation_history1_exectime`, `node_historynode1resource_history0operation_history1_queuetime`, `node_historynode1resource_history0operation_history1_rc`, `node_historynode1resource_history0operation_history1_rc_text`, `node_historynode1resource_history0_id`, `node_historynode1resource_history0_orphan`, `node_historynode1resource_history0_migrationthreshold`, `node_historynode1resource_history1operation_history0_call`, `node_historynode1resource_history1operation_history0_task`, `node_historynode1resource_history1operation_history0_lastrcchange`, `node_historynode1resource_history1operation_history0_lastrun`, `node_historynode1resource_history1operation_history0_exectime`, `node_historynode1resource_history1operation_history0_queuetime`, `node_historynode1resource_history1operation_history0_rc`, `node_historynode1resource_history1operation_history0_rc_text`, `node_historynode1resource_history1operation_history1_call`, `node_historynode1resource_history1operation_history1_task`, `node_historynode1resource_history1operation_history1_interval`, `node_historynode1resource_history1operation_history1_lastrcchange`, `node_historynode1resource_history1operation_history1_exectime`, `node_historynode1resource_history1operation_history1_queuetime`, `node_historynode1resource_history1operation_history1_rc`, `node_historynode1resource_history1operation_history1_rc_text`, `node_historynode1resource_history1_id`, `node_historynode1resource_history1_orphan`, `node_historynode1resource_history1_migrationthreshold`, `node_historynode1resource_history2operation_history0_call`, `node_historynode1resource_history2operation_history0_task`, `node_historynode1resource_history2operation_history0_lastrcchange`, `node_historynode1resource_history2operation_history0_lastrun`, `node_historynode1resource_history2operation_history0_exectime`, `node_historynode1resource_history2operation_history0_queuetime`, `node_historynode1resource_history2operation_history0_rc`, `node_historynode1resource_history2operation_history0_rc_text`, `node_historynode1resource_history2operation_history1_call`, `node_historynode1resource_history2operation_history1_task`, `node_historynode1resource_history2operation_history1_interval`, `node_historynode1resource_history2operation_history1_lastrcchange`, `node_historynode1resource_history2operation_history1_exectime`, `node_historynode1resource_history2operation_history1_queuetime`, `node_historynode1resource_history2operation_history1_rc`, `node_historynode1resource_history2operation_history1_rc_text`, `node_historynode1resource_history2_id`, `node_historynode1resource_history2_orphan`, `node_historynode1resource_history2_migrationthreshold`, `node_historynode1resource_history3operation_history0_call`, `node_historynode1resource_history3operation_history0_task`, `node_historynode1resource_history3operation_history0_lastrcchange`, `node_historynode1resource_history3operation_history0_lastrun`, `node_historynode1resource_history3operation_history0_exectime`, `node_historynode1resource_history3operation_history0_queuetime`, `node_historynode1resource_history3operation_history0_rc`, `node_historynode1resource_history3operation_history0_rc_text`, `node_historynode1resource_history3operation_history1_call`, `node_historynode1resource_history3operation_history1_task`, `node_historynode1resource_history3operation_history1_lastrcchange`, `node_historynode1resource_history3operation_history1_lastrun`, `node_historynode1resource_history3operation_history1_exectime`, `node_historynode1resource_history3operation_history1_queuetime`, `node_historynode1resource_history3operation_history1_rc`, `node_historynode1resource_history3operation_history1_rc_text`, `node_historynode1resource_history3operation_history2_call`, `node_historynode1resource_history3operation_history2_task`, `node_historynode1resource_history3operation_history2_interval`, `node_historynode1resource_history3operation_history2_lastrcchange`, `node_historynode1resource_history3operation_history2_exectime`, `node_historynode1resource_history3operation_history2_queuetime`, `node_historynode1resource_history3operation_history2_rc`, `node_historynode1resource_history3operation_history2_rc_text`, `node_historynode1resource_history3_id`, `node_historynode1resource_history3_orphan`, `node_historynode1resource_history3_migrationthreshold`, `node_historynode1_name`, `fence_historyfence_event0_status`, `fence_historyfence_event0_delegate`, `fence_historyfence_event0_action`, `fence_historyfence_event0_target`, `fence_historyfence_event0_client`, `fence_historyfence_event0_origin`, `fence_historyfence_event0_completed`, `fence_historyfence_event1_status`, `fence_historyfence_event1_delegate`, `fence_historyfence_event1_action`, `fence_historyfence_event1_target`, `fence_historyfence_event1_client`, `fence_historyfence_event1_origin`, `fence_historyfence_event1_completed`, `_version`)
  354. VALUES ('corosync', 'true', '2.0.3-5.el8_2.5-4b1f869f0f', 'dallahcsap01.na.xom.com', 1, 'true', 'Fri Jun  2 07:21:14 2023', 'Fri Jun  2 07:20:25 2023', 'root', 'crm_attribute', 'dallahcsap01.na.xom.com', 2, 6, 0, 0, 'true', 'true', 'stop', 'false', 'dallahcsap01.na.xom.com', 1, 'true', 'false', 'false', 'false', 'false', 'false', 'false', 'true', 'true', 3, 'member', 'dallahcsap02.na.xom.com', 2, 'true', 'false', 'false', 'false', 'false', 'false', 'false', 'true', 'false', 3, 'member', 'dallahcsap02.na.xom.com', 2, 'true', 'fence_vm', 'stonith:fence_vmware_soap', 'Started', 'true', 'false', 'false', 'true', 'false', 'false', 1, 'dallahcsap01.na.xom.com', 1, 'true', 'rsc_ip_SAPHana_GCA_HDB00', 'ocf::heartbeat:IPaddr2', 'Started', 'true', 'false', 'false', 'true', 'false', 'false', 1, 'dallahcsap02.na.xom.com', 2, 'true', 'SAPHanaTopology_GCA_HDB00', 'ocf::heartbeat:SAPHanaTopology', 'Started', 'true', 'false', 'false', 'true', 'false', 'false', 1, 'dallahcsap01.na.xom.com', 1, 'true', 'SAPHanaTopology_GCA_HDB00', 'ocf::heartbeat:SAPHanaTopology', 'Started', 'true', 'false', 'false', 'true', 'false', 'false', 1, 'SAPHanaTopology_GCA_HDB00-clone', 'false', 'false', 'true', 'false', 'false', 'dallahcsap02.na.xom.com', 2, 'true', 'SAPHana_GCA_HDB00', 'ocf::heartbeat:SAPHana', 'Slave', 'true', 'false', 'false', 'true', 'false', 'false', 1, 'dallahcsap01.na.xom.com', 1, 'true', 'SAPHana_GCA_HDB00', 'ocf::heartbeat:SAPHana', 'Master', 'true', 'false', 'false', 'true', 'false', 'false', 1, 'SAPHana_GCA_HDB00-clone', 'true', 'false', 'true', 'false', 'false', 'hana_gca_clone_state', 'PROMOTED', 'hana_gca_op_mode', 'logreplay', 'hana_gca_remoteHost', 'dalzgca01', 'hana_gca_roles', '4:P:master1:master:worker:master', 'hana_gca_site', 'DALY', 'hana_gca_srmode', 'syncmem', 'hana_gca_sync_state', 'PRIM', 'hana_gca_version', '2.00.059.00.1636704142', 'hana_gca_vhost', 'dalygca01', 'lpa_gca_lpt', 1685690425, 'master-SAPHana_GCA_HDB00', 150, 'dallahcsap01.na.xom.com', 'hana_gca_clone_state', 'DEMOTED', 'hana_gca_op_mode', 'logreplay', 'hana_gca_remoteHost', 'dalygca01', 'hana_gca_roles', '4:S:master1:master:worker:master', 'hana_gca_site', 'DALZ', 'hana_gca_srmode', 'syncmem', 'hana_gca_sync_state', 'SOK', 'hana_gca_version', '2.00.059.00.1636704142', 'hana_gca_vhost', 'dalzgca01', 'lpa_gca_lpt', 30, 'master-SAPHana_GCA_HDB00', 100, 'dallahcsap02.na.xom.com', 147, 'start', 'Tue May 30 04:40:17 2023', 'Tue May 30 04:40:17 2023', '31550ms', '0ms', 0, 'ok', 148, 'monitor', '60000ms', 'Tue May 30 04:40:49 2023', '7712ms', '0ms', 0, 'ok', 'fence_vm', 'false', 1000000, 23, 'start', 'Mon Mar 20 08:05:00 2023', 'Mon Mar 20 08:05:00 2023', '3688ms', '0ms', 0, 'ok', 24, 'monitor', '10000ms', 'Mon Mar 20 08:05:04 2023', '4326ms', '0ms', 0, 'ok', 'SAPHanaTopology_GCA_HDB00', 'false', 1000000, 19, 'probe', 'Mon Mar 20 08:01:38 2023', 'Mon Mar 20 08:01:38 2023', '182940ms', '0ms', 0, 'ok', 19, 'probe', 'Mon Mar 20 08:01:38 2023', 'Mon Mar 20 08:01:38 2023', '182940ms', '0ms', 0, 'ok', 22, 'monitor', '61000ms', 'Mon Mar 20 08:04:50 2023', '9996ms', '0ms', 0, 'ok', 'SAPHana_GCA_HDB00', 'false', 1000000, 'dallahcsap02.na.xom.com', 61, 'monitor', '60000ms', 'Wed May  3 13:31:59 2023', '8396ms', '0ms', 0, 'ok', 179, 'stop', 'Tue May 30 04:39:47 2023', 'Tue May 30 04:39:47 2023', '0ms', '0ms', 0, 'ok', 'fence_vm', 'false', 1000000, 43, 'start', 'Sat Mar 18 21:11:06 2023', 'Sat Mar 18 21:11:06 2023', '100ms', '0ms', 0, 'ok', 45, 'monitor', '60000ms', 'Sat Mar 18 21:11:06 2023', '62ms', '0ms', 0, 'ok', 'rsc_ip_SAPHana_GCA_HDB00', 'false', 1000000, 44, 'start', 'Sat Mar 18 21:11:06 2023', 'Sat Mar 18 21:11:06 2023', '2984ms', '0ms', 0, 'ok', 46, 'monitor', '10000ms', 'Sat Mar 18 21:12:19 2023', '3493ms', '0ms', 0, 'ok', 'SAPHanaTopology_GCA_HDB00', 'false', 1000000, 19, 'probe', 'Thu Mar  2 21:06:22 2023', 'Thu Mar  2 21:06:22 2023', '7275ms', '0ms', 0, 'ok', 48, 'promote', 'Sat Mar 18 21:15:48 2023', 'Sat Mar 18 21:15:48 2023', '2052ms', '0ms', 0, 'ok', 49, 'monitor', '59000ms', 'Sat Mar 18 21:15:58 2023', '8226ms', '0ms', 8, 'master', 'SAPHana_GCA_HDB00', 'false', 1000000, 'dallahcsap01.na.xom.com', 'success', 'dallahcsap01.na.xom.com', 'reboot', 'dallahcsap02.na.xom.com', 'pacemaker-controld.1904', 'dallahcsap01.na.xom.com', '2023-03-18 21:12:26Z', 'success', 'dallahcsap01.na.xom.com', 'reboot', 'dallahcsap02.na.xom.com', 'pacemaker-controld.1904', 'dallahcsap01.na.xom.com', '2023-03-18 21:12:18Z', '2.0.3');
  355.  
  356.  

Editor

You can edit this paste and save as new:


File Description
  • pcs
  • Paste Code
  • 09 Jun-2023
  • 39.75 Kb
You can Share it: