[gdal-dev] ERROR: Too many connections: max 64

Fri Nov 29 04:47:38 PST 2019

Hi,

The changes that are pending in the wal and shm files are written into the database automatically when the last connection to the database is closed https://sqlite.org/wal.html. There are other ways to invoke checkpoint, but if you have for example opened some layer from the database into QGIS map the checkpoint cannot write the changes into the database because QGIS and SQLite must have a common understanding about what was the contents of the layer when QGIS opened it. Closing the connections when you do not need them anymore should help with the max 64 problem as well.

-Jukka Rahkonen-

Shane Carey wrote:

>After processing, is there a way to release the wal and shm files? I'm on
>qgis3.4.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20191129/cf750c8e/attachment.html>