View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000398 | Pgpool-II | Bug | public | 2018-05-12 10:06 | 2019-01-30 10:09 |
| Reporter | pdindak | Assigned To | pengbo | ||
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | assigned | Resolution | open | ||
| OS | RHEL | OS Version | 6 | ||
| Product Version | 3.7.1 | ||||
| Summary | 0000398: useful logs are not displayed - no matter what config level for logs is used | ||||
| Description | Postgres 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 Reproduce | Install Postgres 9.6 Install PGPOOL 3.7.1 Config for logging to syslog watch ",done," appear in /var/log/pgpool-II-96.log | ||||
| Tags | logging | ||||
| 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 |
