====== 001-without-trans ======= FE=> Query(query="SET statement_timeout = '4s'") <= BE CommandComplete(SET) <= BE ReadyForQuery(I) FE=> Parse(stmt="", query="SELECT pg_sleep(3)") FE=> Bind(stmt="", portal="") FE=> Execute(portal="") FE=> Parse(stmt="", query="SELECT pg_sleep(2)") FE=> Bind(stmt="", portal="") FE=> Execute(portal="") FE=> Sync <= BE ParseComplete <= BE BindComplete <= BE DataRow <= BE CommandComplete(SELECT 1) <= BE ParseComplete <= BE BindComplete <= BE DataRow <= BE CommandComplete(SELECT 1) <= BE ReadyForQuery(I) FE=> Terminate ====== 002-with-trans ======= FE=> Query(query="SET statement_timeout = '4s'") <= BE CommandComplete(SET) <= BE ReadyForQuery(I) FE=> Parse(stmt="", query="BEGIN") FE=> Bind(stmt="", portal="") FE=> Execute(portal="") FE=> Parse(stmt="", query="SELECT pg_sleep(3)") FE=> Bind(stmt="", portal="") FE=> Execute(portal="") FE=> Parse(stmt="", query="SELECT pg_sleep(2)") FE=> Bind(stmt="", portal="") FE=> Execute(portal="") FE=> Parse(stmt="", query="COMMIT") FE=> Bind(stmt="", portal="") FE=> Execute(portal="") FE=> Sync <= BE ParseComplete <= BE BindComplete <= BE CommandComplete(BEGIN) <= BE ParseComplete <= BE BindComplete <= BE DataRow <= BE CommandComplete(SELECT 1) <= BE ParseComplete <= BE BindComplete <= BE DataRow <= BE CommandComplete(SELECT 1) <= BE ParseComplete <= BE BindComplete <= BE CommandComplete(COMMIT) <= BE ReadyForQuery(I) FE=> Terminate ====== 003-without-trans-timeout ======= FE=> Query(query="SET statement_timeout = '2s'") <= BE CommandComplete(SET) <= BE ReadyForQuery(I) FE=> Parse(stmt="", query="SELECT pg_sleep(1)") FE=> Bind(stmt="", portal="") FE=> Execute(portal="") FE=> Parse(stmt="", query="SELECT pg_sleep(2)") FE=> Bind(stmt="", portal="") FE=> Execute(portal="") FE=> Sync 2017-09-05 11:17:26.619 JST [5911] ERROR: canceling statement due to statement timeout 2017-09-05 11:17:26.619 JST [5911] STATEMENT: SELECT pg_sleep(2) <= BE ParseComplete <= BE BindComplete <= BE DataRow <= BE CommandComplete(SELECT 1) <= BE ParseComplete <= BE BindComplete <= BE ErrorResponse(S ERROR V ERROR C 57014 M canceling statement due to statement timeout F postgres.c L 2983 R ProcessInterrupts ) <= BE ReadyForQuery(I) FE=> Terminate ====== 004-with-trans-timeout ======= FE=> Query(query="SET statement_timeout = '2s'") <= BE CommandComplete(SET) <= BE ReadyForQuery(I) FE=> Parse(stmt="", query="BEGIN") FE=> Bind(stmt="", portal="") FE=> Execute(portal="") FE=> Parse(stmt="", query="SELECT pg_sleep(1)") FE=> Bind(stmt="", portal="") FE=> Execute(portal="") FE=> Parse(stmt="", query="SELECT pg_sleep(2)") FE=> Bind(stmt="", portal="") FE=> Execute(portal="") FE=> Parse(stmt="", query="COMMIT") FE=> Bind(stmt="", portal="") FE=> Execute(portal="") FE=> Sync 2017-09-05 11:17:29.630 JST [5914] ERROR: canceling statement due to statement timeout 2017-09-05 11:17:29.630 JST [5914] STATEMENT: SELECT pg_sleep(2) <= BE ParseComplete <= BE BindComplete <= BE CommandComplete(BEGIN) <= BE ParseComplete <= BE BindComplete <= BE DataRow <= BE CommandComplete(SELECT 1) <= BE ParseComplete <= BE BindComplete <= BE ErrorResponse(S ERROR V ERROR C 57014 M canceling statement due to statement timeout F postgres.c L 2983 R ProcessInterrupts ) <= BE ReadyForQuery(E) FE=> Terminate ====== 005-without-trans-simple-timeout ======= FE=> Query(query="SET statement_timeout = '2s'") <= BE CommandComplete(SET) <= BE ReadyForQuery(I) FE=> Query(query="SELECT pg_sleep(1)") <= BE RowDescription <= BE DataRow <= BE CommandComplete(SELECT 1) <= BE ReadyForQuery(I) FE=> Query(query="SELECT pg_sleep(2)") 2017-09-05 11:17:32.637 JST [5916] ERROR: canceling statement due to statement timeout 2017-09-05 11:17:32.637 JST [5916] STATEMENT: SELECT pg_sleep(2) <= BE RowDescription <= BE ErrorResponse(S ERROR V ERROR C 57014 M canceling statement due to statement timeout F postgres.c L 2983 R ProcessInterrupts ) <= BE ReadyForQuery(I) FE=> Terminate ====== 006-with-trans-simple-timeout ======= FE=> Query(query="SET statement_timeout = '2s'") <= BE CommandComplete(SET) <= BE ReadyForQuery(I) FE=> Query(query="BEGIN") <= BE CommandComplete(BEGIN) <= BE ReadyForQuery(T) FE=> Query(query="SELECT pg_sleep(1)") <= BE RowDescription <= BE DataRow <= BE CommandComplete(SELECT 1) <= BE ReadyForQuery(T) FE=> Query(query="SELECT pg_sleep(2)") 2017-09-05 11:17:35.648 JST [5920] ERROR: canceling statement due to statement timeout 2017-09-05 11:17:35.648 JST [5920] STATEMENT: SELECT pg_sleep(2) <= BE RowDescription <= BE ErrorResponse(S ERROR V ERROR C 57014 M canceling statement due to statement timeout F postgres.c L 2983 R ProcessInterrupts ) <= BE ReadyForQuery(E) FE=> Query(query="COMMIT") <= BE CommandComplete(ROLLBACK) <= BE ReadyForQuery(I) FE=> Terminate ====== 007-timeout-twice ======= FE=> Query(query="SET statement_timeout = '3s'") <= BE CommandComplete(SET) <= BE ReadyForQuery(I) FE=> Parse(stmt="S1", query="SELECT pg_sleep(2)") FE=> Bind(stmt="S1", portal="S2") FE=> Parse(stmt="", query="SET statement_timeout = '1s'") FE=> Bind(stmt="", portal="") FE=> Execute(portal="") FE=> Execute(portal="S2") FE=> Sync 2017-09-05 11:17:36.653 JST [5923] ERROR: canceling statement due to statement timeout 2017-09-05 11:17:36.653 JST [5923] STATEMENT: SELECT pg_sleep(2) <= BE ParseComplete <= BE BindComplete <= BE ParseComplete <= BE BindComplete <= BE CommandComplete(SET) <= BE ErrorResponse(S ERROR V ERROR C 57014 M canceling statement due to statement timeout F postgres.c L 2983 R ProcessInterrupts ) <= BE ReadyForQuery(I) FE=> Parse(stmt="S3", query="SELECT pg_sleep(2)") FE=> Bind(stmt="S3", portal="S2") FE=> Execute(portal="S2") FE=> Sync <= BE ParseComplete <= BE BindComplete <= BE DataRow <= BE CommandComplete(SELECT 1) <= BE ReadyForQuery(I) FE=> Terminate