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

[Tim Sutton]

Hi


On Thu, Jan 16, 2014 at 3:23 PM, Stott James <fmrojst at fylkesmannen.no>wrote:

>  Thanks for the response Tim.
>
>
>
> I have not been destroying my layers. This has not been an issue when
> running the plugin with 2.0.
>
>
>
> This was the first thing I thought about in the version running against
> master so I added the following code to close the postgis layers as it once
> I am finished with them:
>
>
>
> QgsMapLayerRegistry.instance().removeMapLayer(layer_id)
>
> This has not made it difference. It still hangs at the same place and I
> still get the warning that there is already too many clients when trying to
> connect to PostGIS with DB Manager or pgAdmin.
>
>
>
> Shall I open a bug?
>

Yes it sounds like a bug to me.

Regards

Tim


>
>
> *Fra:* Tim Sutton [mailto:lists at linfiniti.com]
> *Sendt:* 16. januar 2014 13:30
> *Til:* Stott James
> *Kopi:* qgis-developer at lists.osgeo.org
> *Emne:* Re: [Qgis-developer] Issue with standalone python script and
> PostGIS Layers
>
>
>
> 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
> ==============================================
>



-- 
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/c5906d2c/attachment.html>