View Issue Details

IDProjectCategoryView StatusLast Update
0000343pgpool-IIBugpublic2017-10-05 10:04
ReportereldadAssigned Topengbo 
PriorityhighSeveritymajorReproducibilityalways
Status resolvedResolutionopen 
Product Version3.6.6 
Target Version3.6.7Fixed in Version 
Summary0000343: Pgpool log is empty after upgrade
DescriptionI upgraded pgpool from 3.6.2 to 3.6.6
The pgpool.log file is not showing regular messages as before, only have 1 line for the shutdown command.
see the configuration in additional information.
the only content the log has is -
2017-09-25 05:34:35: pid 31540: [No Connection]: [No Connection]: LOG: stop request sent to pgpool. waiting for termination...
.done.
Steps To Reproduceupgrade pgpool from 3.6.2 to 3.6.6 without changing pgpool.conf
Additional InformationPGPOOLLOG=/etc/pgpool-II/log/pgpool.log
========
log_destination = 'stderr'
# - What to log -
log_line_prefix = '%t: pid %p: %d: %u: ' # printf-style string to output at beginning of each log line.
log_connections = on
log_hostname = on
log_statement = off
log_per_node_statement = off
log_standby_delay = 'if_over_threshold'
# - Syslog specific -
syslog_facility = 'LOCAL0'
syslog_ident = 'pgpool'

# - Debug -
debug_level = 0
                                   # Debug message verbosity level
                                   # 0 means no message, 1 or more mean verbose
#log_error_verbosity = default # terse, default, or verbose messages
#client_min_messages = notice # values in order of decreasing detail:
log_min_messages = warning # values in order of decreasing detail:

Tagssettings

Activities

t-ishii

2017-09-26 07:54

developer   ~0001715

Sounds like an installation problem. Which distribution are you using? (it's best to fill in a bug report along with the information). How did you install Pgpool-II? From source code or package?

eldad

2017-09-26 15:05

reporter   ~0001716

Hi,

I installed using rpm, downloaded from here:
http://www.pgpool.net/yum/rpms/3.6/redhat/rhel-6-x86_64/

# rpm -qa | grep pgpool
pgpool-II-pg96-3.6.6-1pgdg.rhel6.x86_64
pgpool-II-pg96-devel-3.6.6-1pgdg.rhel6.x86_64

cat /etc/redhat-release
Red Hat Enterprise Linux Server release 6.3 (Santiago)

Regards,
Eldad

pengbo

2017-09-27 22:17

developer   ~0001717

If you install Pgpool-II by using RPM, the log messages are not redirected to log file.
Could you show me your pgpool.service?

I think you configured your pgpool.service in Pgpool-II 3.6.2.

eldad

2017-09-28 17:52

reporter   ~0001718

I compared /etc/init.d/pgpool from the rpm and what I have, it looks the same.

this is the command in it that uses the log file:
$SU -l $PGPOOLUSER -c "$PGPOOLDAEMON -f $PGPOOLCONF $OPTS & " >> "$PGPOOLLOG" 2>&1 < /dev/null
and I use log_destination = 'stderr'

If its not redirected to log file so where are the messages??

eldad

2017-09-28 21:53

reporter   ~0001719

These are the values in the pgpool :
# Set defaults for configuration variables
PGPOOLUSER=postgres
PGPOOLENGINE=/usr/bin
PGPOOLDAEMON=$PGPOOLENGINE/pgpool
PGPOOLCONF=/etc/pgpool-II/pgpool.conf
PGPOOLPIDDIR=/etc/pgpool-II
PGPOOLLOG=/etc/pgpool-II/log/pgpool.log

eldad

2017-10-02 17:31

reporter   ~0001720

Hi,

Any updates?
Do you need more information?

Thanks,
Eldad

pengbo

2017-10-02 19:18

developer   ~0001721

I get the same issue like you.
I think We should improve the /etc/sysconfig/pgpool file of 3.6.6.

Could you try to add
 
       OPTS=" -n"

in your /etc/sysconfig/pgpool of 3.6.6 to fix this?

The following is the /etc/sysconfig/pgpool of 3.6.6. and 3.6.2.
===
3.6.6
===
# Options for pgpool
# If you want to use '-n' in START_OPTS, change the service type to simple in
# the Pgpool-II service configuration file
#OPTS=" -d"

#STOP_OPTS=" -m fast"

====
3.6.2
====
# Options for pgpool
# -n: don't run in daemon mode. does not detatch control tty
# -d: debug mode. lots of debug information will be printed

#OPTS=" -d -n"
OPTS=" -n"

eldad

2017-10-02 20:11

reporter   ~0001722

Hi,

It fixed the problem, thanks you very much!

Regards,
Eldad

Issue History

Date Modified Username Field Change
2017-09-25 23:16 eldad New Issue
2017-09-25 23:16 eldad Tag Attached: settings
2017-09-26 07:54 t-ishii Note Added: 0001715
2017-09-26 15:05 eldad Note Added: 0001716
2017-09-27 22:17 pengbo Note Added: 0001717
2017-09-27 22:18 pengbo Assigned To => pengbo
2017-09-27 22:18 pengbo Status new => assigned
2017-09-28 17:52 eldad Note Added: 0001718
2017-09-28 21:53 eldad Note Added: 0001719
2017-10-02 17:31 eldad Note Added: 0001720
2017-10-02 19:18 pengbo Note Added: 0001721
2017-10-02 20:11 eldad Note Added: 0001722
2017-10-05 10:04 pengbo Status assigned => resolved
2017-10-05 10:04 pengbo Target Version => 3.6.7