<div dir="ltr">Hi<div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Jan 16, 2014 at 3:23 PM, Stott James <span dir="ltr"><<a href="mailto:fmrojst@fylkesmannen.no" target="_blank">fmrojst@fylkesmannen.no</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="NO-BOK" link="blue" vlink="purple">
<div>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Thanks for the response Tim.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">I have not been destroying my layers. This has not been an issue when running the plugin with 2.0.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">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:<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal" style="margin-bottom:7.5pt;background:whitesmoke;word-break:break-all">
<span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:#333333">QgsMapLayerRegistry</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:#666666">.</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:#333333">instance()</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:#666666">.</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Courier New";color:#333333">removeMapLayer(layer_id)<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">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.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Shall I open a bug?</span></p></div></div></blockquote><div><br></div><div>Yes it sounds like a bug to me.</div>
<div><br></div><div>Regards</div><div><br></div><div>Tim</div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang="NO-BOK" link="blue" vlink="purple">
<div><p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">Fra:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Tim Sutton [mailto:<a href="mailto:lists@linfiniti.com" target="_blank">lists@linfiniti.com</a>]
<br>
<b>Sendt:</b> 16. januar 2014 13:30<br>
<b>Til:</b> Stott James<br>
<b>Kopi:</b> <a href="mailto:qgis-developer@lists.osgeo.org" target="_blank">qgis-developer@lists.osgeo.org</a><br>
<b>Emne:</b> Re: [Qgis-developer] Issue with standalone python script and PostGIS Layers<u></u><u></u></span></p><div><div class="h5">
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<div>
<p class="MsoNormal">Hi<u></u><u></u></p>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><u></u> <u></u></p>
<div>
<p class="MsoNormal">On Thu, Jan 16, 2014 at 11:06 AM, Stott James <<a href="mailto:fmrojst@fylkesmannen.no" target="_blank">fmrojst@fylkesmannen.no</a>> wrote:<u></u><u></u></p>
<div>
<div>
<p class="MsoNormal"><span lang="EN-US">Hello all,</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US"> </span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US">I have a standalone python script that creates a bunch of PDFs for me.</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US"> </span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US">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.</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US"> </span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US">It makes about 42 PDFs then it stops.</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US"> </span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US">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.</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US"> </span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US">From the log file that my script creates, I know that it is hanging with this line of code:</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US"> </span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US">vlayer = QgsVectorLayer(uri.uri(), layerName, "postgres")</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US"> </span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US">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.</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US"> </span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US">Has anyone any suggestions as to what is wrong here? Is this a bug?</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US"> </span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US">I updated QGIS dev this morning using the OSGeo4W installer (its revision is eb9ce3a).</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US"> </span><u></u><u></u></p>
</div>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">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....<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Regards<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Tim<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal"><span lang="EN-US">James Stott</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US"> </span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US" style="background:white">GIS-koordinator</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US" style="background:white">Administrasjonsavdelinga</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US" style="background:white">Fylkesmannen i Rogaland</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US" style="background:white"> </span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US" style="background:white">Tele</span><span style="background:white">fon: 51568793</span><u></u><u></u></p>
<p class="MsoNormal"><span style="background:white"><a href="mailto:james.stott@fylkesmannen.no" target="_blank">james.stott@fylkesmannen.no</a></span><u></u><u></u></p>
<p class="MsoNormal"><span style="background:white"><a href="http://www.temakart-rogaland.no" target="_blank">http://www.temakart-rogaland.no</a></span><u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"><br>
_______________________________________________<br>
Qgis-developer mailing list<br>
<a href="mailto:Qgis-developer@lists.osgeo.org" target="_blank">Qgis-developer@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/qgis-developer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a><u></u><u></u></p>
</blockquote>
</div>
<p class="MsoNormal"><br>
<br clear="all">
<u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<p class="MsoNormal">-- <u></u><u></u></p>
<div>
<p class="MsoNormal">Tim Sutton - QGIS Project Steering Committee Member<br>
==============================================<br>
Please do not email me off-list with technical<br>
support questions. Using the lists will gain<br>
more exposure for your issues and the knowledge<br>
surrounding your issue will be shared with all.<br>
<br>
Irc: timlinux on #qgis at <a href="http://freenode.net" target="_blank">freenode.net</a><br>
==============================================<u></u><u></u></p>
</div>
</div>
</div>
</div></div></div>
</div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr">Tim Sutton - QGIS Project Steering Committee Member<br>==============================================<br>Please do not email me off-list with technical<br>
support questions. Using the lists will gain<br>more exposure for your issues and the knowledge<br>surrounding your issue will be shared with all.<br><br>Irc: timlinux on #qgis at <a href="http://freenode.net" target="_blank">freenode.net</a><br>
==============================================</div>
</div></div>