Bug report #17050
Adding many WFS layers causes "Cannot create temporary SpatiaLite cache"
| Status: | Closed | ||
|---|---|---|---|
| Priority: | Normal | ||
| Assignee: | - | ||
| Category: | Web Services clients/WFS | ||
| Affected QGIS version: | 2.18.12 | Regression?: | No |
| Operating System: | Easy fix?: | No | |
| Pull Request or Patch supplied: | No | Resolution: | up/downstream |
| Crashes QGIS or corrupts data: | No | Copied to github as #: | 24949 |
Description
Many WFS layers added with iface.addVectorLayer seems to overload the WFS cache and prints "Cannot create temporary SpatiaLite cache" to the log.
This error occurs on 2.14, 2.17. and 2.99 that i've tried so far.
To reproduce, add a few dozen WFS layers, save them all as a layer definition and reload, or use the following script in the python console several times (attached .txt)
iface.addVectorLayer(' restrictToRequestBBOX=\'1\' srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\' version=\'auto\' table="" sql=',"example01","WFS")
qgisPythonWFSscript.txt 
(8.4 KB)
Qgis_17050.PNG - log message output (97.4 KB)
History
#1
Updated by Giovanni Manghi over 6 years ago
- Status changed from Open to Feedback
Tried your script on 2.18.12 on Windows and Linux and had no issues.
#2
Updated by Dan Meerschaert over 6 years ago
- File Qgis_17050.PNG added
Giovanni Manghi wrote:
Tried your script on 2.18.12 on Windows and Linux and had no issues.
I just tried on 2.18.12 windows 64bit and got the same problem.
Did you run the attached script? I ask because the problem doesn't happen until layer # 36 or so
#3
Updated by Giovanni Manghi over 6 years ago
- Affected QGIS version changed from 2.18.7 to 2.18.12
Dan Meerschaert wrote:
Giovanni Manghi wrote:
Tried your script on 2.18.12 on Windows and Linux and had no issues.
I just tried on 2.18.12 windows 64bit and got the same problem.
Did you run the attached script? I ask because the problem doesn't happen until layer # 36 or so
yes, I used your script. Have you tried on a clean installation and/or on another system?
#4
Updated by Dan Meerschaert over 6 years ago
Tried on a brand new win10 2.18.12 and the three versions i listed above on the same win7 machine.
#5
Updated by Giovanni Manghi over 6 years ago
- Operating System deleted (
Windows) - Status changed from Feedback to Open
- Subject changed from Many WFS layers causes failures to Adding many WFS layers causes "Cannot create temporary SpatiaLite cache"
#6
Updated by Even Rouault over 6 years ago
I've identified this as a libspatialite issue. Basically we are currently limited to SPATIALITE_MAX_CONNECTIONS / 2 = 32 WFS layers
Thread to discuss increasing this limit: https://groups.google.com/forum/#!topic/spatialite-users/ir7Iz15x_SM
#7
Updated by Even Rouault over 6 years ago
According to libspatialite developer, the issue will be solved by packaging recent libspatialite and GEOS >= 3.5
#8
Updated by Giovanni Manghi over 6 years ago
Even Rouault wrote:
According to libspatialite developer, the issue will be solved by packaging recent libspatialite and GEOS >= 3.5
Should we make a feature request for this?
#9
Updated by Jürgen Fischer over 5 years ago
- Status changed from Open to Feedback
Please test with QGIS 3.4 - QGIS 2.18 reached it's end of life.
#10
Updated by Giovanni Manghi about 5 years ago
- Status changed from Feedback to Closed
- Resolution set to up/downstream