Re: [GENERAL] 8.3b2 XPath-based function index server crash

2007-11-18 Thread Tom Lane
"Matt Magoffin" <[EMAIL PROTECTED]> writes: > Hmm. I do have a load testing program with which I _might_ be able to get > to generate a sufficient amount of dummy data. However, it apparently will > require many tens of thousands of rows to reproduce the problem. Will I be > able to post a dump fil

Re: [GENERAL] 8.3b2 XPath-based function index server crash

2007-11-18 Thread Matt Magoffin
> "Matt Magoffin" <[EMAIL PROTECTED]> writes: >> I took the latest snapshot from /dev, but I still get the same crash: > > Drat :-(. Please try a bit harder at generating a self-contained > test case. Given where the crash is happening, I suspect it may be > only weakly if at all dependent on you

Re: [GENERAL] 8.3b2 XPath-based function index server crash

2007-11-18 Thread Tom Lane
"Matt Magoffin" <[EMAIL PROTECTED]> writes: > I took the latest snapshot from /dev, but I still get the same crash: Drat :-(. Please try a bit harder at generating a self-contained test case. Given where the crash is happening, I suspect it may be only weakly if at all dependent on your input d

Re: [GENERAL] 8.3b2 XPath-based function index server crash

2007-11-18 Thread Matt Magoffin
>>> (gdb) bt >>> #0 0x8820 in __memcpy () >>> #1 0x004d9098 in xmlBufferAdd () >>> #2 0x004e0dc4 in xmlParserInputBufferCreateMem () >>> #3 0x004ced98 in xmlCtxtReadMemory () >>> #4 0x0026ea0c in xpath (fcinfo=0x37) at xml.c:3183 >>> #5 0x001095bc in ExecMakeFunctionResultNoSets (fcache=

Re: [GENERAL] 8.3b2 XPath-based function index server crash

2007-11-18 Thread Matt Magoffin
> "Matt Magoffin" <[EMAIL PROTECTED]> writes: >> (gdb) bt >> #0 0x8820 in __memcpy () >> #1 0x004d9098 in xmlBufferAdd () >> #2 0x004e0dc4 in xmlParserInputBufferCreateMem () >> #3 0x004ced98 in xmlCtxtReadMemory () >> #4 0x0026ea0c in xpath (fcinfo=0x37) at xml.c:3183 >> #5 0x001095bc in

Re: [GENERAL] 8.3b2 XPath-based function index server crash

2007-11-18 Thread Matt Magoffin
> "Matt Magoffin" <[EMAIL PROTECTED]> writes: >> (gdb) bt >> #0 0x8820 in __memcpy () >> #1 0x004d9098 in xmlBufferAdd () >> #2 0x004e0dc4 in xmlParserInputBufferCreateMem () >> #3 0x004ced98 in xmlCtxtReadMemory () >> #4 0x0026ea0c in xpath (fcinfo=0x37) at xml.c:3183 >> #5 0x001095bc in

Re: [GENERAL] 8.3b2 XPath-based function index server crash

2007-11-18 Thread Tom Lane
"Matt Magoffin" <[EMAIL PROTECTED]> writes: > (gdb) bt > #0 0x8820 in __memcpy () > #1 0x004d9098 in xmlBufferAdd () > #2 0x004e0dc4 in xmlParserInputBufferCreateMem () > #3 0x004ced98 in xmlCtxtReadMemory () > #4 0x0026ea0c in xpath (fcinfo=0x37) at xml.c:3183 > #5 0x001095bc in ExecMake

Re: [GENERAL] 8.3b2 XPath-based function index server crash

2007-11-18 Thread Matt Magoffin
> "Matt Magoffin" <[EMAIL PROTECTED]> writes: >> I understand. I cannot make the SELECT query nor the ADD INDEX command >> break on an empty database. I cannot share this database data, either. > > So try to make a test case using dummy data, or with suitably obscured > versions of your real data.

Re: [GENERAL] 8.3b2 XPath-based function index server crash

2007-11-18 Thread Tom Lane
"Matt Magoffin" <[EMAIL PROTECTED]> writes: > I understand. I cannot make the SELECT query nor the ADD INDEX command > break on an empty database. I cannot share this database data, either. So try to make a test case using dummy data, or with suitably obscured versions of your real data. Also, co

Re: [GENERAL] 8.3b2 XPath-based function index server crash

2007-11-18 Thread Matt Magoffin
> On Mon, Nov 19, 2007 at 10:02:20AM +1300, Matt Magoffin wrote: >> Sorry if I left any relavent details out. I've been looking at this for >> a while so many things are probably obvious only to me. Could you hint >> at which additional details you think would be useful here? > > What's being asked

Re: [GENERAL] 8.3b2 XPath-based function index server crash

2007-11-18 Thread Tom Lane
Matt Magoffin <[EMAIL PROTECTED]> writes: > Sorry if I left any relavent details out. I've been looking at this for > a while so many things are probably obvious only to me. Could you hint > at which additional details you think would be useful here? What I asked for was a self-contained example

Re: [GENERAL] 8.3b2 XPath-based function index server crash

2007-11-18 Thread Martijn van Oosterhout
On Mon, Nov 19, 2007 at 10:02:20AM +1300, Matt Magoffin wrote: > Sorry if I left any relavent details out. I've been looking at this for > a while so many things are probably obvious only to me. Could you hint > at which additional details you think would be useful here? What's being asked for i

Re: [GENERAL] 8.3b2 XPath-based function index server crash

2007-11-18 Thread Matt Magoffin
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] (Tom Lane) wrote: > "Matt Magoffin" <[EMAIL PROTECTED]> 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: > > >

Re: [GENERAL] 8.3b2 XPath-based function index server crash

2007-11-18 Thread Tom Lane
"Matt Magoffin" <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED

[GENERAL] 8.3b2 XPath-based function index server crash

2007-11-18 Thread Matt Magoffin
Hello, I currently have a table in Postgres 8.1 with a text column that contains XML. I use the xml2 module to define several XPath-based function indices on that column, and this has worked very well. I'm trying not to evaluate the native XML support in 8.3b2. I dumped this table from 8.1, then l