Re: "could not receive data from client" && "incomplete startup packet" - Mailing list pgsql-general

From David Gauthier
Subject Re: "could not receive data from client" && "incomplete startup packet"
Date
Msg-id CAMBRECDEU_tMXc6Zxju_X053JcunJQj5BXxv_QTYpXUkgdgEKA@mail.gmail.com
Whole thread Raw
In response to Re: "could not receive data from client" && "incomplete startup packet"  (David Gauthier <davegauthierpg@gmail.com>)
Responses Re: "could not receive data from client" && "incomplete startup packet"
List pgsql-general
I think I found out what's going on.
In the perl script, I'm "forking" a parallel process.  The DB connection gets messed up as a consequence (sorry, I can't articulate better because I don't fully understand).  But the answer (at least what worked for me), is to formally disconnect and then reconnect back in the main thread.  Fortunately, I don't have any outstanding transactions at that time so I don't lose anything as far as that's concerned.

my $pid = fork()

if($pid == 0) {
<do whatever the forked proc needs to do>
}

$dbh->disconnect();
$dbh->connect(...)

proceed with the rest of the perl script.

On Wed, Feb 7, 2018 at 11:59 AM, David Gauthier <davegauthierpg@gmail.com> wrote:
Hi David, thanks for the response.

I upgraded to 9.3.2 and recreated the DB there.  So far, so good.  But nights are usually the worse time, so we'll see later.
There is a more current version of the perl code, but that's not the project default at this time.  If the PG upgrade fixes this, I'll be happy with that, else I'll point to the more recent perl versions.

Thanks Again

On Wed, Feb 7, 2018 at 9:47 AM, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Wed, Feb 7, 2018 at 7:34 AM, David Gauthier <davegauthierpg@gmail.com> wrote:
I have a v9.3.0 PG DB on a linux box as the DB server.
​[...]​
 
Any help would be appreciated!


Upgrade to 9.3.20 and ensure you are using a current version of Perl and DB modules.

David J.



pgsql-general by date:

Previous
From: Dan Wierenga
Date:
Subject: Re: BDR, ERROR: previous init failed, manual cleanup is required
Next
From: David Gauthier
Date:
Subject: Re: "could not receive data from client" && "incomplete startup packet"