https://issues.qgis.org/https://issues.qgis.org/favicon.ico2013-11-25T00:58:57ZQGIS Issue TrackingQGIS Application - Bug report #9119: srs.db not closed (with OTF reprojection)https://issues.qgis.org/issues/9119?journal_id=466112013-11-25T00:58:57ZMatthias Kuhn
<ul><li><strong>Status</strong> changed from <i>Open</i> to <i>Feedback</i></li></ul><p>Can you run the following command when this happens next time, replacing [qgis-pid] with the actual pid</p>
<p><code>ls -l /proc/[qgis-pid]/fd/</code></p> QGIS Application - Bug report #9119: srs.db not closed (with OTF reprojection)https://issues.qgis.org/issues/9119?journal_id=466132013-11-25T01:41:34ZLuigi Pirelliluipir@gmail.com
<ul></ul><p>hmmm... seems is related to my opened db by my new plugin</p>
<p>it's full of: /tmp/srs.db</p>
<p>generating 20 more every zoom!</p>
<p>so probably it's my fault... one more check and after I'll close this ticket</p> QGIS Application - Bug report #9119: srs.db not closed (with OTF reprojection)https://issues.qgis.org/issues/9119?journal_id=466142013-11-25T02:08:27ZLuigi Pirelliluipir@gmail.com
<ul></ul><p>no... it's not my fault!</p>
<p>on fly repropjection open 12 /tmp/srs.db EVERY zoom or canvas redraw!</p>
<p>I don't know if it's related with dataProvider type (spatialite)</p>
<p>it's possibile to generate e lot of /tmp/srs.db doing this steps:</p>
<p>0) open qgis<br />0.1) ls -l /proc/<qgis pid>/fd/ |wc = 18 (more or less constant during normal operation)<br />1) create a spatialite layer in a proyection (I've a multipolygon in srid 32632)<br />2) set project on fly projection with other srid (I've current srid to 3003)<br />3) load spatialite layer<br />4) ls -l /proc/<qgis pid>/fd/ |wc = X<br />5) zoom<br />6) ls -l /proc/<qgis pid>/fd/ |wc = X+12</p>
<p>probably we have to change the issue title to somthing like: "On the fly reprojection doesn't close related files /tmp/srs.db"</p>
<p>I leave this issue opened</p> QGIS Application - Bug report #9119: srs.db not closed (with OTF reprojection)https://issues.qgis.org/issues/9119?journal_id=466162013-11-25T02:42:45ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Affected QGIS version</strong> changed from <i>2.0.1</i> to <i>master</i></li><li><strong>Target version</strong> changed from <i>Version 2.0.0</i> to <i>Future Release - High Priority</i></li><li><strong>Priority</strong> changed from <i>Normal</i> to <i>Severe/Regression</i></li><li><strong>Category</strong> changed from <i>83</i> to <i>Projection Support</i></li></ul><p>I cannot add any technical detail but I can certainly confirm this issue as I have seen it many times in the last days on qgis master.</p> QGIS Application - Bug report #9119: srs.db not closed (with OTF reprojection)https://issues.qgis.org/issues/9119?journal_id=466172013-11-25T03:23:48ZMatthias Kuhn
<ul><li><strong>Status</strong> changed from <i>Feedback</i> to <i>Open</i></li><li><strong>Subject</strong> changed from <i>"Too many open files" trying to save style</i> to <i>srs.db not closed (with OTF reprojection)</i></li></ul> QGIS Application - Bug report #9119: srs.db not closed (with OTF reprojection)https://issues.qgis.org/issues/9119?journal_id=466182013-11-25T04:32:28ZMarco Hugentoblermarco.hugentobler@sourcepole.ch
<ul><li><strong>Status</strong> changed from <i>Open</i> to <i>Feedback</i></li></ul><p>There was a missing delete / db close. However, it does not explain why the number of open db grows with every zoom.<br />Could you git pull and see if the issue is still there?</p> QGIS Application - Bug report #9119: srs.db not closed (with OTF reprojection)https://issues.qgis.org/issues/9119?journal_id=466192013-11-25T05:01:58ZLuigi Pirelliluipir@gmail.com
<ul></ul><p>it works :)</p>
<p>19 opened at the open of qgis<br />37 after opened my project... after a while down to 25<br />zoom... remain 25 and after a while down to 23!</p>
<p>gooooood :)</p> QGIS Application - Bug report #9119: srs.db not closed (with OTF reprojection)https://issues.qgis.org/issues/9119?journal_id=466242013-11-25T08:08:01ZMatthias Kuhn
<ul></ul><p>Thank you for the quick fix Marco.<br />It seems this can be closed.</p>
<p>Out of curiosity, is there a reason to have it open more than once?</p> QGIS Application - Bug report #9119: srs.db not closed (with OTF reprojection)https://issues.qgis.org/issues/9119?journal_id=473502014-01-12T07:55:00ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Status</strong> changed from <i>Feedback</i> to <i>Closed</i></li><li><strong>Resolution</strong> set to <i>fixed/implemented</i></li></ul>