perfSONAR User Q&A and Other Discussion

["Chaker, Haythem" <>]

Hello,

 

I am running Ubuntu 18.04 on two machines.

I am trying to change measurements archive directory for esmond/cassandra/postgresql10 following instructions in the FAQ .

I changed directories for cassandra (with cassandra chown) and same for postgres .

After restarting the 3 services :

• The web GUI says “Error loading tset listing; measurement archive unreachable” in the Test results
• <host>/esmond/perfsonar/archive/ returns 500 Internal Server error

 

Given that the link for rebuilding the esmond tables in the FAQ is broken. I started following these rpm_install instructions . except python esmond/manage.py syncdb happens to be an unknown command.

 

/var/log/esmond/django.log has :

 

 

2019-03-14 13:27:45,867 [ERROR] /usr/lib/python2.7/dist-packages/django/core/handlers/exception.py: Internal Server Error: /esmond/perfsonar/archive/

Traceback (most recent call last):

  File "/usr/lib/python2.7/dist-packages/django/core/handlers/exception.py", line 41, in inner

    response = get_response(request)

  File "/usr/lib/python2.7/dist-packages/django/core/handlers/base.py", line 249, in _legacy_get_response

    response = self._get_response(request)

  File "/usr/lib/python2.7/dist-packages/django/core/handlers/base.py", line 187, in _get_response

    response = self.process_exception_by_middleware(e, request)

  File "/usr/lib/python2.7/dist-packages/django/core/handlers/base.py", line 185, in _get_response

    response = wrapped_callback(request, *callback_args, **callback_kwargs)

  File "/usr/lib/python2.7/dist-packages/django/views/decorators/csrf.py", line 58, in wrapped_view

    return view_func(*args, **kwargs)

  File "/usr/lib/python2.7/dist-packages/rest_framework/viewsets.py", line 95, in view

    return self.dispatch(request, *args, **kwargs)

  File "/usr/lib/python2.7/dist-packages/rest_framework/views.py", line 494, in dispatch

    response = self.handle_exception(exc)

  File "/usr/lib/python2.7/dist-packages/rest_framework/views.py", line 454, in handle_exception

    self.raise_uncaught_exception(exc)

  File "/usr/lib/python2.7/dist-packages/rest_framework/views.py", line 482, in dispatch

    self.initial(request, *args, **kwargs)

  File "/usr/lib/python2.7/dist-packages/rest_framework/views.py", line 399, in initial

    self.perform_authentication(request)

  File "/usr/lib/python2.7/dist-packages/rest_framework/views.py", line 325, in perform_authentication

    request.user

  File "/usr/lib/python2.7/dist-packages/rest_framework/request.py", line 222, in user

    self._authenticate()

  File "/usr/lib/python2.7/dist-packages/rest_framework/request.py", line 374, in _authenticate

    user_auth_tuple = authenticator.authenticate(self)

  File "/usr/lib/python2.7/dist-packages/rest_framework/authentication.py", line 190, in authenticate

    return self.authenticate_credentials(token)

  File "/usr/lib/python2.7/dist-packages/rest_framework/authentication.py", line 195, in authenticate_credentials

    token = model.objects.select_related('user').get(key=key)

  File "/usr/lib/python2.7/dist-packages/django/db/models/query.py", line 374, in get

    num = len(clone)

  File "/usr/lib/python2.7/dist-packages/django/db/models/query.py", line 232, in __len__

    self._fetch_all()

  File "/usr/lib/python2.7/dist-packages/django/db/models/query.py", line 1118, in _fetch_all

    self._result_cache = list(self._iterable_class(self))

  File "/usr/lib/python2.7/dist-packages/django/db/models/query.py", line 53, in __iter__

    results = compiler.execute_sql(chunked_fetch=self.chunked_fetch)

  File "/usr/lib/python2.7/dist-packages/django/db/models/sql/compiler.py", line 899, in execute_sql

    raise original_exception

ProgrammingError: relation "authtoken_token" does not exist

LINE 1: ...user"."is_active", "auth_user"."date_joined" FROM "authtoken...

 

 

/var/log/apache2/error.log has :

 

 

[Thu Mar 14 13:27:45.888595 2019] [wsgi:error] [pid 12640:tid 139748364121856] [remote 192.168.50.117:49044] AttributeError: 'NoneType' object has no attribute 'upper'

[Thu Mar 14 13:31:35.967844 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062] mod_wsgi (pid=12642): Exception occurred processing WSGI script '/usr/lib/python2.7/dist-packages/esmond/wsgi.py'.

[Thu Mar 14 13:31:35.967876 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062] Traceback (most recent call last):

[Thu Mar 14 13:31:35.967887 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]   File "/usr/lib/python2.7/dist-packages/esmond/wsgi.py", line 28, in application

[Thu Mar 14 13:31:35.967906 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]     return get_wsgi_application()(environ, start_response)

[Thu Mar 14 13:31:35.967913 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]   File "/usr/lib/python2.7/dist-packages/django/core/handlers/wsgi.py", line 157, in __call__

[Thu Mar 14 13:31:35.967923 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]     response = self.get_response(request)

[Thu Mar 14 13:31:35.967928 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]   File "/usr/lib/python2.7/dist-packages/django/core/handlers/base.py", line 124, in get_response

[Thu Mar 14 13:31:35.967936 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]     response = self._middleware_chain(request)

[Thu Mar 14 13:31:35.967941 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]   File "/usr/lib/python2.7/dist-packages/django/core/handlers/exception.py", line 43, in inner

[Thu Mar 14 13:31:35.967948 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]     response = response_for_exception(request, exc)

[Thu Mar 14 13:31:35.967953 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]   File "/usr/lib/python2.7/dist-packages/django/core/handlers/exception.py", line 93, in response_for_exception

[Thu Mar 14 13:31:35.967960 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]     response = handle_uncaught_exception(request, get_resolver(get_urlconf()), sys.exc_info())

[Thu Mar 14 13:31:35.967965 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]   File "/usr/lib/python2.7/dist-packages/django/core/handlers/exception.py", line 135, in handle_uncaught_exception

[Thu Mar 14 13:31:35.967972 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]     extra={'status_code': 500, 'request': request},

[Thu Mar 14 13:31:35.967983 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]   File "/usr/lib/python2.7/logging/__init__.py", line 1200, in error

[Thu Mar 14 13:31:35.967992 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]     self._log(ERROR, msg, args, **kwargs)

[Thu Mar 14 13:31:35.967997 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]   File "/usr/lib/python2.7/logging/__init__.py", line 1293, in _log

[Thu Mar 14 13:31:35.968003 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]     self.handle(record)

[Thu Mar 14 13:31:35.968007 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]   File "/usr/lib/python2.7/logging/__init__.py", line 1303, in handle

[Thu Mar 14 13:31:35.968014 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]     self.callHandlers(record)

[Thu Mar 14 13:31:35.968018 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]   File "/usr/lib/python2.7/logging/__init__.py", line 1343, in callHandlers

[Thu Mar 14 13:31:35.968024 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]     hdlr.handle(record)

[Thu Mar 14 13:31:35.968029 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]   File "/usr/lib/python2.7/logging/__init__.py", line 766, in handle

[Thu Mar 14 13:31:35.968035 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]     self.emit(record)

[Thu Mar 14 13:31:35.968039 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]   File "/usr/lib/python2.7/dist-packages/django/utils/log.py", line 119, in emit

[Thu Mar 14 13:31:35.968046 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]     message = "%s\\n\\n%s" % (self.format(no_exc_record), reporter.get_traceback_text())

[Thu Mar 14 13:31:35.968051 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]   File "/usr/lib/python2.7/dist-packages/django/views/debug.py", line 334, in get_traceback_text

[Thu Mar 14 13:31:35.968058 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]     return t.render(c)

[Thu Mar 14 13:31:35.968063 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]   File "/usr/lib/python2.7/dist-packages/django/template/base.py", line 207, in render

[Thu Mar 14 13:31:35.968070 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]     return self._render(context)

[Thu Mar 14 13:31:35.968074 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]   File "/usr/lib/python2.7/dist-packages/django/template/base.py", line 199, in _render

[Thu Mar 14 13:31:35.968081 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]     return self.nodelist.render(context)

[Thu Mar 14 13:31:35.968085 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]   File "/usr/lib/python2.7/dist-packages/django/template/base.py", line 990, in render

[Thu Mar 14 13:31:35.968091 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]     bit = node.render_annotated(context)

[Thu Mar 14 13:31:35.968095 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]   File "/usr/lib/python2.7/dist-packages/django/template/base.py", line 957, in render_annotated

[Thu Mar 14 13:31:35.968102 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]     return self.render(context)

[Thu Mar 14 13:31:35.968106 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]   File "/usr/lib/python2.7/dist-packages/django/template/base.py", line 1040, in render

[Thu Mar 14 13:31:35.968112 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]     output = self.filter_expression.resolve(context)

[Thu Mar 14 13:31:35.968116 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]   File "/usr/lib/python2.7/dist-packages/django/template/base.py", line 732, in resolve

[Thu Mar 14 13:31:35.968126 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]     obj = template_localtime(obj, context.use_tz)

[Thu Mar 14 13:31:35.968131 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]   File "/usr/lib/python2.7/dist-packages/django/utils/timezone.py", line 195, in template_localtime

[Thu Mar 14 13:31:35.968138 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]     return localtime(value) if should_convert else value

[Thu Mar 14 13:31:35.968143 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]   File "/usr/lib/python2.7/dist-packages/django/utils/timezone.py", line 213, in localtime

[Thu Mar 14 13:31:35.968149 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]     timezone = get_current_timezone()

[Thu Mar 14 13:31:35.968154 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]   File "/usr/lib/python2.7/dist-packages/django/utils/timezone.py", line 97, in get_current_timezone

[Thu Mar 14 13:31:35.968161 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]     return getattr(_active, "value", get_default_timezone())

[Thu Mar 14 13:31:35.968165 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]   File "/usr/lib/python2.7/dist-packages/django/utils/lru_cache.py", line 124, in wrapper

[Thu Mar 14 13:31:35.968173 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]     result = user_function(*args, **kwds)

[Thu Mar 14 13:31:35.968177 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]   File "/usr/lib/python2.7/dist-packages/django/utils/timezone.py", line 79, in get_default_timezone

[Thu Mar 14 13:31:35.968183 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]     return pytz.timezone(settings.TIME_ZONE)

[Thu Mar 14 13:31:35.968188 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]   File "/usr/lib/python2.7/dist-packages/pytz/__init__.py", line 162, in timezone

[Thu Mar 14 13:31:35.968195 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062]     if zone.upper() == 'UTC':

[Thu Mar 14 13:31:35.968205 2019] [wsgi:error] [pid 12642:tid 139748347336448] [remote 192.168.50.117:49062] AttributeError: 'NoneType' object has no attribute 'upper'

 

 

/var/log/esmond/esmond.log is empty

 

Pscheduler got stuck too so I ran a pscheduler internal reset .

 

How do I sync esmond to with my new directories or at least sync it back with previous directories and then I could try to do symbolic linking.

 

Thank you