Sep 22 13:20:30 ubuntu dotnet[4147723]: [13:20:30 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/api/schooladmin/devices - 200 null application/json; charset=utf-8 2.608ms Sep 22 13:20:32 ubuntu dotnet[4147723]: [13:20:32 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 13:20:32 ubuntu dotnet[4147723]: SELECT d."Id", d."CommandType", d."CompletedAt", d."CreatedAt", d."CreatedBy", d."DeviceId", d."DurationMs", d."ExpiresAt", d."Parameters", d."ResultCode", d."ResultMessage", d."StartedAt", d."Status", d."TenantId" Sep 22 13:20:32 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 13:20:32 ubuntu dotnet[4147723]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 22 13:20:32 ubuntu dotnet[4147723]: [13:20:32 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/api/schooladmin/devices - null null Sep 22 13:20:32 ubuntu dotnet[4147723]: [13:20:32 INF] Executing endpoint 'ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server)' Sep 22 13:20:32 ubuntu dotnet[4147723]: [13:20:32 INF] Route matched with {action = "GetDevices", controller = "SchoolAdmin"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetDevices() on controller ClassNotify.Server.Controllers.SchoolAdminController (ClassNotify.Server). Sep 22 13:20:32 ubuntu dotnet[4147723]: [13:20:32 INF] Executed DbCommand (0ms) [Parameters=[@__tenantId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 13:20:32 ubuntu dotnet[4147723]: SELECT d."Id", d."ClassroomId", d."CreatedAt", d."DeviceTokenHash", d."Hostname", d."InstallationId", d."IsActive", d."LastHeartbeatAt", d."RawDeviceToken", d."TenantId" Sep 22 13:20:32 ubuntu dotnet[4147723]: FROM "Devices" AS d Sep 22 13:20:32 ubuntu dotnet[4147723]: WHERE d."TenantId" = @__tenantId_0 Sep 22 13:20:32 ubuntu dotnet[4147723]: [13:20:32 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 13:20:32 ubuntu dotnet[4147723]: SELECT t."Id", t."CreatedAt", t."IsActive", t."Name" Sep 22 13:20:32 ubuntu dotnet[4147723]: FROM "Tenants" AS t Sep 22 13:20:32 ubuntu dotnet[4147723]: [13:20:32 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 13:20:32 ubuntu dotnet[4147723]: SELECT c."TenantId", c."Id", c."CreatedAt", c."DisplayName", c."Grade", c."RoomNumber" Sep 22 13:20:32 ubuntu dotnet[4147723]: FROM "Classrooms" AS c Sep 22 13:20:32 ubuntu dotnet[4147723]: [13:20:32 INF] Executing OkObjectResult, writing value of type 'System.Collections.Generic.List`1[[ClassNotify.Shared.Models.DeviceAdminDto, ClassNotify.Shared, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. Sep 22 13:20:32 ubuntu dotnet[4147723]: [13:20:32 INF] Executed action ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server) in 2.0854ms Sep 22 13:20:32 ubuntu dotnet[4147723]: [13:20:32 INF] Executed endpoint 'ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server)' Sep 22 13:20:32 ubuntu dotnet[4147723]: [13:20:32 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/api/schooladmin/devices - 200 null application/json; charset=utf-8 2.5022ms Sep 22 13:20:35 ubuntu dotnet[4147723]: [13:20:35 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/api/schooladmin/devices - null null Sep 22 13:20:35 ubuntu dotnet[4147723]: [13:20:35 INF] Executing endpoint 'ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server)' Sep 22 13:20:35 ubuntu dotnet[4147723]: [13:20:35 INF] Route matched with {action = "GetDevices", controller = "SchoolAdmin"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetDevices() on controller ClassNotify.Server.Controllers.SchoolAdminController (ClassNotify.Server). Sep 22 13:20:35 ubuntu dotnet[4147723]: [13:20:35 INF] Executed DbCommand (1ms) [Parameters=[@__tenantId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 13:20:35 ubuntu dotnet[4147723]: SELECT d."Id", d."ClassroomId", d."CreatedAt", d."DeviceTokenHash", d."Hostname", d."InstallationId", d."IsActive", d."LastHeartbeatAt", d."RawDeviceToken", d."TenantId" Sep 22 13:20:35 ubuntu dotnet[4147723]: FROM "Devices" AS d Sep 22 13:20:35 ubuntu dotnet[4147723]: WHERE d."TenantId" = @__tenantId_0 Sep 22 13:20:35 ubuntu dotnet[4147723]: [13:20:35 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 13:20:35 ubuntu dotnet[4147723]: SELECT t."Id", t."CreatedAt", t."IsActive", t."Name" Sep 22 13:20:35 ubuntu dotnet[4147723]: FROM "Tenants" AS t Sep 22 13:20:35 ubuntu dotnet[4147723]: [13:20:35 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 13:20:35 ubuntu dotnet[4147723]: SELECT c."TenantId", c."Id", c."CreatedAt", c."DisplayName", c."Grade", c."RoomNumber" Sep 22 13:20:35 ubuntu dotnet[4147723]: FROM "Classrooms" AS c Sep 22 13:20:35 ubuntu dotnet[4147723]: [13:20:35 INF] Executing OkObjectResult, writing value of type 'System.Collections.Generic.List`1[[ClassNotify.Shared.Models.DeviceAdminDto, ClassNotify.Shared, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. Sep 22 13:20:35 ubuntu dotnet[4147723]: [13:20:35 INF] Executed action ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server) in 2.2406ms Sep 22 13:20:35 ubuntu dotnet[4147723]: [13:20:35 INF] Executed endpoint 'ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server)' Sep 22 13:20:35 ubuntu dotnet[4147723]: [13:20:35 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/api/schooladmin/devices - 200 null application/json; charset=utf-8 2.644ms Sep 22 13:20:37 ubuntu dotnet[4147723]: [13:20:37 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/api/schooladmin/devices - null null Sep 22 13:20:37 ubuntu dotnet[4147723]: [13:20:37 INF] Executing endpoint 'ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server)' Sep 22 13:20:37 ubuntu dotnet[4147723]: [13:20:37 INF] Route matched with {action = "GetDevices", controller = "SchoolAdmin"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetDevices() on controller ClassNotify.Server.Controllers.SchoolAdminController (ClassNotify.Server). Sep 22 13:20:37 ubuntu dotnet[4147723]: [13:20:37 INF] Executed DbCommand (1ms) [Parameters=[@__tenantId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 13:20:37 ubuntu dotnet[4147723]: SELECT d."Id", d."ClassroomId", d."CreatedAt", d."DeviceTokenHash", d."Hostname", d."InstallationId", d."IsActive", d."LastHeartbeatAt", d."RawDeviceToken", d."TenantId" Sep 22 13:20:37 ubuntu dotnet[4147723]: FROM "Devices" AS d Sep 22 13:20:37 ubuntu dotnet[4147723]: WHERE d."TenantId" = @__tenantId_0 Sep 22 13:20:37 ubuntu dotnet[4147723]: [13:20:37 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 13:20:37 ubuntu dotnet[4147723]: SELECT t."Id", t."CreatedAt", t."IsActive", t."Name" Sep 22 13:20:37 ubuntu dotnet[4147723]: FROM "Tenants" AS t Sep 22 13:20:37 ubuntu dotnet[4147723]: [13:20:37 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 13:20:37 ubuntu dotnet[4147723]: SELECT c."TenantId", c."Id", c."CreatedAt", c."DisplayName", c."Grade", c."RoomNumber" Sep 22 13:20:37 ubuntu dotnet[4147723]: FROM "Classrooms" AS c Sep 22 13:20:37 ubuntu dotnet[4147723]: [13:20:37 INF] Executing OkObjectResult, writing value of type 'System.Collections.Generic.List`1[[ClassNotify.Shared.Models.DeviceAdminDto, ClassNotify.Shared, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. Sep 22 13:20:37 ubuntu dotnet[4147723]: [13:20:37 INF] Executed action ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server) in 2.3941ms Sep 22 13:20:37 ubuntu dotnet[4147723]: [13:20:37 INF] Executed endpoint 'ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server)' Sep 22 13:20:37 ubuntu dotnet[4147723]: [13:20:37 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/api/schooladmin/devices - 200 null application/json; charset=utf-8 2.8273ms Sep 22 13:20:37 ubuntu dotnet[4147723]: [13:20:37 INF] Unregistered active device connection hkIy_RZ9S12HLuRiatF2BQ for Device dev_59e35e79 Sep 22 13:20:37 ubuntu dotnet[4147723]: [13:20:37 INF] Device dev_59e35e79 disconnected for Tenant t_beijing_no4, Class cls_802 Sep 22 13:20:39 ubuntu dotnet[4147723]: [13:20:39 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/api/schooladmin/devices - null null Sep 22 13:20:39 ubuntu dotnet[4147723]: [13:20:39 INF] Executing endpoint 'ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server)' Sep 22 13:20:39 ubuntu dotnet[4147723]: [13:20:39 INF] Route matched with {action = "GetDevices", controller = "SchoolAdmin"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetDevices() on controller ClassNotify.Server.Controllers.SchoolAdminController (ClassNotify.Server). Sep 22 13:20:39 ubuntu dotnet[4147723]: [13:20:39 INF] Executed DbCommand (1ms) [Parameters=[@__tenantId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 13:20:39 ubuntu dotnet[4147723]: SELECT d."Id", d."ClassroomId", d."CreatedAt", d."DeviceTokenHash", d."Hostname", d."InstallationId", d."IsActive", d."LastHeartbeatAt", d."RawDeviceToken", d."TenantId" Sep 22 13:20:39 ubuntu dotnet[4147723]: FROM "Devices" AS d Sep 22 13:20:39 ubuntu dotnet[4147723]: WHERE d."TenantId" = @__tenantId_0 Sep 22 13:20:39 ubuntu dotnet[4147723]: [13:20:39 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 13:20:39 ubuntu dotnet[4147723]: SELECT t."Id", t."CreatedAt", t."IsActive", t."Name" Sep 22 13:20:39 ubuntu dotnet[4147723]: FROM "Tenants" AS t Sep 22 13:20:39 ubuntu dotnet[4147723]: [13:20:39 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 13:20:39 ubuntu dotnet[4147723]: SELECT c."TenantId", c."Id", c."CreatedAt", c."DisplayName", c."Grade", c."RoomNumber" Sep 22 13:20:39 ubuntu dotnet[4147723]: FROM "Classrooms" AS c Sep 22 13:20:39 ubuntu dotnet[4147723]: [13:20:39 INF] Executing OkObjectResult, writing value of type 'System.Collections.Generic.List`1[[ClassNotify.Shared.Models.DeviceAdminDto, ClassNotify.Shared, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. Sep 22 13:20:39 ubuntu dotnet[4147723]: [13:20:39 INF] Executed action ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server) in 2.1825ms Sep 22 13:20:39 ubuntu dotnet[4147723]: [13:20:39 INF] Executed endpoint 'ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server)' Sep 22 13:20:39 ubuntu dotnet[4147723]: [13:20:39 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/api/schooladmin/devices - 200 null application/json; charset=utf-8 2.5936ms Sep 22 13:20:39 ubuntu dotnet[4147723]: [13:20:39 INF] Request starting HTTP/1.1 POST http://classnotify.paradise.eu.org/api/device-command/send - application/json 75 Sep 22 13:20:39 ubuntu dotnet[4147723]: [13:20:39 INF] Executing endpoint 'ClassNotify.Server.Controllers.DeviceCommandController.SendCommand (ClassNotify.Server)' Sep 22 13:20:39 ubuntu dotnet[4147723]: [13:20:39 INF] Route matched with {action = "SendCommand", controller = "DeviceCommand"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SendCommand(ClassNotify.Server.Controllers.SendDeviceCommandRequest) on controller ClassNotify.Server.Controllers.DeviceCommandController (ClassNotify.Server). Sep 22 13:20:40 ubuntu dotnet[4147723]: [13:20:40 INF] Executed DbCommand (1ms) [Parameters=[@__deviceId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 13:20:40 ubuntu dotnet[4147723]: SELECT d."Id", d."ClassroomId", d."CreatedAt", d."DeviceTokenHash", d."Hostname", d."InstallationId", d."IsActive", d."LastHeartbeatAt", d."RawDeviceToken", d."TenantId" Sep 22 13:20:40 ubuntu dotnet[4147723]: FROM "Devices" AS d Sep 22 13:20:40 ubuntu dotnet[4147723]: WHERE d."Id" = @__deviceId_0 Sep 22 13:20:40 ubuntu dotnet[4147723]: LIMIT 1 Sep 22 13:20:40 ubuntu dotnet[4147723]: [13:20:40 INF] Executed DbCommand (2ms) [Parameters=[@p0='?', @p1='?', @p2='?' (DbType = DateTime), @p3='?' (DbType = DateTime), @p4='?', @p5='?', @p6='?' (DbType = Int64), @p7='?' (DbType = DateTime), @p8='?', @p9='?' (DbType = Int32), @p10='?', @p11='?' (DbType = DateTime), @p12='?', @p13='?'], CommandType='Text', CommandTimeout='30'] Sep 22 13:20:40 ubuntu dotnet[4147723]: INSERT INTO "DeviceCommands" ("Id", "CommandType", "CompletedAt", "CreatedAt", "CreatedBy", "DeviceId", "DurationMs", "ExpiresAt", "Parameters", "ResultCode", "ResultMessage", "StartedAt", "Status", "TenantId") Sep 22 13:20:40 ubuntu dotnet[4147723]: VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13); Sep 22 13:20:40 ubuntu dotnet[4147723]: [13:20:40 INF] Created remote command cmd_a2015e08d752498d99887d3e82187fb7 (RestartClient) for Device dev_59e35e79 (Tenant t_beijing_no4, TTL 2m) by 北京四中管理员 Sep 22 13:20:40 ubuntu dotnet[4147723]: [13:20:40 INF] Device dev_59e35e79 is offline. Command cmd_a2015e08d752498d99887d3e82187fb7 queued as Pending until 2026-09-22 13:22:40Z Sep 22 13:20:40 ubuntu dotnet[4147723]: [13:20:40 INF] Executing OkObjectResult, writing value of type '<>f__AnonymousType4`4[[System.Boolean, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[ClassNotify.Shared.Models.DeviceCommandDto, ClassNotify.Shared, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null],[System.Boolean, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[System.String, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. Sep 22 13:20:40 ubuntu dotnet[4147723]: [13:20:40 INF] Executed action ClassNotify.Server.Controllers.DeviceCommandController.SendCommand (ClassNotify.Server) in 274.2718ms Sep 22 13:20:40 ubuntu dotnet[4147723]: [13:20:40 INF] Executed endpoint 'ClassNotify.Server.Controllers.DeviceCommandController.SendCommand (ClassNotify.Server)' Sep 22 13:20:40 ubuntu dotnet[4147723]: [13:20:40 INF] Request finished HTTP/1.1 POST https://classnotify.paradise.eu.org/api/device-command/send - 200 null application/json; charset=utf-8 274.7705ms Sep 22 13:20:42 ubuntu dotnet[4147723]: [13:20:42 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 13:20:42 ubuntu dotnet[4147723]: SELECT d."Id", d."CommandType", d."CompletedAt", d."CreatedAt", d."CreatedBy", d."DeviceId", d."DurationMs", d."ExpiresAt", d."Parameters", d."ResultCode", d."ResultMessage", d."StartedAt", d."Status", d."TenantId" Sep 22 13:20:42 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 13:20:42 ubuntu dotnet[4147723]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 22 13:20:42 ubuntu dotnet[4147723]: [13:20:42 INF] Connection id "0HNOOC57U1J6A", Request id "0HNOOC57U1J6A:00000001": the application aborted the connection. Sep 22 13:20:42 ubuntu dotnet[4147723]: [13:20:42 INF] Executed endpoint '/hubs/device' Sep 22 13:20:42 ubuntu dotnet[4147723]: [13:20:42 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/hubs/device?id=zqQahYvu_PGS-jiEwy06pA - 101 null null 41519.2896ms Sep 22 13:20:52 ubuntu dotnet[4147723]: [13:20:52 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 13:20:52 ubuntu dotnet[4147723]: SELECT d."Id", d."CommandType", d."CompletedAt", d."CreatedAt", d."CreatedBy", d."DeviceId", d."DurationMs", d."ExpiresAt", d."Parameters", d."ResultCode", d."ResultMessage", d."StartedAt", d."Status", d."TenantId" Sep 22 13:20:52 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 13:20:52 ubuntu dotnet[4147723]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 22 13:21:02 ubuntu dotnet[4147723]: [13:21:02 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 13:21:02 ubuntu dotnet[4147723]: SELECT d."Id", d."CommandType", d."CompletedAt", d."CreatedAt", d."CreatedBy", d."DeviceId", d."DurationMs", d."ExpiresAt", d."Parameters", d."ResultCode", d."ResultMessage", d."StartedAt", d."Status", d."TenantId" Sep 22 13:21:02 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 13:21:02 ubuntu dotnet[4147723]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 22 13:21:12 ubuntu dotnet[4147723]: [13:21:12 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 13:21:12 ubuntu dotnet[4147723]: SELECT d."Id", d."CommandType", d."CompletedAt", d."CreatedAt", d."CreatedBy", d."DeviceId", d."DurationMs", d."ExpiresAt", d."Parameters", d."ResultCode", d."ResultMessage", d."StartedAt", d."Status", d."TenantId" Sep 22 13:21:12 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 13:21:12 ubuntu dotnet[4147723]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 22 13:21:22 ubuntu dotnet[4147723]: [13:21:22 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 13:21:22 ubuntu dotnet[4147723]: SELECT d."Id", d."CommandType", d."CompletedAt", d."CreatedAt", d."CreatedBy", d."DeviceId", d."DurationMs", d."ExpiresAt", d."Parameters", d."ResultCode", d."ResultMessage", d."StartedAt", d."Status", d."TenantId" Sep 22 13:21:22 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 13:21:22 ubuntu dotnet[4147723]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 22 13:21:32 ubuntu dotnet[4147723]: [13:21:32 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 13:21:32 ubuntu dotnet[4147723]: SELECT d."Id", d."CommandType", d."CompletedAt", d."CreatedAt", d."CreatedBy", d."DeviceId", d."DurationMs", d."ExpiresAt", d."Parameters", d."ResultCode", d."ResultMessage", d."StartedAt", d."Status", d."TenantId" Sep 22 13:21:32 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 13:21:32 ubuntu dotnet[4147723]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 22 13:21:42 ubuntu dotnet[4147723]: [13:21:42 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 13:21:42 ubuntu dotnet[4147723]: SELECT d."Id", d."CommandType", d."CompletedAt", d."CreatedAt", d."CreatedBy", d."DeviceId", d."DurationMs", d."ExpiresAt", d."Parameters", d."ResultCode", d."ResultMessage", d."StartedAt", d."Status", d."TenantId" Sep 22 13:21:42 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 13:21:42 ubuntu dotnet[4147723]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 22 13:21:52 ubuntu dotnet[4147723]: [13:21:52 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 13:21:52 ubuntu dotnet[4147723]: SELECT d."Id", d."CommandType", d."CompletedAt", d."CreatedAt", d."CreatedBy", d."DeviceId", d."DurationMs", d."ExpiresAt", d."Parameters", d."ResultCode", d."ResultMessage", d."StartedAt", d."Status", d."TenantId" Sep 22 13:21:52 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 13:21:52 ubuntu dotnet[4147723]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 22 13:22:02 ubuntu dotnet[4147723]: [13:22:02 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 13:22:02 ubuntu dotnet[4147723]: SELECT d."Id", d."CommandType", d."CompletedAt", d."CreatedAt", d."CreatedBy", d."DeviceId", d."DurationMs", d."ExpiresAt", d."Parameters", d."ResultCode", d."ResultMessage", d."StartedAt", d."Status", d."TenantId" Sep 22 13:22:02 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 13:22:02 ubuntu dotnet[4147723]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 22 13:22:12 ubuntu dotnet[4147723]: [13:22:12 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 13:22:12 ubuntu dotnet[4147723]: SELECT d."Id", d."CommandType", d."CompletedAt", d."CreatedAt", d."CreatedBy", d."DeviceId", d."DurationMs", d."ExpiresAt", d."Parameters", d."ResultCode", d."ResultMessage", d."StartedAt", d."Status", d."TenantId" Sep 22 13:22:12 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 13:22:12 ubuntu dotnet[4147723]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 22 13:22:22 ubuntu dotnet[4147723]: [13:22:22 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 13:22:22 ubuntu dotnet[4147723]: SELECT d."Id", d."CommandType", d."CompletedAt", d."CreatedAt", d."CreatedBy", d."DeviceId", d."DurationMs", d."ExpiresAt", d."Parameters", d."ResultCode", d."ResultMessage", d."StartedAt", d."Status", d."TenantId" Sep 22 13:22:22 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 13:22:22 ubuntu dotnet[4147723]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 22 13:22:32 ubuntu dotnet[4147723]: [13:22:32 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 13:22:32 ubuntu dotnet[4147723]: SELECT d."Id", d."CommandType", d."CompletedAt", d."CreatedAt", d."CreatedBy", d."DeviceId", d."DurationMs", d."ExpiresAt", d."Parameters", d."ResultCode", d."ResultMessage", d."StartedAt", d."Status", d."TenantId" Sep 22 13:22:32 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 13:22:32 ubuntu dotnet[4147723]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 22 13:22:42 ubuntu dotnet[4147723]: [13:22:42 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 13:22:42 ubuntu dotnet[4147723]: SELECT d."Id", d."CommandType", d."CompletedAt", d."CreatedAt", d."CreatedBy", d."DeviceId", d."DurationMs", d."ExpiresAt", d."Parameters", d."ResultCode", d."ResultMessage", d."StartedAt", d."Status", d."TenantId" Sep 22 13:22:42 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 13:22:42 ubuntu dotnet[4147723]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 22 13:22:42 ubuntu dotnet[4147723]: [13:22:42 WRN] Command cmd_a2015e08d752498d99887d3e82187fb7 (Device dev_59e35e79, Tenant t_beijing_no4) transitioned to terminal status 'Expired': Command pending expired before dispatch or device reconnect. Sep 22 13:22:42 ubuntu dotnet[4147723]: [13:22:42 INF] Executed DbCommand (2ms) [Parameters=[@p4='?', @p0='?' (DbType = DateTime), @p1='?' (DbType = Int32), @p2='?', @p3='?'], CommandType='Text', CommandTimeout='30'] Sep 22 13:22:42 ubuntu dotnet[4147723]: UPDATE "DeviceCommands" SET "CompletedAt" = @p0, "ResultCode" = @p1, "ResultMessage" = @p2, "Status" = @p3 Sep 22 13:22:42 ubuntu dotnet[4147723]: WHERE "Id" = @p4; Sep 22 13:22:52 ubuntu dotnet[4147723]: [13:22:52 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 13:22:52 ubuntu dotnet[4147723]: SELECT d."Id", d."CommandType", d."CompletedAt", d."CreatedAt", d."CreatedBy", d."DeviceId", d."DurationMs", d."ExpiresAt", d."Parameters", d."ResultCode", d."ResultMessage", d."StartedAt", d."Status", d."TenantId" Sep 22 13:22:52 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 13:22:52 ubuntu dotnet[4147723]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 22 13:23:01 ubuntu dotnet[4147723]: [13:23:01 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/api/device-command/cmd_a2015e08d752498d99887d3e82187fb7 - null null Sep 22 13:23:01 ubuntu dotnet[4147723]: [13:23:01 INF] Executing endpoint 'ClassNotify.Server.Controllers.DeviceCommandController.GetCommand (ClassNotify.Server)' Sep 22 13:23:01 ubuntu dotnet[4147723]: [13:23:01 INF] Route matched with {action = "GetCommand", controller = "DeviceCommand"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetCommand(System.String) on controller ClassNotify.Server.Controllers.DeviceCommandController (ClassNotify.Server). Sep 22 13:23:01 ubuntu dotnet[4147723]: [13:23:01 INF] Executed DbCommand (1ms) [Parameters=[@__commandId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 13:23:01 ubuntu dotnet[4147723]: SELECT d."Id", d."CommandType", d."CompletedAt", d."CreatedAt", d."CreatedBy", d."DeviceId", d."DurationMs", d."ExpiresAt", d."Parameters", d."ResultCode", d."ResultMessage", d."StartedAt", d."Status", d."TenantId" Sep 22 13:23:01 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 13:23:01 ubuntu dotnet[4147723]: WHERE d."Id" = @__commandId_0 Sep 22 13:23:01 ubuntu dotnet[4147723]: LIMIT 1 Sep 22 13:23:01 ubuntu dotnet[4147723]: [13:23:01 INF] Executing OkObjectResult, writing value of type 'ClassNotify.Shared.Models.DeviceCommandDto'. Sep 22 13:23:01 ubuntu dotnet[4147723]: [13:23:01 INF] Executed action ClassNotify.Server.Controllers.DeviceCommandController.GetCommand (ClassNotify.Server) in 1.587ms Sep 22 13:23:01 ubuntu dotnet[4147723]: [13:23:01 INF] Executed endpoint 'ClassNotify.Server.Controllers.DeviceCommandController.GetCommand (ClassNotify.Server)' Sep 22 13:23:01 ubuntu dotnet[4147723]: [13:23:01 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/api/device-command/cmd_a2015e08d752498d99887d3e82187fb7 - 200 null application/json; charset=utf-8 2.0135ms Sep 22 13:23:02 ubuntu dotnet[4147723]: [13:23:02 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 13:23:02 ubuntu dotnet[4147723]: SELECT d."Id", d."CommandType", d."CompletedAt", d."CreatedAt", d."CreatedBy", d."DeviceId", d."DurationMs", d."ExpiresAt", d."Parameters", d."ResultCode", d."ResultMessage", d."StartedAt", d."Status", d."TenantId" Sep 22 13:23:02 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 13:23:02 ubuntu dotnet[4147723]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 22 13:23:12 ubuntu dotnet[4147723]: [13:23:12 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 13:23:12 ubuntu dotnet[4147723]: SELECT d."Id", d."CommandType", d."CompletedAt", d."CreatedAt", d."CreatedBy", d."DeviceId", d."DurationMs", d."ExpiresAt", d."Parameters", d."ResultCode", d."ResultMessage", d."StartedAt", d."Status", d."TenantId" Sep 22 13:23:12 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 13:23:12 ubuntu dotnet[4147723]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 22 13:23:12 ubuntu dotnet[4147723]: [13:23:12 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/api/device-command/history?deviceId=dev_59e35e79&limit=20 - null null Sep 22 13:23:12 ubuntu dotnet[4147723]: [13:23:12 INF] Executing endpoint 'ClassNotify.Server.Controllers.DeviceCommandController.GetHistory (ClassNotify.Server)' Sep 22 13:23:12 ubuntu dotnet[4147723]: [13:23:12 INF] Route matched with {action = "GetHistory", controller = "DeviceCommand"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetHistory(System.String, System.String, Int32) on controller ClassNotify.Server.Controllers.DeviceCommandController (ClassNotify.Server). Sep 22 13:23:12 ubuntu dotnet[4147723]: [13:23:12 INF] Executed DbCommand (1ms) [Parameters=[@__tenantId_0='?', @__deviceId_1='?', @__p_2='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30'] Sep 22 13:23:12 ubuntu dotnet[4147723]: SELECT d."Id", d."CommandType", d."CompletedAt", d."CreatedAt", d."CreatedBy", d."DeviceId", d."DurationMs", d."ExpiresAt", d."Parameters", d."ResultCode", d."ResultMessage", d."StartedAt", d."Status", d."TenantId" Sep 22 13:23:12 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 13:23:12 ubuntu dotnet[4147723]: WHERE d."TenantId" = @__tenantId_0 AND d."DeviceId" = @__deviceId_1 Sep 22 13:23:12 ubuntu dotnet[4147723]: ORDER BY d."CreatedAt" DESC Sep 22 13:23:12 ubuntu dotnet[4147723]: LIMIT @__p_2 Sep 22 13:23:12 ubuntu dotnet[4147723]: [13:23:12 INF] Executing OkObjectResult, writing value of type 'System.Collections.Generic.List`1[[ClassNotify.Shared.Models.DeviceCommandDto, ClassNotify.Shared, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. Sep 22 13:23:12 ubuntu dotnet[4147723]: [13:23:12 INF] Executed action ClassNotify.Server.Controllers.DeviceCommandController.GetHistory (ClassNotify.Server) in 2.189ms Sep 22 13:23:12 ubuntu dotnet[4147723]: [13:23:12 INF] Executed endpoint 'ClassNotify.Server.Controllers.DeviceCommandController.GetHistory (ClassNotify.Server)' Sep 22 13:23:12 ubuntu dotnet[4147723]: [13:23:12 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/api/device-command/history?deviceId=dev_59e35e79&limit=20 - 200 null application/json; charset=utf-8 2.9377ms Sep 22 13:23:13 ubuntu dotnet[4147723]: [13:23:13 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/api/health - null null Sep 22 13:23:13 ubuntu dotnet[4147723]: [13:23:13 INF] Executing endpoint 'HTTP: GET /api/health' Sep 22 13:23:13 ubuntu dotnet[4147723]: [13:23:13 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 13:23:13 ubuntu dotnet[4147723]: SELECT 1 Sep 22 13:23:13 ubuntu dotnet[4147723]: [13:23:13 INF] Setting HTTP status code 200. Sep 22 13:23:13 ubuntu dotnet[4147723]: [13:23:13 INF] Writing value of type '<>f__AnonymousType28`6' as Json. Sep 22 13:23:13 ubuntu dotnet[4147723]: [13:23:13 INF] Executed endpoint 'HTTP: GET /api/health' Sep 22 13:23:13 ubuntu dotnet[4147723]: [13:23:13 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/api/health - 200 null application/json; charset=utf-8 13.1161ms Sep 22 13:23:22 ubuntu dotnet[4147723]: [13:23:22 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 13:23:22 ubuntu dotnet[4147723]: SELECT d."Id", d."CommandType", d."CompletedAt", d."CreatedAt", d."CreatedBy", d."DeviceId", d."DurationMs", d."ExpiresAt", d."Parameters", d."ResultCode", d."ResultMessage", d."StartedAt", d."Status", d."TenantId" Sep 22 13:23:22 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 13:23:22 ubuntu dotnet[4147723]: WHERE d."Status" IN ('Pending', 'Dispatched')