[pgpool-general-jp: 1555] Re: Solarisでregression test 006のテストに失敗

[Tatsuo Ishii]

石井です。

ざっくりとしかログを見ていませんが、とりあえず、実際に実行されている
Pgpool-IIが3.7.1なのが気になります。

2018-07-17 11:52:18: pid 24377: LOG:  pgpool-II successfully started. version 3.7.1 (amefuriboshi)
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> 大野と申します。
> お世話になります。
> 
> 以下の環境でregression testを実行したところ、
> 006.memqcacheのテストに必ず失敗しております。
> 006.memqcacheのログを見る限り
> テスト途中でコネクションが閉じられているようですが原因が思い当りません。
> 
> [環境]
> 　Solaris 11.3 SPARC
> 　Postgres10.3
> 　pgpool-II-3.7.4
> 
> [006.memqcache]
> ----
> ：
> server closed the connection unexpectedly
>         This probably means the server terminated abnormally
>         before or while processing the request.
> connection to server was lost
> ----
> 
> 原因・対処方法をご教示頂けないでしょうか。
> テスト時に出力されるログ(006.memqcache)
> 各DBが出力するログ(data0_Tuesday.log、data1_Tuesday.log)
> pgpool2が出力するログ(pgpool.log)を添付致します。
> 
> また、テスト失敗後に以下のプロセスが残ったままになります。
> 
> user ＠ b14se03g027:/mnt/work/pgpool-II-3.7.4/src/test/regression$ ps -ef | grep regress
>     user 24374 24369   0 11:52:18 ?           0:00 /mnt/postgres/bin/postgres -D /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/data1
>     user 24404 24377   0 11:52:18 pts/3       0:00 /mnt/pgpool2//bin/pgpool -d -D -n -f /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pgpool.conf -F /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pcp.conf -a /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pool_hba.conf
>     user 24393 24377   0 11:52:18 pts/3       0:00 /mnt/pgpool2//bin/pgpool -d -D -n -f /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pgpool.conf -F /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pcp.conf -a /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pool_hba.conf
>     user 24371 24369   0 11:52:18 ?           0:00 /mnt/postgres/bin/postgres -D /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/data1
>     user 24410 24377   0 11:52:18 pts/3       0:00 /mnt/pgpool2//bin/pgpool -d -D -n -f /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pgpool.conf -F /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pcp.conf -a /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pool_hba.conf
>     user 24386 24377   0 11:52:18 pts/3       0:00 /mnt/pgpool2//bin/pgpool -d -D -n -f /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pgpool.conf -F /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pcp.conf -a /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pool_hba.conf
>     user 24403 24377   0 11:52:18 pts/3       0:00 /mnt/pgpool2//bin/pgpool -d -D -n -f /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pgpool.conf -F /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pcp.conf -a /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pool_hba.conf
>     user 24401 24377   0 11:52:18 pts/3       0:00 /mnt/pgpool2//bin/pgpool -d -D -n -f /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pgpool.conf -F /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pcp.conf -a /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pool_hba.conf
>     user 24389 24377   0 11:52:18 pts/3       0:00 /mnt/pgpool2//bin/pgpool -d -D -n -f /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pgpool.conf -F /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pcp.conf -a /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pool_hba.conf
>     user 24362 24357   0 11:52:18 ?           0:00 /mnt/postgres/bin/postgres -D /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/data0
>     user 24373 24369   0 11:52:18 ?           0:00 /mnt/postgres/bin/postgres -D /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/data1
>     user 24618 24377   0 11:57:19 pts/3       0:00 /mnt/pgpool2//bin/pgpool -d -D -n -f /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pgpool.conf -F /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pcp.conf -a /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pool_hba.conf
>     user 24364 24357   0 11:52:18 ?           0:00 /mnt/postgres/bin/postgres -D /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/data0
>     user 24419 24377   0 11:52:19 pts/3       0:00 /mnt/pgpool2//bin/pgpool -d -D -n -f /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pgpool.conf -F /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pcp.conf -a /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pool_hba.conf
>     user 24392 24377   0 11:52:18 pts/3       0:00 /mnt/pgpool2//bin/pgpool -d -D -n -f /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pgpool.conf -F /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pcp.conf -a /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pool_hba.conf
>     user 24407 24377   0 11:52:18 pts/3       0:00 /mnt/pgpool2//bin/pgpool -d -D -n -f /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pgpool.conf -F /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pcp.conf -a /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pool_hba.conf
>     user 24413 24377   0 11:52:19 pts/3       0:00 /mnt/pgpool2//bin/pgpool -d -D -n -f /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pgpool.conf -F /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pcp.conf -a /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pool_hba.conf
>     user 24408 24377   0 11:52:18 pts/3       0:00 /mnt/pgpool2//bin/pgpool -d -D -n -f /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pgpool.conf -F /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pcp.conf -a /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pool_hba.conf
>     user 24402 24377   0 11:52:18 pts/3       0:00 /mnt/pgpool2//bin/pgpool -d -D -n -f /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pgpool.conf -F /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pcp.conf -a /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pool_hba.conf
>     user 24383 24377   0 11:52:18 pts/3       0:00 /mnt/pgpool2//bin/pgpool -d -D -n -f /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pgpool.conf -F /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pcp.conf -a /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pool_hba.conf
>     user 24418 24377   0 11:52:19 pts/3       0:00 /mnt/pgpool2//bin/pgpool -d -D -n -f /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pgpool.conf -F /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pcp.conf -a /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pool_hba.conf
>     user 24385 24377   0 11:52:18 pts/3       0:00 /mnt/pgpool2//bin/pgpool -d -D -n -f /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pgpool.conf -F /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pcp.conf -a /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pool_hba.conf
>     user 24395 24377   0 11:52:18 pts/3       0:00 /mnt/pgpool2//bin/pgpool -d -D -n -f /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pgpool.conf -F /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pcp.conf -a /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pool_hba.conf
>     user 24360 24357   0 11:52:18 ?           0:00 /mnt/postgres/bin/postgres -D /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/data0
>     user 24375 24357   0 11:52:18 ?           0:00 /mnt/postgres/bin/postgres -D /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/data0
>     user 24396 24377   0 11:52:18 pts/3       0:00 /mnt/pgpool2//bin/pgpool -d -D -n -f /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pgpool.conf -F /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pcp.conf -a /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pool_hba.conf
>     user 24399 24377   0 11:52:18 pts/3       0:00 /mnt/pgpool2//bin/pgpool -d -D -n -f /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pgpool.conf -F /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pcp.conf -a /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pool_hba.conf
>     user 24405 24377   0 11:52:18 pts/3       0:00 /mnt/pgpool2//bin/pgpool -d -D -n -f /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pgpool.conf -F /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pcp.conf -a /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pool_hba.conf
>     user 24394 24377   0 11:52:18 pts/3       0:00 /mnt/pgpool2//bin/pgpool -d -D -n -f /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pgpool.conf -F /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pcp.conf -a /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pool_hba.conf
>     user 24694  2014   0 11:59:05 pts/3       0:00 grep regress
>     user 24409 24377   0 11:52:18 pts/3       0:00 /mnt/pgpool2//bin/pgpool -d -D -n -f /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pgpool.conf -F /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pcp.conf -a /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pool_hba.conf
>     user 24411 24377   0 11:52:18 pts/3       0:00 /mnt/pgpool2//bin/pgpool -d -D -n -f /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pgpool.conf -F /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pcp.conf -a /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pool_hba.conf
>     user 24361 24357   0 11:52:18 ?           0:00 /mnt/postgres/bin/postgres -D /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/data0
>     user 24432 24377   0 11:52:22 pts/3       0:00 /mnt/pgpool2//bin/pgpool -d -D -n -f /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pgpool.conf -F /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pcp.conf -a /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pool_hba.conf
>     user 24398 24377   0 11:52:18 pts/3       0:00 /mnt/pgpool2//bin/pgpool -d -D -n -f /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pgpool.conf -F /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pcp.conf -a /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pool_hba.conf
>     user 24412 24377   0 11:52:19 pts/3       0:00 /mnt/pgpool2//bin/pgpool -d -D -n -f /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pgpool.conf -F /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pcp.conf -a /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pool_hba.conf
>     user 24406 24377   0 11:52:18 pts/3       0:00 /mnt/pgpool2//bin/pgpool -d -D -n -f /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pgpool.conf -F /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pcp.conf -a /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pool_hba.conf
>     user 24358 24357   0 11:52:18 ?           0:00 /mnt/postgres/bin/postgres -D /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/data0
>     user 24390 24377   0 11:52:18 pts/3       0:00 /mnt/pgpool2//bin/pgpool -d -D -n -f /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pgpool.conf -F /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pcp.conf -a /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pool_hba.conf
>     user 24400 24377   0 11:52:18 pts/3       0:00 /mnt/pgpool2//bin/pgpool -d -D -n -f /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pgpool.conf -F /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pcp.conf -a /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pool_hba.conf
>     user 24416 24377   0 11:52:19 pts/3       0:00 /mnt/pgpool2//bin/pgpool -d -D -n -f /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pgpool.conf -F /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pcp.conf -a /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pool_hba.conf
>     user 24397 24377   0 11:52:18 pts/3       0:00 /mnt/pgpool2//bin/pgpool -d -D -n -f /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pgpool.conf -F /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pcp.conf -a /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pool_hba.conf
>     user 24370 24369   0 11:52:18 ?           0:00 /mnt/postgres/bin/postgres -D /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/data1
>     user 24387 24377   0 11:52:18 pts/3       0:00 /mnt/pgpool2//bin/pgpool -d -D -n -f /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pgpool.conf -F /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pcp.conf -a /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pool_hba.conf
>     user 24417 24377   0 11:52:19 pts/3       0:00 /mnt/pgpool2//bin/pgpool -d -D -n -f /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pgpool.conf -F /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pcp.conf -a /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pool_hba.conf
>     user 24363 24357   0 11:52:18 ?           0:00 /mnt/postgres/bin/postgres -D /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/data0
>     user 24365 24357   0 11:52:18 ?           0:00 /mnt/postgres/bin/postgres -D /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/data0
>     user 24377     1   0 11:52:18 pts/3       0:00 /mnt/pgpool2//bin/pgpool -d -D -n -f /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pgpool.conf -F /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pcp.conf -a /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pool_hba.conf
>     user 24372 24369   0 11:52:18 ?           0:00 /mnt/postgres/bin/postgres -D /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/data1
>     user 24366 24357   0 11:52:18 ?           0:00 /mnt/postgres/bin/postgres -D /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/data0
>     user 24388 24377   0 11:52:18 pts/3       0:00 /mnt/pgpool2//bin/pgpool -d -D -n -f /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pgpool.conf -F /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pcp.conf -a /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pool_hba.conf
>     user 24369     1   0 11:52:18 pts/3       0:00 /mnt/postgres/bin/postgres -D /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/data1
>     user 24391 24377   0 11:52:18 pts/3       0:00 /mnt/pgpool2//bin/pgpool -d -D -n -f /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pgpool.conf -F /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pcp.conf -a /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/etc/pool_hba.conf
>     user 24357     1   0 11:52:18 pts/3       0:00 /mnt/postgres/bin/postgres -D /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/data0
>     user 24376 24369   0 11:52:18 ?           0:00 /mnt/postgres/bin/postgres -D /mnt/work/pgpool-II-3.7.4/src/test/regression/tests/006.memqcache/testdir/data1
> user ＠ b14se03g027:/mnt/work/pgpool-II-3.7.4/src/test/regression$
> 
> 以上です。よろしくお願いします。