Re: [ovirt-users] After update to 3.6.1 profile internal does not exist message
On Tue, Dec 22, 2015 at 5:29 PM, Gianluca Cecchi
wrote:
>
>
> On Mon, Dec 21, 2015 at 3:52 PM, Gianluca Cecchi <
> gianluca.cec...@gmail.com> wrote:
>
>> On Mon, Dec 21, 2015 at 2:10 PM, Yedidyah Bar David wrote:
>>
>>> On Sun, Dec 20, 2015 at 9:50 PM, Martin Perina wrote:
>>> >
>>> >
>>>
>>
>> [snip]
>>
>>
>>> >>
>>> >> So you should run engine-setup after you update this package.
>>> >>
>>> >> Martin - is this intentional? Why not update the package automatically
>>> >> during engine-setup?
>>> >>
>>> >> Or even version-lock it? I do not think people should expect their
>>> engine
>>> >> to not allow logins after they run 'yum update'. Adding also Sandro.
>>> >
>>> > Hi,
>>> >
>>> > there are several reasons for this:
>>> >
>>> > 1. aaa-jdbc is an engine 3.6 extension, engine requires its presence to
>>> >provide 'internal' domain but it doesn't require any specific
>>> version,
>>> >so users may update aaa-jdbc independently on engine if they need
>>> >features provided provided by new version
>>> >
>>> > 2. engine-setup automatically configures/upgrades 'internal' domain,
>>> but
>>> >users may define manually other domains (as described in
>>> README.admin)
>>> >and those domains are not touched by engine-setup at all
>>> >
>>> > 3. Due to 1. and 2. we decided not to define version specific
>>> requirement
>>> >between engine and aaa-jdbc in engine-setup (same behaviour as
>>> already
>>> >exists for other engine extensions). So users may for example
>>> upgrade
>>> >engine, but leave aaa-jdbc as is or leave engine as is and upgrade
>>> >aaa-jdbc if they need it. Users just need to get used to read doc
>>> >before doing upgrade.
>>>
>>> Now filed: https://bugzilla.redhat.com/show_bug.cgi?id=1293338
>>>
>>> Best,
>>> --
>>> Didi
>>>
>>
>> Thanks, I gave my contribute inside the bugzilla.
>> I personally felt this behavior could potentially break many oVirt and
>> possibly RHEV installations based on the internal profile and your action
>> seems to confirm it.
>> As a user I disagree with Martin point in 3. as I'm usually inclined to
>> read the docs but not all the READMEs provided by any single package in the
>> system. I didn't find a clear reference to this step inside the oVirt web
>> documentation, but I could be wrong. I rememebr about it only when I played
>> with FreeIPA authentication in oVirt, but not in internal usage.
>> But if this problem can become an opportunity to make both docs and users
>> better entities it's not a problem for me...
>> Gianluca
>>
>>
>
>
> In the mean time I was "able" to solve the problems following what already
> asked some days ago:
> http://lists.ovirt.org/pipermail/users/2015-December/036601.html
>
>
It just happened another time to me so it seams quite systematic and it's
worth to open a bug on it:
https://bugzilla.redhat.com/show_bug.cgi?id=1293689
> - verified no tasks on hypervisor as what found in
> business_entity_snapshot are failed attempts to import hosted engine
> storage domain
> [root@ractor ~]# vdsClient -s 0 getAllTasksStatuses
> {'status': {'message': 'OK', 'code': 0}, 'allTasksStatus': {}}
>
> - stop engine
> systemctl stop ovirt-engine
>
> - delete on db
> engine=# delete from business_entity_snapshot ;
> DELETE 3
> engine=# commit;
> COMMIT
> engine=# exit
> engine-# \q
> -bash-4.2$ exit
> logout
>
> - start engine
> systemctl start engine
>
> - update ovirt-engine-extension-aaa-jdbc
> ---> Package ovirt-engine-extension-aaa-jdbc.noarch 0:1.0.1-1.el7 will be
> updated
> ---> Package ovirt-engine-extension-aaa-jdbc.noarch 0:1.0.4-1.el7 will be
> an update
>
> - engine-setup now completes ok
> (based
> on /usr/share/doc/ovirt-engine-extension-aaa-jdbc-1.0.4/README.admin as I
> have only internal profile)
> [root@ractorshe ovirt-engine]# engine-setup
> [ INFO ] Stage: Initializing
> [ INFO ] Stage: Environment setup
> Configuration files:
> ['/etc/ovirt-engine-setup.conf.d/10-packaging-jboss.conf',
> '/etc/ovirt-engine-setup.conf.d/10-packaging.conf',
> '/etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf']
> Log file:
> /var/log/ovirt-engine/setup/ovirt-engine-setup-20151222171311-pad6e4.log
> Version: otopi-1.4.0 (otopi-1.4.0-1.el7.centos)
> [ INFO ] Stage: Environment packages setup
> [ INFO ] Stage: Programs detection
> [ INFO ] Stage: Environment setup
> [ INFO ] Stage: Environment customization
>
> --== PRODUCT OPTIONS ==--
>
>
> --== PACKAGES ==--
>
> [ INFO ] Checking for product updates...
> [ INFO ] No product updates found
>
> --== ALL IN ONE CONFIGURATION ==--
>
>
> --== NETWORK CONFIGURATION ==--
>
> [WARNING] Failed to resolve ractorshe.my.domain using DNS, it can be
> resolved only locally
> Setup can automatically configure the firewall on this system.
> Note: automatic configuration of the firewall may overwrite
> current settings.
> Do you want Setup to configure the firewal
Re: [ovirt-users] After update to 3.6.1 profile internal does not exist message
On Mon, Dec 21, 2015 at 3:52 PM, Gianluca Cecchi
wrote:
> On Mon, Dec 21, 2015 at 2:10 PM, Yedidyah Bar David wrote:
>
>> On Sun, Dec 20, 2015 at 9:50 PM, Martin Perina wrote:
>> >
>> >
>>
>
> [snip]
>
>
>> >>
>> >> So you should run engine-setup after you update this package.
>> >>
>> >> Martin - is this intentional? Why not update the package automatically
>> >> during engine-setup?
>> >>
>> >> Or even version-lock it? I do not think people should expect their
>> engine
>> >> to not allow logins after they run 'yum update'. Adding also Sandro.
>> >
>> > Hi,
>> >
>> > there are several reasons for this:
>> >
>> > 1. aaa-jdbc is an engine 3.6 extension, engine requires its presence to
>> >provide 'internal' domain but it doesn't require any specific
>> version,
>> >so users may update aaa-jdbc independently on engine if they need
>> >features provided provided by new version
>> >
>> > 2. engine-setup automatically configures/upgrades 'internal' domain, but
>> >users may define manually other domains (as described in
>> README.admin)
>> >and those domains are not touched by engine-setup at all
>> >
>> > 3. Due to 1. and 2. we decided not to define version specific
>> requirement
>> >between engine and aaa-jdbc in engine-setup (same behaviour as
>> already
>> >exists for other engine extensions). So users may for example upgrade
>> >engine, but leave aaa-jdbc as is or leave engine as is and upgrade
>> >aaa-jdbc if they need it. Users just need to get used to read doc
>> >before doing upgrade.
>>
>> Now filed: https://bugzilla.redhat.com/show_bug.cgi?id=1293338
>>
>> Best,
>> --
>> Didi
>>
>
> Thanks, I gave my contribute inside the bugzilla.
> I personally felt this behavior could potentially break many oVirt and
> possibly RHEV installations based on the internal profile and your action
> seems to confirm it.
> As a user I disagree with Martin point in 3. as I'm usually inclined to
> read the docs but not all the READMEs provided by any single package in the
> system. I didn't find a clear reference to this step inside the oVirt web
> documentation, but I could be wrong. I rememebr about it only when I played
> with FreeIPA authentication in oVirt, but not in internal usage.
> But if this problem can become an opportunity to make both docs and users
> better entities it's not a problem for me...
> Gianluca
>
>
In the mean time I was "able" to solve the problems following what already
asked some days ago:
http://lists.ovirt.org/pipermail/users/2015-December/036601.html
- verified no tasks on hypervisor as what found in business_entity_snapshot
are failed attempts to import hosted engine storage domain
[root@ractor ~]# vdsClient -s 0 getAllTasksStatuses
{'status': {'message': 'OK', 'code': 0}, 'allTasksStatus': {}}
- stop engine
systemctl stop ovirt-engine
- delete on db
engine=# delete from business_entity_snapshot ;
DELETE 3
engine=# commit;
COMMIT
engine=# exit
engine-# \q
-bash-4.2$ exit
logout
- start engine
systemctl start engine
- update ovirt-engine-extension-aaa-jdbc
---> Package ovirt-engine-extension-aaa-jdbc.noarch 0:1.0.1-1.el7 will be
updated
---> Package ovirt-engine-extension-aaa-jdbc.noarch 0:1.0.4-1.el7 will be
an update
- engine-setup now completes ok
(based on /usr/share/doc/ovirt-engine-extension-aaa-jdbc-1.0.4/README.admin
as I have only internal profile)
[root@ractorshe ovirt-engine]# engine-setup
[ INFO ] Stage: Initializing
[ INFO ] Stage: Environment setup
Configuration files:
['/etc/ovirt-engine-setup.conf.d/10-packaging-jboss.conf',
'/etc/ovirt-engine-setup.conf.d/10-packaging.conf',
'/etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf']
Log file:
/var/log/ovirt-engine/setup/ovirt-engine-setup-20151222171311-pad6e4.log
Version: otopi-1.4.0 (otopi-1.4.0-1.el7.centos)
[ INFO ] Stage: Environment packages setup
[ INFO ] Stage: Programs detection
[ INFO ] Stage: Environment setup
[ INFO ] Stage: Environment customization
--== PRODUCT OPTIONS ==--
--== PACKAGES ==--
[ INFO ] Checking for product updates...
[ INFO ] No product updates found
--== ALL IN ONE CONFIGURATION ==--
--== NETWORK CONFIGURATION ==--
[WARNING] Failed to resolve ractorshe.my.domain using DNS, it can be
resolved only locally
Setup can automatically configure the firewall on this system.
Note: automatic configuration of the firewall may overwrite
current settings.
Do you want Setup to configure the firewall? (Yes, No) [Yes]: Yes
[ INFO ] firewalld will be configured as firewall manager.
[WARNING] Failed to resolve ractorshe.my.domain using DNS, it can be
resolved only locally
[WARNING] Failed to resolve ractorshe.my.domain using DNS, it can be
resolved only locally
--== DATABASE CONFIGURATION ==--
--== OVIRT ENGINE CONFIGURATION ==--
--== STORAGE CONFIGURATION ==--
--== PKI CONFIGURATION ==--
Re: [ovirt-users] After update to 3.6.1 profile internal does not exist message
On Mon, Dec 21, 2015 at 2:10 PM, Yedidyah Bar David wrote: > On Sun, Dec 20, 2015 at 9:50 PM, Martin Perina wrote: > > > > > [snip] > >> > >> So you should run engine-setup after you update this package. > >> > >> Martin - is this intentional? Why not update the package automatically > >> during engine-setup? > >> > >> Or even version-lock it? I do not think people should expect their > engine > >> to not allow logins after they run 'yum update'. Adding also Sandro. > > > > Hi, > > > > there are several reasons for this: > > > > 1. aaa-jdbc is an engine 3.6 extension, engine requires its presence to > >provide 'internal' domain but it doesn't require any specific version, > >so users may update aaa-jdbc independently on engine if they need > >features provided provided by new version > > > > 2. engine-setup automatically configures/upgrades 'internal' domain, but > >users may define manually other domains (as described in README.admin) > >and those domains are not touched by engine-setup at all > > > > 3. Due to 1. and 2. we decided not to define version specific requirement > >between engine and aaa-jdbc in engine-setup (same behaviour as already > >exists for other engine extensions). So users may for example upgrade > >engine, but leave aaa-jdbc as is or leave engine as is and upgrade > >aaa-jdbc if they need it. Users just need to get used to read doc > >before doing upgrade. > > Now filed: https://bugzilla.redhat.com/show_bug.cgi?id=1293338 > > Best, > -- > Didi > Thanks, I gave my contribute inside the bugzilla. I personally felt this behavior could potentially break many oVirt and possibly RHEV installations based on the internal profile and your action seems to confirm it. As a user I disagree with Martin point in 3. as I'm usually inclined to read the docs but not all the READMEs provided by any single package in the system. I didn't find a clear reference to this step inside the oVirt web documentation, but I could be wrong. I rememebr about it only when I played with FreeIPA authentication in oVirt, but not in internal usage. But if this problem can become an opportunity to make both docs and users better entities it's not a problem for me... Gianluca ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] After update to 3.6.1 profile internal does not exist message
On Sun, Dec 20, 2015 at 9:50 PM, Martin Perina wrote: > > > - Original Message - >> From: "Yedidyah Bar David" >> To: "Gianluca Cecchi" , "Martin Perina" >> , "Sandro Bonazzola" >> >> Cc: "Simone Tiraboschi" , "users" >> Sent: Sunday, December 20, 2015 10:50:43 AM >> Subject: Re: [ovirt-users] After update to 3.6.1 profile internal does not >> exist message >> >> On Sun, Dec 20, 2015 at 12:45 AM, Gianluca Cecchi >> wrote: >> > On Sat, Dec 19, 2015 at 9:14 PM, Gianluca Cecchi wrote: >> >> >> >> >> >> I fear that the "yum update" command I executed after "engine-setuo" >> >> completed successfully, to update the OS to CentOS 7.2 has pulled in the >> >> package >> >> Dec 19 13:46:48 Updated: >> >> ovirt-engine-extension-aaa-jdbc-1.0.4-1.el7.noarch >> >> >> >> and has created my problems... and create similar ones to other guys... >> >> what do you think? >> >> >> >> Gianluca >> > >> > >> > >> > It was indeed the main reason for not being able to authenticate in >> > webadmin >> > portal: >> > >> > I reverted to the previous version of the package. After putting env in >> > maintenance global I executed: >> > >> > # systemctl stop ovirt-engine >> > >> > Previous version: >> > Nov 04 12:52:20 Installed: >> > ovirt-engine-extension-aaa-jdbc-1.0.1-1.el7.noarch >> > >> > # yum downgrade ovirt-engine-extension-aaa-jdbc >> > ... >> > Dependencies Resolved >> > >> > >> > Package Arch Version >> > Repository Size >> > >> > Downgrading: >> > ovirt-engine-extension-aaa-jdbc noarch 1.0.1-1.el7 >> > ovirt-3.6 165 k >> > >> > # systemctl start ovirt-engine >> > >> > and I'm able to connect again. In engine.log now >> > >> > 2015-12-19 23:38:31,352 INFO >> > [org.ovirt.engine.core.uutils.config.ShellLikeConfd] (default task-1) [] >> > Loaded file >> > '/etc/ovirt-engine/engine.conf.d/50-ovirt-engine-extension-aaa-jdbc.conf'. >> > ... >> > 2015-12-19 23:38:31,357 INFO >> > [org.ovirt.engine.core.uutils.config.ShellLikeConfd] (default task-1) [] >> > Value of property 'ENGINE_JAVA_MODULEPATH' is >> > '/usr/share/ovirt-engine-wildfly-overlay/modules:/usr/share/ovirt-engine/modules/common:/usr/share/ovirt-engine-extension-aaa-jdbc/modules'. >> > ... >> > 2015-12-19 23:38:34,355 INFO >> > [org.ovirt.engine.core.extensions.mgr.ExtensionsManager] (ServerService >> > Thread Pool -- 37) [] Instance name: 'internal-authn', Extension name: >> > '"ovirt-engine-extension-aaa-jdbc".authn', Version: '"1.0.1"', Notes: >> > 'Display name: "ovirt-engine-extension-aaa-jdbc"', License: 'ASL 2.0', >> > Home: >> > 'http://www.ovirt.org', Author 'The oVirt Project', Build interface >> > Version: >> > '0', File: '/etc/ovirt-engine/extensions.d/internal-authn.properties', >> > Initialized: 'true' >> > 2015-12-19 23:38:34,355 INFO >> > [org.ovirt.engine.core.extensions.mgr.ExtensionsManager] (ServerService >> > Thread Pool -- 37) [] Instance name: 'internal-authz', Extension name: >> > '"ovirt-engine-extension-aaa-jdbc".authz', Version: '"1.0.1"', Notes: >> > 'Display name: "ovirt-engine-extension-aaa-jdbc"', License: 'ASL 2.0', >> > Home: >> > 'http://www.ovirt.org', Author 'The oVirt Project', Build interface >> > Version: >> > '0', File: '/etc/ovirt-engine/extensions.d/internal-authz.properties', >> > Initialized: 'true' >> >> On Sat, Dec 19, 2015 at 10:14 PM, Gianluca Cecchi >> wrote: >> > On Sat, Dec 19, 2015 at 8:57 PM, Gianluca Cecchi >> > >> > wrote: >> >> >> >> >> >> >> >> but I don't understand how this c
Re: [ovirt-users] After update to 3.6.1 profile internal does not exist message
- Original Message - > From: "Yedidyah Bar David" > To: "Gianluca Cecchi" , "Martin Perina" > , "Sandro Bonazzola" > > Cc: "Simone Tiraboschi" , "users" > Sent: Sunday, December 20, 2015 10:50:43 AM > Subject: Re: [ovirt-users] After update to 3.6.1 profile internal does not > exist message > > On Sun, Dec 20, 2015 at 12:45 AM, Gianluca Cecchi > wrote: > > On Sat, Dec 19, 2015 at 9:14 PM, Gianluca Cecchi wrote: > >> > >> > >> I fear that the "yum update" command I executed after "engine-setuo" > >> completed successfully, to update the OS to CentOS 7.2 has pulled in the > >> package > >> Dec 19 13:46:48 Updated: > >> ovirt-engine-extension-aaa-jdbc-1.0.4-1.el7.noarch > >> > >> and has created my problems... and create similar ones to other guys... > >> what do you think? > >> > >> Gianluca > > > > > > > > It was indeed the main reason for not being able to authenticate in > > webadmin > > portal: > > > > I reverted to the previous version of the package. After putting env in > > maintenance global I executed: > > > > # systemctl stop ovirt-engine > > > > Previous version: > > Nov 04 12:52:20 Installed: > > ovirt-engine-extension-aaa-jdbc-1.0.1-1.el7.noarch > > > > # yum downgrade ovirt-engine-extension-aaa-jdbc > > ... > > Dependencies Resolved > > > > > > Package Arch Version > > Repository Size > > > > Downgrading: > > ovirt-engine-extension-aaa-jdbc noarch 1.0.1-1.el7 > > ovirt-3.6 165 k > > > > # systemctl start ovirt-engine > > > > and I'm able to connect again. In engine.log now > > > > 2015-12-19 23:38:31,352 INFO > > [org.ovirt.engine.core.uutils.config.ShellLikeConfd] (default task-1) [] > > Loaded file > > '/etc/ovirt-engine/engine.conf.d/50-ovirt-engine-extension-aaa-jdbc.conf'. > > ... > > 2015-12-19 23:38:31,357 INFO > > [org.ovirt.engine.core.uutils.config.ShellLikeConfd] (default task-1) [] > > Value of property 'ENGINE_JAVA_MODULEPATH' is > > '/usr/share/ovirt-engine-wildfly-overlay/modules:/usr/share/ovirt-engine/modules/common:/usr/share/ovirt-engine-extension-aaa-jdbc/modules'. > > ... > > 2015-12-19 23:38:34,355 INFO > > [org.ovirt.engine.core.extensions.mgr.ExtensionsManager] (ServerService > > Thread Pool -- 37) [] Instance name: 'internal-authn', Extension name: > > '"ovirt-engine-extension-aaa-jdbc".authn', Version: '"1.0.1"', Notes: > > 'Display name: "ovirt-engine-extension-aaa-jdbc"', License: 'ASL 2.0', > > Home: > > 'http://www.ovirt.org', Author 'The oVirt Project', Build interface > > Version: > > '0', File: '/etc/ovirt-engine/extensions.d/internal-authn.properties', > > Initialized: 'true' > > 2015-12-19 23:38:34,355 INFO > > [org.ovirt.engine.core.extensions.mgr.ExtensionsManager] (ServerService > > Thread Pool -- 37) [] Instance name: 'internal-authz', Extension name: > > '"ovirt-engine-extension-aaa-jdbc".authz', Version: '"1.0.1"', Notes: > > 'Display name: "ovirt-engine-extension-aaa-jdbc"', License: 'ASL 2.0', > > Home: > > 'http://www.ovirt.org', Author 'The oVirt Project', Build interface > > Version: > > '0', File: '/etc/ovirt-engine/extensions.d/internal-authz.properties', > > Initialized: 'true' > > On Sat, Dec 19, 2015 at 10:14 PM, Gianluca Cecchi > wrote: > > On Sat, Dec 19, 2015 at 8:57 PM, Gianluca Cecchi > > > > wrote: > >> > >> > >> > >> but I don't understand how this can influence the fact that inside the web > >> ui login I don't see any selectable value for the profile field: the > >> "internal" default domain is missing I didn't implement any other > >> > >> https://drive.google.com/file/d/0BwoPbcrMv8mvNTV1S2M3MGdKNHM/view?usp=sharing > >> > >> Gianluca > > > > > > > > the culprit could be related to these lines
Re: [ovirt-users] After update to 3.6.1 profile internal does not exist message
On Sun, Dec 20, 2015 at 12:45 AM, Gianluca Cecchi wrote: > On Sat, Dec 19, 2015 at 9:14 PM, Gianluca Cecchi wrote: >> >> >> I fear that the "yum update" command I executed after "engine-setuo" >> completed successfully, to update the OS to CentOS 7.2 has pulled in the >> package >> Dec 19 13:46:48 Updated: >> ovirt-engine-extension-aaa-jdbc-1.0.4-1.el7.noarch >> >> and has created my problems... and create similar ones to other guys... >> what do you think? >> >> Gianluca > > > > It was indeed the main reason for not being able to authenticate in webadmin > portal: > > I reverted to the previous version of the package. After putting env in > maintenance global I executed: > > # systemctl stop ovirt-engine > > Previous version: > Nov 04 12:52:20 Installed: > ovirt-engine-extension-aaa-jdbc-1.0.1-1.el7.noarch > > # yum downgrade ovirt-engine-extension-aaa-jdbc > ... > Dependencies Resolved > > > Package Arch Version > Repository Size > > Downgrading: > ovirt-engine-extension-aaa-jdbc noarch 1.0.1-1.el7 > ovirt-3.6 165 k > > # systemctl start ovirt-engine > > and I'm able to connect again. In engine.log now > > 2015-12-19 23:38:31,352 INFO > [org.ovirt.engine.core.uutils.config.ShellLikeConfd] (default task-1) [] > Loaded file > '/etc/ovirt-engine/engine.conf.d/50-ovirt-engine-extension-aaa-jdbc.conf'. > ... > 2015-12-19 23:38:31,357 INFO > [org.ovirt.engine.core.uutils.config.ShellLikeConfd] (default task-1) [] > Value of property 'ENGINE_JAVA_MODULEPATH' is > '/usr/share/ovirt-engine-wildfly-overlay/modules:/usr/share/ovirt-engine/modules/common:/usr/share/ovirt-engine-extension-aaa-jdbc/modules'. > ... > 2015-12-19 23:38:34,355 INFO > [org.ovirt.engine.core.extensions.mgr.ExtensionsManager] (ServerService > Thread Pool -- 37) [] Instance name: 'internal-authn', Extension name: > '"ovirt-engine-extension-aaa-jdbc".authn', Version: '"1.0.1"', Notes: > 'Display name: "ovirt-engine-extension-aaa-jdbc"', License: 'ASL 2.0', Home: > 'http://www.ovirt.org', Author 'The oVirt Project', Build interface Version: > '0', File: '/etc/ovirt-engine/extensions.d/internal-authn.properties', > Initialized: 'true' > 2015-12-19 23:38:34,355 INFO > [org.ovirt.engine.core.extensions.mgr.ExtensionsManager] (ServerService > Thread Pool -- 37) [] Instance name: 'internal-authz', Extension name: > '"ovirt-engine-extension-aaa-jdbc".authz', Version: '"1.0.1"', Notes: > 'Display name: "ovirt-engine-extension-aaa-jdbc"', License: 'ASL 2.0', Home: > 'http://www.ovirt.org', Author 'The oVirt Project', Build interface Version: > '0', File: '/etc/ovirt-engine/extensions.d/internal-authz.properties', > Initialized: 'true' On Sat, Dec 19, 2015 at 10:14 PM, Gianluca Cecchi wrote: > On Sat, Dec 19, 2015 at 8:57 PM, Gianluca Cecchi > wrote: >> >> >> >> but I don't understand how this can influence the fact that inside the web >> ui login I don't see any selectable value for the profile field: the >> "internal" default domain is missing I didn't implement any other >> >> https://drive.google.com/file/d/0BwoPbcrMv8mvNTV1S2M3MGdKNHM/view?usp=sharing >> >> Gianluca > > > > the culprit could be related to these lines in engine.log > > 2015-12-19 13:57:22,403 INFO > [org.ovirt.engine.core.extensions.mgr.ExtensionsManager] (ServerService > Thread Pool -- 41) [] Extension 'internal-authn' loaded > 2015-12-19 13:57:22,406 INFO > [org.ovirt.engine.core.extensions.mgr.ExtensionsManager] (ServerService > Thread Pool -- 41) [] Loading extension 'internal-authz' > 2015-12-19 13:57:22,408 INFO > [org.ovirt.engine.core.extensions.mgr.ExtensionsManager] (ServerService > Thread Pool -- 41) [] Extension 'internal-authz' loaded > 2015-12-19 13:57:22,409 INFO > [org.ovirt.engine.core.extensions.mgr.ExtensionsManager] (ServerService > Thread Pool -- 41) [] Initializing extension 'internal-authn' > 2015-12-19 13:57:22,447 ERROR > [org.ovirt.engine.extension.aaa.jdbc.binding.api.AuthnExtension] > (ServerService Thread Pool -- 41) [] Unexpected Exception invoking: > EXTENSION_INITIALIZE[e5ae1b7f-9104-4f23-a444-7b9175ff68d2] > 2015-12-19 13:57:22,447 ERROR > [org.ovirt.engine.core.extensions.mgr.ExtensionsManager] (ServerService > Thread Pool -- 41) [] Error in activating extension 'internal-authn': > Database schema is older than required by currently installed > ovirt-engine-extension-aaa-jdbc package version. Please upgrade profile > database schema before proceeding (for more info about upgrade please take a > look at README.admin file contained in ovirt-engine-extension-aaa-jdbc > package). README.admin there [1] says, among other things: === IV. Upgrading 'internal' profile ATTENTION: aaa-jdbc extension is not upg
Re: [ovirt-users] After update to 3.6.1 profile internal does not exist message
On Sat, Dec 19, 2015 at 9:14 PM, Gianluca Cecchi wrote: > > I fear that the "yum update" command I executed after "engine-setuo" > completed successfully, to update the OS to CentOS 7.2 has pulled in the > package > Dec 19 13:46:48 Updated: ovirt-engine-extension-aaa-jdbc-1.0.4-1.el7.noarch > > and has created my problems... and create similar ones to other guys... > what do you think? > > Gianluca > It was indeed the main reason for not being able to authenticate in webadmin portal: I reverted to the previous version of the package. After putting env in maintenance global I executed: # systemctl stop ovirt-engine Previous version: Nov 04 12:52:20 Installed: ovirt-engine-extension-aaa-jdbc-1.0.1-1.el7.noarch # yum downgrade ovirt-engine-extension-aaa-jdbc ... Dependencies Resolved Package Arch Version Repository Size Downgrading: ovirt-engine-extension-aaa-jdbc noarch 1.0.1-1.el7 ovirt-3.6 165 k # systemctl start ovirt-engine and I'm able to connect again. In engine.log now 2015-12-19 23:38:31,352 INFO [org.ovirt.engine.core.uutils.config.ShellLikeConfd] (default task-1) [] Loaded file '/etc/ovirt-engine/engine.conf.d/50-ovirt-engine-extension-aaa-jdbc.conf'. ... 2015-12-19 23:38:31,357 INFO [org.ovirt.engine.core.uutils.config.ShellLikeConfd] (default task-1) [] Value of property 'ENGINE_JAVA_MODULEPATH' is '/usr/share/ovirt-engine-wildfly-overlay/modules:/usr/share/ovirt-engine/modules/common:/usr/share/ovirt-engine-extension-aaa-jdbc/modules'. ... 2015-12-19 23:38:34,355 INFO [org.ovirt.engine.core.extensions.mgr.ExtensionsManager] (ServerService Thread Pool -- 37) [] Instance name: 'internal-authn', Extension name: '"ovirt-engine-extension-aaa-jdbc".authn', Version: '"1.0.1"', Notes: 'Display name: "ovirt-engine-extension-aaa-jdbc"', License: 'ASL 2.0', Home: 'http://www.ovirt.org', Author 'The oVirt Project', Build interface Version: '0', File: '/etc/ovirt-engine/extensions.d/internal-authn.properties', Initialized: 'true' 2015-12-19 23:38:34,355 INFO [org.ovirt.engine.core.extensions.mgr.ExtensionsManager] (ServerService Thread Pool -- 37) [] Instance name: 'internal-authz', Extension name: '"ovirt-engine-extension-aaa-jdbc".authz', Version: '"1.0.1"', Notes: 'Display name: "ovirt-engine-extension-aaa-jdbc"', License: 'ASL 2.0', Home: 'http://www.ovirt.org', Author 'The oVirt Project', Build interface Version: '0', File: '/etc/ovirt-engine/extensions.d/internal-authz.properties', Initialized: 'true' ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] After update to 3.6.1 profile internal does not exist message
On Sat, Dec 19, 2015 at 8:57 PM, Gianluca Cecchi
wrote:
>
>
> but I don't understand how this can influence the fact that inside the web
> ui login I don't see any selectable value for the profile field: the
> "internal" default domain is missing I didn't implement any other
>
> https://drive.google.com/file/d/0BwoPbcrMv8mvNTV1S2M3MGdKNHM/view?usp=sharing
>
> Gianluca
>
the culprit could be related to these lines in engine.log
2015-12-19 13:57:22,403 INFO
[org.ovirt.engine.core.extensions.mgr.ExtensionsManager] (ServerService
Thread Pool -- 41) [] Extension 'internal-authn' loaded
2015-12-19 13:57:22,406 INFO
[org.ovirt.engine.core.extensions.mgr.ExtensionsManager] (ServerService
Thread Pool -- 41) [] Loading extension 'internal-authz'
2015-12-19 13:57:22,408 INFO
[org.ovirt.engine.core.extensions.mgr.ExtensionsManager] (ServerService
Thread Pool -- 41) [] Extension 'internal-authz' loaded
2015-12-19 13:57:22,409 INFO
[org.ovirt.engine.core.extensions.mgr.ExtensionsManager] (ServerService
Thread Pool -- 41) [] Initializing extension 'internal-authn'
2015-12-19 13:57:22,447 ERROR
[org.ovirt.engine.extension.aaa.jdbc.binding.api.AuthnExtension]
(ServerService Thread Pool -- 41) [] Unexpected Exception invoking:
EXTENSION_INITIALIZE[e5ae1b7f-9104-4f23-a444-7b9175ff68d2]
2015-12-19 13:57:22,447 ERROR
[org.ovirt.engine.core.extensions.mgr.ExtensionsManager] (ServerService
Thread Pool -- 41) [] Error in activating extension 'internal-authn':
Database schema is older than required by currently installed
ovirt-engine-extension-aaa-jdbc package version. Please upgrade profile
database schema before proceeding (for more info about upgrade please take
a look at README.admin file contained in ovirt-engine-extension-aaa-jdbc
package).
2015-12-19 13:57:22,448 ERROR
[org.ovirt.engine.core.utils.extensionsmgr.EngineExtensionsManager]
(ServerService Thread Pool -- 41) [] Could not initialize extension
'internal-authn'. Exception message is: Class: class
org.ovirt.engine.core.extensions.mgr.ExtensionInvokeCommandFailedException
Input:
{Extkey[name=EXTENSION_INVOKE_COMMAND;type=class
org.ovirt.engine.api.extensions.ExtUUID;uuid=EXTENSION_INVOKE_COMMAND[485778ab-bede-4f1a-b823-77b262a2f28d];]=EXTENSION_INITIALIZE[e5ae1b7f-9104-4f23-a444-7b9175ff68d2],
Extkey[name=EXTENSION_INVOKE_CONTEXT;type=class
org.ovirt.engine.api.extensions.E
Full engine.log for today is here:
https://drive.google.com/file/d/0BwoPbcrMv8mvVGVxNVN4TUdQR2c/view?usp=sharing
if you can give it an eye.
I fear that the "yum update" command I executed after "engine-setuo"
completed successfully, to update the OS to CentOS 7.2 has pulled in the
package
Dec 19 13:46:48 Updated: ovirt-engine-extension-aaa-jdbc-1.0.4-1.el7.noarch
and has created my problems... and create similar ones to other guys...
what do you think?
Gianluca
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] After update to 3.6.1 profile internal does not exist message
On Sat, Dec 19, 2015 at 8:16 PM, Simone Tiraboschi wrote: > > > On Sat, Dec 19, 2015 at 7:58 PM, Oved Ourfali wrote: > >> Reading it again, I'm not sure the engine was even tested with centos 7. >> As far as I know only centos 6 is supported/tested for the engine machine. >> > Our ovirt-engine-appliance is already based on Centos 7 so I think that a > consistent part of our 3.6 upstream user is already on that. > > [root@enginevm ~]# cat /etc/redhat-release > CentOS Linux release 7.2.1511 (Core) > > > Yes, for engine VM in HE I used the oVirt shipped appliance that was already in CentOS 7.1 and the flow I was trying to complete was to update it to 7.2 as supported. >From the last output I sent it seems in some way sanlock was responsible for the detath of engineVM right after completion of engine-setup. And possibly causing any corruption inside the db If it can be of any help, here the contents of the two tables involved storage_domain_static and storage_domain_dynamic https://drive.google.com/file/d/0BwoPbcrMv8mvU0RoZjFZSzRKbzQ/view?usp=sharing If you have any othr quey to run against db but I don't understand how this can influence the fact that inside the web ui login I don't see any selectable value for the profile field: the "internal" default domain is missing I didn't implement any other https://drive.google.com/file/d/0BwoPbcrMv8mvNTV1S2M3MGdKNHM/view?usp=sharing Gianluca ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] After update to 3.6.1 profile internal does not exist message
On Sat, Dec 19, 2015 at 7:58 PM, Oved Ourfali wrote:
> Reading it again, I'm not sure the engine was even tested with centos 7.
> As far as I know only centos 6 is supported/tested for the engine machine.
>
Our ovirt-engine-appliance is already based on Centos 7 so I think that a
consistent part of our 3.6 upstream user is already on that.
[root@enginevm ~]# cat /etc/redhat-release
CentOS Linux release 7.2.1511 (Core)
> CC-ing Eli to try and help with the DB issue, but if you have any backup I
> guess it would be safer.
>
> Oved
> On Dec 19, 2015 15:15, "Gianluca Cecchi"
> wrote:
>
>> Hello.
>>
>> I updated my test self hosted engine vm to 3.6.1 and to CentOS 7.2.
>>
>> Now it seems it isn't able to to login to webadmin due to this in
>> engine.log
>> (field is empty in web admin gui)
>>
>> 2015-12-19 13:59:05,182 ERROR
>> [org.ovirt.engine.core.bll.aaa.LoginBaseCommand] (default task-17) []
>> Can't login because authentication profile 'internal' doesn't exist.
>>
>> Is it an already known problem?
>>
>> The first ERRROR message I find in it is dated 13:34 and it is an SQL one:
>>
>> 2015-12-19 13:34:39,882 ERROR [org.ovirt.engine.core.bll.Backend]
>> (ServerService Thread Pool -- 42) [] Failed to run compensation on startup
>> for Command
>> 'org.ovirt.engine.core.bll.storage.AddExistingFileStorageDomainCommand',
>> Command Id 'bb7ee4a3-6b35-4c62-9823-a434a40e5b38':
>> CallableStatementCallback; SQL [{call insertstorage_domain_dynamic(?, ?,
>> ?)}]; ERROR: insert or update on table "storage_domain_dynamic" violates
>> foreign key constraint "fk_storage_domain_dynamic_storage_domain_static"
>> Detail: Key (id)=(----) is not present
>> in table "storage_domain_static".
>> Where: SQL statement "INSERT INTO
>> storage_domain_dynamic(available_disk_size, id, used_disk_size)
>> VALUES(v_available_disk_size, v_id, v_used_disk_size)"
>> PL/pgSQL function insertstorage_domain_dynamic(integer,uuid,integer) line
>> 3 at SQL statement; nested exception is org.postgresql.util.PSQLException:
>> ERROR: insert or update on table "storage_domain_dynamic" violates foreign
>> key constraint "fk_storage_domain_dynamic_storage_domain_static"
>> Detail: Key (id)=(----) is not present
>> in table "storage_domain_static".
>> Where: SQL statement "INSERT INTO
>> storage_domain_dynamic(available_disk_size, id, used_disk_size)
>> VALUES(v_available_disk_size, v_id, v_used_disk_size)"
>> PL/pgSQL function insertstorage_domain_dynamic(integer,uuid,integer) line
>> 3 at SQL statement
>> 2015-12-19 13:34:39,882 ERROR [org.ovirt.engine.core.bll.Backend]
>> (ServerService Thread Pool -- 42) [] Exception:
>> org.springframework.dao.DataIntegrityViolationException:
>> CallableStatementCallback; SQL [{call insertstorage_domain_dynamic(?, ?,
>> ?)}]; ERROR: insert or update on table "storage_domain_dynamic" violates
>> foreign key constraint "fk_storage_domain_dynamic_storage_domain_static"
>> Detail: Key (id)=(----) is not present
>> in table "storage_domain_static".
>>
>>
>> I think it is not related to update from CentOS 7.1 to 7.2 that generates
>> an update of PostgreSQL too because it is 10 minutes later:
>> from installed one
>> Nov 04 12:55:30 Installed: postgresql-server-9.2.13-1.el7_1.x86_64
>> to 7.2 one
>> Dec 19 13:45:51 Updated: postgresql-server-9.2.14-1.el7_1.x86_64
>>
>> BTW: my order was
>>
>> yum update "ovirt-engine-setup-*"
>> engine-setup
>>
>> the engine-setup completed successfully with
>> ...
>> [ INFO ] Stage: Misc configuration
>> [ INFO ] Backing up database localhost:engine to
>> '/var/lib/ovirt-engine/backups/engine-20151219132925.5OoFQA.dump'.
>> [ INFO ] Creating/refreshing Engine database schema
>> [ INFO ] Creating/refreshing Engine 'internal' domain database schema
>> [ INFO ] Upgrading CA
>> [ INFO ] Configuring WebSocket Proxy
>> [ INFO ] Generating post install configuration file
>> '/etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf'
>> [ INFO ] Stage: Transaction commit
>> [ INFO ] Stage: Closing up
>>
>> --== SUMMARY ==--
>>
>> SSH fingerprint: 19:56:8d:3e:50:fc:90:37:5a:ba:6c:57:30:b1:7d:93
>> Internal CA
>> DA:E6:04:34:99:A0:DB:CE:3F:0A:7B:A2:96:67:4C:7F:19:CA:95:5F
>> Note! If you want to gather statistical information you can
>> install Reports and/or DWH:
>> http://www.ovirt.org/Ovirt_DWH
>> http://www.ovirt.org/Ovirt_Reports
>> Web access is enabled at:
>> http://ractorshe.mydomain:80/ovirt-engine
>> https://ractorshe.mydomain:443/ovirt-engine
>>
>> --== END OF SUMMARY ==--
>>
>> [ INFO ] Starting engine service
>> [ INFO ] Restarting httpd
>> [ INFO ] Restarting ovirt-vmconsole proxy service
>> [ INFO ] Stage: Clean up
>> Log file is located at
>> /var/log/ovirt-engine/setup/ovirt-engine-setup-20151219132415-2pfee1.log
>> [ I
Re: [ovirt-users] After update to 3.6.1 profile internal does not exist message
Reading it again, I'm not sure the engine was even tested with centos 7.
As far as I know only centos 6 is supported/tested for the engine machine.
CC-ing Eli to try and help with the DB issue, but if you have any backup I
guess it would be safer.
Oved
On Dec 19, 2015 15:15, "Gianluca Cecchi" wrote:
> Hello.
>
> I updated my test self hosted engine vm to 3.6.1 and to CentOS 7.2.
>
> Now it seems it isn't able to to login to webadmin due to this in
> engine.log
> (field is empty in web admin gui)
>
> 2015-12-19 13:59:05,182 ERROR
> [org.ovirt.engine.core.bll.aaa.LoginBaseCommand] (default task-17) []
> Can't login because authentication profile 'internal' doesn't exist.
>
> Is it an already known problem?
>
> The first ERRROR message I find in it is dated 13:34 and it is an SQL one:
>
> 2015-12-19 13:34:39,882 ERROR [org.ovirt.engine.core.bll.Backend]
> (ServerService Thread Pool -- 42) [] Failed to run compensation on startup
> for Command
> 'org.ovirt.engine.core.bll.storage.AddExistingFileStorageDomainCommand',
> Command Id 'bb7ee4a3-6b35-4c62-9823-a434a40e5b38':
> CallableStatementCallback; SQL [{call insertstorage_domain_dynamic(?, ?,
> ?)}]; ERROR: insert or update on table "storage_domain_dynamic" violates
> foreign key constraint "fk_storage_domain_dynamic_storage_domain_static"
> Detail: Key (id)=(----) is not present
> in table "storage_domain_static".
> Where: SQL statement "INSERT INTO
> storage_domain_dynamic(available_disk_size, id, used_disk_size)
> VALUES(v_available_disk_size, v_id, v_used_disk_size)"
> PL/pgSQL function insertstorage_domain_dynamic(integer,uuid,integer) line
> 3 at SQL statement; nested exception is org.postgresql.util.PSQLException:
> ERROR: insert or update on table "storage_domain_dynamic" violates foreign
> key constraint "fk_storage_domain_dynamic_storage_domain_static"
> Detail: Key (id)=(----) is not present
> in table "storage_domain_static".
> Where: SQL statement "INSERT INTO
> storage_domain_dynamic(available_disk_size, id, used_disk_size)
> VALUES(v_available_disk_size, v_id, v_used_disk_size)"
> PL/pgSQL function insertstorage_domain_dynamic(integer,uuid,integer) line
> 3 at SQL statement
> 2015-12-19 13:34:39,882 ERROR [org.ovirt.engine.core.bll.Backend]
> (ServerService Thread Pool -- 42) [] Exception:
> org.springframework.dao.DataIntegrityViolationException:
> CallableStatementCallback; SQL [{call insertstorage_domain_dynamic(?, ?,
> ?)}]; ERROR: insert or update on table "storage_domain_dynamic" violates
> foreign key constraint "fk_storage_domain_dynamic_storage_domain_static"
> Detail: Key (id)=(----) is not present
> in table "storage_domain_static".
>
>
> I think it is not related to update from CentOS 7.1 to 7.2 that generates
> an update of PostgreSQL too because it is 10 minutes later:
> from installed one
> Nov 04 12:55:30 Installed: postgresql-server-9.2.13-1.el7_1.x86_64
> to 7.2 one
> Dec 19 13:45:51 Updated: postgresql-server-9.2.14-1.el7_1.x86_64
>
> BTW: my order was
>
> yum update "ovirt-engine-setup-*"
> engine-setup
>
> the engine-setup completed successfully with
> ...
> [ INFO ] Stage: Misc configuration
> [ INFO ] Backing up database localhost:engine to
> '/var/lib/ovirt-engine/backups/engine-20151219132925.5OoFQA.dump'.
> [ INFO ] Creating/refreshing Engine database schema
> [ INFO ] Creating/refreshing Engine 'internal' domain database schema
> [ INFO ] Upgrading CA
> [ INFO ] Configuring WebSocket Proxy
> [ INFO ] Generating post install configuration file
> '/etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf'
> [ INFO ] Stage: Transaction commit
> [ INFO ] Stage: Closing up
>
> --== SUMMARY ==--
>
> SSH fingerprint: 19:56:8d:3e:50:fc:90:37:5a:ba:6c:57:30:b1:7d:93
> Internal CA
> DA:E6:04:34:99:A0:DB:CE:3F:0A:7B:A2:96:67:4C:7F:19:CA:95:5F
> Note! If you want to gather statistical information you can
> install Reports and/or DWH:
> http://www.ovirt.org/Ovirt_DWH
> http://www.ovirt.org/Ovirt_Reports
> Web access is enabled at:
> http://ractorshe.mydomain:80/ovirt-engine
> https://ractorshe.mydomain:443/ovirt-engine
>
> --== END OF SUMMARY ==--
>
> [ INFO ] Starting engine service
> [ INFO ] Restarting httpd
> [ INFO ] Restarting ovirt-vmconsole proxy service
> [ INFO ] Stage: Clean up
> Log file is located at
> /var/log/ovirt-engine/setup/ovirt-engine-setup-20151219132415-2pfee1.log
> [ INFO ] Generating answer file
> '/var/lib/ovirt-engine/setup/answers/20151219133045-setup.conf'
> [ INFO ] Stage: Pre-termination
> [ INFO ] Stage: Termination
> [ INFO ] Execution of setup completed successfully
>
> Strangely the VM was shutdown...
> In /var/log/libvirt/qemu/HostedEngine.log I saw (in UTC)
> 2015-12-19 12:31:19.494+: shutting down
>
> So I exited from global mai
Re: [ovirt-users] After update to 3.6.1 profile internal does not exist message
On Sat, Dec 19, 2015 at 2:15 PM, Gianluca Cecchi wrote: > Hello. > > I updated my test self hosted engine vm to 3.6.1 and to CentOS 7.2. > > Now it seems it isn't able to to login to webadmin due to this in > engine.log > (field is empty in web admin gui) > > 2015-12-19 13:59:05,182 ERROR > [org.ovirt.engine.core.bll.aaa.LoginBaseCommand] (default task-17) [] > Can't login because authentication profile 'internal' doesn't exist. > > Is it an already known problem? > Here the output of the engine-setup run today and completead at 13:30. https://drive.google.com/file/d/0BwoPbcrMv8mveWlPdmh6MkV5cDA/view?usp=sharing Last lines in messages something like this: Dec 19 13:30:45 ractorshe ovirt-websocket-proxy.py: ovirt-websocket-proxy[21225] INFO msg:824 - Deny non-SSL/TLS connections Dec 19 13:30:45 ractorshe journal: 2015-12-19 13:30:45,958 ovirt-websocket-proxy: INFO msg:824 - proxying from *:6100 to targets in /dummy Dec 19 13:30:45 ractorshe ovirt-websocket-proxy.py: ovirt-websocket-proxy[21225] INFO msg:824 - proxying from *:6100 to targets in /dummy Dec 19 13:30:55 ractorshe systemd: serial-getty@ttyS0.service holdoff time over, scheduling restart. Dec 19 13:30:55 ractorshe systemd: Stopping Serial Getty on ttyS0... Dec 19 13:30:55 ractorshe systemd: Starting Serial Getty on ttyS0... Dec 19 13:30:55 ractorshe systemd: Started Serial Getty on ttyS0. Dec 19 13:31:05 ractorshe systemd: serial-getty@ttyS0.service holdoff time over, scheduling restart. Dec 19 13:31:05 ractorshe systemd: Stopping Serial Getty on ttyS0... Dec 19 13:31:05 ractorshe systemd: Starting Serial Getty on ttyS0... Dec 19 13:31:05 ractorshe systemd: Started Serial Getty on ttyS0. Then I see a seven lines of this sequence: ^@^@^@^@^@^@^@^@^@^@ and then the start of the VM (cause d by leaving maintenance) Dec 19 13:34:14 ractorshe rsyslogd: [origin software="rsyslogd" swVersion="7.4.7" x-pid="484" x-info="http://www.rsyslog.com";] s tart Dec 19 13:34:14 ractorshe rsyslogd-2307: warning: ~ action is deprecated, consider using the 'stop' statement instead [try http://www.rsyslog.com/e/2307 ] Dec 19 13:34:09 ractorshe journal: Runtime journal is using 8.0M (max 794.3M, leaving 1.1G of free 7.7G, current limit 794.3M). Dec 19 13:34:09 ractorshe kernel: Initializing cgroup subsys cpuset Dec 19 13:34:09 ractorshe kernel: Initializing cgroup subsys cpu .. the shutdown was not clean because I see also this during the start Dec 19 13:34:10 ractorshe kernel: input: ImExPS/2 Generic Explorer Mouse as /devices/platform/i8042/ serio1/input/input2 Dec 19 13:34:10 ractorshe kernel: tsc: Refined TSC clocksource calibration: 2260.990 MHz Dec 19 13:34:12 ractorshe systemd-fsck: /dev/vda1: Clearing orphaned inode 272353 (uid=0, gid=0, mode=0100600, size=43056) Dec 19 13:34:12 ractorshe systemd-fsck: /dev/vda1: Clearing orphaned inode 272352 (uid=0, gid=0, mode=0100600, size=16) first lines of postgresql-Sat.log in /var/lib/pgsql/data/pg_log are: WARNING: column "user_role_title" has type "unknown" DETAIL: Proceeding with relation creation anyway. LOG: database system was interrupted; last known up at 2015-12-19 12:28:54 UTC FATAL: the database system is starting up LOG: database system was not properly shut down; automatic recovery in progress LOG: redo starts at 1/1FDFCAC8 LOG: record with zero length at 1/20A06E50 LOG: redo done at 1/20A06E20 LOG: last completed transaction was at log time 2015-12-19 12:31:19.33468+00 FATAL: the database system is starting up FATAL: the database system is starting up FATAL: the database system is starting up LOG: autovacuum launcher started LOG: database system is ready to accept connections ERROR: insert or update on table "storage_domain_dynamic" violates foreign key constraint "fk_storage_domain_dynamic_storage_domain_static" DETAIL: Key (id)=(----) is not present in table "storage_domain_static". CONTEXT: SQL statement "INSERT INTO storage_domain_dynamic(available_disk_size, id, used_disk_size) VALUES(v_available_disk_size, v_id, v_used_disk_size)" PL/pgSQL function insertstorage_domain_dynamic(integer,uuid,integer) line 3 at SQL statement STATEMENT: select * from insertstorage_domain_dynamic($1, $2, $3) as result LOG: autovacuum: found orphan temp table "pg_temp_4"."tt_temp22" in database "engine" LOG: autovacuum: found orphan temp table "pg_temp_4"."tt_temp22" in database "engine" LOG: autovacuum: found orphan temp table "pg_temp_4"."tt_temp22" in database "engine" LOG: autovacuum: found orphan temp table "pg_temp_4"."tt_temp22" in database "engine" LOG: autovacuum: found orphan temp table "pg_temp_4"."tt_temp22" in database "engine" LOG: autovacuum: found orphan temp table "pg_temp_4"."tt_temp22" in database "engine" LOG: autovacuum: found orphan temp table "pg_temp_4"."tt_temp22" in database "engine" LOG: autovacuum: found orphan temp table "pg_temp_4"."tt_temp22" in database "engine" LOG: received fast shutdown reque
