Error creating initial grafana datasource

grafana

(lonelyadmin) #1

I’m using the latest release version of icingaweb2, graphite, and grafana. I’ve gotten to the point of setting up the grafana datasource by pointing it at graphite-web. It runs for a while and then dies with this in the graphite webapp error log:

 [Fri Jun 15 15:37:21.159044 2018] [core:info] [pid 11649:tid 139953983973120] [client 127.0.0.1:34988] AH00128: File does not exist: /opt/graphite/webapp/tags/tagMultiSeries
[Fri Jun 15 15:37:43.182928 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176] Internal Server Error: /graphite/metrics/find
[Fri Jun 15 15:37:43.182947 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176] Traceback (most recent call last):
[Fri Jun 15 15:37:43.182952 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]   File "/usr/lib64/python2.7/site-packages/django/core/handlers/exception.py", line 39, in inner
[Fri Jun 15 15:37:43.182956 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]     response = get_response(request)
[Fri Jun 15 15:37:43.182963 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]   File "/usr/lib64/python2.7/site-packages/django/core/handlers/base.py", line 187, in _get_response
[Fri Jun 15 15:37:43.182966 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]     response = self.process_exception_by_middleware(e, request)
[Fri Jun 15 15:37:43.182969 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]   File "/usr/lib64/python2.7/site-packages/django/core/handlers/base.py", line 185, in _get_response
[Fri Jun 15 15:37:43.182972 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]     response = wrapped_callback(request, *callback_args, **callback_kwargs)
[Fri Jun 15 15:37:43.182975 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]   File "/opt/graphite/webapp/graphite/metrics/views.py", line 135, in find_view
[Fri Jun 15 15:37:43.182977 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]     profile = getProfile(request)
[Fri Jun 15 15:37:43.182980 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]   File "/opt/graphite/webapp/graphite/user_util.py", line 25, in getProfile
[Fri Jun 15 15:37:43.182983 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]     return default_profile()
[Fri Jun 15 15:37:43.182986 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]   File "/opt/graphite/webapp/graphite/user_util.py", line 41, in default_profile
[Fri Jun 15 15:37:43.182989 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]     'password': '!'})
[Fri Jun 15 15:37:43.182992 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]   File "/usr/lib64/python2.7/site-packages/django/db/models/manager.py", line 85, in manager_method
[Fri Jun 15 15:37:43.182995 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]     return getattr(self.get_queryset(), name)(*args, **kwargs)
[Fri Jun 15 15:37:43.182998 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]   File "/usr/lib64/python2.7/site-packages/django/db/models/query.py", line 473, in get_or_create
[Fri Jun 15 15:37:43.183000 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]     return self._create_object_from_params(lookup, params)
[Fri Jun 15 15:37:43.183003 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]   File "/usr/lib64/python2.7/site-packages/django/db/models/query.py", line 503, in _create_object_from_params
[Fri Jun 15 15:37:43.183006 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]     obj = self.create(**params)
[Fri Jun 15 15:37:43.183009 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]   File "/usr/lib64/python2.7/site-packages/django/db/models/query.py", line 399, in create
[Fri Jun 15 15:37:43.183011 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]     obj.save(force_insert=True, using=self.db)
[Fri Jun 15 15:37:43.183014 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]   File "/usr/lib64/python2.7/site-packages/django/contrib/auth/base_user.py", line 80, in save
[Fri Jun 15 15:37:43.183017 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]     super(AbstractBaseUser, self).save(*args, **kwargs)
[Fri Jun 15 15:37:43.183020 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]   File "/usr/lib64/python2.7/site-packages/django/db/models/base.py", line 796, in save
[Fri Jun 15 15:37:43.183023 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]     force_update=force_update, update_fields=update_fields)
[Fri Jun 15 15:37:43.183025 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]   File "/usr/lib64/python2.7/site-packages/django/db/models/base.py", line 824, in save_base
[Fri Jun 15 15:37:43.183028 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]     updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)
[Fri Jun 15 15:37:43.183034 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]   File "/usr/lib64/python2.7/site-packages/django/db/models/base.py", line 908, in _save_table
[Fri Jun 15 15:37:43.183037 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]     result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)
[Fri Jun 15 15:37:43.183040 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]   File "/usr/lib64/python2.7/site-packages/django/db/models/base.py", line 947, in _do_insert
[Fri Jun 15 15:37:43.183043 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]     using=using, raw=raw)
[Fri Jun 15 15:37:43.183046 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]   File "/usr/lib64/python2.7/site-packages/django/db/models/manager.py", line 85, in manager_method
[Fri Jun 15 15:37:43.183049 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]     return getattr(self.get_queryset(), name)(*args, **kwargs)
[Fri Jun 15 15:37:43.183052 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]   File "/usr/lib64/python2.7/site-packages/django/db/models/query.py", line 1043, in _insert
[Fri Jun 15 15:37:43.183054 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]     return query.get_compiler(using=using).execute_sql(return_id)
[Fri Jun 15 15:37:43.183057 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]   File "/usr/lib64/python2.7/site-packages/django/db/models/sql/compiler.py", line 1054, in execute_sql
[Fri Jun 15 15:37:43.183060 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]     cursor.execute(sql, params)
[Fri Jun 15 15:37:43.183063 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]   File "/usr/lib64/python2.7/site-packages/django/db/backends/utils.py", line 79, in execute
[Fri Jun 15 15:37:43.183066 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]     return super(CursorDebugWrapper, self).execute(sql, params)
[Fri Jun 15 15:37:43.183069 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]   File "/usr/lib64/python2.7/site-packages/django/db/backends/utils.py", line 64, in execute
[Fri Jun 15 15:37:43.183072 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]     return self.cursor.execute(sql, params)
[Fri Jun 15 15:37:43.183074 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]   File "/usr/lib64/python2.7/site-packages/django/db/utils.py", line 94, in __exit__
[Fri Jun 15 15:37:43.183077 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]     six.reraise(dj_exc_type, dj_exc_value, traceback)
[Fri Jun 15 15:37:43.183080 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]   File "/usr/lib64/python2.7/site-packages/django/db/backends/utils.py", line 64, in execute
[Fri Jun 15 15:37:43.183083 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]     return self.cursor.execute(sql, params)
[Fri Jun 15 15:37:43.183086 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]   File "/usr/lib64/python2.7/site-packages/django/db/backends/sqlite3/base.py", line 337, in execute
[Fri Jun 15 15:37:43.183088 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176]     return Database.Cursor.execute(self, query, params)
[Fri Jun 15 15:37:43.183091 2018] [wsgi:error] [pid 24629:tid 139954006144768] [remote 127.0.0.1:35176] OperationalError: unable to open database file

I also see multiple occurances of these as well in that same file, not sure if it stems from the same issue, but they were there before grafana:
[Fri Jun 15 15:30:21.546746 2018] [core:info] [pid 12336:tid 139953824511744] [client 127.0.0.1:32966] AH00128: File does not exist: /opt/graphite/webapp/tags/tagMultiSeries

Not sure if I missed something on the webserver setup…some alias or something.

Thanks for any help given!


(Chris) #2

i think the database is not set up for graphite