Actions
Bug #14742
closed
Bug #6403: Postgresql misconfigured when not the default distrib package (ex: Centos 6 with Postgresql 9.3 from pgfoundry.org)
System technique don't support PostgreSQL from other source than the distribution
Pull Request:
Severity:
UX impact:
User visibility:
Effort required:
Priority:
0
Name check:
Fix check:
Regression:
Description
if postgresql is not the system one, the component Check postgresql boot script and Check postgresql process are failing
agent ouput is
E| compliant server-roles Check PostgreSQL configu| There is no need of specific PostgreSQL configuration on this system R: [INFO] Executing is-active-process on postgres:.* writer process using the systemctl method warning server-roles Check postgresql process postgres:.* write| Check if the service postgres:.* writer process is started using ps could not be repaired rudder info: Executing 'no timeout' ... '/bin/systemctl --no-ask-password start postgresql.service' error: Finished command related to promiser '/bin/systemctl --no-ask-password start postgresql.service' -- an error occurred, returned 5 rudder info: Completed execution of '/bin/systemctl --no-ask-password start postgresql.service' R: [INFO] Executing start on postgresql using the systemctl method error: Method 'ncf_services' failed in some repairs warning server-roles Check postgresql process postgresql Run action start on service postgresql could not be repaired error: Method 'service_action' failed in some repairs warning server-roles Check postgresql process postgresql Start service postgresql could not be repaired error: Method 'service_start' failed in some repairs warning server-roles Check postgresql process postgresql Ensure that service postgresql is running could not be repaired error: Method 'service_started_path' failed in some repairs warning server-roles Check postgresql process postgresql Ensure that service postgresql is running could not be repaired error: Method 'service_ensure_running_path' failed in some repairs E| error server-roles Check postgresql process Check postgresql process running could not be repaired error: Method 'generic_process_check_process' failed in some repairs Failed to get unit file state for postgresql.service: No such file or directory R: [INFO] Executing is-enabled on postgresql using the systemctl method warning server-roles Check postgresql boot sc| postgresql Check if service postgresql is started at boot could not be repaired rudder info: Executing 'no timeout' ... '/bin/systemctl --no-ask-password enable postgresql.service' error: Finished command related to promiser '/bin/systemctl --no-ask-password enable postgresql.service' -- an error occurred, returned 1 rudder info: Completed execution of '/bin/systemctl --no-ask-password enable postgresql.service' R: [INFO] Executing enable on postgresql using the systemctl method error: Method 'ncf_services' failed in some repairs warning server-roles Check postgresql boot sc| postgresql Ensure service postgresql is started at boot could not be repaired error: Method 'service_enabled' failed in some repairs warning server-roles Check postgresql boot sc| postgresql Ensure service postgresql is started at boot could not be repaired error: Method 'service_ensure_started_at_boot' failed in some repairs E| error server-roles Check postgresql boot sc| Check postgresql boot starting parameters could not be repaired error: Method 'generic_process_check_bootstart' failed in some repairs error: Method 'root_component_check' failed in some repairs E| n/a server-roles Send metrics to rudder-p| Sending metrics to rudder-project.org is not enabled. Skipping. R: [INFO] Executing is-active on rsyslog using the systemctl method info Common Make sure syslog service| rsyslog Check if the service rsyslog is started was correct info Common Make sure syslog service| rsyslog Ensure that service rsyslog is running was correct info Common Make sure syslog service| rsyslog Ensure that service rsyslog is running was correct
Updated by Nicolas CHARLES over 5 years ago
check on process is made on
postgres:.* writer process
however the process list with postgres 11 are
postgres 3920 0.0 0.8 392348 16864 ? Ss 11:58 0:00 /usr/pgsql-11/bin/postmaster -D /var/lib/pgsql/11/data/ postgres 3922 0.0 0.1 247268 2396 ? Ss 11:58 0:00 \_ postgres: logger postgres 3924 0.0 0.3 392464 7212 ? Ss 11:58 0:00 \_ postgres: checkpointer postgres 3925 0.0 0.2 392484 3780 ? Ss 11:58 0:00 \_ postgres: background writer postgres 3926 0.0 0.3 392348 6508 ? Ss 11:58 0:00 \_ postgres: walwriter postgres 3927 0.0 0.1 392896 3436 ? Ss 11:58 0:00 \_ postgres: autovacuum launcher postgres 3928 0.0 0.1 247396 2556 ? Ss 11:58 0:00 \_ postgres: stats collector postgres 3929 0.0 0.1 392764 3016 ? Ss 11:58 0:00 \_ postgres: logical replication launcher
ubuntu 16.04 with postgres 9.5 is
postgres 2648 0.0 0.6 294716 13328 ? S Apr04 1:14 /usr/lib/postgresql/9.5/bin/postgres -D /var/lib/postgresql/9.5/main -c config_file=/etc/postgresql/9.5/main/postgresql.conf postgres 2661 0.0 6.5 294848 134080 ? Ss Apr04 2:14 \_ postgres: checkpointer process postgres 2662 0.0 1.7 294716 35284 ? Ss Apr04 0:15 \_ postgres: writer process postgres 2663 0.0 0.3 294716 6680 ? Ss Apr04 1:12 \_ postgres: wal writer process postgres 2664 0.0 0.1 295100 3804 ? Ss Apr04 0:20 \_ postgres: autovacuum launcher process postgres 2665 0.0 0.1 149828 2268 ? Ss Apr04 1:17 \_ postgres: stats collector process
centos 6 with postgresl 8.4 (unsupported)
postgres 1360 0.0 0.0 215984 2712 ? S Apr04 0:33 /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data postgres 1415 0.0 0.0 178996 668 ? Ss Apr04 0:56 \_ postgres: logger process postgres 1417 0.0 0.8 216184 35140 ? Ss Apr04 8:04 \_ postgres: writer process postgres 1418 0.0 0.0 215984 924 ? Ss Apr04 4:52 \_ postgres: wal writer process postgres 1419 0.0 0.0 216256 1108 ? Ss Apr04 1:16 \_ postgres: autovacuum launcher process postgres 1420 0.0 0.0 179128 852 ? Ss Apr04 1:35 \_ postgres: stats collector process
sles11 with postgresql 9.1 is
postgres 4393 0.0 0.0 98280 1156 ? S Apr04 0:25 /usr/lib/postgresql91/bin/postgres -D /var/lib/pgsql/data postgres 4998 0.0 0.0 57876 412 ? Ss Apr04 0:59 \_ postgres: logger process postgres 5000 0.0 2.2 98364 35080 ? Ss Apr04 6:24 \_ postgres: writer process postgres 5001 0.0 0.0 98264 1432 ? Ss Apr04 4:47 \_ postgres: wal writer process postgres 5002 0.0 0.0 99140 1296 ? Ss Apr04 1:13 \_ postgres: autovacuum launcher process postgres 5003 0.0 0.0 58136 464 ? Ss Apr04 1:04 \_ postgres: stats collector process po
debian 9 with postgresql 9.6 is
postgres 1208 0.0 0.6 287576 13328 ? S Apr04 1:23 /usr/lib/postgresql/9.6/bin/postgres -D /var/lib/postgresql/9.6/main -c config_file=/etc/postgresql/9.6/main/postgresql.conf postgres 1787 0.0 6.8 287868 140644 ? Ss Apr04 5:57 \_ postgres: 9.6/main: checkpointer process postgres 1788 0.0 6.6 287576 136936 ? Ss Apr04 0:54 \_ postgres: 9.6/main: writer process postgres 1789 0.0 0.3 287576 6432 ? Ss Apr04 1:59 \_ postgres: 9.6/main: wal writer process postgres 1790 0.0 0.1 287980 3156 ? Ss Apr04 0:24 \_ postgres: 9.6/main: autovacuum launcher process postgres 1791 0.0 0.0 142704 1832 ? Ss Apr04 3:37 \_ postgres: 9.6/main: stats collector process
Updated by Nicolas CHARLES over 5 years ago
- Related to Bug #9182: Multiple errors "The postgresql process was not running and has been restarted" added
Updated by Nicolas CHARLES over 5 years ago
- Related to User story #2202: PT distributePolicy: Check if all the core rudder daemons are launched and set to start on boot added
Updated by Nicolas CHARLES over 5 years ago
when webapp is stopped, the ouput is much smaller
postgres 17418 0.1 0.8 392348 16844 ? Ss 13:30 0:00 /usr/pgsql-11/bin/postmaster -D /var/lib/pgsql/11/data/ postgres 17420 0.0 0.1 247268 1900 ? Ss 13:30 0:00 \_ postgres: logger postgres 17422 0.0 0.1 392348 2040 ? Ss 13:30 0:00 \_ postgres: checkpointer postgres 17423 0.0 0.1 392348 2276 ? Ss 13:30 0:00 \_ postgres: background writer postgres 17424 0.0 0.3 392348 6232 ? Ss 13:30 0:00 \_ postgres: walwriter postgres 17425 0.0 0.1 392764 3076 ? Ss 13:30 0:00 \_ postgres: autovacuum launcher postgres 17426 0.0 0.1 247396 2208 ? Ss 13:30 0:00 \_ postgres: stats collector postgres 17427 0.0 0.1 392764 2784 ? Ss 13:30 0:00 \_ postgres: logical replication launcher
Updated by Nicolas CHARLES over 5 years ago
- Status changed from New to In progress
- Assignee set to Nicolas CHARLES
Updated by Nicolas CHARLES over 5 years ago
- Status changed from In progress to Pending technical review
- Assignee changed from Nicolas CHARLES to Benoît PECCATTE
- Pull Request set to https://github.com/Normation/rudder-techniques/pull/1432
Updated by Nicolas CHARLES over 5 years ago
- Status changed from Pending technical review to Pending release
Applied in changeset rudder-techniques|69881aec936cf51527b81ce78b7bb8603b48e0e1.
Updated by Nicolas CHARLES over 5 years ago
- Subject changed from System technique don't support Postgresql to System technique don't support PostgreSQL from other source than the distribution
Updated by Vincent MEMBRÉ over 5 years ago
- Status changed from Pending release to Released
This bug has been fixed in Rudder 5.0.10 which was released today.
Actions