From fabrice.bacchella at orange.fr Thu Apr 20 13:50:33 2017 Content-Type: multipart/mixed; boundary="===============4485908702555974716==" MIME-Version: 1.0 From: Fabrice Bacchella To: users at ovirt.org Subject: [ovirt-users] upgrade to 4.1 Date: Thu, 20 Apr 2017 15:50:29 +0200 Message-ID: <38512329-33CA-4E01-B4FB-C2C090A55EA6@orange.fr> --===============4485908702555974716== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable --Apple-Mail=3D_C613A6BB-4998-43FE-91A3-E88EFD401FEE Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=3Dus-ascii I tried to upgrade ovirt to version 4.1 from 4.0 and got: Found the following problems in PostgreSQL configuration for =3D the Engine database: autovacuum_vacuum_scale_factor required to be at most 0.01 autovacuum_analyze_scale_factor required to be at most 0.075 autovacuum_max_workers required to be at least 6 Postgresql client version is '9.4.8', whereas the version on =3D XXX is '9.4.11'. Please use a Postgresql server of version '9.4.8'. Please set: autovacuum_vacuum_scale_factor =3D3D 0.01 autovacuum_analyze_scale_factor =3D3D 0.075 autovacuum_max_workers =3D3D 6 server_version =3D3D 9.4.8 in postgresql.conf on 'XXXX'. Its location is usually =3D /var/lib/pgsql/data , or somewhere under /etc/postgresql* . I'm a little afraid about that. Does ovirt want pg to lies about it's =3D version ? It's a shared instance so what about other tools that access =3D it ? Is there some explanation about the meaning of those values ? And it was not in the release notes, it's not funny to get this warning =3D after starting the upgrade=3D --Apple-Mail=3D_C613A6BB-4998-43FE-91A3-E88EFD401FEE Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=3Dus-ascii

I trie= d =3D to upgrade ovirt to version 4.1 from 4.0 and got:

=3D Found the following problems in PostgreSQL configuration for = =3D the Engine database:

=3D autovacuum_vacuum_scale_factor required to be at most =3D 0.01

=3D autovacuum_analyze_scale_factor required to be at most =3D 0.075

=3D autovacuum_max_workers required to be at least 6

= =3D Postgresql client version is '9.4.8', whereas the version on XXX is =3D '9.4.11'. Please use a Postgresql server of version =3D '9.4.8'.

= =3D Please set:

=3D autovacuum_vacuum_scale_factor =3D3D 0.01

=3D autovacuum_analyze_scale_factor =3D3D 0.075

= =3D autovacuum_max_workers =3D3D 6

server_version =3D3D = =3D 9.4.8

= =3D in postgresql.conf on 'XXXX'. Its location =3D is usually /var/lib/pgsql/data , or somewhere under /etc/postgresql* =3D .

I'm a little afraid about that. Does ovirt want pg to lies =3D about it's version ? It's a shared instance so what about other tools =3D that access it ? Is there some explanation about the meaning of those =3D values ?

And it= =3D was not in the release notes, it's not funny to get this warning after =3D starting the upgrade

=3D --Apple-Mail=3D_C613A6BB-4998-43FE-91A3-E88EFD401FEE-- --===============4485908702555974716== Content-Type: multipart/alternative MIME-Version: 1.0 Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="attachment.bin" Ci0tQXBwbGUtTWFpbD1fQzYxM0E2QkItNDk5OC00M0ZFLTkxQTMtRTg4RUZENDAxRkVFCkNvbnRl bnQtVHJhbnNmZXItRW5jb2Rpbmc6IHF1b3RlZC1wcmludGFibGUKQ29udGVudC1UeXBlOiB0ZXh0 L3BsYWluOwoJY2hhcnNldD11cy1hc2NpaQoKSSB0cmllZCB0byB1cGdyYWRlIG92aXJ0IHRvIHZl cnNpb24gNC4xIGZyb20gNC4wIGFuZCBnb3Q6CgogICAgICAgICAgRm91bmQgdGhlIGZvbGxvd2lu ZyBwcm9ibGVtcyBpbiBQb3N0Z3JlU1FMIGNvbmZpZ3VyYXRpb24gZm9yID0KdGhlIEVuZ2luZSBk YXRhYmFzZToKICAgICAgICAgICBhdXRvdmFjdXVtX3ZhY3V1bV9zY2FsZV9mYWN0b3IgcmVxdWly ZWQgdG8gYmUgYXQgbW9zdCAwLjAxCiAgICAgICAgICAgYXV0b3ZhY3V1bV9hbmFseXplX3NjYWxl X2ZhY3RvciByZXF1aXJlZCB0byBiZSBhdCBtb3N0IDAuMDc1CiAgICAgICAgICAgYXV0b3ZhY3V1 bV9tYXhfd29ya2VycyByZXF1aXJlZCB0byBiZSBhdCBsZWFzdCA2CiAgICAgICAgICAgUG9zdGdy ZXNxbCBjbGllbnQgdmVyc2lvbiBpcyAnOS40LjgnLCB3aGVyZWFzIHRoZSB2ZXJzaW9uIG9uID0K WFhYIGlzICc5LjQuMTEnLiBQbGVhc2UgdXNlIGEgUG9zdGdyZXNxbCBzZXJ2ZXIgb2YgdmVyc2lv biAnOS40LjgnLgogICAgICAgICAgUGxlYXNlIHNldDoKICAgICAgICAgICBhdXRvdmFjdXVtX3Zh Y3V1bV9zY2FsZV9mYWN0b3IgPTNEIDAuMDEKICAgICAgICAgICBhdXRvdmFjdXVtX2FuYWx5emVf c2NhbGVfZmFjdG9yID0zRCAwLjA3NQogICAgICAgICAgIGF1dG92YWN1dW1fbWF4X3dvcmtlcnMg PTNEIDYKICAgICAgICAgICBzZXJ2ZXJfdmVyc2lvbiA9M0QgOS40LjgKICAgICAgICAgIGluIHBv c3RncmVzcWwuY29uZiBvbiAnWFhYWCcuIEl0cyBsb2NhdGlvbiBpcyB1c3VhbGx5ID0KL3Zhci9s aWIvcGdzcWwvZGF0YSAsIG9yIHNvbWV3aGVyZSB1bmRlciAvZXRjL3Bvc3RncmVzcWwqIC4KCkkn bSBhIGxpdHRsZSBhZnJhaWQgYWJvdXQgdGhhdC4gRG9lcyBvdmlydCB3YW50IHBnIHRvIGxpZXMg YWJvdXQgaXQncyA9CnZlcnNpb24gPyBJdCdzIGEgc2hhcmVkIGluc3RhbmNlIHNvIHdoYXQgYWJv dXQgb3RoZXIgdG9vbHMgdGhhdCBhY2Nlc3MgPQppdCA/IElzIHRoZXJlIHNvbWUgZXhwbGFuYXRp b24gYWJvdXQgdGhlIG1lYW5pbmcgb2YgdGhvc2UgdmFsdWVzID8KCkFuZCBpdCB3YXMgbm90IGlu IHRoZSByZWxlYXNlIG5vdGVzLCBpdCdzIG5vdCBmdW5ueSB0byBnZXQgdGhpcyB3YXJuaW5nID0K YWZ0ZXIgc3RhcnRpbmcgdGhlIHVwZ3JhZGU9CgotLUFwcGxlLU1haWw9X0M2MTNBNkJCLTQ5OTgt NDNGRS05MUEzLUU4OEVGRDQwMUZFRQpDb250ZW50LVRyYW5zZmVyLUVuY29kaW5nOiBxdW90ZWQt cHJpbnRhYmxlCkNvbnRlbnQtVHlwZTogdGV4dC9odG1sOwoJY2hhcnNldD11cy1hc2NpaQoKPGh0 bWw+PGhlYWQ+PG1ldGEgaHR0cC1lcXVpdj0zRCJDb250ZW50LVR5cGUiIGNvbnRlbnQ9M0QidGV4 dC9odG1sID0KY2hhcnNldD0zRHVzLWFzY2lpIj48L2hlYWQ+PGJvZHkgc3R5bGU9M0Qid29yZC13 cmFwOiBicmVhay13b3JkOyA9Ci13ZWJraXQtbmJzcC1tb2RlOiBzcGFjZTsgLXdlYmtpdC1saW5l LWJyZWFrOiBhZnRlci13aGl0ZS1zcGFjZTsiID0KY2xhc3M9M0QiIj48ZGl2IHN0eWxlPTNEIm1h cmdpbjogMHB4OyBmb250LXNpemU6IDExcHg7IGxpbmUtaGVpZ2h0OiA9Cm5vcm1hbDsgZm9udC1m YW1pbHk6IE1lbmxvOyIgY2xhc3M9M0QiIj48c3BhbiA9CnN0eWxlPTNEImZvbnQtdmFyaWFudC1s aWdhdHVyZXM6IG5vLWNvbW1vbi1saWdhdHVyZXMiIGNsYXNzPTNEIiI+SSB0cmllZCA9CnRvIHVw Z3JhZGUgb3ZpcnQgdG8gdmVyc2lvbiA0LjEgZnJvbSA0LjAgYW5kIGdvdDo8L3NwYW4+PC9kaXY+ PGRpdiA9CnN0eWxlPTNEIm1hcmdpbjogMHB4OyBmb250LXNpemU6IDExcHg7IGxpbmUtaGVpZ2h0 OiBub3JtYWw7IGZvbnQtZmFtaWx5OiA9Ck1lbmxvOyIgY2xhc3M9M0QiIj48c3BhbiBzdHlsZT0z RCJmb250LXZhcmlhbnQtbGlnYXR1cmVzOiA9Cm5vLWNvbW1vbi1saWdhdHVyZXMiIGNsYXNzPTNE IiI+PGJyIGNsYXNzPTNEIiI+PC9zcGFuPjwvZGl2PjxkaXYgPQpzdHlsZT0zRCJtYXJnaW46IDBw eDsgZm9udC1zaXplOiAxMXB4OyBsaW5lLWhlaWdodDogbm9ybWFsOyBmb250LWZhbWlseTogPQpN ZW5sbzsiIGNsYXNzPTNEIiI+PHNwYW4gc3R5bGU9M0QiZm9udC12YXJpYW50LWxpZ2F0dXJlczog PQpuby1jb21tb24tbGlnYXR1cmVzIiBjbGFzcz0zRCIiPiZuYnNwOyAmbmJzcDsgJm5ic3A7ICZu YnNwOyA9CiZuYnNwOyZuYnNwO0ZvdW5kIHRoZSBmb2xsb3dpbmcgcHJvYmxlbXMgaW4gUG9zdGdy ZVNRTCBjb25maWd1cmF0aW9uIGZvciA9CnRoZSBFbmdpbmUgZGF0YWJhc2U6PC9zcGFuPjwvZGl2 PjxkaXYgc3R5bGU9M0QibWFyZ2luOiAwcHg7IGZvbnQtc2l6ZTogPQoxMXB4OyBsaW5lLWhlaWdo dDogbm9ybWFsOyBmb250LWZhbWlseTogTWVubG87IiBjbGFzcz0zRCIiPjxzcGFuID0Kc3R5bGU9 M0QiZm9udC12YXJpYW50LWxpZ2F0dXJlczogbm8tY29tbW9uLWxpZ2F0dXJlcyIgPQpjbGFzcz0z RCIiPiZuYnNwOyZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgPQphdXRvdmFjdXVt X3ZhY3V1bV9zY2FsZV9mYWN0b3IgcmVxdWlyZWQgdG8gYmUgYXQgbW9zdCA9CjAuMDE8L3NwYW4+ PC9kaXY+PGRpdiBzdHlsZT0zRCJtYXJnaW46IDBweDsgZm9udC1zaXplOiAxMXB4OyA9CmxpbmUt aGVpZ2h0OiBub3JtYWw7IGZvbnQtZmFtaWx5OiBNZW5sbzsiIGNsYXNzPTNEIiI+PHNwYW4gPQpz dHlsZT0zRCJmb250LXZhcmlhbnQtbGlnYXR1cmVzOiBuby1jb21tb24tbGlnYXR1cmVzIiA9CmNs YXNzPTNEIiI+Jm5ic3A7Jm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyA9CmF1dG92 YWN1dW1fYW5hbHl6ZV9zY2FsZV9mYWN0b3IgcmVxdWlyZWQgdG8gYmUgYXQgbW9zdCA9CjAuMDc1 PC9zcGFuPjwvZGl2PjxkaXYgc3R5bGU9M0QibWFyZ2luOiAwcHg7IGZvbnQtc2l6ZTogMTFweDsg PQpsaW5lLWhlaWdodDogbm9ybWFsOyBmb250LWZhbWlseTogTWVubG87IiBjbGFzcz0zRCIiPjxz cGFuID0Kc3R5bGU9M0QiZm9udC12YXJpYW50LWxpZ2F0dXJlczogbm8tY29tbW9uLWxpZ2F0dXJl cyIgPQpjbGFzcz0zRCIiPiZuYnNwOyZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsg PQphdXRvdmFjdXVtX21heF93b3JrZXJzIHJlcXVpcmVkIHRvIGJlIGF0IGxlYXN0IDY8L3NwYW4+ PC9kaXY+PGRpdiA9CnN0eWxlPTNEIm1hcmdpbjogMHB4OyBmb250LXNpemU6IDExcHg7IGxpbmUt aGVpZ2h0OiBub3JtYWw7IGZvbnQtZmFtaWx5OiA9Ck1lbmxvOyIgY2xhc3M9M0QiIj48c3BhbiBz dHlsZT0zRCJmb250LXZhcmlhbnQtbGlnYXR1cmVzOiA9Cm5vLWNvbW1vbi1saWdhdHVyZXMiIGNs YXNzPTNEIiI+Jm5ic3A7Jm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyA9ClBvc3Rn cmVzcWwgY2xpZW50IHZlcnNpb24gaXMgJzkuNC44Jywgd2hlcmVhcyB0aGUgdmVyc2lvbiBvbiBY WFggaXMgPQonOS40LjExJy4gUGxlYXNlIHVzZSBhIFBvc3RncmVzcWwgc2VydmVyIG9mIHZlcnNp b24gPQonOS40LjgnLjwvc3Bhbj48L2Rpdj48ZGl2IHN0eWxlPTNEIm1hcmdpbjogMHB4OyBmb250 LXNpemU6IDExcHg7ID0KbGluZS1oZWlnaHQ6IG5vcm1hbDsgZm9udC1mYW1pbHk6IE1lbmxvOyIg Y2xhc3M9M0QiIj48c3BhbiA9CnN0eWxlPTNEImZvbnQtdmFyaWFudC1saWdhdHVyZXM6IG5vLWNv bW1vbi1saWdhdHVyZXMiIGNsYXNzPTNEIiI+Jm5ic3A7ID0KJm5ic3A7ICZuYnNwOyAmbmJzcDsg Jm5ic3A7IFBsZWFzZSBzZXQ6PC9zcGFuPjwvZGl2PjxkaXYgc3R5bGU9M0QibWFyZ2luOiA9CjBw eDsgZm9udC1zaXplOiAxMXB4OyBsaW5lLWhlaWdodDogbm9ybWFsOyBmb250LWZhbWlseTogTWVu bG87IiA9CmNsYXNzPTNEIiI+PHNwYW4gc3R5bGU9M0QiZm9udC12YXJpYW50LWxpZ2F0dXJlczog bm8tY29tbW9uLWxpZ2F0dXJlcyIgPQpjbGFzcz0zRCIiPiZuYnNwOyZuYnNwOyAmbmJzcDsgJm5i c3A7ICZuYnNwOyAmbmJzcDsgPQphdXRvdmFjdXVtX3ZhY3V1bV9zY2FsZV9mYWN0b3IgPTNEIDAu MDE8L3NwYW4+PC9kaXY+PGRpdiBzdHlsZT0zRCJtYXJnaW46ID0KMHB4OyBmb250LXNpemU6IDEx cHg7IGxpbmUtaGVpZ2h0OiBub3JtYWw7IGZvbnQtZmFtaWx5OiBNZW5sbzsiID0KY2xhc3M9M0Qi Ij48c3BhbiBzdHlsZT0zRCJmb250LXZhcmlhbnQtbGlnYXR1cmVzOiBuby1jb21tb24tbGlnYXR1 cmVzIiA9CmNsYXNzPTNEIiI+Jm5ic3A7Jm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNw OyA9CmF1dG92YWN1dW1fYW5hbHl6ZV9zY2FsZV9mYWN0b3IgPTNEIDAuMDc1PC9zcGFuPjwvZGl2 PjxkaXYgPQpzdHlsZT0zRCJtYXJnaW46IDBweDsgZm9udC1zaXplOiAxMXB4OyBsaW5lLWhlaWdo dDogbm9ybWFsOyBmb250LWZhbWlseTogPQpNZW5sbzsiIGNsYXNzPTNEIiI+PHNwYW4gc3R5bGU9 M0QiZm9udC12YXJpYW50LWxpZ2F0dXJlczogPQpuby1jb21tb24tbGlnYXR1cmVzIiBjbGFzcz0z RCIiPiZuYnNwOyZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgPQphdXRvdmFjdXVt X21heF93b3JrZXJzID0zRCA2PC9zcGFuPjwvZGl2PjxkaXYgc3R5bGU9M0QibWFyZ2luOiAwcHg7 ID0KZm9udC1zaXplOiAxMXB4OyBsaW5lLWhlaWdodDogbm9ybWFsOyBmb250LWZhbWlseTogTWVu bG87IiA9CmNsYXNzPTNEIiI+PHNwYW4gc3R5bGU9M0QiZm9udC12YXJpYW50LWxpZ2F0dXJlczog bm8tY29tbW9uLWxpZ2F0dXJlcyIgPQpjbGFzcz0zRCIiPiZuYnNwOyZuYnNwOyAmbmJzcDsgJm5i c3A7ICZuYnNwOyAmbmJzcDsgc2VydmVyX3ZlcnNpb24gPTNEID0KOS40Ljg8L3NwYW4+PC9kaXY+ PGRpdiBzdHlsZT0zRCJtYXJnaW46IDBweDsgZm9udC1zaXplOiAxMXB4OyA9CmxpbmUtaGVpZ2h0 OiBub3JtYWw7IGZvbnQtZmFtaWx5OiBNZW5sbzsiIGNsYXNzPTNEIiI+PHNwYW4gPQpzdHlsZT0z RCJmb250LXZhcmlhbnQtbGlnYXR1cmVzOiBuby1jb21tb24tbGlnYXR1cmVzIiBjbGFzcz0zRCIi PiZuYnNwOyA9CiZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyBpbiBwb3N0Z3Jlc3FsLmNvbmYg b24gJ1hYWFgnLiBJdHMgbG9jYXRpb24gPQppcyB1c3VhbGx5IC92YXIvbGliL3Bnc3FsL2RhdGEg LCBvciBzb21ld2hlcmUgdW5kZXIgL2V0Yy9wb3N0Z3Jlc3FsKiA9Ci48L3NwYW4+PC9kaXY+PGRp diBjbGFzcz0zRCIiPjxzcGFuIHN0eWxlPTNEImZvbnQtdmFyaWFudC1saWdhdHVyZXM6ID0Kbm8t Y29tbW9uLWxpZ2F0dXJlcyIgY2xhc3M9M0QiIj48YnIgY2xhc3M9M0QiIj48L3NwYW4+PC9kaXY+ PGRpdiA9CmNsYXNzPTNEIiI+PHNwYW4gc3R5bGU9M0QiZm9udC12YXJpYW50LWxpZ2F0dXJlczog bm8tY29tbW9uLWxpZ2F0dXJlcyIgPQpjbGFzcz0zRCIiPkknbSBhIGxpdHRsZSBhZnJhaWQgYWJv dXQgdGhhdC4gRG9lcyBvdmlydCB3YW50IHBnIHRvIGxpZXMgPQphYm91dCBpdCdzIHZlcnNpb24g PyBJdCdzIGEgc2hhcmVkIGluc3RhbmNlIHNvIHdoYXQgYWJvdXQgb3RoZXIgdG9vbHMgPQp0aGF0 IGFjY2VzcyBpdCA/IElzIHRoZXJlIHNvbWUgZXhwbGFuYXRpb24gYWJvdXQgdGhlIG1lYW5pbmcg b2YgdGhvc2UgPQp2YWx1ZXMgPzwvc3Bhbj48L2Rpdj48ZGl2IGNsYXNzPTNEIiI+PHNwYW4gPQpz dHlsZT0zRCJmb250LXZhcmlhbnQtbGlnYXR1cmVzOiBuby1jb21tb24tbGlnYXR1cmVzIiBjbGFz cz0zRCIiPjxiciA9CmNsYXNzPTNEIiI+PC9zcGFuPjwvZGl2PjxkaXYgY2xhc3M9M0QiIj48c3Bh biA9CnN0eWxlPTNEImZvbnQtdmFyaWFudC1saWdhdHVyZXM6IG5vLWNvbW1vbi1saWdhdHVyZXMi IGNsYXNzPTNEIiI+QW5kIGl0ID0Kd2FzIG5vdCBpbiB0aGUgcmVsZWFzZSBub3RlcywgaXQncyBu b3QgZnVubnkgdG8gZ2V0IHRoaXMgd2FybmluZyBhZnRlciA9CnN0YXJ0aW5nIHRoZSB1cGdyYWRl PC9zcGFuPjwvZGl2PjwvYm9keT48L2h0bWw+PQoKLS1BcHBsZS1NYWlsPV9DNjEzQTZCQi00OTk4 LTQzRkUtOTFBMy1FODhFRkQ0MDFGRUUtLQo= --===============4485908702555974716==--