BUG反馈：升级后管理员账号无法维护组织，无法复制

LAA.Y 2023-01-11 16:33:07 分享收藏

8 / 287

问题 1：使用管理员账号登录后切换组织管理报错，日志如下

"TimeStamp":16734074405779510,"HostName":"d02816fade27","ServiceType":36,"Developer":0,"ClientIp":"","Stack":"exception:message:Table 'MDProject.Project_Organize' doesn't exist| StackTrace: at MySql.Data.MySqlClient.MySqlStream.ReadPacket()\n at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)\n at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)\n at MySql.Data.MySqlClient.MySqlDataReader.NextResult()\n at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)\n at Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior) in C:\\projects\\dapper\\Dapper\\SqlMapper.cs:line 1060\n at Dapper.SqlMapper.QueryImpl[T](IDbConnection cnn, CommandDefinition command, Type effectiveType)+MoveNext() in C:\\projects\\dapper\\Dapper\\SqlMapper.cs:line 1079\n at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)\n at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)\n at Dapper.SqlMapper.Query[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable`1 commandTimeout, Nullable`1 commandType) in C:\\projects\\dapper\\Dapper\\SqlMapper.cs:line 721\n at MD.Dapper.DapperRepository`1.<>c__DisplayClass23_0`1.<Query>b__0(IDbConnection conn)\n at MD.Dapper.DapperRepository`1.OpenDbConnection[DT](Func`2 func, Boolean useMaster)\n at MD.BasicService.Repository.Repositories.ProjectOrganizeRepository.GetOrgRoleWithAccounts(String projectId) in /data/jenkins/workspace/basicservice-bug/MD.BasicServices/MD.Basic.Core/Repositories/ProjectOrganizeRepository.cs:line 55\n at MD.BasicService.Cache.UserCachings.Prepaeres.InternalPUserPreparer.<>c__DisplayClass13_0.<GetAllOrgRoleAccounts>b__0() in /data/jenkins/workspace/basicservice-bug/MD.BasicServices/MD.Basic.Core/Cache/UserCachings/Prepaeres/InternalPUserPreparer.cs:line 120\n at MD.Basic.Core.Common.MDTask.<>c__DisplayClass0_0`1.<Run>b__0() in /data/jenkins/workspace/basicservice-bug/MD.BasicServices/MD.Basic.Core/Common/MDTask.cs:line 19","Message":"Table 'MDProject.Project_Organize' doesn't exist","Action":"<GetAllOrgRoleAccounts>b__0","AccountId":"","ProjectId":"","Level":3,"Extras":{},"ServiceName":"baseservice","RequestId":"","LevelName":"error","Endpoint":"","ElapsedMilliSeconds":0,"TimeOn":"2023-01-11 03:24:00.582"}

问题 2：复制应用报错

日志如下：

{"TimeStamp":16734076427826547,"HostName":"d02816fade27(172.18.0.2)","ServiceType":1,"Developer":0,"ClientIp":"10.32.140.119","Stack":"One or more errors occurred. (Status(StatusCode=\"Unknown\", Detail=\"Exception was thrown by handler.\", DebugException=\"Grpc.Core.Internal.CoreErrorDetailException: {\"created\":\"@1673407642.776693703\",\"description\":\"Error received from peer ipv4:127.0.0.1:5200\",\"file\":\"/var/local/git/grpc/src/core/lib/surface/call.cc\",\"file_line\":1070,\"grpc_message\":\"Exception was thrown by handler.\",\"grpc_status\":2}\"))\r\n at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification)\n at MD.Basic.AccountInfo.GetNormalAccountIds(String projectId) in /data/jenkins/workspace/api-all-private/MD.Basic/AccountInfo.cs:line 126\n at MD.Basic.AccountInfo.GetAccountIdsByProjectId(String projectId, UserStatus status) in /data/jenkins/workspace/api-all-private/MD.Basic/AccountInfo.cs:line 140\n at MD.Business.HomeApp.HomeApp.CloneApp(String appId, String newAppName, String accountId, Boolean isOpenApi, String groupId, GroupEnum groupType) in /data/jenkins/workspace/api-all-private/MD.Business/HomeApp/HomeApp.cs:line 630\n at MD.Web.Ajax.Controller.HomeAppController.CopyApp(CopyAppRequest request) in /data/jenkins/workspace/api-all-private/MD.Web.Ajax/Controller/HomeAppController.cs:line 205\n at lambda_method(Closure , Object , Object[] )\n at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync()\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync()\n--- End of stack trace from previous location where exception was thrown ---\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync()\n--- End of stack trace from previous location where exception was thrown ---\n at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)","Message":"AppGlobalFilter_Web 接口调用异常","Action":"","AccountId":"","ProjectId":"","Level":3,"Extras":{"requestHost":"10.32.141.124","requestPath":"/homeapp/copyapp","requestBody":"{\"request\":{\"appId\":\"70e88df3-da88-4c07-9511-4cd94f5ea22d\",\"appName\":\"法务系统-复制\",\"groupId\":\"\",\"groupType\":0}}","requestQuery":"","requestMethod":"POST","accountID":"bbd2762a-4a2a-4f9f-a7f9-0f6157e3d5a2","projectID":"","appID":"","innerException":"Status(StatusCode=\"Unknown\", Detail=\"Exception was thrown by handler.\", DebugException=\"Grpc.Core.Internal.CoreErrorDetailException: {\"created\":\"@1673407642.776693703\",\"description\":\"Error received from peer ipv4:127.0.0.1:5200\",\"file\":\"/var/local/git/grpc/src/core/lib/surface/call.cc\",\"file_line\":1070,\"grpc_message\":\"Exception was thrown by handler.\",\"grpc_status\":2}\")\r\n at Grpc.Core.Internal.ClientResponseStream`2.MoveNext(CancellationToken token)"},"ServiceName":"master","RequestId":"","LevelName":"error","Endpoint":"","ElapsedMilliSeconds":0,"TimeOn":"2023-01-11 03:27:22.786"}

{"TimeStamp":16734076426179110,"HostName":"d02816fade27","ServiceType":36,"Developer":0,"ClientIp":"","Stack":"exception:message:Table 'MDProject.Project_Organize' doesn't exist| StackTrace: at MySql.Data.MySqlClient.MySqlStream.ReadPacket()\n at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)\n at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)\n at MySql.Data.MySqlClient.MySqlDataReader.NextResult()\n at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)\n at Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior) in C:\\projects\\dapper\\Dapper\\SqlMapper.cs:line 1060\n at Dapper.SqlMapper.QueryImpl[T](IDbConnection cnn, CommandDefinition command, Type effectiveType)+MoveNext() in C:\\projects\\dapper\\Dapper\\SqlMapper.cs:line 1079\n at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)\n at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)\n at Dapper.SqlMapper.Query[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable`1 commandTimeout, Nullable`1 commandType) in C:\\projects\\dapper\\Dapper\\SqlMapper.cs:line 721\n at MD.Dapper.DapperRepository`1.<>c__DisplayClass23_0`1.<Query>b__0(IDbConnection conn)\n at MD.Dapper.DapperRepository`1.OpenDbConnection[DT](Func`2 func, Boolean useMaster)\n at MD.BasicService.Repository.Repositories.ProjectOrganizeRepository.GetOrgRoleWithAccounts(String projectId) in /data/jenkins/workspace/basicservice-bug/MD.BasicServices/MD.Basic.Core/Repositories/ProjectOrganizeRepository.cs:line 55\n at MD.BasicService.Cache.UserCachings.Prepaeres.InternalPUserPreparer.<>c__DisplayClass13_0.<GetAllOrgRoleAccounts>b__0() in /data/jenkins/workspace/basicservice-bug/MD.BasicServices/MD.Basic.Core/Cache/UserCachings/Prepaeres/InternalPUserPreparer.cs:line 120\n at MD.Basic.Core.Common.MDTask.<>c__DisplayClass0_0`1.<Run>b__0() in /data/jenkins/workspace/basicservice-bug/MD.BasicServices/MD.Basic.Core/Common/MDTask.cs:line 19","Message":"Table 'MDProject.Project_Organize' doesn't exist","Action":"<GetAllOrgRoleAccounts>b__0","AccountId":"","ProjectId":"","Level":3,"Extras":{},"ServiceName":"baseservice","RequestId":"","LevelName":"error","Endpoint":"","ElapsedMilliSeconds":0,"TimeOn":"2023-01-11 03:27:22.621"}

问题 3：表单数据中的日志打开异常

日志如下：


{"TimeStamp":16734077270851499,"HostName":"d02816fade27(172.18.0.2)","ServiceType":1,"Developer":0,"ClientIp":"10.32.140.119","Stack":"One or more errors occurred. (Status(StatusCode=\"Unknown\", Detail=\"Exception was thrown by handler.\", DebugException=\"Grpc.Core.Internal.CoreErrorDetailException: {\"created\":\"@1673407727.079445351\",\"description\":\"Error received from peer ipv4:127.0.0.1:5200\",\"file\":\"/var/local/git/grpc/src/core/lib/surface/call.cc\",\"file_line\":1070,\"grpc_message\":\"Exception was thrown by handler.\",\"grpc_status\":2}\"))\r\n at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification)\n at MD.Basic.AccountInfo.GetAccountInfoByAccountIds(IEnumerable`1 accountIds, String projectId, UserStatus status) in /data/jenkins/workspace/api-all-private/MD.Basic/AccountInfo.cs:line 234\n at MD.Basic.AccountInfo.GetAccountInfoByAccountIds(IEnumerable`1 accountIds, String projectId) in /data/jenkins/workspace/api-all-private/MD.Basic/AccountInfo.cs:line 207\n at MD.Business.Worksheet.Worksheet.GetWorksheetOpeationLogsAsync(GetWorksheetOpeationLogsDto dto) in /data/jenkins/workspace/api-all-private/MD.Business/Worksheet/Worksheet.cs:line 2370\n at MD.Web.Ajax.Controller.WorksheetController.GetWorksheetOpeationLogs(GetWorksheetOpeationLogsRequest request) in /data/jenkins/workspace/api-all-private/MD.Web.Ajax/Controller/WorksheetController.cs:line 948\n at lambda_method(Closure , Object )\n at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)\n at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)","Message":"AppGlobalFilter_Web 接口调用异常","Action":"","AccountId":"","ProjectId":"","Level":3,"Extras":{"requestHost":"10.32.141.124","requestPath":"/worksheet/getworksheetopeationlogs","requestBody":"{\"request\":{\"pageSize\":20,\"pageIndex\":1,\"objectType\":2,\"worksheetId\":\"636481deaf5e8d2ccc8e43b6\",\"rowId\":\"a58fcdaa-1419-430c-9b35-70081a8cf4da\",\"filterUniqueIds\":[],\"controlIds\":[],\"opeartorIds\":[]}}","requestQuery":"","requestMethod":"POST","accountID":"bbd2762a-4a2a-4f9f-a7f9-0f6157e3d5a2","projectID":"","appID":"","innerException":"Status(StatusCode=\"Unknown\", Detail=\"Exception was thrown by handler.\", DebugException=\"Grpc.Core.Internal.CoreErrorDetailException: {\"created\":\"@1673407727.079445351\",\"description\":\"Error received from peer ipv4:127.0.0.1:5200\",\"file\":\"/var/local/git/grpc/src/core/lib/surface/call.cc\",\"file_line\":1070,\"grpc_message\":\"Exception was thrown by handler.\",\"grpc_status\":2}\")\r\n at Grpc.Core.Internal.ClientResponseStream`2.MoveNext(CancellationToken token)"},"ServiceName":"master","RequestId":"","LevelName":"error","Endpoint":"","ElapsedMilliSeconds":0,"TimeOn":"2023-01-11 03:28:47.090"}

{"TimeStamp":16734077270754583,"HostName":"d02816fade27","ServiceType":36,"Developer":0,"ClientIp":"","Stack":"exception:message:Table 'MDProject.Project_Organize' doesn't exist| StackTrace: at MySql.Data.MySqlClient.MySqlStream.ReadPacket()\n at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)\n at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)\n at MySql.Data.MySqlClient.MySqlDataReader.NextResult()\n at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)\n at Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior) in C:\\projects\\dapper\\Dapper\\SqlMapper.cs:line 1060\n at Dapper.SqlMapper.QueryImpl[T](IDbConnection cnn, CommandDefinition command, Type effectiveType)+MoveNext() in C:\\projects\\dapper\\Dapper\\SqlMapper.cs:line 1079\n at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)\n at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)\n at Dapper.SqlMapper.Query[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable`1 commandTimeout, Nullable`1 commandType) in C:\\projects\\dapper\\Dapper\\SqlMapper.cs:line 721\n at MD.Dapper.DapperRepository`1.<>c__DisplayClass23_0`1.<Query>b__0(IDbConnection conn)\n at MD.Dapper.DapperRepository`1.OpenDbConnection[DT](Func`2 func, Boolean useMaster)\n at MD.BasicService.Repository.Repositories.ProjectOrganizeRepository.GetOrgRoleWithAccounts(String projectId) in /data/jenkins/workspace/basicservice-bug/MD.BasicServices/MD.Basic.Core/Repositories/ProjectOrganizeRepository.cs:line 55\n at MD.BasicService.Cache.UserCachings.Prepaeres.InternalPUserPreparer.<>c__DisplayClass13_0.<GetAllOrgRoleAccounts>b__0() in /data/jenkins/workspace/basicservice-bug/MD.BasicServices/MD.Basic.Core/Cache/UserCachings/Prepaeres/InternalPUserPreparer.cs:line 120\n at MD.Basic.Core.Common.MDTask.<>c__DisplayClass0_0`1.<Run>b__0() in /data/jenkins/workspace/basicservice-bug/MD.BasicServices/MD.Basic.Core/Common/MDTask.cs:line 19","Message":"Table 'MDProject.Project_Organize' doesn't exist","Action":"<GetAllOrgRoleAccounts>b__0","AccountId":"","ProjectId":"","Level":3,"Extras":{},"ServiceName":"baseservice","RequestId":"","LevelName":"error","Endpoint":"","ElapsedMilliSeconds":0,"TimeOn":"2023-01-11 03:28:47.080"}