API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 14th, 2014
398
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.21 KB | None | 0 0
raw download clone embed print report
  1. (gdb) bt
  2. #0 errfinish (dummy=0) at elog.c:411
  3. #1 0x000000000060e7bd in lazy_vacuum_index (indrel=0x7f600adc4928, stats=0x276be38, vacrelstats=0x276bc80) at vacuumlazy.c:1337
  4. #2 0x000000000060dea3 in lazy_scan_heap (onerel=0x7f600ae70e78, vacrelstats=0x276bc80, Irel=0x276c490, nindexes=3, scan_all=0 '\000') at vacuumlazy.c:1076
  5. #3 0x000000000060ca6d in lazy_vacuum_rel (onerel=0x7f600ae70e78, vacstmt=0x27012c0, bstrategy=0x27658a0) at vacuumlazy.c:239
  6. #4 0x000000000060c5d8 in vacuum_rel (relid=16400, vacstmt=0x27012c0, do_toast=1 '\001', for_wraparound=0 '\000') at vacuum.c:1285
  7. #5 0x000000000060b0b0 in vacuum (vacstmt=0x27012c0, relid=0, do_toast=1 '\001', bstrategy=0x27658a0, for_wraparound=0 '\000', isTopLevel=1 '\001') at vacuum.c:237
  8. #6 0x000000000076ef39 in standard_ProcessUtility (parsetree=0x27012c0, queryString=0x2700890 "VACUUM VERBOSE ANALYZE sales;", context=PROCESS_UTILITY_TOPLEVEL, params=0x0, dest=0x2701620, completionTag=0x7fff9089e1d0 "")
  9. at utility.c:641
  10. #7 0x000000000076e683 in ProcessUtility (parsetree=0x27012c0, queryString=0x2700890 "VACUUM VERBOSE ANALYZE sales;", context=PROCESS_UTILITY_TOPLEVEL, params=0x0, dest=0x2701620, completionTag=0x7fff9089e1d0 "") at utility.c:311
  11. #8 0x000000000076d81d in PortalRunUtility (portal=0x2769880, utilityStmt=0x27012c0, isTopLevel=1 '\001', dest=0x2701620, completionTag=0x7fff9089e1d0 "") at pquery.c:1187
  12. #9 0x000000000076d9c9 in PortalRunMulti (portal=0x2769880, isTopLevel=1 '\001', dest=0x2701620, altdest=0x2701620, completionTag=0x7fff9089e1d0 "") at pquery.c:1318
  13. #10 0x000000000076cf99 in PortalRun (portal=0x2769880, count=9223372036854775807, isTopLevel=1 '\001', dest=0x2701620, altdest=0x2701620, completionTag=0x7fff9089e1d0 "") at pquery.c:816
  14. #11 0x000000000076705c in exec_simple_query (query_string=0x2700890 "VACUUM VERBOSE ANALYZE sales;") at postgres.c:1045
  15. #12 0x000000000076b287 in PostgresMain (argc=1, argv=0x26a5978, dbname=0x26a5830 "minmax", username=0x26a5810 "sekondquad") at postgres.c:4010
  16. #13 0x00000000006fac3a in BackendRun (port=0x26c4660) at postmaster.c:4112
  17. #14 0x00000000006fa2d0 in BackendStartup (port=0x26c4660) at postmaster.c:3787
  18. #15 0x00000000006f6ae7 in ServerLoop () at postmaster.c:1566
  19. #16 0x00000000006f61b7 in PostmasterMain (argc=3, argv=0x26a4a50) at postmaster.c:1219
  20. #17 0x000000000065d49b in main (argc=3, argv=0x26a4a50) at main.c:219
  21.  
  22.  
  23. FULL
  24.  
  25. #0 errfinish (dummy=0) at elog.c:411
  26. edata = 0x26f5480
  27. elevel = -1870014432
  28. save_ImmediateInterruptOK = 0 '\000'
  29. oldcontext = 0x26a7040
  30. econtext = 0xd10da0
  31. __func__ = "errfinish"
  32. #1 0x000000000060e7bd in lazy_vacuum_index (indrel=0x7f600adc4928, stats=0x276be38, vacrelstats=0x276bc80) at vacuumlazy.c:1337
  33. ivinfo = {index = 0x7f600adc4928, analyze_only = 0 '\000', estimated_count = 1 '\001', message_level = 17, num_heap_tuples = 2273835, strategy = 0x27658a0}
  34. ru0 = {tv = {tv_sec = 1410745836, tv_usec = 814050}, ru = {ru_utime = {tv_sec = 2, tv_usec = 82221}, ru_stime = {tv_sec = 0, tv_usec = 279225}, ru_maxrss = 58228, ru_ixrss = 0, ru_idrss = 0, ru_isrss = 0, ru_minflt = 12954,
  35. ru_majflt = 0, ru_nswap = 0, ru_inblock = 0, ru_oublock = 251328, ru_msgsnd = 0, ru_msgrcv = 0, ru_nsignals = 0, ru_nvcsw = 1417, ru_nivcsw = 293}}
  36. __func__ = "lazy_vacuum_index"
  37. #2 0x000000000060dea3 in lazy_scan_heap (onerel=0x7f600ae70e78, vacrelstats=0x276bc80, Irel=0x276c490, nindexes=3, scan_all=0 '\000') at vacuumlazy.c:1076
  38. nblocks = 48701
  39. blkno = 48701
  40. tuple = {t_len = 60, t_self = {ip_blkid = {bi_hi = 0, bi_lo = 48700}, ip_posid = 120}, t_tableOid = 16400, t_data = 0x7f600c0af9c0}
  41. relname = 0x7f600adbd348 "sales"
  42. empty_pages = 0
  43. vacuumed_pages = 0
  44. num_tuples = 4949272
  45. tups_vacuumed = 0
  46. nkeep = 9
  47. nunused = 0
  48. indstats = 0x276be30
  49. i = 1
  50. ru0 = {tv = {tv_sec = 1410745692, tv_usec = 124096}, ru = {ru_utime = {tv_sec = 0, tv_usec = 22617}, ru_stime = {tv_sec = 0, tv_usec = 8092}, ru_maxrss = 15312, ru_ixrss = 0, ru_idrss = 0, ru_isrss = 0, ru_minflt = 2127,
  51. ru_majflt = 0, ru_nswap = 0, ru_inblock = 0, ru_oublock = 0, ru_msgsnd = 0, ru_msgrcv = 0, ru_nsignals = 0, ru_nvcsw = 21, ru_nivcsw = 2}}
  52. vmbuffer = 0
  53. next_not_all_visible_block = 48701
  54. skipping_all_visible_blocks = 0 '\000'
  55. frozen = 0x276c598
  56. __func__ = "lazy_scan_heap"
  57. #3 0x000000000060ca6d in lazy_vacuum_rel (onerel=0x7f600ae70e78, vacstmt=0x27012c0, bstrategy=0x27658a0) at vacuumlazy.c:239
  58. vacrelstats = 0x276bc80
  59. Irel = 0x276c490
  60. nindexes = 3
  61. possibly_freeable = 2
  62. ru0 = {tv = {tv_sec = 40851648, tv_usec = 4335608432}, ru = {ru_utime = {tv_sec = 140735618341872, tv_usec = 7666392}, ru_stime = {tv_sec = 162, tv_usec = 40713217}, ru_maxrss = 17184449281, ru_ixrss = 140735618341952,
  63. ru_idrss = 70437463670784, ru_isrss = 72057594037927936, ru_minflt = 140733193388036, ru_majflt = 0, ru_nswap = 16400, ru_inblock = 10395712, ru_oublock = 140735618341712, ru_msgsnd = 20, ru_msgrcv = 16400,
  64. ru_nsignals = 40646432, ru_nvcsw = 140735618341904, ru_nivcsw = 140050638375828}}
  65. starttime = 0
  66. secs = 140050638375828
  67. usecs = 32767
  68. read_rate = 8.7707378005553088e-315
  69. write_rate = 4.9406564584124654e-324
  70. scan_all = 0 '\000'
  71. scanned_all = 0 '\000'
  72. xidFullScanLimit = 4144968722
  73. mxactFullScanLimit = 4144967297
  74. new_rel_pages = 344787860
  75. new_rel_tuples = 5.4323095486817214e-312
  76. new_rel_allvisible = 32608
  77. new_live_tuples = 0
  78. new_frozen_xid = 0
  79. new_min_multi = 4
  80. __func__ = "lazy_vacuum_rel"
  81.  
  82.  
  83. onerel = 0x7f600ae70e78
  84. onerelid = {relId = 16400, dbId = 16384}
  85. toast_relid = 16405
  86. save_userid = 10
  87. save_sec_context = 0
  88. save_nestlevel = 2
  89. __func__ = "vacuum_rel"
  90. #5 0x000000000060b0b0 in vacuum (vacstmt=0x27012c0, relid=0, do_toast=1 '\001', bstrategy=0x27658a0, for_wraparound=0 '\000', isTopLevel=1 '\001') at vacuum.c:237
  91. relid = 16400
  92. cur = 0x27659b0
  93. save_exception_stack = 0x7fff9089e020
  94. save_context_stack = 0x0
  95. local_sigjmp_buf = {{__jmpbuf = {0, -239893133770819443, 4581360, 140735618344880, 0, 0, -239893133733070707, 239987815718254733}, __mask_was_saved = 0, __saved_mask = {__val = {512, 140050476502648, 140735618342304,
  96. 140050638375828, 12, 140735618342336, 140050638375828, 10413873, 0, 0, 40896656, 10413873, 40900128, 140735618343376, 5194143, 10413873}}}}
  97. stmttype = 0x9c1be0 "VACUUM"
  98. in_outer_xact = 0 '\000'
  99. use_own_xacts = 1 '\001'
  100. relations = 0x27659d0
  101. #6 0x000000000076ef39 in standard_ProcessUtility (parsetree=0x27012c0, queryString=0x2700890 "VACUUM VERBOSE ANALYZE sales;", context=PROCESS_UTILITY_TOPLEVEL, params=0x0, dest=0x2701620, completionTag=0x7fff9089e1d0 "")
  102. at utility.c:641
  103. stmt = 0x27012c0
  104. isTopLevel = 1 '\001'
  105. __func__ = "standard_ProcessUtility"
  106. #7 0x000000000076e683 in ProcessUtility (parsetree=0x27012c0, queryString=0x2700890 "VACUUM VERBOSE ANALYZE sales;", context=PROCESS_UTILITY_TOPLEVEL, params=0x0, dest=0x2701620, completionTag=0x7fff9089e1d0 "") at utility.c:311
  107. No locals.
  108. #8 0x000000000076d81d in PortalRunUtility (portal=0x2769880, utilityStmt=0x27012c0, isTopLevel=1 '\001', dest=0x2701620, completionTag=0x7fff9089e1d0 "") at pquery.c:1187
  109. active_snapshot_set = 1 '\001'
  110. __func__ = "PortalRunUtility"
  111. #9 0x000000000076d9c9 in PortalRunMulti (portal=0x2769880, isTopLevel=1 '\001', dest=0x2701620, altdest=0x2701620, completionTag=0x7fff9089e1d0 "") at pquery.c:1318
  112. stmt = 0x27012c0
  113. active_snapshot_set = 0 '\000'
  114. stmtlist_item = 0x27015d0
  115. #10 0x000000000076cf99 in PortalRun (portal=0x2769880, count=9223372036854775807, isTopLevel=1 '\001', dest=0x2701620, altdest=0x2701620, completionTag=0x7fff9089e1d0 "") at pquery.c:816
  116. save_exception_stack = 0x7fff9089e280
  117. save_context_stack = 0x0
  118. local_sigjmp_buf = {{__jmpbuf = {0, -239893133915522931, 4581360, 140735618344880, 0, 0, -239893133703710579, 239987694510471309}, __mask_was_saved = 0, __saved_mask = {__val = {40521008, 128, 40900112, 140735618343370,
  119. 17179869185, 0, 4581360, 140735618343152, 9182323, 140735618343200, 88, 2, 40900216, 140735618343232, 140735618343232, 140050638375828}}}}
  120. result = 0 '\000'
  121. nprocessed = 40850560
  122. saveTopTransactionResourceOwner = 0x26f5590
  123. saveTopTransactionContext = 0x26f5480
  124. saveActivePortal = 0x0
  125. saveResourceOwner = 0x26f5590
  126. savePortalContext = 0x0
  127. saveMemoryContext = 0x26f5480
  128. __func__ = "PortalRun"
  129. #11 0x000000000076705c in exec_simple_query (query_string=0x2700890 "VACUUM VERBOSE ANALYZE sales;") at postgres.c:1045
  130. parsetree = 0x27012c0
  131. portal = 0x2769880
  132. snapshot_set = 0 '\000'
  133. commandTag = 0x9ee731 "VACUUM"
  134. completionTag = "\000\000\000\000\000\000\000\000\035\000\000\000\000\000\000\000P≐\377\177\000\000\224\v\215\024`\177\000\000P㉐\377\177\000\000\000\000\000\000\000\000\000\000\006\000\000\000\000\000\000\000\220\bp\002\000\000\000"
  135. querytree_list = 0x27015a0
  136. plantree_list = 0x27015f0
  137. receiver = 0x2701620
  138. format = 0
  139. dest = DestRemote
  140. snapshot_set = 0 '\000'
  141. commandTag = 0x9ee731 "VACUUM"
  142. completionTag = "\000\000\000\000\000\000\000\000\035\000\000\000\000\000\000\000P≐\377\177\000\000\224\v\215\024`\177\000\000P㉐\377\177\000\000\000\000\000\000\000\000\000\000\006\000\000\000\000\000\000\000\220\bp\002\000\000\000"
  143. querytree_list = 0x27015a0
  144. plantree_list = 0x27015f0
  145. receiver = 0x2701620
  146. format = 0
  147. dest = DestRemote
  148. ---Type <return> to continue, or q <return> to quit---bt full
  149. oldcontext = 0x26f5480
  150. parsetree_list = 0x2701330
  151. parsetree_item = 0x2701310
  152. save_log_statement_stats = 0 '\000'
  153. was_logged = 0 '\000'
  154. isTopLevel = 1 '\001'
  155. msec_str = "P㉐\377\177", '\000' <repeats 18 times>"\211, \317e\000\000\000\000"
  156. __func__ = "exec_simple_query"
  157. #12 0x000000000076b287 in PostgresMain (argc=1, argv=0x26a5978, dbname=0x26a5830 "minmax", username=0x26a5810 "sekondquad") at postgres.c:4010
  158. query_string = 0x2700890 "VACUUM VERBOSE ANALYZE sales;"
  159. firstchar = 81
  160. input_message = {data = 0x2700890 "VACUUM VERBOSE ANALYZE sales;", len = 30, maxlen = 1024, cursor = 30}
  161. local_sigjmp_buf = {{__jmpbuf = {0, -239893134024574835, 4581360, 140735618344880, 0, 0, -239893133819053939, 239987695456286861}, __mask_was_saved = 1, __saved_mask = {__val = {0, 1024, 40521008, 0, 40673552, 16384, 16, 64,
  162. 40521008, 1024, 140735618343792, 140050638375828, 140735618343888, 524288, 140735618343824, 140050638375828}}}}
  163. send_ready_for_query = 0 '\000'
  164. __func__ = "PostgresMain"
  165. #13 0x00000000006fac3a in BackendRun (port=0x26c4660) at postmaster.c:4112
  166. av = 0x26a5978
  167. maxac = 2
  168. ac = 1
  169. secs = 464060778
  170. usecs = 731330
  171. i = 1
  172. __func__ = "BackendRun"
  173. #14 0x00000000006fa2d0 in BackendStartup (port=0x26c4660) at postmaster.c:3787
  174. bn = 0x26c5970
  175. pid = 0
  176. __func__ = "BackendStartup"
  177. #15 0x00000000006f6ae7 in ServerLoop () at postmaster.c:1566
  178. port = 0x26c4660
  179. i = 2
  180. rmask = {fds_bits = {32, 0 <repeats 15 times>}}
  181. selres = 1
  182. readmask = {fds_bits = {56, 0 <repeats 15 times>}}
  183. nSockets = 6
  184. now = 1410745576
  185. last_touch_time = 1410745444
  186. __func__ = "ServerLoop"
  187. #16 0x00000000006f61b7 in PostmasterMain (argc=3, argv=0x26a4a50) at postmaster.c:1219
  188. opt = -1
  189. status = 0
  190. userDoption = 0x26c1460 "/data/sekondquad/AXLE/sekondquad/minmax18"
  191. listen_addr_saved = 1 '\001'
  192. i = 64
  193. output_config_variable = 0x0
  194. __func__ = "PostmasterMain"
  195. #17 0x000000000065d49b in main (argc=3, argv=0x26a4a50) at main.c:219
  196. do_check_root = 1 '\001'
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!