[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 jef):

 Replying to [comment:4 lutra]:
 > 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

 Ok. With GDAL 1.7 from experimental I can add the the layer.   Is there a
 sample set with multiple rasters?

 > > 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.

 Still no crash on the first case, but on the second with GDAL 1.7.  Fixed
 in
 r13817.

 > > - 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.

 Works fine with GDAL 1.7 for me now, too.

 > > 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.

 I added instructions to UsingTracWithQuantumGis

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