id,summary,reporter,owner,description,type,status,priority,milestone,component,version,resolution,keywords,cc,drp_resources,i_links,o_links,remaining_time,sprint 12242,Bug: broken upgrade of nightshade,jamoore,jballanco-x,"The re-indexing of the nightshade clone is currently stuck due to a bug in a very old upgrade script: {{{ OMERO4__0/OMERO3A__11.sql:UPDATE annotation SET discriminator = '/basic/text/uri/' WHERE discriminator = '/basic/text/ur;/'; }}} Having this invalid discriminator leads to: {{{ 2014-04-26 00:01:00,228 ERROR [ org.quartz.core.JobRunShell] (2-thread-4) Job DEFAULT.fullTextThreadRun threw an unhandled Exception: org.springframework.scheduling.quartz.JobMethodInvocationFailedException: Invocation of method 'run' on target class [class ome.services.fulltext.FullTextThread] failed; nested exception is ome.conditions.ValidationException: Object with id: 56453 was not of the specified subclass: ome.model.annotations.Annotation (Discriminator: /basic/text/url/); nested exception is org.hibernate.WrongClassException: Object with id: 56453 was not of the specified subclass: ome.model.annotations.Annotation (Discriminator: /basic/text/url/) }}} In addition, even if the above line *had* worked properly, it would have left the `entitytype` column in `eventlog` invalid. Here's the list of classes that will lead to warnings if present in `eventlog`: {{{ $ comm -2 -3 ns_event_classes current_classes ome.model.annotations.DatasetAnnotation ome.model.annotations.ImageAnnotation ome.model.annotations.UrlAnnotation ome.model.containers.Category ome.model.containers.CategoryGroup ome.model.containers.CategoryGroupCategoryLink ome.model.containers.CategoryImageLink ome.model.core.PixelsDimensions ome.model.display.Color }}}",task,closed,blocker,5.0.2,ORM,5.0.1,fixed,,mtbcarroll khgillen jballanco-x ajpatterson jburel,,,,0,