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

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

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

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

Jorge Samuel Mendes de Jesus
Hi Martin

Are you using master branch or develop ?

J.

On Mon, Oct 16, 2017 at 10:43 AM, Martin Landa <[hidden email]> 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
[hidden email]
https://lists.osgeo.org/mailman/listinfo/pywps-dev


_______________________________________________
pywps-dev mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/pywps-dev
Reply | Threaded
Open this post in threaded view
|

Re: 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


-------- 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
To: Martin Landa <[hidden email]>

Hi Martin

Are you using master branch or develop ?

J.

On Mon, Oct 16, 2017 at 10:43 AM, Martin Landa <[hidden email]> wrote:
Hi,

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


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


_______________________________________________
pywps-dev mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/pywps-dev
Reply | Threaded
Open this post in threaded view
|

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

Martin Landa
In reply to this post by Jorge Samuel Mendes de Jesus
Hi,

2017-10-16 11:41 GMT+02:00 Jorge Mendes de Jesus <[hidden email]>:
> Are you using master branch or develop ?

pywps installed using pip (4.0.0). Ma

--
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 demo: Service error: (sqlite3.OperationalError) unable to open database file

Martin Landa
In reply to this post by Luí­s Moreira de Sousa
Hi,

2017-10-16 12:01 GMT+02:00 Luí­s Moreira de Sousa <[hidden email]>:
> Could you try to delete the .sqlite3 file and restart pywps-flask? It seems
> the SQLite file you have got messed up somehow.

I already tried that (remove and create logs directory from scratch),
no change. Ma

--
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 demo: Service error: (sqlite3.OperationalError) unable to open database file

Jorge Samuel Mendes de Jesus
Try to run thingss from github and devleopment


I have the idea that you are reporting an old bug

J.

On Mon, Oct 16, 2017 at 12:51 PM, Martin Landa <[hidden email]> wrote:
Hi,

2017-10-16 12:01 GMT+02:00 Luí­s Moreira de Sousa <[hidden email]>:
> Could you try to delete the .sqlite3 file and restart pywps-flask? It seems
> the SQLite file you have got messed up somehow.

I already tried that (remove and create logs directory from scratch),
no change. Ma


_______________________________________________
pywps-dev mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/pywps-dev
Reply | Threaded
Open this post in threaded view
|

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

Martin Landa
Hi,

2017-10-16 13:19 GMT+02:00 Jorge Mendes de Jesus <[hidden email]>:

right, even master works. Probably time for 4.0.1? :-) Ma

--
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 demo: Service error: (sqlite3.OperationalError) unable to open database file

Jorge Samuel Mendes de Jesus
Thank you for the report just open a ticket
https://github.com/geopython/pywps/issues/305

We need to update the package in pip.

j.

_______________________________________________
pywps-dev mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/pywps-dev
Reply | Threaded
Open this post in threaded view
|

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

Martin Landa
Hi,

2017-10-16 15:12 GMT+02:00 Jorge Mendes de Jesus <[hidden email]>:
> Thank you for the report just open a ticket
> https://github.com/geopython/pywps/issues/305
>
> We need to update the package in pip.

any change that pip will provide a new fixed version of PyWPS within
next few days? I would like to present also PyWPS (together with
GRASS) in workshop in Jena (next week ~16/2). Thanks! Ma

--
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