[PyWPS-dev] pywps in docker: unable to open database file

[Jachym Cepicky]

Hi,

this looks like the config file is not loaded properly?

would `print(database)` around line 160 would tell any info?

J

út 8. 10. 2019 v 10:24 odesílatel Martin Landa <landa.martin at gmail.com> napsal:
>
> Hi,
>
> I am running pywps in self-made docker. Logs are stored outside of docker:
>
> """
>     volumes:
>       - /opt/subdayprecip-design/wps/logs:/var/log/pywps
> """
>
> Relevant part of configuration:
>
> """
> [logging]
> file=/var/log/pywps/pywps.log
> database=sqlite:///var/log/pywps/pywps.db
> level=INFO
> """
>
> Unfortunately an execute request fails with
>
> """
> 2019-10-08 08:19:54,119] [ERROR]
> file=/usr/local/lib/python2.7/dist-packages/pywps/exceptions.py
> line=45 module=exceptions function=__init__ Exception: code: 400,
> locator: Service error: (OperationalError) unable to open database
> file None None, description:
> Traceback (most recent call last):
>   File "/usr/local/lib/python2.7/dist-packages/pywps/app/Service.py",
> line 371, in _parse_and_execute
>     wps_response = process.execute(wps_request, uuid)
>   File "/usr/local/lib/python2.7/dist-packages/pywps/app/Process.py",
> line 147, in execute
>     wps_response = self._execute_process(self.async, wps_request, wps_response)
>   File "/usr/local/lib/python2.7/dist-packages/pywps/app/Process.py",
> line 173, in _execute_process
>     running = dblog.get_running().count()
>   File "/usr/local/lib/python2.7/dist-packages/pywps/dblog.py", line
> 84, in get_running
>     session = get_session()
>   File "/usr/local/lib/python2.7/dist-packages/pywps/dblog.py", line
> 177, in get_session
>     ProcessInstance.metadata.create_all(engine)
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py",
> line 3404, in create_all
>     tables=tables)
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",
> line 1615, in _run_visitor
>     with self._optional_conn_ctx_manager(connection) as conn:
>   File "/usr/lib/python2.7/contextlib.py", line 17, in __enter__
>     return self.gen.next()
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",
> line 1608, in _optional_conn_ctx_manager
>     with self.contextual_connect() as conn:
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",
> line 1798, in contextual_connect
>     self.pool.connect(),
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line
> 338, in connect
>     return _ConnectionFairy._checkout(self)
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line
> 644, in _checkout
>     fairy = _ConnectionRecord.checkout(pool)
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line
> 440, in checkout
>     rec = pool._do_get()
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line
> 1057, in _do_get
>     return self._create_connection()
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line
> 285, in _create_connection
>     return _ConnectionRecord(self)
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line
> 411, in __init__
>     self.connection = self.__connect()
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line
> 538, in __connect
>     connection = self.__pool._creator()
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/strategies.py",
> line 96, in connect
>     connection_invalidated=invalidated
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py",
> line 199, in raise_from_cause
>     reraise(type(exception), exception, tb=exc_tb)
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/strategies.py",
> line 90, in connect
>     return dialect.connect(*cargs, **cparams)
>   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py",
> line 377, in connect
>     return self.dbapi.connect(*cargs, **cparams)
> OperationalError: (OperationalError) unable to open database file None None
> """
>
> But strangely logging db is created and request stored successfully:
>
> 680667e2-e9a4-11e9-a3ce-0242ac130004|19|execute|1.0.0|2019-10-08
> 08:19:54.067625|2019-10-08 08:19:54.131476|d-rain-shp||100.0|0
>
> Any idea what is wrong? Thanks in advance, Martin
>
> --
> Martin Landa
> http://geo.fsv.cvut.cz/gwiki/Landa
> http://gismentors.cz/mentors/landa
> _______________________________________________
> pywps-dev mailing list
> pywps-dev at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/pywps-dev



-- 
Jachym Cepicky
e-mail: jachym.cepicky gmail com
URL: http://les-ejk.cz
GPG: http://les-ejk.cz/pgp/JachymCepicky.pgp