BUG #3675: Crash on xpath function with 2 parameters

From: "Jeremy Palmer" <jpalmer(at)linz(dot)govt(dot)nz>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3675: Crash on xpath function with 2 parameters
Date: 2007-10-13 09:58:09
Message-ID: 200710130958.l9D9w98P003385@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 3675
Logged by: Jeremy Palmer
Email address: jpalmer(at)linz(dot)govt(dot)nz
PostgreSQL version: 8.3b1
Operating system: WinXP SP2
Description: Crash on xpath function with 2 parameters
Details:

The following query crashes the backend:

SELECT xpath('/my:a/text()', '<my:a
xmlns:my="http://example.com">test</my:a>');

Server log:

2007-10-13 22:45:38 NZDT LOG: database system was interrupted; last known
up at 2007-10-13 22:43:54 NZDT
2007-10-13 22:45:38 NZDT LOG: database system was not properly shut down;
automatic recovery in progress
2007-10-13 22:45:38 NZDT LOG: record with zero length at 0/871688
2007-10-13 22:45:38 NZDT LOG: redo is not required
2007-10-13 22:45:38 NZDT LOG: database system is ready to accept
connections
2007-10-13 22:45:38 NZDT LOG: autovacuum launcher started
2007-10-13 22:45:38 NZDT LOG: loaded library
"$libdir/plugins/plugin_debugger.dll"
2007-10-13 22:45:44 NZDT LOG: loaded library
"$libdir/plugins/plugin_debugger.dll"
2007-10-13 22:45:47 NZDT LOG: loaded library
"$libdir/plugins/plugin_debugger.dll"
2007-10-13 22:45:48 NZDT LOG: loaded library
"$libdir/plugins/plugin_debugger.dll"
2007-10-13 22:46:29 NZDT LOG: server process (PID 2984) was terminated by
exception 0xC0000005
2007-10-13 22:46:29 NZDT HINT: See C include file "ntstatus.h" for a
description of the hex value.
2007-10-13 22:46:29 NZDT LOG: terminating any other active server
processes
2007-10-13 22:46:29 NZDT WARNING: terminating connection because of crash
of another server process
2007-10-13 22:46:29 NZDT DETAIL: The postmaster has commanded this server
process to roll back the current transaction and exit, because another
server process exited abnormally and possibly corrupted shared memory.
2007-10-13 22:46:29 NZDT HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2007-10-13 22:46:29 NZDT WARNING: terminating connection because of crash
of another server process
2007-10-13 22:46:29 NZDT DETAIL: The postmaster has commanded this server
process to roll back the current transaction and exit, because another
server process exited abnormally and possibly corrupted shared memory.
2007-10-13 22:46:29 NZDT HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2007-10-13 22:46:29 NZDT LOG: all server processes terminated;
reinitializing
2007-10-13 22:46:30 NZDT FATAL: pre-existing shared memory block is still
in use
2007-10-13 22:46:30 NZDT HINT: Check if there are any old server processes
still running, and terminate them.

I'm using the default configuration as setup by the win32 pginstaller.

Thanks
Jeremy

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Rolf de By 2007-10-13 15:58:33 BUG #3676: README.TXT is duff gen
Previous Message Tom Lane 2007-10-13 02:06:10 Re: BUG #3672: ALTER <column> TYPE change the underlying index tablespace to default