[ovirt-devel] Issues Running Engine Setup Related to Database Autovacuum Settings

[Greg Sheremeta]

On Fri, Jan 13, 2017 at 4:57 PM, Greg Sheremeta <gshereme at redhat.com> wrote:

> I saw something similar.
>
> Also, it's a poor user experience to have these checked one by one and
> keep dying for each one. There should be some up front check for all of
> them, give the user a chance to fix them, and recheck without having to
> enter the db credentials again.
>

I did eventually get past it, so Philip, you might have a typo on the last
one. (At least 6, whereas the others are at most X?)

It's still an undesirable UX though.

[ ERROR ] Cannot connect to Engine database: Engine requires
autovacuum_vacuum_scale_factor to be at most 0.01. Please fix
autovacuum_vacuum_scale_factor in postgresql.conf on localhost before you
continue. Its location is usually /var/lib/pgsql/data , or somewhere under
/etc/postgresql* .
          Engine database host [localhost]:
          Engine database port [5432]:
          Engine database secured connection (Yes, No) [No]:
          Engine database name [engine]: enginetemp
          Engine database user [engine]:
          Engine database password:
[ ERROR ] Cannot connect to Engine database: Engine requires
autovacuum_analyze_scale_factor to be at most 0.075. Please fix
autovacuum_analyze_scale_factor in postgresql.conf on localhost before you
continue. Its location is usually /var/lib/pgsql/data , or somewhere under
/etc/postgresql* .
          Engine database host [localhost]:
          Engine database port [5432]:
          Engine database secured connection (Yes, No) [No]:
          Engine database name [engine]: enginetemp
          Engine database user [engine]:
          Engine database password:
[ ERROR ] Cannot connect to Engine database: Engine requires
autovacuum_max_workers to be at least 6. Please fix autovacuum_max_workers
in postgresql.conf on localhost before you continue. Its location is
usually /var/lib/pgsql/data , or somewhere under /etc/postgresql* .
          Engine database host [localhost]:
          Engine database port [5432]:
          Engine database secured connection (Yes, No) [No]:
          Engine database name [engine]:
          Engine database user [engine]:
          Engine database password:

          --== OVIRT ENGINE CONFIGURATION ==--

          Engine admin password:
          Confirm engine admin password:
          Application mode (Virt, Gluster, Both) [Both]:

<snip>
[ INFO  ] Execution of setup completed successfully


>
>
> On Jan 13, 2017 4:47 PM, "Phillip Bailey" <phbailey at redhat.com> wrote:
>
> Hi team,
>
> I'm having trouble running engine-setup on a fresh database. When I first
> ran setup I received a message prompting me to update the
> autovacuum_vacuum_scale_factor, which I did. I then received another
> prompting me to update the autovacuum_analyze_scale_factor, which I also
> did. The next prompted me to update the autovacuum_max_workers to a value
> of at least 6. I have tried changing the value to both 6 and 7 multiple
> times, but it doesn't acknowledge that the change has been made and won't
> let me proceed with setup.
>
> Could someone tell me if I'm doing something wrong or if this is an issue
> with the new feature?
>
> Thanks!
>
> -Phillip Bailey
>
>
>


-- 
Greg Sheremeta, MBA
Red Hat, Inc.
Sr. Software Engineer
gshereme at redhat.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/devel/attachments/20170113/ca2ca902/attachment.html>