Some Exceptions

Apr 27, 2010 at 3:03 AM

When I run the windows Form demo, I found bellow exceptions in the "outpu" window.

It looks like should I create such SQLite Table first?

GetImageFromCache: System.Data.SQLite.SQLiteException: SQLite errorno such table: TilesData   在 System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)   在 System.Data.SQLite.SQLiteCommand.BuildNextCommand()   在 System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)   在 System.Data.SQLite.SQLiteDataReader.NextResult()   在 System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)   在 System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)   在 System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(CommandBehavior behavior)   在 System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)   在 GMap.NET.CacheProviders.SQLitePureImageCache.GMap.NET.PureImageCache.GetImageFromCache(MapType type, Point pos, Int32 zoom) 位置 C:\Documents and Settings\Administrator\桌面\greatmaps_d8e2cfccfe1c\GMap.NET.Core\GMap.NET.CacheProviders\SQLitePureImageCache.cs:行号 323

 

PutImageToCache: System.Data.SQLite.SQLiteException: SQLite errorno such table: Tiles   在 System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)   在 System.Data.SQLite.SQLiteCommand.BuildNextCommand()   在 System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)   在 System.Data.SQLite.SQLiteDataReader.NextResult()   在 System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)   在 System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)   在 System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()   在 GMap.NET.CacheProviders.SQLitePureImageCache.GMap.NET.PureImageCache.PutImageToCache(MemoryStream tile, MapType type, Point pos, Int32 zoom) 位置 C:\Documents and Settings\Administrator\桌面\greatmaps_d8e2cfccfe1c\GMap.NET.Core\GMap.NET.CacheProviders\SQLitePureImageCache.cs:行号 263

Coordinator
Apr 27, 2010 at 7:26 PM

i wonder what '在' means ;}

Apr 28, 2010 at 1:12 AM

means "at".  :)

Coordinator
Apr 28, 2010 at 12:30 PM

can you show full debug output from the very start?

Apr 29, 2010 at 2:08 AM

------------------OnTileLoadStart: 20 tiles to load at zoom 2, time: 08:57:40.1406250OnTileLoadStart: 25 tiles to load at zoom 2, time: 08:57:40.1562500Fill empty TileMatrix: 2 - {X=41,Y=29}'Demo.WindowsForms.exe' (Managed): Loaded 'C:\Documents and Settings\Administrator\桌面\greatmaps_d8e2cfccfe1c\Build\Debug\System.Data.SQLite.dll''Demo.WindowsForms.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_32\System.Data\2.0.0.0__b77a5c561934e089\System.Data.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.'Demo.WindowsForms.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_32\System.Transactions\2.0.0.0__b77a5c561934e089\System.Transactions.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

A first chance exception of type 'System.Data.SQLite.SQLiteException' occurred in System.Data.SQLite.dllGetImageFromCache: System.Data.SQLite.SQLiteException: Unable to open the database file   在 System.Data.SQLite.SQLite3.Open(String strFilename, SQLiteOpenFlagsEnum flags, Int32 maxPoolSize, Boolean usePool)   在 System.Data.SQLite.SQLiteConnection.Open()   在 GMap.NET.CacheProviders.SQLitePureImageCache.GMap.NET.PureImageCache.GetImageFromCache(MapType type, Point pos, Int32 zoom) 位置 C:\Documents and Settings\Administrator\桌面\greatmaps_d8e2cfccfe1c\GMap.NET.Core\GMap.NET.CacheProviders\SQLitePureImageCache.cs:行号 317

Starting GetResponse: {X=41,Y=29}Fill empty TileMatrix: 2 - {X=37,Y=30}A first chance exception of type 'System.Data.SQLite.SQLiteException' occurred in System.Data.SQLite.dllGetImageFromCache: System.Data.SQLite.SQLiteException: Unable to open the database file   在 System.Data.SQLite.SQLite3.Open(String strFilename, SQLiteOpenFlagsEnum flags, Int32 maxPoolSize, Boolean usePool)   在 System.Data.SQLite.SQLiteConnection.Open()   在 GMap.NET.CacheProviders.SQLitePureImageCache.GMap.NET.PureImageCache.GetImageFromCache(MapType type, Point pos, Int32 zoom) 位置 C:\Documents and Settings\Administrator\桌面\greatmaps_d8e2cfccfe1c\GMap.NET.Core\GMap.NET.CacheProviders\SQLitePureImageCache.cs:行号 317

Starting GetResponse: {X=37,Y=30}Fill empty TileMatrix: 2 - {X=38,Y=29}

A first chance exception of type 'System.Data.SQLite.SQLiteException' occurred in System.Data.SQLite.dllGetImageFromCache: System.Data.SQLite.SQLiteException: Unable to open the database file   在 System.Data.SQLite.SQLite3.Open(String strFilename, SQLiteOpenFlagsEnum flags, Int32 maxPoolSize, Boolean usePool)   在 System.Data.SQLite.SQLiteConnection.Open()   在 GMap.NET.CacheProviders.SQLitePureImageCache.GMap.NET.PureImageCache.GetImageFromCache(MapType type, Point pos, Int32 zoom) 位置 C:\Documents and Settings\Administrator\桌面\greatmaps_d8e2cfccfe1c\GMap.NET.Core\GMap.NET.CacheProviders\SQLitePureImageCache.cs:行号 317

Starting GetResponse: {X=38,Y=29}Fill empty TileMatrix: 2 - {X=40,Y=29}

A first chance exception of type 'System.Data.SQLite.SQLiteException' occurred in System.Data.SQLite.dllGetImageFromCache: System.Data.SQLite.SQLiteException: Unable to open the database file   在 System.Data.SQLite.SQLite3.Open(String strFilename, SQLiteOpenFlagsEnum flags, Int32 maxPoolSize, Boolean usePool)   在 System.Data.SQLite.SQLiteConnection.Open()   在 GMap.NET.CacheProviders.SQLitePureImageCache.GMap.NET.PureImageCache.GetImageFromCache(MapType type, Point pos, Int32 zoom) 位置 C:\Documents and Settings\Administrator\桌面\greatmaps_d8e2cfccfe1c\GMap.NET.Core\GMap.NET.CacheProviders\SQLitePureImageCache.cs:行号 317

Starting GetResponse: {X=40,Y=29}GetResponse OK: {X=37,Y=30}

Starting GetResponseStream: {X=37,Y=30}GetResponseStream OK: {X=37,Y=30}EnqueueCacheTask: {X=37,Y=30}CacheEngine: startFill empty TileMatrix: 2 - {X=39,Y=31}'Demo.WindowsForms.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

A first chance exception of type 'System.Data.SQLite.SQLiteException' occurred in System.Data.SQLite.dllGetImageFromCache: System.Data.SQLite.SQLiteException: SQLite errorno such table: TilesData   在 System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)   在 System.Data.SQLite.SQLiteCommand.BuildNextCommand()   在 System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)   在 System.Data.SQLite.SQLiteDataReader.NextResult()   在 System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)   在 System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)   在 System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(CommandBehavior behavior)   在 System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)   在 GMap.NET.CacheProviders.SQLitePureImageCache.GMap.NET.PureImageCache.GetImageFromCache(MapType type, Point pos, Int32 zoom) 位置 C:\Documents and Settings\Administrator\桌面\greatmaps_d8e2cfccfe1c\GMap.NET.Core\GMap.NET.CacheProviders\SQLitePureImageCache.cs:行号 323

Starting GetResponse: {X=39,Y=31}GetResponse OK: {X=41,Y=29}Starting GetResponseStream: {X=41,Y=29}GetResponseStream OK: {X=41,Y=29}EnqueueCacheTask: {X=41,Y=29}Fill empty TileMatrix: 2 - {X=38,Y=28}

A first chance exception of type 'System.Data.SQLite.SQLiteException' occurred in System.Data.SQLite.dllGetImageFromCache: System.Data.SQLite.SQLiteException: SQLite errorno such table: TilesData   在 System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)   在 System.Data.SQLite.SQLiteCommand.BuildNextCommand()   在 System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)   在 System.Data.SQLite.SQLiteDataReader.NextResult()   在 System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)   在 System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)   在 System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(CommandBehavior behavior)   在 System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)   在 GMap.NET.CacheProviders.SQLitePureImageCache.GMap.NET.PureImageCache.GetImageFromCache(MapType type, Point pos, Int32 zoom) 位置 C:\Documents and Settings\Administrator\桌面\greatmaps_d8e2cfccfe1c\GMap.NET.Core\GMap.NET.CacheProviders\SQLitePureImageCache.cs:行号 323

Starting GetResponse: {X=38,Y=28}GetResponse OK: {X=38,Y=29}Starting GetResponseStream: {X=38,Y=29}GetResponseStream OK: {X=38,Y=29}EnqueueCacheTask: {X=38,Y=29}Fill empty TileMatrix: 2 - {X=41,Y=28}

A first chance exception of type 'System.Data.SQLite.SQLiteException' occurred in System.Data.SQLite.dllGetImageFromCache: System.Data.SQLite.SQLiteException: SQLite errorno such table: TilesData   在 System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)   在 System.Data.SQLite.SQLiteCommand.BuildNextCommand()   在 System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)   在 System.Data.SQLite.SQLiteDataReader.NextResult()   在 System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)   在 System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)   在 System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(CommandBehavior behavior)   在 System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)   在 GMap.NET.CacheProviders.SQLitePureImageCache.GMap.NET.PureImageCache.GetImageFromCache(MapType type, Point pos, Int32 zoom) 位置 C:\Documents and Settings\Administrator\桌面\greatmaps_d8e2cfccfe1c\GMap.NET.Core\GMap.NET.CacheProviders\SQLitePureImageCache.cs:行号 323

Starting GetResponse: {X=41,Y=28}GetResponse OK: {X=39,Y=31}GetResponseStream OK: {X=39,Y=31}EnqueueCacheTask: {X=39,Y=31}Fill empty TileMatrix: 2 - {X=39,Y=29}Fill empty TileMatrix: 2 - {X=41,Y=30}GetResponse OK: {X=38,Y=28}Starting GetResponseStream: {X=38,Y=28}GetResponseStream OK: {X=38,Y=28}EnqueueCacheTask: {X=38,Y=28}Fill empty TileMatrix: 2 - {X=40,Y=28}Starting GetResponse: {X=40,Y=28}Starting GetResponse: {X=39,Y=29}Starting GetResponse: {X=41,Y=30}GetResponse OK: {X=40,Y=29}Starting GetResponseStream: {X=40,Y=29}GetResponseStream OK: {X=40,Y=29}EnqueueCacheTask: {X=40,Y=29}Fill empty TileMatrix: 2 - {X=38,Y=31}Starting GetResponse: {X=38,Y=31}GetResponse OK: {X=40,Y=28}Starting GetResponseStream: {X=40,Y=28}GetResponse OK: {X=39,Y=29}Starting GetResponseStream: {X=39,Y=29}GetResponseStream OK: {X=39,Y=29}EnqueueCacheTask: {X=39,Y=29}Fill empty TileMatrix: 2 - {X=39,Y=30}Starting GetResponse: {X=39,Y=30}GetResponse OK: {X=41,Y=28}Starting GetResponseStream: {X=41,Y=28}GetResponseStream OK: {X=40,Y=28}EnqueueCacheTask: {X=40,Y=28}Fill empty TileMatrix: 2 - {X=38,Y=30}Starting GetResponse: {X=38,Y=30}GetResponse OK: {X=41,Y=30}Starting GetResponseStream: {X=41,Y=30}GetResponseStream OK: {X=41,Y=30}GetResponseStream OK: {X=41,Y=28}EnqueueCacheTask: {X=41,Y=30}EnqueueCacheTask: {X=41,Y=28}Fill empty TileMatrix: 2 - {X=40,Y=31}Starting GetResponse: {X=40,Y=31}Fill empty TileMatrix: 2 - {X=37,Y=28}Starting GetResponse: {X=37,Y=28}GetResponse OK: {X=39,Y=30}Starting GetResponseStream: {X=39,Y=30}'Demo.WindowsForms.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System.resources\2.0.0.0_zh-CHS_b77a5c561934e089\System.resources.dll'GetResponseStream OK: {X=39,Y=30}EnqueueCacheTask: {X=39,Y=30}Fill empty TileMatrix: 2 - {X=40,Y=30}Starting GetResponse: {X=40,Y=30}GetResponse OK: {X=38,Y=31}Starting GetResponseStream: {X=38,Y=31}GetResponseStream OK: {X=38,Y=31}EnqueueCacheTask: {X=38,Y=31}Fill empty TileMatrix: 2 - {X=41,Y=31}Starting GetResponse: {X=41,Y=31}GetResponse OK: {X=40,Y=31}Starting GetResponseStream: {X=40,Y=31}GetResponse OK: {X=38,Y=30}GetResponse OK: {X=40,Y=30}GetResponse OK: {X=41,Y=31}Starting GetResponseStream: {X=38,Y=30}GetResponseStream OK: {X=40,Y=31}Starting GetResponseStream: {X=40,Y=30}Starting GetResponseStream: {X=41,Y=31}GetResponseStream OK: {X=38,Y=30}GetResponseStream OK: {X=40,Y=30}EnqueueCacheTask: {X=40,Y=31}GetResponseStream OK: {X=41,Y=31}EnqueueCacheTask: {X=38,Y=30}Fill empty TileMatrix: 2 - {X=40,Y=27}EnqueueCacheTask: {X=40,Y=30}Starting GetResponse: {X=40,Y=27}Fill empty TileMatrix: 2 - {X=42,Y=28}EnqueueCacheTask: {X=41,Y=31}Fill empty TileMatrix: 2 - {X=37,Y=31}Fill empty TileMatrix: 2 - {X=43,Y=27}Starting GetResponse: {X=42,Y=28}Starting GetResponse: {X=37,Y=31}Starting GetResponse: {X=43,Y=27}GetResponse OK: {X=37,Y=28}Starting GetResponseStream: {X=37,Y=28}GetResponseStream OK: {X=37,Y=28}EnqueueCacheTask: {X=37,Y=28}Fill empty TileMatrix: 2 - {X=42,Y=27}Starting GetResponse: {X=42,Y=27}GetResponse OK: {X=37,Y=31}Starting GetResponseStream: {X=37,Y=31}GetResponseStream OK: {X=37,Y=31}EnqueueCacheTask: {X=37,Y=31}Fill empty TileMatrix: 2 - {X=40,Y=26}Starting GetResponse: {X=40,Y=26}GetResponse OK: {X=43,Y=27}Starting GetResponseStream: {X=43,Y=27}GetResponseStream OK: {X=43,Y=27}EnqueueCacheTask: {X=43,Y=27}Fill empty TileMatrix: 2 - {X=43,Y=26}Starting GetResponse: {X=43,Y=26}GetResponse OK: {X=40,Y=26}Starting GetResponseStream: {X=40,Y=26}GetResponseStream OK: {X=40,Y=26}EnqueueCacheTask: {X=40,Y=26}Fill empty TileMatrix: 2 - {X=43,Y=28}Starting GetResponse: {X=43,Y=28}GetResponse OK: {X=42,Y=27}Starting GetResponseStream: {X=42,Y=27}GetResponseStream OK: {X=42,Y=27}EnqueueCacheTask: {X=42,Y=27}Fill empty TileMatrix: 2 - {X=43,Y=30}Starting GetResponse: {X=43,Y=30}GetResponse OK: {X=40,Y=27}Starting GetResponseStream: {X=40,Y=27}GetResponseStream OK: {X=40,Y=27}EnqueueCacheTask: {X=40,Y=27}Fill empty TileMatrix: 2 - {X=42,Y=30}Starting GetResponse: {X=42,Y=30}GetResponse OK: {X=43,Y=26}Starting GetResponseStream: {X=43,Y=26}GetResponseStream OK: {X=43,Y=26}EnqueueCacheTask: {X=43,Y=26}Fill empty TileMatrix: 2 - {X=39,Y=26}Starting GetResponse: {X=39,Y=26}GetResponse OK: {X=43,Y=30}Starting GetResponseStream: {X=43,Y=30}GetResponseStream OK: {X=43,Y=30}EnqueueCacheTask: {X=43,Y=30}Fill empty TileMatrix: 2 - {X=41,Y=26}Starting GetResponse: {X=41,Y=26}GetResponse OK: {X=42,Y=28}Starting GetResponseStream: {X=42,Y=28}GetResponseStream OK: {X=42,Y=28}EnqueueCacheTask: {X=42,Y=28}Fill empty TileMatrix: 2 - {X=42,Y=26}GetResponse OK: {X=42,Y=30}Starting GetResponseStream: {X=42,Y=30}GetResponseStream OK: {X=42,Y=30}Starting GetResponse: {X=42,Y=26}EnqueueCacheTask: {X=42,Y=30}Fill empty TileMatrix: 2 - {X=42,Y=29}Starting GetResponse: {X=42,Y=29}GetResponse OK: {X=39,Y=26}Starting GetResponseStream: {X=39,Y=26}GetResponseStream OK: {X=39,Y=26}EnqueueCacheTask: {X=39,Y=26}Fill empty TileMatrix: 2 - {X=43,Y=29}GetResponse OK: {X=43,Y=28}Starting GetResponseStream: {X=43,Y=28}GetResponseStream OK: {X=43,Y=28}EnqueueCacheTask: {X=43,Y=28}Starting GetResponse: {X=43,Y=29}Fill empty TileMatrix: 2 - {X=41,Y=27}Starting GetResponse: {X=41,Y=27}GetResponse OK: {X=42,Y=26}Starting GetResponseStream: {X=42,Y=26}GetResponseStream OK: {X=42,Y=26}EnqueueCacheTask: {X=42,Y=26}Fill empty TileMatrix: 2 - {X=37,Y=29}Starting GetResponse: {X=37,Y=29}GetResponse OK: {X=42,Y=29}Starting GetResponseStream: {X=42,Y=29}GetResponseStream OK: {X=42,Y=29}EnqueueCacheTask: {X=42,Y=29}Fill empty TileMatrix: 2 - {X=39,Y=28}Starting GetResponse: {X=39,Y=28}GetResponse OK: {X=41,Y=26}Starting GetResponseStream: {X=41,Y=26}GetResponseStream OK: {X=41,Y=26}EnqueueCacheTask: {X=41,Y=26}Fill empty TileMatrix: 2 - {X=39,Y=27}Starting GetResponse: {X=39,Y=27}GetResponse OK: {X=39,Y=28}Starting GetResponseStream: {X=39,Y=28}GetResponseStream OK: {X=39,Y=28}EnqueueCacheTask: {X=39,Y=28}GetResponse OK: {X=43,Y=29}Starting GetResponseStream: {X=43,Y=29}GetResponseStream OK: {X=43,Y=29}EnqueueCacheTask: {X=43,Y=29}GetResponse OK: {X=41,Y=27}Starting GetResponseStream: {X=41,Y=27}OnTileLoadComplete: 9877ms, MemoryCacheSize: 0.248805999755859MBGetResponseStream OK: {X=41,Y=27}EnqueueCacheTask: {X=41,Y=27}GetResponse OK: {X=39,Y=27}Starting GetResponseStream: {X=39,Y=27}GetResponseStream OK: {X=39,Y=27}EnqueueCacheTask: {X=39,Y=27}GetResponse OK: {X=37,Y=29}Starting GetResponseStream: {X=37,Y=29}GetResponseStream OK: {X=37,Y=29}EnqueueCacheTask: {X=37,Y=29}CacheEngine: stopThe thread '<No Name>' (0x1f8) has exited with code 0 (0x0).

 

Coordinator
Apr 29, 2010 at 6:56 PM

hm.. Unable to open the database file, no such table: TilesData ;/