log pgpool with JDBC

log_client

INSERT INTO testtable not successful
An error occurred when executing the SQL command:
insert into testtable(testcol) values(1)

FATAL: Backend throw an error message
  Detail: Exiting current session because of an error from backend
  Hint: BACKEND Error: "portal "pgpool11973" does not exist"

Execution time: 0.25s
1 statement failed.

log_pgpool

2016-11-21 20:57:05: pid 11973: DEBUG:  processing frontend response
2016-11-21 20:57:05: pid 11973: DETAIL:  received kind 'P'(50) from frontend
2016-11-21 20:57:05: pid 11973: LOCATION:  pool_proto_modules.c:2305
2016-11-21 20:57:05: pid 11973: DEBUG:  session context: clearing doing extended query messaging. DONE
2016-11-21 20:57:05: pid 11973: LOCATION:  pool_session_context.c:286
2016-11-21 20:57:05: pid 11973: DEBUG:  session context: setting doing extended query messaging. DONE
2016-11-21 20:57:05: pid 11973: LOCATION:  pool_session_context.c:275
2016-11-21 20:57:05: pid 11973: DEBUG:  Parse: statement name <>
2016-11-21 20:57:05: pid 11973: LOCATION:  pool_proto_modules.c:934
2016-11-21 20:57:05: pid 11973: DEBUG:  make table name from rangevar: tablename:""testtable""
2016-11-21 20:57:05: pid 11973: LOCATION:  pool_select_walker.c:1273
2016-11-21 20:57:05: pid 11973: LOG:  DB node id: 0 backend pid: 20927 statement: SELECT count(*) from (SELECT has_function_privilege('master', 'to_regclass(cstring)', 'execute') WHERE EXISTS(SELECT * FROM pg_catalog.pg_proc AS p WHERE p.proname = 'to_regclass')) AS s
2016-11-21 20:57:05: pid 11973: LOCATION:  pool_proto_modules.c:3084
2016-11-21 20:57:05: pid 11973: DEBUG:  do_query: extended:1 query:"SELECT count(*) from (SELECT has_function_privilege('master', 'to_regclass(cstring)', 'execute') WHERE EXISTS(SELECT * FROM pg_catalog.pg_proc AS p WHERE p.proname = 'to_regclass')) AS s"
2016-11-21 20:57:05: pid 11973: CONTEXT:  while searching system catalog, When relcache is missed
2016-11-21 20:57:05: pid 11973: LOCATION:  pool_process_query.c:1979
2016-11-21 20:57:05: pid 11973: DEBUG:  pool_write: to backend: 0 kind:P
2016-11-21 20:57:05: pid 11973: CONTEXT:  while searching system catalog, When relcache is missed
2016-11-21 20:57:05: pid 11973: LOCATION:  pool_stream.c:436
2016-11-21 20:57:05: pid 11973: DEBUG:  pool_write: to backend: 0 kind:B
2016-11-21 20:57:05: pid 11973: CONTEXT:  while searching system catalog, When relcache is missed
2016-11-21 20:57:05: pid 11973: LOCATION:  pool_stream.c:436
2016-11-21 20:57:05: pid 11973: DEBUG:  pool_write: to backend: 0 kind:C
2016-11-21 20:57:05: pid 11973: CONTEXT:  while searching system catalog, When relcache is missed
2016-11-21 20:57:05: pid 11973: LOCATION:  pool_stream.c:436
2016-11-21 20:57:05: pid 11973: DEBUG:  pool_write: to backend: 0 kind:S
2016-11-21 20:57:05: pid 11973: CONTEXT:  while searching system catalog, When relcache is missed
2016-11-21 20:57:05: pid 11973: LOCATION:  pool_stream.c:436
2016-11-21 20:57:05: pid 11973: DEBUG:  pool_write: to backend: 0 kind:E
2016-11-21 20:57:05: pid 11973: CONTEXT:  while searching system catalog, When relcache is missed
2016-11-21 20:57:05: pid 11973: LOCATION:  pool_stream.c:436
2016-11-21 20:57:05: pid 11973: DEBUG:  pool_write: to backend: 0 kind:C
2016-11-21 20:57:05: pid 11973: CONTEXT:  while searching system catalog, When relcache is missed
2016-11-21 20:57:05: pid 11973: LOCATION:  pool_stream.c:436
2016-11-21 20:57:05: pid 11973: DEBUG:  pool_write: to backend: 0 kind:P
2016-11-21 20:57:05: pid 11973: CONTEXT:  while searching system catalog, When relcache is missed
2016-11-21 20:57:05: pid 11973: LOCATION:  pool_stream.c:436
2016-11-21 20:57:05: pid 11973: DEBUG:  pool_write: to backend: 0 kind:H
2016-11-21 20:57:05: pid 11973: CONTEXT:  while searching system catalog, When relcache is missed
2016-11-21 20:57:05: pid 11973: LOCATION:  pool_stream.c:436
2016-11-21 20:57:05: pid 11973: DEBUG:  pool_read: read 153 bytes from backend 0
2016-11-21 20:57:05: pid 11973: CONTEXT:  while searching system catalog, When relcache is missed
2016-11-21 20:57:05: pid 11973: LOCATION:  pool_stream.c:190
2016-11-21 20:57:05: pid 11973: DEBUG:  do_query: kind: '1'
2016-11-21 20:57:05: pid 11973: CONTEXT:  while searching system catalog, When relcache is missed
2016-11-21 20:57:05: pid 11973: LOCATION:  pool_process_query.c:2200
2016-11-21 20:57:05: pid 11973: DEBUG:  do_query: received PARSE COMPLETE ('1')
2016-11-21 20:57:05: pid 11973: CONTEXT:  while searching system catalog, When relcache is missed
2016-11-21 20:57:05: pid 11973: LOCATION:  pool_process_query.c:2296
2016-11-21 20:57:05: pid 11973: DEBUG:  do_query: kind: '2'
2016-11-21 20:57:05: pid 11973: CONTEXT:  while searching system catalog, When relcache is missed
2016-11-21 20:57:05: pid 11973: LOCATION:  pool_process_query.c:2200
2016-11-21 20:57:05: pid 11973: DEBUG:  do_query: received BIND COMPLETE ('2')
2016-11-21 20:57:05: pid 11973: CONTEXT:  while searching system catalog, When relcache is missed
2016-11-21 20:57:05: pid 11973: LOCATION:  pool_process_query.c:2303
2016-11-21 20:57:05: pid 11973: DEBUG:  do_query: kind: '3'
2016-11-21 20:57:05: pid 11973: CONTEXT:  while searching system catalog, When relcache is missed
2016-11-21 20:57:05: pid 11973: LOCATION:  pool_process_query.c:2200
2016-11-21 20:57:05: pid 11973: DEBUG:  do_query: received CLOSE COMPLETE ('3')
2016-11-21 20:57:05: pid 11973: CONTEXT:  while searching system catalog, When relcache is missed
2016-11-21 20:57:05: pid 11973: LOCATION:  pool_process_query.c:2309
2016-11-21 20:57:05: pid 11973: DEBUG:  do_query: kind: 'E'
2016-11-21 20:57:05: pid 11973: CONTEXT:  while searching system catalog, When relcache is missed
2016-11-21 20:57:05: pid 11973: LOCATION:  pool_process_query.c:2200
2016-11-21 20:57:05: pid 11973: FATAL:  Backend throw an error message
2016-11-21 20:57:05: pid 11973: DETAIL:  Exiting current session because of an error from backend
2016-11-21 20:57:05: pid 11973: HINT:  BACKEND Error: "portal "pgpool11973" does not exist"
2016-11-21 20:57:05: pid 11973: CONTEXT:  while searching system catalog, When relcache is missed
2016-11-21 20:57:05: pid 11973: LOCATION:  pool_process_query.c:2224
2016-11-21 20:57:05: pid 11973: DEBUG:  pool_write: to backend: 0 kind:X
2016-11-21 20:57:05: pid 11973: LOCATION:  pool_stream.c:436
2016-11-21 20:57:05: pid 11973: DEBUG:  pool_write: to backend: 1 kind:X
2016-11-21 20:57:05: pid 11973: LOCATION:  pool_stream.c:436
2016-11-21 20:57:05: pid 11941: DEBUG:  reaper handler
2016-11-21 20:57:05: pid 11941: LOCATION:  pgpool_main.c:2301
2016-11-21 20:57:05: pid 11941: LOG:  child process with pid: 11973 exits with status 256
2016-11-21 20:57:05: pid 11941: LOCATION:  pgpool_main.c:2359
2016-11-21 20:57:05: pid 11941: LOG:  fork a new child process with pid: 11976
2016-11-21 20:57:05: pid 11941: LOCATION:  pgpool_main.c:2445
2016-11-21 20:57:05: pid 11941: DEBUG:  reaper handler: exiting normally
2016-11-21 20:57:05: pid 11941: LOCATION:  pgpool_main.c:2456
2016-11-21 20:57:05: pid 11976: DEBUG:  initializing backend status
2016-11-21 20:57:05: pid 11976: LOCATION:  child.c:1790