API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 25th, 2017
470
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 55.11 KB | None | 0 0
raw download clone embed print report
  1. 2017-06-23 15:45:30.306807 PDT,"gpadmin","appriss",p5660,th-2019084416,"[local]",,2017-06-23 14:08:06 PDT,20299569,con1771148,cmd44,seg-1,,dx2631738,x20299569,sx1,"LOG","00000","DTM error (gathered 144 results from cmd 'Distributed Prepare')","Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg0 gpseg10:40000 pid=48899)
  2. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg1 gpseg10:40001 pid=48901)
  3. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg2 gpseg10:40002 pid=48903)
  4. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg3 gpseg10:40003 pid=48905)
  5. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg4 gpseg10:40004 pid=48907)
  6. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg5 gpseg10:40005 pid=48909)
  7. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg6 gpseg11:40000 pid=19942)
  8. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg7 gpseg11:40001 pid=19944)
  9. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg8 gpseg11:40002 pid=19946)
  10. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg9 gpseg11:40003 pid=19948)
  11. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg10 gpseg11:40004 pid=19950)
  12. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg11 gpseg11:40005 pid=19952)
  13. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg12 gpseg12:40000 pid=36134)
  14. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg13 gpseg12:40001 pid=36136)
  15. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg14 gpseg12:40002 pid=36138)
  16. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg15 gpseg12:40003 pid=36140)
  17. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg16 gpseg12:40004 pid=36142)
  18. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg17 gpseg12:40005 pid=36144)
  19. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg18 gpseg13:40000 pid=19477)
  20. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg19 gpseg13:40001 pid=19479)
  21. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg20 gpseg13:40002 pid=19481)
  22. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg21 gpseg13:40003 pid=19483)
  23. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg22 gpseg13:40004 pid=19485)
  24. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg23 gpseg13:40005 pid=19487)
  25. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg24 gpseg14:40000 pid=22677)
  26. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg25 gpseg14:40001 pid=22679)
  27. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg26 gpseg14:40002 pid=22681)
  28. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg27 gpseg14:40003 pid=22683)
  29. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg28 gpseg14:40004 pid=22685)
  30. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg29 gpseg14:40005 pid=22687)
  31. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg30 gpseg15:40000 pid=26276)
  32. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg31 gpseg15:40001 pid=26278)
  33. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg32 gpseg15:40002 pid=26280)
  34. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg33 gpseg15:40003 pid=26282)
  35. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg34 gpseg15:40004 pid=26284)
  36. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg35 gpseg15:40005 pid=26286)
  37. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg36 gpseg16:40000 pid=15722)
  38. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg37 gpseg16:40001 pid=15724)
  39. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg38 gpseg16:40002 pid=15726)
  40. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg39 gpseg16:40003 pid=15728)
  41. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg40 gpseg16:40004 pid=15730)
  42. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg41 gpseg16:40005 pid=15732)
  43. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg42 gpseg17:40000 pid=8533)
  44. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg43 gpseg17:40001 pid=8535)
  45. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg44 gpseg17:40002 pid=8537)
  46. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg45 gpseg17:40003 pid=8539)
  47. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg46 gpseg17:40004 pid=8541)
  48. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg47 gpseg17:40005 pid=8543)
  49. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg48 gpseg18:40000 pid=5052)
  50. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg49 gpseg18:40001 pid=5054)
  51. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg50 gpseg18:40002 pid=5056)
  52. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg51 gpseg18:40003 pid=5058)
  53. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg52 gpseg18:40004 pid=5060)
  54. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg53 gpseg18:40005 pid=5062)
  55. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg54 gpseg19:40000 pid=39353)
  56. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg55 gpseg19:40001 pid=39355)
  57. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg56 gpseg19:40002 pid=39357)
  58. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg57 gpseg19:40003 pid=39359)
  59. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg58 gpseg19:40004 pid=39361)
  60. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg59 gpseg19:40005 pid=39363)
  61. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg60 gpseg1:40000 pid=43824)
  62. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg61 gpseg21:50001 pid=7578)
  63. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg62 gpseg1:40002 pid=43826)
  64. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg63 gpseg1:40003 pid=43828)
  65. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg64 gpseg1:40004 pid=43820)
  66. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg65 gpseg1:40005 pid=43822)
  67. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg66 gpseg20:40000 pid=36792)
  68. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg67 gpseg20:40001 pid=36794)
  69. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg68 gpseg20:40002 pid=36796)
  70. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg69 gpseg20:40003 pid=36798)
  71. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg70 gpseg20:40004 pid=36800)
  72. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg71 gpseg20:40005 pid=36802)
  73. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg72 gpseg21:40000 pid=7565)
  74. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg73 gpseg21:40001 pid=7567)
  75. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg74 gpseg21:40002 pid=7569)
  76. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg75 gpseg21:40003 pid=7571)
  77. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg76 gpseg21:40004 pid=7573)
  78. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg77 gpseg21:40005 pid=7575)
  79. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg78 gpseg22:40000 pid=34178)
  80. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg79 gpseg22:40001 pid=34180)
  81. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg80 gpseg22:40002 pid=34182)
  82. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg81 gpseg22:40003 pid=34184)
  83. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg82 gpseg22:40004 pid=34186)
  84. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg83 gpseg22:40005 pid=34188)
  85. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg84 gpseg23:40000 pid=17962)
  86. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg85 gpseg23:40001 pid=17964)
  87. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg86 gpseg23:40002 pid=17966)
  88. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg87 gpseg23:40003 pid=17968)
  89. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg88 gpseg23:40004 pid=17970)
  90. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg89 gpseg23:40005 pid=17972)
  91. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg90 gpseg24:40000 pid=15287)
  92. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg91 gpseg24:40001 pid=15289)
  93. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg92 gpseg24:40002 pid=15291)
  94. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg93 gpseg24:40003 pid=15293)
  95. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg94 gpseg24:40004 pid=15295)
  96. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg95 gpseg24:40005 pid=15297)
  97. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg96 gpseg2:40000 pid=27937)
  98. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg97 gpseg2:40001 pid=27939)
  99. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg98 gpseg2:40002 pid=27941)
  100. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg99 gpseg2:40003 pid=27943)
  101. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg100 gpseg2:40004 pid=27945)
  102. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg101 gpseg2:40005 pid=27947)
  103. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg102 gpseg3:40000 pid=17654)
  104. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg103 gpseg3:40001 pid=17656)
  105. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg104 gpseg3:40002 pid=17658)
  106. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg105 gpseg3:40003 pid=17660)
  107. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg106 gpseg3:40004 pid=17662)
  108. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg107 gpseg3:40005 pid=17664)
  109. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg108 gpseg4:40000 pid=47799)
  110. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg109 gpseg4:40001 pid=47801)
  111. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg110 gpseg4:40002 pid=47803)
  112. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg111 gpseg4:40003 pid=47805)
  113. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg112 gpseg4:40004 pid=47807)
  114. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg113 gpseg4:40005 pid=47809)
  115. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg114 gpseg5:40000 pid=36909)
  116. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg115 gpseg5:40001 pid=36911)
  117. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg116 gpseg5:40002 pid=36913)
  118. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg117 gpseg5:40003 pid=36915)
  119. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg118 gpseg5:40004 pid=36917)
  120. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg119 gpseg5:40005 pid=36919)
  121. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg120 gpseg6:40000 pid=48387)
  122. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg121 gpseg6:40001 pid=48389)
  123. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg122 gpseg6:40002 pid=48391)
  124. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg123 gpseg6:40003 pid=48393)
  125. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg124 gpseg6:40004 pid=48395)
  126. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg125 gpseg6:40005 pid=48397)
  127. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg126 gpseg7:40000 pid=21165)
  128. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg127 gpseg7:40001 pid=21167)
  129. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg128 gpseg7:40002 pid=21157)
  130. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg129 gpseg7:40003 pid=21159)
  131. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg130 gpseg7:40004 pid=21161)
  132. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg131 gpseg7:40005 pid=21163)
  133. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg132 gpseg8:40000 pid=19819)
  134. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg133 gpseg8:40001 pid=19821)
  135. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg134 gpseg8:40002 pid=19823)
  136. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg135 gpseg8:40003 pid=19825)
  137. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg136 gpseg8:40004 pid=19827)
  138. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg137 gpseg8:40005 pid=19829)
  139. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg138 gpseg9:40000 pid=12199)
  140. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg139 gpseg9:40001 pid=12201)
  141. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg140 gpseg9:40002 pid=12203)
  142. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg141 gpseg9:40003 pid=12205)
  143. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg142 gpseg9:40004 pid=12207)
  144. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4341) (seg143 gpseg9:40005 pid=12209)",,,,,"vacuum verbose;",0,,"cdbtm.c",2242,
  145. 2017-06-23 15:45:30.313861 PDT,,,p12592,th-2019084416,,,,0,,,seg-1,,,,,"LOG","00000","3rd party error log:
  146. addr2line: /usr/local/greenplum-db/./lib/libz.so.1: no version information available (required by /lib64/libbfd-2.25.1-22.base.el7.so)",,,,,,,,"SysLoggerMain","syslogger.c",550,
  147. 2017-06-23 15:45:30.383270 PDT,"gpadmin","appriss",p5660,th-2019084416,"[local]",,2017-06-23 14:08:06 PDT,20299569,con1771148,cmd44,seg-1,,dx2631738,x20299569,sx1,"ERROR","XX000","The distributed transaction 'Prepare' broadcast failed to one or more segments for gid = 1492614208-0002631738. (cdbtm.c:689)",,,,,,"vacuum verbose;",0,,"cdbtm.c",689,"Stack trace:
  148. 1 0xb06242 postgres <symbol not found> (elog.c:502)
  149. 2 0xb08258 postgres elog_finish (elog.c:1446)
  150. 3 0xcd6826 postgres prepareDtxTransaction (cdbtm.c:689)
  151. 4 0x543409 postgres CommitTransaction (xact.c:3478)
  152. 5 0x547a75 postgres CommitTransactionCommand (xact.c:4368)
  153. 6 0x742478 postgres <symbol not found> (vacuum.c:1018)
  154. 7 0x7435c2 postgres vacuum (vacuum.c:331)
  155. 8 0x9a485e postgres ProcessUtility (utility.c:1414)
  156. 9 0x9a216b postgres PortalRun (pquery.c:1505)
  157. 10 0x997bfc postgres <symbol not found> (postgres.c:1811)
  158. 11 0x99bb26 postgres PostgresMain (postgres.c:4744)
  159. 12 0x8f93be postgres <symbol not found> (postmaster.c:6673)
  160. 13 0x8fc060 postgres PostmasterMain (postmaster.c:7604)
  161. 14 0x7fd7ef postgres main (main.c:206)
  162. 15 0x7f9583362b35 libc.so.6 __libc_start_main (??:0)
  163. 16 0x4c0149 postgres <symbol not found> (??:?)
  164. "
  165. 2017-06-23 15:45:30.423799 PDT,"gpmon","gpperfmon",p10805,th-2019084416,"[local]",,2017-06-23 15:45:30 PDT,20299623,con1775056,cmd1,seg-1,,dx2631765,x20299623,sx1,"LOG","00000","statement: SELECT sess_id, current_query FROM pg_stat_activity;",,,,,,"SELECT sess_id, current_query FROM pg_stat_activity;",0,,"postgres.c",1619,
  166. 2017-06-23 15:45:33.138668 PDT,"gpmon","gpperfmon",p10834,th-2019084416,"127.0.0.1","2236",2017-06-23 15:45:33 PDT,20299625,con1775057,cmd1,seg-1,,dx2631766,x20299625,sx1,"LOG","00000","statement: SELECT SUM(CASE WHEN status <> 'u' THEN 1 ELSE 0 END) AS degraded,SUM(CASE WHEN mode = 'r' THEN 1 ELSE 0 END) AS resync,SUM(CASE WHEN role <> preferred_role THEN 1 ELSE 0 END) AS unbalanced,to_char(pg_postmaster_start_time(), 'YYYY-MM-DD') || 'T' || to_char(pg_postmaster_start_time(), 'HH24:MI:SS') || to_char(extract('timezone_hour' from pg_postmaster_start_time()), 'S00') ||':' || to_char(extract('timezone_minute' from pg_postmaster_start_time()), 'FM00') AS gpdbstarttime,version() AS gpdbversion,(SELECT COUNT(*) - 1 FROM pg_stat_activity) AS numopenconnections,to_char(now(), 'YYYY-MM-DD') || 'T' || to_char(now(), 'HH24:MI:SS') || to_char(extract('timezone_hour' from now()), 'S00') ||':' || to_char(extract('timezone_minute' from now()), 'FM00') AS localservertime,(SELECT COUNT(*) FROM queries_now WHERE status IN ('start', 'submit')) AS activequeries FROM gp_segment_configuration",,,,,,"SELECT SUM(CASE WHEN status <> 'u' THEN 1 ELSE 0 END) AS degraded,SUM(CASE WHEN mode = 'r' THEN 1 ELSE 0 END) AS resync,SUM(CASE WHEN role <> preferred_role THEN 1 ELSE 0 END) AS unbalanced,to_char(pg_postmaster_start_time(), 'YYYY-MM-DD') || 'T' || to_char(pg_postmaster_start_time(), 'HH24:MI:SS') || to_char(extract('timezone_hour' from pg_postmaster_start_time()), 'S00') ||':' || to_char(extract('timezone_minute' from pg_postmaster_start_time()), 'FM00') AS gpdbstarttime,version() AS gpdbversion,(SELECT COUNT(*) - 1 FROM pg_stat_activity) AS numopenconnections,to_char(now(), 'YYYY-MM-DD') || 'T' || to_char(now(), 'HH24:MI:SS') || to_char(extract('timezone_hour' from now()), 'S00') ||':' || to_char(extract('timezone_minute' from now()), 'FM00') AS localservertime,(SELECT COUNT(*) FROM queries_now WHERE status IN ('start', 'submit')) AS activequeries FROM gp_segment_configuration",0,,"postgres.c",1619,
  167. 2017-06-23 15:45:33.527353 PDT,"gpmon","gpperfmon",p10838,th-2019084416,"127.0.0.1","2238",2017-06-23 15:45:33 PDT,20299627,con1775058,cmd1,seg-1,,dx2631767,x20299627,sx1,"LOG","00000","statement: SELECT DISTINCT query_text,ctime as sample_time,tmid,ssid,ccnt,username,db,cost,tsubmit,tstart,tfinish,case when tfinish is null then ctime - tstart else tfinish - tstart end as exec_time,case when tstart is null then ctime - tsubmit else tstart - tsubmit end as wait_time,status,rows_out,cpu_elapsed,case when cpu_currpct = 0 then 0 else cast(cpu_currpct as decimal(18,2)) end as cpu_currpct,case when skew_cpu = 0 then 0 else cast(skew_cpu as decimal(18,2)) end as skew_cpu,case when skew_rows = 0 then 0 else cast(skew_rows as decimal(18,2)) end as skew_rows,query_hash,rqppriority as priority,rsqname as queuename FROM queries_now qn WHERE status in ('submit','start') LIMIT 250",,,,,,"SELECT DISTINCT query_text,ctime as sample_time,tmid,ssid,ccnt,username,db,cost,tsubmit,tstart,tfinish,case when tfinish is null then ctime - tstart else tfinish - tstart end as exec_time,case when tstart is null then ctime - tsubmit else tstart - tsubmit end as wait_time,status,rows_out,cpu_elapsed,case when cpu_currpct = 0 then 0 else cast(cpu_currpct as decimal(18,2)) end as cpu_currpct,case when skew_cpu = 0 then 0 else cast(skew_cpu as decimal(18,2)) end as skew_cpu,case when skew_rows = 0 then 0 else cast(skew_rows as decimal(18,2)) end as skew_rows,query_hash,rqppriority as priority,rsqname as queuename FROM queries_now qn WHERE status in ('submit','start') LIMIT 250",0,,"postgres.c",1619,
  168. 2017-06-23 15:45:34.880453 PDT,"analytics","appriss",p34448,th-2019084416,"172.16.11.43","62466",2017-06-23 13:53:52 PDT,0,con1770594,cmd3,seg-1,,,,,"LOG","08006","could not receive data from client: Connection reset by peer",,,,,,,0,,"pqcomm.c",875,
  169. 2017-06-23 15:45:34.880573 PDT,"analytics","appriss",p34448,th-2019084416,"172.16.11.43","62466",2017-06-23 13:53:52 PDT,0,con1770594,cmd3,seg-1,,,,,"LOG","08P01","unexpected EOF on client connection",,,,,,,0,,"postgres.c",409,
  170. 2017-06-23 15:45:34.880608 PDT,"analytics","appriss",p34450,th-2019084416,"172.16.11.43","62467",2017-06-23 13:53:52 PDT,0,con1770595,cmd3,seg-1,,,,,"LOG","08006","could not receive data from client: Connection reset by peer",,,,,,,0,,"pqcomm.c",875,
  171. 2017-06-23 15:45:34.880635 PDT,"analytics","appriss",p34450,th-2019084416,"172.16.11.43","62467",2017-06-23 13:53:52 PDT,0,con1770595,cmd3,seg-1,,,,,"LOG","08P01","unexpected EOF on client connection",,,,,,,0,,"postgres.c",409,
  172. 2017-06-23 15:45:35.943046 PDT,"gpmon","gpperfmon",p10866,th-2019084416,"127.0.0.1","2246",2017-06-23 15:45:35 PDT,20299629,con1775059,cmd1,seg-1,,dx2631768,x20299629,sx1,"LOG","00000","statement: SELECT SUM(CASE WHEN status <> 'u' THEN 1 ELSE 0 END) AS degraded,SUM(CASE WHEN mode = 'r' THEN 1 ELSE 0 END) AS resync,SUM(case when role <> preferred_role then 1 else 0 end) unbalanced FROM gp_segment_configuration",,,,,,"SELECT SUM(CASE WHEN status <> 'u' THEN 1 ELSE 0 END) AS degraded,SUM(CASE WHEN mode = 'r' THEN 1 ELSE 0 END) AS resync,SUM(case when role <> preferred_role then 1 else 0 end) unbalanced FROM gp_segment_configuration",0,,"postgres.c",1619,
  173. 2017-06-23 15:45:35.965558 PDT,"gpmon","gpperfmon",p10868,th-2019084416,"127.0.0.1","2248",2017-06-23 15:45:35 PDT,20299632,con1775060,cmd1,seg-1,,dx2631770,x20299632,sx1,"LOG","00000","execute <unnamed>: SELECT count(*) FROM pg_authid a, pg_roles r WHERE pg_has_role($1, a.oid, 'member') AND r.oid = a.oid AND r.rolname = 'gpcc_operator'","parameters: $1 = 'gpmon'",,,,,"SELECT count(*) FROM pg_authid a, pg_roles r WHERE pg_has_role($1, a.oid, 'member') AND r.oid = a.oid AND r.rolname = 'gpcc_operator'",0,,"postgres.c",2730,
  174. 2017-06-23 15:45:35.967792 PDT,"gpmon","gpperfmon",p10868,th-2019084416,"127.0.0.1","2248",2017-06-23 15:45:35 PDT,20299634,con1775060,cmd2,seg-1,,dx2631772,x20299634,sx1,"LOG","00000","execute <unnamed>: SELECT count(*) FROM pg_authid a, pg_roles r WHERE pg_has_role($1, a.oid, 'member') AND r.oid = a.oid AND r.rolname = 'gpcc_operator_readonly'","parameters: $1 = 'gpmon'",,,,,"SELECT count(*) FROM pg_authid a, pg_roles r WHERE pg_has_role($1, a.oid, 'member') AND r.oid = a.oid AND r.rolname = 'gpcc_operator_readonly'",0,,"postgres.c",2730,
  175. 2017-06-23 15:45:35.987700 PDT,"gpmon","gpperfmon",p10870,th-2019084416,"127.0.0.1","2250",2017-06-23 15:45:35 PDT,20299637,con1775061,cmd1,seg-1,,dx2631774,x20299637,sx1,"LOG","00000","execute <unnamed>: SELECT rolsuper FROM pg_roles WHERE rolname = $1","parameters: $1 = 'gpmon'",,,,,"SELECT rolsuper FROM pg_roles WHERE rolname = $1",0,,"postgres.c",2730,
  176. 2017-06-23 15:45:36.061230 PDT,"gpmon","gpperfmon",p10875,th-2019084416,"127.0.0.1","2252",2017-06-23 15:45:36 PDT,20299642,con1775062,cmd1,seg-1,,dx2631775,x20299642,sx1,"LOG","00000","statement: SELECT t.sample_time,COALESCE(swap_page_in, 0) as swap_page_in, COALESCE(swap_page_out, 0) as swap_page_out, COALESCE(cpu_user, 0) as cpu_user, COALESCE(cpu_sys, 0) as cpu_sys, COALESCE(cpu_idle, 0) as cpu_idle, COALESCE(load0, 0) as load0, COALESCE(load1, 0) as load1, COALESCE(load2, 0) as load2, COALESCE(disk_ro_rate, 0) as disk_ro_rate, COALESCE(disk_wo_rate, 0) as disk_wo_rate, COALESCE(net_rp_rate, 0) as net_rp_rate, COALESCE(net_wp_rate, 0) as net_wp_rate,COALESCE(mem_total, 0) as mem_total, COALESCE(mem_used, 0) as mem_used, COALESCE(mem_actual_used, 0) as mem_actual_used, COALESCE(mem_actual_free, 0) as mem_actual_free, COALESCE(swap_total, 0) as swap_total, COALESCE(swap_used, 0) as swap_used, COALESCE(disk_rb_rate, 0) as disk_rb_rate, COALESCE(disk_wb_rate, 0) as disk_wb_rate, COALESCE(net_rb_rate, 0) as net_rb_rate, COALESCE(net_wb_rate, 0) as net_wb_rate,COALESCE(mem_used_pct, 0) as mem_used_pct,COALESCE(queries_total, 0) as queries_total, COALESCE(queries_running, 0) as queries_running, COALESCE(queries_queued, 0) as queries_queued,COALESCE(queries_total_min, 0) as queries_total_min, COALESCE(queries_running_min, 0) as queries_running_min, COALESCE(queries_queued_min, 0) as queries_queued_min,COALESCE(queries_total_max, 0) as queries_total_max, COALESCE(queries_running_max, 0) as queries_running_max, COALESCE(queries_queued_max, 0) as queries_queued_max,COALESCE(s.found, 0) + COALESCE(d.found, 0) AS data_found FROM (SELECT i as sample_time FROM generate_series(date_trunc('minute', CAST('2017-06-23 14:45:36' AS timestamp)), date_trunc('minute', CAST('2017-06-23 15:45:35' AS timestamp)-'1ms'::interval+'1 minute'::interval), '1 minute'::interval) i WHERE i <= CURRENT_TIMESTAMP) AS t LEFT OUTER JOIN (SELECT sample_time,1 AS found,round(avg(swap_page_in)::numeric, 2) as swap_page_in, round(avg(swap_page_out)::numeric, 2) as swap_page_out, round(avg(cpu_user)::numeric, 2) as cpu_user, round(avg(cpu_sys)::numeric, 2) as cpu_sys, round(avg(cpu_idle)::numeric, 2) as cpu_idle, round(avg(load0)::numeric, 2) as load0, round(avg(load1)::numeric, 2) as load1, round(avg(load2)::numeric, 2) as load2, round(avg(disk_ro_rate)::numeric, 2) as disk_ro_rate, round(avg(disk_wo_rate)::numeric, 2) as disk_wo_rate, round(avg(net_rp_rate)::numeric, 2) as net_rp_rate, round(avg(net_wp_rate)::numeric, 2) as net_wp_rate,round((avg(mem_total)::real/1048576)::numeric, 2) as mem_total, round((avg(mem_used)::real/1048576)::numeric, 2) as mem_used, round((avg(mem_actual_used)::real/1048576)::numeric, 2) as mem_actual_used, round((avg(mem_actual_free)::real/1048576)::numeric, 2) as mem_actual_free, round((avg(swap_total)::real/1048576)::numeric, 2) as swap_total, round((avg(swap_used)::real/1048576)::numeric, 2) as swap_used, round((avg(disk_rb_rate)::real/1048576)::numeric, 2) as disk_rb_rate, round((avg(disk_wb_rate)::real/1048576)::numeric, 2) as disk_wb_rate, round((avg(net_rb_rate)::real/1048576)::numeric, 2) as net_rb_rate, round((avg(net_wb_rate)::real/1048576)::numeric, 2) as net_wb_rate,round(100.0*(avg(mem_actual_used)::numeric/avg(mem_total)::numeric), 2) as mem_used_pct FROM (SELECT date_trunc('minute', ctime) AS sample_time,* FROM (SELECT * FROM system_now UNION SELECT * FROM system_tail UNION SELECT * FROM _system_tail UNION SELECT * FROM system_history WHERE date_trunc('minute', CAST('2017-06-23 14:45:36' AS timestamp)) <= ctime AND ctime < date_trunc('minute', CAST('2017-06-23 15:45:35' AS timestamp)-'1ms'::interval+'1 minute'::interval)+'1 minute'::interval ) AS su WHERE (hostname IN (SELECT hostname FROM gp_segment_configuration WHERE content >= 0) OR (hostname NOT LIKE 'mdw%' AND hostname NOT LIKE 'smdw%' AND hostname NOT IN (SELECT hostname FROM gp_segment_configuration WHERE content < 0))) AND date_trunc('minute', CAST('2017-06-23 14:45:36' AS timestamp)) <= ctime AND ctime < date_trunc('minute', CAST('2017-06-23 15:45:35' AS timestamp)-'1ms'::interval+'1 minute'::interval)+'1 minute'::interval) AS st GROUP BY sample_time) AS s ON s.sample_time = t.sample_time LEFT OUTER JOIN (SELECT sample_time,1 AS found,ceil(avg(queries_total)) as queries_total, ceil(avg(queries_running)) as queries_running, ceil(avg(queries_queued)) as queries_queued,min(queries_total) as queries_total_min, min(queries_running) as queries_running_min, min(queries_queued) as queries_queued_min,max(queries_total) as queries_total_max, max(queries_running) as queries_running_max, max(queries_queued) as queries_queued_max FROM (SELECT date_trunc('minute', ctime) AS sample_time,* FROM (SELECT * FROM database_now UNION SELECT * FROM database_tail UNION SELECT * FROM _database_tail UNION SELECT * FROM database_history WHERE date_trunc('minute', CAST('2017-06-23 14:45:36' AS timestamp)) <= ctime AND ctime < date_trunc('minute', CAST('2017-06-23 15:45:35' AS timestamp)-'1ms'::interval+'1 minute'::interval)+'1 minute'::interval ) AS du WHERE date_trunc('minute', CAST('2017-06-23 14:45:36' AS timestamp)) <= ctime AND ctime < date_trunc('minute', CAST('2017-06-23 15:45:35' AS timestamp)-'1ms'::interval+'1 minute'::interval)+'1 minute'::interval) AS dt GROUP BY sample_time) AS d ON d.sample_time = t.sample_time",,,,,,"SELECT t.sample_time,COALESCE(swap_page_in, 0) as swap_page_in, COALESCE(swap_page_out, 0) as swap_page_out, COALESCE(cpu_user, 0) as cpu_user, COALESCE(cpu_sys, 0) as cpu_sys, COALESCE(cpu_idle, 0) as cpu_idle, COALESCE(load0, 0) as load0, COALESCE(load1, 0) as load1, COALESCE(load2, 0) as load2, COALESCE(disk_ro_rate, 0) as disk_ro_rate, COALESCE(disk_wo_rate, 0) as disk_wo_rate, COALESCE(net_rp_rate, 0) as net_rp_rate, COALESCE(net_wp_rate, 0) as net_wp_rate,COALESCE(mem_total, 0) as mem_total, COALESCE(mem_used, 0) as mem_used, COALESCE(mem_actual_used, 0) as mem_actual_used, COALESCE(mem_actual_free, 0) as mem_actual_free, COALESCE(swap_total, 0) as swap_total, COALESCE(swap_used, 0) as swap_used, COALESCE(disk_rb_rate, 0) as disk_rb_rate, COALESCE(disk_wb_rate, 0) as disk_wb_rate, COALESCE(net_rb_rate, 0) as net_rb_rate, COALESCE(net_wb_rate, 0) as net_wb_rate,COALESCE(mem_used_pct, 0) as mem_used_pct,COALESCE(queries_total, 0) as queries_total, COALESCE(queries_running, 0) as queries_running, COALESCE(queries_queued, 0) as queries_queued,COALESCE(queries_total_min, 0) as queries_total_min, COALESCE(queries_running_min, 0) as queries_running_min, COALESCE(queries_queued_min, 0) as queries_queued_min,COALESCE(queries_total_max, 0) as queries_total_max, COALESCE(queries_running_max, 0) as queries_running_max, COALESCE(queries_queued_max, 0) as queries_queued_max,COALESCE(s.found, 0) + COALESCE(d.found, 0) AS data_found FROM (SELECT i as sample_time FROM generate_series(date_trunc('minute', CAST('2017-06-23 14:45:36' AS timestamp)), date_trunc('minute', CAST('2017-06-23 15:45:35' AS timestamp)-'1ms'::interval+'1 minute'::interval), '1 minute'::interval) i WHERE i <= CURRENT_TIMESTAMP) AS t LEFT OUTER JOIN (SELECT sample_time,1 AS found,round(avg(swap_page_in)::numeric, 2) as swap_page_in, round(avg(swap_page_out)::numeric, 2) as swap_page_out, round(avg(cpu_user)::numeric, 2) as cpu_user, round(avg(cpu_sys)::numeric, 2) as cpu_sys, round(avg(cpu_idle)::numeric, 2) as cpu_idle, round(avg(load0)::numeric, 2) as load0, round(avg(load1)::numeric, 2) as load1, round(avg(load2)::numeric, 2) as load2, round(avg(disk_ro_rate)::numeric, 2) as disk_ro_rate, round(avg(disk_wo_rate)::numeric, 2) as disk_wo_rate, round(avg(net_rp_rate)::numeric, 2) as net_rp_rate, round(avg(net_wp_rate)::numeric, 2) as net_wp_rate,round((avg(mem_total)::real/1048576)::numeric, 2) as mem_total, round((avg(mem_used)::real/1048576)::numeric, 2) as mem_used, round((avg(mem_actual_used)::real/1048576)::numeric, 2) as mem_actual_used, round((avg(mem_actual_free)::real/1048576)::numeric, 2) as mem_actual_free, round((avg(swap_total)::real/1048576)::numeric, 2) as swap_total, round((avg(swap_used)::real/1048576)::numeric, 2) as swap_used, round((avg(disk_rb_rate)::real/1048576)::numeric, 2) as disk_rb_rate, round((avg(disk_wb_rate)::real/1048576)::numeric, 2) as disk_wb_rate, round((avg(net_rb_rate)::real/1048576)::numeric, 2) as net_rb_rate, round((avg(net_wb_rate)::real/1048576)::numeric, 2) as net_wb_rate,round(100.0*(avg(mem_actual_used)::numeric/avg(mem_total)::numeric), 2) as mem_used_pct FROM (SELECT date_trunc('minute', ctime) AS sample_time,* FROM (SELECT * FROM system_now UNION SELECT * FROM system_tail UNION SELECT * FROM _system_tail UNION SELECT * FROM system_history WHERE date_trunc('minute', CAST('2017-06-23 14:45:36' AS timestamp)) <= ctime AND ctime < date_trunc('minute', CAST('2017-06-23 15:45:35' AS timestamp)-'1ms'::interval+'1 minute'::interval)+'1 minute'::interval ) AS su WHERE (hostname IN (SELECT hostname FROM gp_segment_configuration WHERE content >= 0) OR (hostname NOT LIKE 'mdw%' AND hostname NOT LIKE 'smdw%' AND hostname NOT IN (SELECT hostname FROM gp_segment_configuration WHERE content < 0))) AND date_trunc('minute', CAST('2017-06-23 14:45:36' AS timestamp)) <= ctime AND ctime < date_trunc('minute', CAST('2017-06-23 15:45:35' AS timestamp)-'1ms'::interval+'1 minute'::interval)+'1 minute'::interval) AS st GROUP BY sample_time) AS s ON s.sample_time = t.sample_time LEFT OUTER JOIN (SELECT sample_time,1 AS found,ceil(avg(queries_total)) as queries_total, ceil(avg(queries_running)) as queries_running, ceil(avg(queries_queued)) as queries_queued,min(queries_total) as queries_total_min, min(queries_running) as queries_running_min, min(queries_queued) as queries_queued_min,max(queries_total) as queries_total_max, max(queries_running) as queries_running_max, max(queries_queued) as queries_queued_max FROM (SELECT date_trunc('minute', ctime) AS sample_time,* FROM (SELECT * FROM database_now UNION SELECT * FROM database_tail UNION SELECT * FROM _database_tail UNION SELECT * FROM database_history WHERE date_trunc('minute', CAST('2017-06-23 14:45:36' AS timestamp)) <= ctime AND ctime < date_trunc('minute', CAST('2017-06-23 15:45:35' AS timestamp)-'1ms'::interval+'1 minute'::interval)+'1 minute'::interval ) AS du WHERE date_trunc('minute', CAST('2017-06-23 14:45:36' AS timestamp)) <= ctime AND ctime < date_trunc('minute', CAST('2017-06-23 15:45:35' AS timestamp)-'1ms'::interval+'1 minute'::interval)+'1 minute'::interval) AS dt GROUP BY sample_time) AS d ON d.sample_time = t.sample_time",0,,"postgres.c",1619,
  177. 2017-06-23 15:45:36.061673 PDT,"gpmon","gpperfmon",p10876,th-2019084416,"127.0.0.1","2254",2017-06-23 15:45:36 PDT,20299643,con1775063,cmd1,seg-1,,dx2631776,x20299643,sx1,"LOG","00000","statement: SELECT DISTINCT query_text,ctime as sample_time,tmid,ssid,ccnt,username,db,cost,tsubmit,tstart,tfinish,case when tfinish is null then ctime - tstart else tfinish - tstart end as exec_time,case when tstart is null then ctime - tsubmit else tstart - tsubmit end as wait_time,status,rows_out,cpu_elapsed,case when cpu_currpct = 0 then 0 else cast(cpu_currpct as decimal(18,2)) end as cpu_currpct,case when skew_cpu = 0 then 0 else cast(skew_cpu as decimal(18,2)) end as skew_cpu,case when skew_rows = 0 then 0 else cast(skew_rows as decimal(18,2)) end as skew_rows,query_hash,rqppriority as priority,rsqname as queuename FROM queries_now qn WHERE status in ('submit','start') LIMIT 250",,,,,,"SELECT DISTINCT query_text,ctime as sample_time,tmid,ssid,ccnt,username,db,cost,tsubmit,tstart,tfinish,case when tfinish is null then ctime - tstart else tfinish - tstart end as exec_time,case when tstart is null then ctime - tsubmit else tstart - tsubmit end as wait_time,status,rows_out,cpu_elapsed,case when cpu_currpct = 0 then 0 else cast(cpu_currpct as decimal(18,2)) end as cpu_currpct,case when skew_cpu = 0 then 0 else cast(skew_cpu as decimal(18,2)) end as skew_cpu,case when skew_rows = 0 then 0 else cast(skew_rows as decimal(18,2)) end as skew_rows,query_hash,rqppriority as priority,rsqname as queuename FROM queries_now qn WHERE status in ('submit','start') LIMIT 250",0,,"postgres.c",1619,
  178. 2017-06-23 15:45:36.061936 PDT,"gpmon","gpperfmon",p10878,th-2019084416,"127.0.0.1","2258",2017-06-23 15:45:36 PDT,20299644,con1775065,cmd1,seg-1,,dx2631777,x20299644,sx1,"LOG","00000","statement: SELECT (max(sample_time)) AS sample_time,(count(distinct(hostname))) AS hosts_current,hosttype as hostname,sum(total_bytes) as total_bytes, sum(bytes_used) as bytes_used, sum(bytes_available) as bytes_available FROM (SELECT DISTINCT sample_time, hostname, filesystem, hosttype, total_bytes, bytes_used, bytes_available FROM (SELECT *, rank() over (partition by dbid, hostname order by dt.len desc) rn FROM (SELECT sample_time, dbid, hostname, filesystem, hosttype, position(filesystem in datadir) as pos, length(filesystem) as len,round((total_bytes::real/1073741824)::numeric, 2) as total_bytes, round((bytes_used::real/1073741824)::numeric, 2) as bytes_used, round((bytes_available::real/1073741824)::numeric, 2) as bytes_available FROM (SELECT ctime as sample_time,* FROM diskspace_history WHERE ctime IN ( select distinct max(ctime) from diskspace_history )) AS a,(SELECT hostname as customerhostname,case when content < 0 then 'master' else 'sdw' end as hosttype,fselocation as datadir,pgfse.fsedbid as dbid FROM gp_segment_configuration gpsec, pg_filespace_entry pgfse WHERE pgfse.fsedbid=gpsec.dbid) AS gseg WHERE hostname=customerhostname) AS dt WHERE dt.pos = 1) AS dt2 WHERE dt2.rn <= 1) AS c GROUP BY hosttype",,,,,,"SELECT (max(sample_time)) AS sample_time,(count(distinct(hostname))) AS hosts_current,hosttype as hostname,sum(total_bytes) as total_bytes, sum(bytes_used) as bytes_used, sum(bytes_available) as bytes_available FROM (SELECT DISTINCT sample_time, hostname, filesystem, hosttype, total_bytes, bytes_used, bytes_available FROM (SELECT *, rank() over (partition by dbid, hostname order by dt.len desc) rn FROM (SELECT sample_time, dbid, hostname, filesystem, hosttype, position(filesystem in datadir) as pos, length(filesystem) as len,round((total_bytes::real/1073741824)::numeric, 2) as total_bytes, round((bytes_used::real/1073741824)::numeric, 2) as bytes_used, round((bytes_available::real/1073741824)::numeric, 2) as bytes_available FROM (SELECT ctime as sample_time,* FROM diskspace_history WHERE ctime IN ( select distinct max(ctime) from diskspace_history )) AS a,(SELECT hostname as customerhostname,case when content < 0 then 'master' else 'sdw' end as hosttype,fselocation as datadir,pgfse.fsedbid as dbid FROM gp_segment_configuration gpsec, pg_filespace_entry pgfse WHERE pgfse.fsedbid=gpsec.dbid) AS gseg WHERE hostname=customerhostname) AS dt WHERE dt.pos = 1) AS dt2 WHERE dt2.rn <= 1) AS c GROUP BY hosttype",0,,"postgres.c",1619,
  179. 2017-06-23 15:45:36.062889 PDT,"gpmon","gpperfmon",p10877,th-2019084416,"127.0.0.1","2256",2017-06-23 15:45:36 PDT,20299645,con1775064,cmd1,seg-1,,dx2631778,x20299645,sx1,"LOG","00000","statement: SELECT dbid, content, role, preferred_role, mode, status, port, hostname, address, replication_port, recovery_done, recovery_total, count, latest_event, latest_event_description AS event_description FROM (SELECT (a).* FROM (SELECT gpcmdr_instance_analyticsgp.segment_configuration_recovery(segconf.dbid, segconf.content, segconf.role, segconf.preferred_role, segconf.mode, segconf.status, segconf.port, segconf.hostname, segconf.address, segconf.replication_port, count, latest_event, latest_event_description) as a FROM gp_segment_configuration segconf LEFT OUTER JOIN (SELECT T.*, gch.desc as latest_event_description FROM (SELECT dbid, count(*) as count, max(time) as latest_event FROM gp_configuration_history GROUP BY dbid) AS T,gp_configuration_history as gch WHERE T.dbid=gch.dbid AND T.latest_event=gch.time) AS conf_hist ON segconf.dbid=conf_hist.dbid WHERE segconf.content >= 0) AS g) AS h",,,,,,"SELECT dbid, content, role, preferred_role, mode, status, port, hostname, address, replication_port, recovery_done, recovery_total, count, latest_event, latest_event_description AS event_description FROM (SELECT (a).* FROM (SELECT gpcmdr_instance_analyticsgp.segment_configuration_recovery(segconf.dbid, segconf.content, segconf.role, segconf.preferred_role, segconf.mode, segconf.status, segconf.port, segconf.hostname, segconf.address, segconf.replication_port, count, latest_event, latest_event_description) as a FROM gp_segment_configuration segconf LEFT OUTER JOIN (SELECT T.*, gch.desc as latest_event_description FROM (SELECT dbid, count(*) as count, max(time) as latest_event FROM gp_configuration_history GROUP BY dbid) AS T,gp_configuration_history as gch WHERE T.dbid=gch.dbid AND T.latest_event=gch.time) AS conf_hist ON segconf.dbid=conf_hist.dbid WHERE segconf.content >= 0) AS g) AS h",0,,"postgres.c",1619,
  180. 2017-06-23 15:45:36.926126 PDT,"gpadmin","appriss",p5660,th-2019084416,"[local]",,2017-06-23 14:08:06 PDT,20299569,con1771148,cmd44,seg-1,,dx2631738,x20299569,sx1,"LOG","00000","DTM error (gathered 144 results from cmd 'Distributed Abort (Some Prepared)')","Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg0 gpseg10:40000 pid=48899)
  181. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg1 gpseg10:40001 pid=48901)
  182. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg2 gpseg10:40002 pid=48903)
  183. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg3 gpseg10:40003 pid=48905)
  184. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg4 gpseg10:40004 pid=48907)
  185. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg5 gpseg10:40005 pid=48909)
  186. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg6 gpseg11:40000 pid=19942)
  187. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg7 gpseg11:40001 pid=19944)
  188. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg8 gpseg11:40002 pid=19946)
  189. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg9 gpseg11:40003 pid=19948)
  190. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg10 gpseg11:40004 pid=19950)
  191. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg11 gpseg11:40005 pid=19952)
  192. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg12 gpseg12:40000 pid=36134)
  193. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg13 gpseg12:40001 pid=36136)
  194. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg14 gpseg12:40002 pid=36138)
  195. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg15 gpseg12:40003 pid=36140)
  196. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg16 gpseg12:40004 pid=36142)
  197. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg17 gpseg12:40005 pid=36144)
  198. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg18 gpseg13:40000 pid=19477)
  199. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg19 gpseg13:40001 pid=19479)
  200. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg20 gpseg13:40002 pid=19481)
  201. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg21 gpseg13:40003 pid=19483)
  202. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg22 gpseg13:40004 pid=19485)
  203. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg23 gpseg13:40005 pid=19487)
  204. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg24 gpseg14:40000 pid=22677)
  205. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg25 gpseg14:40001 pid=22679)
  206. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg26 gpseg14:40002 pid=22681)
  207. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg27 gpseg14:40003 pid=22683)
  208. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg28 gpseg14:40004 pid=22685)
  209. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg29 gpseg14:40005 pid=22687)
  210. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg30 gpseg15:40000 pid=26276)
  211. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg31 gpseg15:40001 pid=26278)
  212. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg32 gpseg15:40002 pid=26280)
  213. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg33 gpseg15:40003 pid=26282)
  214. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg34 gpseg15:40004 pid=26284)
  215. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg35 gpseg15:40005 pid=26286)
  216. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg36 gpseg16:40000 pid=15722)
  217. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg37 gpseg16:40001 pid=15724)
  218. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg38 gpseg16:40002 pid=15726)
  219. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg39 gpseg16:40003 pid=15728)
  220. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg40 gpseg16:40004 pid=15730)
  221. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg41 gpseg16:40005 pid=15732)
  222. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg42 gpseg17:40000 pid=8533)
  223. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg43 gpseg17:40001 pid=8535)
  224. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg44 gpseg17:40002 pid=8537)
  225. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg45 gpseg17:40003 pid=8539)
  226. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg46 gpseg17:40004 pid=8541)
  227. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg47 gpseg17:40005 pid=8543)
  228. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg48 gpseg18:40000 pid=5052)
  229. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg49 gpseg18:40001 pid=5054)
  230. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg50 gpseg18:40002 pid=5056)
  231. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg51 gpseg18:40003 pid=5058)
  232. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg52 gpseg18:40004 pid=5060)
  233. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg53 gpseg18:40005 pid=5062)
  234. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg54 gpseg19:40000 pid=39353)
  235. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg55 gpseg19:40001 pid=39355)
  236. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg56 gpseg19:40002 pid=39357)
  237. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg57 gpseg19:40003 pid=39359)
  238. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg58 gpseg19:40004 pid=39361)
  239. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg59 gpseg19:40005 pid=39363)
  240. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg60 gpseg1:40000 pid=43824)
  241. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg61 gpseg21:50001 pid=7578)
  242. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg62 gpseg1:40002 pid=43826)
  243. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg63 gpseg1:40003 pid=43828)
  244. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg64 gpseg1:40004 pid=43820)
  245. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg65 gpseg1:40005 pid=43822)
  246. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg66 gpseg20:40000 pid=36792)
  247. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg67 gpseg20:40001 pid=36794)
  248. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg68 gpseg20:40002 pid=36796)
  249. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg69 gpseg20:40003 pid=36798)
  250. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg70 gpseg20:40004 pid=36800)
  251. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg71 gpseg20:40005 pid=36802)
  252. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg72 gpseg21:40000 pid=7565)
  253. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg73 gpseg21:40001 pid=7567)
  254. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg74 gpseg21:40002 pid=7569)
  255. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg75 gpseg21:40003 pid=7571)
  256. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg76 gpseg21:40004 pid=7573)
  257. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg77 gpseg21:40005 pid=7575)
  258. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg78 gpseg22:40000 pid=34178)
  259. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg79 gpseg22:40001 pid=34180)
  260. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg80 gpseg22:40002 pid=34182)
  261. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg81 gpseg22:40003 pid=34184)
  262. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg82 gpseg22:40004 pid=34186)
  263. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg83 gpseg22:40005 pid=34188)
  264. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg84 gpseg23:40000 pid=17962)
  265. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg85 gpseg23:40001 pid=17964)
  266. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg86 gpseg23:40002 pid=17966)
  267. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg87 gpseg23:40003 pid=17968)
  268. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg88 gpseg23:40004 pid=17970)
  269. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg89 gpseg23:40005 pid=17972)
  270. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg90 gpseg24:40000 pid=15287)
  271. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg91 gpseg24:40001 pid=15289)
  272. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg92 gpseg24:40002 pid=15291)
  273. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg93 gpseg24:40003 pid=15293)
  274. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg94 gpseg24:40004 pid=15295)
  275. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg95 gpseg24:40005 pid=15297)
  276. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg96 gpseg2:40000 pid=27937)
  277. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg97 gpseg2:40001 pid=27939)
  278. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg98 gpseg2:40002 pid=27941)
  279. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg99 gpseg2:40003 pid=27943)
  280. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg100 gpseg2:40004 pid=27945)
  281. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg101 gpseg2:40005 pid=27947)
  282. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg102 gpseg3:40000 pid=17654)
  283. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg103 gpseg3:40001 pid=17656)
  284. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg104 gpseg3:40002 pid=17658)
  285. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg105 gpseg3:40003 pid=17660)
  286. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg106 gpseg3:40004 pid=17662)
  287. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg107 gpseg3:40005 pid=17664)
  288. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg108 gpseg4:40000 pid=47799)
  289. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg109 gpseg4:40001 pid=47801)
  290. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg110 gpseg4:40002 pid=47803)
  291. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg111 gpseg4:40003 pid=47805)
  292. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg112 gpseg4:40004 pid=47807)
  293. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg113 gpseg4:40005 pid=47809)
  294. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg114 gpseg5:40000 pid=36909)
  295. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg115 gpseg5:40001 pid=36911)
  296. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg116 gpseg5:40002 pid=36913)
  297. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg117 gpseg5:40003 pid=36915)
  298. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg118 gpseg5:40004 pid=36917)
  299. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg119 gpseg5:40005 pid=36919)
  300. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg120 gpseg6:40000 pid=48387)
  301. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg121 gpseg6:40001 pid=48389)
  302. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg122 gpseg6:40002 pid=48391)
  303. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg123 gpseg6:40003 pid=48393)
  304. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg124 gpseg6:40004 pid=48395)
  305. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg125 gpseg6:40005 pid=48397)
  306. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg126 gpseg7:40000 pid=21165)
  307. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg127 gpseg7:40001 pid=21167)
  308. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg128 gpseg7:40002 pid=21157)
  309. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg129 gpseg7:40003 pid=21159)
  310. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg130 gpseg7:40004 pid=21161)
  311. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg131 gpseg7:40005 pid=21163)
  312. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg132 gpseg8:40000 pid=19819)
  313. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg133 gpseg8:40001 pid=19821)
  314. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg134 gpseg8:40002 pid=19823)
  315. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg135 gpseg8:40003 pid=19825)
  316. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg136 gpseg8:40004 pid=19827)
  317. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg137 gpseg8:40005 pid=19829)
  318. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg138 gpseg9:40000 pid=12199)
  319. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg139 gpseg9:40001 pid=12201)
  320. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg140 gpseg9:40002 pid=12203)
  321. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg141 gpseg9:40003 pid=12205)
  322. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg142 gpseg9:40004 pid=12207)
  323. Distributed transaction 1492614208-0002631738 not found (cdbtm.c:4372) (seg143 gpseg9:40005 pid=12209)",,,,,,0,,"cdbtm.c",2242,
  324. 2017-06-23 15:45:36.926789 PDT,"gpadmin","appriss",p5660,th-2019084416,"[local]",,2017-06-23 14:08:06 PDT,20299569,con1771148,cmd44,seg-1,,dx2631738,x20299569,sx1,"WARNING","01000","The distributed transaction 'Abort [Prepared]' broadcast failed to one or more segments for gid = 1492614208-0002631738.",,,,,,,0,,"cdbtm.c",918,
  325. 2017-06-23 15:45:36.929463 PDT,"gpadmin","appriss",p5660,th-2019084416,"[local]",,2017-06-23 14:08:06 PDT,20299569,con1775066,,seg-1,,dx2631738,x20299569,sx1,"LOG","00000","The previous session was reset because its gang was disconnected (session id = 1771148). The new session id = 1775066",,,,,,,0,,"cdbgang.c",2669,
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!