[RHV] The /var/lib/pgsql directory is growing due to "threads_per_core does not exist" error messages

Solution Verified - Updated -

Issue

The /var/lib/pgsql logs are growing due to following error message

2022-01-24 08:28:03.324 UTC STATEMENT:  SELECT
          host_id,
          host_unique_id,
          host_name,
          cluster_id,
          upper(cast(cluster_id as char(36))) as cluster_join_id,
          host_type,
          fqdn_or_ip,
          memory_size_mb,
          swap_size_mb,
          cpu_model,
          number_of_cores,
          number_of_sockets,
          cpu_speed_mh,
          host_os,
          kernel_version,
          kvm_version,
          vdsm_version,
          vdsm_port,
          threads_per_core,
          hardware_manufacturer,
          hardware_product_name,
          hardware_version,
          hardware_serial_number,
          create_date,
          update_date
        FROM dwh_host_configuration_history_view
2022-01-24 08:43:03.422 UTC ERROR:  column "threads_per_core" does not exist at character 342

Environment

Red Hat Virtualization 4.4

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content