Re: BUG #3767: tsearch2 index creation fatal crash

the reported problem below can be reproduced by using this simple query
straight from the documentation:

SELECT to_tsvector('a fat cat sat on a mat and ate a fat rat');

--> postgres.exe dies instantly, with the logs being the same as in the
bugreport.

interestingly using ::tsvector (which according to the documentation is
equivalent) works just fine:

SELECT 'a fat cat sat on a mat and ate a fat rat'::tsvector;

gives the correct result.

default configuration for text search is set to:
default_text_search_config = 'pg_catalog.german'

- thomas

-------- Original Message --------
Subject: [BUGS] BUG #3767: tsearch2 index creation fatal crash
From: Thomas Haegi <me(at)alternize(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Date: 21.11.2007 03:25

> The following bug has been logged online:
>
> Bug reference: 3767
> Logged by: Thomas Haegi
> Email address: me(at)alternize(dot)com
> PostgreSQL version: 8.3b3
> Operating system: Windows 2003
> Description: tsearch2 index creation fatal crash
> Details:
>
> the previously reported problem gets worse if you execute the query 2-3
> times... postgres.exe terminates:
>
> Faulting application postgres.exe, version 8.3.0.7319, faulting module
> postgres.exe, version 8.3.0.7319, fault address 0x001ced2f.
>
> from the pgsql logs:
>
> 2007-11-21 03:24:40 CET LOG: server process (PID 2376) exited with exit
> code 128
> 2007-11-21 03:24:40 CET LOG: terminating any other active server processes
> 2007-11-21 03:24:40 CET WARNING: terminating connection because of crash of
> another server process
> 2007-11-21 03:24:40 CET 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-11-21 03:24:40 CET HINT: In a moment you should be able to reconnect
> to the database and repeat your command.
> 2007-11-21 03:24:40 CET WARNING: terminating connection because of crash of
> another server process
> 2007-11-21 03:24:40 CET 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-11-21 03:24:40 CET HINT: In a moment you should be able to reconnect
> to the database and repeat your command.
> 2007-11-21 03:24:40 CET WARNING: terminating connection because of crash of
> another server process
> 2007-11-21 03:24:40 CET 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-11-21 03:24:40 CET HINT: In a moment you should be able to reconnect
> to the database and repeat your command.
> 2007-11-21 03:24:40 CET WARNING: terminating connection because of crash of
> another server process
> 2007-11-21 03:24:40 CET 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-11-21 03:24:40 CET HINT: In a moment you should be able to reconnect
> to the database and repeat your command.
> 2007-11-21 03:24:40 CET WARNING: terminating connection because of crash of
> another server process
> 2007-11-21 03:24:40 CET 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-11-21 03:24:40 CET HINT: In a moment you should be able to reconnect
> to the database and repeat your command.
> 2007-11-21 03:24:40 CET WARNING: terminating connection because of crash of
> another server process
> 2007-11-21 03:24:40 CET 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-11-21 03:24:40 CET HINT: In a moment you should be able to reconnect
> to the database and repeat your command.
> 2007-11-21 03:24:40 CET LOG: all server processes terminated;
> reinitializing
> 2007-11-21 03:24:41 CET FATAL: pre-existing shared memory block is still in
> use
> 2007-11-21 03:24:41 CET HINT: Check if there are any old server processes
> still running, and terminate them.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly