Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WAvHo-0007Lc-LV for pgsql-admin@arkaria.postgresql.org; Wed, 05 Feb 2014 05:44:36 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WAvHo-0003fE-4R for pgsql-admin@arkaria.postgresql.org; Wed, 05 Feb 2014 05:44:36 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WAvHm-0003do-RX for pgsql-admin@postgresql.org; Wed, 05 Feb 2014 05:44:34 +0000 Received: from crispin.apple.com ([17.151.62.50] helo=mail-out.apple.com) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WAvHj-0000mN-IQ for pgsql-admin@postgresql.org; Wed, 05 Feb 2014 05:44:34 +0000 MIME-version: 1.0 Content-transfer-encoding: 7BIT Content-type: text/plain; CHARSET=US-ASCII Received: from relay7.apple.com ([17.128.113.101]) by mail-out.apple.com (Oracle Communications Messaging Server 7u4-23.01 (7.0.4.23.0) 64bit (built Aug 10 2011)) with ESMTP id <0N0I00E82D9E8NZ1@mail-out.apple.com> for pgsql-admin@postgresql.org; Tue, 04 Feb 2014 21:44:25 -0800 (PST) X-AuditID: 11807165-f79076d0000015d9-60-52f1cfb87815 Received: from [17.153.33.6] (Unknown_Domain [17.153.33.6]) (using TLS with cipher AES128-SHA (128/128 bits)) (Client did not present a certificate) by relay7.apple.com (Apple SCV relay) with SMTP id 34.BB.05593.9BFC1F25; Tue, 04 Feb 2014 21:44:25 -0800 (PST) From: Joel Hedden Subject: 9.3.2 on Mac OS X: WAL Sender never exits on SIGUSR2 when pg_receivexlog is connected Message-id: <4272E166-96DD-4852-8921-B2C8F029A3F9@apple.com> Date: Tue, 04 Feb 2014 21:44:23 -0800 To: pgsql-admin@postgresql.org X-Mailer: Apple Mail (2.1827) X-Brightmail-Tracker: H4sIAAAAAAAAA+NgFvrAJMWRmVeSWpSXmKPExsUiOFORTXfn+Y9BBtvnK1pca1nN5sDocWHf NPYAxigum5TUnMyy1CJ9uwSujJ+dP5gKHrFV/J8e2cC4h7WLkZNDQsBE4uWCu0wQtpjEhXvr 2boYuTiEBDqZJPZ37GYHSbAJqEpsnzWFGcRmFtCSuPHvJROErS2xbOFrsLiwQJzE4SkLwYby CthIdO5dwAJiswioSBx88B5oDgeHiICcxLddkiAmr4CexP5VqSCmhICsxPzTpRMYeWYhmT8L yfxZCA0LGJlXMQoUpeYkVprrJRYU5KTqJefnbmIEhUNDYeoOxsblVocYBTgYlXh4DYQ/Bgmx JpYVV+YeYpTgYFYS4U3sBgrxpiRWVqUW5ccXleakFh9ilOZgURLnLX/6PkhIID2xJDU7NbUg tQgmy8TBKdXAuOS3a4vQxMXnpt16089rFnp8t4DwPfHXOvG1SXd4j79Kt4gJ1BKZ0rtg/6vH rXPrK36mVy4pO3pkT5WNbOfjsk+2BrsZvlVXVO71s9vWqHjuZ9HENru0/fsf2rraR9hPaLj2 o+ms0x3bfDf7Pz/W9OocDvhlNzlZ+WPrDameJZWXDSdFTVj0T4mlOCPRUIu5qDgRANV6WsgD AgAA X-Pg-Spam-Score: -4.7 (----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Hi, I've been testing PostgreSQL 9.3.2 on Mac OS X (10.9.1), the EnterpriseDB release as well as my own modified source, and I'm seeing an issue that didn't affect 9.2.4. I connect a pg_receivexlog instance and have "hot_standby" archiving enabled, with "archive_command" defined correctly. When the WAL Sender process receives a SIGUSR2 from the postmaster (or me), it fails to shut down and pg_receivexlog remains connected. Upon inspection, it looks like the test for "sentPtr == MyWalSnd->flush" is always false at walsender.c:1058 where the wal sender should be shutting down. Replication and archiving seem to be working otherwise. Killing pg_receivexlog allows for the WAL Sender to then terminate. I'm curious if this is a known issue. I have not tried testing the 9.3 HEAD code yet. Thanks, -Joel Hedden -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin