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

Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

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

Martin Landa
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
[hidden email]
https://lists.osgeo.org/mailman/listinfo/pywps-dev
Reply | Threaded
Open this post in threaded view
|

Re: 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 <[hidden email]> 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
> [hidden email]
> 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
_______________________________________________
pywps-dev mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/pywps-dev