|
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...
On 13/12/2017 20:42, Andrew Lake wrote:
Anything
in /var/log/esmond/django.log? From that log it looks like it
can connect to cassandra, so that’s a good sign, something else
must be tripping it up.
On December 13, 2017 at 12:52:03 PM, Ciprian
Pinzaru () wrote:
Hello,
In the logs I see:
[Wed Dec 13 19:33:08.072893 2017] [:error] [pid 1041]
path=
['/usr/lib/esmond/src/dlnetsnmp/lib', '/usr/lib/esmond',
'/usr/lib/esmond/esmond_client',
'/usr/lib/esmond/esmond',
'/usr/lib/esmond/lib/python2.7',
'/usr/lib/esmond/lib/python2.7/site-packages',
'/usr/lib64/python27.zip', '/usr/lib64/python2.7',
'/usr/lib64/python2.7/plat-linux2',
'/usr/lib64/python2.7/lib-tk',
'/usr/lib64/python2.7/lib-old',
'/usr/lib64/python2.7/lib-dynload',
'/usr/lib64/python2.7/site-packages',
'/usr/lib64/python2.7/site-packages/gtk-2.0',
'/usr/lib/python2.7/site-packages']
[Wed Dec 13 19:33:08.437883 2017] [:error] [pid 1041]
cassandra_db
[INFO] Checking/creating column families
[Wed Dec 13 19:33:08.448204 2017] [:error] [pid 1041]
cassandra_db
[INFO] Schema check done
[Wed Dec 13 19:33:08.448295 2017] [:error] [pid 1041]
cassandra_db
[DEBUG] Opening ConnectionPool
[Wed Dec 13 19:33:08.460624 2017] [:error] [pid 1041]
cassandra_db
[INFO] Connected to ['localhost:9160']
The host is
http://perfsonar-grid.uaic.ro/toolkit/
On 13/12/2017 16:43, Szymon
Trocha
wrote:
W dniu 13.12.2017 o 15:27,
Ciprian Pinzaru pisze:
Hello,
In the end the instalation process was ok
68dcdd3776954fdb833d09432ff2c107
pS-Toolkit-4.0.2-CentOS7-FullInstall-x86_64-2017Nov22.iso
68dcdd3776954fdb833d09432ff2c107
/root/toolkit-building/scripts/../resources/pS-Toolkit-4.0.2-CentOS7-FullInstall-x86_64-2017Nov22.iso
In one server was ok
perfsonar2-grid.uaic.ro/toolkit/
but in the other server give
Error
loading test listing: Internal Server Error
You may try restarting cassandra with systemctl restart
cassandra
and see it's correctly connecting to esmond. Please also
look for
any suspicious errors in the logs under /var/log/esmond
to
verify.
best regards,
--
Szymon Trocha
Poznań Supercomputing & Networking Center
Tel. +48 618582022 ::: http://noc.pcss.pl
|
