perfSONAR User Q&A and Other Discussion

[Ciprian Pinzaru <>]

Hello,

You have news about this bug?

Thank you,

Ciprian Pinzaru


On 14/12/2017 14:15, Szymon Trocha wrote:
> W dniu 13.12.2017 o 20:07, Ciprian Pinzaru pisze:
> > Hello,
> >
> > [root@perfsonar-grid esmond]# systemctl status cassandra
> > ● cassandra.service - SYSV: Starts and stops Cassandra
> >    Loaded: loaded (/etc/rc.d/init.d/cassandra; bad; vendor preset: 
> > disabled)
> >    Active: active (exited) since Wed 2017-12-13 21:07:14 EET; 9s ago
> >      Docs: man:systemd-sysv-generator(8)
> >   Process: 8556 ExecStop=/etc/rc.d/init.d/cassandra stop 
> > (code=exited, status=1/FAILURE)
> >   Process: 8596 ExecStart=/etc/rc.d/init.d/cassandra start 
> > (code=exited, status=0/SUCCESS)
> >
> > Dec 13 21:07:14 perfsonar-grid.uaic.ro systemd[1]: Unit 
> > cassandra.service entered failed state.
> > Dec 13 21:07:14 perfsonar-grid.uaic.ro systemd[1]: cassandra.service 
> > failed.
> > Dec 13 21:07:14 perfsonar-grid.uaic.ro systemd[1]: Starting SYSV: 
> > Starts and stops Cassandra...
> > Dec 13 21:07:14 perfsonar-grid.uaic.ro su[8605]: (to cassandra) root 
> > on none
> > Dec 13 21:07:14 perfsonar-grid.uaic.ro cassandra[8596]: Starting 
> > Cassandra: OK
> > Dec 13 21:07:14 perfsonar-grid.uaic.ro systemd[1]: Started SYSV: 
> > Starts and stops Cassandra.
> >
> > The logs var/log/esmond/django.log:
> >
> > 2017-12-13 21:04:57,477 [ERROR] 
> > /usr/lib/esmond/lib/python2.7/site-packages/django/core/handlers/exception.py: 
> > Internal Server Error: /esmond/perfsonar/archive/
> > Traceback (most recent call last):
> >   File 
> > "/usr/lib/esmond/lib/python2.7/site-packages/django/core/handlers/exception.py", 
> > line 42, in inner
> >     response = get_response(request)
> >   File 
> > "/usr/lib/esmond/lib/python2.7/site-packages/django/core/handlers/base.py", 
> > line 249, in _legacy_get_response
> >     response = self._get_response(request)
> >   File 
> > "/usr/lib/esmond/lib/python2.7/site-packages/django/core/handlers/base.py", 
> > line 187, in _get_response
> >     response = self.process_exception_by_middleware(e, request)
> >   File 
> > "/usr/lib/esmond/lib/python2.7/site-packages/django/core/handlers/base.py", 
> > line 185, in _get_response
> >     response = wrapped_callback(request, *callback_args, 
> > **callback_kwargs)
> >   File 
> > "/usr/lib/esmond/lib/python2.7/site-packages/django/views/decorators/csrf.py", 
> > line 58, in wrapped_view
> >     return view_func(*args, **kwargs)
> >   File 
> > "/usr/lib/esmond/lib/python2.7/site-packages/rest_framework/viewsets.py", 
> > line 90, in view
> >     return self.dispatch(request, *args, **kwargs)
> >   File 
> > "/usr/lib/esmond/lib/python2.7/site-packages/rest_framework/views.py", 
> > line 489, in dispatch
> >     response = self.handle_exception(exc)
> >   File 
> > "/usr/lib/esmond/lib/python2.7/site-packages/rest_framework/views.py", 
> > line 449, in handle_exception
> >     self.raise_uncaught_exception(exc)
> >   File 
> > "/usr/lib/esmond/lib/python2.7/site-packages/rest_framework/views.py", 
> > line 486, in dispatch
> >     response = handler(request, *args, **kwargs)
> >   File "/usr/lib/esmond/esmond/api/perfsonar/api_v2.py", line 838, in 
> > list
> >     return super(ArchiveViewset, self).list(request)
> >   File 
> > "/usr/lib/esmond/lib/python2.7/site-packages/rest_framework/mixins.py", 
> > line 42, in list
> >     page = self.paginate_queryset(queryset)
> >   File 
> > "/usr/lib/esmond/lib/python2.7/site-packages/rest_framework/generics.py", 
> > line 173, in paginate_queryset
> >     return self.paginator.paginate_queryset(queryset, self.request, 
> > view=self)
> >   File 
> > "/usr/lib/esmond/lib/python2.7/site-packages/rest_framework/pagination.py", 
> > line 335, in paginate_queryset
> >     self.count = _get_count(queryset)
> >   File 
> > "/usr/lib/esmond/lib/python2.7/site-packages/rest_framework/pagination.py", 
> > line 53, in _get_count
> >     return queryset.count()
> >   File 
> > "/usr/lib/esmond/lib/python2.7/site-packages/django/db/models/query.py", 
> > line 369, in count
> >     return self.query.get_count(using=self.db)
> >   File 
> > "/usr/lib/esmond/lib/python2.7/site-packages/django/db/models/sql/query.py", 
> > line 476, in get_count
> >     number = obj.get_aggregation(using, ['__count'])['__count']
> >   File 
> > "/usr/lib/esmond/lib/python2.7/site-packages/django/db/models/sql/query.py", 
> > line 457, in get_aggregation
> >     result = compiler.execute_sql(SINGLE)
> >   File 
> > "/usr/lib/esmond/lib/python2.7/site-packages/django/db/models/sql/compiler.py", 
> > line 835, in execute_sql
> >     cursor.execute(sql, params)
> >   File 
> > "/usr/lib/esmond/lib/python2.7/site-packages/django/db/backends/utils.py", 
> > line 64, in execute
> >     return self.cursor.execute(sql, params)
> >   File 
> > "/usr/lib/esmond/lib/python2.7/site-packages/django/db/utils.py", 
> > line 94, in __exit__
> >     six.reraise(dj_exc_type, dj_exc_value, traceback)
> >   File 
> > "/usr/lib/esmond/lib/python2.7/site-packages/django/db/backends/utils.py", 
> > line 64, in execute
> >     return self.cursor.execute(sql, params)
> > ProgrammingError: relation "ps_metadata" does not exist
> > LINE 1: ...e" AS Col3, "ps_metadata"."checksum" AS Col4 FROM 
> > "ps_metada...
>
> Hi Ciprian,
>
> I was able to recreate this problem reported by you and some other 
> persons in my environment.
>
> I opened an issue about this: 
> https://github.com/perfsonar/toolkit/issues/286
>
> Although some other e-mail exchange showed some workaround to make it 
> working I wasn't able to apply the same solution in my environment so 
> I can't recommend doing it. Our developers will come back to you with 
> advise as soon as possible.
>
> Best regards,

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature