Clear the Servers List

[Lylian b]

Hi all !

We finished to configure all nodes on our opencast system. As you can see on the capture :

The server who are offline are unused now. How can i clear these offline servers from the list ?

Best regards,

Lylian.

[Greg Logan]

Hi Lylian,

Unfortunately removing them is difficult.  They have to stay there unless you're willing to remove the jobs they ran, and that requires editing the core jobs database table by hand!  It's generally considered easier to just live with them, or to clear the entire jobs table at a convenient time, but then you lose your workflow history - the episodes will still show up in the admin ui, but you will not be able to see what jobs ran during processing.

G

--
To unsubscribe from this group and stop receiving emails from it, send an email to users+un...@opencast.org.

[Lylian b]

Hi Greg,

Thank you for your answer. edited the database table by hand and now it's nice.

Best regards,

Lylian.

[Lars Kiesow]

Hi,
just a slight correction for future references:

> They have to stay there unless you're willing to remove the jobs they
> ran, and that requires editing the core jobs database table by hand!

In Opencast's database, there is a connect between host registration,
service registration and jobs built with `on delete cascade` to easily
remove a host with all its services and jobs.

This means that dropping an entry from the host registration table will
remove the host just fine *but* it will also remove the services and
the jobs. This means that you loose all data about workflows run on
these nodes.

These data is still present in Elasticsearch though, meaning that just
deleting a host from the database means that you have inconsistent data
in your Opencast. To fix that, rebuild *at least* the solr workflow
index, the admin interface index and the external API index
(my recommendation: just rebuild all indexes).

In general, it's a good idea to just mess with the database if you
really know what you are doing. In this case, you could also just
disable the host using the REST interface which would have removed it
from the admin interface while keeping the data.

Best regards,
Lars

[Lylian b]

Hi Lars,

Thank you for your advice, i didn't specify that we never ran any workflow with these host. I also rebuilt the solr index for security.

Best regards,

Lylian.

[Ruben Gaspar]

Hi Lars,

Please could you let me know the exact API call you mentioned on this thread? I am now in a similar situation.

Thank you,

Ruben

[Lars Kiesow]

Hi Ruben,
the REST call I meant is:
POST /services/unregisterhost

You can easily access it from the REST docs:
https://develop.opencast.org/docs.html?path=/services#unregisterhost-12

Again: Be aware of side effects.

Best regards,
Lars