search

nachocove / NachoClientX

Xamarin (C#) Client
5 stars 0 forks source link

SQLite.SQLiteException: file is encrypted or is not a database #3592

Open nacho-crashreporter opened 6 years ago

nacho-crashreporter commented 6 years ago 
Nacho vDEV[chrisperret] (1510269633)
iOS 10.3.3 14G60
2017-11-10T04:26:00.8225070Z

SQLite.SQLiteException: file is encrypted or is not a database
  at SQLite.SQLiteCommand.ExecuteScalar[T] () [0x0007c] in /Users/chrisperret/Projects/NachoClientX/SQLite/sqlite-net/SQLite.cs:2284 
  at SQLite.SQLiteConnection.ExecuteScalar[T] (System.String query, System.Object[] args) [0x00056] in /Users/chrisperret/Projects/NachoClientX/SQLite/sqlite-net/SQLite.cs:680 
  at NachoCore.Model.NcModel.AllTableRowCounts (System.Boolean includeZeroCounts) [0x00026] in /Users/chrisperret/Projects/NachoClientX/NachoCore/NachoCore/Model/NcModel.cs:296 
  at NachoCore.NcApplicationMonitor.Report (System.String moniker, System.String sourceFilePath, System.Int32 sourceLineNumber) [0x00243] in /Users/chrisperret/Projects/NachoClientX/NachoCore/NachoCore/Utils/NcApplicationMonitor.cs:149 
  at NachoCore.NcApplicationMonitor.<Start>b__16_0 (System.Object state) [0x00000] in /Users/chrisperret/Projects/NachoClientX/NachoCore/NachoCore/Utils/NcApplicationMonitor.cs:93 
  at NachoCore.Utils.NcTimer.<PartialInit>b__26_0 (System.Object state) [0x002c3] in /Users/chrisperret/Projects/NachoClientX/NachoCore/NachoCore/Utils/NcTimer.cs:113 
  at System.Threading.Timer+Scheduler.TimerCB (System.Object o) [0x00007] in /Library/Frameworks/Xamarin.iOS.framework/Versions/11.2.0.11/src/mono/mcs/class/corlib/System.Threading/Timer.cs:327 
  at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem () [0x00015] in /Library/Frameworks/Xamarin.iOS.framework/Versions/11.2.0.11/src/mono/mcs/class/referencesource/mscorlib/system/threading/threadpool.cs:1279 
  at System.Threading.ThreadPoolWorkQueue.Dispatch () [0x00074] in /Library/Frameworks/Xamarin.iOS.framework/Versions/11.2.0.11/src/mono/mcs/class/referencesource/mscorlib/system/threading/threadpool.cs:856 
  at ObjCRuntime.Runtime.ThreadPoolDispatcher (System.Func`1[TResult] callback) [0x00006] in /Users/builder/data/lanes/5481/2f8bbec0/source/xamarin-macios/src/ObjCRuntime/Runtime.cs:244 
  at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback () [0x00009] in /Library/Frameworks/Xamarin.iOS.framework/Versions/11.2.0.11/src/mono/mcs/class/referencesource/mscorlib/system/threading/threadpool.cs:1208 

2017-11-10T04:26:00.1215570Z [   690] Info  STATE SM(IMAPPC(4):6): S=Parked & E=Launch/IMAPPCEXE => S=SyncW
2017-11-10T04:26:00.1159590Z [   693] Info  SYS OAUTH2 RefreshAllDueTokens(4): token refresh needed.
2017-11-10T04:26:00.0466250Z [   690] Info  HTTP NcHttpClient(91651602-1592-46fe-8c22-b69527a27e3a): Starting task
2017-11-10T04:26:00.0459320Z [   687] Info  HTTP NcHttpClient(06332d1f-b4f9-4df5-8b88-49569bdad504): Starting task
2017-11-10T04:26:00.0450250Z [   693] Info  HTTP NcHttpClient(2a6be295-e776-4bb3-a1f2-72b8503e7472): Starting task
2017-11-10T04:26:00.0209970Z [   694] Warn  SYS SQLite: 1625ms/-1 rows for: SELECT f.* FROM McFolder AS f WHERE  likelihood (f.AccountId = ?, 1.0) AND  likelihood (f.IsAwaitingDelete = 0, 1.0) AND  likelihood (f.IsClientOwned = 0, 1.0) AND  likelihood (f.Type = ?, 0.05)  ORDER BY AsFolderSyncEpoch DESC
2017-11-10T04:25:59.5667740Z [   690] Info  TIMER NcTimer 317/PATimeout set: due=10000ms, period=0
2017-11-10T04:25:59.5662730Z [   687] Info  TIMER NcTimer 316/PATimeout set: due=10000ms, period=0
2017-11-10T04:25:59.4609280Z [   693] Info  SYS RefreshOAuth2(3:GoogleDefault): OAUTH2 request: POST:https://www.googleapis.com/oauth2/v3/token?client_id=135541750674-r1oih3ikecbp0mqeje0sr03ns19f8rk9.apps.googleusercontent.com&client_secret=k9IvmgO7g_o_zGC9zVx9CPXm&grant_type=refresh_token&refresh_token=1%2F4sgXzlCGj-NRbkG5dzfvouOhsLpUEVkffM3C3OVOyXQ
2017-11-10T04:25:59.4606460Z [   693] Info  SYS RefreshOAuth2(3:GoogleDefault): Attempting Refresh
2017-11-10T04:25:59.3955230Z [     1] Info  STATE SM(InAppPurchaseMgrSM:1): S=PrdDataWait & E=PrdDataReqFailedEvt/NO_VALID_PRODUCTS => S=Start
2017-11-10T04:25:59.3941860Z [     1] Info  SYS InAppPurchase: No valid products returned from store.
2017-11-10T04:25:59.3530400Z [   687] Info  PUSH PA request (8c6a11e9): scheme=https, url=https://ec2-54-193-95-54.us-west-1.compute.amazonaws.com:8443/1/register, port=8443, method=POST
2017-11-10T04:25:59.3521870Z [   690] Info  PUSH PA request (219d0199): scheme=https, url=https://ec2-54-193-95-54.us-west-1.compute.amazonaws.com:8443/1/register, port=8443, method=POST
2017-11-10T04:25:59.2761150Z [   689] Warn  SYS SQLite: 1950ms/-1 rows for: SELECT f.* FROM McContact AS f WHERE  likelihood (f.AccountId = ?, 1.0) AND  likelihood (f.IsAwaitingDelete = 0, 1.0) AND  likelihood (f.ServerId = ?, 0.001) 
2017-11-10T04:25:59.2502310Z [   688] Info  DB NcSQLiteConnection 688 > connection (Connections: Pool 8, DbCons 9)
2017-11-10T04:25:59.2228660Z [   690] Info  PUSH LoggablePasswordSaltedHash(4): PushAssist->DoStartSession passwordHash=174
2017-11-10T04:25:59.2093130Z [   687] Info  PUSH LoggablePasswordSaltedHash(3): PushAssist->DoStartSession passwordHash=3b7
2017-11-10T04:25:59.1731380Z [   688] Info  SYS NcApplicationMonitor: DB Connections 9
2017-11-10T04:25:59.1729100Z [   688] Info  SYS NcApplicationMonitor: Status: Comm Up, Speed CellFast_1, Battery 75% Unplugged
2017-11-10T04:25:59.1036130Z [   688] Info  SYS NcApplicationMonitor: Threads: Min 8/6, Max 50/16, System 27
2017-11-10T04:25:59.0764460Z [   688] Info  SYS NcApplicationMonitor: Memory: Process 47 MB, GC 11 MB
2017-11-10T04:25:58.5369250Z [   693] Info  SYS OAUTH2 RefreshAllDueTokens(3): token refresh needed.
2017-11-10T04:25:58.5305660Z [   693] Info  SYS OAUTH2 RefreshAllDueTokens: checking 3 creds
2017-11-10T04:25:58.4332560Z [   693] Info  DB NcSQLiteConnection 693 > connection (Connections: Pool 9, DbCons 8)
2017-11-10T04:25:58.4328700Z [   693] Info  TIMER NcTimer 314/McCred:Oauth2RefreshTimer fired.
2017-11-10T04:25:58.2130240Z [   693] Info  SYS NcTask Start_SmtpProtoControl:5_995 completed after 758 msec.
2017-11-10T04:25:58.2127720Z [   693] Info  DB NcSQLiteConnection 693 < connection (Connections: Pool 10, DbCons 8)
2017-11-10T04:25:58.1977300Z [   684] Warn  SYS SQLite: 652ms/-1 rows for: SELECT * FROM McAccount
2017-11-10T04:25:58.1967510Z [   690] Warn  SYS SQLite: 639ms/-1 rows for: SELECT f.* FROM McCred AS f WHERE  f.AccountId = ? 
2017-11-10T04:25:58.1965890Z [   687] Info  PUSH [PA] start session starts: client_id=NchoBC363DCBX5354X4237XACAC5, context=8c6a11e9
2017-11-10T04:25:58.1964450Z [   687] Info  STATE SM(PA(3):4): S=Parked & E=Launch/PAEXE => S=SessTokW
2017-11-10T04:25:58.1957940Z [   687] Warn  SYS SQLite: 696ms/-1 rows for: select * from "McAccount" where ("Id" = ?)
2017-11-10T04:25:58.0432640Z [   693] Info  STATE SM(SMTPPC(5):11): S=IdleW & E=Launch/DRIVE => S=IdleW
2017-11-10T04:25:58.0424950Z [   694] Info  DB NcSQLiteConnection 694 > connection (Connections: Pool 9, DbCons 8)
2017-11-10T04:25:57.9984790Z [   694] Info  SYS NcTask AccountSource_Reload997 started on ManagedThreadId 694, 9 running
2017-11-10T04:25:57.5876410Z [   695] Info  DB NcSQLiteConnection 695 > connection (Connections: Pool 10, DbCons 7)
2017-11-10T04:25:57.5868190Z [   693] Info  STATE SM(SMTPPC(5):11): S=IdleW & E=Launch/DRIVE => S=(TBD SmtpProtoControl.DoPick())
2017-11-10T04:25:57.5848100Z [     1] Info  LIFECYCLE Starting PerformFetch timer: 39.03 seconds of background time remaining.
2017-11-10T04:25:57.5845710Z [   695] Info  SYS NcTask Backend_StartActionsHelper996 started on ManagedThreadId 695, 8 running
2017-11-10T04:25:57.5834950Z [     1] Info  TIMER NcTimer 315/NcApplicationMonitor set: due=1000ms, period=60000
2017-11-10T04:25:57.5747020Z [   691] Info  SYS NcTask Start_SmtpProtoControl:4_993 completed after 136 msec.
2017-11-10T04:25:57.5735650Z [   691] Info  DB NcSQLiteConnection 691 < connection (Connections: Pool 11, DbCons 7)
2017-11-10T04:25:57.5481420Z [   690] Info  PUSH [PA] start session starts: client_id=NchoBC363DCBX5354X4237XACAC5, context=219d0199
2017-11-10T04:25:57.5468090Z [   690] Info  STATE SM(PA(4):7): S=Parked & E=Launch/PAEXE => S=SessTokW
2017-11-10T04:25:57.5448080Z [   684] Info  DB NcSQLiteConnection 684 > connection (Connections: Pool 10, DbCons 7)
2017-11-10T04:25:57.5445010Z [   684] Info  LIFECYCLE Telemetry starts running
2017-11-10T04:25:57.5440700Z [   684] Info  SYS Got user id from cognito: us-east-1:d4ef97b4-f7be-46cc-bbca-1e7997dc462f
2017-11-10T04:25:57.5079820Z [   693] Info  STATE SM(SMTPPC(5):11): S=Parked & E=Launch/SMTPPCEXE => S=IdleW
2017-11-10T04:25:57.5021530Z [   691] Info  STATE SM(SMTPPC(4):8): S=IdleW & E=Launch/DRIVE => S=IdleW
2017-11-10T04:25:57.5017020Z [   691] Info  STATE SM(SMTPPC(4):8): S=IdleW & E=Launch/DRIVE => S=(TBD SmtpProtoControl.DoPick())
2017-11-10T04:25:57.4997480Z [   692] Info  DB NcSQLiteConnection 692 < connection (Connections: Pool 11, DbCons 7)
2017-11-10T04:25:57.4898430Z [   693] Info  STATE SM(SMTPPC(5):11): S=Parked & E=Launch/SMTPPCEXE => S=(TBD SmtpProtoControl.DoDrive())
2017-11-10T04:25:57.4849390Z [   691] Info  STATE SM(SMTPPC(4):8): S=Parked & E=Launch/SMTPPCEXE => S=IdleW
2017-11-10T04:25:57.4724860Z [   688] Info  SYS NcTask Start_SmtpProtoControl:3_991 completed after 71 msec.
2017-11-10T04:25:57.4721690Z [     1] Info  BACKEND BackEnd.Start(5) exited
2017-11-10T04:25:57.4721620Z [   688] Info  DB NcSQLiteConnection 688 < connection (Connections: Pool 10, DbCons 8)
2017-11-10T04:25:57.4680820Z [   692] Info  STATE SM(IMAPPC(5):9): S=Parked & E=Launch/IMAPPCEXE => S=(TBD ImapProtoControl.DoDrive())
2017-11-10T04:25:57.4670900Z [   691] Info  STATE SM(SMTPPC(4):8): S=Parked & E=Launch/SMTPPCEXE => S=(TBD SmtpProtoControl.DoDrive())
2017-11-10T04:25:57.4666780Z [   690] Info  STATE SM(IMAPPC(4):6): S=Parked & E=Launch/IMAPPCEXE => S=(TBD ImapProtoControl.DoDrive())
2017-11-10T04:25:57.4557050Z [   693] Info  DB NcSQLiteConnection 693 > connection (Connections: Pool 9, DbCons 8)
2017-11-10T04:25:57.4553830Z [   693] Info  SYS NcTask Start_SmtpProtoControl:5_995 started on ManagedThreadId 693, 9 running
2017-11-10T04:25:57.4551480Z [   688] Info  STATE SM(SMTPPC(3):5): S=IdleW & E=Launch/DRIVE => S=IdleW
2017-11-10T04:25:57.4533290Z [   692] Info  DB NcSQLiteConnection 692 > connection (Connections: Pool 10, DbCons 7)
2017-11-10T04:25:57.4529880Z [   692] Info  SYS NcTask Start_ImapProtoControl:5_994 started on ManagedThreadId 692, 7 running
2017-11-10T04:25:57.4526420Z [   688] Info  STATE SM(SMTPPC(3):5): S=IdleW & E=Launch/DRIVE => S=(TBD SmtpProtoControl.DoPick())
2017-11-10T04:25:57.4520420Z [     1] Info  BACKEND BackEnd.Start(5) starting 2 services
2017-11-10T04:25:57.4516630Z [     1] Info  BACKEND BackEnd.Start(5) called
2017-11-10T04:25:57.4509230Z [     1] Info  BACKEND BackEnd.Start(4) exited
2017-11-10T04:25:57.4492760Z [   687] Info  STATE SM(IMAPPC(3):3): S=Parked & E=Launch/IMAPPCEXE => S=(TBD ImapProtoControl.DoDrive())
2017-11-10T04:25:57.4410480Z [   688] Info  STATE SM(SMTPPC(3):5): S=Parked & E=Launch/SMTPPCEXE => S=IdleW
2017-11-10T04:25:57.4388390Z [   691] Info  DB NcSQLiteConnection 691 > connection (Connections: Pool 11, DbCons 6)
2017-11-10T04:25:57.4384660Z [   691] Info  SYS NcTask Start_SmtpProtoControl:4_993 started on ManagedThreadId 691, 7 running
2017-11-10T04:25:57.4357190Z [   690] Info  DB NcSQLiteConnection 690 > connection (Connections: Pool 12, DbCons 5)
2017-11-10T04:25:57.4352950Z [   690] Info  SYS NcTask Start_ImapProtoControl:4_992 started on ManagedThreadId 690, 6 running
2017-11-10T04:25:57.4336540Z [     1] Info  BACKEND BackEnd.Start(4) starting 2 services
2017-11-10T04:25:57.4333220Z [     1] Info  BACKEND BackEnd.Start(4) called
2017-11-10T04:25:57.4329030Z [     1] Info  BACKEND BackEnd.Start(3) exited
2017-11-10T04:25:57.4295940Z [   688] Info  STATE SM(SMTPPC(3):5): S=Parked & E=Launch/SMTPPCEXE => S=(TBD SmtpProtoControl.DoDrive())
2017-11-10T04:25:57.4238990Z [     1] Info  TIMER NcTimer 314/McCred:Oauth2RefreshTimer set: due=1000ms, period=300000
2017-11-10T04:25:57.4033710Z [   688] Info  DB NcSQLiteConnection 688 > connection (Connections: Pool 13, DbCons 4)
2017-11-10T04:25:57.4014410Z [   688] Info  SYS NcTask Start_SmtpProtoControl:3_991 started on ManagedThreadId 688, 4 running
2017-11-10T04:25:57.3816020Z [   687] Info  DB NcSQLiteConnection 687 > connection (Connections: Pool 14, DbCons 3)
2017-11-10T04:25:57.3733580Z [   687] Info  SYS NcTask Start_ImapProtoControl:3_990 started on ManagedThreadId 687, 3 running
2017-11-10T04:25:57.3639240Z [     1] Info  BACKEND BackEnd.Start(3) starting 2 services
2017-11-10T04:25:57.3611970Z [     1] Info  BACKEND BackEnd.Start(3) called
2017-11-10T04:25:57.3607520Z [     1] Info  BACKEND BackEnd.Start(2) exited
2017-11-10T04:25:57.3435530Z [     1] Info  BACKEND BackEnd.Start(2) starting 0 services
2017-11-10T04:25:57.3372130Z [     1] Info  BACKEND BackEnd.Start(2) called
2017-11-10T04:25:57.3352610Z [     1] Info  BACKEND BackEnd.Start(1) exited
2017-11-10T04:25:57.3252780Z [   689] Info  DB NcSQLiteConnection 689 > connection (Connections: Pool 15, DbCons 2)
2017-11-10T04:25:57.3166790Z [   687] Info  SYS NcTask Start_DeviceProtoControl:1_988 completed after 7 msec.
2017-11-10T04:25:57.3162490Z [   689] Info  SYS NcTask DeviceProtoControl:DoSync989 started on ManagedThreadId 689, 3 running
2017-11-10T04:25:57.3144630Z [   687] Info  SYS NcTask DeviceProtoControl:DoSync will be long running
2017-11-10T04:25:57.3124010Z [   687] Info  STATE SM(DEV(1):2): S=Parked & E=Launch/DEVICELAUNCH => S=SyncW
2017-11-10T04:25:57.3099830Z [   687] Info  SYS NcTask Start_DeviceProtoControl:1_988 started on ManagedThreadId 687, 2 running
2017-11-10T04:25:57.3024720Z [     1] Info  BACKEND BackEnd.Start(1) starting 1 services
2017-11-10T04:25:57.3005240Z [     1] Info  STATE UPDATE STATE Up=>Up CellFast_1=>CellFast_1 (src Refresh)
2017-11-10T04:25:57.2964800Z [     1] Info  BACKEND BackEnd.Start(1) called
2017-11-10T04:25:57.2925330Z [   687] Info  SYS NcTask ReverseFinalShutdownCleanupOldDbConnections987 completed after 121 msec.
owenpshaw commented 6 years ago

Seems like #3404 . Same stack trace, different exception.