--_000_6A17C71B52524C408E7AAF69103E9E490FA8E78Dfabamailserverf_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Hi,
I updated to 4.0.6 today and again hitting this Problem can anyone plz help=
?
backend_start | query_start | st=
ate_change | waiting | state | =
query
-------------------------------+-------------------------------+-----------=
--------------------+---------+---------------------+----------------------=
--------------------------------------------------------------------
2017-01-11 15:52:41.612942+01 | 2017-01-11 16:14:45.676881+01 | 2017-01-11 =
16:14:45.676882+01 | f | active | select * from getdisk=
svmguid($1, $2, $3, $4)
2017-01-11 15:52:35.526771+01 | 2017-01-11 16:14:45.750546+01 | 2017-01-11 =
16:14:45.750547+01 | f | active | select * from getdisk=
svmguid($1, $2, $3, $4)
2017-01-11 14:48:41.133303+01 | 2017-01-11 16:14:42.89794+01 | 2017-01-11 =
16:14:42.897991+01 | f | idle | SELECT 1
2017-01-11 14:48:43.504048+01 | 2017-01-11 16:14:46.794742+01 | 2017-01-11 =
16:14:46.794813+01 | f | idle | SELECT option_value FR=
OM vdc_options WHERE option_name =3D 'DisconnectDwh'
2017-01-11 14:48:43.531955+01 | 2017-01-11 16:14:34.541273+01 | 2017-01-11 =
16:14:34.543513+01 | f | idle | COMMIT
2017-01-11 14:48:43.564148+01 | 2017-01-11 16:14:34.543635+01 | 2017-01-11 =
16:14:34.544145+01 | f | idle | COMMIT
2017-01-11 14:48:43.569029+01 | 2017-01-11 16:00:01.86664+01 | 2017-01-11 =
16:00:01.866711+01 | f | idle in transaction | SELECT 'continueAgg', =
'1' +
| | =
| | | FROM history_configur=
ation +
| | =
| | | WHERE var_name =3D 'l=
astHourAggr' +
| | =
| | | AND var_datetime < '2=
017-01-11 15:00:00.000000+0100' +
| | =
| | |
2017-01-11 14:48:43.572644+01 | 2017-01-11 14:48:43.57571+01 | 2017-01-11 =
14:48:43.575736+01 | f | idle | SET extra_float_digits=
=3D 3
2017-01-11 14:48:43.577039+01 | 2017-01-11 14:48:43.580066+01 | 2017-01-11 =
14:48:43.58009+01 | f | idle | SET extra_float_digits=
=3D 3
2017-01-11 14:48:54.308078+01 | 2017-01-11 16:14:46.931422+01 | 2017-01-11 =
16:14:46.931423+01 | f | active | select * from getsnap=
shotbyleafguid($1)
2017-01-11 14:48:54.465485+01 | 2017-01-11 16:14:21.113926+01 | 2017-01-11 =
16:14:21.113959+01 | f | idle | COMMIT
2017-01-11 15:52:41.606561+01 | 2017-01-11 16:14:45.839754+01 | 2017-01-11 =
16:14:45.839755+01 | f | active | select * from getdisk=
svmguid($1, $2, $3, $4)
2017-01-11 14:48:56.477555+01 | 2017-01-11 16:14:45.276255+01 | 2017-01-11 =
16:14:45.277038+01 | f | idle | select * from getvdsb=
yvdsid($1, $2, $3)
2017-01-11 15:52:41.736304+01 | 2017-01-11 16:14:44.48134+01 | 2017-01-11 =
16:14:44.48134+01 | f | active | select * from getdisk=
svmguid($1, $2, $3, $4)
2017-01-11 14:48:56.489949+01 | 2017-01-11 16:14:46.40924+01 | 2017-01-11 =
16:14:46.409241+01 | f | active | select * from getdisk=
svmguid($1, $2, $3, $4)
2017-01-11 15:52:41.618773+01 | 2017-01-11 16:14:45.732394+01 | 2017-01-11 =
16:14:45.732394+01 | f | active | select * from getdisk=
svmguid($1, $2, $3, $4)
2017-01-11 14:48:56.497824+01 | 2017-01-11 16:14:46.827751+01 | 2017-01-11 =
16:14:46.827752+01 | f | active | select * from getsnap=
shotbyleafguid($1)
2017-01-11 14:48:56.497732+01 | 2017-01-11 16:09:04.207597+01 | 2017-01-11 =
16:09:04.342567+01 | f | idle | select * from getvdsb=
yvdsid($1, $2, $3)
2017-01-11 14:48:58.785162+01 | 2017-01-11 16:14:46.093658+01 | 2017-01-11 =
16:14:46.093659+01 | f | active | select * from getdisk=
svmguid($1, $2, $3, $4)
2017-01-11 15:52:41.620421+01 | 2017-01-11 16:14:46.224543+01 | 2017-01-11 =
16:14:46.224543+01 | f | active | select * from getdisk=
svmguid($1, $2, $3, $4)
2017-01-11 15:52:41.620478+01 | 2017-01-11 16:14:46.009864+01 | 2017-01-11 =
16:14:46.009865+01 | f | active | select * from getdisk=
svmguid($1, $2, $3, $4)
2017-01-11 15:52:41.647839+01 | 2017-01-11 16:14:46.834005+01 | 2017-01-11 =
16:14:46.834005+01 | f | active | select * from getsnap=
shotbyleafguid($1)
2017-01-11 14:48:58.929402+01 | 2017-01-11 16:14:44.908748+01 | 2017-01-11 =
16:14:44.908749+01 | f | active | select * from getdisk=
svmguid($1, $2, $3, $4)
2017-01-11 15:52:41.756257+01 | 2017-01-11 16:14:46.193542+01 | 2017-01-11 =
16:14:46.193542+01 | f | active | select * from getdisk=
svmguid($1, $2, $3, $4)
2017-01-11 15:52:41.766689+01 | 2017-01-11 16:14:46.453393+01 | 2017-01-11 =
16:14:46.453394+01 | f | active | select * from getdisk=
svmguid($1, $2, $3, $4)
2017-01-11 15:52:41.848642+01 | 2017-01-11 16:14:29.04013+01 | 2017-01-11 =
16:14:29.080273+01 | f | idle | select * from getvdsb=
yvdsid($1, $2, $3)
2017-01-11 16:03:06.731047+01 | 2017-01-11 16:13:43.332298+01 | 2017-01-11 =
16:13:43.333075+01 | f | idle | select * from getallf=
romcluster($1, $2)
2017-01-11 16:03:18.282962+01 | 2017-01-11 16:14:44.56195+01 | 2017-01-11 =
16:14:44.56195+01 | f | active | select * from getdisk=
svmguid($1, $2, $3, $4)
2017-01-11 16:03:18.305949+01 | 2017-01-11 16:14:46.483223+01 | 2017-01-11 =
16:14:46.483223+01 | f | active | select * from getdisk=
svmguid($1, $2, $3, $4)
2017-01-11 16:03:18.905939+01 | 2017-01-11 16:14:45.090399+01 | 2017-01-11 =
16:14:45.0904+01 | f | active | select * from getdisk=
svmguid($1, $2, $3, $4)
2017-01-11 16:03:25.100944+01 | 2017-01-11 16:14:46.887946+01 | 2017-01-11 =
16:14:46.887947+01 | f | active | select * from getsnap=
shotbyleafguid($1)
2017-01-11 16:03:25.118964+01 | 2017-01-11 16:14:45.866665+01 | 2017-01-11 =
16:14:45.866666+01 | f | active | select * from getdisk=
svmguid($1, $2, $3, $4)
2017-01-11 16:04:00.255077+01 | 2017-01-11 16:13:51.184443+01 | 2017-01-11 =
16:13:51.184499+01 | f | idle | select * from getqosb=
yqosid($1)
2017-01-11 16:04:12.591564+01 | 2017-01-11 16:14:45.849935+01 | 2017-01-11 =
16:14:45.849935+01 | f | active | select * from getdisk=
svmguid($1, $2, $3, $4)
2017-01-11 16:04:13.778038+01 | 2017-01-11 16:14:46.138704+01 | 2017-01-11 =
16:14:46.138705+01 | f | active | select * from getdisk=
svmguid($1, $2, $3, $4)
2017-01-11 16:04:14.734107+01 | 2017-01-11 16:12:28.219276+01 | 2017-01-11 =
16:12:28.219372+01 | f | idle | select * from getqosb=
yqosid($1)
2017-01-11 16:04:15.098427+01 | 2017-01-11 16:14:45.049351+01 | 2017-01-11 =
16:14:45.049352+01 | f | active | select * from getdisk=
svmguid($1, $2, $3, $4)
2017-01-11 16:04:15.549806+01 | 2017-01-11 16:14:45.942699+01 | 2017-01-11 =
16:14:45.942699+01 | f | active | select * from getdisk=
svmguid($1, $2, $3, $4)
2017-01-11 16:04:35.623004+01 | 2017-01-11 16:14:45.277261+01 | 2017-01-11 =
16:14:45.278013+01 | f | idle | select * from getvdsb=
yvdsid($1, $2, $3)
2017-01-11 16:05:17.307564+01 | 2017-01-11 16:14:41.567496+01 | 2017-01-11 =
16:14:41.568274+01 | f | idle | select * from getvdsb=
yvdsid($1, $2, $3)
2017-01-11 16:05:11.805966+01 | 2017-01-11 16:14:46.851024+01 | 2017-01-11 =
16:14:46.851024+01 | f | active | select * from getsnap=
shotbyleafguid($1)
2017-01-11 16:05:17.430004+01 | 2017-01-11 16:10:23.506252+01 | 2017-01-11 =
16:10:23.582274+01 | f | idle | select * from getstor=
age_domains_by_storagepoolid($1, $2, $3)
2017-01-11 16:05:25.482896+01 | 2017-01-11 16:14:45.0316+01 | 2017-01-11 =
16:14:45.0316+01 | f | active | select * from getdisk=
svmguid($1, $2, $3, $4)
2017-01-11 16:05:25.547646+01 | 2017-01-11 16:11:10.067981+01 | 2017-01-11 =
16:11:10.068043+01 | f | idle | select * from getqosb=
yqosid($1)
2017-01-11 16:05:34.070317+01 | 2017-01-11 16:14:46.293573+01 | 2017-01-11 =
16:14:46.293573+01 | f | active | select * from getdisk=
svmguid($1, $2, $3, $4)
2017-01-11 16:05:35.479037+01 | 2017-01-11 16:14:45.699444+01 | 2017-01-11 =
16:14:45.699445+01 | f | active | select * from getdisk=
svmguid($1, $2, $3, $4)
2017-01-11 16:05:35.500181+01 | 2017-01-11 16:14:46.221274+01 | 2017-01-11 =
16:14:46.221274+01 | f | active | select * from getdisk=
svmguid($1, $2, $3, $4)
2017-01-11 16:05:48.391458+01 | 2017-01-11 16:14:46.443046+01 | 2017-01-11 =
16:14:46.443047+01 | f | active | select * from getdisk=
svmguid($1, $2, $3, $4)
2017-01-11 16:06:40.116008+01 | 2017-01-11 16:14:45.181865+01 | 2017-01-11 =
16:14:45.181866+01 | f | active | select * from getdisk=
svmguid($1, $2, $3, $4)
2017-01-11 16:06:23.595959+01 | 2017-01-11 16:14:46.126082+01 | 2017-01-11 =
16:14:46.126083+01 | f | active | select * from getdisk=
svmguid($1, $2, $3, $4)
2017-01-11 16:06:24.582543+01 | 2017-01-11 16:14:46.074258+01 | 2017-01-11 =
16:14:46.074258+01 | f | active | select * from getdisk=
svmguid($1, $2, $3, $4)
2017-01-11 16:06:24.660881+01 | 2017-01-11 16:13:39.930702+01 | 2017-01-11 =
16:13:39.95559+01 | f | idle | select * from getvdsb=
yvdsid($1, $2, $3)
2017-01-11 16:06:24.690863+01 | 2017-01-11 16:07:28.763627+01 | 2017-01-11 =
16:07:28.763684+01 | f | idle | select * from getqosb=
yqosid($1)
2017-01-11 16:06:26.244997+01 | 2017-01-11 16:14:45.760047+01 | 2017-01-11 =
16:14:45.760048+01 | f | active | select * from getdisk=
svmguid($1, $2, $3, $4)
2017-01-11 16:06:26.359194+01 | 2017-01-11 16:14:46.90043+01 | 2017-01-11 =
16:14:46.929003+01 | f | idle | select * from getvdsb=
yvdsid($1, $2, $3)
2017-01-11 16:06:26.377649+01 | 2017-01-11 16:14:45.035936+01 | 2017-01-11 =
16:14:45.035937+01 | f | active | select * from getdisk=
svmguid($1, $2, $3, $4)
2017-01-11 16:06:40.128282+01 | 2017-01-11 16:12:43.764245+01 | 2017-01-11 =
16:12:43.764293+01 | f | idle | select * from getqosb=
yqosid($1)
2017-01-11 16:06:40.150762+01 | 2017-01-11 16:10:54.629416+01 | 2017-01-11 =
16:10:54.629496+01 | f | idle | select * from getstor=
agedomainidsbystoragepoolidandstatus($1, $2)
2017-01-11 16:14:46.934168+01 | 2017-01-11 16:14:46.964807+01 | 2017-01-11 =
16:14:46.964809+01 | f | active | select backend_start,q=
uery_start,state_change,waiting,state,query from pg_stat_activity;
top - 16:13:43 up 1:36, 3 users, load average: 41.62, 37.53, 21.37
Tasks: 286 total, 40 running, 246 sleeping, 0 stopped, 0 zombie
%Cpu(s): 99.3 us, 0.6 sy, 0.0 ni, 0.0 id, 0.0 wa, 0.0 hi, 0.0 si, 0.=
0 st
KiB Mem : 16432648 total, 3626184 free, 6746368 used, 6060096 buff/cache
KiB Swap: 5242876 total, 5242876 free, 0 used. 8104244 avail Mem
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
17328 postgres 20 0 3485020 66760 20980 R 21.5 0.4 1:37.27 postgre=
s: engine engine 127.0.0.1(35212) SELECT
8269 postgres 20 0 3484796 68200 22780 R 21.2 0.4 2:15.36 postgres=
: engine engine 127.0.0.1(47116) SELECT
9016 postgres 20 0 3520356 279756 199452 R 21.2 1.7 7:24.29 postgres=
: engine engine 127.0.0.1(42992) SELECT
16878 postgres 20 0 3498100 66160 18468 R 21.2 0.4 2:00.82 postgre=
s: engine engine 127.0.0.1(34238) SELECT
16751 postgres 20 0 3486388 215784 169404 R 20.9 1.3 1:56.38 postgre=
s: engine engine 127.0.0.1(34008) SELECT
17868 postgres 20 0 3487860 215472 167796 R 20.9 1.3 1:07.40 postgre=
s: engine engine 127.0.0.1(36312) SELECT
8272 postgres 20 0 3490392 76912 25288 R 20.5 0.5 2:30.15 postgres=
: engine engine 127.0.0.1(47124) SELECT
8274 postgres 20 0 3495800 83144 26100 R 20.5 0.5 2:56.66 postgres=
: engine engine 127.0.0.1(47130) SELECT
9015 postgres 20 0 3523344 283388 198908 R 20.5 1.7 7:19.91 postgres=
: engine engine 127.0.0.1(42990) SELECT
16879 postgres 20 0 3488296 72180 23744 R 20.5 0.4 1:30.01 postgre=
s: engine engine 127.0.0.1(34242) SELECT
17241 postgres 20 0 3486540 215716 168024 R 20.5 1.3 1:47.58 postgre=
s: engine engine 127.0.0.1(35018) SELECT
17242 postgres 20 0 3495864 69172 20988 R 20.5 0.4 1:54.09 postgre=
s: engine engine 127.0.0.1(35022) SELECT
17668 postgres 20 0 3488576 54484 15080 R 20.5 0.3 1:28.91 postgre=
s: engine engine 127.0.0.1(35896) SELECT
8266 postgres 20 0 3490688 222344 170852 R 20.2 1.4 2:58.95 postgres=
: engine engine 127.0.0.1(47112) SELECT
8268 postgres 20 0 3503420 241888 177500 R 20.2 1.5 3:10.34 postgres=
: engine engine 127.0.0.1(47117) SELECT
8275 postgres 20 0 3510316 253340 181688 R 20.2 1.5 4:12.02 postgres=
: engine engine 127.0.0.1(47132) SELECT
9014 postgres 20 0 3523872 284636 199424 R 20.2 1.7 7:51.82 postgres=
: engine engine 127.0.0.1(42988) SELECT
9027 postgres 20 0 3514872 265384 189656 R 20.2 1.6 5:21.63 postgres=
: engine engine 127.0.0.1(43012) SELECT
17546 postgres 20 0 3475628 55248 19108 R 20.2 0.3 1:33.40 postgre=
s: engine engine 127.0.0.1(35668) SELECT
17669 postgres 20 0 3483284 66920 22488 R 20.2 0.4 1:28.01 postgre=
s: engine engine 127.0.0.1(35898) SELECT
17670 postgres 20 0 3504988 78300 22032 R 20.2 0.5 1:18.96 postgre=
s: engine engine 127.0.0.1(35900) SELECT
17865 postgres 20 0 3485084 66688 21316 R 20.2 0.4 1:14.00 postgre=
s: engine engine 127.0.0.1(36306) SELECT
7869 postgres 20 0 3492780 224272 171620 R 19.9 1.4 2:57.03 postgres=
: engine engine 127.0.0.1(46542) SELECT
Thx Christian
Von: users-bounces(a)ovirt.org [mailto:users-bounces@ovirt.org] Im Auftrag vo=
n Grundmann, Christian
Gesendet: Donnerstag, 29. September 2016 15:29
An: 'users(a)ovirt.org' <users(a)ovirt.org
Betreff:
[ovirt-users] WG: High Database Load after updating to oVirt 4.0.4
Maybe an side effect off this bug?
https://bugzilla.redhat.com/1302752
I did a restore to 4.0.3 and the timeouts are gone
Von: Grundmann, Christian
Gesendet: Dienstag, 27. September 2016 10:33
An: users@ovirt.org<mailto:users@ovirt.org
Betreff:
High Database Load after updating to oVirt 4.0.4
After 4.0.4 Update we have a very high database load during startup of VMs
So high that the api calls getting timeouts
I attached the output of
select * from pg_stat_activity
is there a way to downgrade to 4.0.3?
Thx Christian
--_000_6A17C71B52524C408E7AAF69103E9E490FA8E78Dfabamailserverf_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml"
xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word"
=
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml"
xmlns=3D"http:=
//www.w3.org/TR/REC-html40"
<head
<meta http-equiv=3D"Content-Type"
content=3D"text/html; charset=3Dus-ascii"=
<meta name=3D"Generator" content=3D"Microsoft
Word 15 (filtered medium)"
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.E-MailFormatvorlage18
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.E-MailFormatvorlage19
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.E-MailFormatvorlage20
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.E-MailFormatvorlage21
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.E-MailFormatvorlage22
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" /
</xml><![endif]--><!--[if gte mso
9]><xml
<o:shapelayout
v:ext=3D"edit"
<o:idmap v:ext=3D"edit"
data=3D"1" /
</o:shapelayout></xml><![endif]--
</head
<body lang=3D"DE-AT"
link=3D"#0563C1" vlink=3D"#954F72"
<div
class=3D"WordSection1"
<p
class=3D"MsoNormal"><span
lang=3D"EN-US">Hi,<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">I updated to 4.0.6 today and ag=
ain hitting this Problem can anyone plz
help?<o:p></o:p></span></p
<p
class=3D"MsoNormal"><span
lang=3D"EN-US"><o:p> </o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US"> &=
nbsp;
backend_start &n=
bsp;
|
query_start&nb=
sp;
| &nbs=
p;
state_change =
| waiting
| st=
ate
| &nbs=
p; &=
nbsp; &nbs=
p;
query<=
o:p></o:p></span></p
<p
class=3D"MsoNormal"><span
lang=3D"EN-US">-------------------------------=
+-------------------------------+-------------------------------=
3;---------+---------------------+---------------------------------=
---------------------------------------------------------<o:p></o:p></span>=
</p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 15:52:41.612942+=
01 | 2017-01-11 16:14:45.676881+01 | 2017-01-11 16:14:45.676882+01 =
| f |
active &nb=
sp; |
select * from g=
etdisksvmguid($1, $2, $3, $4)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 15:52:35.526771+=
01 | 2017-01-11 16:14:45.750546+01 | 2017-01-11 16:14:45.750547+01 =
| f |
active &nb=
sp; |
select * from g=
etdisksvmguid($1, $2, $3, $4)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 14:48:41.133303+=
01 | 2017-01-11 16:14:42.89794+01 | 2017-01-11 16:14:42.897991=
3;01 | f |
idle =
| SELECT=
1<o:p></o:p></span></p
<p
class=3D"MsoNormal"><span lang=3D"EN-US">2017-01-11
14:48:43.504048+=
01 | 2017-01-11 16:14:46.794742+01 | 2017-01-11 16:14:46.794813+01 =
| f |
idle  =
;
| SELECT opti=
on_value FROM vdc_options WHERE option_name =3D
'DisconnectDwh'<o:p></o:p><=
/span></p
<p
class=3D"MsoNormal"><span lang=3D"EN-US">2017-01-11
14:48:43.531955+=
01 | 2017-01-11 16:14:34.541273+01 | 2017-01-11 16:14:34.543513+01 =
| f |
idle  =
;
| COMMIT<o:p>=
</o:p></span></p
<p
class=3D"MsoNormal"><span lang=3D"EN-US">2017-01-11
14:48:43.564148+=
01 | 2017-01-11 16:14:34.543635+01 | 2017-01-11 16:14:34.544145+01 =
| f |
idle  =
;
| COMMIT<o:p>=
</o:p></span></p
<p
class=3D"MsoNormal"><span lang=3D"EN-US">2017-01-11
14:48:43.569029+=
01 | 2017-01-11 16:00:01.86664+01 | 2017-01-11 16:00:01.866711=
3;01 | f | idle in transaction
| SELECT=
'continueAgg',
'1' &n=
bsp;  =
; &n=
bsp;  =
; &n=
bsp; +<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US"> &=
nbsp;
&nb=
sp; =
| &n=
bsp;  =
;
| =
&nb=
sp;
| &nbs=
p;
|  =
; &n=
bsp; | FROM
history_configuration =
&nb=
sp; =
&nb=
sp; =
+<o:p></o:p></span></p
<p
class=3D"MsoNormal"><span
lang=3D"EN-US"> &=
nbsp; &nbs=
p;
=
| &n=
bsp;
&nbs=
p; | =
&nb=
sp;
| &nbs=
p;
|  =
; &n=
bsp; | WHERE var_name =3D
'lastHourAggr'  =
; &n=
bsp;  =
; &n=
bsp;  =
;
+<o:p></o:p></span></p
<p
class=3D"MsoNormal"><span
lang=3D"EN-US"> &=
nbsp; &nbs=
p;
=
| &n=
bsp;  =
;
| =
&nb=
sp;
| &nbs=
p;
|  =
; &n=
bsp; | AND var_datetime < '2017-01-11
15:00:00.000000+0100'&nb=
sp; =
&nb=
sp;
+<o:p></o:p></span></p
<p
class=3D"MsoNormal"><span
lang=3D"EN-US"> &=
nbsp; &nbs=
p;
=
| &n=
bsp;  =
;
| =
&nb=
sp;
| &nbs=
p;
|  =
;
&=
nbsp; |<o:p></o:p></span></p
<p
class=3D"MsoNormal"><span lang=3D"EN-US">2017-01-11
14:48:43.572644+=
01 | 2017-01-11 14:48:43.57571+01 | 2017-01-11 14:48:43.575736=
3;01 | f |
idle =
| SET ex=
tra_float_digits =3D 3<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 14:48:43.577039+=
01 | 2017-01-11 14:48:43.580066+01 | 2017-01-11 14:48:43.58009+01&n=
bsp; | f |
idle =
| SET ex=
tra_float_digits =3D 3<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 14:48:54.308078+=
01 | 2017-01-11 16:14:46.931422+01 | 2017-01-11 16:14:46.931423+01 =
| f |
active &nb=
sp; |
select * from g=
etsnapshotbyleafguid($1)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 14:48:54.465485+=
01 | 2017-01-11 16:14:21.113926+01 | 2017-01-11 16:14:21.113959+01 =
| f |
idle  =
;
| COMMIT<o:p>=
</o:p></span></p
<p
class=3D"MsoNormal"><span lang=3D"EN-US">2017-01-11
15:52:41.606561+=
01 | 2017-01-11 16:14:45.839754+01 | 2017-01-11 16:14:45.839755+01 =
| f |
active &nb=
sp; |
select * from g=
etdisksvmguid($1, $2, $3, $4)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 14:48:56.477555+=
01 | 2017-01-11 16:14:45.276255+01 | 2017-01-11 16:14:45.277038+01 =
| f |
idle  =
;
| select * fr=
om getvdsbyvdsid($1, $2, $3)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 15:52:41.736304+=
01 | 2017-01-11 16:14:44.48134+01 | 2017-01-11 16:14:44.48134+=
;01 | f |
active  =
;
| select * fr=
om getdisksvmguid($1, $2, $3, $4)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 14:48:56.489949+=
01 | 2017-01-11 16:14:46.40924+01 | 2017-01-11 16:14:46.409241=
3;01 | f |
active &nbs=
p;
| select * from&nb=
sp; getdisksvmguid($1, $2, $3, $4)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 15:52:41.618773+=
01 | 2017-01-11 16:14:45.732394+01 | 2017-01-11 16:14:45.732394+01 =
| f |
active &nb=
sp; |
select * from g=
etdisksvmguid($1, $2, $3, $4)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 14:48:56.497824+=
01 | 2017-01-11 16:14:46.827751+01 | 2017-01-11 16:14:46.827752+01 =
| f |
active &nb=
sp; |
select * from g=
etsnapshotbyleafguid($1)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 14:48:56.497732+=
01 | 2017-01-11 16:09:04.207597+01 | 2017-01-11 16:09:04.342567+01 =
| f |
idle  =
;
| select * fr=
om getvdsbyvdsid($1, $2, $3)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 14:48:58.785162+=
01 | 2017-01-11 16:14:46.093658+01 | 2017-01-11 16:14:46.093659+01 =
| f |
active &nb=
sp; |
select * from g=
etdisksvmguid($1, $2, $3, $4)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 15:52:41.620421+=
01 | 2017-01-11 16:14:46.224543+01 | 2017-01-11 16:14:46.224543+01 =
| f |
active &nb=
sp; |
select * from g=
etdisksvmguid($1, $2, $3, $4)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 15:52:41.620478+=
01 | 2017-01-11 16:14:46.009864+01 | 2017-01-11 16:14:46.009865+01 =
| f |
active &nb=
sp; |
select * from g=
etdisksvmguid($1, $2, $3, $4)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 15:52:41.647839+=
01 | 2017-01-11 16:14:46.834005+01 | 2017-01-11 16:14:46.834005+01 =
| f |
active &nb=
sp; |
select * from g=
etsnapshotbyleafguid($1)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 14:48:58.929402+=
01 | 2017-01-11 16:14:44.908748+01 | 2017-01-11 16:14:44.908749+01 =
| f |
active &nb=
sp; |
select * from g=
etdisksvmguid($1, $2, $3, $4)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 15:52:41.756257+=
01 | 2017-01-11 16:14:46.193542+01 | 2017-01-11 16:14:46.193542+01 =
| f |
active &nb=
sp; |
select * from g=
etdisksvmguid($1, $2, $3, $4)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 15:52:41.766689+=
01 | 2017-01-11 16:14:46.453393+01 | 2017-01-11 16:14:46.453394+01 =
| f |
active &nb=
sp; |
select * from g=
etdisksvmguid($1, $2, $3, $4)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 15:52:41.848642+=
01 | 2017-01-11 16:14:29.04013+01 | 2017-01-11 16:14:29.080273=
3;01 | f |
idle =
| select=
* from getvdsbyvdsid($1, $2, $3)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 16:03:06.731047+=
01 | 2017-01-11 16:13:43.332298+01 | 2017-01-11 16:13:43.333075+01 =
| f |
idle  =
;
| select * fr=
om getallfromcluster($1, $2)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 16:03:18.282962+=
01 | 2017-01-11 16:14:44.56195+01 | 2017-01-11 16:14:44.56195+=
;01 | f |
active  =
;
| select * fr=
om getdisksvmguid($1, $2, $3, $4)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 16:03:18.305949+=
01 | 2017-01-11 16:14:46.483223+01 | 2017-01-11 16:14:46.483223+01 =
| f |
active &nb=
sp; |
select * from g=
etdisksvmguid($1, $2, $3, $4)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 16:03:18.905939+=
01 | 2017-01-11 16:14:45.090399+01 | 2017-01-11 16:14:45.0904+01&nb=
sp; | f |
active  =
;
| select * fr=
om getdisksvmguid($1, $2, $3, $4)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 16:03:25.100944+=
01 | 2017-01-11 16:14:46.887946+01 | 2017-01-11 16:14:46.887947+01 =
| f |
active &nb=
sp; |
select * from g=
etsnapshotbyleafguid($1)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 16:03:25.118964+=
01 | 2017-01-11 16:14:45.866665+01 | 2017-01-11 16:14:45.866666+01 =
| f |
active &nb=
sp; |
select * from g=
etdisksvmguid($1, $2, $3, $4)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 16:04:00.255077+=
01 | 2017-01-11 16:13:51.184443+01 | 2017-01-11 16:13:51.184499+01 =
| f |
idle  =
;
| select * fr=
om getqosbyqosid($1)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 16:04:12.591564+=
01 | 2017-01-11 16:14:45.849935+01 | 2017-01-11 16:14:45.849935+01 =
| f |
active &nb=
sp; |
select * from g=
etdisksvmguid($1, $2, $3, $4)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 16:04:13.778038+=
01 | 2017-01-11 16:14:46.138704+01 | 2017-01-11 16:14:46.138705+01 =
| f |
active &nb=
sp; |
select * from g=
etdisksvmguid($1, $2, $3, $4)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 16:04:14.734107+=
01 | 2017-01-11 16:12:28.219276+01 | 2017-01-11 16:12:28.219372+01 =
| f |
idle  =
;
| select * fr=
om getqosbyqosid($1)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 16:04:15.098427+=
01 | 2017-01-11 16:14:45.049351+01 | 2017-01-11 16:14:45.049352+01 =
| f |
active &nb=
sp; |
select * from g=
etdisksvmguid($1, $2, $3, $4)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 16:04:15.549806+=
01 | 2017-01-11 16:14:45.942699+01 | 2017-01-11 16:14:45.942699+01 =
| f |
active &nb=
sp; |
select * from g=
etdisksvmguid($1, $2, $3, $4)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 16:04:35.623004+=
01 | 2017-01-11 16:14:45.277261+01 | 2017-01-11 16:14:45.278013+01 =
| f |
idle  =
;
| select * fr=
om getvdsbyvdsid($1, $2, $3)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 16:05:17.307564+=
01 | 2017-01-11 16:14:41.567496+01 | 2017-01-11 16:14:41.568274+01 =
| f |
idle  =
;
| select * fr=
om getvdsbyvdsid($1, $2, $3)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 16:05:11.805966+=
01 | 2017-01-11 16:14:46.851024+01 | 2017-01-11 16:14:46.851024+01 =
| f |
active &nb=
sp; |
select * from g=
etsnapshotbyleafguid($1)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 16:05:17.430004+=
01 | 2017-01-11 16:10:23.506252+01 | 2017-01-11 16:10:23.582274+01 =
| f |
idle  =
;
| select * fr=
om getstorage_domains_by_storagepoolid($1, $2,
$3)<o:p></o:p></span><=
/p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 16:05:25.482896+=
01 | 2017-01-11 16:14:45.0316+01 | 2017-01-11 16:14:45.0316=
+01 |
f | active &=
nbsp;
| s=
elect * from getdisksvmguid($1, $2, $3,
$4)<o:p></o:p></span></p
<p
class=3D"MsoNormal"><span lang=3D"EN-US">2017-01-11
16:05:25.547646+=
01 | 2017-01-11 16:11:10.067981+01 | 2017-01-11 16:11:10.068043+01 =
| f |
idle  =
;
| select * fr=
om getqosbyqosid($1)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 16:05:34.070317+=
01 | 2017-01-11 16:14:46.293573+01 | 2017-01-11 16:14:46.293573+01 =
| f |
active &nb=
sp; |
select * from g=
etdisksvmguid($1, $2, $3, $4)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 16:05:35.479037+=
01 | 2017-01-11 16:14:45.699444+01 | 2017-01-11 16:14:45.699445+01 =
| f |
active &nb=
sp; |
select * from g=
etdisksvmguid($1, $2, $3, $4)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 16:05:35.500181+=
01 | 2017-01-11 16:14:46.221274+01 | 2017-01-11 16:14:46.221274+01 =
| f |
active &nb=
sp; |
select * from g=
etdisksvmguid($1, $2, $3, $4)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 16:05:48.391458+=
01 | 2017-01-11 16:14:46.443046+01 | 2017-01-11 16:14:46.443047+01 =
| f |
active &nb=
sp; |
select * from g=
etdisksvmguid($1, $2, $3, $4)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 16:06:40.116008+=
01 | 2017-01-11 16:14:45.181865+01 | 2017-01-11 16:14:45.181866+01 =
| f |
active &nb=
sp; |
select * from g=
etdisksvmguid($1, $2, $3, $4)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 16:06:23.595959+=
01 | 2017-01-11 16:14:46.126082+01 | 2017-01-11 16:14:46.126083+01 =
| f |
active &nb=
sp; |
select * from g=
etdisksvmguid($1, $2, $3, $4)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 16:06:24.582543+=
01 | 2017-01-11 16:14:46.074258+01 | 2017-01-11 16:14:46.074258+01 =
| f |
active &nb=
sp; |
select * from g=
etdisksvmguid($1, $2, $3, $4)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 16:06:24.660881+=
01 | 2017-01-11 16:13:39.930702+01 | 2017-01-11 16:13:39.95559+01&n=
bsp; | f |
idle =
| select=
* from getvdsbyvdsid($1, $2, $3)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 16:06:24.690863+=
01 | 2017-01-11 16:07:28.763627+01 | 2017-01-11 16:07:28.763684+01 =
| f |
idle  =
;
| select * fr=
om getqosbyqosid($1)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 16:06:26.244997+=
01 | 2017-01-11 16:14:45.760047+01 | 2017-01-11 16:14:45.760048+01 =
| f |
active &nb=
sp; |
select * from g=
etdisksvmguid($1, $2, $3, $4)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 16:06:26.359194+=
01 | 2017-01-11 16:14:46.90043+01 | 2017-01-11 16:14:46.929003=
3;01 | f |
idle =
| select=
* from getvdsbyvdsid($1, $2, $3)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 16:06:26.377649+=
01 | 2017-01-11 16:14:45.035936+01 | 2017-01-11 16:14:45.035937+01 =
| f |
active &nb=
sp; |
select * from g=
etdisksvmguid($1, $2, $3, $4)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 16:06:40.128282+=
01 | 2017-01-11 16:12:43.764245+01 | 2017-01-11 16:12:43.764293+01 =
| f |
idle  =
;
|
select * fr=
om getqosbyqosid($1)<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">2017-01-11 16:06:40.150762+=
01 | 2017-01-11 16:10:54.629416+01 | 2017-01-11 16:10:54.629496+01 =
| f |
idle  =
;
| select * fr=
om getstoragedomainidsbystoragepoolidandstatus($1,
$2)<o:p></o:p></sp=
an></p
<p
class=3D"MsoNormal"><span lang=3D"EN-US">2017-01-11
16:14:46.934168+=
01 | 2017-01-11 16:14:46.964807+01 | 2017-01-11 16:14:46.964809+01 =
| f |
active &nb=
sp; |
select backend_start,=
query_start,state_change,waiting,state,query from pg_stat_activity;<o:p></o=
:p></span></p
<p
class=3D"MsoNormal"><span
lang=3D"EN-US"><o:p> </o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">top - 16:13:43 up 1:36,&n=
bsp; 3 users, load average: 41.62, 37.53,
21.37<o:p></o:p></span></p
<p
class=3D"MsoNormal"><span lang=3D"EN-US">Tasks: 286
total, 40 runn=
ing, 246 sleeping, 0 stopped, 0
zombie<o:p></o:p></=
span></p
<p
class=3D"MsoNormal"><span lang=3D"EN-US">%Cpu(s): 99.3
us, 0.6 sy,=
0.0 ni, 0.0 id, 0.0 wa, 0.0 hi, 0.0
si, =
; 0.0 st<o:p></o:p></span></p
<p
class=3D"MsoNormal"><span lang=3D"EN-US">KiB Mem : 16432648
total, =
3626184 free, 6746368 used, 6060096
buff/cache<o:p></o:p></spa=
n></p
<p
class=3D"MsoNormal"><span lang=3D"EN-US">KiB Swap:
5242876 total,&=
nbsp; 5242876 free,
0 used. =
8104244 avail Mem<o:p></o:p></span></p
<p
class=3D"MsoNormal"><span
lang=3D"EN-US"><o:p> </o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US"> PID USER &nbs=
p; PR NI
VIRT RES&nbs=
p; SHR S %CPU %MEM
TIME+ COMM=
AND<o:p></o:p></span></p
<p
class=3D"MsoNormal"><span lang=3D"EN-US">17328
postgres 20 &n=
bsp; 0 3485020 66760 20980 R 21.5
0.4 1=
:37.27 postgres: engine engine 127.0.0.1(35212)
SELECT<o:p></o:p></span></p=
<p class=3D"MsoNormal"><span
lang=3D"EN-US">8269 postgres 20 &nb=
sp; 0 3484796 68200 22780 R 21.2
0.4 2:=
15.36 postgres: engine engine 127.0.0.1(47116)
SELECT<o:p></o:p></span></p
<p
class=3D"MsoNormal"><span lang=3D"EN-US">9016
postgres 20 &nb=
sp; 0 3520356 279756 199452 R 21.2 1.7 7:24.29
post=
gres: engine engine 127.0.0.1(42992) SELECT<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">16878 postgres 20 &n=
bsp; 0 3498100 66160 18468 R 21.2
0.4 2=
:00.82 postgres: engine engine 127.0.0.1(34238)
SELECT<o:p></o:p></span></p=
<p class=3D"MsoNormal"><span
lang=3D"EN-US">16751 postgres 20 &n=
bsp; 0 3486388 215784 169404 R 20.9 1.3 1:56.38
pos=
tgres: engine engine 127.0.0.1(34008) SELECT<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">17868 postgres 20 &n=
bsp; 0 3487860 215472 167796 R 20.9 1.3 1:07.40
pos=
tgres: engine engine 127.0.0.1(36312) SELECT<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">8272 postgres 20 &n=
bsp;0 3490392 76912 25288 R 20.5
0.5 2:=
30.15 postgres: engine engine 127.0.0.1(47124)
SELECT<o:p></o:p></span></p
<p
class=3D"MsoNormal"><span lang=3D"EN-US">8274
postgres 20 &nb=
sp; 0 3495800 83144 26100 R 20.5
0.5 2:=
56.66 postgres: engine engine 127.0.0.1(47130)
SELECT<o:p></o:p></span></p
<p
class=3D"MsoNormal"><span lang=3D"EN-US">9015
postgres 20 &nb=
sp; 0 3523344 283388 198908 R 20.5 1.7 7:19.91
post=
gres: engine engine 127.0.0.1(42990) SELECT<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">16879 postgres 20 &n=
bsp; 0 3488296 72180 23744 R 20.5
0.4 1=
:30.01 postgres: engine engine 127.0.0.1(34242)
SELECT<o:p></o:p></span></p=
<p class=3D"MsoNormal"><span
lang=3D"EN-US">17241 postgres 20 &n=
bsp; 0 3486540 215716 168024 R 20.5 1.3 1:47.58
pos=
tgres: engine engine 127.0.0.1(35018) SELECT<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">17242 postgres 20 &n=
bsp; 0 3495864 69172 20988 R 20.5
0.4 1=
:54.09 postgres: engine engine 127.0.0.1(35022)
SELECT<o:p></o:p></span></p=
<p class=3D"MsoNormal"><span
lang=3D"EN-US">17668 postgres 20 &n=
bsp; 0 3488576 54484 15080 R 20.5
0.3 1=
:28.91 postgres: engine engine 127.0.0.1(35896)
SELECT<o:p></o:p></span></p=
<p class=3D"MsoNormal"><span
lang=3D"EN-US">8266 postgres 20 &nb=
sp; 0 3490688 222344 170852 R 20.2 1.4 2:58.95
post=
gres: engine engine 127.0.0.1(47112) SELECT<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">8268 postgres 20 &nb=
sp; 0 3503420 241888 177500 R 20.2 1.5 3:10.34
post=
gres: engine engine 127.0.0.1(47117) SELECT<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">8275 postgres 20 &nb=
sp; 0 3510316 253340 181688 R 20.2 1.5 4:12.02
post=
gres: engine engine 127.0.0.1(47132) SELECT<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">9014 postgres 20 &nb=
sp; 0 3523872 284636 199424 R 20.2 1.7 7:51.82
post=
gres: engine engine 127.0.0.1(42988) SELECT<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">9027 postgres 20 &nb=
sp; 0 3514872 265384 189656 R 20.2 1.6 5:21.63
post=
gres: engine engine 127.0.0.1(43012) SELECT<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">17546 postgres 20 &n=
bsp; 0 3475628 55248 19108 R 20.2
0.3 1=
:33.40 postgres: engine engine 127.0.0.1(35668)
SELECT<o:p></o:p></span></p=
<p class=3D"MsoNormal"><span
lang=3D"EN-US">17669 postgres 20 &n=
bsp; 0 3483284 66920 22488 R 20.2
0.4 1=
:28.01 postgres: engine engine 127.0.0.1(35898)
SELECT<o:p></o:p></span></p=
<p class=3D"MsoNormal"><span
lang=3D"EN-US">17670 postgres 20 &n=
bsp; 0 3504988 78300 22032 R 20.2
0.5 1=
:18.96 postgres: engine engine 127.0.0.1(35900)
SELECT<o:p></o:p></span></p=
<p class=3D"MsoNormal"><span
lang=3D"EN-US">17865 postgres 20 &n=
bsp; 0 3485084 66688 21316 R 20.2
0.4 1=
:14.00 postgres: engine engine 127.0.0.1(36306)
SELECT<o:p></o:p></span></p=
<p class=3D"MsoNormal"><span
lang=3D"EN-US">7869 postgres 20 &nb=
sp; 0 3492780 224272 171620 R 19.9 1.4 2:57.03
post=
gres: engine engine 127.0.0.1(46542) SELECT<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US"><o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US"><o:p> </o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">Thx Christian<o:p></o:p></span>=
</p
<p class=3D"MsoNormal"><span
lang=3D"EN-US"><o:p> </o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US"><o:p> </o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US"><o:p> </o:p></span></p
<div
<div
style=3D"border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm =
0cm 0cm"
<p
class=3D"MsoNormal"><b><span lang=3D"DE"
style=3D"mso-fareast-language:D=
E-AT">Von:</span></b><span lang=3D"DE"
style=3D"mso-fareast-language:DE-AT"=
users-bounces(a)ovirt.org [mailto:users-bounces@ovirt.org]
<b>Im Auftrag von </b>Grundmann, Christian<br
<b>Gesendet:</b> Donnerstag, 29. September 2016
15:29<br
<b>An:</b>
'users(a)ovirt.org' &lt;users(a)ovirt.org&gt;<br
<b>Betreff:</b> [ovirt-users] WG: High Database
Load after updating to oVir=
t 4.0.4<o:p></o:p></span></p
</div
</div
<p
class=3D"MsoNormal"><o:p> </o:p></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">Maybe an side effect off this b=
ug?<o:p></o:p></span></p
<p
class=3D"MsoNormal"><span
lang=3D"EN-US"><o:p> </o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US"><a href=3D"https://bugzilla.red=
hat.com/1302752">https://bugzilla.redhat.com/1302752</a><...
/p
<p class=3D"MsoNormal"><span
lang=3D"EN-US"><o:p> </o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">I did a restore to 4.0.3 and th=
e timeouts are gone<o:p></o:p></span></p
<p
class=3D"MsoNormal"><span
lang=3D"EN-US"><o:p> </o:p></span></p
<div
<div
style=3D"border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm =
0cm 0cm"
<p
class=3D"MsoNormal"><b><span lang=3D"DE"
style=3D"mso-fareast-language:D=
E-AT">Von:</span></b><span lang=3D"DE"
style=3D"mso-fareast-language:DE-AT"=
Grundmann, Christian
<br
<b>Gesendet:</b> Dienstag, 27. </span><span
lang=3D"EN-US" style=3D"mso-far=
east-language:DE-AT">September 2016 10:33<br
<b>An:</b> </span><span lang=3D"DE"
style=3D"mso-fareast-language:DE-AT"><a=
href=3D"mailto:users@ovirt.org"><span
lang=3D"EN-US">users(a)ovirt.org</span=
></a></span><span lang=3D"EN-US"
style=3D"mso-fareast-language:DE-AT"><br
<b>Betreff:</b> High Database Load after updating to oVirt
4.0.4<o:p></o:p>=
</span></p
</div
</div
<p
class=3D"MsoNormal"><span
lang=3D"EN-US"><o:p> </o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">After 4.0.4 Update we have a ve=
ry high database load during startup of VMs<o:p></o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">So high that the api calls gett=
ing timeouts<o:p></o:p></span></p
<p
class=3D"MsoNormal"><span
lang=3D"EN-US"><o:p> </o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">I attached the output of<o:p></=
o:p></span></p
<p
class=3D"MsoNormal"><span lang=3D"EN-US">select * from
pg_stat_activity&=
nbsp; <o:p></o:p></span></p
<p
class=3D"MsoNormal"><span
lang=3D"EN-US"><o:p> </o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US"><o:p> </o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">is there a way to downgrade to =
4.0.3?<o:p></o:p></span></p
<p
class=3D"MsoNormal"><span
lang=3D"EN-US"><o:p> </o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US">Thx Christian<o:p></o:p></span>=
</p
<p class=3D"MsoNormal"><span
lang=3D"EN-US"><o:p> </o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US"><o:p> </o:p></span></p
<p class=3D"MsoNormal"><span
lang=3D"EN-US"><o:p> </o:p></span></p
</div
</body
</html
--_000_6A17C71B52524C408E7AAF69103E9E490FA8E78Dfabamailserverf_--