From: | Martti Hertzen <hertzma(at)sqc(dot)fi> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | backend closed the channel unexpectedly?!? |
Date: | 2000-11-08 14:54:40 |
Message-ID: | 3A096930.9FD36B49@sqc.fi |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi,
I don't know if this is the right place to ask this (and I'm sorry if
this isn't) but here is a little problem I encountered. I have been
using postgres in a redhat linux 6.1 for nearly 6 month and it has been
working fine until today. I have a table with a field called 'id'
(primary key) that is referenced from other tables. Today I tried to
delete one of the rows in this table with the following command (worked
fine a few weeks ago) and there's the output. It does that each and
every time I try to update the primary key or delete a row. I've stoped
and started the postmaster several times of course.
testsqc=> DELETE FROM henkilo WHERE id = 12;
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!>
Here's the output of the debug channel:
001108.16:31:16.753 [31195] StartTransactionCommand
001108.16:31:16.753 [31195] query: DELETE FROM henkilo WHERE id = 12;
001108.16:31:16.840 [31195] ProcessQuery
postmaster: reaping dead processes...
postmaster: CleanupProc: pid 31195 exited with status 139
Server process (pid 31195) exited with status 139 at Wed Nov 8 16:31:17
2000
Terminating any active server processes...
Server processes were terminated at Wed Nov 8 16:31:17 2000
Reinitializing shared memory and semaphores
001108.16:31:17.822 [30871] shmem_exit(0)
binding ShmemCreate(key=52e4b5, size=1104896)
etc...
Is this a known problem with a solution to it?
Thanks,
--
Martti Hertzen
PS:
testsqc=> select version();
version
---------------------------------------------------------------------
PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66
(1 row)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-11-08 15:03:07 | Re: backend closed the channel unexpectedly?!? |
Previous Message | Karel Zak | 2000-11-08 10:11:39 | Re: to_date problems (Re: Favor for Postgres User at WSI) |