From: | David Gauthier <davegauthierpg(at)gmail(dot)com> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: "could not receive data from client" && "incomplete startup packet" |
Date: | 2018-02-07 21:57:41 |
Message-ID: | CAMBRECBbn16sBizCBwxi55-pytwCwiuRsamSQ-fJuV=5POdCeQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I thin kit's 9.3.2 :-(
% psql -V
psql (PostgreSQL) 9.3.2
These are my options...
ls -ld /tool/pandora64/.package/postgresql*
drwxr-xr-x 8 pandora pandora 4096 Sep 2 2016
/tool/pandora64/.package/postgresql-8.2.3
drwxr-xr-x 8 pandora pandora 4096 Sep 16 2013
/tool/pandora64/.package/postgresql-8.3.0
drwxr-xr-x 6 pandora pandora 4096 Aug 31 2015
/tool/pandora64/.package/postgresql-9.0.2
drwxr-xr-x 6 pandora pandora 4096 Oct 11 2013
/tool/pandora64/.package/postgresql-9.3.0
drwxr-xr-x 6 pandora pandora 4096 May 30 2014
/tool/pandora64/.package/postgresql-9.3.2
drwxr-xr-x 6 pandora pandora 4096 Oct 19 2016
/tool/pandora64/.package/postgresql-9.6.0
What about 9.6.0 ?
On Wed, Feb 7, 2018 at 4:47 PM, David Gauthier <davegauthierpg(at)gmail(dot)com>
wrote:
> 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(at)gmail(dot)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(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>>
>>> On Wed, Feb 7, 2018 at 7:34 AM, David Gauthier <davegauthierpg(at)gmail(dot)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.
>>>
>>>
>>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2018-02-07 23:24:53 | Re: "could not receive data from client" && "incomplete startup packet" |
Previous Message | David Gauthier | 2018-02-07 21:47:58 | Re: "could not receive data from client" && "incomplete startup packet" |