在查询数据时经常卡，救助大佬帮我看看日志
forguncy.js?v=638035013340000000:29
forguncy.js?v=638035013340000000:29 执行点击命令 OrdererInv!P2 用时: 1013 毫秒
forguncy.js?v=638035013340000000:29 条件 用时: 1007 毫秒
forguncy.js?v=638035013340000000:29 判断: =AU2 等于 1 结果为 false
forguncy.js?v=638035013340000000:29 Else 用时: 1006 毫秒
forguncy.js?v=638035013340000000:29 条件 用时: 5 毫秒
forguncy.js?v=638035013340000000:29 判断: =BK2 不等于 %Null% 结果为 true 用时: 5 毫秒
forguncy.js?v=638035013340000000:29
forguncy.js?v=638035013340000000:29 执行值变更命令 search(OrdererInv!C2) 用时: 8 毫秒
forguncy.js?v=638035013340000000:29 [创建命令上下文变量]
forguncy.js?v=638035013340000000:29 创建变量 valueChangedReason = userInput
forguncy.js?v=638035013340000000:29 JavaScript命令 用时: 1 毫秒
forguncy.js?v=638035013340000000:29
jquery-3.6.0.min.js?v=638035013340000000:2 POST http://localhost:49362/Forguncy/Home/GetTableDataWithOffset 500 (Internal Server Error)
send @ jquery-3.6.0.min.js?v=638035013340000000:2
ajax @ jquery-3.6.0.min.js?v=638035013340000000:2
i.forguncyPost @ forguncy.js?v=638035013340000000:9
t.GetTableDataWithOffset @ forguncy.js?v=638035013340000000:35
t.queryDataFromServer @ spread.js?v=638035013340000000:131
(anonymous) @ forguncy.js?v=638035013340000000:62
(anonymous) @ forguncy.js?v=638035013340000000:65
(anonymous) @ forguncy.js?v=638035013340000000:65
(anonymous) @ forguncy.js?v=638035013340000000:35
c.success @ forguncy.js?v=638035013340000000:9
c @ jquery-3.6.0.min.js?v=638035013340000000:2
fireWith @ jquery-3.6.0.min.js?v=638035013340000000:2
l @ jquery-3.6.0.min.js?v=638035013340000000:2
(anonymous) @ jquery-3.6.0.min.js?v=638035013340000000:2
load (async)
send @ jquery-3.6.0.min.js?v=638035013340000000:2
ajax @ jquery-3.6.0.min.js?v=638035013340000000:2
i.forguncyPost @ forguncy.js?v=638035013340000000:9
t.GetRowCount @ forguncy.js?v=638035013340000000:35
r.GetRowCountFromServer @ forguncy.js?v=638035013340000000:65
r.GetRowCount @ forguncy.js?v=638035013340000000:65
r.RefeshRowCount @ forguncy.js?v=638035013340000000:65
r.fillData @ forguncy.js?v=638035013340000000:62
i.queryCommand @ forguncy.js?v=638035013340000000:112
i.execute @ forguncy.js?v=638035013340000000:112
r._executeSingleCommand @ forguncy.js?v=638035013340000000:104
(anonymous) @ forguncy.js?v=638035013340000000:104
s @ forguncy.js?v=638035013340000000:44
(anonymous) @ forguncy.js?v=638035013340000000:44
(anonymous) @ forguncy.js?v=638035013340000000:44
__awaiter @ forguncy.js?v=638035013340000000:44
r._executeFirstCommandInList @ forguncy.js?v=638035013340000000:104
(anonymous) @ forguncy.js?v=638035013340000000:104
(anonymous) @ forguncy.js?v=638035013340000000:15
(anonymous) @ forguncy.js?v=638035013340000000:15
setTimeout (async)
i.setTimeout @ forguncy.js?v=638035013340000000:15
t.doOperation @ forguncy.js?v=638035013340000000:15
(anonymous) @ forguncy.js?v=638035013340000000:15
Promise.then (async)
(anonymous) @ forguncy.js?v=638035013340000000:15
(anonymous) @ forguncy.js?v=638035013340000000:15
setTimeout (async)
i.setTimeout @ forguncy.js?v=638035013340000000:15
t.doOperation @ forguncy.js?v=638035013340000000:15
t.Push @ forguncy.js?v=638035013340000000:15
r._executeCommand @ forguncy.js?v=638035013340000000:104
r.excuteCommandFromWaitingQueque @ forguncy.js?v=638035013340000000:104
r.excuteCommand @ forguncy.js?v=638035013340000000:104
(anonymous) @ forguncy.js?v=638035013340000000:68
(anonymous) @ forguncy.js?v=638035013340000000:28
n.trigger @ forguncy.js?v=638035013340000000:28
r.trigger @ forguncy.js?v=638035013340000000:73
(anonymous) @ forguncy.js?v=638035013340000000:74
dispatch @ jquery-3.6.0.min.js?v=638035013340000000:2
v.handle @ jquery-3.6.0.min.js?v=638035013340000000:2
MetadataLoader.js?v=638035013340000000:623 /Forguncy/Home/GetTableDataWithOffset
Internal Server Error
Request Exception Happened-------------------------------
Path/Home/GetTableDataWithOffset
UserName:ADMIN
{
"ClassName": "System.Data.SqlClient.SqlException",
"Message": "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.",
"Data": {
"$type": "System.Collections.ListDictionaryInternal, System.Private.CoreLib",
"HelpLink.ProdName": "Microsoft SQL Server",
"HelpLink.ProdVer": "11.00.3128",
"HelpLink.EvtSrc": "MSSQLServer",
"HelpLink.EvtID": "-2",
"HelpLink.BaseHelpUrl": "https://go.microsoft.com/fwlink",
"HelpLink.LinkId": "20476",
"SqlError 1": "System.Data.SqlClient.SqlError: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
},
"InnerException": {
"$type": "System.ComponentModel.Win32Exception, Microsoft.Win32.Primitives",
"ClassName": "System.ComponentModel.Win32Exception",
"Message": "等待的操作过时。",
"Data": null,
"InnerException": null,
"HelpURL": null,
"StackTraceString": null,
"RemoteStackTraceString": null,
"RemoteStackIndex": 0,
"ExceptionMethod": null,
"HResult": -2147467259,
"Source": null,
"WatsonBuckets": null,
"NativeErrorCode": 258
},
"HelpURL": null,
"StackTraceString": " at System.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__126_0(Task`1 result)
at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location ---
at Forguncy.DataSourceBase.FillTableAsync(String commandText, IEnumerable`1 parameters)
at ForguncyDataAccess.DataAccess.a(String A_0, String A_1, DataBaseType A_2, DbParameter[] A_3)
at ForguncyDataAccess.DataAccess.SelectAsync(List`1 columnBindingInfos, ISqlCondition selectCondition, TopSqlConditionBase topCondition, String tableName, OrderBySqlCondition orderByCondition, OffsetSqlCondition offsetCondition, Boolean useGroupBy)
at Forguncy.Server2.ForguncyServerDataAccess.SelectAsync(List`1 columnBindingInfos, ISqlCondition selectCondition, TopSqlConditionBase topCondition, String tableName, OrderBySqlCondition orderByCondition, OffsetSqlCondition offsetCondition, Boolean useGroupBy)
at ForguncyDataAccess.DataAccess.GetDetailDataTableAsync(List`1 columnBindingInfos, ISqlCondition sqlCondition, TopSqlConditionBase topCondition, OrderBySqlCondition orderByCondition, List`1 primaryKeys, OffsetSqlCondition offsetCondition, Boolean distinct)
at ForguncyDataAccess.DataAccess.GetDataTableAsync(List`1 columnBindingInfos, ISqlCondition sqlCondition, TopSqlConditionBase topCondition, List`1 primaryKeys, OrderBySqlCondition orderByCondition, OffsetSqlCondition offsetCondition, Boolean distinct)
at Forguncy.Server2.ForguncyServerDataAccess.GetDataTableAsync(List`1 columnBindingInfos, ISqlCondition sqlCondition, TopSqlConditionBase topCondition, List`1 primaryKeys, OrderBySqlCondition orderByCondition, OffsetSqlCondition offsetCondition, Boolean distinct)
at Forguncy.Server2.Controllers.HomeController.a(List`1 A_0, CurrentRowInfo A_1, Int32 A_2, OffsetSqlCondition A_3, Boolean A_4, ISqlCondition A_5, TopSqlConditionBase A_6, OrderBySqlCondition A_7, List`1 A_8, IDataAccess A_9, Boolean A_10)
at Forguncy.Server2.Controllers.HomeController.a(List`1 A_0, CurrentRowInfo A_1, Int32 A_2, Int32 A_3, Boolean A_4, QueryCommandInfo A_5, List`1 A_6, String A_7, OffsetSqlCondition A_8, Boolean A_9, ColumnFilterQuery[] A_10, Boolean A_11, List`1 A_12, Boolean A_13)
at Forguncy.Server2.Controllers.HomeController.a(List`1 A_0, CurrentRowInfo A_1, Int32 A_2, Int32 A_3, Boolean A_4, QueryCommandInfo A_5, List`1 A_6, String A_7, OffsetSqlCondition A_8, Boolean A_9, ColumnFilterQuery[] A_10, Boolean A_11, List`1 A_12, Boolean A_13)
at Forguncy.Server2.Controllers.HomeController.GetTableDataWithOffset(GetTableDataWithOffsetParam data)
at lambda_method1261(Closure , Object )
at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeFilterPipelineAsync>g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope)
at Microsoft.AspNetCore.Routing.EndpointMiddleware.<Invoke>g__AwaitRequestTask|6_0(Endpoint endpoint, Task requestTask, ILogger logger)
at Forguncy.Server2.KatanaMiddleware.ProcessEngineMiddleware.InvokeAsync(HttpContext context, ICacheService cacheService)
at Forguncy.Server2.KatanaMiddleware.ReportsMiddleware.InvokeAsync(HttpContext context, ICacheService cacheService, IReportServerService reportServerService)
at Forguncy.KatanaMiddleware.ServerCommandMiddleware.InvokeAsync(HttpContext context)
at Forguncy.KatanaMiddleware.k.InvokeAsync(HttpContext context)
at Forguncy.KatanaMiddleware.j.InvokeAsync(HttpContext context)
at Forguncy.Server2.KatanaMiddleware.StartPageMiddleware.InvokeAsync(HttpContext context)
at ForguncyServerCommon.HttpHeaderMiddlewareBase.InvokeAsync(HttpContext context)
at Forguncy.KatanaMiddleware.q.InvokeAsync(HttpContext context)",
"RemoteStackTraceString": null,
"RemoteStackIndex": 0,
"ExceptionMethod": null,
"HResult": -2146232060,
"Source": "Core .Net SqlClient Data Provider",
"WatsonBuckets": null,
"Errors": null,
"ClientConnectionId": "420d3f5d-22fd-4a1d-96d2-f9314bcc607d"
}
MetadataLoader.loggedError @ MetadataLoader.js?v=638035013340000000:623
c.error @ forguncy.js?v=638035013340000000:9
c @ jquery-3.6.0.min.js?v=638035013340000000:2
fireWith @ jquery-3.6.0.min.js?v=638035013340000000:2
l @ jquery-3.6.0.min.js?v=638035013340000000:2
(anonymous) @ jquery-3.6.0.min.js?v=638035013340000000:2
forguncy.js?v=638035013340000000:29 执行点击命令 OrdererInv!P2 用时: 30489 毫秒
forguncy.js?v=638035013340000000:29 条件 用时: 30483 毫秒
forguncy.js?v=638035013340000000:29 判断: =AU2 等于 1 结果为 false
forguncy.js?v=638035013340000000:29 Else 用时: 30483 毫秒
forguncy.js?v=638035013340000000:29 条件 用时: 4 毫秒
forguncy.js?v=638035013340000000:29 判断: =BK2 不等于 %Null% 结果为 true 用时: 4 毫秒
forguncy.js?v=638035013340000000:29
|
陕公网安备：61019002000258 |
隐私政策 |
网站地图