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

[Tim Sutton]

Hi


On Thu, Jan 16, 2014 at 11:06 AM, Stott James <fmrojst at fylkesmannen.no>wrote:

>  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).
>
>
>

If you are creating postgis layers in a loop, are you making sure to
destroy them again nicely in your loop? Anyway if it used to work before
maybe there was a regression somewhere....

Regards

Tim


>  James Stott
>
>
>
> GIS-koordinator
>
> Administrasjonsavdelinga
>
> Fylkesmannen i Rogaland
>
>
>
> Telefon: 51568793
>
> james.stott at fylkesmannen.no
>
> http://www.temakart-rogaland.no
>
>
>
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>



-- 
Tim Sutton - QGIS Project Steering Committee Member
==============================================
Please do not email me off-list with technical
support questions. Using the lists will gain
more exposure for your issues and the knowledge
surrounding your issue will be shared with all.

Irc: timlinux on #qgis at freenode.net
==============================================
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20140116/636b6368/attachment.html>