Bug 1368112

Summary: graphite service is not running after boot-up qcow2 image
Product: Red Hat Storage Console Reporter: Martin Kudlej <mkudlej>
Component: distributionAssignee: Nishanth Thomas <nthomas>
Status: CLOSED CURRENTRELEASE QA Contact: sds-qe-bugs
Severity: urgent Docs Contact:
Priority: unspecified    
Version: 2CC: mbukatov, nthomas, sankarshan
Target Milestone: ---   
Target Release: 2   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: https://brewweb.engineering.redhat.com/brew/buildinfo?buildID=509870 Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2018-11-19 05:34:26 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description Martin Kudlej 2016-08-18 12:52:52 UTC
Description of problem:
After boot-up image there should be graphite service up and running. It seems that it hasn't initialized db.
    [Thu Aug 18 07:07:19.925505 2016] [:error] [pid 882] [client 10.40.2.154:43284] mod_wsgi (pid=882): Exception occurred processing WSGI script '/usr/share/graphite/graphite-web.wsgi'.
    [Thu Aug 18 07:07:19.925522 2016] [:error] [pid 882] [client 10.40.2.154:43284] Traceback (most recent call last):
    [Thu Aug 18 07:07:19.925533 2016] [:error] [pid 882] [client 10.40.2.154:43284]   File "/usr/share/graphite/graphite-web.wsgi", line 16, in <module>
    [Thu Aug 18 07:07:19.925574 2016] [:error] [pid 882] [client 10.40.2.154:43284]     import graphite.metrics.search
    [Thu Aug 18 07:07:19.925596 2016] [:error] [pid 882] [client 10.40.2.154:43284]   File "/usr/lib/python2.7/site-packages/graphite/metrics/search.py", line 6, in <module>
    [Thu Aug 18 07:07:19.925636 2016] [:error] [pid 882] [client 10.40.2.154:43284]     from graphite.storage import is_pattern, match_entries
    [Thu Aug 18 07:07:19.925643 2016] [:error] [pid 882] [client 10.40.2.154:43284]   File "/usr/lib/python2.7/site-packages/graphite/storage.py", line 7, in <module>
    [Thu Aug 18 07:07:19.925724 2016] [:error] [pid 882] [client 10.40.2.154:43284]     from graphite.remote_storage import RemoteStore
    [Thu Aug 18 07:07:19.925738 2016] [:error] [pid 882] [client 10.40.2.154:43284]   File "/usr/lib/python2.7/site-packages/graphite/remote_storage.py", line 8, in <module>
    [Thu Aug 18 07:07:19.925791 2016] [:error] [pid 882] [client 10.40.2.154:43284]     from graphite.util import unpickle
    [Thu Aug 18 07:07:19.925798 2016] [:error] [pid 882] [client 10.40.2.154:43284]   File "/usr/lib/python2.7/site-packages/graphite/util.py", line 70, in <module>
    [Thu Aug 18 07:07:19.925842 2016] [:error] [pid 882] [client 10.40.2.154:43284]     defaultUser = User.objects.get(username='default')
    [Thu Aug 18 07:07:19.925850 2016] [:error] [pid 882] [client 10.40.2.154:43284]   File "/usr/lib/python2.7/site-packages/django/db/models/manager.py", line 127, in manager_method
    [Thu Aug 18 07:07:19.925912 2016] [:error] [pid 882] [client 10.40.2.154:43284]     return getattr(self.get_queryset(), name)(*args, **kwargs)
    [Thu Aug 18 07:07:19.925919 2016] [:error] [pid 882] [client 10.40.2.154:43284]   File "/usr/lib/python2.7/site-packages/django/db/models/query.py", line 328, in get
    [Thu Aug 18 07:07:19.926217 2016] [:error] [pid 882] [client 10.40.2.154:43284]     num = len(clone)
    [Thu Aug 18 07:07:19.926231 2016] [:error] [pid 882] [client 10.40.2.154:43284]   File "/usr/lib/python2.7/site-packages/django/db/models/query.py", line 144, in __len__
    [Thu Aug 18 07:07:19.926244 2016] [:error] [pid 882] [client 10.40.2.154:43284]     self._fetch_all()
    [Thu Aug 18 07:07:19.926250 2016] [:error] [pid 882] [client 10.40.2.154:43284]   File "/usr/lib/python2.7/site-packages/django/db/models/query.py", line 965, in _fetch_all
    [Thu Aug 18 07:07:19.926258 2016] [:error] [pid 882] [client 10.40.2.154:43284]     self._result_cache = list(self.iterator())
    [Thu Aug 18 07:07:19.926263 2016] [:error] [pid 882] [client 10.40.2.154:43284]   File "/usr/lib/python2.7/site-packages/django/db/models/query.py", line 238, in iterator
    [Thu Aug 18 07:07:19.926270 2016] [:error] [pid 882] [client 10.40.2.154:43284]     results = compiler.execute_sql()
    [Thu Aug 18 07:07:19.926274 2016] [:error] [pid 882] [client 10.40.2.154:43284]   File "/usr/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 840, in execute_sql
    [Thu Aug 18 07:07:19.926480 2016] [:error] [pid 882] [client 10.40.2.154:43284]     cursor.execute(sql, params)
    [Thu Aug 18 07:07:19.926490 2016] [:error] [pid 882] [client 10.40.2.154:43284]   File "/usr/lib/python2.7/site-packages/django/db/backends/utils.py", line 64, in execute
    [Thu Aug 18 07:07:19.926544 2016] [:error] [pid 882] [client 10.40.2.154:43284]     return self.cursor.execute(sql, params)
    [Thu Aug 18 07:07:19.926551 2016] [:error] [pid 882] [client 10.40.2.154:43284]   File "/usr/lib/python2.7/site-packages/django/db/utils.py", line 98, in __exit__
    [Thu Aug 18 07:07:19.926628 2016] [:error] [pid 882] [client 10.40.2.154:43284]     six.reraise(dj_exc_type, dj_exc_value, traceback)
    [Thu Aug 18 07:07:19.926637 2016] [:error] [pid 882] [client 10.40.2.154:43284]   File "/usr/lib/python2.7/site-packages/django/db/backends/utils.py", line 64, in execute
    [Thu Aug 18 07:07:19.926648 2016] [:error] [pid 882] [client 10.40.2.154:43284]     return self.cursor.execute(sql, params)
    [Thu Aug 18 07:07:19.926653 2016] [:error] [pid 882] [client 10.40.2.154:43284]   File "/usr/lib/python2.7/site-packages/django/db/backends/sqlite3/base.py", line 318, in execute
    [Thu Aug 18 07:07:19.926740 2016] [:error] [pid 882] [client 10.40.2.154:43284]     return Database.Cursor.execute(self, query, params)
    [Thu Aug 18 07:07:19.926756 2016] [:error] [pid 882] [client 10.40.2.154:43284] OperationalError: no such table: auth_user


Difference between old and new image:
    ## Package tests: packages added (new vs old iso)
    set(['cloud-init-0.7.6-9.el7.x86_64',
         'python-jsonpatch-1.2-2.el7.noarch',
         'python-jsonpointer-1.9-2.el7.noarch',
         'python-prettytable-0.7.2-1.el7.noarch'])
     
    ## Package tests: packages removed (new vs old iso)
    set()
     
    ## Package tests: packages upgraded (new vs old iso)
    set(['openpgm-5.2.122-4.el7.x86_64',
         'python-django-1.8.7-1.el7.noarch',
         'python-django-bash-completion-1.8.7-1.el7.noarch'])


Version-Release number of selected component (if applicable):
0.3-5.x86_64.qcow2

How reproducible:
100% in libvirt and in Openstack too.

Comment 2 Martin Bukatovic 2016-08-18 13:58:53 UTC
Additional info
===============

File /var/lib/graphite-web/graphite.db is not present in the image:

~~~
$ guestfish --ro -a rhscon-appliance-0.3-5.x86_64.qcow2
 
Welcome to guestfish, the guest filesystem shell for
editing virtual machine filesystems and disk images.
 
Type: 'help' for help on commands
      'man' to read the manual
      'quit' to quit the shell
 
><fs> run
><fs> list-filesystems
/dev/sda1: swap
/dev/sda2: ext4
><fs> mount /dev/sda2 /
><fs> ls /var/lib/graphite-web
><fs>
~~~

Comment 3 Nishanth Thomas 2016-08-19 15:48:46 UTC
This fixed in latest qcow image, so moving to ON_QA

Comment 4 Martin Bukatovic 2016-08-22 16:56:14 UTC
Checking with: rhscon-appliance-0.3-8

And the graphite web interface is accessible after booting the machine up
in both libvirt and openstack environment.