Sep 22 22:37:09 ubuntu dotnet[4147723]: [22:37:09 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/api/schooladmin/devices - null null Sep 22 22:37:09 ubuntu dotnet[4147723]: [22:37:09 INF] Executing endpoint 'ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server)' Sep 22 22:37:09 ubuntu dotnet[4147723]: [22:37:09 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 22:37:09 ubuntu dotnet[4147723]: [22:37:09 INF] Executed DbCommand (1ms) [Parameters=[@__tenantId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 22:37:09 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 22:37:09 ubuntu dotnet[4147723]: FROM "Devices" AS d Sep 22 22:37:09 ubuntu dotnet[4147723]: WHERE d."TenantId" = @__tenantId_0 Sep 22 22:37:09 ubuntu dotnet[4147723]: [22:37:09 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 22:37:09 ubuntu dotnet[4147723]: SELECT t."Id", t."CreatedAt", t."IsActive", t."Name" Sep 22 22:37:09 ubuntu dotnet[4147723]: FROM "Tenants" AS t Sep 22 22:37:09 ubuntu dotnet[4147723]: [22:37:09 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 22:37:09 ubuntu dotnet[4147723]: SELECT c."TenantId", c."Id", c."CreatedAt", c."DisplayName", c."Grade", c."RoomNumber" Sep 22 22:37:09 ubuntu dotnet[4147723]: FROM "Classrooms" AS c Sep 22 22:37:09 ubuntu dotnet[4147723]: [22:37:09 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 22:37:09 ubuntu dotnet[4147723]: [22:37:09 INF] Executed action ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server) in 2.146ms Sep 22 22:37:09 ubuntu dotnet[4147723]: [22:37:09 INF] Executed endpoint 'ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server)' Sep 22 22:37:09 ubuntu dotnet[4147723]: [22:37:09 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/api/schooladmin/devices - 200 null application/json; charset=utf-8 2.5639ms Sep 22 22:37:11 ubuntu dotnet[4147723]: [22:37:11 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/api/schooladmin/devices - null null Sep 22 22:37:11 ubuntu dotnet[4147723]: [22:37:11 INF] Executing endpoint 'ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server)' Sep 22 22:37:11 ubuntu dotnet[4147723]: [22:37:11 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 22:37:11 ubuntu dotnet[4147723]: [22:37:11 INF] Executed DbCommand (1ms) [Parameters=[@__tenantId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 22:37:11 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 22:37:11 ubuntu dotnet[4147723]: FROM "Devices" AS d Sep 22 22:37:11 ubuntu dotnet[4147723]: WHERE d."TenantId" = @__tenantId_0 Sep 22 22:37:11 ubuntu dotnet[4147723]: [22:37:11 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 22:37:11 ubuntu dotnet[4147723]: SELECT t."Id", t."CreatedAt", t."IsActive", t."Name" Sep 22 22:37:11 ubuntu dotnet[4147723]: FROM "Tenants" AS t Sep 22 22:37:11 ubuntu dotnet[4147723]: [22:37:11 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 22:37:11 ubuntu dotnet[4147723]: SELECT c."TenantId", c."Id", c."CreatedAt", c."DisplayName", c."Grade", c."RoomNumber" Sep 22 22:37:11 ubuntu dotnet[4147723]: FROM "Classrooms" AS c Sep 22 22:37:11 ubuntu dotnet[4147723]: [22:37:11 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 22:37:11 ubuntu dotnet[4147723]: [22:37:11 INF] Executed action ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server) in 2.9626ms Sep 22 22:37:11 ubuntu dotnet[4147723]: [22:37:11 INF] Executed endpoint 'ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server)' Sep 22 22:37:11 ubuntu dotnet[4147723]: [22:37:11 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/api/schooladmin/devices - 200 null application/json; charset=utf-8 3.4033ms Sep 22 22:37:12 ubuntu dotnet[4147723]: [22:37:12 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 22:37: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 22:37:12 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 22:37:12 ubuntu dotnet[4147723]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 22 22:37:13 ubuntu dotnet[4147723]: [22:37:13 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/api/schooladmin/devices - null null Sep 22 22:37:13 ubuntu dotnet[4147723]: [22:37:13 INF] Executing endpoint 'ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server)' Sep 22 22:37:13 ubuntu dotnet[4147723]: [22:37:13 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 22:37:13 ubuntu dotnet[4147723]: [22:37:13 INF] Executed DbCommand (1ms) [Parameters=[@__tenantId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 22:37:13 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 22:37:13 ubuntu dotnet[4147723]: FROM "Devices" AS d Sep 22 22:37:13 ubuntu dotnet[4147723]: WHERE d."TenantId" = @__tenantId_0 Sep 22 22:37:13 ubuntu dotnet[4147723]: [22:37:13 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 22:37:13 ubuntu dotnet[4147723]: SELECT t."Id", t."CreatedAt", t."IsActive", t."Name" Sep 22 22:37:13 ubuntu dotnet[4147723]: FROM "Tenants" AS t Sep 22 22:37:13 ubuntu dotnet[4147723]: [22:37:13 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 22:37:13 ubuntu dotnet[4147723]: SELECT c."TenantId", c."Id", c."CreatedAt", c."DisplayName", c."Grade", c."RoomNumber" Sep 22 22:37:13 ubuntu dotnet[4147723]: FROM "Classrooms" AS c Sep 22 22:37:13 ubuntu dotnet[4147723]: [22:37:13 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 22:37:13 ubuntu dotnet[4147723]: [22:37:13 INF] Executed action ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server) in 2.3615ms Sep 22 22:37:13 ubuntu dotnet[4147723]: [22:37:13 INF] Executed endpoint 'ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server)' Sep 22 22:37:13 ubuntu dotnet[4147723]: [22:37:13 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/api/schooladmin/devices - 200 null application/json; charset=utf-8 2.7683ms Sep 22 22:37:14 ubuntu dotnet[4147723]: [22:37:14 INF] Request starting HTTP/1.1 POST http://classnotify.paradise.eu.org/hubs/device/negotiate?negotiateVersion=1 - null 0 Sep 22 22:37:14 ubuntu dotnet[4147723]: [22:37:14 INF] Executing endpoint '/hubs/device/negotiate' Sep 22 22:37:14 ubuntu dotnet[4147723]: [22:37:14 INF] Executed endpoint '/hubs/device/negotiate' Sep 22 22:37:14 ubuntu dotnet[4147723]: [22:37:14 INF] Request finished HTTP/1.1 POST https://classnotify.paradise.eu.org/hubs/device/negotiate?negotiateVersion=1 - 200 316 application/json 0.3213ms Sep 22 22:37:15 ubuntu dotnet[4147723]: [22:37:15 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/hubs/device?id=YYOa9LcFTlW3z6U1UKYKeQ - null null Sep 22 22:37:15 ubuntu dotnet[4147723]: [22:37:15 INF] Executing endpoint '/hubs/device' Sep 22 22:37:15 ubuntu dotnet[4147723]: [22:37:15 INF] Executed DbCommand (1ms) [Parameters=[@__deviceId_0='?', @__tokenHash_1='?'], CommandType='Text', CommandTimeout='30'] Sep 22 22:37:15 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 22:37:15 ubuntu dotnet[4147723]: FROM "Devices" AS d Sep 22 22:37:15 ubuntu dotnet[4147723]: WHERE d."Id" = @__deviceId_0 AND d."DeviceTokenHash" = @__tokenHash_1 AND d."IsActive" Sep 22 22:37:15 ubuntu dotnet[4147723]: LIMIT 1 Sep 22 22:37:15 ubuntu dotnet[4147723]: [22:37:15 INF] Device dev_59e35e79 connected via SignalR. ConnectionId=nEFejlXKdxxWwK5KkEvTaw, IP=130.61.36.218 Sep 22 22:37:15 ubuntu dotnet[4147723]: [22:37:15 INF] Device dev_59e35e79 authenticated successfully. Joined group t:t_beijing_no4:c:cls_802 at nEFejlXKdxxWwK5KkEvTaw Sep 22 22:37:15 ubuntu dotnet[4147723]: [22:37:15 INF] Executed DbCommand (0ms) [Parameters=[@__tenantId_0='?', @__classId_1='?'], CommandType='Text', CommandTimeout='30'] Sep 22 22:37:15 ubuntu dotnet[4147723]: SELECT c."TenantId", c."Id", c."CreatedAt", c."DisplayName", c."Grade", c."RoomNumber" Sep 22 22:37:15 ubuntu dotnet[4147723]: FROM "Classrooms" AS c Sep 22 22:37:15 ubuntu dotnet[4147723]: WHERE c."TenantId" = @__tenantId_0 AND c."Id" = @__classId_1 Sep 22 22:37:15 ubuntu dotnet[4147723]: LIMIT 1 Sep 22 22:37:15 ubuntu dotnet[4147723]: [22:37:15 INF] Executed DbCommand (1ms) [Parameters=[@__deviceId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 22:37:15 ubuntu dotnet[4147723]: SELECT n."Id", n."AcknowledgedAt", n."DeviceId", n."DeviceReceivedAt", n."DisplayedAt", n."FailedAt", n."FailureReason", n."NotificationId", n."Status", n."UpdatedAt", n0."Id", n0."ClassroomId", n0."CreatedAt", n0."DurationSeconds", n0."ExpiresAt", n0."Message", n0."Priority", n0."SenderName", n0."SenderUserId", n0."Shake", n0."TenantId", n0."Title", n0."Voice" Sep 22 22:37:15 ubuntu dotnet[4147723]: FROM "NotificationReceipts" AS n Sep 22 22:37:15 ubuntu dotnet[4147723]: INNER JOIN "Notifications" AS n0 ON n."NotificationId" = n0."Id" Sep 22 22:37:15 ubuntu dotnet[4147723]: WHERE n."DeviceId" = @__deviceId_0 AND n."Status" = 'Sent' Sep 22 22:37:15 ubuntu dotnet[4147723]: [22:37:15 INF] Executed DbCommand (1ms) [Parameters=[@__deviceId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 22:37:15 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 22:37:15 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 22:37:15 ubuntu dotnet[4147723]: WHERE d."DeviceId" = @__deviceId_0 AND d."Status" IN ('Pending', 'Dispatched') Sep 22 22:37:15 ubuntu dotnet[4147723]: ORDER BY d."CreatedAt" Sep 22 22:37:16 ubuntu dotnet[4147723]: [22:37:16 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/api/schooladmin/devices - null null Sep 22 22:37:16 ubuntu dotnet[4147723]: [22:37:16 INF] Executing endpoint 'ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server)' Sep 22 22:37:16 ubuntu dotnet[4147723]: [22:37:16 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 22:37:16 ubuntu dotnet[4147723]: [22:37:16 INF] Executed DbCommand (0ms) [Parameters=[@__tenantId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 22:37:16 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 22:37:16 ubuntu dotnet[4147723]: FROM "Devices" AS d Sep 22 22:37:16 ubuntu dotnet[4147723]: WHERE d."TenantId" = @__tenantId_0 Sep 22 22:37:16 ubuntu dotnet[4147723]: [22:37:16 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 22:37:16 ubuntu dotnet[4147723]: SELECT t."Id", t."CreatedAt", t."IsActive", t."Name" Sep 22 22:37:16 ubuntu dotnet[4147723]: FROM "Tenants" AS t Sep 22 22:37:16 ubuntu dotnet[4147723]: [22:37:16 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 22:37:16 ubuntu dotnet[4147723]: SELECT c."TenantId", c."Id", c."CreatedAt", c."DisplayName", c."Grade", c."RoomNumber" Sep 22 22:37:16 ubuntu dotnet[4147723]: FROM "Classrooms" AS c Sep 22 22:37:16 ubuntu dotnet[4147723]: [22:37:16 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 22:37:16 ubuntu dotnet[4147723]: [22:37:16 INF] Executed action ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server) in 2.1202ms Sep 22 22:37:16 ubuntu dotnet[4147723]: [22:37:16 INF] Executed endpoint 'ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server)' Sep 22 22:37:16 ubuntu dotnet[4147723]: [22:37:16 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/api/schooladmin/devices - 200 null application/json; charset=utf-8 2.5085ms Sep 22 22:37:16 ubuntu dotnet[4147723]: [22:37:16 INF] Request starting HTTP/1.1 POST http://classnotify.paradise.eu.org/api/device-command/send - application/json 75 Sep 22 22:37:16 ubuntu dotnet[4147723]: [22:37:16 INF] Executing endpoint 'ClassNotify.Server.Controllers.DeviceCommandController.SendCommand (ClassNotify.Server)' Sep 22 22:37:16 ubuntu dotnet[4147723]: [22:37:16 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 22:37:16 ubuntu dotnet[4147723]: [22:37:16 INF] Executed DbCommand (1ms) [Parameters=[@__deviceId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 22:37:16 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 22:37:16 ubuntu dotnet[4147723]: FROM "Devices" AS d Sep 22 22:37:16 ubuntu dotnet[4147723]: WHERE d."Id" = @__deviceId_0 Sep 22 22:37:16 ubuntu dotnet[4147723]: LIMIT 1 Sep 22 22:37:16 ubuntu dotnet[4147723]: [22:37:16 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 22:37:16 ubuntu dotnet[4147723]: INSERT INTO "DeviceCommands" ("Id", "CommandType", "CompletedAt", "CreatedAt", "CreatedBy", "DeviceId", "DurationMs", "ExpiresAt", "Parameters", "ResultCode", "ResultMessage", "StartedAt", "Status", "TenantId") Sep 22 22:37:16 ubuntu dotnet[4147723]: VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13); Sep 22 22:37:16 ubuntu dotnet[4147723]: [22:37:16 INF] Created remote command cmd_737ad775465148c89721a7486cf13d21 (RestartClient) for Device dev_59e35e79 (Tenant t_beijing_no4, TTL 2m) by 北京四中管理员 Sep 22 22:37:16 ubuntu dotnet[4147723]: [22:37:16 INF] Executed DbCommand (0ms) [Parameters=[@__commandId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 22:37:16 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 22:37:16 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 22:37:16 ubuntu dotnet[4147723]: WHERE d."Id" = @__commandId_0 Sep 22 22:37:16 ubuntu dotnet[4147723]: LIMIT 1 Sep 22 22:37:16 ubuntu dotnet[4147723]: [22:37:16 INF] Executed DbCommand (1ms) [Parameters=[@p1='?', @p0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 22:37:16 ubuntu dotnet[4147723]: UPDATE "DeviceCommands" SET "Status" = @p0 Sep 22 22:37:16 ubuntu dotnet[4147723]: WHERE "Id" = @p1; Sep 22 22:37:16 ubuntu dotnet[4147723]: [22:37:16 INF] Dispatched command cmd_737ad775465148c89721a7486cf13d21 (RestartClient) to device dev_59e35e79 via SignalR nEFejlXKdxxWwK5KkEvTaw Sep 22 22:37:16 ubuntu dotnet[4147723]: [22:37:16 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 22:37:16 ubuntu dotnet[4147723]: [22:37:16 INF] Executed action ClassNotify.Server.Controllers.DeviceCommandController.SendCommand (ClassNotify.Server) in 281.7248ms Sep 22 22:37:16 ubuntu dotnet[4147723]: [22:37:16 INF] Executed endpoint 'ClassNotify.Server.Controllers.DeviceCommandController.SendCommand (ClassNotify.Server)' Sep 22 22:37:16 ubuntu dotnet[4147723]: [22:37:16 INF] Request finished HTTP/1.1 POST https://classnotify.paradise.eu.org/api/device-command/send - 200 null application/json; charset=utf-8 282.1112ms Sep 22 22:37:17 ubuntu dotnet[4147723]: [22:37:17 INF] Executed DbCommand (1ms) [Parameters=[@__result_CommandId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 22:37:17 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 22:37:17 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 22:37:17 ubuntu dotnet[4147723]: WHERE d."Id" = @__result_CommandId_0 Sep 22 22:37:17 ubuntu dotnet[4147723]: LIMIT 1 Sep 22 22:37:17 ubuntu dotnet[4147723]: [22:37:17 INF] Executed DbCommand (1ms) [Parameters=[@p6='?', @p0='?' (DbType = DateTime), @p1='?' (DbType = Int64), @p2='?' (DbType = Int32), @p3='?', @p4='?' (DbType = DateTime), @p5='?'], CommandType='Text', CommandTimeout='30'] Sep 22 22:37:17 ubuntu dotnet[4147723]: UPDATE "DeviceCommands" SET "CompletedAt" = @p0, "DurationMs" = @p1, "ResultCode" = @p2, "ResultMessage" = @p3, "StartedAt" = @p4, "Status" = @p5 Sep 22 22:37:17 ubuntu dotnet[4147723]: WHERE "Id" = @p6; Sep 22 22:37:17 ubuntu dotnet[4147723]: [22:37:17 INF] Recorded execution result for Command cmd_737ad775465148c89721a7486cf13d21 (Device dev_59e35e79): Status=Succeeded, ResultCode=0, Duration=395ms Sep 22 22:37:19 ubuntu dotnet[4147723]: [22:37:19 INF] Executed DbCommand (1ms) [Parameters=[@__p_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 22:37:19 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 22:37:19 ubuntu dotnet[4147723]: FROM "Devices" AS d Sep 22 22:37:19 ubuntu dotnet[4147723]: WHERE d."Id" = @__p_0 Sep 22 22:37:19 ubuntu dotnet[4147723]: LIMIT 1 Sep 22 22:37:19 ubuntu dotnet[4147723]: [22:37:19 INF] Executed DbCommand (2ms) [Parameters=[@p1='?', @p0='?' (DbType = DateTime)], CommandType='Text', CommandTimeout='30'] Sep 22 22:37:19 ubuntu dotnet[4147723]: UPDATE "Devices" SET "LastHeartbeatAt" = @p0 Sep 22 22:37:19 ubuntu dotnet[4147723]: WHERE "Id" = @p1; Sep 22 22:37:20 ubuntu dotnet[4147723]: [22:37:20 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/api/health - null null Sep 22 22:37:20 ubuntu dotnet[4147723]: [22:37:20 INF] Executing endpoint 'HTTP: GET /api/health' Sep 22 22:37:20 ubuntu dotnet[4147723]: [22:37:20 INF] Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 22:37:20 ubuntu dotnet[4147723]: SELECT 1 Sep 22 22:37:20 ubuntu dotnet[4147723]: [22:37:20 INF] Setting HTTP status code 200. Sep 22 22:37:20 ubuntu dotnet[4147723]: [22:37:20 INF] Writing value of type '<>f__AnonymousType28`6' as Json. Sep 22 22:37:20 ubuntu dotnet[4147723]: [22:37:20 INF] Executed endpoint 'HTTP: GET /api/health' Sep 22 22:37:20 ubuntu dotnet[4147723]: [22:37:20 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/api/health - 200 null application/json; charset=utf-8 15.3726ms Sep 22 22:37:22 ubuntu dotnet[4147723]: [22:37:22 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 22:37: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 22:37:22 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 22:37:22 ubuntu dotnet[4147723]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 22 22:37:24 ubuntu dotnet[4147723]: [22:37:24 INF] Request starting HTTP/1.1 POST http://classnotify.paradise.eu.org/api/device-command/send - application/json 71 Sep 22 22:37:24 ubuntu dotnet[4147723]: [22:37:24 INF] Executing endpoint 'ClassNotify.Server.Controllers.DeviceCommandController.SendCommand (ClassNotify.Server)' Sep 22 22:37:24 ubuntu dotnet[4147723]: [22:37:24 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 22:37:24 ubuntu dotnet[4147723]: [22:37:24 INF] Executed DbCommand (1ms) [Parameters=[@__deviceId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 22:37:24 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 22:37:24 ubuntu dotnet[4147723]: FROM "Devices" AS d Sep 22 22:37:24 ubuntu dotnet[4147723]: WHERE d."Id" = @__deviceId_0 Sep 22 22:37:24 ubuntu dotnet[4147723]: LIMIT 1 Sep 22 22:37:24 ubuntu dotnet[4147723]: [22:37:24 INF] Executed DbCommand (1ms) [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 22:37:24 ubuntu dotnet[4147723]: INSERT INTO "DeviceCommands" ("Id", "CommandType", "CompletedAt", "CreatedAt", "CreatedBy", "DeviceId", "DurationMs", "ExpiresAt", "Parameters", "ResultCode", "ResultMessage", "StartedAt", "Status", "TenantId") Sep 22 22:37:24 ubuntu dotnet[4147723]: VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13); Sep 22 22:37:24 ubuntu dotnet[4147723]: [22:37:24 INF] Created remote command cmd_a4aae3f9e8b440b48a83de01bb5629fc (Reconnect) for Device dev_59e35e79 (Tenant t_beijing_no4, TTL 2m) by 北京四中管理员 Sep 22 22:37:24 ubuntu dotnet[4147723]: [22:37:24 INF] Executed DbCommand (0ms) [Parameters=[@__commandId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 22:37:24 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 22:37:24 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 22:37:24 ubuntu dotnet[4147723]: WHERE d."Id" = @__commandId_0 Sep 22 22:37:24 ubuntu dotnet[4147723]: LIMIT 1 Sep 22 22:37:24 ubuntu dotnet[4147723]: [22:37:24 INF] Executed DbCommand (1ms) [Parameters=[@p1='?', @p0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 22:37:24 ubuntu dotnet[4147723]: UPDATE "DeviceCommands" SET "Status" = @p0 Sep 22 22:37:24 ubuntu dotnet[4147723]: WHERE "Id" = @p1; Sep 22 22:37:24 ubuntu dotnet[4147723]: [22:37:24 INF] Dispatched command cmd_a4aae3f9e8b440b48a83de01bb5629fc (Reconnect) to device dev_59e35e79 via SignalR nEFejlXKdxxWwK5KkEvTaw Sep 22 22:37:24 ubuntu dotnet[4147723]: [22:37:24 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 22:37:24 ubuntu dotnet[4147723]: [22:37:24 INF] Executed action ClassNotify.Server.Controllers.DeviceCommandController.SendCommand (ClassNotify.Server) in 288.0857ms Sep 22 22:37:24 ubuntu dotnet[4147723]: [22:37:24 INF] Executed endpoint 'ClassNotify.Server.Controllers.DeviceCommandController.SendCommand (ClassNotify.Server)' Sep 22 22:37:24 ubuntu dotnet[4147723]: [22:37:24 INF] Request finished HTTP/1.1 POST https://classnotify.paradise.eu.org/api/device-command/send - 200 null application/json; charset=utf-8 288.4736ms Sep 22 22:37:24 ubuntu dotnet[4147723]: [22:37:24 INF] Unregistered active device connection nEFejlXKdxxWwK5KkEvTaw for Device dev_59e35e79 Sep 22 22:37:24 ubuntu dotnet[4147723]: [22:37:24 INF] Device dev_59e35e79 disconnected for Tenant t_beijing_no4, Class cls_802 Sep 22 22:37:24 ubuntu dotnet[4147723]: [22:37:24 INF] Executed endpoint '/hubs/device' Sep 22 22:37:24 ubuntu dotnet[4147723]: [22:37:24 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/hubs/device?id=YYOa9LcFTlW3z6U1UKYKeQ - 101 null null 9298.3743ms Sep 22 22:37:26 ubuntu dotnet[4147723]: [22:37:26 INF] Request starting HTTP/1.1 POST http://classnotify.paradise.eu.org/hubs/device/negotiate?negotiateVersion=1 - null 0 Sep 22 22:37:26 ubuntu dotnet[4147723]: [22:37:26 INF] Executing endpoint '/hubs/device/negotiate' Sep 22 22:37:26 ubuntu dotnet[4147723]: [22:37:26 INF] Executed endpoint '/hubs/device/negotiate' Sep 22 22:37:26 ubuntu dotnet[4147723]: [22:37:26 INF] Request finished HTTP/1.1 POST https://classnotify.paradise.eu.org/hubs/device/negotiate?negotiateVersion=1 - 200 316 application/json 0.2802ms Sep 22 22:37:27 ubuntu dotnet[4147723]: [22:37:27 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/hubs/device?id=VlmQ8-D25AO_jMPDRClBGw - null null Sep 22 22:37:27 ubuntu dotnet[4147723]: [22:37:27 INF] Executing endpoint '/hubs/device' Sep 22 22:37:27 ubuntu dotnet[4147723]: [22:37:27 INF] Executed DbCommand (1ms) [Parameters=[@__deviceId_0='?', @__tokenHash_1='?'], CommandType='Text', CommandTimeout='30'] Sep 22 22:37:27 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 22:37:27 ubuntu dotnet[4147723]: FROM "Devices" AS d Sep 22 22:37:27 ubuntu dotnet[4147723]: WHERE d."Id" = @__deviceId_0 AND d."DeviceTokenHash" = @__tokenHash_1 AND d."IsActive" Sep 22 22:37:27 ubuntu dotnet[4147723]: LIMIT 1 Sep 22 22:37:27 ubuntu dotnet[4147723]: [22:37:27 INF] Device dev_59e35e79 connected via SignalR. ConnectionId=cZ77uyOzlNhDIsHNbstGYQ, IP=130.61.36.218 Sep 22 22:37:27 ubuntu dotnet[4147723]: [22:37:27 INF] Device dev_59e35e79 authenticated successfully. Joined group t:t_beijing_no4:c:cls_802 at cZ77uyOzlNhDIsHNbstGYQ Sep 22 22:37:27 ubuntu dotnet[4147723]: [22:37:27 INF] Executed DbCommand (0ms) [Parameters=[@__tenantId_0='?', @__classId_1='?'], CommandType='Text', CommandTimeout='30'] Sep 22 22:37:27 ubuntu dotnet[4147723]: SELECT c."TenantId", c."Id", c."CreatedAt", c."DisplayName", c."Grade", c."RoomNumber" Sep 22 22:37:27 ubuntu dotnet[4147723]: FROM "Classrooms" AS c Sep 22 22:37:27 ubuntu dotnet[4147723]: WHERE c."TenantId" = @__tenantId_0 AND c."Id" = @__classId_1 Sep 22 22:37:27 ubuntu dotnet[4147723]: LIMIT 1 Sep 22 22:37:27 ubuntu dotnet[4147723]: [22:37:27 INF] Executed DbCommand (1ms) [Parameters=[@__deviceId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 22:37:27 ubuntu dotnet[4147723]: SELECT n."Id", n."AcknowledgedAt", n."DeviceId", n."DeviceReceivedAt", n."DisplayedAt", n."FailedAt", n."FailureReason", n."NotificationId", n."Status", n."UpdatedAt", n0."Id", n0."ClassroomId", n0."CreatedAt", n0."DurationSeconds", n0."ExpiresAt", n0."Message", n0."Priority", n0."SenderName", n0."SenderUserId", n0."Shake", n0."TenantId", n0."Title", n0."Voice" Sep 22 22:37:27 ubuntu dotnet[4147723]: FROM "NotificationReceipts" AS n Sep 22 22:37:27 ubuntu dotnet[4147723]: INNER JOIN "Notifications" AS n0 ON n."NotificationId" = n0."Id" Sep 22 22:37:27 ubuntu dotnet[4147723]: WHERE n."DeviceId" = @__deviceId_0 AND n."Status" = 'Sent' Sep 22 22:37:27 ubuntu dotnet[4147723]: [22:37:27 INF] Executed DbCommand (0ms) [Parameters=[@__deviceId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 22:37:27 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 22:37:27 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 22:37:27 ubuntu dotnet[4147723]: WHERE d."DeviceId" = @__deviceId_0 AND d."Status" IN ('Pending', 'Dispatched') Sep 22 22:37:27 ubuntu dotnet[4147723]: ORDER BY d."CreatedAt" Sep 22 22:37:27 ubuntu dotnet[4147723]: [22:37:27 INF] Device dev_59e35e79 connected with 2 pending command(s) to catch up. Sep 22 22:37:27 ubuntu dotnet[4147723]: [22:37:27 INF] Executed DbCommand (0ms) [Parameters=[@__commandId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 22:37:27 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 22:37:27 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 22:37:27 ubuntu dotnet[4147723]: WHERE d."Id" = @__commandId_0 Sep 22 22:37:27 ubuntu dotnet[4147723]: LIMIT 1 Sep 22 22:37:27 ubuntu dotnet[4147723]: [22:37:27 INF] Executed DbCommand (0ms) [Parameters=[@__commandId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 22:37:27 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 22:37:27 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 22:37:27 ubuntu dotnet[4147723]: WHERE d."Id" = @__commandId_0 Sep 22 22:37:27 ubuntu dotnet[4147723]: LIMIT 1 Sep 22 22:37:27 ubuntu dotnet[4147723]: [22:37:27 INF] Executed DbCommand (1ms) [Parameters=[@__result_CommandId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 22:37:27 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 22:37:27 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 22:37:27 ubuntu dotnet[4147723]: WHERE d."Id" = @__result_CommandId_0 Sep 22 22:37:27 ubuntu dotnet[4147723]: LIMIT 1 Sep 22 22:37:27 ubuntu dotnet[4147723]: [22:37:27 INF] Executed DbCommand (1ms) [Parameters=[@p2='?', @p0='?' (DbType = DateTime), @p1='?'], CommandType='Text', CommandTimeout='30'] Sep 22 22:37:27 ubuntu dotnet[4147723]: UPDATE "DeviceCommands" SET "CompletedAt" = @p0, "Status" = @p1 Sep 22 22:37:27 ubuntu dotnet[4147723]: WHERE "Id" = @p2; Sep 22 22:37:27 ubuntu dotnet[4147723]: [22:37:27 INF] Recorded execution result for Command cmd_737ad775465148c89721a7486cf13d21 (Device dev_59e35e79): Status=Succeeded, ResultCode=0, Duration=395ms Sep 22 22:37:27 ubuntu dotnet[4147723]: [22:37:27 INF] Executed DbCommand (0ms) [Parameters=[@__result_CommandId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 22:37:27 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 22:37:27 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 22:37:27 ubuntu dotnet[4147723]: WHERE d."Id" = @__result_CommandId_0 Sep 22 22:37:27 ubuntu dotnet[4147723]: LIMIT 1 Sep 22 22:37:27 ubuntu dotnet[4147723]: [22:37:27 INF] Executed DbCommand (2ms) [Parameters=[@p6='?', @p0='?' (DbType = DateTime), @p1='?' (DbType = Int64), @p2='?' (DbType = Int32), @p3='?', @p4='?' (DbType = DateTime), @p5='?'], CommandType='Text', CommandTimeout='30'] Sep 22 22:37:27 ubuntu dotnet[4147723]: UPDATE "DeviceCommands" SET "CompletedAt" = @p0, "DurationMs" = @p1, "ResultCode" = @p2, "ResultMessage" = @p3, "StartedAt" = @p4, "Status" = @p5 Sep 22 22:37:27 ubuntu dotnet[4147723]: WHERE "Id" = @p6; Sep 22 22:37:27 ubuntu dotnet[4147723]: [22:37:27 INF] Recorded execution result for Command cmd_a4aae3f9e8b440b48a83de01bb5629fc (Device dev_59e35e79): Status=Succeeded, ResultCode=0, Duration=2730ms Sep 22 22:37:27 ubuntu dotnet[4147723]: [22:37:27 INF] Executed DbCommand (1ms) [Parameters=[@__result_CommandId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 22:37:27 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 22:37:27 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 22:37:27 ubuntu dotnet[4147723]: WHERE d."Id" = @__result_CommandId_0 Sep 22 22:37:27 ubuntu dotnet[4147723]: LIMIT 1 Sep 22 22:37:27 ubuntu dotnet[4147723]: [22:37:27 INF] Command cmd_a4aae3f9e8b440b48a83de01bb5629fc already completed with terminal status 'Succeeded'. Ignoring duplicate result report. Sep 22 22:37:32 ubuntu dotnet[4147723]: [22:37:32 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 22:37: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 22:37:32 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 22:37:32 ubuntu dotnet[4147723]: WHERE d."Status" IN ('Pending', 'Dispatched')