From: | Vijaykumar Jain <vijaykumarjain(dot)github(at)gmail(dot)com> |
---|---|
To: | Ignacio Rey <ignaciorey(at)virgilio(dot)it> |
Cc: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: JDBC error: Unexpected packet type: 25 |
Date: | 2021-06-09 14:32:36 |
Message-ID: | CAM+6J94hakYKzfuLwzeezq-WdGe-feMjUnOrdW=oDFz=_UOY5Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
" java.io.IOException: Unexpected packet type: 25"
char 25 is EM. ( End of Medium)
I do not see it being part of the wire protocol, as for the same reason,
not in pgjdbc handling i think.
PostgreSQL: Documentation: 13: 52.7. Message Formats
<https://www.postgresql.org/docs/current/protocol-message-formats.html>
pgjdbc/QueryExecutorImpl.java at REL42.2.10 · pgjdbc/pgjdbc (github.com)
<https://github.com/pgjdbc/pgjdbc/blob/REL42.2.10/pgjdbc/src/main/java/org/postgresql/core/v3/QueryExecutorImpl.java#L2395>
I may be diverting that may not be related but a few things, just in case.
1) we once had a scenario of a bad nic driver e1000, that resulted in a lot
of pkt losses.
We figured out there were too many pkt drops and upgraded the driver to
vmnet or something.
2)You should also raise the same with pgjdbc. I see they have resolved
issues with other mismatched packet types like 52 at their end.
3) I have had some arguments wrt pgjdbc/npgsql having issues with pgbouncer
and not with postgresql directly. I counter by running the same queries
using psql with pgbouncer. never got an error. But I am not an expert with
Java so I keep an open mind and also raise this with the driver owners just
in case as well as pgbouncer. else it is a deadlock :)
Unexpected packet type during stream replication · Issue #1466 ·
pgjdbc/pgjdbc (github.com) <https://github.com/pgjdbc/pgjdbc/issues/1466>
although this one is different issue, can you reproduce this case like
above ?
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 2021-06-09 15:03:47 | Re: bottom / top posting |
Previous Message | Ignacio Rey | 2021-06-09 12:48:14 | JDBC error: Unexpected packet type: 25 |