Re: Partitioning option for COPY
Emmanuel Cecchet <manu@asterdata.com>
From: Emmanuel Cecchet <manu@asterdata.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Jan Urbański <wulczer@wulczer.org>, Emmanuel Cecchet <manu@asterdata.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2009-11-17T14:59:58Z
Lists: pgsql-hackers
Tom Lane wrote: > =?UTF-8?B?SmFuIFVyYmHFhHNraQ==?= <wulczer@wulczer.org> writes: > >> Program received signal SIGSEGV, Segmentation fault. >> 0x0819368b in route_tuple_to_child (parent_relation=0xb5d93040, >> tuple=0x873b08c, hi_options=0, parentResultRelInfo=0x871e204) at copy.c:1821 >> 1821 child_relation_id = >> child_oid_cell->oid_value; >> (gdb) p child_oid_cell >> $1 = (OidCell *) 0x7f7f7f7f >> > > This looks like the patch is trying to create a data structure in a > memory context that's not sufficiently long-lived for the use of the > structure. If you do this in a non-cassert build, it will seem to > work, some of the time, if the memory in question happens to not > get reallocated to something else. > I was using the CacheMemoryContext. Could someone tell me why this is wrong and what should have been the appropriate context to use? Thanks Emmanuel -- Emmanuel Cecchet Aster Data Web: http://www.asterdata.com