Article ID: 119748, created on Jan 22, 2014, last review on May 30, 2014

  • Applies to:
  • Operations Automation 5.4

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 != '';

ac82ce33439a9c1feec4ff4f2f638899 caea8340e2d186a540518d08602aa065 5356b422f65bdad1c3e9edca5d74a1ae 2554725ed606193dd9bbce21365bed4e e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF