Comments (3)
I have found the pg_bulkload causes segmentation faults.
Program terminated with signal 11, Segmentation fault.
#0 0x00000000005387f9 in FormIndexDatum (indexInfo=0x2aedae8, slot=0x2ade6b0, estate=0x2ade7d8,
values=0x7ffdf03e5200, isnull=0x7ffdf03e51e0 "") at index.c:1806
1806 iDatum = ExecEvalExprSwitchContext((ExprState *) lfirst(indexpr_item),
Missing separate debuginfos, use: debuginfo-install glibc-2.17-106.el7_2.8.x86_64
(gdb) bt
#0 0x00000000005387f9 in FormIndexDatum (indexInfo=0x2aedae8, slot=0x2ade6b0, estate=0x2ade7d8,
values=0x7ffdf03e5200, isnull=0x7ffdf03e51e0 "") at index.c:1806
#1 0x00007f46998733ac in IndexSpoolInsert (spools=0x2aee448, slot=0x2ade6b0, tupleid=0x2b137dc,
estate=0x2ade7d8) at pg_btree.c:355
#2 0x00007f4699872ee8 in SpoolerInsert (self=0x2ad0600, tuple=0x2b137d8) at pg_btree.c:189
#3 0x00007f469987ebf5 in DirectWriterInsert (self=0x2ad0570, tuple=0x2b137d8)
at writer_direct.c:294
#4 0x00007f469987524a in pg_bulkload (fcinfo=0x7ffdf03e5850) at pg_bulkload.c:278
#5 0x000000000067d414 in ExecMakeTableFunctionResult (setexpr=0x2ad2318, econtext=0x2ad2058,
argContext=0x2aad998, expectedDesc=0x2ad3758, randomAccess=0 '\000') at execSRF.c:230
#6 0x000000000068da1e in FunctionNext (node=0x2ad1f48) at nodeFunctionscan.c:94
#7 0x000000000067cb42 in ExecScanFetch (node=0x2ad1f48, accessMtd=0x68d967 <FunctionNext>,
recheckMtd=0x68dd4c <FunctionRecheck>) at execScan.c:95
#8 0x000000000067cbb1 in ExecScan (node=0x2ad1f48, accessMtd=0x68d967 <FunctionNext>,
recheckMtd=0x68dd4c <FunctionRecheck>) at execScan.c:143
#9 0x000000000068dd81 in ExecFunctionScan (node=0x2ad1f48) at nodeFunctionscan.c:268
#10 0x000000000067b3db in ExecProcNode (node=0x2ad1f48) at execProcnode.c:477
#11 0x0000000000676cfe in ExecutePlan (estate=0x2ad1e38, planstate=0x2ad1f48,
use_parallel_mode=0 '\000', operation=CMD_SELECT, sendTuples=1 '\001', numberTuples=0,
direction=ForwardScanDirection, dest=0x2a8ac58, execute_once=1 '\001') at execMain.c:1651
#12 0x0000000000674f7d in standard_ExecutorRun (queryDesc=0x2a2fde8,
direction=ForwardScanDirection, count=0, execute_once=1 '\001') at execMain.c:360
#13 0x0000000000674e18 in ExecutorRun (queryDesc=0x2a2fde8, direction=ForwardScanDirection,
count=0, execute_once=1 '\001') at execMain.c:303
#14 0x0000000000812b58 in PortalRunSelect (portal=0x2a265b8, forward=1 '\001', count=0,
dest=0x2a8ac58) at pquery.c:933
#15 0x000000000081282f in PortalRun (portal=0x2a265b8, count=9223372036854775807,
isTopLevel=1 '\001', run_once=1 '\001', dest=0x2a8ac58, altdest=0x2a8ac58,
completionTag=0x7ffdf03e60d0 "") at pquery.c:774
#16 0x000000000080e525 in exec_execute_message (portal_name=0x2a8a848 "",
max_rows=9223372036854775807) at postgres.c:1990
#17 0x0000000000810ef4 in PostgresMain (argc=1, argv=0x2a33e38,
dbname=0x2a33d48 "contrib_regression", username=0x2a33d28 "postgres") at postgres.c:4138
#18 0x0000000000785f4b in BackendRun (port=0x2a2a050) at postmaster.c:4317
#19 0x00000000007856f4 in BackendStartup (port=0x2a2a050) at postmaster.c:3989
#20 0x00000000007820a8 in ServerLoop () at postmaster.c:1729
#21 0x000000000078172f in PostmasterMain (argc=1, argv=0x2a06f10) at postmaster.c:1337
#22 0x00000000006c9e26 in main (argc=1, argv=0x2a06f10) at main.c:228
I have spent some time to debug this, but could not resolved :(
Maybe need to understand the postgres commit more closely.
from pg_bulkload.
I reported an issue on pgsql-hackers that caused this segfault crash, and it was fixed last night. Now pg_bulkload doesn't crash. There was an issue with how FormIndexDatum() got memory for index expression state.
from pg_bulkload.
Wow, great!
from pg_bulkload.
Related Issues (20)
- Cannot load unquoted CSV data?
- Build Errors Postgresql 14 - master branch HOT 2
- Compile Error in Ubuntu LTS 22.04 HOT 2
- stride - invalid command HOT 6
- new lines in fields HOT 2
- delimiter - extended string syntax
- failed to install HOT 7
- unable to load to citus distributed table
- PostgreSQL 15 support HOT 4
- Cannot Make HOT 4
- update deprecated actoins for github actions
- Make impossible on Ubuntu HOT 6
- Error on Ubuntu
- Extension version pg_bulkload mistake HOT 6
- rpmbuild issue and question
- what is recovery command's major purpose ?
- pg_bulkload on PG13 fails to handle large data duplicates HOT 8
- missing img in the doc
- PostgreSQL 16 support HOT 5
- how to used in windows10/11?
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from pg_bulkload.