468,765 Members | 1,583 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,765 developers. It's quick & easy.

Backend disconnect problems

Hello everyone,

I have received any error message in my Postgres error log as follows:

"The Postmaster has informed me that some other backend died abnormally
and possibly corrupted shared memory. I have rolled back the current
transaction and am going to terminate your database system connection
and exit. Please reconnect to the database system and repeat your
query."

This error message repeats itself at 11:13, 11:16 and 11:57 on the same
day AM. Then it dissappeared. I can find no evidence of it over the
weekend and went back 20 days in the old logs and no occurrences of it
there either.

I had a user who uses pgamind on occassion for quering the backend who
told me that he did not intterupt any of the criteria he was running.

Do I just chalk it up to a "transient anomaly" ?

Thanks for any help you can give.

Bob Powell
Database Administrator

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 23 '05 #1
1 2535
"Bob Powell" <Bo*@hotchkiss.org> writes:
I have received any error message in my Postgres error log as follows: "The Postmaster has informed me that some other backend died abnormally
and possibly corrupted shared memory.


Is there a core dump from this event? A backtrace from the core dump
would tell us something useful, but the above message doesn't. (There
should at least be a postmaster log entry mentioning the signal number
that killed the failed backend...)

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Sven Jacobs | last post: by
2 posts views Thread by chrisw_14 | last post: by
7 posts views Thread by Ulrich Wisser | last post: by
3 posts views Thread by xincmu | last post: by
reply views Thread by Marin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.