[Pywps-dev] pywps demo: Service error: (sqlite3.OperationalError) unable to open database file

[Martin Landa]

Hi,

pywps-demo is failing on computer (Ubuntu 16.04LTS):

http://127.0.0.1:5000/wps?service=wps&&version=1.0.0&request=execute&identifier=say_hello&datainputs=name=slunce

ends with

Service error: (sqlite3.OperationalError) unable to open database file

Debug:

2017-10-16 10:37:54,026] [DEBUG]
file=/usr/local/lib/python3.5/dist-packages/pywps/dblog.py line=163
module=dblog function=get_session Initializing database connection
2017-10-16 10:37:54,027] [ERROR]
file=/usr/local/lib/python3.5/dist-packages/pywps/exceptions.py
line=45 module=exceptions function=__init__ Exception: code: 400,
locator: Service error: (sqlite3.OperationalError) unable to open
database file, description:
Traceback (most recent call last):
  File "/usr/local/lib/python3.5/dist-packages/sqlalchemy/engine/base.py",
line 2147, in _wrap_pool_connect
    return fn()
  File "/usr/local/lib/python3.5/dist-packages/sqlalchemy/pool.py",
line 387, in connect
    return _ConnectionFairy._checkout(self)
  File "/usr/local/lib/python3.5/dist-packages/sqlalchemy/pool.py",
line 766, in _checkout
    fairy = _ConnectionRecord.checkout(pool)
  File "/usr/local/lib/python3.5/dist-packages/sqlalchemy/pool.py",
line 516, in checkout
    rec = pool._do_get()
  File "/usr/local/lib/python3.5/dist-packages/sqlalchemy/pool.py",
line 1229, in _do_get
    return self._create_connection()
  File "/usr/local/lib/python3.5/dist-packages/sqlalchemy/pool.py",
line 333, in _create_connection
    return _ConnectionRecord(self)
  File "/usr/local/lib/python3.5/dist-packages/sqlalchemy/pool.py",
line 461, in __init__
    self.__connect(first_connect_check=True)
  File "/usr/local/lib/python3.5/dist-packages/sqlalchemy/pool.py",
line 651, in __connect
    connection = pool._invoke_creator(self)
  File "/usr/local/lib/python3.5/dist-packages/sqlalchemy/engine/strategies.py",
line 105, in connect
    return dialect.connect(*cargs, **cparams)
  File "/usr/local/lib/python3.5/dist-packages/sqlalchemy/engine/default.py",
line 393, in connect
    return self.dbapi.connect(*cargs, **cparams)
sqlite3.OperationalError: unable to open database file

Strangely `logs/pywps-logs.sqlite3` is created, table `pywps_requests`
contains records, but `pywps_stored requests` is empty.

No modification in configuration has been done. Any idea what could be wrong?

Martin

-- 
Martin Landa
http://geo.fsv.cvut.cz/gwiki/Landa
http://gismentors.cz/mentors/landa