View Issue Details

IDProjectCategoryView StatusLast Update
0000398Pgpool-IIBugpublic2019-01-30 10:09
ReporterpdindakAssigned Topengbo 
PriorityurgentSeveritymajorReproducibilityalways
Status assignedResolutionopen 
PlatformOSRHELOS Version6
Product Version3.7.1 
Target VersionFixed in Version 
Summary0000398: useful logs are not displayed - no matter what config level for logs is used
DescriptionPostgres 9.6
RPM install of 3.7.1

pgpool.conf
log_destination = 'syslog'

Reload pgpool

messages:

May 11 19:36:47 pre-sv-postgres-db-2 pgpool[10361]: [93-1] 2018-05-11 19:36:47: pid 10361: LOG: reload config files.
May 11 19:36:47 pre-sv-postgres-db-2 pgpool[10361]: [93-2] 2018-05-11 19:36:47: pid 10361: LOCATION: pgpool_main.c:3399
May 11 19:36:47 pre-sv-postgres-db-2 pgpool[10509]: [620114-1] 2018-05-11 19:36:47: pid 10509: LOG: reloading config file
May 11 19:36:47 pre-sv-postgres-db-2 pgpool[10509]: [620114-2] 2018-05-11 19:36:47: pid 10509: LOCATION: pool_worker_child.c:446
May 11 19:38:06 pre-sv-postgres-db-2 pgpool[11035]: [19-1] 2018-05-11 19:38:06: pid 11035: INFO: unrecognized configuration parameter "ifconfig_path"
May 11 19:38:06 pre-sv-postgres-db-2 pgpool[11035]: [19-2] 2018-05-11 19:38:06: pid 11035: LOCATION: pool_config_variables.c:2605
May 11 19:38:06 pre-sv-postgres-db-2 pgpool[10361]: [95-1] 2018-05-11 19:38:06: pid 10361: INFO: unrecognized configuration parameter "debug_level"
May 11 19:38:06 pre-sv-postgres-db-2 pgpool[10361]: [95-2] 2018-05-11 19:38:06: pid 10361: LOCATION: pool_config_variables.c:2605
May 11 19:38:06 pre-sv-postgres-db-2 pgpool[10361]: [114-1] 2018-05-11 19:38:06: pid 10361: INFO: unrecognized configuration parameter "ifconfig_path"
May 11 19:38:06 pre-sv-postgres-db-2 pgpool[10361]: [114-2] 2018-05-11 19:38:06: pid 10361: LOCATION: pool_config_variables.c:2605
May 11 19:38:06 pre-sv-postgres-db-2 pgpool[10361]: [118-1] 2018-05-11 19:38:06: pid 10361: WARNING: failed to open status file at: "/var/log/pgpool-II-96/pgpool_status"
May 11 19:38:06 pre-sv-postgres-db-2 pgpool[10361]: [118-2] 2018-05-11 19:38:06: pid 10361: DETAIL: "No such file or directory"
May 11 19:38:06 pre-sv-postgres-db-2 pgpool[10361]: [118-3] 2018-05-11 19:38:06: pid 10361: LOCATION: pgpool_main.c:3338


What I see in logs:

.done.
.done.
.done.
.done.
.done.
.done.
.done.
.done.
.done.
.done.
.done.
failover done. shutdown host pre-sv-postgres(5432)failover done. shutdown host pre-sv-postgres-db-2(5432).done.
.done.
.done.
.done.
.done.
.done.
.done.


If I do the " -d -n" in the /etc/sysconfig/pgpool-II-96 config, I see lots of debug statements, so logging IS working:

2018-05-11 19:36:47: pid 10361: LOCATION: pool_config_variables.c:2765
2018-05-11 19:36:47: pid 10361: DEBUG: setting value no index value for parameter "health_check_max_retries" source = 1
2018-05-11 19:36:47: pid 10361: LOCATION: pool_config_variables.c:2755
2018-05-11 19:36:47: pid 10361: DEBUG: parameter "health_check_max_retries" is an array type variable and allows index-free value as well
2018-05-11 19:36:47: pid 10361: LOCATION: pool_config_variables.c:2765
2018-05-11 19:36:47: pid 10361: DEBUG: setting value no index value for parameter "health_check_retry_delay" source = 1
2018-05-11 19:36:47: pid 10361: LOCATION: pool_config_variables.c:2755
2018-05-11 19:36:47: pid 10361: DEBUG: parameter "health_check_retry_delay" is an array type variable and allows index-free value as well
2018-05-11 19:36:47: pid 10361: LOCATION: pool_config_variables.c:2765
2018-05-11 19:36:47: pid 10361: DEBUG: setting value no index value for parameter "connect_timeout" source = 1
2018-05-11 19:36:47: pid 10361: LOCATION: pool_config_variables.c:2755
2018-05-11 19:36:47: pid 10361: DEBUG: parameter "connect_timeout" is an array type variable and allows index-free value as well
2018-05-11 19:36:47: pid 10361: LOCATION: pool_config_variables.c:2765
2018-05-11 19:36:47: pid 10361: INFO: unrecognized configuration parameter "ifconfig_path"
2018-05-11 19:36:47: pid 10361: LOCATION: pool_config_variables.c:2605
2018-05-11 19:36:47: pid 10361: DEBUG: initializing pool configuration
2018-05-11 19:36:47: pid 10361: DETAIL: num_backends: 2 total_weight: 2.000000
2018-05-11 19:36:47: pid 10361: LOCATION: pool_config_variables.c:3955


Turn it back off and I get nothing but "done" in the logs

Not sure what else to try here
Steps To ReproduceInstall Postgres 9.6
Install PGPOOL 3.7.1
Config for logging to syslog

watch ",done," appear in /var/log/pgpool-II-96.log


Tagslogging

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2018-05-12 10:06 pdindak New Issue
2018-05-12 10:06 pdindak Tag Attached: logging
2019-01-30 10:09 administrator Assigned To => pengbo
2019-01-30 10:09 administrator Status new => assigned