Skip site navigation (1) Skip section navigation (2)

postgresql 8.2.0 -- LIMIT NULL crashes server

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 (view raw or flat)
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


Responses

pgsql-bugs by date

Next:From: Stefan KaltenbrunnerDate: 2006-12-21 15:50:37
Subject: Re: postgresql 8.2.0 -- LIMIT NULL crashes server
Previous:From: Tom LaneDate: 2006-12-21 15:33:41
Subject: Re: BUG #2848: information_schema.key_column_usage does not work

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group