Re: Segmentation fault with core dump - Mailing list pgsql-general

(gdb) bt full

        newmax = <value optimized out>

#1  0x00000000006e1382 in SearchCatCache (cache=0x2a1aad0,

    v1=<value optimized out>, v2=<value optimized out>,

    v3=<value optimized out>, v4=<value optimized out>) at catcache.c:1143

        res = 1 '\001'

        cur_skey = {{sk_flags = 0, sk_attno = -2, sk_strategy = 3,

            sk_subtype = 0, sk_collation = 0, sk_func = {

              fn_addr = 0x686640 <oideq>, fn_oid = 184, fn_nargs = 2,

              fn_strict = 1 '\001', fn_retset = 0 '\000', fn_stats = 2 '\002',

              fn_extra = 0x0, fn_mcxt = 0x298b108, fn_expr = 0x0},

            sk_argument = 20}, {sk_flags = 0, sk_attno = 0, sk_strategy = 0,

            sk_subtype = 0, sk_collation = 0, sk_func = {fn_addr = 0,

              fn_oid = 0, fn_nargs = 0, fn_strict = 0 '\000',

              fn_retset = 0 '\000', fn_stats = 0 '\000', fn_extra = 0x0,

              fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 0}, {sk_flags = 0,

            sk_attno = 0, sk_strategy = 0, sk_subtype = 0, sk_collation = 0,

            sk_func = {fn_addr = 0, fn_oid = 0, fn_nargs = 0,

              fn_strict = 0 '\000', fn_retset = 0 '\000', fn_stats = 0 '\000',

              fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x0}, sk_argument = 0},

          {sk_flags = 0, sk_attno = 0, sk_strategy = 0, sk_subtype = 0,

            sk_collation = 0, sk_func = {fn_addr = 0, fn_oid = 0,

              fn_nargs = 0, fn_strict = 0 '\000', fn_retset = 0 '\000',

              fn_stats = 0 '\000', fn_extra = 0x0, fn_mcxt = 0x0,

              fn_expr = 0x0}, sk_argument = 0}}

        hashValue = 2280326203

        hashIndex = 59

        elt = 0x7fc28648fb88

        ct = 0x7fc28648fb78

        relation = <value optimized out>

        scandesc = <value optimized out>

        ntp = <value optimized out>

#2  0x00000000006ec69e in getTypeOutputInfo (type=20, typOutput=0x2a8ac30,

    typIsVarlena=0x2a8ac38 "") at lsyscache.c:2438

        typeTuple = <value optimized out>

        pt = <value optimized out>

        __func__ = "getTypeOutputInfo"

#3  0x0000000000459027 in printtup_prepare_info (myState=0x2a50c40,

    typeinfo=0x2e7fc50, numAttrs=42) at printtup.c:263

        thisState = <value optimized out>

        format = <value optimized out>

        formats = 0x0

        i = <value optimized out>

        __func__ = "printtup_prepare_info"

#4  0x00000000004593c4 in printtup (slot=0x2d14618, self=0x2a50c40)

    at printtup.c:297

        typeinfo = <value optimized out>

        myState = 0x2a50c40

        buf = {data = 0x2aa9360 "x\376\243\002", len = 47269400, maxlen = 0,

          cursor = 47269400}

        natts = 42

        i = <value optimized out>

#5  0x00000000006376ca in RunFromStore (portal=0x2aa9360,

    direction=<value optimized out>, count=10, dest=0x2a50c40) at pquery.c:1121

        oldcontext = 0x2aca6f0

        ok = <value optimized out>

        current_tuple_count = 0

        slot = 0x2d14618

#6  0x00000000006377b2 in PortalRunSelect (portal=0x2aa9360,

    forward=<value optimized out>, count=10, dest=0x2a50c40) at pquery.c:939

        queryDesc = 0x0

        direction = ForwardScanDirection

        nprocessed = <value optimized out>

        __func__ = "PortalRunSelect"

#7  0x0000000000638c78 in PortalRun (portal=0x2aa9360, count=10,

    isTopLevel=1 '\001', dest=0x2a50c40, altdest=0x2a50c40,

    completionTag=0x7fffd193d0f0 "") at pquery.c:787

        save_exception_stack = 0x7fffd193cfe0

        save_context_stack = 0x0

        local_sigjmp_buf = {{__jmpbuf = {140736709513424, 8412518331319730861,

              44733280, 0, 4294967295, 3, -8412469024494566739,

              8412517527857939117}, __mask_was_saved = 0, __saved_mask = {

              __val = {76, 44316880, 5, 0, 44804496, 767, 5, 0, 4294967295, 3,

                5565893, 11495616, 4746857, 140736709513424, 140736709513424,

                0}}}}

        result = <value optimized out>

        nprocessed = <value optimized out>

        saveTopTransactionResourceOwner = 0x2a439e0

        saveTopTransactionContext = 0x2a438d0

        saveActivePortal = 0x0

        saveResourceOwner = 0x2a439e0

        savePortalContext = 0x0

        saveMemoryContext = 0x2a438d0

        __func__ = "PortalRun"

#8  0x000000000063661e in exec_execute_message (argc=<value optimized out>,

    argv=<value optimized out>, dbname=0x298a150 "[dbname]",

    username=<value optimized out>) at postgres.c:1965

        completed = <value optimized out>

        execute_is_fetch = 1 '\001'

        completionTag = "\000ELECT 3\000\000\241\361=\000\000\000pÑ\321\377\177\000\000\300@\231\002", '\000' <repeats 12 times>"\200, \355\232\002\000\000\000\000PÑ\321\377\177\000\000U\000`\377\377\377\377\377"

        save_log_statement_stats = 0 '\000'

        was_logged = <value optimized out>

        dest = DestRemoteExecute

        receiver = 0x2a50c40

        portal = <value optimized out>

        sourceText = 0x2d141b8 "declare \"SQL_CUR017CB040\" cursor with hold for SELECT anl.LAB,anl.JOB,anl.COMPANYCODE,anl.SAMPLETYPE,anl.COMPANYLAB,anl.CYLNO,anl.CONTAINERCODE,anl.DATEGCANALYSIS,anl.DATEREPORT,anl.SAMPLENAME,anl.FIE"...

        prepStmtName = 0x817c44 "<unnamed>"

        portalParams = 0x0

        is_xact_command = <value optimized out>

        msec_str = '\000' <repeats 16 times>, "1500\000\000\000\000\330@\231\002\000\000\000"

#9  PostgresMain (argc=<value optimized out>, argv=<value optimized out>,

    dbname=0x298a150 "[dbname]", username=<value optimized out>)

    at postgres.c:4026

        portal_name = 0x2a50420 "SQL_CUR017CB040"

        max_rows = 10

        firstchar = <value optimized out>

        input_message = {data = 0x2a50420 "SQL_CUR017CB040", len = 20,

          maxlen = 1024, cursor = 20}

        local_sigjmp_buf = {{__jmpbuf = {140736709513392, 8412515096121983661,

              1, 1, -9187201950435737471, 0, -8412469024567967059,

              8412517530690536109}, __mask_was_saved = 1, __saved_mask = {

              __val = {0, 0, 0, 18446462598732840960, 18446744073709551615, 0,

                0, 0, 0, 0, 0, 266046903056, 140486762587344, 0, 4294967295,

                0}}}}

        send_ready_for_query = 0 '\000'

        __func__ = "PostgresMain"

#10 0x00000000005f6c61 in BackendRun () at postmaster.c:3612

        ac = 1

        secs = 418739329

        usecs = 43047

        i = <value optimized out>

        av = 0x298a398

        maxac = <value optimized out>

#11 BackendStartup () at postmaster.c:3302

        bn = 0x29940c0

        pid = 0

#12 ServerLoop () at postmaster.c:1466

        rmask = {fds_bits = {32, 0 <repeats 15 times>}}

        selres = <value optimized out>

        readmask = {fds_bits = {224, 0 <repeats 15 times>}}

        nSockets = 8

        now = <value optimized out>

        last_touch_time = 1365422110

        __func__ = "ServerLoop"

#13 0x00000000005f9431 in PostmasterMain (argc=<value optimized out>,

    argv=<value optimized out>) at postmaster.c:1127

        opt = <value optimized out>

        status = <value optimized out>

        userDoption = <value optimized out>

        listen_addr_saved = 1 '\001'

        i = <value optimized out>

        __func__ = "PostmasterMain"

#14 0x000000000059a9b0 in main (argc=5, argv=0x2988480) at main.c:199

No locals.

(gdb)