Node2 log: STATEMENT: SELECT * FROM pg_test WHERE data = $1 FOR UPDATE LOG: 00000: duration: 0.000 ms bind : SELECT * FROM pg_test WHERE data = $1 FOR UPDATE DETAIL: parameters: $1 = '1' LOCATION: exec_bind_message, postgres.c:1932 STATEMENT: SELECT * FROM pg_test WHERE data = $1 FOR UPDATE LOG: 00000: duration: 0.000 ms execute : SELECT * FROM pg_test WHERE data = $1 FOR UPDATE DETAIL: parameters: $1 = '1' LOCATION: exec_execute_message, postgres.c:2151 STATEMENT: SELECT * FROM pg_test WHERE data = $1 FOR UPDATE LOG: 00000: duration: 0.000 ms statement: SELECT PGR_SYSTEM_COMMAND_FUNCTION(8,4375,0,1 LOCATION: exec_simple_query, postgres.c:1310 STATEMENT: SELECT PGR_SYSTEM_COMMAND_FUNCTION(8,4375,0,1 DEBUG: 00000: increased replicate_id to 160391 LOCATION: exec_simple_query, postgres.c:1264 STATEMENT: commit LOG: 00000: duration: 12.768 ms statement: commit LOCATION: exec_simple_query, postgres.c:1310 STATEMENT: commit DEBUG: 00000: replication id set from 160391 to 160393 LOCATION: set_replication_id, replicate.c:1125 STATEMENT: SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1184683715,859597,160393,1,4376 LOG: 00000: duration: 0.005 ms statement: SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1184683715,859597,160393,1,4376 LOCATION: exec_simple_query, postgres.c:1310 STATEMENT: SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1184683715,859597,160393,1,4376 LOG: 00000: duration: 0.000 ms statement: SELECT PGR_SYSTEM_COMMAND_FUNCTION(8,4376,0,1 LOCATION: exec_simple_query, postgres.c:1310 STATEMENT: SELECT PGR_SYSTEM_COMMAND_FUNCTION(8,4376,0,1 DEBUG: 00000: increased replicate_id to 160394 LOCATION: exec_simple_query, postgres.c:1264 STATEMENT: begin LOG: 00000: duration: 0.000 ms statement: begin LOCATION: exec_simple_query, postgres.c:1310 STATEMENT: begin DEBUG: 00000: replication id set from 160394 to 160393 LOCATION: set_replication_id, replicate.c:1125 STATEMENT: SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1184683715,864601,160393,1,4377 LOG: 00000: duration: 5.003 ms statement: SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1184683715,864601,160393,1,4377 LOCATION: exec_simple_query, postgres.c:1310 STATEMENT: SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1184683715,864601,160393,1,4377 DEBUG: 00000: replication id set from 160393 to 160395 LOCATION: set_replication_id, replicate.c:1125 STATEMENT: begin LOG: 00000: duration: 26704.022 ms statement: begin LOCATION: exec_simple_query, postgres.c:1310 STATEMENT: begin DEBUG: 00000: origin's RId = 0 , MyProc->RId = 4377 LOCATION: ProcSleep, proc.c:778 STATEMENT: SELECT * FROM pg_test WHERE data = $1 FOR UPDATE LOG: 00000: duration: 0.000 ms parse : SELECT * FROM pg_test WHERE data = $1 FOR UPDATE LOCATION: exec_parse_message, postgres.c:1569 STATEMENT: SELECT * FROM pg_test WHERE data = $1 FOR UPDATE LOG: 00000: duration: 0.241 ms statement: SELECT 1 LOCATION: exec_simple_query, postgres.c:1310 STATEMENT: SELECT 1 DEBUG: 00000: recv_message():unexpected EOF LOCATION: recv_message, replicate.c:1287 LOG: 08P01: unexpected EOF on client connection LOCATION: SocketBackend, postgres.c:313 WARNING: 01000: This query is not permitted when all replication servers fell down LOCATION: PostgresMain, postgres.c:3757 LOG: 00000: duration: 0.000 ms parse : SELECT * FROM pg_test WHERE data = $1 FOR UPDATE LOCATION: exec_parse_message, postgres.c:1569 STATEMENT: SELECT * FROM pg_test WHERE data = $1 FOR UPDATE LOG: 00000: duration: 0.000 ms bind : SELECT * FROM pg_test WHERE data = $1 FOR UPDATE DETAIL: parameters: $1 = '1' LOCATION: exec_bind_message, postgres.c:1932 STATEMENT: SELECT * FROM pg_test WHERE data = $1 FOR UPDATE LOG: 00000: duration: 0.000 ms execute : SELECT * FROM pg_test WHERE data = $1 FOR UPDATE DETAIL: parameters: $1 = '1' LOCATION: exec_execute_message, postgres.c:2151 STATEMENT: SELECT * FROM pg_test WHERE data = $1 FOR UPDATE