From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Emils Klotins" <emils(at)mail(dot)usis(dot)bkc(dot)lv> |
Cc: | pgsql-sql(at)postgreSQL(dot)org |
Subject: | Re: [SQL] Backend dies (6.5.3-1) on SELECT from 6 row table |
Date: | 1999-11-26 16:20:24 |
Message-ID: | 15891.943633224@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
"Emils Klotins" <emils(at)mail(dot)usis(dot)bkc(dot)lv> writes:
> When I try to "SELECT * FROM most of the tables (except for
> ones which have 2 or less rows) , the backend dies:
> If i try to select specific field (address_id or lastname,
> firstname from the same table - it works).
That's really odd. I doubt you have a memory problem; corrupted
data or maybe an outright bug of some kind seem more likely.
What error message, if any, shows up in the postmaster log file?
Also, the crashed backend presumably leaves a core file in the database
directory. Do you know how to use gdb to get a backtrace showing what
the backend was doing? Briefly it's
gdb path/to/postgres path/to/core
bt
quit
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Moray McConnachie | 1999-11-26 16:35:17 | DISTINCT & COUNT |
Previous Message | Artur Kokoszka | 1999-11-26 15:52:15 | national character once again |