Bug: Large query failure on event reload during save

[jamoore]

See attached stack. Caused by events being re-loaded on merge.

This is also occurring for experimenters, etc.

[jmoore]

OMEROGateway.createObject(OMEROGateway.java:2151)
	... 10 more
Caused by: omero.InternalException
    serverStackTrace = "ome.conditions.InternalException:  Wrapped Exception: (org.springframework.orm.hibernate3.HibernateJdbcException):
                        JDBC exception on Hibernate data access: SQLException for SQL [select event0_.id as id109_144_, event0_.containingEvent as containi5_109_144_, event0_.external_id as external6_109_144_, event0_.permissions as permissi2_109_144_, event0_.experimenter as experime7_109_144_, event0_.experimenterGroup as experime8_109_144_, event0_."session" as session9_109_144_, event0_.status as status109_144_, event0_.time as time109_144_, event0_.type as type109_144_, event1_.id as id109_0_, event1_.containingEvent as containi5_109_0_, event1_.external_id as external6_109_0_, event1_.permissions as permissi2_109_0_, event1_.experimenter as experime7_109_0_, event1_.experimenterGroup as experime8_109_0_, event1_."session" as session9_109_0_, event1_.status as status109_0_, event1_.time as time109_0_, event1_.type as type109_0_, externalin2_.id as id49_1_, externalin2_.creation_id as creation7_49_1_, externalin2_.external_id as external8_49_1_, externalin2_.group_id as group9_49_1_, externalin2_.owner_id as owner10_49_1_, externalin2_.permissions as permissi2_49_1_, externalin2_.entityId as entityId49_1_, externalin2_.entityType as entityType49_1_, externalin2_.lsid as lsid49_1_, externalin2_.uuid as uuid49_1_, event3_.id as id109_2_, event3_.containingEvent as containi5_109_2_, event3_.external_id as external6_109_2_, event3_.permissions as permissi2_109_2_, event3_.experimenter as experime7_109_2_, event3_.experimenterGroup as experime8_109_2_, event3_."session" as session9_109_2_, event3_.status as status109_2_, event3_.time as time109_2_, event3_.type as type109_2_, experiment4_.id as id107_3_, experiment4_.external_id as external10_107_3_, experiment4_.permissions as permissi2_107_3_, experiment4_.email as email107_3_, experiment4_.firstName as firstName107_3_, experiment4_.institution as institut5_107_3_, experiment4_.lastName as lastName107_3_, experiment4_.middleName as middleName107_3_, experiment4_.omeName as omeName107_3_, experiment4_.version as version107_3_, annotation5_.parent as parent107_146_, annotation5_.id as id146_, annotation5_.id as id79_4_, annotation5_.child as child79_4_, annotation5_.creation_id as creation5_79_4_, annotation5_.external_id as external6_79_4_, annotation5_.group_id as group7_79_4_, annotation5_.owner_id as owner8_79_4_, annotation5_.permissions as permissi2_79_4_, annotation5_.update_id as update9_79_4_, annotation5_.parent as parent79_4_, annotation5_.version as version79_4_, annotation6_.id as id12_5_, to_char(annotation6_.description) as descript3_12_5_, annotation6_.creation_id as creation12_12_5_, annotation6_.external_id as external13_12_5_, annotation6_.group_id as group14_12_5_, annotation6_.owner_id as owner15_12_5_, annotation6_.permissions as permissi4_12_5_, annotation6_.update_id as update16_12_5_, annotation6_.ns as ns12_5_, annotation6_.version as version12_5_, annotation6_.timeValue as timeValue12_5_, to_char(annotation6_.textValue) as textValue12_5_, annotation6_.boolValue as boolValue12_5_, annotation6_."file" as file17_12_5_, annotation6_.thumbnail as thumbnail12_5_, annotation6_.longValue as longValue12_5_, annotation6_.doubleValue as doubleV11_12_5_, annotation6_.discriminator as discrimi1_12_5_, event7_.id as id109_6_, event7_.containingEvent as containi5_109_6_, event7_.external_id as external6_109_6_, event7_.permissions as permissi2_109_6_, event7_.experimenter as experime7_109_6_, event7_.experimenterGroup as experime8_109_6_, event7_."session" as session9_109_6_, event7_.status as status109_6_, event7_.time as time109_6_, event7_.type as type109_6_, experiment8_.id as id32_7_, to_char(experiment8_.description) as descript2_32_7_, experiment8_.creation_id as creation6_32_7_, experiment8_.external_id as external7_32_7_, experiment8_.group_id as group8_32_7_, experiment8_.owner_id as owner9_32_7_, experiment8_.permissions as permissi3_32_7_, experiment8_.update_id as update10_32_7_, experiment8_.name as name32_7_, experiment8_.version as version32_7_, event9_.id as id109_8_, event9_.containingEvent as containi5_109_8_, event9_.external_id as external6_109_8_, event9_.permissions as permissi2_109_8_, event9_.experimenter as experime7_109_8_, event9_.experimenterGroup as experime8_109_8_, event9_."session" as session9_109_8_, event9_.status as status109_8_, event9_.time as time109_8_, event9_.type as type109_8_, session10_.id as id54_9_, session10_.closed as closed54_9_, session10_.defaultEventType as defaultE3_54_9_, session10_.defaultPermissions as defaultP4_54_9_, session10_.external_id as external13_54_9_, session10_.permissions as permissi5_54_9_, to_char(session10_.message) as message54_9_, session10_.node as node54_9_, session10_.owner as owner54_9_, session10_.started as started54_9_, session10_.timeToIdle as timeToIdle54_9_, session10_.timeToLive as timeToLive54_9_, session10_.userAgent as userAgent54_9_, session10_.uuid as uuid54_9_, session10_.version as version54_9_, session10_1_.active as active55_9_, session10_1_.data as data55_9_, session10_1_.itemCount as itemCount55_9_, case when session10_1_.session_id is not null then 1 when session10_.id is not null then 0 end as clazz_9_, externalin11_.id as id49_10_, externalin11_.creation_id as creation7_49_10_, externalin11_.external_id as external8_49_10_, externalin11_.group_id as group9_49_10_, externalin11_.owner_id as owner10_49_10_, externalin11_.permissions as permissi2_49_10_, externalin11_.entityId as entityId49_10_, externalin11_.entityType as entityType49_10_, externalin11_.lsid as lsid49_10_, externalin11_.uuid as uuid49_10_, externalin12_.id as id49_11_, externalin12_.creation_id as creation7_49_11_, externalin12_.external_id as external8_49_11_, externalin12_.group_id as group9_49_11_, externalin12_.owner_id as owner10_49_11_, externalin12_.permissions as permissi2_49_11_, externalin12_.entityId as entityId49_11_, externalin12_.entityType as entityType49_11_, externalin12_.lsid as lsid49_11_, externalin12_.uuid as uuid49_11_, experiment13_.id as id32_12_, to_char(experiment13_.description) as descript2_32_12_, experiment13_.creation_id as creation6_32_12_, experiment13_.external_id as external7_32_12_, experiment13_.group_id as group8_32_12_, experiment13_.owner_id as owner9_32_12_, experiment13_.permissions as permissi3_32_12_, experiment13_.update_id as update10_32_12_, experiment13_.name as name32_12_, experiment13_.version as version32_12_, externalin14_.id as id49_13_, externalin14_.creation_id as creation7_49_13_, externalin14_.external_id as external8_49_13_, externalin14_.group_id as group9_49_13_, externalin14_.owner_id as owner10_49_13_, externalin14_.permissions as permissi2_49_13_, externalin14_.entityId as entityId49_13_, externalin14_.entityType as entityType49_13_, externalin14_.lsid as lsid49_13_, externalin14_.uuid as uuid49_13_, experiment15_.id as id107_14_, experiment15_.external_id as external10_107_14_, experiment15_.permissions as permissi2_107_14_, experiment15_.email as email107_14_, experiment15_.firstName as firstName107_14_, experiment15_.institution as institut5_107_14_, experiment15_.lastName as lastName107_14_, experiment15_.middleName as middleName107_14_, experiment15_.omeName as omeName107_14_, experiment15_.version as version107_14_, externalin16_.id as id49_15_, externalin16_.creation_id as creation7_49_15_, externalin16_.external_id as external8_49_15_, externalin16_.group_id as group9_49_15_, externalin16_.owner_id as owner10_49_15_, externalin16_.permissions as permissi2_49_15_, externalin16_.entityId as entityId49_15_, externalin16_.entityType as entityType49_15_, externalin16_.lsid as lsid49_15_, externalin16_.uuid as uuid49_15_, experiment17_.id as id32_16_, to_char(experiment17_.description) as descript2_32_16_, experiment17_.creation_id as creation6_32_16_, experiment17_.external_id as external7_32_16_, experiment17_.group_id as group8_32_16_, experiment17_.owner_id as owner9_32_16_, experiment17_.permissions as permissi3_32_16_, experiment17_.update_id as update10_32_16_, experiment17_.name as name32_16_, experiment17_.version as version32_16_, experiment18_.id as id107_17_, experiment18_.external_id as external10_107_17_, experiment18_.permissions as permissi2_107_17_, experiment18_.email as email107_17_, experiment18_.firstName as firstName107_17_, experiment18_.institution as institut5_107_17_, experiment18_.lastName as lastName107_17_, experiment18_.middleName as middleName107_17_, experiment18_.omeName as omeName107_17_, experiment18_.version as version107_17_, event19_.id as id109_18_, event19_.containingEvent as containi5_109_18_, event19_.external_id as external6_109_18_, event19_.permissions as permissi2_109_18_, event19_.experimenter as experime7_109_18_, event19_.experimenterGroup as experime8_109_18_, event19_."session" as session9_109_18_, event19_.status as status109_18_, event19_.time as time109_18_, event19_.type as type109_18_, eventtype20_.id as id37_19_, eventtype20_.creation_id as creation4_37_19_, eventtype20_.external_id as external5_37_19_, eventtype20_.group_id as group6_37_19_, eventtype20_.owner_id as owner7_37_19_, eventtype20_.permissions as permissi2_37_19_, eventtype20_.value as value37_19_, event21_.id as id109_20_, event21_.containingEvent as containi5_109_20_, event21_.external_id as external6_109_20_, event21_.permissions as permissi2_109_20_, event21_.experimenter as experime7_109_20_, event21_.experimenterGroup as experime8_109_20_, event21_."session" as session9_109_20_, event21_.status as status109_20_, event21_.time as time109_20_, event21_.type as type109_20_, externalin22_.id as id49_21_, externalin22_.creation_id as creation7_49_21_, externalin22_.external_id as external8_49_21_, externalin22_.group_id as group9_49_21_, externalin22_.owner_id as owner10_49_21_, externalin22_.permissions as permissi2_49_21_, externalin22_.entityId as entityId49_21_, externalin22_.entityType as entityType49_21_, externalin22_.lsid as lsid49_21_, externalin22_.uuid as uuid49_21_, experiment23_.id as id32_22_, to_char(experiment23_.description) as descript2_32_22_, experiment23_.creation_id as creation6_32_22_, experiment23_.external_id as external7_32_22_, experiment23_.group_id as group8_32_22_, experiment23_.owner_id as owner9_32_22_, experiment23_.permissions as permissi3_32_22_, experiment23_.update_id as update10_32_22_, experiment23_.name as name32_22_, experiment23_.version as version32_22_, experiment24_.id as id107_23_, experiment24_.external_id as external10_107_23_, experiment24_.permissions as permissi2_107_23_, experiment24_.email as email107_23_, experiment24_.firstName as firstName107_23_, experiment24_.institution as institut5_107_23_, experiment24_.lastName as lastName107_23_, experiment24_.middleName as middleName107_23_, experiment24_.omeName as omeName107_23_, experiment24_.version as version107_23_, node25_.id as id93_24_, node25_.conn as conn93_24_, node25_.external_id as external9_93_24_, node25_.permissions as permissi3_93_24_, node25_.down as down93_24_, node25_.scale as scale93_24_, node25_.up as up93_24_, node25_.uuid as uuid93_24_, node25_.version as version93_24_, externalin26_.id as id49_25_, externalin26_.creation_id as creation7_49_25_, externalin26_.external_id as external8_49_25_, externalin26_.group_id as group9_49_25_, externalin26_.owner_id as owner10_49_25_, externalin26_.permissions as permissi2_49_25_, externalin26_.entityId as entityId49_25_, externalin26_.entityType as entityType49_25_, externalin26_.lsid as lsid49_25_, externalin26_.uuid as uuid49_25_, experiment27_.id as id107_26_, experiment27_.external_id as external10_107_26_, experiment27_.permissions as permissi2_107_26_, experiment27_.email as email107_26_, experiment27_.firstName as firstName107_26_, experiment27_.institution as institut5_107_26_, experiment27_.lastName as lastName107_26_, experiment27_.middleName as middleName107_26_, experiment27_.omeName as omeName107_26_, experiment27_.version as version107_26_, externalin28_.id as id49_27_, externalin28_.creation_id as creation7_49_27_, externalin28_.external_id as external8_49_27_, externalin28_.group_id as group9_49_27_, externalin28_.owner_id as owner10_49_27_, externalin28_.permissions as permissi2_49_27_, externalin28_.entityId as entityId49_27_, externalin28_.entityType as entityType49_27_, externalin28_.lsid as lsid49_27_, externalin28_.uuid as uuid49_27_, experiment29_.id as id32_28_, to_char(experiment29_.description) as descript2_32_28_, experiment29_.creation_id as creation6_32_28_, experiment29_.external_id as external7_32_28_, experiment29_.group_id as group8_32_28_, experiment29_.owner_id as owner9_32_28_, experiment29_.permissions as permissi3_32_28_, experiment29_.update_id as update10_32_28_, experiment29_.name as name32_28_, experiment29_.version as version32_28_, experiment30_.id as id107_29_, experiment30_.external_id as external10_107_29_, experiment30_.permissions as permissi2_107_29_, experiment30_.email as email107_29_, experiment30_.firstName as firstName107_29_, experiment30_.institution as institut5_107_29_, experiment30_.lastName as lastName107_29_, experiment30_.middleName as middleName107_29_, experiment30_.omeName as omeName107_29_, experiment30_.version as version107_29_, event31_.id as id109_30_, event31_.containingEvent as containi5_109_30_, event31_.external_id as external6_109_30_, event31_.permissions as permissi2_109_30_, event31_.experimenter as experime7_109_30_, event31_.experimenterGroup as experime8_109_30_, event31_."session" as session9_109_30_, event31_.status as status109_30_, event31_.time as time109_30_, event31_.type as type109_30_, originalfi32_.id as id73_31_, originalfi32_.atime as atime73_31_, originalfi32_.ctime as ctime73_31_, originalfi32_.creation_id as creation11_73_31_, originalfi32_.external_id as external12_73_31_, originalfi32_.group_id as group13_73_31_, originalfi32_.owner_id as owner14_73_31_, originalfi32_.permissions as permissi4_73_31_, originalfi32_.update_id as update15_73_31_, originalfi32_.format as format73_31_, originalfi32_.mtime as mtime73_31_, originalfi32_.name as name73_31_, originalfi32_.path as path73_31_, originalfi32_.sha1 as sha8_73_31_, originalfi32_."size" as size9_73_31_, originalfi32_.version as version73_31_, event33_.id as id109_32_, event33_.containingEvent as containi5_109_32_, event33_.external_id as external6_109_32_, event33_.permissions as permissi2_109_32_, event33_.experimenter as experime7_109_32_, event33_.experimenterGroup as experime8_109_32_, event33_."session" as session9_109_32_, event33_.status as status109_32_, event33_.time as time109_32_, event33_.type as type109_32_, externalin34_.id as id49_33_, externalin34_.creation_id as creation7_49_33_, externalin34_.external_id as external8_49_33_, externalin34_.group_id as group9_49_33_, externalin34_.owner_id as owner10_49_33_, externalin34_.permissions as permissi2_49_33_, externalin34_.entityId as entityId49_33_, externalin34_.entityType as entityType49_33_, externalin34_.lsid as lsid49_33_, externalin34_.uuid as uuid49_33_, experiment35_.id as id32_34_, to_char(experiment35_.description) as descript2_32_34_, experiment35_.creation_id as creation6_32_34_, experiment35_.external_id as external7_32_34_, experiment35_.group_id as group8_32_34_, experiment35_.owner_id as owner9_32_34_, experiment35_.permissions as permissi3_32_34_, experiment35_.update_id as update10_32_34_, experiment35_.name as name32_34_, experiment35_.version as version32_34_, experiment36_.id as id107_35_, experiment36_.external_id as external10_107_35_, experiment36_.permissions as permissi2_107_35_, experiment36_.email as email107_35_, experiment36_.firstName as firstName107_35_, experiment36_.institution as institut5_107_35_, experiment36_.lastName as lastName107_35_, experiment36_.middleName as middleName107_35_, experiment36_.omeName as omeName107_35_, experiment36_.version as version107_35_, event37_.id as id109_36_, event37_.containingEvent as containi5_109_36_, event37_.external_id as external6_109_36_, event37_.permissions as permissi2_109_36_, event37_.experimenter as experime7_109_36_, event37_.experimenterGroup as experime8_109_36_, event37_."session" as session9_109_36_, event37_.status as status109_36_, event37_.time as time109_36_, event37_.type as type109_36_, format38_.id as id92_37_, format38_.creation_id as creation4_92_37_, format38_.external_id as external5_92_37_, format38_.group_id as group6_92_37_, format38_.owner_id as owner7_92_37_, format38_.permissions as permissi2_92_37_, format38_.value as value92_37_, event39_.id as id109_38_, event39_.containingEvent as containi5_109_38_, event39_.external_id as external6_109_38_, event39_.permissions as permissi2_109_38_, event39_.experimenter as experime7_109_38_, event39_.experimenterGroup as experime8_109_38_, event39_."session" as session9_109_38_, event39_.status as status109_38_, event39_.time as time109_38_, event39_.type as type109_38_, externalin40_.id as id49_39_, externalin40_.creation_id as creation7_49_39_, externalin40_.external_id as external8_49_39_, externalin40_.group_id as group9_49_39_, externalin40_.owner_id as owner10_49_39_, externalin40_.permissions as permissi2_49_39_, externalin40_.entityId as entityId49_39_, externalin40_.entityType as entityType49_39_, externalin40_.lsid as lsid49_39_, externalin40_.uuid as uuid49_39_, experiment41_.id as id32_40_, to_char(experiment41_.description) as descript2_32_40_, experiment41_.creation_id as creation6_32_40_, experiment41_.external_id as external7_32_40_, experiment41_.group_id as group8_32_40_, experiment41_.owner_id as owner9_32_40_, experiment41_.permissions as permissi3_32_40_, experiment41_.update_id as update10_32_40_, experiment41_.name as name32_40_, experiment41_.version as version32_40_, experiment42_.id as id107_41_, experiment42_.external_id as external10_107_41_, experiment42_.permissions as permissi2_107_41_, experiment42_.email as email107_41_, experiment42_.firstName as firstName107_41_, experiment42_.institution as institut5_107_41_, experiment42_.lastName as lastName107_41_, experiment42_.middleName as middleName107_41_, experiment42_.omeName as omeName107_41_, experiment42_.version as version107_41_, thumbnail43_.id as id6_42_, thumbnail43_.creation_id as creation8_6_42_, thumbnail43_.external_id as external9_6_42_, thumbnail43_.group_id as group10_6_42_, thumbnail43_.owner_id as owner11_6_42_, thumbnail43_.permissions as permissi2_6_42_, thumbnail43_.update_id as update12_6_42_, thumbnail43_.mimeType as mimeType6_42_, thumbnail43_.pixels as pixels6_42_, thumbnail43_."ref" as ref4_6_42_, thumbnail43_.sizeX as sizeX6_42_, thumbnail43_.sizeY as sizeY6_42_, thumbnail43_.version as version6_42_, event44_.id as id109_43_, event44_.containingEvent as containi5_109_43_, event44_.external_id as external6_109_43_, event44_.permissions as permissi2_109_43_, event44_.experimenter as experime7_109_43_, event44_.experimenterGroup as experime8_109_43_, event44_."session" as session9_109_43_, event44_.status as status109_43_, event44_.time as time109_43_, event44_.type as type109_43_, externalin45_.id as id49_44_, externalin45_.creation_id as creation7_49_44_, externalin45_.external_id as external8_49_44_, externalin45_.group_id as group9_49_44_, externalin45_.owner_id as owner10_49_44_, externalin45_.permissions as permissi2_49_44_, externalin45_.entityId as entityId49_44_, externalin45_.entityType as entityType49_44_, externalin45_.lsid as lsid49_44_, externalin45_.uuid as uuid49_44_, experiment46_.id as id32_45_, to_char(experiment46_.description) as descript2_32_45_, experiment46_.creation_id as creation6_32_45_, experiment46_.external_id as external7_32_45_, experiment46_.group_id as group8_32_45_, experiment46_.owner_id as owner9_32_45_, experiment46_.permissions as permissi3_32_45_, experiment46_.update_id as update10_32_45_, experiment46_.name as name32_45_, experiment46_.version as version32_45_, experiment47_.id as id107_46_, experiment47_.external_id as external10_107_46_, experiment47_.permissions as permissi2_107_46_, experiment47_.email as email107_46_, experiment47_.firstName as firstName107_46_, experiment47_.institution as institut5_107_46_, experiment47_.lastName as lastName107_46_, experiment47_.middleName as middleName107_46_, experiment47_.omeName as omeName107_46_, experiment47_.version as version107_46_, event48_.id as id109_47_, event48_.containingEvent as containi5_109_47_, event48_.external_id as external6_109_47_, event48_.permissions as permissi2_109_47_, event48_.experimenter as experime7_109_47_, event48_.experimenterGroup as experime8_109_47_, event48_."session" as session9_109_47_, event48_.status as status109_47_, event48_.time as time109_47_, event48_.type as type109_47_, pixels49_.id as id46_48_, pixels49_.creation_id as creation17_46_48_, pixels49_.external_id as external18_46_48_, pixels49_.group_id as group19_46_48_, pixels49_.owner_id as owner20_46_48_, pixels49_.permissions as permissi2_46_48_, pixels49_.update_id as update21_46_48_, pixels49_.dimensionOrder as dimensi22_46_48_, pixels49_.image as image46_48_, pixels49_.methodology as methodol3_46_48_, pixels49_.physicalSizeX as physical4_46_48_, pixels49_.physicalSizeY as physical5_46_48_, pixels49_.physicalSizeZ as physical6_46_48_, pixels49_.pixelsType as pixelsType46_48_, pixels49_.relatedTo as relatedTo46_48_, pixels49_.sha1 as sha7_46_48_, pixels49_.sizeC as sizeC46_48_, pixels49_.sizeT as sizeT46_48_, pixels49_.sizeX as sizeX46_48_, pixels49_.sizeY as sizeY46_48_, pixels49_.sizeZ as sizeZ46_48_, pixels49_.timeIncrement as timeInc13_46_48_, pixels49_.version as version46_48_, pixels49_.waveIncrement as waveInc15_46_48_, pixels49_.waveStart as waveStart46_48_, event50_.id as id109_49_, event50_.containingEvent as containi5_109_49_, event50_.external_id as external6_109_49_, event50_.permissions as permissi2_109_49_, event50_.experimenter as experime7_109_49_, event50_.experimenterGroup as experime8_109_49_, event50_."session" as session9_109_49_, event50_.status as status109_49_, event50_.time as time109_49_, event50_.type as type109_49_, externalin51_.id as id49_50_, externalin51_.creation_id as creation7_49_50_, externalin51_.external_id as external8_49_50_, externalin51_.group_id as group9_49_50_, externalin51_.owner_id as owner10_49_50_, externalin51_.permissions as permissi2_49_50_, externalin51_.entityId as entityId49_50_, externalin51_.entityType as entityType49_50_, externalin51_.lsid as lsid49_50_, externalin51_.uuid as uuid49_50_, experiment52_.id as id32_51_, to_char(experiment52_.description) as descript2_32_51_, experiment52_.creation_id as creation6_32_51_, experiment52_.external_id as external7_32_51_, experiment52_.group_id as group8_32_51_, experiment52_.owner_id as owner9_32_51_, experiment52_.permissions as permissi3_32_51_, experiment52_.update_id as update10_32_51_, experiment52_.name as name32_51_, experiment52_.version as version32_51_, experiment53_.id as id107_52_, experiment53_.external_id as external10_107_52_, experiment53_.permissions as permissi2_107_52_, experiment53_.email as email107_52_, experiment53_.firstName as firstName107_52_, experiment53_.institution as institut5_107_52_, experiment53_.lastName as lastName107_52_, experiment53_.middleName as middleName107_52_, experiment53_.omeName as omeName107_52_, experiment53_.version as version107_52_, event54_.id as id109_53_, event54_.containingEvent as containi5_109_53_, event54_.external_id as external6_109_53_, event54_.permissions as permissi2_109_53_, event54_.experimenter as experime7_109_53_, event54_.experimenterGroup as experime8_109_53_, event54_."session" as session9_109_53_, event54_.status as status109_53_, event54_.time as time109_53_, event54_.type as type109_53_, dimensiono55_.id as id56_54_, dimensiono55_.creation_id as creation4_56_54_, dimensiono55_.external_id as external5_56_54_, dimensiono55_.group_id as group6_56_54_, dimensiono55_.owner_id as owner7_56_54_, dimensiono55_.permissions as permissi2_56_54_, dimensiono55_.value as value56_54_, event56_.id as id109_55_, event56_.containingEvent as containi5_109_55_, event56_.external_id as external6_109_55_, event56_.permissions as permissi2_109_55_, event56_.experimenter as experime7_109_55_, event56_.experimenterGroup as experime8_109_55_, event56_."session" as session9_109_55_, event56_.status as status109_55_, event56_.time as time109_55_, event56_.type as type109_55_, externalin57_.id as id49_56_, externalin57_.creation_id as creation7_49_56_, externalin57_.external_id as external8_49_56_, externalin57_.group_id as group9_49_56_, externalin57_.owner_id as owner10_49_56_, externalin57_.permissions as permissi2_49_56_, externalin57_.entityId as entityId49_56_, externalin57_.entityType as entityType49_56_, externalin57_.lsid as lsid49_56_, externalin57_.uuid as uuid49_56_, experiment58_.id as id32_57_, to_char(experiment58_.description) as descript2_32_57_, experiment58_.creation_id as creation6_32_57_, experiment58_.external_id as external7_32_57_, experiment58_.group_id as group8_32_57_, experiment58_.owner_id as owner9_32_57_, experiment58_.permissions as permissi3_32_57_, experiment58_.update_id as update10_32_57_, experiment58_.name as name32_57_, experiment58_.version as version32_57_, experiment59_.id as id107_58_, experiment59_.external_id as external10_107_58_, experiment59_.permissions as permissi2_107_58_, experiment59_.email as email107_58_, experiment59_.firstName as firstName107_58_, experiment59_.institution as institut5_107_58_, experiment59_.lastName as lastName107_58_, experiment59_.middleName as middleName107_58_, experiment59_.omeName as omeName107_58_, experiment59_.version as version107_58_, image60_.id as id28_59_, image60_.acquisitionDate as acquisit2_28_59_, image60_.archived as archived28_59_, to_char(image60_.description) as descript4_28_59_, image60_.creation_id as creation8_28_59_, image60_.external_id as external9_28_59_, image60_.group_id as group10_28_59_, image60_.owner_id as owner11_28_59_, image60_.permissions as permissi5_28_59_, image60_.update_id as update12_28_59_, image60_.experiment as experiment28_59_, image60_.imagingEnvironment as imaging14_28_59_, image60_.instrument as instrument28_59_, image60_.name as name28_59_, image60_.objectiveSettings as objecti16_28_59_, image60_.stageLabel as stageLabel28_59_, image60_.version as version28_59_, event61_.id as id109_60_, event61_.containingEvent as containi5_109_60_, event61_.external_id as external6_109_60_, event61_.permissions as permissi2_109_60_, event61_.experimenter as experime7_109_60_, event61_.experimenterGroup as experime8_109_60_, event61_."session" as session9_109_60_, event61_.status as status109_60_, event61_.time as time109_60_, event61_.type as type109_60_, externalin62_.id as id49_61_, externalin62_.creation_id as creation7_49_61_, externalin62_.external_id as external8_49_61_, externalin62_.group_id as group9_49_61_, externalin62_.owner_id as owner10_49_61_, externalin62_.permissions as permissi2_49_61_, externalin62_.entityId as entityId49_61_, externalin62_.entityType as entityType49_61_, externalin62_.lsid as lsid49_61_, externalin62_.uuid as uuid49_61_, experiment63_.id as id32_62_, to_char(experiment63_.description) as descript2_32_62_, experiment63_.creation_id as creation6_32_62_, experiment63_.external_id as external7_32_62_, experiment63_.group_id as group8_32_62_, experiment63_.owner_id as owner9_32_62_, experiment63_.permissions as permissi3_32_62_, experiment63_.update_id as update10_32_62_, experiment63_.name as name32_62_, experiment63_.version as version32_62_, experiment64_.id as id107_63_, experiment64_.external_id as external10_107_63_, experiment64_.permissions as permissi2_107_63_, experiment64_.email as email107_63_, experiment64_.firstName as firstName107_63_, experiment64_.institution as institut5_107_63_, experiment64_.lastName as lastName107_63_, experiment64_.middleName as middleName107_63_, experiment64_.omeName as omeName107_63_, experiment64_.version as version107_63_, event65_.id as id109_64_, event65_.containingEvent as containi5_109_64_, event65_.external_id as external6_109_64_, event65_.permissions as permissi2_109_64_, event65_.experimenter as experime7_109_64_, event65_.experimenterGroup as experime8_109_64_, event65_."session" as session9_109_64_, event65_.status as status109_64_, event65_.time as time109_64_, event65_.type as type109_64_, experiment66_.id as id98_65_, to_char(experiment66_.description) as descript2_98_65_, experiment66_.creation_id as creation5_98_65_, experiment66_.external_id as external6_98_65_, experiment66_.group_id as group7_98_65_, experiment66_.owner_id as owner8_98_65_, experiment66_.permissions as permissi3_98_65_, experiment66_.update_id as update9_98_65_, experiment66_.type as type98_65_, experiment66_.version as version98_65_, event67_.id as id109_66_, event67_.containingEvent as containi5_109_66_, event67_.external_id as external6_109_66_, event67_.permissions as permissi2_109_66_, event67_.experimenter as experime7_109_66_, event67_.experimenterGroup as experime8_109_66_, event67_."session" as session9_109_66_, event67_.status as status109_66_, event67_.time as time109_66_, event67_.type as type109_66_, externalin68_.id as id49_67_, externalin68_.creation_id as creation7_49_67_, externalin68_.external_id as external8_49_67_, externalin68_.group_id as group9_49_67_, externalin68_.owner_id as owner10_49_67_, externalin68_.permissions as permissi2_49_67_, externalin68_.entityId as entityId49_67_, externalin68_.entityType as entityType49_67_, externalin68_.lsid as lsid49_67_, externalin68_.uuid as uuid49_67_, experiment69_.id as id32_68_, to_char(experiment69_.description) as descript2_32_68_, experiment69_.creation_id as creation6_32_68_, experiment69_.external_id as external7_32_68_, experiment69_.group_id as group8_32_68_, experiment69_.owner_id as owner9_32_68_, experiment69_.permissions as permissi3_32_68_, experiment69_.update_id as update10_32_68_, experiment69_.name as name32_68_, experiment69_.version as version32_68_, experiment70_.id as id107_69_, experiment70_.external_id as external10_107_69_, experiment70_.permissions as permissi2_107_69_, experiment70_.email as email107_69_, experiment70_.firstName as firstName107_69_, experiment70_.institution as institut5_107_69_, experiment70_.lastName as lastName107_69_, experiment70_.middleName as middleName107_69_, experiment70_.omeName as omeName107_69_, experiment70_.version as version107_69_, event71_.id as id109_70_, event71_.containingEvent as containi5_109_70_, event71_.external_id as external6_109_70_, event71_.permissions as permissi2_109_70_, event71_.experimenter as experime7_109_70_, event71_.experimenterGroup as experime8_109_70_, event71_."session" as session9_109_70_, event71_.status as status109_70_, event71_.time as time109_70_, event71_.type as type109_70_, experiment72_.id as id13_71_, experiment72_.creation_id as creation4_13_71_, experiment72_.external_id as external5_13_71_, experiment72_.group_id as group6_13_71_, experiment72_.owner_id as owner7_13_71_, experiment72_.permissions as permissi2_13_71_, experiment72_.value as value13_71_, event73_.id as id109_72_, event73_.containingEvent as containi5_109_72_, event73_.external_id as external6_109_72_, event73_.permissions as permissi2_109_72_, event73_.experimenter as experime7_109_72_, event73_.experimenterGroup as experime8_109_72_, event73_."session" as session9_109_72_, event73_.status as status109_72_, event73_.time as time109_72_, event73_.type as type109_72_, externalin74_.id as id49_73_, externalin74_.creation_id as creation7_49_73_, externalin74_.external_id as external8_49_73_, externalin74_.group_id as group9_49_73_, externalin74_.owner_id as owner10_49_73_, externalin74_.permissions as permissi2_49_73_, externalin74_.entityId as entityId49_73_, externalin74_.entityType as entityType49_73_, externalin74_.lsid as lsid49_73_, externalin74_.uuid as uuid49_73_, experiment75_.id as id32_74_, to_char(experiment75_.description) as descript2_32_74_, experiment75_.creation_id as creation6_32_74_, experiment75_.external_id as external7_32_74_, experiment75_.group_id as group8_32_74_, experiment75_.owner_id as owner9_32_74_, experiment75_.permissions as permissi3_32_74_, experiment75_.update_id as update10_32_74_, experiment75_.name as name32_74_, experiment75_.version as version32_74_, experiment76_.id as id107_75_, experiment76_.external_id as external10_107_75_, experiment76_.permissions as permissi2_107_75_, experiment76_.email as email107_75_, experiment76_.firstName as firstName107_75_, experiment76_.institution as institut5_107_75_, experiment76_.lastName as lastName107_75_, experiment76_.middleName as middleName107_75_, experiment76_.omeName as omeName107_75_, experiment76_.version as version107_75_, imagingenv77_.id as id63_76_, imagingenv77_.airPressure as airPress2_63_76_, imagingenv77_.co2percent as co3_63_76_, imagingenv77_.creation_id as creation8_63_76_, imagingenv77_.external_id as external9_63_76_, imagingenv77_.group_id as group10_63_76_, imagingenv77_.owner_id as owner11_63_76_, imagingenv77_.permissions as permissi4_63_76_, imagingenv77_.update_id as update12_63_76_, imagingenv77_.humidity as humidity63_76_, imagingenv77_.temperature as temperat6_63_76_, imagingenv77_.version as version63_76_, event78_.id as id109_77_, event78_.containingEvent as containi5_109_77_, event78_.external_id as external6_109_77_, event78_.permissions as permissi2_109_77_, event78_.experimenter as experime7_109_77_, event78_.experimenterGroup as experime8_109_77_, event78_."session" as session9_109_77_, event78_.status as status109_77_, event78_.time as time109_77_, event78_.type as type109_77_, externalin79_.id as id49_78_, externalin79_.creation_id as creation7_49_78_, externalin79_.external_id as external8_49_78_, externalin79_.group_id as group9_49_78_, externalin79_.owner_id as owner10_49_78_, externalin79_.permissions as permissi2_49_78_, externalin79_.entityId as entityId49_78_, externalin79_.entityType as entityType49_78_, externalin79_.lsid as lsid49_78_, externalin79_.uuid as uuid49_78_, experiment80_.id as id32_79_, to_char(experiment80_.description) as descript2_32_79_, experiment80_.creation_id as creation6_32_79_, experiment80_.external_id as external7_32_79_, experiment80_.group_id as group8_32_79_, experiment80_.owner_id as owner9_32_79_, experiment80_.permissions as permissi3_32_79_, experiment80_.update_id as update10_32_79_, experiment80_.name as name32_79_, experiment80_.version as version32_79_, experiment81_.id as id107_80_, experiment81_.external_id as external10_107_80_, experiment81_.permissions as permissi2_107_80_, experiment81_.email as email107_80_, experiment81_.firstName as firstName107_80_, experiment81_.institution as institut5_107_80_, experiment81_.lastName as lastName107_80_, experiment81_.middleName as middleName107_80_, experiment81_.omeName as omeName107_80_, experiment81_.version as version107_80_, event82_.id as id109_81_, event82_.containingEvent as containi5_109_81_, event82_.external_id as external6_109_81_, event82_.permissions as permissi2_109_81_, event82_.experimenter as experime7_109_81_, event82_.experimenterGroup as experime8_109_81_, event82_."session" as session9_109_81_, event82_.status as status109_81_, event82_.time as time109_81_, event82_.type as type109_81_, instrument83_.id as id58_82_, instrument83_.creation_id as creation4_58_82_, instrument83_.external_id as external5_58_82_, instrument83_.group_id as group6_58_82_, instrument83_.owner_id as owner7_58_82_, instrument83_.permissions as permissi2_58_82_, instrument83_.update_id as update8_58_82_, instrument83_.microscope as microscope58_82_, instr
12:06:54  jburel/lifesci: when tagging
12:06:54  jburel/lifesci: with new tag

[jmoore]

I'm still unsure if these large queries were being made previously, but on some RDBMs the number of joins is an issue. I tried various workarounds:

• in some cases I could use IUpdate.flush() to prevent the need for merging Event & Experimenter objects
• in other cases, especially for Events since they are immutable, changes to MergeEventListener could prevent merging by replacing objects with a session-based proxy.

Problems persisted with the mutable, details objects (like Experimenter). I then ran across this blog: ​http://community.jboss.org/message/354813

Setting the property MAX_FETCH_DEPTH directly on the dialect in question seems to work. Using that as the solution, and closing this ticket.

[jmoore <josh@…>]

(In [efb735f336aeda95831f9544ee69f7db26ae03e8/ome.git] on branch dev_4_1_custom) Not merging events, only loading proxy (See #4468)

[jmoore <josh@…>]

(In [efce217e78fd99cfe38ab1e412c46fb4c565af83/ome.git] on branch dev_4_1_custom) Merge branch 'feature/4.1-backport-fixes' into dev_4_1_custom (See #4468)