View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000343 | Pgpool-II | Bug | public | 2017-09-25 23:16 | 2017-10-05 10:04 |
| Reporter | eldad | Assigned To | pengbo | ||
| Priority | high | Severity | major | Reproducibility | always |
| Status | resolved | Resolution | open | ||
| Product Version | 3.6.6 | ||||
| Target Version | 3.6.7 | ||||
| Summary | 0000343: Pgpool log is empty after upgrade | ||||
| Description | I 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 Reproduce | upgrade pgpool from 3.6.2 to 3.6.6 without changing pgpool.conf | ||||
| Additional Information | PGPOOLLOG=/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: | ||||
| Tags | settings | ||||
|
|
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? |
|
|
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 |
|
|
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. |
|
|
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?? |
|
|
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 |
|
|
Hi, Any updates? Do you need more information? Thanks, Eldad |
|
|
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" |
|
|
Hi, It fixed the problem, thanks you very much! Regards, Eldad |
| 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 |
