Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 3CC1463287F for ; Mon, 16 Aug 2010 17:47:29 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 68962-07 for ; Mon, 16 Aug 2010 20:47:21 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from joeconway.com (wsip-72-214-29-243.sd.sd.cox.net [72.214.29.243]) by mail.postgresql.org (Postfix) with ESMTP id C4281632867 for ; Mon, 16 Aug 2010 17:47:21 -0300 (ADT) Received: from [192.168.4.40] (account jconway HELO dev.joeconway.com) by joeconway.com (CommuniGate Pro SMTP 4.1.8) with ESMTP-TLS id 10008597; Mon, 16 Aug 2010 13:47:20 -0700 Message-ID: <4C69A3D7.8020609@joeconway.com> Date: Mon, 16 Aug 2010 13:47:19 -0700 From: Joe Conway User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.8.0.12) Gecko/20071019 Fedora/1.5.0.12-3.fc6 pango-text Thunderbird/1.5.0.12 Mnenhy/0.7.5.666 MIME-Version: 1.0 To: Josh Berkus CC: PostgreSQL-development Subject: Re: Return of the Solaris vacuum polling problem -- anyone remember this? References: <4C69827A.409@agliodbs.com> <4C698CAD.2020001@joeconway.com> <4C698D88.6030201@agliodbs.com> In-Reply-To: <4C698D88.6030201@agliodbs.com> X-Enigmail-Version: 1.1.2 OpenPGP: id=B699434A Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------enig5FB142317CF75E6D6D8FF695" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.918 tagged_above=-5 required=5 tests=BAYES_00=-1.9, RDNS_DYNAMIC=0.982 X-Spam-Level: X-Archive-Number: 201008/1145 X-Sequence-Number: 167948 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig5FB142317CF75E6D6D8FF695 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable On 08/16/2010 12:12 PM, Josh Berkus wrote: >=20 >> I've also recently heard a report of vacuum hanging on 8.3.x on Solari= s >> Sparc. Any chance you can get a backtrace from a build with debug symb= ols? >=20 > The problem is that we haven't been able to reproduce the bug in > testing. Like I said, it only seems to happen occasionally ... like > maybe once in 10 or 20 (or more?) autovacuums. We've never been seen i= t > with a manual vacuum at all. >=20 > And we can't rebuild the production servers. Hmmm, well I don't know how to reproduce it on demand either -- I'll try to get a backtrace from the wild if possible. I'll keep you posted... Joe --=20 Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, & 24x7 Support --------------enig5FB142317CF75E6D6D8FF695 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.14 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iQIcBAEBCAAGBQJMaaPYAAoJEDfy90M199hlMBQP/1Y4DXeW9ZhbrsfGDwoBA+9W gWo1NPfHB6ep4PZiJTwVJQQe6CB+kASjGiq/GD1o9pSCOOxbE1OZr2kBvcLo+o0C KixUPbBUqi1SgncCPvrLABrhF2rh2W82Fa2RgdZ6oaE9gl1Nguh2Mujx756kjM90 CUumFZG31PUBK1JqrkzWGPDw31QlUV0pwmD6aX/AGcGTBRBjrw4i8HRgY6gDAqOP UjNeLc0i88JyabCVqD40G9aOyv1WZxpRlgkE5SDGWOMc7Wuoj9YsJomwkEFJrdl7 3OE0XsupWq3EALfgJSxIFPcTkpmNGBadph/e9aEQmmNEVlHd/CP3slRixZu7DK19 lWbRPmYIa0SLXO+GsmD0SPNGNMIob5QwmVmbtHMMuPxslzOz3KOD+buczl18bkpC ADdIw++BCle+cVcz0qTzHeTTkFGmvXs0z44udp1j9r/Tt2ZF5mVJ9Z9RQEv8c2pj H1Kk1JfcuO0asMDTfrB5Vcg+SJ14C1NAXg2+0lVlE4RjyPVf3jkXxcAH0LYjhcI1 nMMkdCNqsA6BfF/nzQwN4ZVKxEh3X3Vv0PfzH4K8FXUCUTBARCJlAWKCX0GHdN6d RUuiP15cnUUhDXvPOH5obgfDMbPGoSzl/4CFIfRvyIxYSAwCR9+rEemATPREQ2rf otvwM+lOg7DgezEPZW+C =YPX/ -----END PGP SIGNATURE----- --------------enig5FB142317CF75E6D6D8FF695--