D 2019-11-07T09:20:17.633
J foundin 1.0.111
J icomment Hi,\r\nwe\sare\susing\sSystem.Data.SQLite\sv1.0.111\swith\sSQLite.CodeFirst\sv1.5.2.28\sand\sEntityFramework\sv6.3.0.\r\nWe\salso\suse\sserilog\sto\slog\sour\sstuff\sand\swe\sadd\stracelistener\sinto\sour\slogging\saswell.\r\n\r\nFrom\scode\swe\shave\smultiple\sthreads/tasks\sthat\sare\saccessing\sthe\sDB.\r\nFor\severy\soperation\swe\sopen\snew\sDbContext\sand\safter\scommit,\swe\sdispose\sit.\r\nThis\soperation\scan\sbe\sread,\swrite\sor\sboth.\se.g.\sfinding\ssomething\sin\sDB,\smodifying\sit\sand\supdating\sit\sin\sdb.\r\n\r\nWe\sdon't\ssee\sany\sdata\scorruption,\sbut\ssomething\snot\sfrom\sour\scode\sis\slogging\sSQLite\serror\sinto\sour\slogs.\r\n\r\nAfter\sdownloading\ssources\sof\sSystem.Data.SQLite\sI\sfound,\sthat\sit\sis\sa\sTrace.WriteLine\sfrom\sSQLiteLog.cs\saprox.\sline\s671.\r\n\r\nThe\strace\slooks\slike\sthis:\r\n10:06:20.8824554\s+01:00\s[DBUG]\s[1]\sSQLite\serror\s(5):\sdatabase\sis\slocked\sin\s"SELECT\r\n[Project2].[C1]\sAS\s[C1],\r\n[Project2].[ServerGuid]\sAS\s[ServerGuid],\r\n[Project2].[C9]\sAS\s[C2],\r\n[Project2].[C2]\sAS\s[C3],\r\n[Project2].[Id]\sAS\s[Id],\r\n[Project2].[JobType]\sAS\s[J\r\n10:06:21.0356220\s+01:00\s[DBUG]\s[1]\sSQLite\serror\s(5):\sdatabase\sis\slocked\sin\s"SELECT\r\n[Extent1].[Id]\sAS\s[Id],\r\n[Extent1].[Value]\sAS\s[Value],\r\n[Extent1].[SettingName]\sAS\s[SettingName],\r\n[Extent1].[ModifiedDateTime]\sAS\s[ModifiedDateTime]\r\nFROM\s[SettingValuePc]\sA\r\n\r\nBut\syour\slibrary\sdoesn't\sthrow\sanything\sto\sus,\sso\swe\sthink,\sthat\sthe\slibrary\shandles\sthis\serror\sin\ssome\sway\sinternally\s(maybe\sby\sretrying)\sand\sfinishes\spossibly\ssuccessfully\sall\sthe\srequests.\r\n\r\nThe\sodd\sthing\sabout\sthis\sis,\sthat\sthe\smessage\sit\scut\soff.\r\n\r\nFor\snow\swe\scan\srepro\sit\son\sour\sprivate\scode,\sbut\sif\snecessary\sI\scan\shopefully\sprovide\slimited\srepro\srepo\son\sgithub\sfor\syou.\r\n\r\nMy\squestions\sare:\r\nCan\sthis\sSQLite\serror\sintroduce\sany\scorruption\sinside\sSQLite\sdata?\r\nCan\swe\ssomehow\sturn\soff\sthis\skind\sof\slogging\sfrom\syou\slibrary?\sSo\sthat\sit\sdoesn't\slog\sinternal\serrors\sinto\sTrace?\sI\shaven't\sfound\san\seasy\sway\syet.\r\nShould\swe\sbe\susing\sonly\sone\sinstance\sof\sDBContext\sat\sone\stime,\sso\sthat\sthis\serror\sdoesn't\sever\soccur?\sWe\scan\sget\sthe\sdbcontext\sunder\slocks,\sbut\sit\swould\sbe\sour\slast\sresort,\sbecause\swe\sdon't\swant\sto\sthrottle\sout\sapp.\r\n\r\nThanks!\r\nJacob
J login anonymous
J mimetype text/plain
J private_contact 514527136bf670ffc6670b1ffae79d1d85aae79f
J severity Important
J status Open
J title SQLiteLog\slogs\sError\sinto\sTrace,\sbut\sdll\sdoesn't\spropagate\serror\soutside
J type Code_Defect
K 63cc0caf78c9f5d25961833a1cf96bd189b76dc9
U anonymous
Z 2bac3da0acdbad55425af9b8f1cc90b5
