[pgpool-general: 2623] Re: OTRS

Csaba Ragasits ragasits.csaba at gmail.com
Wed Mar 12 00:46:55 JST 2014


Hello,

Thanks for your answer.
A tried it with log_per_node_statement. I'm sending more detailed log.

Thx,
Csaba


Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22367: DB node
id: 0 backend pid: 23054 statement: BEGIN
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22367: DB node
id: 1 backend pid: 23587 statement: BEGIN
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22367: DB node
id: 0 backend pid: 23054 statement: SET standard_conforming_strings TO ON
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22367: DB node
id: 1 backend pid: 23587 statement: SET standard_conforming_strings TO ON
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22367: DB node
id: 1 backend pid: 23587 statement: COMMIT
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22367: DB node
id: 0 backend pid: 23054 statement: COMMIT
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22367: DB node
id: 0 backend pid: 23054 statement: SELECT count(*) from (SELECT
has_function_privilege('otrs', 'pgpool_regclass(cstring)', 'execute') WHERE
EXISTS(SELECT * FROM pg_catalog.pg_proc AS p WHERE p.proname =
'pgpool_regclass')) AS s
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22367: DB node
id: 0 backend pid: 23054 statement: SELECT count(*) FROM pg_class AS c,
pg_namespace AS n WHERE c.oid = pgpool_regclass('pg_namespace') AND
c.relnamespace = n.oid AND n.nspname = 'pg_catalog'
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22367: DB node
id: 0 backend pid: 23054 statement: SELECT count(*) FROM pg_class AS c,
pg_namespace AS n WHERE c.oid = pgpool_regclass('process_id') AND
c.relnamespace = n.oid AND n.nspname = 'pg_catalog'
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22367: DB node
id: 0 backend pid: 23054 statement: SELECT count(*) FROM
pg_catalog.pg_class AS c, pg_attribute AS a WHERE c.relname = 'pg_class'
AND a.attrelid = c.oid AND a.attname = 'relistemp'
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22367: DB node
id: 0 backend pid: 23054 statement: SELECT count(*) FROM pg_class AS c,
pg_namespace AS n WHERE c.relname = 'process_id' AND c.relnamespace = n.oid
AND n.nspname ~ '^pg_temp_'
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22367: DB node
id: 0 backend pid: 23054 statement: SELECT count(*) FROM
pg_catalog.pg_class AS c, pg_catalog.pg_attribute AS a WHERE c.relname =
'pg_class' AND a.attrelid = c.oid AND a.attname = 'relpersistence'
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22367: DB node
id: 0 backend pid: 23054 statement: SELECT count(*) FROM
pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass('process_id') AND
c.relpersistence = 'u'
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22367: DB node
id: 1 backend pid: 23587 statement: Parse:
Mar 11 15:18:25 utu pgpool:             SELECT process_name, process_id,
process_host, process_create, process_change
Mar 11 15:18:25 utu pgpool:             FROM process_id
Mar 11 15:18:25 utu pgpool:             WHERE process_name = $1 LIMIT 1
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22367: DB node
id: 1 backend pid: 23587 statement: B message
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22367: DB node
id: 1 backend pid: 23587 statement: D message
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22367: DB node
id: 1 backend pid: 23587 statement: Execute:
Mar 11 15:18:25 utu pgpool:             SELECT process_name, process_id,
process_host, process_create, process_change
Mar 11 15:18:25 utu pgpool:             FROM process_id
Mar 11 15:18:25 utu pgpool:             WHERE process_name = $1 LIMIT 1
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22367: DB node
id: 0 backend pid: 23054 statement:  DISCARD ALL
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22367: DB node
id: 1 backend pid: 23587 statement:  DISCARD ALL
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387: DB node
id: 0 backend pid: 23055 statement: BEGIN
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387: DB node
id: 1 backend pid: 23588 statement: BEGIN
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387: DB node
id: 0 backend pid: 23055 statement: SET standard_conforming_strings TO ON
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387: DB node
id: 1 backend pid: 23588 statement: SET standard_conforming_strings TO ON
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387: DB node
id: 1 backend pid: 23588 statement: COMMIT
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387: DB node
id: 0 backend pid: 23055 statement: COMMIT
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387: DB node
id: 0 backend pid: 23055 statement: SELECT count(*) from (SELECT
has_function_privilege('otrs', 'pgpool_regclass(cstring)', 'execute') WHERE
EXISTS(SELECT * FROM pg_catalog.pg_proc AS p WHERE p.proname =
'pgpool_regclass')) AS s
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387: DB node
id: 0 backend pid: 23055 statement: SELECT count(*) FROM pg_class AS c,
pg_namespace AS n WHERE c.oid = pgpool_regclass('pg_namespace') AND
c.relnamespace = n.oid AND n.nspname = 'pg_catalog'
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387: DB node
id: 0 backend pid: 23055 statement: SELECT count(*) FROM pg_class AS c,
pg_namespace AS n WHERE c.oid = pgpool_regclass('process_id') AND
c.relnamespace = n.oid AND n.nspname = 'pg_catalog'
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387: DB node
id: 0 backend pid: 23055 statement: SELECT count(*) FROM
pg_catalog.pg_class AS c, pg_attribute AS a WHERE c.relname = 'pg_class'
AND a.attrelid = c.oid AND a.attname = 'relistemp'
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387: DB node
id: 0 backend pid: 23055 statement: SELECT count(*) FROM pg_class AS c,
pg_namespace AS n WHERE c.relname = 'process_id' AND c.relnamespace = n.oid
AND n.nspname ~ '^pg_temp_'
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387: DB node
id: 0 backend pid: 23055 statement: SELECT count(*) FROM
pg_catalog.pg_class AS c, pg_catalog.pg_attribute AS a WHERE c.relname =
'pg_class' AND a.attrelid = c.oid AND a.attname = 'relpersistence'
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387: DB node
id: 0 backend pid: 23055 statement: SELECT count(*) FROM
pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass('process_id') AND
c.relpersistence = 'u'
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387: DB node
id: 0 backend pid: 23055 statement: Parse:
Mar 11 15:18:25 utu pgpool:             SELECT process_name, process_id,
process_host, process_create, process_change
Mar 11 15:18:25 utu pgpool:             FROM process_id
Mar 11 15:18:25 utu pgpool:             WHERE process_name = $1 LIMIT 1
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387: DB node
id: 0 backend pid: 23055 statement: B message
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387: DB node
id: 0 backend pid: 23055 statement: D message
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387: DB node
id: 0 backend pid: 23055 statement: Execute:
Mar 11 15:18:25 utu pgpool:             SELECT process_name, process_id,
process_host, process_create, process_change
Mar 11 15:18:25 utu pgpool:             FROM process_id
Mar 11 15:18:25 utu pgpool:             WHERE process_name = $1 LIMIT 1
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387: DB node
id: 0 backend pid: 23055 statement: Parse:
Mar 11 15:18:25 utu pgpool:         DELETE FROM process_id
Mar 11 15:18:25 utu pgpool:         WHERE process_name = $1
Mar 11 15:18:25 utu pgpool:         AND process_host = $2
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387: DB node
id: 0 backend pid: 23055 statement: BEGIN
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387: DB node
id: 0 backend pid: 23055 statement: B message
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387:
pool_send_and_wait: Error or notice message from backend: : DB node id: 0
backend pid: 23055 statement:
Mar 11 15:18:25 utu pgpool:         DELETE FROM process_id
Mar 11 15:18:25 utu pgpool:         WHERE process_name = $1
Mar 11 15:18:25 utu pgpool:         AND process_host = $2 message: unnamed
prepared statement does not exist
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387: DB node
id: 0 backend pid: 23055 statement: COMMIT
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387: DB node
id: 0 backend pid: 23055 statement: Parse:
Mar 11 15:18:25 utu pgpool:             INSERT INTO process_id
Mar 11 15:18:25 utu pgpool:             (process_name, process_id,
process_host, process_create, process_change)
Mar 11 15:18:25 utu pgpool:             VALUES ($1, $2, $3, $4, $5)
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387: DB node
id: 0 backend pid: 23055 statement: BEGIN
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387: DB node
id: 0 backend pid: 23055 statement: B message
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387:
pool_send_and_wait: Error or notice message from backend: : DB node id: 0
backend pid: 23055 statement:
Mar 11 15:18:25 utu pgpool:             INSERT INTO process_id
Mar 11 15:18:25 utu pgpool:             (process_name, process_id,
process_host, process_create, process_change)
Mar 11 15:18:25 utu pgpool:             VALUES ($1, $2, $3, $4, $5)
message: unnamed prepared statement does not exist
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387: DB node
id: 0 backend pid: 23055 statement: COMMIT
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387: DB node
id: 0 backend pid: 23055 statement: DEALLOCATE dbdpg_p29023_1
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387: DB node
id: 0 backend pid: 23055 statement: Parse:
Mar 11 15:18:25 utu pgpool:             SELECT process_name, process_id,
process_host, process_create, process_change
Mar 11 15:18:25 utu pgpool:             FROM process_id
Mar 11 15:18:25 utu pgpool:             WHERE process_name = $1 LIMIT 1
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387: DB node
id: 0 backend pid: 23055 statement: B message
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387: DB node
id: 0 backend pid: 23055 statement: D message
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387: DB node
id: 0 backend pid: 23055 statement: Execute:
Mar 11 15:18:25 utu pgpool:             SELECT process_name, process_id,
process_host, process_create, process_change
Mar 11 15:18:25 utu pgpool:             FROM process_id
Mar 11 15:18:25 utu pgpool:             WHERE process_name = $1 LIMIT 1
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387: DB node
id: 0 backend pid: 23055 statement: DEALLOCATE dbdpg_p29023_2
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387: DB node
id: 0 backend pid: 23055 statement: Parse:
Mar 11 15:18:25 utu pgpool:             SELECT process_name, process_id,
process_host, process_create, process_change
Mar 11 15:18:25 utu pgpool:             FROM process_id
Mar 11 15:18:25 utu pgpool:             WHERE process_name = $1 LIMIT 1
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387: DB node
id: 0 backend pid: 23055 statement: B message
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387: DB node
id: 0 backend pid: 23055 statement: D message
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387: DB node
id: 0 backend pid: 23055 statement: Execute:
Mar 11 15:18:25 utu pgpool:             SELECT process_name, process_id,
process_host, process_create, process_change
Mar 11 15:18:25 utu pgpool:             FROM process_id
Mar 11 15:18:25 utu pgpool:             WHERE process_name = $1 LIMIT 1
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22380: DB node
id: 0 backend pid: 23056 statement: BEGIN
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22380: DB node
id: 1 backend pid: 23589 statement: BEGIN
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22380: DB node
id: 0 backend pid: 23056 statement: SET standard_conforming_strings TO ON
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22380: DB node
id: 1 backend pid: 23589 statement: SET standard_conforming_strings TO ON
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22380: DB node
id: 1 backend pid: 23589 statement: COMMIT
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22380: DB node
id: 0 backend pid: 23056 statement: COMMIT
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387: DB node
id: 0 backend pid: 23055 statement:  DISCARD ALL
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22380: DB node
id: 0 backend pid: 23056 statement:  DISCARD ALL
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22387: DB node
id: 1 backend pid: 23588 statement:  DISCARD ALL
Mar 11 15:18:25 utu pgpool: 2014-03-11 15:18:25 LOG:   pid 22380: DB node
id: 1 backend pid: 23589 statement:  DISCARD ALL
Mar 11 15:18:58 utu pgpool: 2014-03-11 15:18:58 LOG:   pid 22383: DB node
id: 0 backend pid: 23067 statement: Parse: SET extra_float_digits = 3
Mar 11 15:18:58 utu pgpool: 2014-03-11 15:18:58 LOG:   pid 22383: DB node
id: 1 backend pid: 23598 statement: Parse: SET extra_float_digits = 3
Mar 11 15:18:58 utu pgpool: 2014-03-11 15:18:58 LOG:   pid 22383: DB node
id: 0 backend pid: 23067 statement: B message
Mar 11 15:18:58 utu pgpool: 2014-03-11 15:18:58 LOG:   pid 22383: DB node
id: 1 backend pid: 23598 statement: B message
Mar 11 15:18:58 utu pgpool: 2014-03-11 15:18:58 LOG:   pid 22383: DB node
id: 0 backend pid: 23067 statement: Execute: SET extra_float_digits = 3
Mar 11 15:18:58 utu pgpool: 2014-03-11 15:18:58 LOG:   pid 22383: DB node
id: 1 backend pid: 23598 statement: Execute: SET extra_float_digits = 3
Mar 11 15:18:58 utu pgpool: 2014-03-11 15:18:58 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: BEGIN
Mar 11 15:18:58 utu pgpool: 2014-03-11 15:18:58 LOG:   pid 22376: DB node
id: 1 backend pid: 23600 statement: BEGIN
Mar 11 15:18:58 utu pgpool: 2014-03-11 15:18:58 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: SET standard_conforming_strings TO ON
Mar 11 15:18:58 utu pgpool: 2014-03-11 15:18:58 LOG:   pid 22376: DB node
id: 1 backend pid: 23600 statement: SET standard_conforming_strings TO ON
Mar 11 15:18:58 utu pgpool: 2014-03-11 15:18:58 LOG:   pid 22376: DB node
id: 1 backend pid: 23600 statement: COMMIT
Mar 11 15:18:58 utu pgpool: 2014-03-11 15:18:58 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: COMMIT
Mar 11 15:19:04 utu pgpool: 2014-03-11 15:19:04 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: SELECT 'DBD::Pg ping test'
Mar 11 15:19:04 utu pgpool: 2014-03-11 15:19:04 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: BEGIN
Mar 11 15:19:04 utu pgpool: 2014-03-11 15:19:04 LOG:   pid 22376: DB node
id: 1 backend pid: 23600 statement: BEGIN
Mar 11 15:19:04 utu pgpool: 2014-03-11 15:19:04 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: SET standard_conforming_strings TO ON
Mar 11 15:19:04 utu pgpool: 2014-03-11 15:19:04 LOG:   pid 22376: DB node
id: 1 backend pid: 23600 statement: SET standard_conforming_strings TO ON
Mar 11 15:19:04 utu pgpool: 2014-03-11 15:19:04 LOG:   pid 22376: DB node
id: 1 backend pid: 23600 statement: COMMIT
Mar 11 15:19:04 utu pgpool: 2014-03-11 15:19:04 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: COMMIT
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: SELECT count(*) from (SELECT
has_function_privilege('otrs', 'pgpool_regclass(cstring)', 'execute') WHERE
EXISTS(SELECT * FROM pg_catalog.pg_proc AS p WHERE p.proname =
'pgpool_regclass')) AS s
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: SELECT count(*) FROM pg_class AS c,
pg_namespace AS n WHERE c.oid = pgpool_regclass('pg_namespace') AND
c.relnamespace = n.oid AND n.nspname = 'pg_catalog'
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: SELECT count(*) FROM pg_class AS c,
pg_namespace AS n WHERE c.oid = pgpool_regclass('users') AND c.relnamespace
= n.oid AND n.nspname = 'pg_catalog'
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: SELECT count(*) FROM
pg_catalog.pg_class AS c, pg_attribute AS a WHERE c.relname = 'pg_class'
AND a.attrelid = c.oid AND a.attname = 'relistemp'
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: SELECT count(*) FROM pg_class AS c,
pg_namespace AS n WHERE c.relname = 'users' AND c.relnamespace = n.oid AND
n.nspname ~ '^pg_temp_'
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: SELECT count(*) FROM
pg_catalog.pg_class AS c, pg_catalog.pg_attribute AS a WHERE c.relname =
'pg_class' AND a.attrelid = c.oid AND a.attname = 'relpersistence'
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: SELECT count(*) FROM
pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass('users') AND
c.relpersistence = 'u'
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: Parse: SELECT id FROM users  WHERE
LOWER(login) = $1 LIMIT 1
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: B message
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: D message
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: Execute: SELECT id FROM users  WHERE
LOWER(login) = $1 LIMIT 1
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: DEALLOCATE dbdpg_p29066_1
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: Parse: SELECT id, login,  title,
first_name, last_name, pw, valid_id,  create_time, change_time FROM users
WHERE  id = $1 LIMIT 1
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: B message
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: D message
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: Execute: SELECT id, login,  title,
first_name, last_name, pw, valid_id,  create_time, change_time FROM users
WHERE  id = $1 LIMIT 1
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: DEALLOCATE dbdpg_p29066_2
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: SELECT count(*) FROM pg_class AS c,
pg_namespace AS n WHERE c.oid = pgpool_regclass('user_preferences') AND
c.relnamespace = n.oid AND n.nspname = 'pg_catalog'
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: SELECT count(*) FROM pg_class AS c,
pg_namespace AS n WHERE c.relname = 'user_preferences' AND c.relnamespace =
n.oid AND n.nspname ~ '^pg_temp_'
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: SELECT count(*) FROM
pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass('user_preferences')
AND c.relpersistence = 'u'
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: Parse:
Mar 11 15:19:05 utu pgpool:             SELECT preferences_key,
preferences_value
Mar 11 15:19:05 utu pgpool:             FROM user_preferences
Mar 11 15:19:05 utu pgpool:             WHERE user_id = $1
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: B message
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: D message
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: Execute:
Mar 11 15:19:05 utu pgpool:             SELECT preferences_key,
preferences_value
Mar 11 15:19:05 utu pgpool:             FROM user_preferences
Mar 11 15:19:05 utu pgpool:             WHERE user_id = $1
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: DEALLOCATE dbdpg_p29066_3
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: Parse: SELECT login FROM users  WHERE
id = $1 LIMIT 1
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: B message
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: D message
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: Execute: SELECT login FROM users  WHERE
id = $1 LIMIT 1
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: Parse:
Mar 11 15:19:05 utu pgpool:             DELETE FROM user_preferences
Mar 11 15:19:05 utu pgpool:             WHERE user_id = $1
Mar 11 15:19:05 utu pgpool:                 AND preferences_key = $2
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: BEGIN
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: B message
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376:
pool_send_and_wait: Error or notice message from backend: : DB node id: 0
backend pid: 23069 statement:
Mar 11 15:19:05 utu pgpool:             DELETE FROM user_preferences
Mar 11 15:19:05 utu pgpool:             WHERE user_id = $1
Mar 11 15:19:05 utu pgpool:                 AND preferences_key = $2
message: unnamed prepared statement does not exist
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: COMMIT
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: DEALLOCATE dbdpg_p29066_4
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: Parse: SELECT id, login,  title,
first_name, last_name, pw, valid_id,  create_time, change_time FROM users
WHERE  LOWER(login) = $1 LIMIT 1
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: B message
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: D message
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: Execute: SELECT id, login,  title,
first_name, last_name, pw, valid_id,  create_time, change_time FROM users
WHERE  LOWER(login) = $1 LIMIT 1
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: DEALLOCATE dbdpg_p29066_5
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: Parse:
Mar 11 15:19:05 utu pgpool:             SELECT preferences_key,
preferences_value
Mar 11 15:19:05 utu pgpool:             FROM user_preferences
Mar 11 15:19:05 utu pgpool:             WHERE user_id = $1
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: B message
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: D message
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: Execute:
Mar 11 15:19:05 utu pgpool:             SELECT preferences_key,
preferences_value
Mar 11 15:19:05 utu pgpool:             FROM user_preferences
Mar 11 15:19:05 utu pgpool:             WHERE user_id = $1
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: DEALLOCATE dbdpg_p29066_6
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: SELECT count(*) FROM pg_class AS c,
pg_namespace AS n WHERE c.oid = pgpool_regclass('groups') AND
c.relnamespace = n.oid AND n.nspname = 'pg_catalog'
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: SELECT count(*) FROM pg_class AS c,
pg_namespace AS n WHERE c.oid = pgpool_regclass('group_user') AND
c.relnamespace = n.oid AND n.nspname = 'pg_catalog'
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: SELECT count(*) FROM pg_class AS c,
pg_namespace AS n WHERE c.relname = 'groups' AND c.relnamespace = n.oid AND
n.nspname ~ '^pg_temp_'
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: SELECT count(*) FROM pg_class AS c,
pg_namespace AS n WHERE c.relname = 'group_user' AND c.relnamespace = n.oid
AND n.nspname ~ '^pg_temp_'
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: SELECT count(*) FROM
pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass('groups') AND
c.relpersistence = 'u'
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: SELECT count(*) FROM
pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass('group_user') AND
c.relpersistence = 'u'
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: Parse: SELECT g.id, g.name,
gu.permission_key, gu.permission_value, gu.user_id
Mar 11 15:19:05 utu pgpool:         FROM groups g, group_user gu, users u
Mar 11 15:19:05 utu pgpool:         WHERE g.valid_id IN (1)
Mar 11 15:19:05 utu pgpool:             AND g.id = gu.group_id
Mar 11 15:19:05 utu pgpool:             AND gu.permission_value = 1
Mar 11 15:19:05 utu pgpool:             AND gu.permission_key IN (
'rw','rw' )
Mar 11 15:19:05 utu pgpool:             AND gu.user_id = u.id
Mar 11 15:19:05 utu pgpool:             AND u.valid_id IN ( 1 )
Mar 11 15:19:05 utu pgpool:             AND gu.user_id = 6
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: B message
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: D message
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: Execute: SELECT g.id, g.name,
gu.permission_key, gu.permission_value, gu.user_id
Mar 11 15:19:05 utu pgpool:         FROM groups g, group_user gu, users u
Mar 11 15:19:05 utu pgpool:         WHERE g.valid_id IN (1)
Mar 11 15:19:05 utu pgpool:             AND g.id = gu.group_id
Mar 11 15:19:05 utu pgpool:             AND gu.permission_value = 1
Mar 11 15:19:05 utu pgpool:             AND gu.permission_key IN (
'rw','rw' )
Mar 11 15:19:05 utu pgpool:             AND gu.user_id = u.id
Mar 11 15:19:05 utu pgpool:             AND u.valid_id IN ( 1 )
Mar 11 15:19:05 utu pgpool:             AND gu.user_id = 6
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: DEALLOCATE dbdpg_p29066_7
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: SELECT count(*) FROM pg_class AS c,
pg_namespace AS n WHERE c.oid = pgpool_regclass('sessions') AND
c.relnamespace = n.oid AND n.nspname = 'pg_catalog'
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: SELECT count(*) FROM pg_class AS c,
pg_namespace AS n WHERE c.relname = 'sessions' AND c.relnamespace = n.oid
AND n.nspname ~ '^pg_temp_'
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: SELECT count(*) FROM
pg_catalog.pg_class AS c WHERE c.oid = pgpool_regclass('sessions') AND
c.relpersistence = 'u'
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: Parse:
Mar 11 15:19:05 utu pgpool:                 SELECT session_id, data_key,
data_value
Mar 11 15:19:05 utu pgpool:                 FROM sessions
Mar 11 15:19:05 utu pgpool:                 WHERE data_key = 'UserType'
Mar 11 15:19:05 utu pgpool:                     OR data_key =
'UserLastRequest'
Mar 11 15:19:05 utu pgpool:                 ORDER BY id ASC
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: B message
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: D message
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: Execute:
Mar 11 15:19:05 utu pgpool:                 SELECT session_id, data_key,
data_value
Mar 11 15:19:05 utu pgpool:                 FROM sessions
Mar 11 15:19:05 utu pgpool:                 WHERE data_key = 'UserType'
Mar 11 15:19:05 utu pgpool:                     OR data_key =
'UserLastRequest'
Mar 11 15:19:05 utu pgpool:                 ORDER BY id ASC
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: Parse:
Mar 11 15:19:05 utu pgpool:             DELETE FROM sessions
Mar 11 15:19:05 utu pgpool:             WHERE session_id = $1
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: BEGIN
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: B message
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376:
pool_send_and_wait: Error or notice message from backend: : DB node id: 0
backend pid: 23069 statement:
Mar 11 15:19:05 utu pgpool:             DELETE FROM sessions
Mar 11 15:19:05 utu pgpool:             WHERE session_id = $1 message:
unnamed prepared statement does not exist
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: COMMIT
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: Parse: INSERT INTO sessions
(session_id, data_key, data_value, serialized) VALUES
($1,$2,$3,$4),($5,$6,$7,$8),($9,$10,$11,$12),($13,$14,$15,$16),($17,$18,$19,$20),($21,$22,$23,$24),($25,$26,$27,$28),($29,$30,$31,$32),($33,$34,$35,$36),($37,$38,$39,$40),($41,$42,$43,$44),($45,$46,$47,$48),($49,$50,$51,$52),($53,$54,$55,$56),($57,$58,$59,$60),($61,$62,$63,$64),($65,$66,$67,$68),($69,$70,$71,$72),($73,$74,$75,$76),($77,$78,$79,$80),($81,$82,$83,$84),($85,$86,$87,$88),($89,$90,$91,$92),($93,$94,$95,$96),($97,$98,$99,$100),($101,$102,$103,$104),($105,$106,$107,$108),($109,$110,$111,$112),($113,$114,$115,$116),($117,$118,$119,$120),($121,$122,$123,$124),($125,$126,$127,$128),($129,$130,$131,$132),($133,$134,$135,$136),($137,$138,$139,$140),($141,$142,$143,$144),($145,$146,$147,$148),($149,$150,$151,$152),($153,$154,$155,$156),($157,$158,$159,$160),($161,$162,$163,$164),($165,$166,$167,$168),($169,$170,$171,$172),($173,$174,$175,$176)
Mar 11 15:19:05 utu pgpool:
,($177,$178,$179,$180),($181,$182,$183,$184),($185,$186,$187,$188),($189,$190,$191
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: BEGIN
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: B message
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376:
pool_send_and_wait: Error or notice message from backend: : DB node id: 0
backend pid: 23069 statement: INSERT INTO sessions (session_id, data_key,
data_value, serialized) VALUES
($1,$2,$3,$4),($5,$6,$7,$8),($9,$10,$11,$12),($13,$14,$15,$16),($17,$18,$19,$20),($21,$22,$23,$24),($25,$26,$27,$28),($29,$30,$31,$32),($33,$34,$35,$36),($37,$38,$39,$40),($41,$42,$43,$44),($45,$46,$47,$48),($49,$50,$51,$52),($53,$54,$55,$56),($57,$58,$59,$60),($61,$62,$63,$64),($65,$66,$67,$68),($69,$70,$71,$72),($73,$74,$75,$76),($77,$78,$79,$80),($81,$82,$83,$84),($85,$86,$87,$88),($89,$90,$91,$92),($93,$94,$95,$96),($97,$98,$99,$100),($101,$102,$103,$104),($105,$106,$107,$108),($109,$110,$111,$112),($113,$114,$115,$116),($117,$118,$119,$120),($121,$122,$123,$124),($125,$126,$127,$128),($129,$130,$131,$132),($133,$134,$135,$136),($137,$138,$139,$140),($141,$142,$143,$144),($145,$146,$147,$148),($149,$150,$151,$152),($153,$154,$155,$156),($157,$158,$159,$160),($161,$162,$163,$164),($165,$166,$
Mar 11 15:19:05 utu pgpool:
167,$168),($169,$170,$171,$172),($173,$174,$175,$176),($177,$178,$179,$180),($181,$182,$183,$184),($185,$186,$187,$188),($189,$190,$191,$192),($193,$194,$195,$196),($197,$198,$199,$200),($201,$202,$203,$204),($205,$206,$207,$208),($209,$210,$211,$212),($213,$214,$215,$216),($217,$218,$219,$220),($221,$222,$223,$224),($225,$226,$227,$228),($229,$230,$231,$232),($233,$234,$235,$236),($237,$238,$239,$240),($241,$242,$243,$244),($245,$246,$247,$248),($249,$250,$251,$252),($253,$254,$255,$256),($257,$258,$259,$260),($261,$262,$263,$264),($265,$266,$267,$268),($269,$270,$271,$272),($273,$274,$275,$276),($277,$278,$279,$280),($281,$282,$283,$284),($285,$286,$287,$288),($289,$290,$291,$292),($293,$294,$295,$296),($297,$298,$299,$300),($301,$302,$303,$304),($305,$306,$307,$308),($309,$310,$311,$312),($313,$314,$315,$316),($317,$318,$319,$320),($321,$322,$323,$324),($325,$326,$327,$328),($329,$330,$331,$332),($333,$334,$335,$336),($337,$338,$339,$340),($341,$342,$343,$344),($345,$346,$347,$348),($349,$350,$351,$352),(
Mar 11 15:19:05 utu pgpool:
$353,$354,$355,$356),($357,$358,$359,$360),($361,$362,$363,$364),($365,$366,$367,$368),($369,$370,$371,$372),($373,$374,$375,$376),($377,$378,$379,$380),($381,$382,$383,$384),($385,$386,$387,$388),($389,$390,$391,$392),($393,$394,$395,$396),($397,$398,$399,$400),($401,$402,$403,$404),($405,$406,$407,$408),($409,$410,$411,$412)
message: unnamed prepared statement does not exist
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: COMMIT
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: DEALLOCATE dbdpg_p29066_8
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: SELECT 'DBD::Pg ping test'
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: BEGIN
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 1 backend pid: 23600 statement: BEGIN
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: SET standard_conforming_strings TO ON
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 1 backend pid: 23600 statement: SET standard_conforming_strings TO ON
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 1 backend pid: 23600 statement: COMMIT
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: COMMIT
Mar 11 15:19:05 utu pgpool: 2014-03-11 15:19:05 LOG:   pid 22376: DB node
id: 0 backend pid: 23069 statement: Parse:


2014-03-10 9:12 GMT+01:00 Tatsuo Ishii <ishii at postgresql.org>:

> I'm not familiar with OTRS and need to know more detailed info when
> the errors occur.  Can you please provide full log from the particular
> session started with log_per_node_statement enabled?
>
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140311/3f93c168/attachment-0001.html>


More information about the pgpool-general mailing list