[pgpool-general: 3528] Re: Amazon EC2 Load Balancer health check kills pgPool node

[James Sewell]

I can see some messages like this also (with the negative packet length),
I'm not sure what the difference is - but I'm 99% sure they are all coming
from an AWS ELB.

2015-03-16 17:36:25 ERROR: pid 3072: read_startup_packet: incorrect packet
length (-565767200)
2015-03-16 17:36:35 ERROR: pid 3072: read_startup_packet: incorrect packet
length (0)
2015-03-16 17:36:45 ERROR: pid 3069: read_startup_packet: incorrect packet
length (-1746037008)


Cheers,


James Sewell,
PostgreSQL Team Lead / Solutions Architect
______________________________________


 Level 2, 50 Queen St, Melbourne VIC 3000

*P *(+61) 3 8370 8000  *W* www.lisasoft.com  *F *(+61) 3 8370 8099


On Tue, Mar 17, 2015 at 11:31 AM, Tatsuo Ishii <ishii at postgresql.org> wrote:

> > Hey,
> >
> > We use the same setup on 3.3.1 (AWS with ELB doing TCP health check), but
> > we get these error messages:
> >
> > 2015-03-16 17:38:05 ERROR: pid 3049: read_startup_packet: incorrect
> packet
> > length (0)
> > 2015-03-16 17:38:15 ERROR: pid 3049: read_startup_packet: incorrect
> packet
> > length (0)
> > 2015-03-16 17:38:25 ERROR: pid 3049: read_startup_packet: incorrect
> packet
> > length (0)
> > 2015-03-16 17:38:35 ERROR: pid 3049: read_startup_packet: incorrect
> packet
> > length (0)
> >
> > There is no backend crash I can see.
>
> Interesting.
>
> When I connect to pgpool-II localhost with telnet, I see these:
>
> 2015-03-17 08:15:50: pid 6436: ERROR:  failed while reading startup packet
> 2015-03-17 08:15:50: pid 6436: DETAIL:  incorrect packet length (-720903)
>
> This is git HEAD (almost same as 3.4.1).
>
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
>

-- 


------------------------------
The contents of this email are confidential and may be subject to legal or 
professional privilege and copyright. No representation is made that this 
email is free of viruses or other defects. If you have received this 
communication in error, you may not copy or distribute any part of it or 
otherwise disclose its contents to anyone. Please advise the sender of your 
incorrect receipt of this correspondence.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150317/e23ea864/attachment.html>