trace.txt

text/plain

Filename: trace.txt
Type: text/plain
Part: 0
Message: BRIN index creation on geometry column causes crash
Program received signal SIGSEGV, Segmentation fault.
FunctionCall2Coll (arg2=94823961171896, arg1=94823961033192, collation=0, flinfo=0x0, collation=0, arg1=94823961033192, arg2=94823961171896) at utils/fmgr/fmgr.c:1161
1161		result = FunctionCallInvoke(fcinfo);
(gdb) bt
#0  FunctionCall2Coll (arg2=94823961171896, arg1=94823961033192, collation=0, flinfo=0x0, collation=0, arg1=94823961033192, arg2=94823961171896) at utils/fmgr/fmgr.c:1161
#1  0x0000563ddb94fef5 in brin_inclusion_union (fcinfo=<optimized out>) at access/brin/brin_inclusion.c:522
#2  0x0000563ddbed992f in FunctionCall3Coll (flinfo=0x563dec875fa0, collation=<optimized out>, arg1=<optimized out>, arg2=<optimized out>, arg3=<optimized out>) at utils/fmgr/fmgr.c:1186
#3  0x0000563ddb95709d in union_tuples (bdesc=0x563dec87b048, a=0x563dec87aa70, b=<optimized out>) at access/brin/brin.c:2142
#4  0x0000563ddb959333 in _brin_parallel_merge (state=<optimized out>) at access/brin/brin.c:2683
#5  brinbuild (heap=<optimized out>, index=<optimized out>, indexInfo=<optimized out>) at access/brin/brin.c:1209
#6  0x0000563ddba450a8 in index_build (heapRelation=heapRelation@entry=0x7f8a362aa3a0, indexRelation=indexRelation@entry=0x7f8a362ab430, indexInfo=indexInfo@entry=0x563dec87a968, isreindex=isreindex@entry=false, 
    parallel=parallel@entry=true) at catalog/index.c:3016
#7  0x0000563ddba46d4a in index_create (heapRelation=<optimized out>, indexRelationName=<optimized out>, indexRelationId=<optimized out>, parentIndexRelid=<optimized out>, parentConstraintId=<optimized out>, 
    relFileNumber=<optimized out>, indexInfo=<optimized out>, indexColNames=<optimized out>, accessMethodId=<optimized out>, tableSpaceId=<optimized out>, collationIds=<optimized out>, opclassIds=<optimized out>, 
    opclassOptions=<optimized out>, coloptions=<optimized out>, stattargets=<optimized out>, reloptions=<optimized out>, flags=<optimized out>, constr_flags=<optimized out>, allow_system_table_mods=<optimized out>, 
    is_internal=<optimized out>, constraintId=<optimized out>) at catalog/index.c:1276
#8  0x0000563ddbaf45da in DefineIndex (tableId=1264656, stmt=0x563dec7252c0, indexRelationId=0, parentIndexId=0, parentConstraintId=0, total_parts=-1, is_alter_table=false, check_rights=true, check_not_in_use=true, skip_build=false, 
    quiet=false) at commands/indexcmds.c:1203
#9  0x0000563ddbf4de43 in ProcessUtilitySlow.isra.0 (pstate=pstate@entry=0x563dec87a818, pstmt=pstmt@entry=0x563dec7253b8, queryString=queryString@entry=0x563dec7247f8 "CREATE INDEX ON random_points USING brin(geom);", 
    context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, qc=0x7ffeec863040, dest=<optimized out>) at tcop/utility.c:1542
#10 0x0000563ddbd52b20 in standard_ProcessUtility (pstmt=0x563dec7253b8, queryString=0x563dec7247f8 "CREATE INDEX ON random_points USING brin(geom);", readOnlyTree=<optimized out>, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, 
    queryEnv=0x0, dest=0x563dec725758, qc=0x7ffeec863040) at tcop/utility.c:1067
#11 0x0000563ddbd537dc in ProcessUtility (pstmt=0x563dec7253b8, queryString=<optimized out>, readOnlyTree=<optimized out>, context=PROCESS_UTILITY_TOPLEVEL, params=<optimized out>, queryEnv=<optimized out>, dest=0x563dec725758, 
    qc=0x7ffeec863040) at tcop/utility.c:523
#12 PortalRunUtility (portal=portal@entry=0x563dec7b0fd8, pstmt=pstmt@entry=0x563dec7253b8, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=0x563dec725758, qc=0x7ffeec863040) at tcop/pquery.c:1158
#13 0x0000563ddbd538c7 in PortalRunMulti (portal=portal@entry=0x563dec7b0fd8, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x563dec725758, altdest=altdest@entry=0x563dec725758, 
    qc=qc@entry=0x7ffeec863040) at tcop/pquery.c:1322
#14 0x0000563ddbd53f16 in PortalRun (portal=0x563dec7b0fd8, count=9223372036854775807, isTopLevel=true, run_once=<optimized out>, dest=0x563dec725758, altdest=0x563dec725758, qc=0x7ffeec863040) at tcop/pquery.c:791
#15 0x0000563ddbd4d7ce in exec_simple_query (query_string=0x563dec7247f8 "CREATE INDEX ON random_points USING brin(geom);") at tcop/postgres.c:1278
#16 0x0000563ddbd56552 in PostgresMain (dbname=<optimized out>, username=<optimized out>) at tcop/postgres.c:4767
#17 0x0000563ddbd4b723 in BackendMain (startup_data=<optimized out>, startup_data_len=<optimized out>) at tcop/backend_startup.c:105
#18 0x0000563ddbcab05b in postmaster_child_launch (child_type=B_BACKEND, startup_data=0x7ffeec8635d0 "", startup_data_len=4, client_sock=0x7ffeec8635f0) at postmaster/launch_backend.c:277
#19 0x0000563ddbf53019 in postmaster_child_launch (child_type=B_BACKEND, startup_data=0x7ffeec8635d0 "", startup_data_len=4, client_sock=0x7ffeec8635f0) at postmaster/postmaster.c:2408
#20 BackendStartup (client_sock=0x7ffeec8635f0) at postmaster/postmaster.c:3593
#21 ServerLoop.isra.0 () at postmaster/postmaster.c:1674
#22 0x0000563ddbcb68d6 in PostmasterMain (argc=<optimized out>, argv=0x563dec6e07b0) at postmaster/postmaster.c:1372
#23 0x0000563ddb94bc5a in main (argc=3, argv=0x563dec6e07b0) at main/main.c:197