[pgsql-jp: 33936] Re: pgpool のエラー(pool_read: EOF encountered)

藤井律男/Ritsuo Fujii ritsuo ＠ mxy.mesh.ne.jp
2004年 8月 26日 (木) 11:21:56 JST 

藤井@岡山です。
石井さん、お世話になります。
少し内容が長いのですが、申し訳ありません。

> >Tatsuo Ishi
> >過負荷状態なのかも知れませんね．pool_process_query.cの1300行目辺りに
> >
> >if (pool_read(frontend, &fkind, 1) < 0)
> >{
> >	pool_error("ProcessFrontendResponse: failed to read
> >kind");
> >		return POOL_END;
> >	}
> >
> >というのがあります．ここで
> >
> >		return POOL_END;
> >を
> >		return POOL_ERROR;
> >
> >にすると，pgpoolの子プロセスが自殺し，代りに新しい子プロセスを作るので，
> >ひょっとしたら問題を回避できるかも知れません．コネクションプールがクリ
> >アされるので，ちょっともったいですが．
> --
> これも、今朝試してみます。

ログの終りを貼り付けています。

DEBUG: pid 8374: read kind from frontend Q(51)
DEBUG: pid 8374: pool_read_string: read all from pending data. po:0 len:0
DEBUG: pid 8374: Query: fetch from tbl_syskanri_key_csr
DEBUG: pid 8374: read kind from backend P
DEBUG: pid 8374: pool_read_string: read all from pending data. po:21 len:706
DEBUG: pid 8374: pool_read_string: read all from pending data. po:21 len:706
ERROR: pid 8371: pool_read: EOF encountered
ERROR: pid 8371: ProcessFrontendResponse: failed to read kind
LOG: pid 8371: do_child: exits with status 1 due to error
ERROR: pid 8370: pool_read: EOF encountered
ERROR: pid 8370: ProcessFrontendResponse: failed to read kind
LOG: pid 8370: do_child: exits with status 1 due to error
ERROR: pid 8369: pool_read: EOF encountered
ERROR: pid 8369: ProcessFrontendResponse: failed to read kind
LOG: pid 8369: do_child: exits with status 1 due to error
ERROR: pid 8368: pool_read: EOF encountered
ERROR: pid 8368: ProcessFrontendResponse: failed to read kind
LOG: pid 8368: do_child: exits with status 1 due to error
ERROR: pid 8360: pool_read: EOF encountered
ERROR: pid 8360: ProcessFrontendResponse: failed to read kind
LOG: pid 8360: do_child: exits with status 1 due to error
ERROR: pid 8358: pool_read: EOF encountered
ERROR: pid 8358: ProcessFrontendResponse: failed to read kind
LOG: pid 8358: do_child: exits with status 1 due to error
ERROR: pid 8357: pool_read: EOF encountered
ERROR: pid 8357: ProcessFrontendResponse: failed to read kind
LOG: pid 8357: do_child: exits with status 1 due to error
ERROR: pid 8356: pool_read: EOF encountered
ERROR: pid 8356: ProcessFrontendResponse: failed to read kind
LOG: pid 8356: do_child: exits with status 1 due to error
DEBUG: pid 8343: child 8373 exits with signal 0
DEBUG: pid 8343: child 8372 exits with signal 0
DEBUG: pid 8343: child 8371 exits with signal 0
DEBUG: pid 8343: child 8370 exits with signal 0
DEBUG: pid 8343: child 8368 exits with signal 0
DEBUG: pid 8343: child 8367 exits with signal 0
DEBUG: pid 8343: child 8366 exits with signal 0
DEBUG: pid 8343: child 8365 exits with signal 0
DEBUG: pid 8343: child 8364 exits with signal 0
DEBUG: pid 8343: child 8363 exits with signal 0
DEBUG: pid 8343: child 8362 exits with signal 0
DEBUG: pid 8343: child 8357 exits with signal 0
DEBUG: pid 8343: child 8356 exits with signal 0
DEBUG: pid 8343: child 8355 exits with signal 0
DEBUG: pid 8343: child 8354 exits with signal 0
DEBUG: pid 8343: child 8353 exits with signal 0
DEBUG: pid 8343: child 8352 exits with signal 0
DEBUG: pid 8343: child 8351 exits with signal 0
DEBUG: pid 8343: child 8350 exits with signal 0
DEBUG: pid 8343: child 8349 exits with signal 0
DEBUG: pid 8343: child 8348 exits with signal 0
DEBUG: pid 8343: child 8347 exits with signal 0
DEBUG: pid 8343: child 8346 exits with signal 0
DEBUG: pid 8565: I am 8565
DEBUG: pid 8566: I am 8566
DEBUG: pid 8567: I am 8567
DEBUG: pid 8568: I am 8568
DEBUG: pid 8569: I am 8569
DEBUG: pid 8570: I am 8570
DEBUG: pid 8571: I am 8571
DEBUG: pid 8572: I am 8572
DEBUG: pid 8573: I am 8573
DEBUG: pid 8574: I am 8574
DEBUG: pid 8575: I am 8575
DEBUG: pid 8576: I am 8576
DEBUG: pid 8577: I am 8577
DEBUG: pid 8578: I am 8578
DEBUG: pid 8579: I am 8579
DEBUG: pid 8580: I am 8580
DEBUG: pid 8581: I am 8581
DEBUG: pid 8582: I am 8582
DEBUG: pid 8583: I am 8583
DEBUG: pid 7322: Query: ABORT
DEBUG: pid 7324: read kind from backend C
DEBUG: pid 8582: I am 8582
DEBUG: pid 8583: I am 8583
DEBUG: pid 8582: I am 8582
DEBUG: pid 8583: I am 8583
DEBUG: pid 8584: I am 8584
DEBUG: pid 8585: I am 8585
DEBUG: pid 8586: I am 8586
DEBUG: pid 8587: I am 8587
ERROR: pid 8374: pool_read: EOF encountered
ERROR: pid 8374: ProcessFrontendResponse: failed to read kind
LOG: pid 8374: do_child: exits with status 1 due to error
ERROR: pid 8361: pool_read: EOF encountered
ERROR: pid 8361: ProcessFrontendResponse: failed to read kind
LOG: pid 8361: do_child: exits with status 1 due to error
DEBUG: pid 8343: child 8374 exits with signal 0
DEBUG: pid 8343: child 8369 exits with signal 0
DEBUG: pid 8343: child 8360 exits with signal 0
DEBUG: pid 8588: I am 8588
DEBUG: pid 8589: I am 8589
DEBUG: pid 8590: I am 8590
DEBUG: pid 8343: child 8358 exits with signal 0
DEBUG: pid 8591: I am 8591
DEBUG: pid 8343: child 8361 exits with signal 0
DEBUG: pid 8592: I am 8592
DEBUG: pid 8343: exit_handler called


> >		return POOL_ERROR;
> >を
> >		return POOL_END; 

元の状態に戻したときの終わりのログ
DEBUG: pid 8374: Query: fetch from tbl_syskanri_key_csr
DEBUG: pid 8374: read kind from backend P
DEBUG: pid 8374: pool_read_string: read all from pending data. po:21 len:706
DEBUG: pid 8374: pool_read_string: read all from pending data. po:21 len:706
ERROR: pid 8371: pool_read: EOF encountered
ERROR: pid 8371: ProcessFrontendResponse: failed to read kind
LOG: pid 8371: do_child: exits with status 1 due to error
ERROR: pid 8370: pool_read: EOF encountered
ERROR: pid 8370: ProcessFrontendResponse: failed to read kind
LOG: pid 8370: do_child: exits with status 1 due to error
ERROR: pid 8369: pool_read: EOF encountered
ERROR: pid 8369: ProcessFrontendResponse: failed to read kind
LOG: pid 8369: do_child: exits with status 1 due to error
ERROR: pid 8368: pool_read: EOF encountered
ERROR: pid 8368: ProcessFrontendResponse: failed to read kind
LOG: pid 8368: do_child: exits with status 1 due to error
ERROR: pid 8360: pool_read: EOF encountered
ERROR: pid 8360: ProcessFrontendResponse: failed to read kind
LOG: pid 8360: do_child: exits with status 1 due to error
ERROR: pid 8358: pool_read: EOF encountered
ERROR: pid 8358: ProcessFrontendResponse: failed to read kind
LOG: pid 8358: do_child: exits with status 1 due to error
ERROR: pid 8357: pool_read: EOF encountered
ERROR: pid 8357: ProcessFrontendResponse: failed to read kind
LOG: pid 8357: do_child: exits with status 1 due to error
ERROR: pid 8356: pool_read: EOF encountered
ERROR: pid 8356: ProcessFrontendResponse: failed to read kind
LOG: pid 8356: do_child: exits with status 1 due to error
DEBUG: pid 8343: child 8373 exits with signal 0
DEBUG: pid 8343: child 8372 exits with signal 0
DEBUG: pid 8343: child 8371 exits with signal 0
DEBUG: pid 8343: child 8370 exits with signal 0
DEBUG: pid 8343: child 8368 exits with signal 0
DEBUG: pid 8343: child 8367 exits with signal 0
DEBUG: pid 8343: child 8366 exits with signal 0
DEBUG: pid 8343: child 8365 exits with signal 0
DEBUG: pid 8343: child 8364 exits with signal 0
DEBUG: pid 8343: child 8363 exits with signal 0
DEBUG: pid 8343: child 8362 exits with signal 0
DEBUG: pid 8343: child 8357 exits with signal 0
DEBUG: pid 8343: child 8356 exits with signal 0
DEBUG: pid 8343: child 8355 exits with signal 0
DEBUG: pid 8343: child 8354 exits with signal 0
DEBUG: pid 8343: child 8353 exits with signal 0
DEBUG: pid 8343: child 8352 exits with signal 0
DEBUG: pid 8343: child 8351 exits with signal 0
DEBUG: pid 8343: child 8350 exits with signal 0
DEBUG: pid 8343: child 8349 exits with signal 0
DEBUG: pid 8343: child 8348 exits with signal 0
DEBUG: pid 8343: child 8347 exits with signal 0
DEBUG: pid 8343: child 8346 exits with signal 0
DEBUG: pid 8565: I am 8565
DEBUG: pid 8566: I am 8566
DEBUG: pid 8567: I am 8567
DEBUG: pid 8568: I am 8568
DEBUG: pid 8569: I am 8569
DEBUG: pid 8570: I am 8570
DEBUG: pid 8571: I am 8571
DEBUG: pid 8572: I am 8572
DEBUG: pid 8573: I am 8573
DEBUG: pid 8574: I am 8574
DEBUG: pid 8575: I am 8575
DEBUG: pid 8576: I am 8576
DEBUG: pid 8577: I am 8577
DEBUG: pid 8578: I am 8578
DEBUG: pid 8579: I am 8579
DEBUG: pid 8580: I am 8580
DEBUG: pid 8581: I am 8581
DEBUG: pid 8582: I am 8582
DEBUG: pid 8583: I am 8583
DEBUG: pid 7322: Query: ABORT
DEBUG: pid 7324: read kind from backend C
DEBUG: pid 8582: I am 8582
DEBUG: pid 8583: I am 8583
DEBUG: pid 8582: I am 8582
DEBUG: pid 8583: I am 8583
DEBUG: pid 7322: Query: ABORT
DEBUG: pid 7324: read kind from backend C
DEBUG: pid 7322: read kind from backend N
DEBUG: pid 7324: pool_read_string: read all from pending data. po:15 len:1
DEBUG: pid 7324: pool_read_string: read all from pending data. po:15 len:1
DEBUG: pid 7324: Complete Command Response: string: "RESET VARIABLE"
DEBUG: pid 7324: read kind from backend pending data Z len: 0 po: 0
DEBUG: pid 7324: pool_connection_pool_timer: called
DEBUG: pid 7322: pool_read_string: read all from pending data. po:47 len:11
DEBUG: pid 7322: pool_read_string: read all from pending data. po:0 len:0
DEBUG: pid 7322: read kind from backend pending data C len: 10 po: 48
DEBUG: pid 7322: pool_read_string: read all from pending data. po:57 len:1
DEBUG: pid 7322: pool_read_string: read all from pending data. po:9 len:1
DEBUG: pid 7322: Complete Command Response: string: "ROLLBACK"
DEBUG: pid 7322: read kind from backend pending data Z len: 0 po: 0
DEBUG: pid 7322: Query: RESET ALL
DEBUG: pid 7322: read kind from backend C
DEBUG: pid 7322: pool_read_string: read all from pending data. po:15 len:1
DEBUG: pid 7322: pool_read_string: read all from pending data. po:15 len:1
DEBUG: pid 7322: Complete Command Response: string: "RESET VARIABLE"
DEBUG: pid 7322: read kind from backend pending data Z len: 0 po: 0
DEBUG: pid 7322: pool_connection_pool_timer: called
DEBUG: pid 7319: exit_handler called

☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆
　　            ホ−ムペ−ジ随時更新中！！　　遊びにきてね。 (^o^)/
    　　　藤井　律男     E-mail: ritsuo ＠ mxy.mesh.ne.jp  (private)
                               E-mail: xxxxxx ＠ docomo.ne.jp
/　/　/　/　　             E-mail: rfujii ＠ fukuyama.kkmiura.co.jp
  ////　　　　　Home_page http://www2k.biglobe.ne.jp/~ritsuo/index.html
   ☆　　　　    　Okayama, JAPAN
Pentax 125SD(F6.4) + ST-4,CV-16L,BJ-30C,S2pro   Takahashi m-250(F12)+ToUcam

            PGP:A801 C77D ADAF 6B8A 5ABF  8983 2171 1140 46CF 09C0

  技評より「まるごとわかるDB読本」が発刊されています
★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★
 
Ritsuo Fujii <ritsuo ＠ mxy.mesh.ne.jp>

pgsql-jp メーリングリストの案内