X-Spam-Check-By: sourceware.org
Message-ID: <210.22.146.67.1138107049.wm@webmail.inode.at>
Date: Tue, 24 Jan 2006 13:50:49 +0100 (CET)
Subject: Re: PostgreSQL 8.1.2 crashes diring import...
From: "Reini Urban" <rurban AT x-ray DOT at>
To: <pobox AT verysmall DOT org>
In-Reply-To: <43D5D0C4.9030004@verysmall.org>
References: <43D56D71 DOT 8050008 AT verysmall DOT org>         <43D5D0C4 DOT 9030004 AT verysmall DOT org>
Cc: <cygwin AT cygwin DOT com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-IsSubscribed: yes
Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:cygwin-unsubscribe-archive-cygwin=delorie DOT com AT cygwin DOT com>
List-Subscribe: <mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive: <http://sourceware.org/ml/cygwin/>
List-Post: <mailto:cygwin AT cygwin DOT com>
List-Help: <mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
Delivered-To: mailing list cygwin AT cygwin DOT com

I see in your previous mail, that your cygserver SHM settings
are already at the maximum. Hope that your have that much RAM/Virtual Memory.

The previous error was an interrupted call error 2, which is not the case
with your problem.
Jason's Problem:
3 [main] postmaster 1144 transport_layer_pipes::connect: lost connection
to cygserver, error = 2
...
FATAL:  could not create shared memory segment: Interrupted system call
DETAIL:  Failed system call was shmget(key=5432001, size=8970240, 03600).

Your problem:
9 [main] postmaster 656 transport_layer_pipes::connect: lost
connection to cygserver, error = 121

Can you try running cygserver with -d. For testing best started from the
console, not as service. Maybe within a sysbash to have the same
permissions.

BTW: My cygwin packages 8.06 and 8.1.2 to test against are at
the setup User Url: http://xarch.tu-graz.ac.at/publ/cygwin/

I haven't tested yet such a big 3-4GIG import, a huge index might need
more than with 8.0, but the heavy and parallel regressions do all pass
so far.

> Adding to my own message.
>
> Just found this, which is from two years ago and reflects on the same
> problem -
>
> http://www.cygwin.com/ml/cygwin-apps/2004-01/msg00014.html
>
> This e-mail says that cygserver simply exits upon high load upon
> PostgreSQL.
>
> This e-mail says that the problem is fixed -
>
> http://www.cygwin.com/ml/cygwin-apps/2004-01/msg00179.html
>
> Could it be that the problem has come back?

Could be but I doubt it.
-- 
Reini Urban
http://phpwiki.org/   http://xarch.tu-graz.ac.at/home/rurban/



--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/