12:10 p.m.
Le 25 avr. 2017 à 10:27, Yedidyah Bar David <didi(a)redhat.com> a
écrit :
On Tue, Apr 25, 2017 at 11:14 AM, Fabrice Bacchella
<fabrice.bacchella(a)orange.fr> wrote:
>
>> Le 25 avr. 2017 à 07:59, Yedidyah Bar David <didi(a)redhat.com> a écrit :
>>
>> On Mon, Apr 24, 2017 at 5:59 PM, Fabrice Bacchella
>> <fabrice.bacchella(a)orange.fr> wrote:
>>> https://www.dropbox.com/s/70h2ajt049i89p6/ovirt-engine.log.tar.gz?dl=0
>>
>> Seems like this wasn't the first error. Before that, the engine lost
>> connection to the database:
>>
>
>> Later the engine was restarted and then the error you reported.
>>
>> Are you sure your database is ok?
>
> Of course I needed to restart the database, to change the requested setting about
vacuum. But it was a scheduled restart, not during the upgrade.
>
>>
>> Please provide the output of 'pg_dump -s' for it, and the output of
>> 'select * from schema_version'.
>>
>
> it ? what it's name. I have no knowledge of pg, how can I connect to it to give
the requested informations.
Sorry, I was under the impression that your organization has some pg
expertise, based on the thread about remote version.
On the pg machine, this should work:
su - postgres -c 'pg_dump -s engine' > engine-schema.dump
su - postgres -c 'psql engine -c "select * from schema_version;"' >
schema-version-table
https://www.dropbox.com/s/6o51owq0f6qrdte/schema-version-table?dl=0
https://www.dropbox.com/s/luw35rlcksl3uwa/engine-schema.dump?dl=0
>
>>
>> Can you please describe the full flow that you went through?
>
> On last friday, I tried a first upgrade, but it stop because of the requested version
mismatch. So I stopped it and asked for help.
>
> On monday I tried to apply the tuning on my database about autovacuum and so restart
it.
>
> At this time, ovirt was still working fine.
>
> I then upgraded the pg client, to match pg_dump with the server but not the jdbc
library, to keep the one supported (9.2).
Please explain this last part with more details.
IIUC your pg client was 9.4.8, and now it's 9.4.11.
Please share yum logs (or whatever you have if you installed it not using yum).
Please share all engine-setup logs.
grep -i postgres /var/log/yum.log
Apr 24 13:28:00 Updated: postgresql94-libs-9.4.11-2PGDG.rhel7.x86_64
Apr 24 13:28:01 Updated: postgresql94-9.4.11-2PGDG.rhel7.x86_64
Apr 24 13:28:07 Updated: postgresql-jdbc-42.0.0-1.rhel7.noarch
Apr 24 13:28:09 Updated: postgresql94-server-9.4.11-2PGDG.rhel7.x86_64
Apr 24 13:36:48 Installed: collectd-postgresql-5.7.0-2.el7.x86_64
rpm -qa |grep -i postgres
postgresql94-libs-9.4.11-2PGDG.rhel7.x86_64
postgresql94-server-9.4.11-2PGDG.rhel7.x86_64
postgresql-jdbc-42.0.0-1.rhel7.noarch
collectd-postgresql-5.7.0-2.el7.x86_64
postgresql94-9.4.11-2PGDG.rhel7.x86_64
I think the engine should work just fine with pg 9.5 (Fedora
25's
default). Never heard about using 9.4.
>
> And then it failed and didn't want to restart any more.
So all was good until you changed (downgraded?) your pg client? So
I upgraded the client from 9.4.8 to 9.4.11, since my server was already 9.4.11, downloaded
directly from postgres' yum repo :
https://yum.postgresql.org/repopackages.php