View Issue Details

IDProjectCategoryView StatusLast Update
0000127Pgpool-IIBugpublic2015-01-05 16:01
ReporterueharaAssigned Tonagata 
PrioritynormalSeveritytweakReproducibilitysometimes
Status closedResolutionfixed 
Product Version 
Target VersionFixed in Version 
Summary0000127: pgpool-II fail in regression '004.watchdog'.
DescriptionHi,

Sometimes, pgpool-II fail in regression test '004.watchdog'.

---------console log---------------
[uehara@localhost regression]$ sh regress.sh -m noinstall -i ~/local/git_pool -p /usr/pgsql-9.3/bin -j ~/JDBC_Driver/postgresql-9.3-1102.jdbc41.jar
not installing pgpool for the tests ...
using pgpool-II at /home/uehara/local/git_pool
*************************
REGRESSION MODE : noinstall
PGPOOL-II : /home/uehara/local/git_pool
PostgreSQL bin : /usr/pgsql-9.3/bin
pgbench : /usr/pgsql-9.3/bin/pgbench
PostgreSQL jdbc : /home/uehara/JDBC_Driver/postgresql-9.3-1102.jdbc41.jar
*************************
testing 004.watchdog...failed.
out of 1 ok:0 failed:1
[uehara@localhost regression]$ sh regress.sh -m noinstall -i ~/local/git_pool -p /usr/pgsql-9.3/bin -j ~/JDBC_Driver/postgresql-9.3-1102.jdbc41.jar
not installing pgpool for the tests ...
using pgpool-II at /home/uehara/local/git_pool
*************************
REGRESSION MODE : noinstall
PGPOOL-II : /home/uehara/local/git_pool
PostgreSQL bin : /usr/pgsql-9.3/bin
pgbench : /usr/pgsql-9.3/bin/pgbench
PostgreSQL jdbc : /home/uehara/JDBC_Driver/postgresql-9.3-1102.jdbc41.jar
*************************
testing 004.watchdog...ok.
out of 1 ok:1 failed:0
---------console log---------------

Failure is happening at buildfarm.
[pgpool-hackers: 729] pgpool-II buildfarm results


I created a patch for this error at regression test.
Would you please check the patch?

regards,
uehara
TagsNo tags attached.

Activities

uehara

2014-12-26 16:51

reporter  

test.sh.patch (497 bytes)
*** test.sh	2014-12-26 16:36:48.020423633 +0900
--- test.sh_new	2014-12-26 16:22:34.842005685 +0900
***************
*** 35,40 ****
--- 35,43 ----
  wait_for_pgpool_startup
  cd ..
  
+ echo "wait 5sec"
+ sleep 5
+ 
  # stop master pgpool and see if standby take over
  $PGPOOL_INSTALL_DIR/bin/pgpool -f master/etc/pgpool.conf -m f stop
  
***************
*** 46,51 ****
--- 49,56 ----
  		echo "Master escalation done."
  		break;
  	fi
+ 	echo "[check] $i times"
+ 	sleep 2
  done
  
  cd master
test.sh.patch (497 bytes)

nagata

2015-01-05 15:09

developer   ~0000506

Thank you for providing the patch!

I'd fixed and committed this.

http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=657c81ea4a67819d4331bda01d76fd872b86f831

Issue History

Date Modified Username Field Change
2014-12-26 16:51 uehara New Issue
2014-12-26 16:51 uehara File Added: test.sh.patch
2014-12-26 17:07 nagata Assigned To => nagata
2014-12-26 17:07 nagata Status new => assigned
2015-01-05 15:09 nagata Note Added: 0000506
2015-01-05 15:09 nagata Status assigned => closed
2015-01-05 15:09 nagata Resolution open => fixed
2015-01-05 16:01 nagata Changeset attached => pgpool2 master 657c81ea