Hi!
Once I saw such problem with VACCUM/VACUUM ANALYZE on Debian 2.0. The
problem was that I enabled locale, and strcoll() was broken in glibc. After
upgarding to Debian 2.1 the problem disappeared.
What OS/compiler/libc do you use? Postgres compilation/startup options?
On Wed, 1 Sep 1999, Jay W. Summet wrote:
> I have upgraded from 6.2 to 6.5.1. I have a nightly script that runs a
> vacuum analyze on my DB. This morning when I checked the output, it had
> errored out.
> I tried running it manually, and got the following result:
>
> fnord% nohup /usr/local/pgsql/bin/psql -c "vacuum analyze;" billing
> NOTICE: AbortTransaction and not in in-progress state
> pqReadData() -- backend closed the channel unexpectedly.
> This probably means the backend terminated abnormally
> before or while processing the request.
> We have lost the connection to the backend, so further processing is
> impossible.
> Terminating.
>
>
> I then tried running just the vacuum, which worked:
>
> fnord% nohup /usr/local/pgsql/bin/psql -c "vacuum;" billing
> VACUUM
> fnord%
>
> Thanks,
> Jay Summet
Oleg.
----
Oleg Broytmann http://members.xoom.com/phd2/ [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
************
