From: | Norman Yamada <nyamada(at)millburncorp(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Cc: | Tyler Hammond <thammond(at)millburncorp(dot)com> |
Subject: | postgresql 8.2.0 -- LIMIT NULL crashes server |
Date: | 2006-12-21 15:45:40 |
Message-ID: | E7402638-1F69-4060-B6DE-6C2C305239C8@millburncorp.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Running postgresql 8.2.0 on Debian testing, Linux kernel 2.6.12, Dual
Xeon 2.80GHz motherboard,
gcc 4.0.3.
If I run a statement like this:
select * from [table] limit null;
it crashes the server.
Under 8.1.3, limit NULL was synonymous with limit ALL. Here, the
server terminates and restarts with a fatal error message:
> <%:4170> 2006-12-21 10:38:10 ESTLOG: server process (PID 4495) was
> terminated by signal 11
> <%:4170> 2006-12-21 10:38:10 ESTLOG: terminating any other active
> server processes
> <postgres%tmc:4496> 2006-12-21 10:38:10 ESTWARNING: terminating
> connection because of crash of another server process
> <postgres%tmc:4496> 2006-12-21 10:38:10 ESTDETAIL: 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.
> <postgres%tmc:4496> 2006-12-21 10:38:10 ESTHINT: In a moment you
> should be able to reconnect to the database and repeat your command.
> <postgres%tmc:4497> 2006-12-21 10:38:10 ESTWARNING: terminating
> connection because of crash of another server process
> <postgres%tmc:4497> 2006-12-21 10:38:10 ESTDETAIL: 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.
> <postgres%tmc:4497> 2006-12-21 10:38:10 ESTHINT: In a moment you
> should be able to reconnect to the database and repeat your command.
> <norman%clndb:4499> 2006-12-21 10:38:10 ESTFATAL: the database
> system is in recovery mode
> <%:4170> 2006-12-21 10:38:10 ESTLOG: all server processes
> terminated; reinitializing
From | Date | Subject | |
---|---|---|---|
Next Message | Stefan Kaltenbrunner | 2006-12-21 15:50:37 | Re: postgresql 8.2.0 -- LIMIT NULL crashes server |
Previous Message | Tom Lane | 2006-12-21 15:33:41 | Re: BUG #2848: information_schema.key_column_usage does not work |