Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UylcN-0000Fx-Kt for pgsql-admin@arkaria.postgresql.org; Mon, 15 Jul 2013 16:27:19 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1UylcM-0001sK-8a for pgsql-admin@arkaria.postgresql.org; Mon, 15 Jul 2013 16:27:18 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Uyjkz-0005wQ-Qi for pgsql-admin@postgresql.org; Mon, 15 Jul 2013 14:28:05 +0000 Received: from md-17.webhostbox.net ([208.91.198.74]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Uyjks-0001bB-C2 for pgsql-admin@postgresql.org; Mon, 15 Jul 2013 14:28:04 +0000 Received: from mailnull by md-17.webhostbox.net with sa-checked (Exim 4.80) (envelope-from ) id 1Uyjkr-002W9r-8V for pgsql-admin@postgresql.org; Mon, 15 Jul 2013 14:27:57 +0000 Received: from [216.51.44.5] (port=50004 helo=[10.18.12.29]) by md-17.webhostbox.net with esmtpsa (TLSv1:DHE-RSA-AES256-SHA:256) (Exim 4.80) (envelope-from ) id 1Uyjka-002V4y-C6; Mon, 15 Jul 2013 14:27:41 +0000 Message-ID: <51E406D4.6080706@postgresdba.net> Date: Mon, 15 Jul 2013 19:57:32 +0530 From: Prashanth Ranjalkar User-Agent: Mozilla/5.0 (Windows NT 6.2; WOW64; rv:17.0) Gecko/20130307 Thunderbird/17.0.4 MIME-Version: 1.0 To: Eduardo Morras CC: pgsql-admin@postgresql.org Subject: Re: 9.2.2 - semop hanging References: <20130715154428.7867d7d74e4cbca04d8b7e4a@yahoo.es> In-Reply-To: <20130715154428.7867d7d74e4cbca04d8b7e4a@yahoo.es> Content-Type: multipart/alternative; boundary="------------020009010900080109050001" X-Authenticated_sender: prashanth.ranjalkar@postgresdba.net X-Spam-Checker-Version: spamc_ctasd client on localost X-Spam-Level: X-Spam-Status: No, score=0.0 required=50.0 tests=SpamClass_Unknown, VirusClass_Unknown autolearn=disabled version=1.0.0 X-CTCH-PVer: 0000001 X-CTCH-Spam: Unknown X-CTCH-VOD: Unknown X-CTCH-Flags: 0 X-CTCH-RefID: str=0001.0A020203.51E406ED.0099, ss=1, re=0.000, recu=0.000, reip=0.000, cl=1, cld=1, fgs=0 X-CTCH-Score: 0.000 X-CTCH-ScoreCust: 0.000 X-CTCH-Rules: X-CTCH-SenderID: prashanth.ranjalkar@postgresdba.net X-CTCH-SenderID-Flags: 0 X-CTCH-SenderID-TotalMessages: 2 X-CTCH-SenderID-TotalSpam: 0 X-CTCH-SenderID-TotalSuspected: 0 X-CTCH-SenderID-TotalConfirmed: 0 X-CTCH-SenderID-TotalBulk: 0 X-CTCH-SenderID-TotalVirus: 0 X-CTCH-SenderID-TotalRecipients: 0 X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - md-17.webhostbox.net X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - postgresdba.net X-Get-Message-Sender-Via: md-17.webhostbox.net: mailgid no entry from get_relayhosts_entry X-Source: X-Source-Args: X-Source-Dir: X-Pg-Spam-Score: 0.8 (/) 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 This is a multi-part message in MIME format. --------------020009010900080109050001 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit On 15-07-2013 19:14, Eduardo Morras wrote: > On Mon, 15 Jul 2013 10:16:19 -0300 > Rafael Domiciano wrote: > > I'm not a Linux expert, I'm a BSD man, but > > a) do you have an interrupt storm? > b) what does postgres do before the hang? > c) do you have anyother software running? Including contrib modules. It may be a dns lookup timeout (watch port 53 tcp/udp) > d) what filesystem? Needs filesystem some kind of "maintenance window"? I mean flush dirty caches, metadata, wake up barriers... > > > --- --- > Eduardo Morras > > Max seg size, max total shared memory represents SHMMAX and SHMALL respectively. max seg size (kbytes) = 83886080 max total shared memory (kbytes) = 17179869184 At initial glance, I suspect adjusting these values may resolve the issue as SHMALL should be set either total max memory size or in number of pages. I think the value set is too large therefore recommend comment this SHMALL parameter and set only SHMMAX value with 24GB. Request to verify the server logs if there are any share memory errors and assume that work_mem value is not set to extreme higher value as the max connections has set to 500. /*Thanks & Regards,*/ //** /*Prashanth Ranjalkar*/ /*Database Consultant & Architect*/ /*Email:prashant.ranjalkar@gmail.com* / /*Skype:prashanth.ranjalkar*/ /*Cell: +91 932 568 2271*/ */www.postgresdba.net /* --------------020009010900080109050001 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit
On 15-07-2013 19:14, Eduardo Morras wrote:
On Mon, 15 Jul 2013 10:16:19 -0300
Rafael Domiciano <rafael.domiciano@gmail.com> wrote:

I'm not a Linux expert, I'm a BSD man, but 

a) do you have an interrupt storm?
b) what does postgres do before the hang?
c) do you have anyother software running? Including contrib modules. It may be a dns lookup timeout (watch port 53 tcp/udp)
d) what filesystem? Needs filesystem some kind of "maintenance window"? I mean flush dirty caches, metadata, wake up barriers...


---   ---
Eduardo Morras <emorrasg@yahoo.es>

Max seg size, max total shared memory  represents SHMMAX and SHMALL respectively.
max seg size (kbytes) = 83886080
max total shared memory (kbytes) = 17179869184

At initial glance, I suspect adjusting these values may resolve the issue as SHMALL should be set either total max memory size or in number of pages. I think the value set is too large therefore recommend comment this SHMALL parameter and set only SHMMAX value with 24GB.

Request to verify the server logs if there are any share memory errors and assume that work_mem value is not set to extreme higher value as the max connections has set to 500.
​
Thanks & Regards,
 
Prashanth Ranjalkar
Database Consultant & Architect
Cell: +91 932 568 2271





--------------020009010900080109050001--