[pgsql-jp: 33543] Re: pgpool 2.0.2 報告

[nishio ＠ aileck.co.jp]

西尾です。

>
>えーと，まずこれが再現しません．ですので，とりあえずpgpool -d -nで起動
>し，このエラーが起きた辺りのデバッグ出力を見せてもらえませんか？
>--
>Tatsuo Ishii
>

\d+(ちなみに\dでも同様)によるデバッグモードでのメッセージは以下のとおりです。

DEBUG: pid 484: read kind from frontend Q(51)
DEBUG: pid 484: pool_read_string: read all from pending data. po:0 len:0
DEBUG: pid 484: Query: SELECT c.oid,
  n.nspname,
  c.relname
FROM pg_catalog.pg_class c
     LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE pg_catalog.pg_table_is_visible(c.oid)
      AND c.relname ~ '^user_list$'
ORDER BY 2, 3;
DEBUG: pid 484: read kind from backend P
DEBUG: pid 484: pool_read_string: read all from pending data. po:6 len:97
DEBUG: pid 484: pool_read_string: read all from pending data. po:6 len:97
DEBUG: pid 484: read kind from backend pending data T len: 96 po: 7
DEBUG: pid 484: pool_read_string: read all from pending data. po:13 len:90
DEBUG: pid 484: pool_read_string: read all from pending data. po:13 len:90
DEBUG: pid 484: RowDescription: field size:4
DEBUG: pid 484: pool_read_string: read all from pending data. po:31 len:72
DEBUG: pid 484: pool_read_string: read all from pending data. po:31 len:72
DEBUG: pid 484: RowDescription: field size:64
DEBUG: pid 484: pool_read_string: read all from pending data. po:49 len:54
DEBUG: pid 484: pool_read_string: read all from pending data. po:49 len:54
DEBUG: pid 484: RowDescription: field size:64
DEBUG: pid 484: read kind from backend pending data D len: 43 po: 60
DEBUG: pid 484: AsciiRow: len:6 data: 35893
DEBUG: pid 484: AsciiRow: len:6 data: publi
DEBUG: pid 484: AsciiRow: len:9 data: user_lis
DEBUG: pid 484: read kind from backend pending data C len: 8 po: 95
DEBUG: pid 484: pool_read_string: read all from pending data. po:102 len:1
DEBUG: pid 484: pool_read_string: read all from pending data. po:102 len:1
DEBUG: pid 484: Complete Command Response: string: "SELECT"
DEBUG: pid 484: read kind from backend pending data Z len: 0 po: 0
DEBUG: pid 484: read kind from frontend Q(51)
DEBUG: pid 484: pool_read_string: read all from pending data. po:0 len:0
DEBUG: pid 484: Query: SELECT relhasindex, relkind, relchecks, reltriggers, relhasrules
FROM pg_catalog.pg_class WHERE oid = '358932'
DEBUG: pid 484: read kind from backend P
DEBUG: pid 484: pool_read_string: read all from pending data. po:6 len:143
DEBUG: pid 484: pool_read_string: read all from pending data. po:6 len:116
DEBUG: pid 484: read kind from backend pending data T len: 142 po: 7
DEBUG: pid 484: pool_read_string: read all from pending data. po:21 len:128
DEBUG: pid 484: pool_read_string: read all from pending data. po:21 len:101
DEBUG: pid 484: RowDescription: field size:1
DEBUG: pid 484: pool_read_string: read all from pending data. po:39 len:110
DEBUG: pid 484: pool_read_string: read all from pending data. po:39 len:83
DEBUG: pid 484: RowDescription: field size:1
DEBUG: pid 484: pool_read_string: read all from pending data. po:59 len:90
DEBUG: pid 484: pool_read_string: read all from pending data. po:59 len:63
DEBUG: pid 484: RowDescription: field size:2
DEBUG: pid 484: pool_read_string: read all from pending data. po:81 len:68
DEBUG: pid 484: pool_read_string: read all from pending data. po:81 len:41
DEBUG: pid 484: RowDescription: field size:2
DEBUG: pid 484: pool_read_string: read all from pending data. po:103 len:46
DEBUG: pid 484: pool_read_string: read all from pending data. po:103 len:19
DEBUG: pid 484: RowDescription: field size:1
ERROR: pid 484: pool_process_query: kind does not match between backends master(D) secondary(C)
LOG: pid 484: do_child: exits with status 1 due to error
DEBUG: pid 467: I am 467 accept fd 6
DEBUG: pid 467: Protocol Major: 2 Minor: 0 database: test02 user: postgres
DEBUG: pid 467: connecting postmaster Unix domain socket: /tmp/.s.PGSQL.5432
DEBUG: pid 467: connected to postmaster Unix domain socket: /tmp/.s.PGSQL.5432 fd: 7
DEBUG: pid 467: read kind from backend pending data Z len: 0 po: 0
DEBUG: pid 467: read kind from frontend Q(51)
DEBUG: pid 467: pool_read_string: read all from pending data. po:0 len:0
DEBUG: pid 467: Query: begin; select getdatabaseencoding(); commit
DEBUG: pid 467: read kind from backend C
DEBUG: pid 467: pool_read_string: read all from pending data. po:6 len:69
DEBUG: pid 467: pool_read_string: read all from pending data. po:6 len:69
DEBUG: pid 467: Complete Command Response: string: "BEGIN"
DEBUG: pid 467: read kind from backend pending data P len: 68 po: 7
DEBUG: pid 467: pool_read_string: read all from pending data. po:13 len:62
DEBUG: pid 467: pool_read_string: read all from pending data. po:13 len:62
DEBUG: pid 467: read kind from backend pending data T len: 61 po: 14
DEBUG: pid 467: pool_read_string: read all from pending data. po:36 len:39
DEBUG: pid 467: pool_read_string: read all from pending data. po:36 len:39
DEBUG: pid 467: RowDescription: field size:64
DEBUG: pid 467: read kind from backend pending data D len: 28 po: 47
DEBUG: pid 467: AsciiRow: len:6 data: EUC_J
DEBUG: pid 467: read kind from backend pending data C len: 16 po: 59
DEBUG: pid 467: pool_read_string: read all from pending data. po:66 len:9
DEBUG: pid 467: pool_read_string: read all from pending data. po:66 len:9
DEBUG: pid 467: Complete Command Response: string: "SELECT"
DEBUG: pid 467: read kind from backend pending data C len: 8 po: 67
DEBUG: pid 467: pool_read_string: read all from pending data. po:74 len:1
DEBUG: pid 467: pool_read_string: read all from pending data. po:74 len:1
DEBUG: pid 467: Complete Command Response: string: "COMMIT"
DEBUG: pid 467: read kind from backend pending data Z len: 0 po: 0

しかし、こちらの環境でエラーが出るのは、コンパイル等がまずいのかな。
ついでに6.4へのバージョンアップを検討中です。