Advertisement
markrofail

GIN Btree Error

Sep 13th, 2017
500
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C 4.70 KB | None | 0 0
  1. test=# SELECT * FROM test_text WHERE i>='abc' ORDER BY i;
  2.   i
  3. -----
  4.  abc
  5.  axy
  6.  xyz
  7. (3 rows)
  8.  
  9. test=# SELECT * FROM test_text WHERE i>'abc' ORDER BY i;
  10.  
  11. Program received signal SIGSEGV, Segmentation fault.
  12. __memmove_avx_unaligned_erms () at ../sysdeps/x86_64/multiarch/memmove-vec-unaligned-erms.S:420
  13. 420 ../sysdeps/x86_64/multiarch/memmove-vec-unaligned-erms.S: No such file or directory.
  14.  
  15. #0  __memmove_avx_unaligned_erms () at ../sysdeps/x86_64/multiarch/memmove-vec-unaligned-erms.S:420
  16. #1  0x000056134abf0369 in varstr_cmp (arg1=0x56134c82d0c4 "\023V", len1=320805950,
  17.     arg2=0x7fbb5ee5f021 "abc", len2=3, collid=100) at varlena.c:1534
  18. #2  0x000056134abf06a1 in text_cmp (arg1=0x56134c82d0c0, arg2=0x7fbb5ee5f020, collid=100)
  19.     at varlena.c:1630
  20. #3  0x000056134abf0ba7 in bttextcmp (fcinfo=0x7fffb25e5450) at varlena.c:1772
  21. #4  0x000056134ac2daa3 in FunctionCall2Coll (flinfo=0x56134c81e900, collation=100, arg1=94640888008896,
  22.     arg2=140442727739424) at fmgr.c:1059
  23. #5  0x000056134a670593 in ginCompareEntries (ginstate=0x56134c81e7e8, attnum=1, a=94640888008896,
  24.     categorya=0 '\000', b=140442727739424, categoryb=0 '\000') at ginutil.c:396
  25. #6  0x000056134a670608 in ginCompareAttEntries (ginstate=0x56134c81e7e8, attnuma=1, a=94640888008896,
  26.     categorya=0 '\000', attnumb=1, b=140442727739424, categoryb=0 '\000') at ginutil.c:413
  27. #7  0x000056134a67699b in entryLocateLeafEntry (btree=0x7fffb25e5950, stack=0x56134c821238)
  28.     at ginentrypage.c:385
  29. #8  0x000056134a68281e in startScanEntry (ginstate=0x56134c81e7e8, entry=0x56134c82d1b8,
  30.     snapshot=0x56134c81bc28) at ginget.c:341
  31. #9  0x000056134a6831d0 in startScan (scan=0x56134c8194b0) at ginget.c:543
  32. #10 0x000056134a686316 in gingetbitmap (scan=0x56134c8194b0, tbm=0x56134c8197f8) at ginget.c:1829
  33. #11 0x000056134a6e0477 in index_getbitmap (scan=0x56134c8194b0, bitmap=0x56134c8197f8) at indexam.c:726
  34. #12 0x000056134a8e9945 in MultiExecBitmapIndexScan (node=0x56134c8192a8) at nodeBitmapIndexscan.c:104
  35. #13 0x000056134a8d513c in MultiExecProcNode (node=0x56134c8192a8) at execProcnode.c:490
  36. #14 0x000056134a8e7d59 in BitmapHeapNext (node=0x56134c817ee8) at nodeBitmapHeapscan.c:117
  37. #15 0x000056134a8d6cd8 in ExecScanFetch (node=0x56134c817ee8,
  38.     accessMtd=0x56134a8e7c7e <BitmapHeapNext>, recheckMtd=0x56134a8e8e54 <BitmapHeapRecheck>)
  39.     at execScan.c:95
  40. #16 0x000056134a8d6d47 in ExecScan (node=0x56134c817ee8, accessMtd=0x56134a8e7c7e <BitmapHeapNext>,
  41.     recheckMtd=0x56134a8e8e54 <BitmapHeapRecheck>) at execScan.c:143
  42. #17 0x000056134a8e8ee3 in ExecBitmapHeapScan (pstate=0x56134c817ee8) at nodeBitmapHeapscan.c:673
  43. #18 0x000056134a8d504e in ExecProcNodeFirst (node=0x56134c817ee8) at execProcnode.c:430
  44. #19 0x000056134a902e63 in ExecProcNode (node=0x56134c817ee8)
  45.     at ../../../src/include/executor/executor.h:251
  46. #20 0x000056134a902fa1 in ExecSort (pstate=0x56134c817c18) at nodeSort.c:107
  47. #21 0x000056134a8d504e in ExecProcNodeFirst (node=0x56134c817c18) at execProcnode.c:430
  48. #22 0x000056134a8ccf69 in ExecProcNode (node=0x56134c817c18)
  49.     at ../../../src/include/executor/executor.h:251
  50. #23 0x000056134a8cf937 in ExecutePlan (estate=0x56134c817a00, planstate=0x56134c817c18,
  51.     use_parallel_mode=0 '\000', operation=CMD_SELECT, sendTuples=1 '\001', numberTuples=0,
  52.     direction=ForwardScanDirection, dest=0x56134c8143a8, execute_once=1 '\001') at execMain.c:1720
  53. #24 0x000056134a8cd56f in standard_ExecutorRun (queryDesc=0x56134c8175f0,
  54.     direction=ForwardScanDirection, count=0, execute_once=1 '\001') at execMain.c:363
  55. #25 0x000056134a8cd389 in ExecutorRun (queryDesc=0x56134c8175f0, direction=ForwardScanDirection,
  56.     count=0, execute_once=1 '\001') at execMain.c:306
  57. #26 0x000056134aaac7ae in PortalRunSelect (portal=0x56134c7f64e0, forward=1 '\001', count=0,
  58.     dest=0x56134c8143a8) at pquery.c:932
  59. #27 0x000056134aaac3cd in PortalRun (portal=0x56134c7f64e0, count=9223372036854775807,
  60.     isTopLevel=1 '\001', run_once=1 '\001', dest=0x56134c8143a8, altdest=0x56134c8143a8,
  61.     completionTag=0x7fffb25e6090 "") at pquery.c:773
  62. #28 0x000056134aaa5c38 in exec_simple_query (
  63.     query_string=0x56134c7c55c0 "SELECT * FROM test_text WHERE i>'abc' ORDER BY i;") at postgres.c:1109
  64. #29 0x000056134aaaa4b5 in PostgresMain (argc=1, argv=0x56134c76ee28, dbname=0x56134c76ecb8 "test",
  65.     username=0x56134c76ec98 "mark") at postgres.c:4103
  66. #30 0x000056134aa02807 in BackendRun (port=0x56134c768060) at postmaster.c:4357
  67. #31 0x000056134aa01eaa in BackendStartup (port=0x56134c768060) at postmaster.c:4029
  68. #32 0x000056134a9fe21c in ServerLoop () at postmaster.c:1753
  69. #33 0x000056134a9fd709 in PostmasterMain (argc=3, argv=0x56134c740300) at postmaster.c:1361
  70. #34 0x000056134a932512 in main (argc=3, argv=0x56134c740300) at main.c:228
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement