View Revisions: Issue #370

Summary 0000370: Pgpool get stuck with db exception followed by select
Revision 2017-12-11 07:37 by t-ishii
Steps To Reproduce To reproduce the problem please:


create a sh script with the following loop

for ((n=0; n<50000; n++))
 do
(
   echo "iteration $n "
   pgproto -f bug.data -p 9999 -h your_IP -u postgres -d postgres;
) done



========== This is the bug data file to be used with pgproto ===============
'Q' "SET statement_timeout = '4s'"

# Receive response from backend
'Y'

'P' "S1" "SELECT 1/0" 0
'B' "" "S1" 0 0 0
'E' "" 0
'C' 'S' "S1"

'P' "S2" "SELECT * from pg_tables" 0
'B' "" "S2" 0 0 0
'E' "" 0
'C' 'S' "S2"

# Issue Sync message
'S'

# Receive response from backend
'Y'

# Send terminate message
'X'


Revision 2017-12-10 22:13 by avi
Steps To Reproduce
To reproduce the problem please:


create a sh script with the following loop

for ((n=0; n<50000; n++))
 do
(
   echo "iteration $n "
   pgproto -f bug.data -p 9999 -h your_IP -u postgres -d postgres;
) done



========== This is the bug data file to be used with pgproto ===============
'Q' "SET statement_timeout = '4s'"

# Receive response from backend
'Y'

'P' "S1" "SELECT 1/0" 0
'B' "" "S1" 0 0 0
'E' "" 0
'C' 'S' "S1"

'P' "S2" "SELECT * from pg_tables" 0
'B' "" "S2" 0 0 0
'E' "" 0
'C' 'S' "S2"

# Issue Sync message
'S'

# Receive response from backend
'Y'

# Send terminate message
'X'