Unused "Home Sapiens" annotation?

[joshmoore]

idr=> select distinct annotation_id, name, value from annotation_mapvalue where (name = 'Organism' and value = 'Homo sapiensx' or value = 'Homo Sapiens');
 annotation_id |   name   |    value
---------------+----------+--------------
      16564093 | Organism | Homo Sapiens
(1 row)

[jamoore@test73-omeroreadwrite ~]$ /opt/omero/server/OMERO.server/bin/omero hql 'select el from EventLog el where entityId = 16564093'
Using session for public@localhost:4064. Idle timeout: 10 min. Current group: Public
 # | Class     | Id        | action | entityId | entityType                                | event
---+-----------+-----------+--------+----------+-------------------------------------------+------------------
...
 3 | EventLogI | 391698750 | INSERT | 16564093 | ome.model.annotations.MapAnnotation       | EventI:130976605

[jamoore@test73-omeroreadwrite ~]$ /opt/omero/server/OMERO.server/bin/omero hql 'select l from ome.model.IAnnotationLink l where l.child.id = 16564093'

shows nothing.

 # | Class  | Id        | experimenterGroup    | experimenter    | session          | type         | time
---+--------+-----------+----------------------+-----------------+------------------+--------------+--------------------------
 0 | EventI | 130976605 | ExperimenterGroupI:3 | ExperimenterI:2 | SessionI:4178906 | EventTypeI:4 | Tue Feb  5 13:31:47 2019
(1 row)

[francesw]

Not sure where annotation_id number comes from or links to. If removing it has no impact on anything, then this will be fine. In any case, value should be "Homo sapiens".

[sbesson]

Same thoughts here, happy for the orphaned Homo Sapiens annotation to be cleaned from the system (prod81 ?). Depending on time, we could look into reviewing and cleaning all other orphaned map annotations on the production system.

[sbesson]

As discussed this morning, deleted the orphaned Organism annotation

[sbesson@prod83-omeroreadwrite ~]$ /opt/omero/server/OMERO.server/bin/omero hql "select m from MapAnnotation m join m.mapValue as mv where m.ns='openmicroscopy.org/mapr/organism' and mv.value='Homo Sapiens'"
Using session for demo@localhost:4064. Idle timeout: 10 min. Current group: Public
 # | Class          | Id       | details         | ns                               
---+----------------+----------+-----------------+----------------------------------
 0 | MapAnnotationI | 16564093 | owner=2;group=3 | openmicroscopy.org/mapr/organism 
(1 row)

To see details for object, enter line number.
To move ahead one page, enter 'p'
To re-display list, enter 'r'.
To quit, enter 'q' or just enter.
q
[sbesson@prod83-omeroreadwrite ~]$ /opt/omero/server/OMERO.server/bin/omero hql 'select l from ome.model.IAnnotationLink l where l.child.id = 16564093'
Using session for demo@localhost:4064. Idle timeout: 10 min. Current group: Public
 # 
---
(0 rows)

To see details for object, enter line number.
To move ahead one page, enter 'p'
To re-display list, enter 'r'.
To quit, enter 'q' or just enter.

[sbesson@prod83-omeroreadwrite ~]$ /opt/omero/server/OMERO.server/bin/omero delete MapAnnotation:16564093
Using session for demo@localhost:4064. Idle timeout: 10 min. Current group: Public
omero.cmd.Delete2 MapAnnotation:16564093 ok
[sbesson@prod83-omeroreadwrite ~]$