I am seeing a similar error since upgrading to 1.0.80.0. I am still working on trying to reproduce it, but here is a stack trace:
All of our Connections and Statements are wrapped in using statements and being disposed correctly. I will report with more if I am able to reproduce this with a unit test. 2012-04-28 13:47:54,100 [20] ERROR Pluck.SiteLife.Daapi.Cache.DaapiRequestCache.Get(C:\msys\home\sitelife\ApiSite\Daapi\Cache\DaapiRequestCache.cs:85) - Error attempting to get Response for ItemScoresRequest from Daapi Cache System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. at System.Data.SQLite.UnsafeNativeMethods.sqlite3_busy_timeout(IntPtr db, Int32 ms) at System.Data.SQLite.SQLite3.SetTimeout(Int32 nTimeoutMS) in c:\Users\Alex\Downloads\sqlite-netFx-source-1.0.80.0\System.Data.SQLite\SQLite3.cs:line 259 at System.Data.SQLite.SQLite3.Open(String strFilename, SQLiteConnectionFlags connectionFlags, SQLiteOpenFlagsEnum openFlags, Int32 maxPoolSize, Boolean usePool) in c:\Users\Alex\Downloads\sqlite-netFx-source-1.0.80.0\System.Data.SQLite\SQLite3.cs:line 249 at System.Data.SQLite.SQLiteConnection.Open() in c:\Users\Alex\Downloads\sqlite-netFx-source-1.0.80.0\System.Data.SQLite\SQLiteConnection.cs:line 1021 at Pluck.SiteLife.Scores.Storage.ScoreCollectionStorage.GetDbConnection() in C:\msys\home\sitelife\ApiSite\Services\Scores\ScoreCollectionStorage.cs:line 426 at Pluck.SiteLife.Scores.Storage.ScoreCollectionStorage.CreateCommand() in C:\msys\home\sitelife\ApiSite\Services\Scores\ScoreCollectionStorage.cs:line 415 at Pluck.SiteLife.Scores.Storage.ScoreCollectionStorage.GetIndividualScores(String userKey, String targetKey) in C:\msys\home\sitelife\ApiSite\Services\Scores\ScoreCollectionStorage.cs:line 211 at Pluck.SiteLife.Services.ScoreService.GetUserScoreForItem(CommandContext ctx, String scoreKey, BaseKey parentKey, BaseKey targetKey, UserKey userKey) in C:\msys\home\sitelife\ApiSite\Services\Scores\ScoreService.cs:line 227 at Pluck.SiteLife.Daapi.Models.Reactions.ItemScore.Refresh(CommandContext ctx) in C:\msys\home\sitelife\ApiSite\Daapi\Models\Reactions\ItemScore.cs:line 150 at ItemScoresResponseCacheBuilder.Refresh(CommandContext ctx, ItemScoresResponse res) at ItemScoresResponseWrapper.Refresh(CommandContext , IResponse ) at Pluck.SiteLife.Daapi.Cache.DaapiRequestCache.Get(CommandContext ctx, IRequest req) in C:\msys\home\sitelife\ApiSite\Daapi\Cache\DaapiRequestCache.cs:line 85 2012-04-28 13:47:54,678 [2] ERROR Pluck.SiteLife.GlobalApplication.CurrentDomain_UnhandledException(C:\msys\home\sitelife\ApiSite\GlobalApplication.cs:648) - System.Runtime.InteropServices.SEHException: External component has thrown an exception. at System.Data.SQLite.UnsafeNativeMethods.sqlite3_next_stmt(IntPtr db, IntPtr stmt) at System.Data.SQLite.SQLiteBase.ResetConnection(SQLiteConnectionHandle db) in c:\Users\Alex\Downloads\sqlite-netFx-source-1.0.80.0\System.Data.SQLite\SQLiteBase.cs:line 383 at System.Data.SQLite.SQLite3.Close() in c:\Users\Alex\Downloads\sqlite-netFx-source-1.0.80.0\System.Data.SQLite\SQLite3.cs:line 120 at System.Data.SQLite.SQLiteConnection.Close() in c:\Users\Alex\Downloads\sqlite-netFx-source-1.0.80.0\System.Data.SQLite\SQLiteConnection.cs:line 643 at System.Data.SQLite.SQLiteConnection.Dispose(Boolean disposing) in c:\Users\Alex\Downloads\sqlite-netFx-source-1.0.80.0\System.Data.SQLite\SQLiteConnection.cs:line 483 at System.ComponentModel.Component.Finalize() -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Joe Mistachkin Sent: Friday, April 27, 2012 11:21 PM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] System.Data.SQLite and pooling problem Greg Carter wrote: > > We recently upgraded to 1.0.80.0 from 1.0.77.0 and have found when we > turn connection pooling on we get seemingly random memory access > violations that > happen in calls to UnsafeNativeMethods.sqlite3_busy_timeout ,call > stack - Open/SetTimeout (line 259 of SQLite3.cs). > Are you seeing an ObjectDisposedException or an AccessViolationException? -- Joe Mistachkin _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users Please NOTE: This electronic message, including any attachments, may include privileged, confidential and/or inside information owned by Demand Media, Inc. Any distribution or use of this communication by anyone other than the intended recipient(s) is strictly prohibited and may be unlawful. If you are not the intended recipient, please notify the sender by replying to this message and then delete it from your system. Thank you. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
