mirror of
https://github.com/1Remote/1Remote.git
synced 2026-04-25 13:36:03 +03:00
[GH-ISSUE #85] Published version is missing SQLite Interop library #67
Labels
No labels
area-configuration
area-ct-app
area-ct-rdp
area-ct-remoteapp
area-ct-ssh
area-ct-vnc
area-launcher
area-list
area-tags
area-teamwork
bug
chore
dependencies
general-build/ci
general-performance
general-refactor
general-security
general-supportive
general-ux
meta-documentation
meta-enhancement
meta-enhancement
meta-feature
meta-help-wanted
meta-unknown-error
priority-hi
priority-low
pull-request
question
resolution-duplicate
resolution-invalid
resolution-wontfix
stale
task-put-off
task-still-considering
task-working-in-progress
No milestone
No project
No assignees
1 participant
Notifications
Due date
No due date set.
Dependencies
No dependencies set.
Reference
starred/1Remote#67
Loading…
Add table
Add a link
Reference in a new issue
No description provided.
Delete branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @majkinetor on GitHub (Feb 19, 2021).
Original GitHub issue: https://github.com/1Remote/1Remote/issues/85
Originally assigned to: @VShawn on GitHub.
Environment
PRemoteM Ver:
0.5.9.2102191952OS:
Windows 10 Enterprise 64-bits 6.2.9200.0 (2009).NET Framework:
.NET Framework 4.8CLR:
4.0.30319.42000Error Info
【主库】状态不可用，等待后台检查程序恢复方可使用。连接字符串错误，或者检查项目属性 > 生成 > 目标平台：x86 | x64
Stack Trace
Recent Log
2021-02-19T09:45:48.2804169+01:00[ThreadId:0000000001] Debug Resolution Change: System.EventArgs
2021-02-19T12:27:56.3106651+01:00[ThreadId:0000000001] Debug Call shortcut to invoke quick window.
2021-02-19T15:28:00.7130189+01:00[ThreadId:0000000001] Debug Call shortcut to invoke quick window.
2021-02-19T16:46:20.7001905+01:00[ThreadId:0000000001] Fatal System.Exception: 【主库】状态不可用，等待后台检查程序恢复方可使用。连接字符串错误，或者检查项目属性 > 生成 > 目标平台：x86 | x64 ---> System.Exception: 【主库】状态不可用，等待后台检查程序恢复方可使用。连接字符串错误，或者检查项目属性 > 生成 > 目标平台：x86 | x64
at FreeSql.Internal.ObjectPool.ObjectPool
1.getFree(Boolean checkAvailable) at FreeSql.Internal.ObjectPool.ObjectPool1.Get(Nullable1 timeout) at FreeSql.Internal.CommonProvider.AdoProvider.ExecuteScalar(DbConnection connection, DbTransaction transaction, CommandType cmdType, String cmdText, Int32 cmdTimeout, DbParameter[] cmdParms) --- End of inner exception stack trace --- at FreeSql.Internal.CommonProvider.AdoProvider.LoggerException(IObjectPool1 pool, PrepareCommandResult pc, Exception ex, DateTime dt, StringBuilder logtxt, Boolean isThrowException)at FreeSql.Internal.CommonProvider.AdoProvider.ExecuteScalar(DbConnection connection, DbTransaction transaction, CommandType cmdType, String cmdText, Int32 cmdTimeout, DbParameter[] cmdParms)
at FreeSql.Internal.CommonProvider.AdoProvider.ExecuteScalar(CommandType cmdType, String cmdText, DbParameter[] cmdParms)
at FreeSql.Sqlite.SqliteCodeFirst.GetComparisonDDLStatements(TypeAndName[] objects)
at FreeSql.Internal.CommonProvider.CodeFirstProvider.SyncStructure(TypeAndName[] objects)
at FreeSql.Internal.CommonProvider.CodeFirstProvider.SyncStructureTEntity
at PRM.Core.DB.freesql.FreeSqlDb.InitTables()
at PRM.Core.DB.freesql.FreeSqlDb.OpenConnection(Nullable
1 type, String newConnectionString) at PRM.Core.Model.PrmContext.InitSqliteDb(String sqlitePath) at PRM.App.App_OnStartup(Object sender, StartupEventArgs startupEvent) at System.Windows.Application.OnStartup(StartupEventArgs e) at System.Windows.Application.<.ctor>b__1_0(Object unused) at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs) at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler) at FreeSql.Internal.CommonProvider.AdoProvider.LoggerException(IObjectPool1 pool, PrepareCommandResult pc, Exception ex, DateTime dt, StringBuilder logtxt, Boolean isThrowException)at FreeSql.Internal.CommonProvider.AdoProvider.ExecuteScalar(DbConnection connection, DbTransaction transaction, CommandType cmdType, String cmdText, Int32 cmdTimeout, DbParameter[] cmdParms)
at FreeSql.Internal.CommonProvider.AdoProvider.ExecuteScalar(CommandType cmdType, String cmdText, DbParameter[] cmdParms)
at FreeSql.Sqlite.SqliteCodeFirst.GetComparisonDDLStatements(TypeAndName[] objects)
at FreeSql.Internal.CommonProvider.CodeFirstProvider.SyncStructure(TypeAndName[] objects)
at FreeSql.Internal.CommonProvider.CodeFirstProvider.SyncStructureTEntity
at PRM.Core.DB.freesql.FreeSqlDb.InitTables()
at PRM.Core.DB.freesql.FreeSqlDb.OpenConnection(Nullable
1 type, String newConnectionString) at PRM.Core.Model.PrmContext.InitSqliteDb(String sqlitePath) at PRM.App.App_OnStartup(Object sender, StartupEventArgs startupEvent) at System.Windows.Application.OnStartup(StartupEventArgs e) at System.Windows.Application.<.ctor>b__1_0(Object unused) at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs) at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler) 2021-02-19T16:52:11.6959509+01:00[ThreadId:0000000001] <u>**<font color=Red>Fatal</font>**</u> System.Exception: 【主库】状态不可用，等待后台检查程序恢复方可使用。连接字符串错误，或者检查项目属性 > 生成 > 目标平台：x86 | x64 ---> System.Exception: 【主库】状态不可用，等待后台检查程序恢复方可使用。连接字符串错误，或者检查项目属性 > 生成 > 目标平台：x86 | x64 at FreeSql.Internal.ObjectPool.ObjectPool1.getFree(Boolean checkAvailable)at FreeSql.Internal.ObjectPool.ObjectPool
1.Get(Nullable1 timeout)at FreeSql.Internal.CommonProvider.AdoProvider.ExecuteScalar(DbConnection connection, DbTransaction transaction, CommandType cmdType, String cmdText, Int32 cmdTimeout, DbParameter[] cmdParms)
--- End of inner exception stack trace ---
at FreeSql.Internal.CommonProvider.AdoProvider.LoggerException(IObjectPool
1 pool, PrepareCommandResult pc, Exception ex, DateTime dt, StringBuilder logtxt, Boolean isThrowException) at FreeSql.Internal.CommonProvider.AdoProvider.ExecuteScalar(DbConnection connection, DbTransaction transaction, CommandType cmdType, String cmdText, Int32 cmdTimeout, DbParameter[] cmdParms) at FreeSql.Internal.CommonProvider.AdoProvider.ExecuteScalar(CommandType cmdType, String cmdText, DbParameter[] cmdParms) at FreeSql.Sqlite.SqliteCodeFirst.GetComparisonDDLStatements(TypeAndName[] objects) at FreeSql.Internal.CommonProvider.CodeFirstProvider.SyncStructure(TypeAndName[] objects) at FreeSql.Internal.CommonProvider.CodeFirstProvider.SyncStructure[TEntity]() at PRM.Core.DB.freesql.FreeSqlDb.InitTables() at PRM.Core.DB.freesql.FreeSqlDb.OpenConnection(Nullable1 type, String newConnectionString)at PRM.Core.Model.PrmContext.InitSqliteDb(String sqlitePath)
at PRM.App.App_OnStartup(Object sender, StartupEventArgs startupEvent)
at System.Windows.Application.OnStartup(StartupEventArgs e)
at System.Windows.Application.<.ctor>b__1_0(Object unused)
at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)
at FreeSql.Internal.CommonProvider.AdoProvider.LoggerException(IObjectPool
1 pool, PrepareCommandResult pc, Exception ex, DateTime dt, StringBuilder logtxt, Boolean isThrowException) at FreeSql.Internal.CommonProvider.AdoProvider.ExecuteScalar(DbConnection connection, DbTransaction transaction, CommandType cmdType, String cmdText, Int32 cmdTimeout, DbParameter[] cmdParms) at FreeSql.Internal.CommonProvider.AdoProvider.ExecuteScalar(CommandType cmdType, String cmdText, DbParameter[] cmdParms) at FreeSql.Sqlite.SqliteCodeFirst.GetComparisonDDLStatements(TypeAndName[] objects) at FreeSql.Internal.CommonProvider.CodeFirstProvider.SyncStructure(TypeAndName[] objects) at FreeSql.Internal.CommonProvider.CodeFirstProvider.SyncStructure[TEntity]() at PRM.Core.DB.freesql.FreeSqlDb.InitTables() at PRM.Core.DB.freesql.FreeSqlDb.OpenConnection(Nullable1 type, String newConnectionString)at PRM.Core.Model.PrmContext.InitSqliteDb(String sqlitePath)
at PRM.App.App_OnStartup(Object sender, StartupEventArgs startupEvent)
at System.Windows.Application.OnStartup(StartupEventArgs e)
at System.Windows.Application.<.ctor>b__1_0(Object unused)
at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)
@VShawn commented on GitHub (Feb 20, 2021):
confirm. I missed
SQLite.Interop.dllwhen it make a package.SQLite.Interop.dllis in mySYSTEM PATHthat's why I did not aware I missed somethings when I test it.I have update the release package, please try it and contact me if any other bug error occur
https://github.com/VShawn/PRemoteM/releases/tag/0.5.9.2102191952
I dont know, the error was throw by https://github.com/dotnetcore/FreeSql, I change db module to it for .NET Core compatibility And it should have English support.
this will fix in next update, maybe we need create a ticket for it?
HTML was in markdown log file, not in the stack trace. It is not for display on GitHub but for my markdown reader.
@VShawn commented on GitHub (Feb 20, 2021):
FUXK ME, they are not offering English exception info for now. all exception info were written in static code by Chinese.
github.com/dotnetcore/FreeSql@c12c552352/Providers/FreeSql.Provider.Sqlite/SqliteAdo/SqliteConnectionPool.cs (L193)should we consider change another DB ORM component? any suggestions?
@majkinetor commented on GitHub (Feb 20, 2021):
God damn people, when will they learn that only English is acceptable. I don't care which language either as long as the whole world uses one.
Let me take a look. I am huge sqlite fan :-) I usually forbid ORM on my projects - my team tested entity, daper etc. and slowdown is between 20% to 300%. We need every bit of perf for web apps with mmlions of users but this is desktop app so such slow down is not relevant.