<div dir="ltr">Hi<div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Jan 16, 2014 at 11:06 AM, 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">Hello all,<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">I have a standalone python script that creates a bunch of PDFs for me.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></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.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">It makes about 42 PDFs then it stops.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></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.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></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:<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">vlayer = QgsVectorLayer(uri.uri(), layerName, "postgres")<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></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.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Has anyone any suggestions as to what is wrong here? Is this a bug?<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">I updated QGIS dev this morning using the OSGeo4W installer (its revision is eb9ce3a).<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> </span></p></div></div></blockquote><div><br></div><div>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....</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"><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">James Stott<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="background:white">GIS-koordinator<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="background:white">Administrasjonsavdelinga</span><span lang="EN-US"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="background:white">Fylkesmannen i Rogaland<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="background:white"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="background:white">Tele</span><span style="background:white">fon: 51568793<u></u><u></u></span></p>
<p class="MsoNormal"><span style="background:white"><a href="mailto:james.stott@fylkesmannen.no" target="_blank">james.stott@fylkesmannen.no</a><u></u><u></u></span></p>
<p class="MsoNormal"><span style="background:white"><a href="http://www.temakart-rogaland.no" target="_blank">http://www.temakart-rogaland.no</a><u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
<br>_______________________________________________<br>
Qgis-developer mailing list<br>
<a href="mailto:Qgis-developer@lists.osgeo.org">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><br></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>