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

BUG #2463: postgres server crashes on "select count(*) from table;"

From: "Satya Prakash Tripathi" <sptripathi78(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2463: postgres server crashes on "select count(*) from table;"
Date: 2006-06-02 10:15:16
Message-ID: 200606021015.k52AFGSJ044043@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2463
Logged by:          Satya Prakash Tripathi
Email address:      sptripathi78(at)yahoo(dot)com
PostgreSQL version: 8.1.3
Operating system:   Linux
Description:        postgres server crashes on "select count(*) from table;"
Details: 

postgres server crashes on running "select count(*) from  table;" from psql
client

steps to reproduce :

1) create a test table:

CREATE TABLE test_tbl(
a          integer,
b          integer,
c          integer,
d          integer,
e          integer,
f          integer,
g          integer,
h          integer,
i          integer);





2)
run a script to do inserts in this table in a loop.
example script:

-----------------------------------------------------
#set -x
#!/bin/bash
FILE=/tmp/test.log.$$
x=0
y=0
PSQL=`which psql`
while [ 1 ];
do
        if [ $x -eq 1000 ]; then
         ` echo "delete from test_tbl;" | $PSQL -q test_db`
        x=0
        fi
 
        #echo "loop: $x"
        ` echo "insert into test_tbl values(1,1,1,1,1,1,1,1,1);" | $PSQL -q
test_db`
        x=`expr $x + 1`
        y=`expr $y + 1`
        echo " no of inserts(y)=$y"  > $FILE
done                    
-----------------------------------------------------




3)

now on psql client, run select command as following:

test_db=# select count(*) from test_tbl;
WARNING:  terminating connection because of crash of another server process
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.
HINT:  In a moment you should be able to reconnect to the database and
repeat your command.
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded. 



On this, postgres server crashes and terminates psql client connection.

I have seen postgres crashing without running this command too.

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2006-06-02 13:57:24
Subject: Re: BUG #2463: postgres server crashes on "select count(*) from table;"
Previous:From: William ZHANGDate: 2006-06-02 10:12:56
Subject: Re: missing or erroneous pg_hba.conf file

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