Thread: BUG #17325: Unexpected streaming replication protocol bytes for IDENTIFY_SYSTEM command

BUG #17325: Unexpected streaming replication protocol bytes for IDENTIFY_SYSTEM command

From
PG Bug reporting form
Date:
The following bug has been logged on the website:

Bug reference:      17325
Logged by:          Greg Rychlewski
Email address:      greg.rychlewski@gmail.com
PostgreSQL version: 13.0
Operating system:   x86_64-apple-darwin18.7.0
Description:

Hi,

I ran the following command and captured the packets with wire shark:

psql "dbname=postgres replication=database" -c "IDENTIFY_SYSTEM;"

The timeline ID returned from psql is displayed as 1. Based on the protocol
docs, I was expecting the packets to correspond to an int32 value of 1, but
I am seeing them coming as the string "1". I see following (values are
hexadecimal):

00 00 00 01 for the length 
31 for the value

Thanks,
Greg


Apologies, this is a false alarm. The oid returned for the datatype is int4 but since this is a simple query the actual value is a string. I didn't read the doc correctly the first time.

On Tue, Dec 7, 2021 at 9:46 PM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      17325
Logged by:          Greg Rychlewski
Email address:      greg.rychlewski@gmail.com
PostgreSQL version: 13.0
Operating system:   x86_64-apple-darwin18.7.0
Description:       

Hi,

I ran the following command and captured the packets with wire shark:

psql "dbname=postgres replication=database" -c "IDENTIFY_SYSTEM;"

The timeline ID returned from psql is displayed as 1. Based on the protocol
docs, I was expecting the packets to correspond to an int32 value of 1, but
I am seeing them coming as the string "1". I see following (values are
hexadecimal):

00 00 00 01 for the length
31 for the value

Thanks,
Greg