Re: "could not receive data from client" && "incomplete startup packet"

Поиск
Список
Период
Сортировка
От David Gauthier
Тема Re: "could not receive data from client" && "incomplete startup packet"
Дата
Msg-id CAMBRECDEU_tMXc6Zxju_X053JcunJQj5BXxv_QTYpXUkgdgEKA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: "could not receive data from client" && "incomplete startup packet"  (David Gauthier <davegauthierpg@gmail.com>)
Ответы Re: "could not receive data from client" && "incomplete startup packet"  (David Gauthier <davegauthierpg@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Dan Wierenga
Дата:
Сообщение: Re: BDR, ERROR: previous init failed, manual cleanup is required
Следующее
От: David Gauthier
Дата:
Сообщение: Re: "could not receive data from client" && "incomplete startup packet"