Notice: In order to edit this ticket you need to be either: a Product Owner, The owner or the reporter of the ticket, or, in case of a Task not yet assigned, a team_member"

Task #6863 (closed)

Opened 8 years ago

Closed 8 years ago

Last modified 8 years ago

BUG: WebAdmin Unexpected end of subtree on loading piechart

Reported by: atarkowska Owned by: atarkowska
Priority: critical Milestone: OMERO-Beta4.3.3
Component: WebAdmin Version: n.a.
Keywords: n.a. Cc: lkolchin@…, jamoore
Resources: n.a. Referenced By: n.a.
References: n.a. Remaining Time: 0.0d
Sprint: 2011-10-13 (1)

Description (last modified by jmoore)

Piechart data is loaded by the following query:

pids = omero.rtypes.rlist([p.id for p in pixels_list])
p2 = omero.sys.ParametersI()
p2.add("pids", pids)
pixels_originalFiles_list = conn.getQueryService().findAllByQuery(
        "select m from PixelsOriginalFileMap as m join fetch m.parent " \
        "where m.child.id in (:pids)", p2, ctx)

What raise the exception below

Change History (9)

comment:1 Changed 8 years ago by atarkowska

  • Description modified (diff)
  • Summary changed from BUG: WebAdmin Unexpected end of subtree to BUG: WebAdmin Unexpected end of subtree on loading piechart

comment:2 Changed 8 years ago by jmoore

  • Description modified (diff)
  • Milestone changed from OME-5.0 to OMERO-Beta4.3.3 
Traceback (most recent call last):

 File "/srv/omeroserver/lib/python/django/core/handlers/base.py", line 92, in get_response
   response = callback(request, *callback_args, **callback_kwargs)

 File "/srv/omeroserver/lib/python/omeroweb/webadmin/views.py", line 168, in wrapped
   return f(request, *args, **kwargs)

 File "/srv/omeroserver/lib/python/omeroweb/webadmin/views.py", line 871, in load_drivespace
   rv = usersData(conn, offset)

 File "/srv/omeroserver/lib/python/omeroweb/webadmin/controller/drivespace.py", line 99, in usersData
   "where m.child.id in (:pids)", p2, ctx)

 File "/srv/omeroserver/lib/python/omero/gateway/__init__.py", line 2959, in __call__
   return self.handle_exception(e, *args, **kwargs)

 File "/srv/OMERO.server-Beta-4.3.2/lib/python/omeroweb/webclient/webclient_gateway.py", line 1652, in handle_exception
   e, *args, **kwargs)

 File "/srv/omeroserver/lib/python/omero/gateway/__init__.py", line 2956, in __call__
   return self.f(*args, **kwargs)

 File "/srv/omeroserver/lib/python/omero_api_IQuery_ice.py", line 138, in findAllByQuery
   return _M_omero.api.IQuery._op_findAllByQuery.invoke(self, ((query, params), _ctx))

ApiUsageException: exception ::omero::ApiUsageException
{
   serverStackTrace = ome.conditions.ApiUsageException: unexpected end of subtree [select m from ome.model.core.PixelsOriginalFileMap as m join fetch m.parent where m.child.id in ()]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: unexpected end of subtree [select m from ome.model.core.PixelsOriginalFileMap as m join fetch m.parent where m.child.id in ()]
       at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:660)
       at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
       at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
       at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)
       at ome.logic.QueryImpl.execute(QueryImpl.java:142)
       at ome.logic.QueryImpl.findAllByQuery(QueryImpl.java:392)
       at sun.reflect.GeneratedMethodAccessor293.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:597)
       at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
       at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
       at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
       at ome.security.basic.EventHandler.invoke(EventHandler.java:150)
       at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
       at org.springframework.orm.hibernate3.HibernateInterceptor.invoke(HibernateInterceptor.java:111)
       at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
       at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:108)
       at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
       at ome.tools.hibernate.ProxyCleanupFilter$Interceptor.invoke(ProxyCleanupFilter.java:231)
       at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
       at ome.services.util.ServiceHandler.invoke(ServiceHandler.java:116)
       at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
       at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
       at $Proxy72.findAllByQuery(Unknown Source)
       at sun.reflect.GeneratedMethodAccessor293.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:597)
       at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
       at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
       at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
       at ome.security.basic.BasicSecurityWiring.invoke(BasicSecurityWiring.java:83)
       at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
       at ome.services.blitz.fire.AopContextInitializer.invoke(AopContextInitializer.java:43)
       at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
       at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
       at $Proxy72.findAllByQuery(Unknown Source)
       at sun.reflect.GeneratedMethodAccessor320.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:597)
       at ome.services.blitz.util.IceMethodInvoker.invoke(IceMethodInvoker.java:179)
       at ome.services.throttling.Callback.run(Callback.java:56)
       at ome.services.throttling.InThreadThrottlingStrategy.callInvokerOnRawArgs(InThreadThrottlingStrategy.java:56)
       at ome.services.blitz.impl.AbstractAmdServant.callInvokerOnRawArgs(AbstractAmdServant.java:136)
       at ome.services.blitz.impl.QueryI.findAllByQuery_async(QueryI.java:66)
       at omero.api._IQueryTie.findAllByQuery_async(_IQueryTie.java:92)
       at omero.api._IQueryDisp.___findAllByQuery(_IQueryDisp.java:366)
       at omero.api._IQueryDisp.__dispatch(_IQueryDisp.java:496)
       at IceInternal.Incoming.invoke(Incoming.java:159)
       at Ice.ConnectionI.invokeAll(ConnectionI.java:2037)
       at Ice.ConnectionI.message(ConnectionI.java:972)
       at IceInternal.ThreadPool.run(ThreadPool.java:577)
       at IceInternal.ThreadPool.access$100(ThreadPool.java:12)
       at IceInternal.ThreadPool$EventHandlerThread.run(ThreadPool.java:971)

   serverExceptionClass = ome.conditions.ApiUsageException
   message = unexpected end of subtree [select m from ome.model.core.PixelsOriginalFileMap as m join fetch m.parent where m.child.id in ()]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: unexpected end of subtree [select m from ome.model.core.PixelsOriginalFileMap as m join fetch m.parent where m.child.id in ()]
}


<WSGIRequest
GET:<QueryDict: {}>,
POST:<QueryDict: {}>,
COOKIES:{'__utma': '192312886.126904984.1289803522.1316045304.1316486455.52',
 '__utmz': '192312886.1316486455.52.35.utmcsr=monash.edu|utmccn=(referral)|utmcmd=referral|utmcct=/',
 'sessionid': '5fd671309cdddd3b278bf04c5d2f0580'},
META:{'CONTENT_TYPE': 'application/json; charset=utf-8',
 'DOCUMENT_ROOT': '/srv/webstart',
 'GATEWAY_INTERFACE': 'CGI/1.1',
 'HTTPS': 'on',
 'HTTP_ACCEPT': 'application/json, text/javascript, */*',
 'HTTP_ACCEPT_CHARSET': 'ISO-8859-1,utf-8;q=0.7,*;q=0.3',
 'HTTP_ACCEPT_ENCODING': 'gzip,deflate,sdch',
 'HTTP_ACCEPT_LANGUAGE': 'en-US,en;q=0.8',
 'HTTP_CONNECTION': 'keep-alive',
 'HTTP_COOKIE': '__utma=203357902.1484366806.1315973805.1315973805.1316391535.2; __utmz=203357902.1315973805.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); __utma=192312886.126904984.1289803522.1316045304.1316486455.52; __utmz=192312886.1316486455.52.35.utmcsr=monash.edu|utmccn=(referral)|utmcmd=referral|utmcct=/; sessionid=5fd671309cdddd3b278bf04c5d2f0580',
 'HTTP_HOST': 'server.its.monash.edu.au',
 'HTTP_REFERER': 'https://server.its.monash.edu.au/webadmin/drivespace/',
 'HTTP_USER_AGENT': 'Mozilla/5.0 (Windows NT 5.1) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/14.0.835.163 Safari/535.1',
 'HTTP_X_REQUESTED_WITH': 'XMLHttpRequest',
 'PATH': '/sbin:/usr/sbin:/bin:/usr/bin',
 'PATH_INFO': u'/webadmin/load_drivespace/',
 'PATH_TRANSLATED': '/srv/omeroserver/var/omero.fcgi/webadmin/load_drivespace/',
 'QUERY_STRING': '',
 'REMOTE_ADDR': '110.174.176.101',
 'REMOTE_PORT': '4153',
 'REQUEST_METHOD': 'GET',
 'REQUEST_URI': '/webadmin/load_drivespace/',
 'SCRIPT_FILENAME': '/srv/omeroserver/var/omero.fcgi',
 'SCRIPT_NAME': u'',
 'SERVER_ADDR': '130.194.245.190',
 'SERVER_ADMIN': 'root@localhost',
 'SERVER_NAME': 'server.its.monash.edu.au',
 'SERVER_PORT': '443',
 'SERVER_PROTOCOL': 'HTTP/1.1',
 'SERVER_SIGNATURE': '<address>Apache/2.2.3 (Red Hat) Server at server.its.monash.edu.au Port 443</address>\n',
 'SERVER_SOFTWARE': 'Apache/2.2.3 (Red Hat)',
 'wsgi.errors': <flup.server.fcgi_base.TeeOutputStream object at 0x10e30ed0>,
 'wsgi.input': <flup.server.fcgi_base.InputStream object at 0x10c98410>,
 'wsgi.multiprocess': True,
 'wsgi.multithread': False,
 'wsgi.run_once': False,
 'wsgi.url_scheme': 'https',
 'wsgi.version': (1, 0)}>

comment:3 Changed 8 years ago by atarkowska

  • Cc jmoore added
  • Remaining Time set to 0.5

comment:4 Changed 8 years ago by atarkowska

  • Sprint set to 2011-10-13 (1)

comment:5 Changed 8 years ago by atarkowska

  • Status changed from new to accepted

comment:6 Changed 8 years ago by atarkowska

TESTING :
In order to test it please use brand new database where no images were imported before. In WebAdmin? check if you see piechart with 100% Free space. Please check piechart with the server where data were imported before as well.

comment:7 Changed 8 years ago by wmoore

Reproduced the bug with an empty db on 'develop', switched to Ola's github 4.3.3-bugs and got '100%' pie chart. Imported image, pie-chart OK. Deleted image and pie-chart still OK.

comment:8 Changed 8 years ago by Aleksandra Tarkowska <atarkowska@…>

  • Remaining Time changed from 0.5 to 0
  • Resolution set to fixed
  • Status changed from accepted to closed

(In [396230de15921980879b1e9e8aae9b8dca5e9540/ome.git]) fixing loading piechart when no data imported, close #6863

comment:9 Changed 8 years ago by atarkowska

Tested with basic user as well

Note: See TracTickets for help on using tickets. You may also have a look at Agilo extensions to the ticket.

1.3.13-PRO © 2008-2011 Agilo Software all rights reserved (this page was served in: 0.74409 sec.)

© 2000-2014 University of Dundee & Open Microscopy Environment. Creative Commons Attribution 3.0 Unported License
OME source code is available under the GNU General public license or through commercial license from Glencoe Software

We're Hiring!