Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1a9AKp-0006Aa-7D for pgsql-admin@arkaria.postgresql.org; Wed, 16 Dec 2015 11:33:31 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1a9AKo-0002Vv-68 for pgsql-admin@arkaria.postgresql.org; Wed, 16 Dec 2015 11:33:30 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1a9AJ9-0000Fz-9k for pgsql-admin@postgresql.org; Wed, 16 Dec 2015 11:31:47 +0000 Received: from mx3.wp.pl ([212.77.101.9]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1a9AJ6-0003rk-6Q for pgsql-admin@postgresql.org; Wed, 16 Dec 2015 11:31:46 +0000 Received: (wp-smtpd smtp.wp.pl 5151 invoked from network); 16 Dec 2015 12:31:42 +0100 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=wp.pl; s=1024a; t=1450265502; bh=D5jP8BPZqVVwDGwWixe8DZMDWSCFTn3yFwW0Q+WTOLg=; h=From:To:Subject; b=Gxjf2omuhSQ6AE9KpcB/bx+anoiZY2E5OzLZMwZ+gKdk5Ol40Gr/sxwmtPmR06uvr Yxay2XKJGJgUoyyVDzP1wPkUUCG5ya5FxLRKp8/cFeeKV1kJ525frlNd/MfLaMN5K3 NoP2/C2eXkLYZC+66+Fx3wsdogXh9XvraP7Hfh8o= Received: from out.poczta.wp.pl ([212.77.101.240]) (envelope-sender ) by smtp.wp.pl (WP-SMTPD) with SMTP for ; 16 Dec 2015 12:31:42 +0100 Date: Wed, 16 Dec 2015 12:31:42 +0100 From: =?ISO-8859-2?Q?Micha=B3_Nowak?= To: "pgsql-admin" Subject: Re: semop hanging - Postgres 9.4.4 Message-ID: <56714b9e73a011.46114915@wp.pl> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-2 Content-Transfer-Encoding: 8bit Content-Disposition: inline X-Mailer: Interfejs WWW nowej poczty Wirtualnej Polski X-User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_4) AppleWebKit/600.7.12 (KHTML, like Gecko) Version/8.0.7 Safari/600.7.12 Organization: Poznaj Poczte WP http://poczta.wp.pl/info-start.html X-WP-IP: 37.157.203.70 X-WP-MailID: 7f05b8357b83cb8aaa9f7bb968aed4b4 X-WP-AV: skaner antywirusowy poczty Wirtualnej Polski S. A. X-WP-SPAM: NO 0000000 [sZN0] X-Pg-Spam-Score: -2.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 Hello, > There is no zombi nor defunct process. Now i have 3 stucked processes. When i try to pg_terminate_backend nothing happens: strace: semop(57802972, {{9, -1, 0}}, 1) = 0 semop(57802972, {{9, -1, 0}}, 1) = 0 select(0, NULL, NULL, NULL, {0, 1000}) = 0 (Timeout) select(0, NULL, NULL, NULL, {0, 1000}) = 0 (Timeout) semop(57802972, {{9, -1, 0}}, 1) = 0 --- SIGTERM {si_signo=SIGTERM, si_code=SI_USER, si_pid=4431, si_uid=105} --- rt_sigreturn() = 139718030872480 select(0, NULL, NULL, NULL, {0, 1000}) = 0 (Timeout) semop(57802972, {{9, -1, 0}}, 1) = 0 semop(57802972, {{9, -1, 0}}, 1) = 0 select(0, NULL, NULL, NULL, {0, 1000}) = 0 (Timeout) select(0, NULL, NULL, NULL, {0, 1000}) = 0 (Timeout) select(0, NULL, NULL, NULL, {0, 1000}) = 0 (Timeout) Best Regards, Michal -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin