Skip to content

Instantly share code, notes, and snippets.

@bdarnell
Created October 1, 2018 19:43
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save bdarnell/f07d1cd944d7dc7c1c4a0ec15fd4d235 to your computer and use it in GitHub Desktop.
Save bdarnell/f07d1cd944d7dc7c1c4a0ec15fd4d235 to your computer and use it in GitHub Desktop.
jepsen postgres dump
Frame 45647: 174 bytes on wire (1392 bits), 174 bytes captured (1392 bits)
Ethernet II, Src: 42:01:0a:80:00:01 (42:01:0a:80:00:01), Dst: 42:01:0a:80:00:1c (42:01:0a:80:00:1c)
Internet Protocol Version 4, Src: 10.128.0.14, Dst: 10.128.0.28
Transmission Control Protocol, Src Port: 41090, Dst Port: 26257, Seq: 13781, Ack: 9845, Len: 108
PostgreSQL
Type: Parse
Length: 79
Statement:
Query: SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL SERIALIZABLE
Parameters: 0
PostgreSQL
Type: Bind
Length: 12
Portal:
Statement:
Parameter formats: 0
Parameter values: 0
Result formats: 0
PostgreSQL
Type: Execute
Length: 9
Portal:
Returns: 1 rows
PostgreSQL
Type: Sync
Length: 4
Frame 45650: 91 bytes on wire (728 bits), 91 bytes captured (728 bits)
Ethernet II, Src: 42:01:0a:80:00:1c (42:01:0a:80:00:1c), Dst: 42:01:0a:80:00:01 (42:01:0a:80:00:01)
Internet Protocol Version 4, Src: 10.128.0.28, Dst: 10.128.0.14
Transmission Control Protocol, Src Port: 26257, Dst Port: 41090, Seq: 9845, Ack: 13889, Len: 25
PostgreSQL
Type: Parse completion
Length: 4
PostgreSQL
Type: Bind completion
Length: 4
PostgreSQL
Type: Command completion
Length: 8
Tag: SET
PostgreSQL
Type: Ready for query
Length: 5
Status: Idle (73)
Frame 45652: 139 bytes on wire (1112 bits), 139 bytes captured (1112 bits)
Ethernet II, Src: 42:01:0a:80:00:01 (42:01:0a:80:00:01), Dst: 42:01:0a:80:00:1c (42:01:0a:80:00:1c)
Internet Protocol Version 4, Src: 10.128.0.14, Dst: 10.128.0.28
Transmission Control Protocol, Src Port: 41090, Dst Port: 26257, Seq: 13889, Ack: 9870, Len: 73
PostgreSQL
Type: Bind
Length: 15
Portal:
Statement: S_2
Parameter formats: 0
Parameter values: 0
Result formats: 0
PostgreSQL
Type: Execute
Length: 9
Portal:
Returns: all rows
PostgreSQL
Type: Bind
Length: 31
Portal:
Statement: S_3
Parameter formats: 1
Format: Binary (1)
Parameter values: 1
Column length: 8
Data: 00000000000000a7
Result formats: 1
Format: Binary (1)
PostgreSQL
Type: Execute
Length: 9
Portal:
Returns: all rows
PostgreSQL
Type: Sync
Length: 4
Frame 45659: 126 bytes on wire (1008 bits), 126 bytes captured (1008 bits)
Ethernet II, Src: 42:01:0a:80:00:1c (42:01:0a:80:00:1c), Dst: 42:01:0a:80:00:01 (42:01:0a:80:00:01)
Internet Protocol Version 4, Src: 10.128.0.28, Dst: 10.128.0.14
Transmission Control Protocol, Src Port: 26257, Dst Port: 41090, Seq: 9870, Ack: 13962, Len: 60
PostgreSQL
Type: Bind completion
Length: 4
PostgreSQL
Type: Command completion
Length: 10
Tag: BEGIN
PostgreSQL
Type: Bind completion
Length: 4
PostgreSQL
Type: Data row
Length: 18
Field count: 1
Column length: 8
Data: 0000000000000001
PostgreSQL
Type: Command completion
Length: 13
Tag: SELECT 1
PostgreSQL
Type: Ready for query
Length: 5
Status: In a transaction (84)
Frame 45661: 128 bytes on wire (1024 bits), 128 bytes captured (1024 bits)
Ethernet II, Src: 42:01:0a:80:00:01 (42:01:0a:80:00:01), Dst: 42:01:0a:80:00:1c (42:01:0a:80:00:1c)
Internet Protocol Version 4, Src: 10.128.0.14, Dst: 10.128.0.28
Transmission Control Protocol, Src Port: 41090, Dst Port: 26257, Seq: 13962, Ack: 9930, Len: 62
PostgreSQL
Type: Bind
Length: 39
Portal:
Statement: S_5
Parameter formats: 2
Format: Binary (1)
Format: Binary (1)
Parameter values: 2
Column length: 4
Data: 00000004
Column length: 8
Data: 00000000000000a7
Result formats: 0
PostgreSQL
Type: Describe
Length: 6
Portal:
PostgreSQL
Type: Execute
Length: 9
Portal:
Returns: 1 rows
PostgreSQL
Type: Sync
Length: 4
Frame 45666: 96 bytes on wire (768 bits), 96 bytes captured (768 bits)
Ethernet II, Src: 42:01:0a:80:00:1c (42:01:0a:80:00:1c), Dst: 42:01:0a:80:00:01 (42:01:0a:80:00:01)
Internet Protocol Version 4, Src: 10.128.0.28, Dst: 10.128.0.14
Transmission Control Protocol, Src Port: 26257, Dst Port: 41090, Seq: 9930, Ack: 14024, Len: 30
PostgreSQL
Type: Bind completion
Length: 4
PostgreSQL
Type: No data
Length: 4
PostgreSQL
Type: Command completion
Length: 13
Tag: UPDATE 1
PostgreSQL
Type: Ready for query
Length: 5
Status: In a transaction (84)
Frame 45667: 97 bytes on wire (776 bits), 97 bytes captured (776 bits)
Ethernet II, Src: 42:01:0a:80:00:01 (42:01:0a:80:00:01), Dst: 42:01:0a:80:00:1c (42:01:0a:80:00:1c)
Internet Protocol Version 4, Src: 10.128.0.14, Dst: 10.128.0.28
Transmission Control Protocol, Src Port: 41090, Dst Port: 26257, Seq: 14024, Ack: 9960, Len: 31
PostgreSQL
Type: Bind
Length: 15
Portal:
Statement: S_1
Parameter formats: 0
Parameter values: 0
Result formats: 0
PostgreSQL
Type: Execute
Length: 9
Portal:
Returns: 1 rows
PostgreSQL
Type: Sync
Length: 4
Frame 45677: 454 bytes on wire (3632 bits), 454 bytes captured (3632 bits)
Ethernet II, Src: 42:01:0a:80:00:1c (42:01:0a:80:00:1c), Dst: 42:01:0a:80:00:01 (42:01:0a:80:00:01)
Internet Protocol Version 4, Src: 10.128.0.28, Dst: 10.128.0.14
Transmission Control Protocol, Src Port: 26257, Dst Port: 41090, Seq: 9960, Ack: 14055, Len: 388
PostgreSQL
Type: Bind completion
Length: 4
PostgreSQL
Type: Error
Length: 382
Severity: ERROR
Code: 40001
File: sql/sqlbase/errors.go
Line: 54
Routine: NewRetryError
Message [truncated]: restart transaction: HandledRetryableTxnError: TransactionRetryError: retry txn (RETRY_ASYNC_WRITE_FAILURE): "sql txn" id=55f33e25 key=/Table/53/1/167/0 rw=true pri=0.03783833 iso=SERIALIZABLE stat=PENDING epo=0 ts=15
Frame 45678: 72 bytes on wire (576 bits), 72 bytes captured (576 bits)
Ethernet II, Src: 42:01:0a:80:00:1c (42:01:0a:80:00:1c), Dst: 42:01:0a:80:00:01 (42:01:0a:80:00:01)
Internet Protocol Version 4, Src: 10.128.0.28, Dst: 10.128.0.14
Transmission Control Protocol, Src Port: 26257, Dst Port: 41090, Seq: 10348, Ack: 14055, Len: 6
PostgreSQL
Type: Ready for query
Length: 5
Status: Idle (73)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment