Skip site navigation (1) Skip section navigation (2)

Re: segfault of autovacuum process during restore - coredumps included

From: Frank van Vugt <ftm(dot)van(dot)vugt(at)foxi(dot)nl>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: segfault of autovacuum process during restore - coredumps included
Date: 2005-11-28 20:36:45
Message-ID: 200511282136.46128.ftm.van.vugt@foxi.nl (view raw or flat)
Thread:
Lists: pgsql-bugs
Alvaro,

> Hum, I'm unable to reproduce the problem here; could you give me the
> code for the functions in the functional indexes for tables 164956 or
> 227469?  They must be non-trivial SQL functions AFAICT (I'm rather
> unable to figure out their shape based only on the backtrace.)

Obviously the oid's have changed ;), but the relid in frame 13 of the latest 
backtrace:

#13 0x080febd6 in analyze_rel (relid=268480, vacstmt=0x4422f4a0) at 
analyze.c:257

is referring to a table 'purchaseorder_line' which has one functional index 
defined like this (taken from '\d' output):

	"purchaseorder_line_idx01" btree (salesorder_line_id) 
	WHERE status_id <> pol_stat('POL_CANCELLED'::character varying) 
		AND status_id <> pol_stat('POL_HANDLED'::character varying)

The pol_stat() function is a helper-function used to refer to statusses by 
abbreviation instead of id and is defined as:

	CREATE OR REPLACE FUNCTION pol_stat(varchar)
		RETURNS int
		LANGUAGE 'sql'
		IMMUTABLE
		STRICT
		SECURITY INVOKER
		AS 'SELECT id FROM purchaseorder_line_status WHERE abbreviation = $1';


If you were interested in some other relid, just let me know.



-- 
Best,




Frank.

In response to

pgsql-bugs by date

Next:From: Jim C. NasbyDate: 2005-11-28 20:51:06
Subject: Re: Hi
Previous:From: Frank van VugtDate: 2005-11-28 20:17:39
Subject: Re: segfault of autovacuum process during restore - coredumps included

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group