API tools faq
paste
popovnv

Untitled

popovnv
Aug 29th, 2018
115
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.86 KB | None | 0 0
raw download clone embed print report
  1. postgres@vm-postgrespro-lin:~$ gdb -p 12127 --ex bt --batch
  2. [Thread debugging using libthread_db enabled]
  3. Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".
  4. _bt_checkkeys (scan=scan@entry=0x55bc7864eb70, page=page@entry=0x7f6cf7252480 "\b", offnum=offnum@entry=87, dir=dir@entry=ForwardScanDirection, continuescan=continuescan@entry=0x7fff7afce8d7 "\001") at ./build/../src/backend/access/nbtree/nbtutils.c:1621
  5. 1621 ./build/../src/backend/access/nbtree/nbtutils.c: No such file or directory.
  6. #0 _bt_checkkeys (scan=scan@entry=0x55bc7864eb70, page=page@entry=0x7f6cf7252480 "\b", offnum=offnum@entry=87, dir=dir@entry=ForwardScanDirection, continuescan=continuescan@entry=0x7fff7afce8d7 "\001") at ./build/../src/backend/access/nbtree/nbtutils.c:1621
  7. #1 0x000055bc7750278f in _bt_readpage (scan=scan@entry=0x55bc7864eb70, state=state@entry=0x55bc787f63f8, dir=dir@entry=ForwardScanDirection, offnum=87) at ./build/../src/backend/access/nbtree/nbtsearch.c:1558
  8. #2 0x000055bc7750364e in _bt_readnextpage (scan=scan@entry=0x55bc7864eb70, state=state@entry=0x55bc787f63f8, blkno=<optimized out>, dir=dir@entry=ForwardScanDirection) at ./build/../src/backend/access/nbtree/nbtsearch.c:1854
  9. #3 0x000055bc77503809 in _bt_steppage (scan=scan@entry=0x55bc7864eb70, state=state@entry=0x55bc787f63f8, dir=ForwardScanDirection, dir@entry=2019879792) at ./build/../src/backend/access/nbtree/nbtsearch.c:1796
  10. #4 0x000055bc775041ce in _bt_next_item (dir=2019879792, state=0x55bc787f63f8, scan=0x55bc7864eb70) at ./build/../src/backend/access/nbtree/nbtsearch.c:1387
  11. #5 _bt_next (scan=scan@entry=0x55bc7864eb70, dir=dir@entry=ForwardScanDirection) at ./build/../src/backend/access/nbtree/nbtsearch.c:1458
  12. #6 0x000055bc7750097a in btgettuple (scan=0x55bc7864eb70, dir=ForwardScanDirection) at ./build/../src/backend/access/nbtree/nbtree.c:444
  13. #7 0x000055bc774f96a5 in index_getnext_tid (scan=0x55bc7864eb70, direction=<optimized out>) at ./build/../src/backend/access/index/indexam.c:542
  14. #8 0x000055bc774f98b4 in index_getnext (scan=scan@entry=0x55bc7864eb70, direction=direction@entry=ForwardScanDirection) at ./build/../src/backend/access/index/indexam.c:680
  15. #9 0x000055bc77664a3e in IndexNext (node=node@entry=0x55bc78640470) at ./build/../src/backend/executor/nodeIndexscan.c:134
  16. #10 0x000055bc77653e16 in ExecScanFetch (recheckMtd=0x55bc776648a0 <IndexRecheck>, accessMtd=0x55bc776649d0 <IndexNext>, node=0x55bc78640470) at ./build/../src/backend/executor/execScan.c:97
  17. #11 ExecScan (node=0x55bc78640470, accessMtd=0x55bc776649d0 <IndexNext>, recheckMtd=0x55bc776648a0 <IndexRecheck>) at ./build/../src/backend/executor/execScan.c:164
  18. #12 0x000055bc7766e3c6 in ExecProcNode (node=0x55bc78640470) at ./build/../src/include/executor/executor.h:256
  19. #13 ExecNestLoop (pstate=0x55bc7863d8c8) at ./build/../src/backend/executor/nodeNestloop.c:160
  20. #14 0x000055bc7766e315 in ExecProcNode (node=0x55bc7863d8c8) at ./build/../src/include/executor/executor.h:256
  21. #15 ExecNestLoop (pstate=0x55bc7863cdd8) at ./build/../src/backend/executor/nodeNestloop.c:109
  22. #16 0x000055bc7764dc8b in ExecProcNode (node=0x55bc7863cdd8) at ./build/../src/include/executor/executor.h:256
  23. #17 ExecutePlan (execute_once=<optimized out>, dest=0x55bc7862eae8, direction=<optimized out>, numberTuples=10000, sendTuples=<optimized out>, operation=CMD_SELECT, use_parallel_mode=<optimized out>, planstate=0x55bc7863cdd8, estate=0x55bc7863cb48) at ./build/../src/backend/executor/execMain.c:1725
  24. #18 standard_ExecutorRun (queryDesc=0x55bc7863aef8, direction=<optimized out>, count=10000, execute_once=<optimized out>) at ./build/../src/backend/executor/execMain.c:363
  25. #19 0x00007f6df353feb5 in pgss_ExecutorRun (queryDesc=0x55bc7863aef8, direction=ForwardScanDirection, count=10000, execute_once=<optimized out>) at ./build/../contrib/pg_stat_statements/pg_stat_statements.c:889
  26. #20 0x000055bc777999ab in PortalRunSelect (portal=0x55bc78325c58, forward=<optimized out>, count=10000, dest=<optimized out>) at ./build/../src/backend/tcop/pquery.c:932
  27. #21 0x000055bc7779b310 in PortalRunFetch (portal=0x55bc78325c58, fdirection=FETCH_FORWARD, count=10000, dest=dest@entry=0x55bc7862eae8) at ./build/../src/backend/tcop/pquery.c:1451
  28. #22 0x000055bc77604772 in PerformPortalFetch (stmt=stmt@entry=0x55bc78782308, dest=dest@entry=0x55bc7862eae8, completionTag=completionTag@entry=0x7fff7afcf3b0 "") at ./build/../src/backend/commands/portalcmds.c:199
  29. #23 0x000055bc7779cc4f in standard_ProcessUtility (pstmt=pstmt@entry=0x55bc78782278, queryString=queryString@entry=0x55bc7862ea48 "FETCH FORWARD 10000 FROM C43", context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=0x55bc7862eae8, completionTag=0x7fff7afcf3b0 "") at ./build/../src/backend/tcop/utility.c:529
  30. #24 0x00007f6df394cade in onlineAnalyzeHookerUtility (pstmt=0x55bc78782278, queryString=0x55bc7862ea48 "FETCH FORWARD 10000 FROM C43", context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=<optimized out>, completionTag=0x7fff7afcf3b0 "") at ./build/../contrib/online_analyze/online_analyze.c:906
  31. #25 0x00007f6df3541d13 in pgss_ProcessUtility (pstmt=0x55bc78782278, queryString=0x55bc7862ea48 "FETCH FORWARD 10000 FROM C43", context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55bc7862eae8, completionTag=0x7fff7afcf3b0 "") at ./build/../contrib/pg_stat_statements/pg_stat_statements.c:998
  32. #26 0x000055bc77799681 in PortalRunUtility (portal=0x55bc78325b48, pstmt=0x55bc78782278, isTopLevel=<optimized out>, setHoldSnapshot=<optimized out>, dest=<optimized out>, completionTag=<optimized out>) at ./build/../src/backend/tcop/pquery.c:1178
  33. #27 0x000055bc7779a427 in FillPortalStore (portal=portal@entry=0x55bc78325b48, isTopLevel=isTopLevel@entry=1 '\001') at ./build/../src/backend/tcop/pquery.c:1038
  34. #28 0x000055bc7779b0b7 in PortalRun (portal=portal@entry=0x55bc78325b48, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=1 '\001', run_once=<optimized out>, dest=dest@entry=0x55bc782b8b88, altdest=altdest@entry=0x55bc782b8b88, completionTag=0x7fff7afcf850 "") at ./build/../src/backend/tcop/pquery.c:768
  35. #29 0x000055bc777982ee in exec_execute_message (max_rows=9223372036854775807, portal_name=0x55bc782b8778 "") at ./build/../src/backend/tcop/postgres.c:1994
  36. #30 PostgresMain (argc=<optimized out>, argv=argv@entry=0x55bc7823a5e0, dbname=<optimized out>, username=<optimized out>) at ./build/../src/backend/tcop/postgres.c:4451
  37. #31 0x000055bc774a8fe0 in BackendRun (port=0x55bc78226d50) at ./build/../src/backend/postmaster/postmaster.c:4517
  38. #32 BackendStartup (port=0x55bc78226d50) at ./build/../src/backend/postmaster/postmaster.c:4179
  39. #33 ServerLoop () at ./build/../src/backend/postmaster/postmaster.c:1849
  40. #34 0x000055bc77719d34 in PostmasterMain (argc=3, argv=<optimized out>) at ./build/../src/backend/postmaster/postmaster.c:1451
  41. #35 0x000055bc774aa3d4 in main (argc=3, argv=0x55bc781fff00) at ./build/../src/backend/main/main.c:229
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
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!