Code Monkey home page Code Monkey logo

Comments (3)

bwtakacy avatar bwtakacy commented on August 15, 2024

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.

amitlan avatar amitlan commented on August 15, 2024

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.

bwtakacy avatar bwtakacy commented on August 15, 2024

Wow, great!

from pg_bulkload.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo 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.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.