Multi GroupExperimenterMaps with default = true cause weird exception

[jamoore]

20:37:34,089 INFO  [ServiceHandler] Excp:       org.springframework.orm.hibernate3.HibernateSystemException: More than one row with the given identifier was found: 50, for class: ome.model.meta.Experimenter; nested exception is org.hibernate.HibernateException: More than one row with the given identifier was found: 50, for class: ome.model.meta.Experimenter

is thrown during the (new) AddGroupTask while calling setGroupOwner()->userProxy() if a user has multiple default groups. This is a known weakness, but is the first example of consequences of not controlling the value. This needs validation.

omero3=# select * from groupexperimentermap where child = 50;
 id  | owner_id | group_id | creation_id | update_id | permissions | external_id | version | defaultgrouplink | child | parent
-----+----------+----------+-------------+-----------+-------------+-------------+---------+------------------+-------+--------
  80 |        0 |        1 |         988 |       988 |          -1 |             |       0 | t                |    50 |      1
 195 |       53 |        1 |           0 |         0 |          -1 |             |       0 | t                |    50 |     53
(2 rows)

[jmoore]

​http://forums.hibernate.org/viewtopic.php?p=2185257

[jmoore]

This is no longer possible. With the changes outlined in UpgradeGuide_3_0_Beta3, the group experimenter map has no default field.

[jmoore]

That's wiki:UpgradeGuide_3_0_Beta3