Symptoms

The task Task "Collect disk usage statistics on ... " failed with error : 

"User 'p231143' does not exist".

Cause

POA-83085 - [NG] task diskusage fails with User XXXXX does not exist

Resolution

Make changes on all databases: web_cluster_db32 in NG cluster

  1. Connect to database web_cluster_db32 with psql

  2. Create index with command:

    CREATE INDEX apache_h2e_websites_idx9 ON v_apache_h2e_websites (ftp_ipv6);

  3. Create index with command:

    CREATE INDEX apache_h2e_websites_idx10 ON v_apache_h2e_websites (ftp_ip);

  4. Modify view

    CREATE OR REPLACE VIEW v_apache_h2e_configured_ips AS (
WITH RECURSIVE t(ip) AS (SELECT min(ipv6) FROM v_apache_h2e_websites UNION ALL SELECT (SELECT min(ipv6) FROM v_apache_h2e_websites WHERE ipv6 > t.ip) FROM t WHERE t.ip IS NOT NULL) SELECT ip as ip_address FROM t where ip != '')
UNION (WITH RECURSIVE t(ip) AS (SELECT min(ftp_ipv6) FROM v_apache_h2e_websites UNION ALL SELECT (SELECT min(ftp_ipv6) FROM v_apache_h2e_websites WHERE ftp_ipv6 > t.ip) FROM t WHERE t.ip IS NOT NULL) SELECT ip FROM t where ip != '')
UNION (WITH RECURSIVE t(ip) AS (SELECT min(current_ip) FROM v_apache_h2e_websites UNION ALL SELECT (SELECT min(current_ip) FROM v_apache_h2e_websites WHERE current_ip > t.ip) FROM t WHERE t.ip IS NOT NULL) SELECT ip FROM t where ip != '')
UNION (WITH RECURSIVE t(ip) AS (SELECT min(ftp_ip) FROM v_apache_h2e_websites UNION ALL SELECT (SELECT min(ftp_ip) FROM v_apache_h2e_websites WHERE ftp_ip > t.ip) FROM t WHERE t.ip IS NOT NULL) SELECT ip FROM t WHERE ip != '');

Rollback

To rollback changes perform following request:

CREATE OR REPLACE VIEW v_apache_h2e_configured_ips
AS SELECT ipv6 as ip_address FROM v_apache_h2e_websites WHERE ipv6 != ''
UNION SELECT ftp_ipv6 FROM v_apache_h2e_websites WHERE ftp_ipv6 != ''
UNION SELECT current_ip from v_apache_h2e_websites WHERE current_ip != ''
UNION SELECT ftp_ip FROM v_apache_h2e_websites WHERE ftp_ip != '';

Internal content