[QGIS-trac] Re: [Quantum GIS] #2840: adding an empty spatialite db causes qgis to crash

[Quantum GIS]

#2840: adding an empty spatialite db causes qgis to crash
---------------------------------------------------------+------------------
   Reporter:  lutra                                      |              Owner:  nobody       
       Type:  bug                                        |             Status:  new          
   Priority:  critical: causes crash or data corruption  |          Milestone:  Version 1.5.0
  Component:  Data Provider                              |            Version:  HEAD         
   Keywords:                                             |   Platform_version:               
   Platform:  Debian                                     |           Must_fix:  No           
Status_info:  0                                          |  
---------------------------------------------------------+------------------

Comment(by lutra):

 Hi,


 Replying to [comment:3 jef]:
 > We don't have support for rasterlite.  So it's an unsupported
 datasource.


 well, gdal 1.7 supports it, so I was just playing around. In any case if
 you try open a rasterlite db trough "add raster layer" it works fine...
 since the db has just one raster map, see #1040



 > When I try to add spatialite layers using OGR (ie. "Add Vector
 Layers...") I get:
 > - on a completely empty sqlite database:  "empty.db is not a valid or
 recognized datasource".
 > - on a fresh spatialite database without any layers: a sublayer list
 with geom_ref_sys, geometry_columns and spatial_ref_sys. and selecting a
 table produces a mostly useless layer,


 In these two cases here I'm getting the crash, see the above message.


 > - on a spatialite database with layers: adding a "valid" layer also
 produces a useless layer.


 If the SL db has at least one layer in it, it works fine for me. If it has
 more than one qgis correctly present the window to let choose what layers
 to load, and it all shows fine in the qgis canvas. I used the SL sample
 dataset.



 > Why are you trying to you OGR instead of the spatialite provider?


 for no reason in particular, as is valid ogr datasource I was testing qgis
 behavior.


 > Anyway still no crash. Are you sure that you don't have any other
 misbehaving plugins?  What about a backtrace?


 I removed all the plugins (removed the entire .qgis directory) and I still
 see the crash when opening empty SL or sqlite dbs.

 If you please help me on how obtain the backtrace I will post it back
 right after.


 cheers

-- 
Ticket URL: <http://trac.osgeo.org/qgis/ticket/2840#comment:4>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS viewer/editor supporting OGR, PostGIS, and GRASS formats