Re: BUG #16283: crash on create index segmentation fault

From: Arthur Cheysson <site(at)lafranceinsoumise(dot)fr>
To: pgsql-bugs(at)postgresql(dot)org
Cc: Przemysław Szustak <przemyslaw(dot)szustak(at)gmail(dot)com>, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
Subject: Re: BUG #16283: crash on create index segmentation fault
Date: 2020-05-18 15:08:13
Message-ID: ad7e7a31-cfc2-bcbc-a243-d7fb5089462f@lafranceinsoumise.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi everyone,

I am facing what seems to be the exact same problem, but with more
recent versions of both PostgreSQL and PostGIS

SELECT version();
PostgreSQL 12.2 (Ubuntu 12.2-4) on x86_64-pc-linux-gnu, compiled by gcc
(Ubuntu 9.3.0-8ubuntu1) 9.3.0, 64-bit

SELECT postgis_full_version();
POSTGIS="3.0.0 r17983" [EXTENSION] PGSQL="120" GEOS="3.8.0-CAPI-1.13.1 "
PROJ="6.3.1" LIBXML="2.9.4" LIBJSON="0.13.1" LIBPROTOBUF="1.3.3"
WAGYU="0.4.3 (Internal)"

I have been able to obtain a stacktrace with the PostGIS symbols, using
`bt full' in GDB on the core dump.

#0  pfree (pointer=0x7fdd15acc1a8) at
./build/../src/backend/utils/mmgr/mcxt.c:1035
        context = 0x4028000d051c0000
#1  0x00007fdd14c3a3c8 in gserialized_gist_picksplit_addlist
(list=0x5639c5e19858, box_union=box_union(at)entry=0x5639c5e18f28,
box_current=box_current(at)entry=0x7fdd15acc8e8, pos=pos(at)entry=0x5639c5e18ee8,
    num=num(at)entry=26) at gserialized_gist_nd.c:1378
No locals.
#2  0x00007fdd14c3ba23 in gserialized_gist_picksplit (fcinfo=<optimized
out>) at gserialized_gist_nd.c:1722
        center = <optimized out>
        avgCenter = 0x5639c5e19c78
        entryvec = 0x5639c5e16cb8
        v = 0x7fff44b6f690
        i = <optimized out>
        box_union = 0x5639c5e18f08
        list = 0x5639c5e12be0
        pos = 0x5639c5e18ed8
        box_pageunion = 0x5639c5e10e00
        box_current = 0x7fdd15acc8e8
        direction = -1
        all_entries_equal = <optimized out>
        max_offset = 168
        nbytes = 340
        ndims_pageunion = 3
        d = <optimized out>
        posmin = 169
        __func__ = "gserialized_gist_picksplit"
#3  0x00005639c41fba99 in FunctionCall2Coll
(flinfo=flinfo(at)entry=0x5639c5de3490, collation=<optimized out>,
arg1=arg1(at)entry=94806133009592, arg2=arg2(at)entry=140734346229392)
    at ./build/../src/backend/utils/fmgr/fmgr.c:1162
        fcinfodata = {fcinfo = {flinfo = 0x5639c5de3490, context = 0x0,
resultinfo = 0x0, fncollation = 100, isnull = false, nargs = 2, args =
0x7fff44b6f4a0},
          fcinfo_data = "\220\064\336\305\071V", '\000' <repeats 18
times>,
"d\000\000\000\000V\002\000\270l\341\305\071V\000\000\000>\341\303\071V\000\000\220\366\266D\377\177\000\000\000\000\000\000\000\000\000"}
        fcinfo = 0x7fff44b6f480
        result = <optimized out>
        __func__ = "FunctionCall2Coll"
        __errno_location = <optimized out>
#4  0x00005639c3e1c4ab in gistUserPicksplit (len=168,
giststate=0x5639c5de1668, itup=0x5639c5e10f20, v=0x7fff44b6f690,
attno=0, entryvec=0x5639c5e16cb8, r=0x7fdd14d30ee8)
    at ./build/../src/backend/access/gist/gistsplit.c:433
        sv = 0x7fff44b6f690
        sv = <optimized out>
        __func__ = "gistUserPicksplit"
        __errno_location = <optimized out>
        NumDontCare = <optimized out>
        toMove = <optimized out>
#5  gistSplitByKey (r=r(at)entry=0x7fdd14d30ee8,
page=page(at)entry=0x7fdd15acad00 "", itup=itup(at)entry=0x5639c5e10f20,
len=168, giststate=giststate(at)entry=0x5639c5de1668,
v=v(at)entry=0x7fff44b6f690, attno=0)
    at ./build/../src/backend/access/gist/gistsplit.c:697
        entryvec = 0x5639c5e16cb8
        offNullTuples = <optimized out>
        nOffNullTuples = <optimized out>
        i = <optimized out>
#6  0x00005639c3e1202b in gistSplit (r=0x7fdd14d30ee8,
page=0x7fdd15acad00 "", itup=0x5639c5e10f20, len=<optimized out>,
giststate=0x5639c5de1668) at ./build/../src/backend/access/gist/gist.c:1451
        lvectup = <optimized out>
        rvectup = <optimized out>
        v = {splitVector = {spl_left = 0x1, spl_nleft = 16384,
spl_ldatum = 94806132985400, spl_ldatum_exists = false, spl_right =
0x3fc5555555555515, spl_nright = -42257124, spl_rdatum = 0,
            spl_rdatum_exists = false}, spl_lattr = {94806132985400,
140587513876200, 0, 3155123322044284928, 140734346229776,
140734346229632, 94806132985264, 140734346229560, 140734346229552,
140587513396116,
            4585845765077098099, 4607175408094817544,
4604108167824115460, 4604952369619992743, 140734346229616,
94806132985296, 140734346229696, 140734346230064, 140734346230432,
140587513413085, 0,
            140587513122282, 4604103549945663722, 4583146448194962646,
4604952369619992743, 140587513165489, 8, 94806132985256, 4,
94806132985296, 8, 0}, spl_lisnull = {true, false <repeats 31 times>},
          spl_rattr = {0, 0, 0, 3155123322047568640, 140734346229856,
94806132985296, 140734346230064, 140587523272732, 140734346230432,
94806099337124, 94806132985296, 140587513413356, 140587513888440,
140734346230030, 140734346231152, 140734346230064, 94802813124608, 0,
140587513888652, 140734346230032, 94806132985392, 140587513888652,
140587513888440, 140734346230064, 140734346230384, 94806099343697, 0,
94806132984880, 1344, 844, 140734346230632, 140587528137984},
spl_risnull = {true, 249, 182, 68, 255, 127, false, false, 97, 225, 33,
196, 57, 86, false, false, 48, 249, 182, 68, 255, 127, false, false,
204, 249, 182, 68, 255, 127, false, false}, spl_dontcare = 0x1}
        i = <optimized out>
        res = 0x0
        __func__ = "gistSplit"
#7  0x00005639c3e123f3 in gistplacetopage (rel=0x7fdd14d30ee8,
freespace=<optimized out>, giststate=giststate(at)entry=0x5639c5de1668,
buffer=844, itup=itup(at)entry=0x7fff44b6fb68, ntup=ntup(at)entry=1,
oldoffnum=0, newblkno=0x0, leftchildbuf=0, splitinfo=0x7fff44b6fab0,
markfollowright=true, heapRel=0x7fdd14d2e118, is_build=true) at
./build/../src/backend/access/gist/gist.c:299
        itvec = <optimized out>
        dist = 0x0
        oldnsn = 0
        npage = <optimized out>
        tlen = 168
        ptr = <optimized out>
        oldrlink = 4294967295
        rootpg = {block = {blkno = 350328448, num = 32733}, list =
0x6066817f, lenlist = 1152842416, itup = 0x5639c40afe0a
<ReadBuffer_common+1258>, page = 0x7fff44b6fae7 "", buffer = 0, next = 0x70}
        is_rootsplit = false
        blkno = 601
        page = 0x7fdd15acad00 ""
        is_leaf = true
        recptr = <optimized out>
        i = <optimized out>
        is_split = <optimized out>
        __func__ = "gistplacetopage"
#8  0x00005639c3e12f1e in gistinserttuples
(state=state(at)entry=0x7fff44b6fba0, stack=stack(at)entry=0x5639c5e10ed0,
giststate=giststate(at)entry=0x5639c5de1668,
tuples=tuples(at)entry=0x7fff44b6fb68, ntup=ntup(at)entry=1,
oldoffnum=oldoffnum(at)entry=0, leftchild=0, rightchild=0, unlockbuf=false,
unlockleftchild=false) at ./build/../src/backend/access/gist/gist.c:1269
        splitinfo = 0x0
        is_split = <optimized out>
#9  0x00005639c3e1331e in gistinserttuple (oldoffnum=0, tuple=<optimized
out>, giststate=0x5639c5de1668, stack=0x5639c5e10ed0,
state=0x7fff44b6fba0) at ./build/../src/backend/access/gist/gist.c:1222
No locals.
#10 gistdoinsert (r=r(at)entry=0x7fdd14d30ee8,
itup=itup(at)entry=0x5639c5e10e30, freespace=<optimized out>,
giststate=0x5639c5de1668, heapRel=<optimized out>,
is_build=is_build(at)entry=true) at
./build/../src/backend/access/gist/gist.c:876
        iid = <optimized out>
        idxtuple = <optimized out>
        firststack = {blkno = 0, buffer = 211, page = 0x7fdd155d8d00
"", lsn = 1, retry_from_parent = false, downlinkoffnum = 0, parent = 0x0}
        stack = 0x5639c5e10ed0
        state = {r = 0x7fdd14d30ee8, heapRel = 0x7fdd14d2e118,
freespace = 819, is_build = true, stack = 0x5639c5e10ed0}
        xlocked = <optimized out>
        __func__ = "gistdoinsert"
#11 0x00005639c3e1dc91 in gistBuildCallback
(index=index(at)entry=0x7fdd14d30ee8, htup=htup(at)entry=0x5639c5dd0a88,
values=values(at)entry=0x7fff44b6fd90, isnull=isnull(at)entry=0x7fff44b6fd70,
tupleIsAlive=tupleIsAlive(at)entry=true, state=state(at)entry=0x7fff44b70170)
at ./build/../src/backend/access/gist/gistbuild.c:489
        buildstate = 0x7fff44b70170
        itup = 0x5639c5e10e30
        oldCtx = 0x5639c5d3f820
#12 0x00005639c3e35e6c in heapam_index_build_range_scan
(heapRelation=0x7fdd14d2e118, indexRelation=0x7fdd14d30ee8,
indexInfo=0x5639c5d3feb8, allow_sync=<optimized out>, anyvisible=false,
progress=true, start_blockno=0, numblocks=4294967295,
callback=0x5639c3e1dc00 <gistBuildCallback>,
callback_state=0x7fff44b70170, scan=0x5639c5dd0a38) at
./build/../src/backend/access/heap/heapam_handler.c:1664
        tupleIsAlive = true
        hscan = 0x5639c5dd0a38
        is_system_catalog = false
        checking_uniqueness = false
        heapTuple = 0x5639c5dd0a88
        values = {140587523272732, 0, 94806132784048, 94806132804896,
140587513896984, 140587720357032, 94806132765608, 140587712194344,
140734346231536, 0, 140587720357008, 140734346231648, 94806105258868,
94806105258868, 140734346231536, 140734346231292, 94806132765608,
3086255563502438562, 18446744073709551472, 94806132784048,
94806132804896, 3155123322047568640, 8744187018653911202, 128,
94806105414899, 94806105414899, 140734346231552, 94806102306725,
140734346231488, 0, 1, 16384}
        isnull = {false, 253, 182, 68, 255, 127, false, false, false,
27, 50, 225, 241, 63, 201, 43, true, 64, false, false, 231, 4, false,
false, 96, 255, 182, 68, 255, 127, false, false}
        reltuples = 66513
        predicate = 0x0
        slot = 0x5639c5d41488
        estate = 0x5639c5e12d70
        econtext = 0x5639c5e12f80
        snapshot = 0x5639c449e3e0 <SnapshotAnyData>
        need_unregister_snapshot = false
        OldestXmin = <optimized out>
        previous_blkno = 2590
        root_blkno = 2590
        root_offsets = {1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14,
15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 0 <repeats 263
times>}
        __func__ = "heapam_index_build_range_scan"
#13 0x00005639c3e1e2c5 in table_index_build_scan (scan=0x0,
callback_state=0x7fff44b70170, callback=0x5639c3e1dc00
<gistBuildCallback>, progress=true, allow_sync=true,
index_info=0x5639c5d3feb8, index_rel=0x7fdd14d30ee8,
table_rel=0x7fdd14d2e118) at ./build/../src/include/access/tableam.h:1522
No locals.
#14 gistbuild (heap=0x7fdd14d2e118, index=0x7fdd14d30ee8,
indexInfo=0x5639c5d3feb8) at
./build/../src/backend/access/gist/gistbuild.c:196
        result = <optimized out>
        reltuples = <optimized out>
        buildstate = {indexrel = 0x7fdd14d30ee8, heaprel =
0x7fdd14d2e118, giststate = 0x5639c5de1668, indtuples = 66512,
indtuplesSize = 2366816, freespace = 819, gfbb = 0x0, parentMap = 0x0,
bufferingMode = GIST_BUFFERING_AUTO}
        buffer = 211
        page = <optimized out>
        oldcxt = 0x5639c5d3f820
        fillfactor = <optimized out>
        __func__ = "gistbuild"
#15 0x00005639c3e9be20 in index_build
(heapRelation=heapRelation(at)entry=0x7fdd14d2e118,
indexRelation=indexRelation(at)entry=0x7fdd14d30ee8,
indexInfo=indexInfo(at)entry=0x5639c5d3feb8,
isreindex=isreindex(at)entry=false, parallel=parallel(at)entry=true) at
./build/../src/backend/catalog/index.c:2902
        stats = <optimized out>
        save_userid = 10
        save_sec_context = 0
        save_nestlevel = 2
        __func__ = "index_build"
#16 0x00005639c3e9d2a1 in index_create
(heapRelation=heapRelation(at)entry=0x7fdd14d2e118,
indexRelationName=indexRelationName(at)entry=0x5639c5d41698
"people_person_coordinates_id", indexRelationId=<optimized out>,
indexRelationId(at)entry=0, parentIndexRelid=parentIndexRelid(at)entry=0,
parentConstraintId=parentConstraintId(at)entry=0, relFileNode=<optimized
out>, indexInfo=<optimized out>, indexColNames=<optimized out>,
accessMethodObjectId=<optimized out>, tableSpaceId=<optimized out>,
collationObjectId=<optimized out>, classObjectId=<optimized out>,
coloptions=<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
./build/../src/backend/catalog/index.c:1221
        heapRelationId = <optimized out>
        pg_class = <optimized out>
        indexRelation = 0x7fdd14d30ee8
        indexTupDesc = 0x5639c5d417e8
        shared_relation = <optimized out>
        mapped_relation = <optimized out>
        is_exclusion = <optimized out>
        namespaceId = <optimized out>
        i = <optimized out>
        relpersistence = <optimized out>
        isprimary = <optimized out>
        invalid = <optimized out>
        concurrent = <optimized out>
        partitioned = <optimized out>
        relkind = <optimized out>
        relfrozenxid = 0
        relminmxid = 0
        __func__ = "index_create"
#17 0x00005639c3f36f2e in DefineIndex
(relationId=relationId(at)entry=20147, stmt=stmt(at)entry=0x5639c5d3fba0,
indexRelationId=indexRelationId(at)entry=0,
parentIndexId=parentIndexId(at)entry=0,
parentConstraintId=parentConstraintId(at)entry=0,
is_alter_table=is_alter_table(at)entry=false, check_rights=true,
check_not_in_use=true, skip_build=false, quiet=false) at
./build/../src/backend/commands/indexcmds.c:1005
        concurrent = <optimized out>
        indexRelationName = 0x5639c5d41698 "people_person_coordinates_id"
        accessMethodName = <optimized out>
        typeObjectId = <optimized out>
        collationObjectId = <optimized out>
        classObjectId = <optimized out>
        accessMethodId = 783
        namespaceId = <optimized out>
        tablespaceId = 0
        createdConstraintId = 0
        indexColNames = 0x5639c5dd6928
        allIndexParams = <optimized out>
        rel = 0x7fdd14d2e118
        tuple = <optimized out>
        accessMethodForm = <optimized out>
        amRoutine = <optimized out>
        amcanorder = <optimized out>
        amoptions = <optimized out>
        partitioned = <optimized out>
        reloptions = 0
        coloptions = <optimized out>
        indexInfo = <optimized out>
        flags = <optimized out>
        constr_flags = <optimized out>
        numberOfAttributes = <optimized out>
        numberOfKeyAttributes = 1
        limitXmin = <optimized out>
        address = <optimized out>
        heaprelid = {relId = 3319621704, dbId = 22073}
        heaplocktag = <optimized out>
        lockmode = 5
        snapshot = <optimized out>
        save_nestlevel = -1
        i = <optimized out>
        __func__ = "DefineIndex"
#18 0x00005639c40e415f in ProcessUtilitySlow
(pstate=pstate(at)entry=0x5639c5d3f930, pstmt=pstmt(at)entry=0x5639c5cf8f78,
queryString=queryString(at)entry=0x5639c5cf7fd0 "CREATE INDEX
people_person_coordinates_id ON public.people_person USING gist
(coordinates);", context=context(at)entry=PROCESS_UTILITY_TOPLEVEL,
params=params(at)entry=0x0, queryEnv=queryEnv(at)entry=0x0,
completionTag=0x7fff44b70d60 "", dest=0x5639c5cf9058) at
./build/../src/backend/tcop/utility.c:1372
        stmt = 0x5639c5d3fba0
        relid = 20147
        lockmode = <optimized out>
        save_exception_stack = 0x7fff44b70c20
        save_context_stack = 0x0
        local_sigjmp_buf = {{__jmpbuf = {140734346235232,
8744187003067877538, 0, 94806131837944, 94806132128048, 94806131834832,
8744187003416004770, 3086257337499830434}, __mask_was_saved = 0,
__saved_mask = {__val = {0, 0, 2, 2, 94802813127573, 4, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0}}}}
        parsetree = 0x5639c5cf8bf8
        isTopLevel = true
        isCompleteQuery = true
        needCleanup = false
        commandCollected = false
        address = {classId = 3, objectId = 0, objectSubId = 3}
        secondaryObject = {classId = 0, objectId = 0, objectSubId = 0}
        __func__ = "ProcessUtilitySlow"
#19 0x00005639c40e2c7f in standard_ProcessUtility (pstmt=0x5639c5cf8f78,
queryString=0x5639c5cf7fd0 "CREATE INDEX people_person_coordinates_id ON
public.people_person USING gist (coordinates);",
context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0,
dest=0x5639c5cf9058, completionTag=0x7fff44b70d60 "") at
./build/../src/backend/tcop/utility.c:927
        parsetree = 0x5639c5cf8bf8
        isTopLevel = <optimized out>
        isAtomicContext = false
        pstate = 0x5639c5d3f930
        __func__ = "standard_ProcessUtility"
#20 0x00005639c40dfcb4 in PortalRunUtility (portal=0x5639c5d809d0,
pstmt=0x5639c5cf8f78, isTopLevel=<optimized out>,
setHoldSnapshot=<optimized out>, dest=0x5639c5cf9058,
completionTag=0x7fff44b70d60 "") at
./build/../src/backend/tcop/pquery.c:1175
        utilityStmt = <optimized out>
        snapshot = 0x5639c5d9d340
#21 0x00005639c40e0767 in PortalRunMulti
(portal=portal(at)entry=0x5639c5d809d0, isTopLevel=isTopLevel(at)entry=true,
setHoldSnapshot=setHoldSnapshot(at)entry=false,
dest=dest(at)entry=0x5639c5cf9058, altdest=altdest(at)entry=0x5639c5cf9058,
completionTag=completionTag(at)entry=0x7fff44b70d60 "") at
./build/../src/backend/tcop/pquery.c:1321
        pstmt = 0x5639c5cf8f78
        active_snapshot_set = false
        stmtlist_item = 0x5639c5cf9008
#22 0x00005639c40e13ae in PortalRun (portal=portal(at)entry=0x5639c5d809d0,
count=count(at)entry=9223372036854775807, isTopLevel=isTopLevel(at)entry=true,
run_once=run_once(at)entry=true, dest=dest(at)entry=0x5639c5cf9058,
altdest=altdest(at)entry=0x5639c5cf9058, completionTag=0x7fff44b70d60 "")
at ./build/../src/backend/tcop/pquery.c:796
        save_exception_stack = 0x7fff44b70f90
        save_context_stack = 0x0
        local_sigjmp_buf = {{__jmpbuf = {1, 8744187003107723426,
94806132394448, 94806131838088, 2, 94806132394448, 8744187003021740194,
3086257336272603298}, __mask_was_saved = 0, __saved_mask = {__val = {0,
140736010536557, 94806105313453, 94806132406008, 94802813124609,
94806132402800, 64, 94806131834560, 112, 94806131838088, 2,
140734346235120, 94806103678836, 140734346235152, 2, 94806104811427}}}}
        result = <optimized out>
        nprocessed = <optimized out>
        saveTopTransactionResourceOwner = 0x5639c5d46578
        saveTopTransactionContext = 0x5639c5d9d200
        saveActivePortal = 0x0
        saveResourceOwner = 0x5639c5d46578
        savePortalContext = 0x0
        saveMemoryContext = 0x5639c5d9d200
        __func__ = "PortalRun"
#23 0x00005639c40dd257 in exec_simple_query (query_string=0x5639c5cf7fd0
"CREATE INDEX people_person_coordinates_id ON public.people_person USING
gist (coordinates);") at ./build/../src/backend/tcop/postgres.c:1215
        parsetree = 0x5639c5cf8c88
        portal = 0x5639c5d809d0
        snapshot_set = <optimized out>
        commandTag = <optimized out>
        completionTag =
"\000\r\267D\377\177\000\000\000\000\000\000\000\000\000\000\240\r\267D\377\177\000\000\f\030\273D\377\177\000\000\344\220\302^\000\000\000\000\001\000\000\000\000\000\000\000\320\177\317\305\071V\000\000\060\017\267D\377\177\000"
        querytree_list = <optimized out>
        plantree_list = <optimized out>
        receiver = <optimized out>
        format = 0
        dest = DestRemote
        oldcontext = <optimized out>
        parsetree_list = 0x5639c5cf8cd8
        parsetree_item = 0x5639c5cf8cb8
        save_log_statement_stats = false
        was_logged = false
        use_implicit_block = false
        msec_str =
"\000\r\267D\377\177\000\000\000\000\000\000\000\000\000\000\240\r\267D\377\177\000\000\f\030\273D\377\177\000"
        __func__ = "exec_simple_query"
#24 0x00005639c40deb6a in PostgresMain (argc=<optimized out>,
argv=argv(at)entry=0x5639c5d44b08, dbname=<optimized out>,
username=<optimized out>) at ./build/../src/backend/tcop/postgres.c:4247
        query_string = 0x5639c5cf7fd0 "CREATE INDEX
people_person_coordinates_id ON public.people_person USING gist
(coordinates);"
        firstchar = <optimized out>
        input_message = {data = 0x5639c5cf7fd0 "CREATE INDEX
people_person_coordinates_id ON public.people_person USING gist
(coordinates);", len = 92, maxlen = 1024, cursor = 92}
        local_sigjmp_buf = {{__jmpbuf = {1, 8744187002696681634,
140734346235728, 1, 94806132148664, 0, 8744187003080460450,
3086257350977570978}, __mask_was_saved = 1, __saved_mask = {__val = {0,
140734346235952, 94806103782045, 140734346239683, 140734346239642,
140734346239954, 0, 139637976727552, 3155123322047568640,
94806131810240, 3155123322047568640, 140734346236176, 94806103782259,
206158430256, 140734346236200, 140734346236000}}}}
        send_ready_for_query = false
        disable_idle_in_transaction_timeout = false
        __func__ = "PostgresMain"
#25 0x00005639c4069b6b in BackendRun (port=0x5639c5d40cd0,
port=0x5639c5d40cd0) at ./build/../src/backend/postmaster/postmaster.c:4437
        av = 0x5639c5d44b08
        maxac = <optimized out>
        ac = 1
        i = 1
        av = <optimized out>
        maxac = <optimized out>
        ac = <optimized out>
        i = <optimized out>
        __func__ = "BackendRun"
        __errno_location = <optimized out>
        __errno_location = <optimized out>
        __errno_location = <optimized out>
#26 BackendStartup (port=0x5639c5d40cd0) at
./build/../src/backend/postmaster/postmaster.c:4128
        bn = <optimized out>
        pid = <optimized out>
        bn = <optimized out>
        pid = <optimized out>
        __func__ = "BackendStartup"
        __errno_location = <optimized out>
        __errno_location = <optimized out>
        save_errno = <optimized out>
        __errno_location = <optimized out>
        __errno_location = <optimized out>
#27 ServerLoop () at ./build/../src/backend/postmaster/postmaster.c:1704
        port = 0x5639c5d40cd0
        i = <optimized out>
        rmask = {fds_bits = {16, 0 <repeats 15 times>}}
        selres = <optimized out>
        now = <optimized out>
        readmask = {fds_bits = {24, 0 <repeats 15 times>}}
        nSockets = 5
        last_lockfile_recheck_time = 1589809339
        last_touch_time = 1589809279
        __func__ = "ServerLoop"
#28 0x00005639c406aa99 in PostmasterMain (argc=5, argv=<optimized out>)
at ./build/../src/backend/postmaster/postmaster.c:1377
        opt = <optimized out>
        status = <optimized out>
        userDoption = <optimized out>
        listen_addr_saved = <optimized out>
        i = <optimized out>
        output_config_variable = <optimized out>
        __func__ = "PostmasterMain"
#29 0x00005639c3df1b88 in main (argc=5, argv=0x5639c5cf1ee0) at
./build/../src/backend/main/main.c:228
        do_check_root = <optimized out>

I'm also trying to file a report with PostGIS (currently waiting for my
UserID), but in the meantime, I'd be grateful if you had any ideas or
hints on where to go from here.

--
Arthur Cheysson
Developper for la France insoumise

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Colin Darie 2020-05-18 15:10:48 Re : Re: BUG #16441: Cannot multi-insert into generated column with DEFAULT value
Previous Message Peter Eisentraut 2020-05-18 14:57:26 Re: BUG #16441: Cannot multi-insert into generated column with DEFAULT value