<div dir="ltr"><div><div>Hello,<br><br>Thanks for your answer.<br>A tried it with log_per_node_statement. I'm sending more detailed log.<br><br>Thx,<br>Csaba</div></div><div><div><div><br><br>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<br>
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<br>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<br>
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<br>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<br>
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<br>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<br>
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'<br>
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'<br>
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'<br>
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_'<br>
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'<br>
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'<br>
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: <br>Mar 11 15:18:25 utu pgpool: SELECT process_name, process_id, process_host, process_create, process_change<br>
Mar 11 15:18:25 utu pgpool: FROM process_id<br>Mar 11 15:18:25 utu pgpool: WHERE process_name = $1 LIMIT 1<br>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<br>
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<br>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: <br>
Mar 11 15:18:25 utu pgpool: SELECT process_name, process_id, process_host, process_create, process_change<br>Mar 11 15:18:25 utu pgpool: FROM process_id<br>Mar 11 15:18:25 utu pgpool: WHERE process_name = $1 LIMIT 1<br>
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<br>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<br>
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<br>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<br>
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<br>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<br>
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<br>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<br>
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<br>
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'<br>
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'<br>
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'<br>
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_'<br>
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'<br>
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'<br>
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: <br>Mar 11 15:18:25 utu pgpool: SELECT process_name, process_id, process_host, process_create, process_change<br>
Mar 11 15:18:25 utu pgpool: FROM process_id<br>Mar 11 15:18:25 utu pgpool: WHERE process_name = $1 LIMIT 1<br>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<br>
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<br>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: <br>
Mar 11 15:18:25 utu pgpool: SELECT process_name, process_id, process_host, process_create, process_change<br>Mar 11 15:18:25 utu pgpool: FROM process_id<br>Mar 11 15:18:25 utu pgpool: WHERE process_name = $1 LIMIT 1<br>
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: <br>Mar 11 15:18:25 utu pgpool: DELETE FROM process_id<br>Mar 11 15:18:25 utu pgpool: WHERE process_name = $1<br>
Mar 11 15:18:25 utu pgpool: AND process_host = $2<br>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<br>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<br>
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: <br>Mar 11 15:18:25 utu pgpool: DELETE FROM process_id<br>
Mar 11 15:18:25 utu pgpool: WHERE process_name = $1<br>Mar 11 15:18:25 utu pgpool: AND process_host = $2 message: unnamed prepared statement does not exist<br>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<br>
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: <br>Mar 11 15:18:25 utu pgpool: INSERT INTO process_id<br>Mar 11 15:18:25 utu pgpool: (process_name, process_id, process_host, process_create, process_change)<br>
Mar 11 15:18:25 utu pgpool: VALUES ($1, $2, $3, $4, $5)<br>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<br>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<br>
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: <br>Mar 11 15:18:25 utu pgpool: INSERT INTO process_id<br>
Mar 11 15:18:25 utu pgpool: (process_name, process_id, process_host, process_create, process_change)<br>Mar 11 15:18:25 utu pgpool: VALUES ($1, $2, $3, $4, $5) message: unnamed prepared statement does not exist<br>
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<br>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<br>
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: <br>Mar 11 15:18:25 utu pgpool: SELECT process_name, process_id, process_host, process_create, process_change<br>
Mar 11 15:18:25 utu pgpool: FROM process_id<br>Mar 11 15:18:25 utu pgpool: WHERE process_name = $1 LIMIT 1<br>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<br>
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<br>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: <br>
Mar 11 15:18:25 utu pgpool: SELECT process_name, process_id, process_host, process_create, process_change<br>Mar 11 15:18:25 utu pgpool: FROM process_id<br>Mar 11 15:18:25 utu pgpool: WHERE process_name = $1 LIMIT 1<br>
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<br>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: <br>
Mar 11 15:18:25 utu pgpool: SELECT process_name, process_id, process_host, process_create, process_change<br>Mar 11 15:18:25 utu pgpool: FROM process_id<br>Mar 11 15:18:25 utu pgpool: WHERE process_name = $1 LIMIT 1<br>
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<br>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<br>
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: <br>Mar 11 15:18:25 utu pgpool: SELECT process_name, process_id, process_host, process_create, process_change<br>
Mar 11 15:18:25 utu pgpool: FROM process_id<br>Mar 11 15:18:25 utu pgpool: WHERE process_name = $1 LIMIT 1<br>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<br>
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<br>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<br>
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<br>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<br>
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<br>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<br>
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<br>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<br>
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<br>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<br>
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<br>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<br>
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<br>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<br>
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<br>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<br>
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<br>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<br>
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<br>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<br>
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<br>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'<br>
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<br>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<br>
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<br>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<br>
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<br>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<br>
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<br>
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'<br>
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'<br>
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'<br>
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_'<br>
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'<br>
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'<br>
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<br>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<br>
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<br>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<br>
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<br>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<br>
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<br>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<br>
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<br>
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<br>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'<br>
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_'<br>
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'<br>
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: <br>Mar 11 15:19:05 utu pgpool: SELECT preferences_key, preferences_value<br>Mar 11 15:19:05 utu pgpool: FROM user_preferences<br>
Mar 11 15:19:05 utu pgpool: WHERE user_id = $1<br>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<br>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<br>
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: <br>Mar 11 15:19:05 utu pgpool: SELECT preferences_key, preferences_value<br>Mar 11 15:19:05 utu pgpool: FROM user_preferences<br>
Mar 11 15:19:05 utu pgpool: WHERE user_id = $1<br>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<br>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<br>
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<br>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<br>
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<br>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: <br>
Mar 11 15:19:05 utu pgpool: DELETE FROM user_preferences<br>Mar 11 15:19:05 utu pgpool: WHERE user_id = $1<br>Mar 11 15:19:05 utu pgpool: AND preferences_key = $2<br>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<br>
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<br>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: <br>
Mar 11 15:19:05 utu pgpool: DELETE FROM user_preferences<br>Mar 11 15:19:05 utu pgpool: WHERE user_id = $1<br>Mar 11 15:19:05 utu pgpool: AND preferences_key = $2 message: unnamed prepared statement does not exist<br>
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<br>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<br>
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<br>
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<br>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<br>
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<br>
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<br>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: <br>
Mar 11 15:19:05 utu pgpool: SELECT preferences_key, preferences_value<br>Mar 11 15:19:05 utu pgpool: FROM user_preferences<br>Mar 11 15:19:05 utu pgpool: WHERE user_id = $1<br>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<br>
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<br>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: <br>
Mar 11 15:19:05 utu pgpool: SELECT preferences_key, preferences_value<br>Mar 11 15:19:05 utu pgpool: FROM user_preferences<br>Mar 11 15:19:05 utu pgpool: WHERE user_id = $1<br>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<br>
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'<br>
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'<br>
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_'<br>
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_'<br>
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'<br>
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'<br>
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 <a href="http://g.id">g.id</a>, <a href="http://g.name">g.name</a>, gu.permission_key, gu.permission_value, gu.user_id<br>
Mar 11 15:19:05 utu pgpool: FROM groups g, group_user gu, users u<br>Mar 11 15:19:05 utu pgpool: WHERE g.valid_id IN (1)<br>Mar 11 15:19:05 utu pgpool: AND <a href="http://g.id">g.id</a> = gu.group_id<br>
Mar 11 15:19:05 utu pgpool: AND gu.permission_value = 1<br>Mar 11 15:19:05 utu pgpool: AND gu.permission_key IN ( 'rw','rw' )<br>Mar 11 15:19:05 utu pgpool: AND gu.user_id = <a href="http://u.id">u.id</a><br>
Mar 11 15:19:05 utu pgpool: AND u.valid_id IN ( 1 )<br>Mar 11 15:19:05 utu pgpool: AND gu.user_id = 6<br>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<br>
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<br>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 <a href="http://g.id">g.id</a>, <a href="http://g.name">g.name</a>, gu.permission_key, gu.permission_value, gu.user_id<br>
Mar 11 15:19:05 utu pgpool: FROM groups g, group_user gu, users u<br>Mar 11 15:19:05 utu pgpool: WHERE g.valid_id IN (1)<br>Mar 11 15:19:05 utu pgpool: AND <a href="http://g.id">g.id</a> = gu.group_id<br>
Mar 11 15:19:05 utu pgpool: AND gu.permission_value = 1<br>Mar 11 15:19:05 utu pgpool: AND gu.permission_key IN ( 'rw','rw' )<br>Mar 11 15:19:05 utu pgpool: AND gu.user_id = <a href="http://u.id">u.id</a><br>
Mar 11 15:19:05 utu pgpool: AND u.valid_id IN ( 1 )<br>Mar 11 15:19:05 utu pgpool: AND gu.user_id = 6<br>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<br>
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'<br>
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_'<br>
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'<br>
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: <br>Mar 11 15:19:05 utu pgpool: SELECT session_id, data_key, data_value<br>Mar 11 15:19:05 utu pgpool: FROM sessions<br>
Mar 11 15:19:05 utu pgpool: WHERE data_key = 'UserType'<br>Mar 11 15:19:05 utu pgpool: OR data_key = 'UserLastRequest'<br>Mar 11 15:19:05 utu pgpool: ORDER BY id ASC<br>
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<br>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<br>
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: <br>Mar 11 15:19:05 utu pgpool: SELECT session_id, data_key, data_value<br>Mar 11 15:19:05 utu pgpool: FROM sessions<br>
Mar 11 15:19:05 utu pgpool: WHERE data_key = 'UserType'<br>Mar 11 15:19:05 utu pgpool: OR data_key = 'UserLastRequest'<br>Mar 11 15:19:05 utu pgpool: ORDER BY id ASC<br>
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: <br>Mar 11 15:19:05 utu pgpool: DELETE FROM sessions<br>Mar 11 15:19:05 utu pgpool: WHERE session_id = $1<br>
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<br>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<br>
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: <br>Mar 11 15:19:05 utu pgpool: DELETE FROM sessions<br>
Mar 11 15:19:05 utu pgpool: WHERE session_id = $1 message: unnamed prepared statement does not exist<br>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<br>
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)<br>
Mar 11 15:19:05 utu pgpool: ,($177,$178,$179,$180),($181,$182,$183,$184),($185,$186,$187,$188),($189,$190,$191<br>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<br>
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<br>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,$<br>
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),(<br>
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<br>
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<br>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<br>
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'<br>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<br>
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<br>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<br>
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<br>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<br>
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<br>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: <br>
</div></div></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">2014-03-10 9:12 GMT+01:00 Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@postgresql.org" target="_blank">ishii@postgresql.org</a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I'm not familiar with OTRS and need to know more detailed info when<br>
the errors occur. Can you please provide full log from the particular<br>
session started with log_per_node_statement enabled?<br>
<br>
Best regards,<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
</blockquote></div><br></div>