Received: from mail.enterprise.net (mail.enterprise.net [194.72.192.18]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA50943 for ; Sat, 23 Oct 1999 10:33:08 -0400 (EDT) (envelope-from olly@lfix.co.uk) Received: from linda.lfix.co.uk (root@max03-055.enterprise.net [194.72.196.55]) by mail.enterprise.net (8.8.5/8.8.5) with ESMTP id PAA16480; Sat, 23 Oct 1999 15:33:06 +0100 (GMT/BST) Received: from lfix.co.uk (olly@localhost [127.0.0.1]) by linda.lfix.co.uk (8.9.3/8.9.3/Debian 8.9.3-6) with ESMTP id OAA30607; Sat, 23 Oct 1999 14:59:26 +0100 Message-Id: <199910231359.OAA30607@linda.lfix.co.uk> X-Authentication-Warning: linda.lfix.co.uk: Host olly@localhost [127.0.0.1] claimed to be lfix.co.uk X-Mailer: exmh version 2.1.1 10/15/1999 (debian) To: phd2@earthling.net cc: Albert REINER , PostgreSQL-SQL , olly@linda.lfix.co.uk Subject: Re: [SQL] Can VACUUM, but cannot do VACUUM ANALYZE In-Reply-To: Message from Oleg Broytmann of "Sat, 23 Oct 1999 12:04:38 -0000." References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Date: Sat, 23 Oct 1999 14:59:26 +0100 From: "Oliver Elphick" Oleg Broytmann wrote: >On Sat, 23 Oct 1999, Albert REINER wrote: >> I.e., I can VACUUM, but I cannot do VACUUM ANALYZE. Why should analyze >> do an ABORT? By the way, I do not notice any strange behavior with >> this database, and pg_dump works fine on it. > > Once I saw similar behaviour. I found thta the problem was in broken >strcoll() function in glibc2; I compiled Postgres with locale support. >After upgrading (Debain GNU/Linux 2.0 to 2.1) I got newer libc, and the >problem gone away. > What system/config you are running? OS, compiler, postgres version, >compilation flags? There was also a specific vacuum analyze bug in vc_abort, fixed in 6.5.2. The error log showed something like ERROR: vacuum: can't destroy lock file! NOTICE: AbortTransaction and not in in-progress state See the pgsql-hackers archive around 10th and 13th August. -- Vote against SPAM: http://www.politik-digital.de/spam/ ======================================== Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver PGP key from public servers; key ID 32B8FAA1 ======================================== "I press toward the mark for the prize of the high calling of God in Christ Jesus." Philippians 3:14