Hi Andres!
On Wed, Apr 10, 2013 at 4:49 PM, Andres Freund <andres@xxxxxxxxxxxxxxx> 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 = "" "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 = "" "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)
