Hi
oVirt,
Since
oVirt upgrade from 4.2.8 to 4.3.7, SHE postgres is
running 100% CPU with 4 processes, related to
ovirt_engine_history DB:
PID USER PR NI VIRT RES SHR S %CPU
%MEM TIME+ COMMAND
2617
postgres 20 0 372668 30876 26352 R 100.0 0.2
63:40.19 postgres: ovirt_engine_history
ovirt_engine_history 127.0.0.1(50226) INSERT
3554
postgres 20 0 368680 15120 11716 R 100.0 0.1
56:45.72 postgres: ovirt_engine_history
ovirt_engine_history 127.0.0.1(50448) BIND
2623
postgres 20 0 368068 17640 14896 R 99.3 0.1
42:35.36 postgres: ovirt_engine_history
ovirt_engine_history 127.0.0.1(50228) BIND
2880
postgres 20 0 368680 20404 17004 R 99.0 0.1
65:13.96 postgres: ovirt_engine_history
ovirt_engine_history 127.0.0.1(50252) BIND
Output
of select * from pg_stat_activity; is giving me
following:
16401
| ovirt_engine_history | 2617 | 16386 |
ovirt_engine_history | |
127.0.0.1 | | 50226 |
2019-12-09 13:37:07.779261+01 | 2019-12-09
13:37:09.555704+01 | 2019-12-09 13:39:04.915431+01 |
2019-12-09 13:39:04.915432+01 |
| | active
| 260332629 | 260332629 | INSERT INTO
vm_disks_usage_samples_history
(history_datetime,vm_id,disks_usage) VALUES
($1,$2,$3)
| client
backend
16401
| ovirt_engine_history | 2623 | 16386 |
ovirt_engine_history | |
127.0.0.1 | | 50228 |
2019-12-09 13:37:07.820982+01 | 2019-12-09
14:00:00.042448+01 | 2019-12-09 14:00:00.997228+01 |
2019-12-09 14:00:00.997229+01 |
| | active
| 260333458 | 260332629 | SELECT
+|
client backend
| | |
| |
| | |
|
|
|
| |
| |
| | |
history_datetime,
+|
| | |
| |
| | |
| |
|
| |
| |
| | | vm_id,
+|
| | |
| |
| |
| |
|
|
| |
| |
| | | disks_usage
+|
| | |
| |
| | |
|
| |
|
| | |
| | | FROM
vm_disks_usage_samples_history
+|
| | |
| |
|
| |
|
|
|
| |
| |
| | | WHERE
history_datetime >= '2019-12-09
07:00:00.000000+0100'
+|
| | |
| |
| | |
|
|
| |
|
| |
| | | AND history_datetime
< '2019-12-09 08:00:00.000000+0100'
+|
| | |
| |
| | |
|
|
|
| |
| |
| | | ORDER BY history_id
DESC,
+|
| | |
| |
| | |
|
| |
|
| | |
| | | vm_id
|
16401
| ovirt_engine_history | 2624 | 16386 |
ovirt_engine_history | |
127.0.0.1 | | 50230 |
2019-12-09 13:37:07.826391+01
|
| | 2019-12-09
13:37:07.835886+01 | Client |
ClientRead | idle
| | |
| client backend
16401
| ovirt_engine_history | 2625 | 16386 |
ovirt_engine_history | |
127.0.0.1 | | 50232 |
2019-12-09 13:37:07.847262+01
| |
| 2019-12-09 13:37:07.850961+01 |
Client | ClientRead | idle
| | |
|
client backend
13214
| postgres | 6275 | 10 |
postgres | psql
| | | -1 |
2019-12-09 14:37:13.890996+01 | 2019-12-09
14:46:36.439887+01 | 2019-12-09 14:46:36.439887+01 |
2019-12-09 14:46:36.439897+01 |
| | active
| | 260332629 | select * from
pg_stat_activity;
|
client backend
<image001.png>
Any
ideas why this could be happening?
Kindly
awaiting your reply.
-----
kind regards/met vrindelijke groet
Marko
Vrgotic
ActiveVideo