Mailing-List: contact cygwin-developers-help AT sourceware DOT cygnus DOT com; run by ezmlm
List-Subscribe: <mailto:cygwin-developers-subscribe AT sources DOT redhat DOT com>
List-Archive: <http://sources.redhat.com/ml/cygwin-developers/>
List-Post: <mailto:cygwin-developers AT sources DOT redhat DOT com>
List-Help: <mailto:cygwin-developers-help AT sources DOT redhat DOT com>, <http://sources.redhat.com/ml/#faqs>
Sender: cygwin-developers-owner AT sources DOT redhat DOT com
Delivered-To: mailing list cygwin-developers AT sources DOT redhat DOT com
Date: Wed, 18 Apr 2001 16:48:28 -0400
From: Christopher Faylor <cgf AT redhat DOT com>
To: Cygwin-Developers <cygwin-developers AT cygwin DOT com>
Cc: Pgsql-Cygwin <pgsql-cygwin AT postgresql DOT org>
Subject: Re: UNIX domain socket change breaks PostgreSQL (was Re: [CYGWIN] initdb fails)
Message-ID: <20010418164828.A30878@redhat.com>
Reply-To: cygwin-developers AT cygwin DOT com
Mail-Followup-To: Cygwin-Developers <cygwin-developers AT cygwin DOT com>,
	Pgsql-Cygwin <pgsql-cygwin AT postgresql DOT org>
References: <20010418164518 DOT B394 AT dothill DOT com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.3.11i
In-Reply-To: <20010418164518.B394@dothill.com>; from Jason.Tishler@dothill.com on Wed, Apr 18, 2001 at 04:45:18PM -0400

Which part of the patch caused the problem?

cgf

On Wed, Apr 18, 2001 at 04:45:18PM -0400, Jason Tishler wrote:
>Chris,
>
>The following recent change:
>
>    http://www.cygwin.com/ml/cygwin-cvs/2001-q2/msg00032.html
>
>breaks UNIX domain socket access between PostgreSQL clients and servers.
>
>See the attached for details.
>
>I'm not very knowledgeable with sockets so I don't know if this is a
>Cygwin or PostgreSQL problem.  Any suggestions would be greatly
>appreciated.
>
>Thanks,
>Jason
>
>-- 
>Jason Tishler
>Director, Software Engineering       Phone: +1 (732) 264-8770 x235
>Dot Hill Systems Corp.               Fax:   +1 (732) 264-8798
>82 Bethany Road, Suite 7             Email: Jason DOT Tishler AT dothill DOT com
>Hazlet, NJ 07730 USA                 WWW:   http://www.dothill.com

>From: Jason Tishler <Jason DOT Tishler AT dothill DOT com>
>To: schopen AT dimdi DOT de
>Cc: pgsql-cygwin AT postgresql DOT org
>Subject: Re: [CYGWIN] initdb fails
>Date: Wed, 18 Apr 2001 15:38:38 -0400
>Mail-Followup-To: schopen AT dimdi DOT de, pgsql-cygwin AT postgresql DOT org
>In-Reply-To: <20010418133004 DOT F536 AT dothill DOT com>; from Jason DOT Tishler AT dothill DOT com on Wed, Apr 18, 2001 at 01:30:04PM -0400
>Organization: Dot Hill Systems Corp.
>
>Michael,
>
>On Wed, Apr 18, 2001 at 01:30:04PM -0400, Jason Tishler wrote:
>> On Wed, Apr 18, 2001 at 06:13:43PM +0200, schopen AT dimdi DOT de wrote:
>> > bash-2.04$ bin/initdb
>> > This database system will be initialized with username "schopen".
>> > This user will own all the data files and must also own the server 
>> > process.
>> > 
>> > Creating directory /usr/share/postgresql/data
>> > [snip]
>> > Initializing pg_shadow.
>> > 
>> > initdb failed.
>> > Removing /usr/share/postgresql/data.
>> > Removing temp file /tmp/initdb.194.
>> > 
>> > Any help? Thanks a lot.
>> 
>> I just tried the above with the following configuration:
>> 
>>     NT 4.0 SP6a
>>     PostgreSQL 7.1-2
>>     cygipc 1.09-2
>>     Cygwin 1.1.8-2 (with cygwin1.dll replaced by cygwin1-20010416.dll.bz2)
>> 
>> and the initdb worked as expected.
>
>The plot thickens or I spoke too soon.
>
>Although initdb works, I am getting the following errors when I connect
>to postmaster:
>
>    # server side
>    $ postmaster
>    DEBUG:  database system was shut down at 2001-04-18 15:12:29 
>    DEBUG:  CheckPoint record at (0, 1563376)
>    DEBUG:  Redo record at (0, 1563376); Undo record at (0, 0); Shutdown TRUE
>    DEBUG:  NextTransactionId: 619; NextOid: 18720
>    DEBUG:  database system is in production state
>    pq_flush: send() failed: The connection was aborted
>    pq_recvbuf: recv() failed: errno ESHUTDOWN triggered
>
>    # client side
>    $ psql -l
>    psql: pqReadData() -- backend closed the channel unexpectedly.
>            This probably means the backend terminated abnormally
>            before or while processing the request.
>
>The Cygwin snapshot from 4/13/2001 works but the one from 4/14/2001
>doesn't.  I'm trying to determine why.  I will report back when I get
>more information.
>
>If anyone wants to help, please jump in.
>
>Thanks,
>Jason
>
>-- 
>Jason Tishler
>Director, Software Engineering       Phone: +1 (732) 264-8770 x235
>Dot Hill Systems Corp.               Fax:   +1 (732) 264-8798
>82 Bethany Road, Suite 7             Email: Jason DOT Tishler AT dothill DOT com
>Hazlet, NJ 07730 USA                 WWW:   http://www.dothill.com
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://www.postgresql.org/search.mpl
>


-- 
cgf AT cygnus DOT com                        Red Hat, Inc.
http://sources.redhat.com/            http://www.redhat.com/