Created
January 23, 2017 16:51
-
-
Save will-moore/13bf257638b4c746c8c8b2a681b630f2 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # select obj, minIndex(ws), maxIndex(ws) from Plate as obj join fetch obj.wells wells left outer join fetch wells.wellSamples ws where obj.id in (:ids) group by obj.id | |
| 2017-01-23 16:50:16,095 INFO [ome.services.sessions.state.SessionCache] (2-thread-5) Synchronizing session cache. Count = 4 | |
| 2017-01-23 16:50:16,095 INFO [ ome.services.util.ServiceHandler] (2-thread-5) Executor.doWork -- ome.services.sessions.SessionManagerImpl.reload[5e9cdf94-4184-40ee-a3da-9c5693f55812] | |
| 2017-01-23 16:50:16,095 INFO [ ome.services.util.ServiceHandler] (2-thread-5) Args: [null, InternalSF@33779587] | |
| 2017-01-23 16:50:16,108 INFO [ ome.security.basic.EventHandler] (2-thread-5) Auth: user=0,group=0,event=null(Sessions),sess=d30fd532-ae16-47a0-a3cc-5dbb3a9b3a91 | |
| 2017-01-23 16:50:16,116 INFO [ org.perf4j.TimingLogger] (2-thread-5) start[1485190216095] time[20] tag[omero.call.success.ome.services.sessions.SessionManagerImpl$6.doWork] | |
| 2017-01-23 16:50:16,116 INFO [ ome.services.util.ServiceHandler] (2-thread-5) Rslt: (ome.model.meta.Experimenter:Id_0, ome.model.meta.ExperimenterGroup:Id_5, (5, 1, 4, ... 4 more), ... 4 more) | |
| 2017-01-23 16:50:16,116 INFO [ ome.services.util.ServiceHandler] (2-thread-5) Executor.doWork -- ome.services.sessions.SessionManagerImpl.reload[d30fd532-ae16-47a0-a3cc-5dbb3a9b3a91] | |
| 2017-01-23 16:50:16,116 INFO [ ome.services.util.ServiceHandler] (2-thread-5) Args: [null, InternalSF@33779587] | |
| 2017-01-23 16:50:16,117 INFO [ ome.security.basic.EventHandler] (2-thread-5) Auth: user=0,group=0,event=null(Sessions),sess=d30fd532-ae16-47a0-a3cc-5dbb3a9b3a91 | |
| 2017-01-23 16:50:16,121 INFO [ org.perf4j.TimingLogger] (2-thread-5) start[1485190216116] time[4] tag[omero.call.success.ome.services.sessions.SessionManagerImpl$6.doWork] | |
| 2017-01-23 16:50:16,121 INFO [ ome.services.util.ServiceHandler] (2-thread-5) Rslt: (ome.model.meta.Experimenter:Id_0, ome.model.meta.ExperimenterGroup:Id_0, (5, 1, 4, ... 4 more), ... 4 more) | |
| 2017-01-23 16:50:16,121 INFO [ ome.services.util.ServiceHandler] (2-thread-5) Executor.doWork -- ome.services.sessions.SessionManagerImpl.reload[d7a45350-3746-461e-bfdb-05b8d40c37b9] | |
| 2017-01-23 16:50:16,121 INFO [ ome.services.util.ServiceHandler] (2-thread-5) Args: [null, InternalSF@33779587] | |
| 2017-01-23 16:50:16,121 INFO [ ome.security.basic.EventHandler] (2-thread-5) Auth: user=0,group=0,event=null(Sessions),sess=d30fd532-ae16-47a0-a3cc-5dbb3a9b3a91 | |
| 2017-01-23 16:50:16,125 INFO [ org.perf4j.TimingLogger] (2-thread-5) start[1485190216121] time[4] tag[omero.call.success.ome.services.sessions.SessionManagerImpl$6.doWork] | |
| 2017-01-23 16:50:16,125 INFO [ ome.services.util.ServiceHandler] (2-thread-5) Rslt: (ome.model.meta.Experimenter:Id_3, ome.model.meta.ExperimenterGroup:Id_5, (5, 1, 4, ... 5 more), ... 4 more) | |
| 2017-01-23 16:50:16,125 INFO [ ome.services.util.ServiceHandler] (2-thread-5) Executor.doWork -- ome.services.sessions.SessionManagerImpl.reload[e13b7a2f-8770-437c-b212-354bf8a9f573] | |
| 2017-01-23 16:50:16,125 INFO [ ome.services.util.ServiceHandler] (2-thread-5) Args: [null, InternalSF@33779587] | |
| 2017-01-23 16:50:16,126 INFO [ ome.security.basic.EventHandler] (2-thread-5) Auth: user=0,group=0,event=null(Sessions),sess=d30fd532-ae16-47a0-a3cc-5dbb3a9b3a91 | |
| 2017-01-23 16:50:16,130 INFO [ org.perf4j.TimingLogger] (2-thread-5) start[1485190216125] time[4] tag[omero.call.success.ome.services.sessions.SessionManagerImpl$6.doWork] | |
| 2017-01-23 16:50:16,130 INFO [ ome.services.util.ServiceHandler] (2-thread-5) Rslt: (ome.model.meta.Experimenter:Id_0, ome.model.meta.ExperimenterGroup:Id_5, (5, 1, 4, ... 4 more), ... 4 more) | |
| 2017-01-23 16:50:16,130 INFO [ org.perf4j.TimingLogger] (2-thread-5) start[1485190216095] time[34] tag[omero.sessions.synchronization] | |
| 2017-01-23 16:50:16,130 INFO [ome.services.sessions.state.SessionCache] (2-thread-5) Synchronization took 34 ms. | |
| 2017-01-23 16:50:18,627 INFO [ ome.services.blitz.fire.SessionManagerI] (.Server-88) Found session locally: d7a45350-3746-461e-bfdb-05b8d40c37b9 | |
| 2017-01-23 16:50:18,628 INFO [ ome.services.blitz.fire.SessionManagerI] (.Server-88) Rejoining session ServiceFactoryI(session-10f88724-f71d-46b6-bd83-c35afe17db3c/d7a45350-3746-461e-bfdb-05b8d40c37b9) (agent=OMERO.webapi) | |
| 2017-01-23 16:50:18,631 INFO [ omero.cmd.SessionI] (.Server-84) Added servant to adapter: d7a45350-3746-461e-bfdb-05b8d40c37b9/10f88724-f71d-46b6-bd83-c35afe17db3comero.api.IQuery(omero.api._IQueryTie@4ced4278) | |
| 2017-01-23 16:50:18,632 INFO [ ome.services.util.ServiceHandler] (.Server-88) Meth: interface ome.api.IQuery.projection | |
| 2017-01-23 16:50:18,632 INFO [ ome.services.util.ServiceHandler] (.Server-88) Args: [select obj, minIndex(ws), maxIndex(ws) from Plate as obj join fetch obj.wells wells left outer join, PARAMS:ids=ArrayList(1) ] | |
| 2017-01-23 16:50:18,633 INFO [ ome.security.basic.BasicEventContext] (.Server-88) cctx: group=-1 | |
| 2017-01-23 16:50:18,635 INFO [ ome.security.basic.EventHandler] (.Server-88) Auth: user=3,group=-1,event=null(User),sess=d7a45350-3746-461e-bfdb-05b8d40c37b9 | |
| 2017-01-23 16:50:18,637 INFO [ org.perf4j.TimingLogger] (.Server-88) start[1485190218632] time[5] tag[omero.call.exception] | |
| 2017-01-23 16:50:18,639 WARN [ ome.services.util.ServiceHandler] (.Server-88) InvalidDataAccessResourceUsageException thrown. | |
| org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select plate0_.id as col_0_0_, min(wellsample2_.well_index) as col_1_0_, max(wellsample2_.well_index) as col_2_0_, wells1_.id as id143_1_, wellsample2_.id as id146_2_, plate0_.id as id109_0_, wells1_.id as id143_1_, wellsample2_.id as id146_2_, plate0_.columnNamingConvention as columnNa2_109_0_, plate0_.columns as columns109_0_, plate0_.defaultSample as defaultS4_109_0_, plate0_.description as descript5_109_0_, plate0_.creation_id as creation17_109_0_, plate0_.external_id as external18_109_0_, plate0_.group_id as group19_109_0_, plate0_.owner_id as owner20_109_0_, plate0_.permissions as permissi6_109_0_, plate0_.update_id as update21_109_0_, plate0_.externalIdentifier as external7_109_0_, plate0_.name as name109_0_, plate0_.rowNamingConvention as rowNamin9_109_0_, plate0_."rows" as rows10_109_0_, plate0_.status as status109_0_, plate0_.version as version109_0_, plate0_.wellOriginXUnit as wellOri13_109_0_, plate0_.wellOriginX as wellOri14_109_0_, plate0_.wellOriginYUnit as wellOri15_109_0_, plate0_.wellOriginY as wellOri16_109_0_, wells1_.alpha as alpha143_1_, wells1_.blue as blue143_1_, wells1_."column" as column4_143_1_, wells1_.creation_id as creation14_143_1_, wells1_.external_id as external15_143_1_, wells1_.group_id as group16_143_1_, wells1_.owner_id as owner17_143_1_, wells1_.permissions as permissi5_143_1_, wells1_.update_id as update18_143_1_, wells1_.externalDescription as external6_143_1_, wells1_.externalIdentifier as external7_143_1_, wells1_.green as green143_1_, wells1_.plate as plate143_1_, wells1_.red as red143_1_, wells1_."row" as row10_143_1_, wells1_.status as status143_1_, wells1_.type as type143_1_, wells1_.version as version143_1_, wells1_.plate as plate109_0__, wells1_.id as id0__, wellsample2_.creation_id as creation9_146_2_, wellsample2_.external_id as external10_146_2_, wellsample2_.group_id as group11_146_2_, wellsample2_.owner_id as owner12_146_2_, wellsample2_.permissions as permissi2_146_2_, wellsample2_.update_id as update13_146_2_, wellsample2_.image as image146_2_, wellsample2_.plateAcquisition as plateAc15_146_2_, wellsample2_.posXUnit as posXUnit146_2_, wellsample2_.posX as posX146_2_, wellsample2_.posYUnit as posYUnit146_2_, wellsample2_.posY as posY146_2_, wellsample2_.timepoint as timepoint146_2_, wellsample2_.version as version146_2_, wellsample2_.well as well146_2_, wellsample2_.well as well143_1__, wellsample2_.id as id1__, wellsample2_.well_index as well17_1__ from plate plate0_ inner join well wells1_ on plate0_.id=wells1_.plate and | |
| ( | |
| 1 = ? OR | |
| 1 = ? OR | |
| (wells1_.group_id in (?)) OR | |
| (wells1_.owner_id = ? AND (select (__g.permissions & 1024) = 1024 from experimentergroup __g where __g.id = wells1_.group_id)) OR | |
| (wells1_.group_id in (?,?,?,?,?,?,?,?) AND (select (__g.permissions & 64) = 64 from experimentergroup __g where __g.id = wells1_.group_id)) OR | |
| ((select (__g.permissions & 4) = 4 from experimentergroup __g where __g.id = wells1_.group_id)) | |
| ) left outer join wellsample wellsample2_ on wells1_.id=wellsample2_.well and | |
| ( | |
| 1 = ? OR | |
| 1 = ? OR | |
| (wellsample2_.group_id in (?)) OR | |
| (wellsample2_.owner_id = ? AND (select (__g.permissions & 1024) = 1024 from experimentergroup __g where __g.id = wellsample2_.group_id)) OR | |
| (wellsample2_.group_id in (?,?,?,?,?,?,?,?) AND (select (__g.permissions & 64) = 64 from experimentergroup __g where __g.id = wellsample2_.group_id)) OR | |
| ((select (__g.permissions & 4) = 4 from experimentergroup __g where __g.id = wellsample2_.group_id)) | |
| ) where | |
| ( | |
| 1 = ? OR | |
| 1 = ? OR | |
| (plate0_.group_id in (?)) OR | |
| (plate0_.owner_id = ? AND (select (__g.permissions & 1024) = 1024 from experimentergroup __g where __g.id = plate0_.group_id)) OR | |
| (plate0_.group_id in (?,?,?,?,?,?,?,?) AND (select (__g.permissions & 64) = 64 from experimentergroup __g where __g.id = plate0_.group_id)) OR | |
| ((select (__g.permissions & 4) = 4 from experimentergroup __g where __g.id = plate0_.group_id)) | |
| ) and (plate0_.id in (?)) group by plate0_.id]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query | |
| at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:629) ~[spring-orm.jar:3.0.1.RELEASE] | |
| at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412) ~[spring-orm.jar:3.0.1.RELEASE] | |
| at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411) ~[spring-orm.jar:3.0.1.RELEASE] | |
| at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339) ~[spring-orm.jar:3.0.1.RELEASE] | |
| at ome.logic.QueryImpl.projection(QueryImpl.java:415) ~[server.jar:na] | |
| at sun.reflect.GeneratedMethodAccessor1012.invoke(Unknown Source) ~[na:na] | |
| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_65] | |
| at java.lang.reflect.Method.invoke(Method.java:497) ~[na:1.8.0_65] | |
| at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) [spring-aop.jar:3.0.1.RELEASE] | |
| at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) [spring-aop.jar:3.0.1.RELEASE] | |
| at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) [spring-aop.jar:3.0.1.RELEASE] | |
| at ome.security.basic.EventHandler.invoke(EventHandler.java:154) ~[server.jar:na] | |
| at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop.jar:3.0.1.RELEASE] | |
| at org.springframework.orm.hibernate3.HibernateInterceptor.invoke(HibernateInterceptor.java:111) ~[spring-orm.jar:3.0.1.RELEASE] | |
| at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop.jar:3.0.1.RELEASE] | |
| at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:108) ~[spring-tx.jar:3.0.1.RELEASE] | |
| at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop.jar:3.0.1.RELEASE] | |
| at ome.tools.hibernate.ProxyCleanupFilter$Interceptor.invoke(ProxyCleanupFilter.java:249) ~[server.jar:na] | |
| at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop.jar:3.0.1.RELEASE] | |
| at ome.services.util.ServiceHandler.invoke(ServiceHandler.java:121) ~[server.jar:na] | |
| at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop.jar:3.0.1.RELEASE] | |
| at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) [spring-aop.jar:3.0.1.RELEASE] | |
| at com.sun.proxy.$Proxy80.projection(Unknown Source) [na:na] | |
| at sun.reflect.GeneratedMethodAccessor1012.invoke(Unknown Source) ~[na:na] | |
| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_65] | |
| at java.lang.reflect.Method.invoke(Method.java:497) ~[na:1.8.0_65] | |
| at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) [spring-aop.jar:3.0.1.RELEASE] | |
| at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) [spring-aop.jar:3.0.1.RELEASE] | |
| at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) [spring-aop.jar:3.0.1.RELEASE] | |
| at ome.security.basic.BasicSecurityWiring.invoke(BasicSecurityWiring.java:93) [server.jar:na] | |
| at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop.jar:3.0.1.RELEASE] | |
| at ome.services.blitz.fire.AopContextInitializer.invoke(AopContextInitializer.java:43) [blitz.jar:na] | |
| at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop.jar:3.0.1.RELEASE] | |
| at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) [spring-aop.jar:3.0.1.RELEASE] | |
| at com.sun.proxy.$Proxy80.projection(Unknown Source) [na:na] | |
| at sun.reflect.GeneratedMethodAccessor1090.invoke(Unknown Source) ~[na:na] | |
| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_65] | |
| at java.lang.reflect.Method.invoke(Method.java:497) ~[na:1.8.0_65] | |
| at ome.services.blitz.util.IceMethodInvoker.invoke(IceMethodInvoker.java:172) [blitz.jar:na] | |
| at ome.services.throttling.Callback.run(Callback.java:56) [blitz.jar:na] | |
| at ome.services.throttling.InThreadThrottlingStrategy.callInvokerWithMappedArgs(InThreadThrottlingStrategy.java:70) [blitz.jar:na] | |
| at ome.services.blitz.impl.AbstractAmdServant.callInvokerOnMappedArgs(AbstractAmdServant.java:149) [blitz.jar:na] | |
| at ome.services.blitz.impl.QueryI.projection_async(QueryI.java:122) [blitz.jar:na] | |
| at sun.reflect.GeneratedMethodAccessor1089.invoke(Unknown Source) ~[na:na] | |
| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_65] | |
| at java.lang.reflect.Method.invoke(Method.java:497) ~[na:1.8.0_65] | |
| at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) [spring-aop.jar:3.0.1.RELEASE] | |
| at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) [spring-aop.jar:3.0.1.RELEASE] | |
| at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) [spring-aop.jar:3.0.1.RELEASE] | |
| at omero.cmd.CallContext.invoke(CallContext.java:78) [blitz.jar:na] | |
| at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop.jar:3.0.1.RELEASE] | |
| at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) [spring-aop.jar:3.0.1.RELEASE] | |
| at com.sun.proxy.$Proxy81.projection_async(Unknown Source) [na:na] | |
| at omero.api._IQueryTie.projection_async(_IQueryTie.java:126) [blitz.jar:na] | |
| at omero.api._IQueryDisp.___projection(_IQueryDisp.java:601) [blitz.jar:na] | |
| at omero.api._IQueryDisp.__dispatch(_IQueryDisp.java:718) [blitz.jar:na] | |
| at IceInternal.Incoming.invoke(Incoming.java:222) [ice.jar:na] | |
| at Ice.ConnectionI.invokeAll(ConnectionI.java:2482) [ice.jar:na] | |
| at Ice.ConnectionI.dispatch(ConnectionI.java:1258) [ice.jar:na] | |
| at Ice.ConnectionI.message(ConnectionI.java:1213) [ice.jar:na] | |
| at IceInternal.ThreadPool.run(ThreadPool.java:321) [ice.jar:na] | |
| at IceInternal.ThreadPool.access$300(ThreadPool.java:12) [ice.jar:na] | |
| at IceInternal.ThreadPool$EventHandlerThread.run(ThreadPool.java:693) [ice.jar:na] | |
| at java.lang.Thread.run(Thread.java:745) [na:1.8.0_65] | |
| Caused by: org.hibernate.exception.SQLGrammarException: could not execute query | |
| at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92) ~[hibernate-core.jar:na] | |
| at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) ~[hibernate-core.jar:na] | |
| at org.hibernate.loader.Loader.doList(Loader.java:2452) ~[hibernate-core.jar:na] | |
| at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2192) ~[hibernate-core.jar:na] | |
| at org.hibernate.loader.Loader.list(Loader.java:2187) ~[hibernate-core.jar:na] | |
| at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452) ~[hibernate-core.jar:na] | |
| at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363) ~[hibernate-core.jar:na] | |
| at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) ~[hibernate-core.jar:na] | |
| at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1260) ~[hibernate-core.jar:na] | |
| at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) ~[hibernate-core.jar:na] | |
| at ome.services.query.Query.doInHibernate(Query.java:241) ~[server.jar:na] | |
| at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406) ~[spring-orm.jar:3.0.1.RELEASE] | |
| ... 61 common frames omitted | |
| Caused by: org.postgresql.util.PSQLException: ERROR: column "wells1_.id" must appear in the GROUP BY clause or be used in an aggregate function | |
| Position: 116 | |
| at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270) ~[postgresql.jar:9.4] | |
| at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998) ~[postgresql.jar:9.4] | |
| at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) ~[postgresql.jar:9.4] | |
| at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570) ~[postgresql.jar:9.4] | |
| at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:420) ~[postgresql.jar:9.4] | |
| at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:305) ~[postgresql.jar:9.4] | |
| at sun.reflect.GeneratedMethodAccessor64.invoke(Unknown Source) ~[na:na] | |
| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_65] | |
| at java.lang.reflect.Method.invoke(Method.java:497) ~[na:1.8.0_65] | |
| at bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64) ~[btm.jar:2.1.3] | |
| at com.sun.proxy.$Proxy8.executeQuery(Unknown Source) ~[na:na] | |
| at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) ~[hibernate-core.jar:na] | |
| at org.hibernate.loader.Loader.getResultSet(Loader.java:1869) ~[hibernate-core.jar:na] | |
| at org.hibernate.loader.Loader.doQuery(Loader.java:718) ~[hibernate-core.jar:na] | |
| at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270) ~[hibernate-core.jar:na] | |
| at org.hibernate.loader.Loader.doList(Loader.java:2449) ~[hibernate-core.jar:na] | |
| ... 70 common frames omitted | |
| 2017-01-23 16:50:18,639 INFO [ ome.services.util.ServiceHandler] (.Server-88) Excp: org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select plate0_.id as col_0_0_, min(wellsample2_.well_index) as col_1_0_, max(wellsample2_.well_index) as col_2_0_, wells1_.id as id143_1_, wellsample2_.id as id146_2_, plate0_.id as id109_0_, wells1_.id as id143_1_, wellsample2_.id as id146_2_, plate0_.columnNamingConvention as columnNa2_109_0_, plate0_.columns as columns109_0_, plate0_.defaultSample as defaultS4_109_0_, plate0_.description as descript5_109_0_, plate0_.creation_id as creation17_109_0_, plate0_.external_id as external18_109_0_, plate0_.group_id as group19_109_0_, plate0_.owner_id as owner20_109_0_, plate0_.permissions as permissi6_109_0_, plate0_.update_id as update21_109_0_, plate0_.externalIdentifier as external7_109_0_, plate0_.name as name109_0_, plate0_.rowNamingConvention as rowNamin9_109_0_, plate0_."rows" as rows10_109_0_, plate0_.status as status109_0_, plate0_.version as version109_0_, plate0_.wellOriginXUnit as wellOri13_109_0_, plate0_.wellOriginX as wellOri14_109_0_, plate0_.wellOriginYUnit as wellOri15_109_0_, plate0_.wellOriginY as wellOri16_109_0_, wells1_.alpha as alpha143_1_, wells1_.blue as blue143_1_, wells1_."column" as column4_143_1_, wells1_.creation_id as creation14_143_1_, wells1_.external_id as external15_143_1_, wells1_.group_id as group16_143_1_, wells1_.owner_id as owner17_143_1_, wells1_.permissions as permissi5_143_1_, wells1_.update_id as update18_143_1_, wells1_.externalDescription as external6_143_1_, wells1_.externalIdentifier as external7_143_1_, wells1_.green as green143_1_, wells1_.plate as plate143_1_, wells1_.red as red143_1_, wells1_."row" as row10_143_1_, wells1_.status as status143_1_, wells1_.type as type143_1_, wells1_.version as version143_1_, wells1_.plate as plate109_0__, wells1_.id as id0__, wellsample2_.creation_id as creation9_146_2_, wellsample2_.external_id as external10_146_2_, wellsample2_.group_id as group11_146_2_, wellsample2_.owner_id as owner12_146_2_, wellsample2_.permissions as permissi2_146_2_, wellsample2_.update_id as update13_146_2_, wellsample2_.image as image146_2_, wellsample2_.plateAcquisition as plateAc15_146_2_, wellsample2_.posXUnit as posXUnit146_2_, wellsample2_.posX as posX146_2_, wellsample2_.posYUnit as posYUnit146_2_, wellsample2_.posY as posY146_2_, wellsample2_.timepoint as timepoint146_2_, wellsample2_.version as version146_2_, wellsample2_.well as well146_2_, wellsample2_.well as well143_1__, wellsample2_.id as id1__, wellsample2_.well_index as well17_1__ from plate plate0_ inner join well wells1_ on plate0_.id=wells1_.plate and | |
| ( | |
| 1 = ? OR | |
| 1 = ? OR | |
| (wells1_.group_id in (?)) OR | |
| (wells1_.owner_id = ? AND (select (__g.permissions & 1024) = 1024 from experimentergroup __g where __g.id = wells1_.group_id)) OR | |
| (wells1_.group_id in (?,?,?,?,?,?,?,?) AND (select (__g.permissions & 64) = 64 from experimentergroup __g where __g.id = wells1_.group_id)) OR | |
| ((select (__g.permissions & 4) = 4 from experimentergroup __g where __g.id = wells1_.group_id)) | |
| ) left outer join wellsample wellsample2_ on wells1_.id=wellsample2_.well and | |
| ( | |
| 1 = ? OR | |
| 1 = ? OR | |
| (wellsample2_.group_id in (?)) OR | |
| (wellsample2_.owner_id = ? AND (select (__g.permissions & 1024) = 1024 from experimentergroup __g where __g.id = wellsample2_.group_id)) OR | |
| (wellsample2_.group_id in (?,?,?,?,?,?,?,?) AND (select (__g.permissions & 64) = 64 from experimentergroup __g where __g.id = wellsample2_.group_id)) OR | |
| ((select (__g.permissions & 4) = 4 from experimentergroup __g where __g.id = wellsample2_.group_id)) | |
| ) where | |
| ( | |
| 1 = ? OR | |
| 1 = ? OR | |
| (plate0_.group_id in (?)) OR | |
| (plate0_.owner_id = ? AND (select (__g.permissions & 1024) = 1024 from experimentergroup __g where __g.id = plate0_.group_id)) OR | |
| (plate0_.group_id in (?,?,?,?,?,?,?,?) AND (select (__g.permissions & 64) = 64 from experimentergroup __g where __g.id = plate0_.group_id)) OR | |
| ((select (__g.permissions & 4) = 4 from experimentergroup __g where __g.id = plate0_.group_id)) | |
| ) and (plate0_.id in (?)) group by plate0_.id]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment