devmode.sh fails because of missing pysqlite2

[Honza Pokorny]

Steps to reproduce:

$ rm -rf ~/.quickstart
$ bash devmode.sh --no-gate --ovb --delete-all-stacks
statically included: /home/hpokorny/.quickstart/usr/local/share/ansible/roles/validate-sanity-checks/tasks/create-scripts.yml
statically included: /home/hpokorny/.quickstart/usr/local/share/ansible/roles/validate-sanity-checks/tasks/sanity-checks.yml
statically included: /home/hpokorny/.quickstart/usr/local/share/ansible/roles/validate-tempest/tasks/undercloud-config.yml
statically included: /home/hpokorny/.quickstart/usr/local/share/ansible/roles/validate-tempest/tasks/pre-tempest.yml
statically included: /home/hpokorny/.quickstart/usr/local/share/ansible/roles/validate-tempest/tasks/run-tempest.yml
statically included: /home/hpokorny/.quickstart/usr/local/share/ansible/roles/validate-tempest/tasks/stackviz.yml
statically included: /home/hpokorny/.quickstart/usr/local/share/ansible/roles/validate-tempest/tasks/post-tempest.yml
statically included: /home/hpokorny/.quickstart/usr/local/share/ansible/roles/validate-tempest/tasks/tempest-status.yml
statically included: /home/hpokorny/.quickstart/usr/local/share/ansible/roles/validate-tempest/tasks/tempest-results.yml
the full traceback was:

Traceback (most recent call last):
  File "/home/hpokorny/.quickstart/bin/ansible-playbook", line 103, in <module>
    exit_code = cli.run()
  File "/home/hpokorny/.quickstart/lib/python2.7/site-packages/ansible/cli/playbook.py", line 159, in run
    results = pbex.run()
  File "/home/hpokorny/.quickstart/lib/python2.7/site-packages/ansible/executor/playbook_executor.py", line 89, in run
    self._tqm.load_callbacks()
  File "/home/hpokorny/.quickstart/lib/python2.7/site-packages/ansible/executor/task_queue_manager.py", line 177, in load_callbacks
    for callback_plugin in callback_loader.all(class_only=True):
  File "/home/hpokorny/.quickstart/lib/python2.7/site-packages/ansible/plugins/__init__.py", line 394, in all
    self._module_cache[path] = self._load_module_source(name, path)
  File "/home/hpokorny/.quickstart/lib/python2.7/site-packages/ansible/plugins/__init__.py", line 324, in _load_module_source
    module = imp.load_source(name, path, module_file)
  File "/home/hpokorny/.quickstart/lib/python2.7/site-packages/ara/plugins/callbacks/log_ara.py", line 43, in <module>
    app = create_app()
  File "/home/hpokorny/.quickstart/lib/python2.7/site-packages/ara/webapp.py", line 66, in create_app
    configure_db(app)
  File "/home/hpokorny/.quickstart/lib/python2.7/site-packages/ara/webapp.py", line 111, in configure_db
    inspector = Inspector.from_engine(db.engine)
  File "/home/hpokorny/.quickstart/lib/python2.7/site-packages/flask_sqlalchemy/__init__.py", line 877, in engine
    return self.get_engine()
  File "/home/hpokorny/.quickstart/lib/python2.7/site-packages/flask_sqlalchemy/__init__.py", line 896, in get_engine
    return connector.get_engine()
  File "/home/hpokorny/.quickstart/lib/python2.7/site-packages/flask_sqlalchemy/__init__.py", line 559, in get_engine
    self._engine = rv = sqlalchemy.create_engine(info, **options)
  File "/home/hpokorny/.quickstart/lib/python2.7/site-packages/sqlalchemy/engine/__init__.py", line 391, in create_engine
    return strategy.create(*args, **kwargs)
  File "/home/hpokorny/.quickstart/lib/python2.7/site-packages/sqlalchemy/engine/strategies.py", line 80, in create
    dbapi = dialect_cls.dbapi(**dbapi_args)
  File "/home/hpokorny/.quickstart/lib/python2.7/site-packages/sqlalchemy/dialects/sqlite/pysqlite.py", line 339, in dbapi
    raise e

ERROR! Unexpected Exception: No module named pysqlite2

[Honza Pokorny (hpokorny)]

Installing sqlite headers, and then pip installing pysqlite manually solves the problem. It seems to be related to the ara plugin.

[David Moreau Simard (dmsimard)]

This is a weird issue -- it seems like there's either a mix of RPM and pip packages involved or a virtualenv created that inherited from system-site-packages with conflicting packages.

Please try to reproduce with "bash -x devmode.sh" so we see what is going on. Thanks.

[Honza Pokorny (hpokorny)]

This is caused by my using pyenv. Setting the version to 'system' for oooq solves the issue.