Re: 8.3b2 XPath-based function index server crash

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Matt Magoffin" <postgresql(dot)org(at)msqr(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 8.3b2 XPath-based function index server crash
Date: 2007-11-18 20:33:19
Message-ID: 8105.1195417999@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Matt Magoffin" <postgresql(dot)org(at)msqr(dot)us> writes:
> So I explored with a SELECT statement, thinking there was some specific
> XML document causing the crash. I could consistently execute this
> statement to get a crash:

> select XMLSERIALIZE( CONTENT
> (xpath('/als:auto-lead-service/als:meta[(at)key="AREA"][1]/text()', xml,
> ARRAY[ARRAY['als','http://autoleadservice.com/xml/als']]))[1] as text)
> from lead order by id limit 1 offset 83367;

Could you put together a self-contained example? It would probably take
someone else a long time to guess at all the details you've left out.

One point in particular is that this query would not use the index
you mentioned, so I doubt that's relevant.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert James 2007-11-18 20:39:12 Sharing static data among several databases
Previous Message Matt Magoffin 2007-11-18 20:16:26 8.3b2 XPath-based function index server crash