Re: [BUGS] BUG #5669: server process was terminated by exception 0xC0000005

2010-09-23 Thread Robert Haas
On Wed, Sep 22, 2010 at 9:04 PM, Tom Lane wrote: > Robert Haas writes: >> Can SHOW return a NULL value, rather than the empty string? > > I think that would take some work in guc.c, and likely a redefinition > of the API for show-hook functions.  I'm not excited about doing it, > particularly not

Re: [BUGS] BUG #5669: server process was terminated by exception 0xC0000005

2010-09-22 Thread Tom Lane
Robert Haas writes: > Can SHOW return a NULL value, rather than the empty string? I think that would take some work in guc.c, and likely a redefinition of the API for show-hook functions. I'm not excited about doing it, particularly not in a bug fix that needs to be back-patched.

Re: [BUGS] BUG #5669: server process was terminated by exception 0xC0000005

2010-09-22 Thread Robert Haas
On Wed, Sep 22, 2010 at 1:54 PM, Tom Lane wrote: > Alvaro Herrera writes: >> Excerpts from Tom Lane's message of mié sep 22 13:36:18 -0400 2010: >>> Well, the more general point is what should "SHOW session_authorization" >>> show in an autovacuum process?  The fact that Andrew wasn't >>> intenti

Re: [BUGS] BUG #5669: server process was terminated by exception 0xC0000005

2010-09-22 Thread Tom Lane
Alvaro Herrera writes: > Excerpts from Tom Lane's message of mié sep 22 13:36:18 -0400 2010: >> Well, the more general point is what should "SHOW session_authorization" >> show in an autovacuum process? The fact that Andrew wasn't >> intentionally doing that doesn't mean that someone else might

Re: [BUGS] BUG #5669: server process was terminated by exception 0xC0000005

2010-09-22 Thread Alvaro Herrera
Excerpts from Tom Lane's message of mié sep 22 13:36:18 -0400 2010: > Alvaro Herrera writes: > > Excerpts from Tom Lane's message of mié sep 22 13:03:06 -0400 2010: > >> Wouldn't an empty string be acceptable? SQL doesn't allow zero-length > >> identifiers, so this couldn't be confused with any r

Re: [BUGS] BUG #5669: server process was terminated by exception 0xC0000005

2010-09-22 Thread Tom Lane
Alvaro Herrera writes: > Excerpts from Tom Lane's message of mié sep 22 13:03:06 -0400 2010: >> Wouldn't an empty string be acceptable? SQL doesn't allow zero-length >> identifiers, so this couldn't be confused with any really-valid value. > I dunno really -- what is this value used for, anyway

Re: [BUGS] BUG #5669: server process was terminated by exception 0xC0000005

2010-09-22 Thread Alvaro Herrera
Excerpts from Tom Lane's message of mié sep 22 13:03:06 -0400 2010: > Alvaro Herrera writes: > > But what would this default value be? > > Wouldn't an empty string be acceptable? SQL doesn't allow zero-length > identifiers, so this couldn't be confused with any really-valid value. I dunno real

Re: [BUGS] BUG #5669: server process was terminated by exception 0xC0000005

2010-09-22 Thread Tom Lane
Alvaro Herrera writes: > Excerpts from Tom Lane's message of mié sep 22 12:39:24 -0400 2010: >> As far as a fix for the crash goes, I'm not sure if it'd be better to >> try to make show_session_authorization() return some sort of default >> value in this scenario, or to try to ensure that the var

Re: [BUGS] BUG #5669: server process was terminated by exception 0xC0000005

2010-09-22 Thread Alvaro Herrera
Excerpts from Tom Lane's message of mié sep 22 12:39:24 -0400 2010: > OK ... so the problem is that the function uses the pg_settings view, > which results in calling show_all_settings(), and in particular it > runs show_session_authorization(), which then dumps core because > session_authorizatio

Re: [BUGS] BUG #5669: server process was terminated by exception 0xC0000005

2010-09-22 Thread Tom Lane
Andrew Geery writes: > The schema below crashes pretty reliably for me. OK ... so the problem is that the function uses the pg_settings view, which results in calling show_all_settings(), and in particular it runs show_session_authorization(), which then dumps core because session_authorization_s

Re: [BUGS] BUG #5669: server process was terminated by exception 0xC0000005

2010-09-22 Thread Andrew Geery
The schema below crashes pretty reliably for me. There are three objects: an immutable function, a table called a and a gin index on table a using the immutable function. To reproduce the crash, do enough inserts into table a to kick off the auto-vacuum process; the insert statement below with th

Re: [BUGS] BUG #5669: server process was terminated by exception 0xC0000005

2010-09-22 Thread Tom Lane
Andrew Geery writes: > I think I've tracked down the problem, although I haven't been able to > get a stack trace yet. I'm afraid that it's my own stupidity, but I > still don't understand why this crashes the entire engine. Me either. Can you narrow it down to a self-contained test case so oth

Re: [BUGS] BUG #5669: server process was terminated by exception 0xC0000005

2010-09-22 Thread Andrew Geery
I think I've tracked down the problem, although I haven't been able to get a stack trace yet. I'm afraid that it's my own stupidity, but I still don't understand why this crashes the entire engine. On the collection table, I have a FTS index. I probably should have defined the index this way: c

Re: [BUGS] BUG #5669: server process was terminated by exception 0xC0000005

2010-09-21 Thread Alvaro Herrera
Excerpts from Andrew Geery's message of mar sep 21 16:37:20 -0400 2010: > Running the server in debug mode, I see the following before the > server crashes -- it looks like something goes wrong with > autovac_balance_cost when trying to analyze the collection table (that > was the table the inserts

Re: [BUGS] BUG #5669: server process was terminated by exception 0xC0000005

2010-09-21 Thread Andrew Geery
Running the server in debug mode, I see the following before the server crashes -- it looks like something goes wrong with autovac_balance_cost when trying to analyze the collection table (that was the table the inserts were being done into). Thanks Andrew 2010-09-21 16:27:40 EDTDEBUG: collectio

Re: [BUGS] BUG #5669: server process was terminated by exception 0xC0000005

2010-09-21 Thread Andrew Geery
I'm just doing insert statements via JDBC. Here's the table definition: CREATE TABLE collection ( id serial NOT NULL, app_uid character(36) NOT NULL DEFAULT uuid_generate_v4(), lock_rev integer NOT NULL DEFAULT 0, collection_type_code character(3) NOT NULL, asset_type_code character(3)

Re: [BUGS] BUG #5669: server process was terminated by exception 0xC0000005

2010-09-21 Thread Heikki Linnakangas
On 21/09/10 21:57, Andrew Geery wrote: The following bug has been logged online: Bug reference: 5669 Logged by: Andrew Geery Email address: andrew.ge...@gmail.com PostgreSQL version: 9.0 Operating system: Windows Vista Description:server process was terminated by ex

[BUGS] BUG #5669: server process was terminated by exception 0xC0000005

2010-09-21 Thread Andrew Geery
The following bug has been logged online: Bug reference: 5669 Logged by: Andrew Geery Email address: andrew.ge...@gmail.com PostgreSQL version: 9.0 Operating system: Windows Vista Description:server process was terminated by exception 0xC005 Details: My PG 9.0 D