Hi Dan, I can reproduce the error. Please fill a new bug in https://issues.qgis.org
There was a related issue (#15602) that is already closed. I think the problem you are facing is different. Meanwhile you can download the data in a script to a temporary folder, while the wfs provider is fixed. Something like curl is enough to download the data: curl "https://maps-public.geo.nyu.edu/geoserver/sdr/wfs?service=WFS&version=2.0.0&request=GetFeature&typenames=sdr:nyu_2451_34490" -o nyu_2451_34490.gml I hope it helps. Regards, J. Gustavo 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> > > J. Gustavo -- Jorge Gustavo Rocha Departamento de Informática Universidade do Minho 4710-057 Braga Tel: +351 253604480 Fax: +351 253604471 Móvel: +351 910333888 skype: nabocudnosor _______________________________________________ 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
