[pgsql-jp: 34159] Re: pgpoolのリードエラーについて

[Naoki Kaneto]

お世話になります、金戸です。

> > replication_strict = 両パターンでテスト
> > replication_timeout = *３パターンでテスト
> > load_balance_mode = *true false ともに変化無し
> > weight_master=1-0
> > weight_secondary=0-1 weightがそれぞれ1-0,0-1も変化無し
> > replication_stop_on_mismatch = false
> 
> replication_strict = trueかつ
> replication_timeout = 0 だとどうなるでしょうか？
> 
無反応になります。

> それから，
> 
> > ERROR: pid 3254: pool_check_fd: data is not ready tp->tv_sec 0
> > tp->tp_usec 0
> 
> このメッセージが出たときのタイミングを教えてください．要は，tp->tv_sec
> 0かつtp->tp_usec 0になるのはおかしいので，どういうときにこうなるのか知
> りたいのです．
> 

ログはPerlの$result->execute();ですが、PgAdminのデータ表示やSQLコマンド
の実行
等で発生します。

DEBUG: pid 22201: Protocol Major: 3 Minor: 0 database: hoge user: kane
DEBUG: pid 22201: name: client_encoding value: EUC_JP
DEBUG: pid 22201: name: DateStyle value: ISO, MDY
DEBUG: pid 22201: name: is_superuser value: off
DEBUG: pid 22201: name: server_version value: 7.4.3
DEBUG: pid 22201: name: session_authorization value: kane
DEBUG: pid 22201: read kind from backend pending data Z len: 5 po: 154
DEBUG: pid 22201: ReadyForQuery: message length: 5
DEBUG: pid 22201: ReadyForQuery: transaction state: I
DEBUG: pid 22201: read kind from frontend Q(51)
DEBUG: pid 22201: Query: SELECT version()
DEBUG: pid 22201: read kind from backend T
DEBUG: pid 22201: pool_process_query: waiting for secondary for data
ready
DEBUG: pid 22201: read kind from backend pending data D len: 87 po: 33
DEBUG: pid 22201: read kind from backend pending data C len: 17 po: 103
DEBUG: pid 22201: read kind from backend pending data Z len: 5 po: 115
DEBUG: pid 22201: ReadyForQuery: message length: 5
DEBUG: pid 22201: ReadyForQuery: transaction state: I
DEBUG: pid 22201: read kind from frontend Q(51)
DEBUG: pid 22201: Query:  SELECT * FROM aaa_v WHERE id='13';
DEBUG: pid 22201: read kind from backend T
DEBUG: pid 22201: pool_process_query: waiting for secondary for data
ready
DEBUG: pid 22201: read kind from backend pending data D len: 835 po: 188
DEBUG: pid 22201: read kind from backend pending data D len: 507 po: 516
DEBUG: pid 22201: read kind from backend pending data D len: 179 po: 844
DEBUG: pid 22201: read kind from backend D
DEBUG: pid 22201: pool_process_query: waiting for secondary for data
ready
DEBUG: pid 22201: read kind from backend pending data D len: 695 po: 328
DEBUG: pid 22201: read kind from backend pending data D len: 367 po: 656
DEBUG: pid 22201: read kind from backend pending data D len: 39 po: 984
DEBUG: pid 22201: read kind from backend D
DEBUG: pid 22201: pool_process_query: waiting for secondary for data
ready
DEBUG: pid 22201: read kind from backend pending data D len: 695 po: 328
DEBUG: pid 22201: read kind from backend pending data D len: 367 po: 656
DEBUG: pid 22201: read kind from backend pending data D len: 39 po: 984
DEBUG: pid 22201: read kind from backend D
DEBUG: pid 22201: pool_process_query: waiting for secondary for data
ready
DEBUG: pid 22201: read kind from backend pending data D len: 695 po: 328
DEBUG: pid 22201: read kind from backend pending data D len: 367 po: 656
DEBUG: pid 22201: read kind from backend pending data D len: 39 po: 984
DEBUG: pid 22201: read kind from backend D
DEBUG: pid 22201: pool_process_query: waiting for secondary for data
ready
DEBUG: pid 22201: read kind from backend pending data D len: 695 po: 328
DEBUG: pid 22201: read kind from backend pending data D len: 367 po: 656
DEBUG: pid 22201: read kind from backend pending data D len: 39 po: 984
DEBUG: pid 22201: pool_process_query: waiting for secondary for data
ready
DEBUG: pid 22201: read kind from backend pending data D len: 695 po: 328
DEBUG: pid 22201: read kind from backend pending data D len: 367 po: 656
DEBUG: pid 22201: read kind from backend pending data D len: 39 po: 984
DEBUG: pid 22201: pool_process_query: waiting for secondary for data
ready
DEBUG: pid 22201: read kind from backend pending data D len: 695 po: 328
DEBUG: pid 22201: read kind from backend pending data D len: 367 po: 656
DEBUG: pid 22201: read kind from backend pending data D len: 39 po: 984
DEBUG: pid 22201: pool_process_query: waiting for secondary for data
ready
DEBUG: pid 22201: read kind from backend pending data D len: 695 po: 328
DEBUG: pid 22201: read kind from backend pending data D len: 367 po: 656
DEBUG: pid 22201: read kind from backend pending data D len: 39 po: 984
DEBUG: pid 22201: pool_process_query: waiting for secondary for data
ready
DEBUG: pid 22201: read kind from backend pending data D len: 695 po: 328
DEBUG: pid 22201: read kind from backend pending data D len: 367 po: 656
DEBUG: pid 22201: read kind from backend pending data D len: 39 po: 984
DEBUG: pid 22201: pool_process_query: waiting for secondary for data
ready
DEBUG: pid 22201: read kind from backend pending data D len: 695 po: 328
DEBUG: pid 22201: read kind from backend pending data D len: 367 po: 656
DEBUG: pid 22201: read kind from backend pending data D len: 39 po: 984
DEBUG: pid 22201: pool_process_query: waiting for secondary for data
ready
DEBUG: pid 22201: read kind from backend pending data D len: 695 po: 328
DEBUG: pid 22201: read kind from backend pending data D len: 367 po: 656
DEBUG: pid 22201: read kind from backend pending data D len: 39 po: 984
DEBUG: pid 22201: read kind from backend D
DEBUG: pid 22201: pool_process_query: waiting for secondary for data
ready
DEBUG: pid 22201: read kind from backend pending data D len: 695 po: 328
DEBUG: pid 22201: read kind from backend pending data D len: 367 po: 656
DEBUG: pid 22201: read kind from backend pending data D len: 39 po: 984
DEBUG: pid 22201: read kind from backend D
DEBUG: pid 22201: pool_process_query: waiting for secondary for data
ready
DEBUG: pid 22201: read kind from backend pending data D len: 695 po: 328
DEBUG: pid 22201: read kind from backend pending data D len: 367 po: 656
DEBUG: pid 22201: read kind from backend pending data D len: 39 po: 984
DEBUG: pid 22201: pool_process_query: waiting for secondary for data
ready
DEBUG: pid 22201: read kind from backend pending data D len: 695 po: 328
DEBUG: pid 22201: read kind from backend pending data D len: 367 po: 656
DEBUG: pid 22201: read kind from backend pending data D len: 39 po: 984
DEBUG: pid 22201: pool_process_query: waiting for secondary for data
ready
DEBUG: pid 22201: read kind from backend pending data D len: 695 po: 328
DEBUG: pid 22201: read kind from backend pending data D len: 367 po: 656
DEBUG: pid 22201: read kind from backend pending data D len: 39 po: 984
DEBUG: pid 22201: pool_process_query: waiting for secondary for data
ready
DEBUG: pid 22201: read kind from backend pending data D len: 695 po: 328
DEBUG: pid 22201: read kind from backend pending data D len: 367 po: 656
DEBUG: pid 22201: read kind from backend pending data D len: 39 po: 984
DEBUG: pid 22201: pool_process_query: waiting for secondary for data
ready

replication_strict = true かつ replication_timeout = 0　でここで止まって
います。

replication_timeout=15000だと15秒でpool_check_fd: data is not readyが帰
ってきます。


> > ---pool_check_fd: data is not ready が発生しない率
> 
> 一応確認ですが，100 = 正常，100以外はNGっていう理解で合っていますか?
> --
変な表現ですみません、ご理解の通りです。

よろしくお願いします。