Your message dated Tue, 7 Feb 2006 00:42:18 +0100 with message-id <[EMAIL PROTECTED]> and subject line postgresql: VACUUM FULL produce warnings has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what I am talking about this indicates a serious mail system misconfiguration somewhere. Please contact me immediately.) Debian bug tracking system administrator (administrator, Debian Bugs database)
--- Begin Message --->From [EMAIL PROTECTED] Tue Jun 08 06:19:17 2004 Received: (at submit) by bugs.debian.org; 8 Jun 2004 13:19:18 +0000 Return-path: <[EMAIL PROTECTED]> Received: from gold.penza.com.ru [80.82.170.1] by spohr.debian.org with esmtp (Exim 3.35 1 (Debian)) id 1BXgVZ-0000S8-00; Tue, 08 Jun 2004 06:19:17 -0700 Received: from topalm2.dionis.local ([80.82.171.26]) by gold.penza.com.ru (8.8.7/8.8.7/PUUG) with ESMTP id RAA07086 for <[EMAIL PROTECTED]>; Tue, 8 Jun 2004 17:17:57 +0400 Received: from admin by topalm2.dionis.local with local (Exim 3.35 #1 (Debian)) id 1BXgVV-00035n-00; Tue, 08 Jun 2004 17:19:13 +0400 From: "Ed" <[EMAIL PROTECTED]> To: Debian Bug Tracking System <[EMAIL PROTECTED]> Subject: postgresql: VACUUM FULL produce warnings X-Mailer: reportbug 1.50 Date: Tue, 08 Jun 2004 17:19:13 +0400 Message-Id: <[EMAIL PROTECTED]> Sender: Edo <[EMAIL PROTECTED]> Delivered-To: [EMAIL PROTECTED] X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2004_03_25 (1.212-2003-09-23-exp) on spohr.debian.org X-Spam-Status: No, hits=-8.0 required=4.0 tests=BAYES_00,HAS_PACKAGE autolearn=no version=2.60-bugs.debian.org_2004_03_25 X-Spam-Level: Package: postgresql Version: 7.4.2-3.backports.org.1 Severity: normal i have small postgesql database with my own clients (C+libpq). database update are rare (several tens per day), transactions common (one or two every second) if i run "VACUUM FULL" in psql i get several messages like this: WARNING: index "pg_depend_depender_index" contains 3722 row versions, but table contains 3720 row versions if i do REINDEX DATABASE before VACUUM i don't see any warnings. it's normal behaviour? or i must look for problem source? -- System Information Debian Release: 3.0 Architecture: i386 Kernel: Linux topalm2 2.6.7-rc1 #9 SMP Wed May 26 12:28:13 MSD 2004 i686 Locale: LANG=ru_RU.CP1251, LC_CTYPE=ru_RU.CP1251 Versions of packages postgresql depends on: ii adduser 3.47 Add and remove users and groups ii debconf 1.4.25 Debian configuration management sy ii debconf [debconf 1.4.25 Debian configuration management sy ii debianutils 2.8.2 Miscellaneous utilities specific t ii e2fsprogs 1.27-2 The EXT2 file system utilities and ii e2fsprogs [libco 1.27-2 The EXT2 file system utilities and ii libc6 2.3.2.ds1-12 GNU C Library: Shared libraries an ii libcomerr2 1.35-6 The Common Error Description libra ii libkrb53 1.3.3-1 MIT Kerberos runtime libraries ii libpam0g 0.76-21 Pluggable Authentication Modules l ii libperl5.6 5.6.1-8.7 Shared Perl library. ii libpq3 7.4.2-3.backports.org.1 Shared library libpq.so.3 for Post ii libreadline4 4.3-10 GNU readline and history libraries ii libssl0.9.6 0.9.6c-2.woody.6 SSL shared libraries ii mailx 1:8.1.2-0.20020411cvs-1 A simple mail user agent. ii postgresql-clien 7.4.2-3.backports.org.1 Front-end programs for PostgreSQL ii procps 1:3.2.1-2 The /proc file system utilities ii python2.1 2.1.3-3.2 An interactive object-oriented scr ii zlib1g 1:1.2.1.1-3 compression library - runtime
--- End Message ---
--- Begin Message --->From [EMAIL PROTECTED] Mon Feb 06 15:42:43 2006 Received: (at 253295-done) by bugs.debian.org; 6 Feb 2006 23:42:43 +0000 Return-path: <[EMAIL PROTECTED]> Received: from box79162.elkhouse.de ([213.9.79.162]) by spohr.debian.org with esmtp (Exim 4.50) id 1F6G0J-0001CC-BA for [EMAIL PROTECTED]; Mon, 06 Feb 2006 15:42:43 -0800 Received: from localhost.localdomain (unknown [195.227.105.180]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "Martin Pitt (workstation)", Issuer "piware CA" (verified OK)) by box79162.elkhouse.de (Postfix) with ESMTP id 8680DDB08 for <[EMAIL PROTECTED]>; Tue, 7 Feb 2006 00:42:04 +0100 (CET) Received: by localhost.localdomain (Postfix, from userid 1000) id 70CD76460; Tue, 7 Feb 2006 00:42:18 +0100 (CET) Date: Tue, 7 Feb 2006 00:42:18 +0100 From: Martin Pitt <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Re: postgresql: VACUUM FULL produce warnings Message-ID: <[EMAIL PROTECTED]> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="ugCSa1rMkiCAmd9S" Content-Disposition: inline User-Agent: Mutt/1.5.11 X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02 (1.212-2003-09-23-exp) on spohr.debian.org X-Spam-Level: * X-Spam-Status: No, hits=1.1 required=4.0 tests=BAYES_00, RCVD_IN_BL_SPAMCOP_NET,RCVD_IN_SBLXBL,RCVD_IN_SBLXBL_CBL, RCVD_IN_SORBS,RCVD_IN_SORBS_WEB autolearn=no version=2.60-bugs.debian.org_2005_01_02 --ugCSa1rMkiCAmd9S Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Hi! No answer and testcase for this to Debian nor upstream, and this bug is inactive for over two months now, thus I'm closing this now until further information arrives. Thanks, Martin --=20 Martin Pitt http://www.piware.de Ubuntu Developer http://www.ubuntu.com Debian Developer http://www.debian.org In a world without walls and fences, who needs Windows and Gates? --ugCSa1rMkiCAmd9S Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (GNU/Linux) iD8DBQFD597aDecnbV4Fd/IRAmyWAJwIcHI9cIUfUOom2SMoDbAXGwWDrACeLd5i r1PGGB6ekoa6WCkrVYt6YCo= =D6Kc -----END PGP SIGNATURE----- --ugCSa1rMkiCAmd9S--
--- End Message ---
