[pgpool-committers: 2618] pgpool: Fix regress test to sleep after pgpool_reload

Yugo Nagata nagata at sraoss.co.jp
Wed Aug 19 17:24:54 JST 2015

Fix regress test to sleep after pgpool_reload

Some regression tests test behaviors after pgpool-II configuration
is modified and reloaded. However, sometimes these modification
were not applied to pgpool just after reloading.

It was observed after the following commit.

 commit ba24a708ed61d6a5fa296451b194c4b448ed5966
 Author: Tatsuo Ishii <ishii at postgresql.org>
 Date:   Thu Aug 6 13:02:42 2015 +0900

 Issue fsync() when writing pgpool_status.

 This ensures that pgpool_status is saved to permanent storage and
 allow to survive after system crash.

It seem to be because fsync() takes a time before SIGHUP is sent
to child processes in reload_config().

Fix is to add sleep to wait for applying modification after

In addition, some messages are added to test for debugging.



Modified Files
src/test/regression/tests/001.load_balance/test.sh |   12 +++++++++++-
src/test/regression/tests/008.dbredirect/test.sh   |    1 +
src/test/regression/tests/009.sql_comments/test.sh |    1 +
3 files changed, 13 insertions(+), 1 deletion(-)

More information about the pgpool-committers mailing list