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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Satya Prakash Tripathi" <sptripathi78(at)yahoo(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2463: postgres server crashes on "select count(*) from table; "
Date: 2006-06-02 13:57:24
Message-ID: 27999.1149256644@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Satya Prakash Tripathi" <sptripathi78(at)yahoo(dot)com> writes:
> postgres server crashes on running "select count(*) from table;" from psql
> client

I don't think so ;-). Perhaps you have a corrupted copy of the postgres
executables?

> test_db=# select count(*) from test_tbl;
> WARNING: terminating connection because of crash of another server process

It's worth noting that this is NOT what you'd see if the select count(*)
itself were failing. Perhaps you have something going on in the
background that is causing a crash of a different query? Look in your
postmaster log to find out what's actually failing, because the above is
merely blowback.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Sebastien MAYER 2006-06-02 16:11:48 BUG #2464: 'After' are not called the first time of the user session
Previous Message Satya Prakash Tripathi 2006-06-02 10:15:16 BUG #2463: postgres server crashes on "select count(*) from table;"