Hi,
If you also switch off the Cache for the WFS on QGIS. You can do this
when you add the Layer, just uncheck the *Cache Feature* box for the
layer you are trying to load.
Hope this helps!
Regards,
Richard.
On 21/08/2017 19:55, Dan Meerschaert wrote:
When I look in the cache/wfsprovider folder, there's another folder
with almost three times the layer number in other files:
wfs_cache_XX.sqlite, -shm, and -wal.
I had to track down a public wfs with a small enough sample set to be
repeatable. This Python code gives the error in 2.18.7 and a 2.99
nightly I grabbed for testing:
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example01","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example02","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example03","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example04","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example05","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example06","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example07","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example08","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example09","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example00","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example11","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example12","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example13","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example14","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example15","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example16","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example17","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example18","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example19","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example10","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example21","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example22","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example23","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example24","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example25","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example26","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example27","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example28","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example29","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example20","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example31","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example32","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example33","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example34","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example35","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example36","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example37","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example38","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example39","WFS")
iface.addVectorLayer(' restrictToRequestBBOX=\'1\'
srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\'
url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\
<https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>'
version=\'auto\' table="" sql=',"example30","WFS")
On Aug 21, 2017 12:55 PM, "Jorge Gustavo Rocha" <[email protected]
<mailto:[email protected]>> wrote:
Hi Dan,
QGIS uses a local SpatiaLite database to store the features on the
client side. The cache should be in your .qgis2/cache/wfsprovider
folder. Can you check the contents of the folder?
If your WFS is a public server, can your share the service URL and the
layer/layers to reproduce the problem?
Regards,
J. Gustavo
On 21-08-2017 16 <tel:21-08-2017%2016>:42, Dan Meerschaert wrote:
> I'm working on a plugin for QGIS 2.18.7 on Windows that (as a
part of
> its other function) grabs many wfs layers at once.
>
> The problem is, after about 30-50 simultaneous connections, QGIS
throws
> up a "Cannot create temporary SpatiaLite cache" error in the WFS log
> panel and doesn't load all the data.
>
> I'm able to repeat this by picking any given wfs layer, and
duplicating
> it manually using iface.addVectorLayer (...) in the python console.
>
> Can anyone help me out?
>
> Respectfully,
> -Dan
>
>
> _______________________________________________
> Qgis-user mailing list
> [email protected] <mailto:[email protected]>
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
<https://lists.osgeo.org/mailman/listinfo/qgis-user>
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
<https://lists.osgeo.org/mailman/listinfo/qgis-user>
>
J. Gustavo
--
Jorge Gustavo Rocha
Departamento de Informática
Universidade do Minho
4710-057 Braga
Tel: +351 253604480 <tel:%2B351%20253604480>
Fax: +351 253604471 <tel:%2B351%20253604471>
Móvel: +351 910333888 <tel:%2B351%20910333888>
skype: nabocudnosor
_______________________________________________
Qgis-user mailing list
[email protected] <mailto:[email protected]>
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
<https://lists.osgeo.org/mailman/listinfo/qgis-user>
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
<https://lists.osgeo.org/mailman/listinfo/qgis-user>
_______________________________________________
Qgis-user mailing list
[email protected]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
--
*_Richard McDonnell_*
*GIS Specialist PgD GIS AssocSCSI*
*OPW FRM Data Management*
*52 Stephens Green, Dublin 2.*
TEL: 01 6476543
OPW - Ag féachaint don am atá le teacht - Ag caomhnú ón am atá thart
OPW - Looking to the future - Caring for the past
***********************************************************
Email Disclaimer: http://www.opw.ie/en/disclaimer/
_______________________________________________
Qgis-user mailing list
[email protected]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
