Hi Andres! On Wed, Apr 10, 2013 at 4:49 PM, Andres Freund <and...@2ndquadrant.com>wrote:
> Could you show the output of 'bt full'? > Program terminated with signal 11, Segmentation fault. #0 ResourceOwnerEnlargeCatCacheRefs (owner=0x0) at resowner.c:605 605 if (owner->ncatrefs < owner->maxcatrefs) (gdb) bt #0 ResourceOwnerEnlargeCatCacheRefs (owner=0x0) at resowner.c:605 #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 #2 0x00000000006ec69e in getTypeOutputInfo (type=20, typOutput=0x2a8ac30, typIsVarlena=0x2a8ac38 "") at lsyscache.c:2438 #3 0x0000000000459027 in printtup_prepare_info (myState=0x2a50c40, typeinfo=0x2e7fc50, numAttrs=42) at printtup.c:263 #4 0x00000000004593c4 in printtup (slot=0x2d14618, self=0x2a50c40) at printtup.c:297 #5 0x00000000006376ca in RunFromStore (portal=0x2aa9360, direction=<value optimized out>, count=10, dest=0x2a50c40) at pquery.c:1121 #6 0x00000000006377b2 in PortalRunSelect (portal=0x2aa9360, forward=<value optimized out>, count=10, dest=0x2a50c40) at pquery.c:939 #7 0x0000000000638c78 in PortalRun (portal=0x2aa9360, count=10, isTopLevel=1 '\001', dest=0x2a50c40, altdest=0x2a50c40, completionTag=0x7fffd193d0f0 "") at pquery.c:787 #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 #9 PostgresMain (argc=<value optimized out>, argv=<value optimized out>, dbname=0x298a150 "[dbname]", username=<value optimized out>) at postgres.c:4026 #10 0x00000000005f6c61 in BackendRun () at postmaster.c:3612 #11 BackendStartup () at postmaster.c:3302 #12 ServerLoop () at postmaster.c:1466 #13 0x00000000005f9431 in PostmasterMain (argc=<value optimized out>, argv=<value optimized out>) at postmaster.c:1127 #14 0x000000000059a9b0 in main (argc=5, argv=0x2988480) at main.c:199 (gdb) bt full #0 ResourceOwnerEnlargeCatCacheRefs (owner=0x0) at resowner.c:605 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)