https://issues.qgis.org/https://issues.qgis.org/favicon.ico2014-11-25T03:38:55ZQGIS Issue TrackingQGIS Application - Bug report #11722: Hang on Identify Feature on Oracle layershttps://issues.qgis.org/issues/11722?journal_id=577692014-11-25T03:38:55ZJürgen Fischerjef@norbit.de
<ul></ul><p>Not reproducable here. Please add more details.</p> QGIS Application - Bug report #11722: Hang on Identify Feature on Oracle layershttps://issues.qgis.org/issues/11722?journal_id=577702014-11-25T03:39:25ZJürgen Fischerjef@norbit.de
<ul><li><strong>Status</strong> changed from <i>Open</i> to <i>Feedback</i></li><li><strong>Priority</strong> changed from <i>High</i> to <i>Normal</i></li></ul> QGIS Application - Bug report #11722: Hang on Identify Feature on Oracle layershttps://issues.qgis.org/issues/11722?journal_id=577852014-11-25T21:06:48ZAlexander Novoselovsanyasi.ru@gmail.com
<ul></ul><p>the same <a class="issue tracker-1 status-5 priority-5 priority- closed" href="https://issues.qgis.org/issues/11744" title="After activation action in window Feature attributes - Crash (Closed)">#11744</a> ?</p> QGIS Application - Bug report #11722: Hang on Identify Feature on Oracle layershttps://issues.qgis.org/issues/11722?journal_id=577882014-11-25T22:59:16ZJürgen Fischerjef@norbit.de
<ul><li><strong>Subject</strong> changed from <i>Identify Feature crashes QGIS on Oracle-objects</i> to <i>Hang on Identify Feature on Oracle layers</i></li></ul> QGIS Application - Bug report #11722: Hang on Identify Feature on Oracle layershttps://issues.qgis.org/issues/11722?journal_id=578122014-11-27T00:41:54ZPer Engström
<ul><li><strong>File</strong> <a href="/attachments/download/8149/141125_QGIS_Identfy_Feature_Oracle_object_Error_Forced_Quit.png">141125_QGIS_Identfy_Feature_Oracle_object_Error_Forced_Quit.png</a> added</li><li><strong>File</strong> <a href="/attachments/download/8148/141125_QGIS_Identfy_Feature_Oracle_object_Error_unresponsive_Endless_Loop.png">141125_QGIS_Identfy_Feature_Oracle_object_Error_unresponsive_Endless_Loop.png</a> added</li></ul><p>The workspace has both locally stored shape-layers, externally stored shape-layers and externally stored Oracle-layers.</p>
<p>QGIS connects to the Oracle-server a show the Oracle-layers on the map after a initial delay. When right-clicking on the Oracle-layers I can view and search the Oracle attribute table.</p>
<p>However, when using the Identify Feature tool on Oracle features QGIS hangs in a endless loop and the entire QGIS program window gets grayed/whitened (as shown in attached screen-dumps). QGIS has to be forced to quit. Happens every time we use the Identify Feature tool on Oracle-layers.</p> QGIS Application - Bug report #11722: Hang on Identify Feature on Oracle layershttps://issues.qgis.org/issues/11722?journal_id=578322014-11-27T21:30:00ZJürgen Fischerjef@norbit.de
<ul></ul><p>Per Engström wrote:</p>
<blockquote>
<p>However, when using the Identify Feature tool on Oracle features QGIS hangs in a endless loop and the entire QGIS program window gets grayed/whitened (as shown in attached screen-dumps). QGIS has to be forced to quit. Happens every time we use the Identify Feature tool on Oracle-layers.</p>
</blockquote>
<p>As said I can't reproduce that here, in other words identify works fine for me on oracle layers. There must be something special about your installation. Do you get any messages in the message log regarding Oracle?</p> QGIS Application - Bug report #11722: Hang on Identify Feature on Oracle layershttps://issues.qgis.org/issues/11722?journal_id=578352014-11-27T23:44:02ZPer Engström
<ul><li><strong>File</strong> <a href="/attachments/download/8150/141128_qgis_startup_log_message_before_it_hangs.PNG">141128_qgis_startup_log_message_before_it_hangs.PNG</a> added</li></ul><p>I checked the message log viewed within QGIS and immediatly after loading the workspace/projektfile I have the following in the Message Log (Oracle Tab):</p>
<p>"No spatial index on column XXX_XXXX.XXX_VPOINT.SHAPE found - expect poor performance."</p>
<p>There is an identical message for each of the Oracle layers.</p>
<p>I cannot find any log that is time stamped at the hang event. When I use the Identify Feature tool QGIS hangs and I can not find any log entries regarding either Identify Feature or the crasch time stamp. <br />I don't really know where and what to look for...</p> QGIS Application - Bug report #11722: Hang on Identify Feature on Oracle layershttps://issues.qgis.org/issues/11722?journal_id=578362014-11-27T23:49:55ZPer Engström
<ul></ul><p>I get the same Oracle Log Message in both QGIS 2.4.0.1 and 2.6.0 (2.6.0 reports in swedish).</p> QGIS Application - Bug report #11722: Hang on Identify Feature on Oracle layershttps://issues.qgis.org/issues/11722?journal_id=578372014-11-28T01:10:18ZJürgen Fischerjef@norbit.de
<ul></ul><p>Per Engström wrote:</p>
<blockquote>
<p>I checked the message log viewed within QGIS and immediatly after loading the workspace/projektfile I have the following in the Message Log (Oracle Tab):</p>
<p>"No spatial index on column XXX_XXXX.XXX_VPOINT.SHAPE found - expect poor performance."</p>
<p>There is an identical message for each of the Oracle layers.</p>
</blockquote>
<p>Are those views? Master should handle those better. Otherwise have you tried to create a spatial index (vector layer properties, general tab, create spatial index) ?</p>
<blockquote>
<p>I cannot find any log that is time stamped at the hang event. When I use the Identify Feature tool QGIS hangs and I can not find any log entries regarding either Identify Feature or the crasch time stamp.</p>
</blockquote>
<p>It isn't crashing, is it? It just takes ages to do the query - and that's probably because of the missing (or not detected) spatial index.</p> QGIS Application - Bug report #11722: Hang on Identify Feature on Oracle layershttps://issues.qgis.org/issues/11722?journal_id=578412014-11-28T03:15:23ZPer Engström
<ul></ul><p>The Oracle Log Messages refers to Oracle Spatial layers containing water and sewage piping and valves, they are correctly projected on the map and I can view and search their attribute tables.</p>
<p>I have left it running as is for hours and nothing happens, it doesn't respond.</p>
<p>I tried to create Spatial Index as you proposed, it tried for a couple of seconds then presented an error message. Message Log (Oracle-tab) as follows:</p>
<p>"Creation spatial index failed.<br />SQL:CREATE INDEX QGIS_IDX_0000000001 ON "XXXXX_XXXXX"."XXX_XXXX_XXXX_VPOINT"("SHAPE") INDEXTYPE IS MDSYS.SPATIAL_INDEX PARALLEL<br />Error: ORA-01702: a view is not appropriate here<br />Kan inte köra uttryck"</p>
<p>("Kan inte köra uttryck" means "Can not run expression").</p>
<p>Could it be that I am using separate login credentials to the Oracle Server - view only login with QGIS and edit login with the proprietary AutoCAD Map 3D plugin?</p>
<p>Must I have write access to the Oracle server to create Spatial Index? Can the Spatial Indexing be done outside QGIS directly on the Oracle server?</p> QGIS Application - Bug report #11722: Hang on Identify Feature on Oracle layershttps://issues.qgis.org/issues/11722?journal_id=578422014-11-28T04:02:52ZJürgen Fischerjef@norbit.de
<ul><li><strong>Status</strong> changed from <i>Feedback</i> to <i>Closed</i></li><li><strong>Resolution</strong> set to <i>duplicate</i></li></ul><p>Per Engström wrote:</p>
<blockquote>
<p>Jürgen Fischer wrote:</p>
<blockquote>
<p>Are those views? Master should handle those better. Otherwise have you tried to create a spatial index (vector layer properties, general tab, create spatial index) ?</p>
</blockquote>
<p>Error: ORA-01702: a view is not appropriate here</p>
</blockquote>
<p>Ok, so you confirm that the layer is referring to a view. And hence this issue is a duplicate of <a class="issue tracker-1 status-5 priority-4 priority- closed" href="https://issues.qgis.org/issues/11358" title="Spatial index is not used in Oracle views (Closed)">#11358</a>. The issue is already fixed in master and views should perform much better there.</p> QGIS Application - Bug report #11722: Hang on Identify Feature on Oracle layershttps://issues.qgis.org/issues/11722?journal_id=578432014-11-28T04:19:58ZPer Engström
<ul></ul><p>Ok, nice work :) The master you are referring to, is it going to be released as 2.8.0? When will it be out?<br />Best Regards!<br />Per Engström</p> QGIS Application - Bug report #11722: Hang on Identify Feature on Oracle layershttps://issues.qgis.org/issues/11722?journal_id=578462014-11-28T05:25:05ZJürgen Fischerjef@norbit.de
<ul></ul><p>Per Engström wrote:</p>
<blockquote>
<p>Ok, nice work :) The master you are referring to, is it going to be released as 2.8.0? When will it be out?<br />Best Regards!<br />Per Engström</p>
</blockquote>
<p>2.8.0 is planned for 20.02.2015 (see <a href="http://www.qgis.org/en/site/getinvolved/development/index.html#release-schedule" class="external">release schedule</a>). But you can verify right now using a nightly build or a weekly snapshot (links in the section following the release schedule), if master actually solves the problem for you.</p> QGIS Application - Bug report #11722: Hang on Identify Feature on Oracle layershttps://issues.qgis.org/issues/11722?journal_id=578472014-11-28T07:05:28ZPer Engström
<ul><li><strong>File</strong> <a href="/attachments/download/8152/141128_NEW__CLUE__-_all_objects_seem_to_have_been_selected_by_the_Identify_Feature_tool___QGIS_Identify_Feature_hang_on_fresh_layer_QGIS_f00db95__2.7.0_Master__.PNG">141128_NEW__CLUE__-_all_objects_seem_to_have_been_selected_by_the_Identify_Feature_tool___QGIS_Identify_Feature_hang_on_fresh_layer_QGIS_f00db95__2.7.0_Master__.PNG</a> added</li><li><strong>File</strong> <a href="/attachments/download/8151/141128_QGIS_Identify_Feature_hang_on_fresh_layer_QGIS_f00db95__2.7.0_Master_.PNG">141128_QGIS_Identify_Feature_hang_on_fresh_layer_QGIS_f00db95__2.7.0_Master_.PNG</a> added</li></ul><p>Hello again! I have now tested with Master f00db95 (2.7.0) and it seems to be no difference, the program hangs after the Identify Feature tool have been used. Nothing happened for several minutes so I took a screen-shot to describe the process, planning to leave it running over the weekend.</p>
<p>I left QGIS running despite the hang while I edited the screen-shot, but when I was ready with the screen-shot I noticed in QGIS upper right corner still visible that ALL OBJECTS HAD BEEN SELECTED AND MARKED WITH RED! QGIS-program totally frozen and unresponsive but all those Oracle layer objects had been selected while I was occupied editing the screenshot!</p>
<p>Going to leave it running as is over the weekend to see how it looks come monday.</p>
<p>Until then!</p>
<p>/Per</p> QGIS Application - Bug report #11722: Hang on Identify Feature on Oracle layershttps://issues.qgis.org/issues/11722?journal_id=578502014-11-28T10:48:38ZJürgen Fischerjef@norbit.de
<ul></ul><p>Per Engström wrote:</p>
<blockquote>
<p>Hello again! I have now tested with Master f00db95 (2.7.0) and it seems to be no difference, the program hangs after the Identify Feature tool have been used. Nothing happened for several minutes so I took a screen-shot to describe the process, planning to leave it running over the weekend.</p>
</blockquote>
<p>No need - if you see "expect poor performance" there will be poor performance. Does the problem also occur when you use the geometry table instead of the view?</p>
<p>Please run the following query in <code>sqlplus</code> and report what it produces:</p>
<pre>
SELECT shape FROM vab_view_mapx_vline WHERE sdo_filter(shape,mdsys.sdo_geometry(2003,NULL,NULL,mdsys.sdo_elem_info_array(1,1003,3),mdsys.sdo_ordinate_array(1,1,-1,-1)))='TRUE';
</pre> QGIS Application - Bug report #11722: Hang on Identify Feature on Oracle layershttps://issues.qgis.org/issues/11722?journal_id=578892014-11-30T23:40:42ZPer Engström
<ul><li><strong>File</strong> <a href="/attachments/download/8165/141201_QGIS_Identify_Feature_Hang_after_running_over_weekend_-_still_not_responding.PNG">141201_QGIS_Identify_Feature_Hang_after_running_over_weekend_-_still_not_responding.PNG</a> added</li><li><strong>File</strong> <a href="/attachments/download/8166/141201_QGIS_Identify_Feature_Hang_-_SQLplus_query_error_codes.PNG">141201_QGIS_Identify_Feature_Hang_-_SQLplus_query_error_codes.PNG</a> added</li></ul><p>Hello again. I left QGIS running over the weekend and at first glance it looked OK but it was still totally froozen and did not answer to anything, however it is apparent that QGIS selects all object instead of just the one clicked on when using the Identify Feature tool.</p>
<p>I ran the SQL query in SQLplus as you asked and it returned three error codes in broken swedish (only the cides presented here, see added screendump for full text):<br />ORA-29902<br />ORA-13208<br />ORA-06512</p>
<p>I do not fully understand what this mean, but I guess it mean what you already have said, that it is a configuration issue?</p>