[ovirt-users] terminating sessions

[Ravi Nori]

We do not display the information on running tasks or command in the UI.

The information is used internally by engine to keep session alive if there
are commands running for a session. The list of sessions and the associated
commands can be retrieved by running the following sql

su - postgres -c 'psql engine -c "select engine_session_id, command_id,
command_type, command_params_class from command_entities, engine_sessions,
status where command_entities.engine_session_seq_id = engine_sessions.id;"'


On Wed, May 24, 2017 at 6:29 AM, Martin Perina <mperina at redhat.com> wrote:

> AFAIK content of Tasks tab in webadmin should be available under
> /ovirt-engine/api/jobs , but sessions are not exposed to API.
>
> On Wed, May 24, 2017 at 11:58 AM, Fabrice Bacchella <
> fabrice.bacchella at orange.fr> wrote:
>
>> And tasks are not available through the REST API, I think.
>>
>> Le 24 mai 2017 à 11:07, Martin Perina <mperina at redhat.com> a écrit :
>>
>> Hi,
>>
>> there is no direct link between sessions and commands executed by them in
>> UI. You can take a look into Tasks tab in bottom right corner, if there are
>> any long running tasks.
>>
>> Ravi, would it be possible to display sessionId inside Tasks to be able
>> to identify which command belongs to which session?
>>
>>
>> Martin Perina
>>
>>
>> On Wed, May 24, 2017 at 9:21 AM, Fabrice Bacchella <
>> fabrice.bacchella at orange.fr> wrote:
>>
>>> No one has the answer ?
>>>
>>> Le 18 mai 2017 à 09:58, Sandro Bonazzola <sbonazzo at redhat.com> a écrit :
>>>
>>> Adding some people who may be able to answer
>>>
>>> On Wed, May 17, 2017 at 11:45 AM, Fabrice Bacchella <
>>> fabrice.bacchella at orange.fr> wrote:
>>>
>>>> I'm back with a long list of sessions, many of them started since many
>>>> days. How can I get informations about them ?
>>>>
>>>> > Le 3 mai 2017 à 18:52, Fabrice Bacchella <fabrice.bacchella at orange.fr>
>>>> a écrit :
>>>> >
>>>> > In the UI, I see 73 open sessions, all open by me.
>>>> >
>>>> > In ovirt logs, I see a lot of :
>>>> > 2017-05-03 18:49:31,483+02 INFO  [org.ovirt.engine.core.bll.aaa.SessionDataContainer]
>>>> (DefaultQuartzScheduler3) [dcf02fc4-72c3-4237-8855-d4e474766088] Not
>>>> removing session 'B/GWJOxyLh3pXQPPitfCk29iiJ3XW
>>>> MerYdNmOdZyc9ceqD+oAW/hhhZDXCltK+N4yRo9TgunhGR7w7YEELOI5A==', session
>>>> has running commands for user 'XXXX'.
>>>> >
>>>> > And indeed I can't close those sessions in the UI.
>>>> >
>>>> >
>>>> > I have two questions:
>>>> >
>>>> > Are those sessions accessible using the API ?
>>>> > How to know what running command is waiting ?
>>>> >
>>>>
>>>
>>>
>>>
>> _______________________________________________
>> Users mailing list
>> Users at ovirt.org
>> http://lists.ovirt.org/mailman/listinfo/users
>>
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20170525/fd8ce5d7/attachment.html>