Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M44886=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1a9cFC-00006E-JZ
 for pgsql-admin@arkaria.postgresql.org; Thu, 17 Dec 2015 17:21:35 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.84) (envelope-from
 <pgsql-admin-owner+M44886=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1a9cFC-0007PP-67
 for pgsql-admin@arkaria.postgresql.org; Thu, 17 Dec 2015 17:21:34 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
 by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
 (Exim 4.84) (envelope-from <minowack@wp.pl>) id 1a9cFB-0007NC-8q
 for pgsql-admin@postgresql.org; Thu, 17 Dec 2015 17:21:33 +0000
Received: from mx4.wp.pl ([212.77.101.12])
 by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
 (Exim 4.84) (envelope-from <minowack@wp.pl>) id 1a9cF8-0007Cm-CH
 for pgsql-admin@postgresql.org; Thu, 17 Dec 2015 17:21:32 +0000
Received: (wp-smtpd smtp.wp.pl 27883 invoked from network);
 17 Dec 2015 18:21:26 +0100
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=wp.pl; s=1024a;
 t=1450372886; bh=jEDIFB4zPYlYUagevmurauNduH85dSmFrdh1AhTWUi8=;
 h=From:To:Subject;
 b=hSSqk1cZL065aK5LopuJdIv6uejT5yIuKhgARmBLhvrVLXFS5Lax0Bget2JKzi9My
 mbaHjS+x1WfFf/K/bculeSSB+nQcoTZzmdN3tgX2L0EO98Mup3uEWs4kONc2ENwBgY
 c7ilRPTBPbgFA+RIrO/fDx2zqe9EZ1VipurXSKwI=
Received: from out.poczta.wp.pl ([212.77.101.240])
 (envelope-sender <minowack@wp.pl>) by smtp.wp.pl (WP-SMTPD) with SMTP
 for <pgsql-admin@postgresql.org>; 17 Dec 2015 18:21:26 +0100
Date: Thu, 17 Dec 2015 18:21:26 +0100
From: =?ISO-8859-2?Q?Micha=B3_Nowak?= <minowack@wp.pl>
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: semop hanging - Postgres 9.4.4
Message-ID: <5672ef1616eef3.56064279@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: 3f1ca290233ab30b121945b007676aa5
X-WP-AV: skaner antywirusowy poczty Wirtualnej Polski S. A.
X-WP-SPAM: NO 0000000 [keMU]                               
X-Pg-Spam-Score: -2.7 (--)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Hello,

Thanks for all replies.


> The perf top output suggests the possibility of a corrupted index,
> causing an endless loop.


Yes! Rebuilding indexes solves problem for this table. :)

But after 20h problem is back on another table. First table has about 2m records, second has only 200k.



> There is a bug fix in 9.4.5 which can cause a deadlock on
> lightweight locking.


I've just upgraded to 9.4.5 and hope that helps. I'll keep you posted. 


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