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

[Luí­s Moreira de Sousa]

Hi Martin,

Could you try to delete the .sqlite3 file and restart pywps-flask? It seems the SQLite file you have got messed up somehow.

Cheers.

--
Luís Moreira de Sousa
Im Grund 6
CH-8600 Dübendorf
Switzerland

Phone: +41 (0)79 812 62 65
Email: luis.de.sousa at protonmail.ch
URL: https://sites.google.com/site/luismoreiradesousa

> -------- Original Message --------
> Subject: Re: [Pywps-dev] pywps demo: Service error: (sqlite3.OperationalError) unable to open database file
> Local Time: October 16, 2017 11:41 AM
> UTC Time: October 16, 2017 9:41 AM
> From: jorge.dejesus at geocat.net
> To: Martin Landa <landa.martin at gmail.com>
> pywps-dev at lists.osgeo.org
>
> Hi Martin
>
> Are you using master branch or develop ?
>
> J.
>
> On Mon, Oct 16, 2017 at 10:43 AM, Martin Landa <landa.martin at gmail.com> wrote:
>
>> 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
>> _______________________________________________
>> pywps-dev mailing list
>> pywps-dev at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/pywps-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pywps-dev/attachments/20171016/053fa0ad/attachment-0001.html>