perfSONAR User Q&A and Other Discussion

[Szymon Trocha <>]

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,

--
Szymon Trocha

Poznań Supercomputing & Networking Center
Tel. +48 618582022 ::: http://noc.pcss.pl