[Qgis-developer] Issue with standalone python script and PostGIS Layers

Stott James fmrojst at fylkesmannen.no
Thu Jan 16 01:06:53 PST 2014

Hello all,

I have a standalone python script that creates a bunch of PDFs for me.

Recently this script has developed an issue. It uses QGIS-dev so it could be related to some of the changes in master recently as it works fine with QGIS 2.0.

It makes about 42 PDFs then it stops.

It is not actually crashing as such, as you can see it running in task manager. It stays running using between 0 and 2% processor, and fluctuates a little with memory use (around 108840kB). But it does not produce any more PDFs. It is like it is stuck.

>From the log file that my script creates, I know that it is hanging with this line of code:

vlayer = QgsVectorLayer(uri.uri(), layerName, "postgres")

If I try and connect to the database using DB Manager in QGIS or pgAdmin III while the script is still running, I get an error saying there is already too many clients already. If I kill the process in windows task manager, I am then able to connect to the database using DB manager.

Has anyone any suggestions as to what is wrong here? Is this a bug?

I updated QGIS dev this morning using the OSGeo4W installer (its revision is eb9ce3a).

James Stott

Fylkesmannen i Rogaland

Telefon: 51568793
james.stott at fylkesmannen.no<mailto:james.stott at fylkesmannen.no>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20140116/3e262014/attachment.html>

More information about the Qgis-developer mailing list