Project

General

Profile

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

Added by Nicolas CHARLES almost 2 years ago. Updated almost 2 years ago.

Status:
Released
Priority:
N/A
Category:
System techniques
Target version:
Severity:
User visibility:
Effort required:
Priority:
0

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


Related issues

Related to Rudder - Bug #9182: Multiple errors "The postgresql process was not running and has been restarted"ReleasedAlexis MOUSSET2016-09-29Actions
Related to Rudder - User story #2202: PT distributePolicy: Check if all the core rudder daemons are launched and set to start on bootReleasedMatthieu CERDA2012-01-26Actions
Actions #1

Updated by Nicolas CHARLES almost 2 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   

Actions #2

Updated by Nicolas CHARLES almost 2 years ago

  • Related to Bug #9182: Multiple errors "The postgresql process was not running and has been restarted" added
Actions #3

Updated by Nicolas CHARLES almost 2 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
Actions #4

Updated by Nicolas CHARLES almost 2 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 

Actions #5

Updated by Nicolas CHARLES almost 2 years ago

  • Status changed from New to In progress
  • Assignee set to Nicolas CHARLES
Actions #6

Updated by Nicolas CHARLES almost 2 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
Actions #7

Updated by Nicolas CHARLES almost 2 years ago

  • Status changed from Pending technical review to Pending release
Actions #8

Updated by Nicolas CHARLES almost 2 years ago

  • Subject changed from System technique don't support Postgresql to System technique don't support PostgreSQL from other source than the distribution
Actions #9

Updated by Vincent MEMBRÉ almost 2 years ago

  • Status changed from Pending release to Released

This bug has been fixed in Rudder 5.0.10 which was released today.

Actions

Also available in: Atom PDF