pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: vignesh C <vignesh21@gmail.com>
Cc: Greg Nancarrow <gregn4422@gmail.com>
Cc: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: Anastasia Lubennikova <a.lubennikova@postgrespro.ru>
Cc: Peter Smith <smithpb2250@gmail.com>
Cc: Smith, Peter <peters@fast.au.fujitsu.com>
Cc: David Steele <david@pgmasters.net>
Cc: Tsunakawa, Takayuki <tsunakawa.takay@fujitsu.com>
Cc: Haribabu Kommi <kommi.haribabu@gmail.com>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Dave Cramer <pg@fastcrypt.com>
Cc: Jing Wang <jingwangian@gmail.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Cc: Elvis Pranskevichus <elprans@gmail.com>
Subject: Re: Libpq support to connect to standby server as priority
Date: Wed, 03 Mar 2021 13:54:18 -0500
Message-ID: <1205270.1614797658@sss.pgh.pa.us> (raw)
In-Reply-To: <1149041.1614746350@sss.pgh.pa.us>
References: <20201124225917.GA21884@alvherre.pgsql>
	<325979.1606259987@sss.pgh.pa.us>
	<388250.1606266434@sss.pgh.pa.us>
	<CAJcOf-cgj=bGOZR7F=H+Rg7846ZgC1G+xbkKKLp6zEuOnZeSFQ@mail.gmail.com>
	<493358.1606322607@sss.pgh.pa.us>
	<CAJcOf-emaiiPOgmpxQyAQT=DAOUPPwZ_G7Z70OdD6ZMX2ifCpw@mail.gmail.com>
	<CAJcOf-e-H2VTo_0vuf69Hsh2FS4CxxWzkgDohXDGMr8cCMmurw@mail.gmail.com>
	<3425296.1609882492@sss.pgh.pa.us>
	<CALDaNm0M+70qB=-sXP_-=mu5NSsLC0=QK=0NPfyhZHtMrokEVA@mail.gmail.com>
	<CAJcOf-fgr0QkW+fvfevVcBBJSzPTWHyEJRpvhwDk5ETWxVgGoA@mail.gmail.com>
	<CALDaNm04kMeoXp-HRk2KoKzMaM238=2CO6J6kjPJuziCLorGnQ@mail.gmail.com>
	<CAJcOf-d0NST1ZbEB4-iwapk2y=fKb9xQosbLOf+5j+68C5qMMg@mail.gmail.com>
	<CALDaNm38F070Gs3wYMBBg98iSVUAdsW7YAKfHQ==FoippvbWAA@mail.gmail.com>
	<CAJcOf-fWgXzetSO=ca5K5PbVjqt8QPG4G-+VfFOHM=687mEKkQ@mail.gmail.com>
	<1127614.1614737237@sss.pgh.pa.us>
	<CALDaNm2mo8YED=M2ZJKGf1U3F3mw6SaQuLXWCK8rZP6sECYcrA@mail.gmail.com>
	<1149041.1614746350@sss.pgh.pa.us>

I wrote:
> vignesh C <vignesh21@gmail.com> writes:
>> Conchuela is failing because of:
>> ok 17 - connect to node standby_1 if mode "standby" and standby_1,primary
>> listed
>> ack Broken pipe: write( 13, 'SHOW port;' ) at
>> /usr/local/lib/perl5/site_perl/IPC/Run/IO.pm line 549.

> It didn't fail on the next run, so this might just be a phase-of-the-moon
> glitch.  Conchuela is a bit prone to that sort of thing, in my experience.
> We'll have to wait and see if it's at all repeatable.

Conchuela hasn't shown it again, but it turns out to be repeatable
on my old warhorse gaur.  After a bit of study I see the problem:
we're asking Perl to write to the stdin of a psql process that
may not be there to receive the data.  We've dodged that issue
in other tests by passing "undef" as the stdin to sub psql, so
that's what I did here.

			regards, tom lane





view thread (149+ messages)

Message-ID: <1205270.1614797658@sss.pgh.pa.us>
Permalink:  ../1205270.1614797658@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/1205270.1614797658@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: tgl@sss.pgh.pa.us, vignesh21@gmail.com, gregn4422@gmail.com, alvherre@alvh.no-ip.org, a.lubennikova@postgrespro.ru, smithpb2250@gmail.com, peters@fast.au.fujitsu.com, david@pgmasters.net, tsunakawa.takay@fujitsu.com, kommi.haribabu@gmail.com, robertmhaas@gmail.com, laurenz.albe@cybertec.at, pg@fastcrypt.com, jingwangian@gmail.com, elprans@gmail.com
  Subject: Re: Libpq support to connect to standby server as priority
  In-Reply-To: <1205270.1614797658@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox