BUG #16024: segfault ip 0000560103865c60 error 4 in postgres
От | PG Bug reporting form |
---|---|
Тема | BUG #16024: segfault ip 0000560103865c60 error 4 in postgres |
Дата | |
Msg-id | 16024-840f55822dee2e9b@postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #16024: segfault ip 0000560103865c60 error 4 in postgres
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 16024 Logged by: Stephan Knauss Email address: sknauss@gmx.de PostgreSQL version: 9.6.15 Operating system: Ubuntu 18.04 Description: Using ubuntu packages 9.6.15 from postgresql.org. Recently a unchanged routine crashes a postgres backend process most of the time (or always?) with a segmentation fault. Call stack below. Please let me know what further details can help you. The core is 3.6G, I can provide it on request. Program terminated with signal SIGSEGV, Segmentation fault. #0 deconstruct_array (array=array@entry=0x564008a6bde8, elmtype=elmtype@entry=25, elmlen=elmlen@entry=-1, elmbyval=elmbyval@entry=0 '\000', elmalign=elmalign@entry=105 'i', elemsp=elemsp@entry=0x7ffc5a33d570, nullsp=0x7ffc5a33d578, nelemsp=0x7ffc5a33d56c) at ./build/../src/backend/utils/adt/arrayfuncs.c:3530 3530 ./build/../src/backend/utils/adt/arrayfuncs.c: No such file or directory. (gdb) bt #0 deconstruct_array (array=array@entry=0x564008a6bde8, elmtype=elmtype@entry=25, elmlen=elmlen@entry=-1, elmbyval=elmbyval@entry=0 '\000', elmalign=elmalign@entry=105 'i', elemsp=elemsp@entry=0x7ffc5a33d570, nullsp=0x7ffc5a33d578, nelemsp=0x7ffc5a33d56c) at ./build/../src/backend/utils/adt/arrayfuncs.c:3530 #1 0x0000564007ad7e48 in array_contain_compare (array1=array1@entry=0x564008a1c718, array2=array2@entry=0x564008a6bde8, collation=100, matchall=matchall@entry=0 '\000', fn_extra=<optimized out>) at ./build/../src/backend/utils/adt/arrayfuncs.c:4111 #2 0x0000564007ada7dd in arrayoverlap (fcinfo=0x564008a5d6e8) at ./build/../src/backend/utils/adt/arrayfuncs.c:4201 #3 0x000056400799d3bc in ExecMakeFunctionResultNoSets (fcache=0x564008a5d678, econtext=0x564008a5d1e8, isNull=0x7ffc5a33da37 "", isDone=<optimized out>) at ./build/../src/backend/executor/execQual.c:2041 #4 0x00005640079a30ef in ExecQual (qual=qual@entry=0x564008a5df78, econtext=econtext@entry=0x564008a5d1e8, resultForNull=resultForNull@entry=0 '\000') at ./build/../src/backend/executor/execQual.c:5316 #5 0x00005640079a3655 in ExecScan (node=node@entry=0x564008a5d0d8, accessMtd=accessMtd@entry=0x5640079b9b00 <SeqNext>, recheckMtd=recheckMtd@entry=0x5640079b9af0 <SeqRecheck>) at ./build/../src/backend/executor/execScan.c:208 #6 0x00005640079b9bb8 in ExecSeqScan (node=node@entry=0x564008a5d0d8) at ./build/../src/backend/executor/nodeSeqscan.c:127 #7 0x000056400799c340 in ExecProcNode (node=node@entry=0x564008a5d0d8) at ./build/../src/backend/executor/execProcnode.c:419 #8 0x00005640079b5f59 in ExecModifyTable (node=node@entry=0x564008a5cf98) at ./build/../src/backend/executor/nodeModifyTable.c:1392 #9 0x000056400799c380 in ExecProcNode (node=node@entry=0x564008a5cf98) at ./build/../src/backend/executor/execProcnode.c:396 #10 0x00005640079984f6 in ExecutePlan (dest=0x564008a39bc0, direction=<optimized out>, numberTuples=0, sendTuples=<optimized out>, operation=CMD_INSERT, use_parallel_mode=<optimized out>, planstate=0x564008a5cf98, estate=0x564008a5ccf8) at ./build/../src/backend/executor/execMain.c:1567 #11 standard_ExecutorRun (queryDesc=0x564008a29ec8, direction=<optimized out>, count=0) at ./build/../src/backend/executor/execMain.c:339 #12 0x0000564007ab6eb8 in ProcessQuery (plan=<optimized out>, sourceText=0x5640089ed678 "DROP TABLE if EXISTS loose;CREATE UNLOGGED TABLE loose (id bigint, node bigint, lat float, lon float, x integer, y integer);INSERT INTO loose SELECT id, nodes[1] AS node FROM planet_osm_ways WHERE ARR"..., params=0x0, dest=0x564008a39bc0, completionTag=0x7ffc5a33e220 "") at ./build/../src/backend/tcop/pquery.c:187 #13 0x0000564007ab70ed in PortalRunMulti (portal=portal@entry=0x5640089536e8, isTopLevel=isTopLevel@entry=0 '\000', setHoldSnapshot=setHoldSnapshot@entry=0 '\000', dest=dest@entry=0x564008a39bc0, altdest=altdest@entry=0x564008a39bc0, completionTag=completionTag@entry=0x7ffc5a33e220 "") at ./build/../src/backend/tcop/pquery.c:1303 #14 0x0000564007ab7cd1 in PortalRun (portal=portal@entry=0x5640089536e8, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=0 '\000', dest=dest@entry=0x564008a39bc0, altdest=altdest@entry=0x564008a39bc0, completionTag=completionTag@entry=0x7ffc5a33e220 "") at ./build/../src/backend/tcop/pquery.c:815 #15 0x0000564007ab5455 in exec_simple_query (query_string=0x5640089ed678 "DROP TABLE if EXISTS loose;CREATE UNLOGGED TABLE loose (id bigint, node bigint, lat float, lon float, x integer, y integer);INSERT INTO loose SELECT id, nodes[1] AS node FROM planet_osm_ways WHERE ARR"...) at ./build/../src/backend/tcop/postgres.c:1109 #16 PostgresMain (argc=<optimized out>, argv=argv@entry=0x564008989868, dbname=<optimized out>, username=<optimized out>) at ./build/../src/backend/tcop/postgres.c:4101 #17 0x0000564007831664 in BackendRun (port=0x564008981600) at ./build/../src/backend/postmaster/postmaster.c:4339 #18 BackendStartup (port=0x564008981600) at ./build/../src/backend/postmaster/postmaster.c:4013 #19 ServerLoop () at ./build/../src/backend/postmaster/postmaster.c:1722 #20 0x0000564007a51e29 in PostmasterMain (argc=5, argv=0x564008934090) at ./build/../src/backend/postmaster/postmaster.c:1330 #21 0x0000564007832ed2 in main (argc=5, argv=0x564008934090) at ./build/../src/backend/main/main.c:228
В списке pgsql-bugs по дате отправления:
Предыдущее
От: Tom LaneДата:
Сообщение: Re: BUG #16023: in PgAdmin4.13, unable to recompile functions that have "search_path" set at the function level
Следующее
От: Tom LaneДата:
Сообщение: Re: BUG #16024: segfault ip 0000560103865c60 error 4 in postgres