Troublesome handling of dropped connection

From: Francisco Reyes <lists(at)natserv(dot)com>
To: pgsql General List <pgsql-general(at)postgresql(dot)org>
Subject: Troublesome handling of dropped connection
Date: 2001-11-26 19:09:38
Message-ID: 20011126140004.X93780-100000@zoraida.natserv.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I had connected to a Postgresql database, running 7.1.3 on FreeBSD,
machine through ssh/psql. My machine crashed.

Upon restart of my machine I recconected to the database machine, again
ssh to the machine and then run psql.

The table I was loading data to at the time of the disconnection was
unresponsive. I tried to "truncate" it, tried to "vacuum <table> and psql
would just sit there for a long time. On the server log there were several
"MoveOfflineLogs" entries, but nothing else.

I tried to do a "smart" shutdown (pg_ctl stop) and that didn't seem to
work. I ended up doing "pg_ctl stop -m fast".

After the fast stop, the server came back up fine. Did a vacuum <table>
and it was instantaneous.

Any ideas what happened to the database prior to the shutdown?
I didn't have anyone else connected so it was not a problem shutting down
the server, however is there anything else I could have tried? In the
coming weeks this machine will go into production and then I will have
more users and a shutdown would not be convenient.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-11-26 19:20:32 Re: pl/perl won't build under 7.1.3
Previous Message Mike Harding 2001-11-26 19:04:01 Re: Strange performance issue