Sep 23 01:15:09 ubuntu dotnet[4147723]: [01:15:09 INF] Executed DbCommand (1ms) [Parameters=[@__deviceId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 23 01:15: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 23 01:15:09 ubuntu dotnet[4147723]: FROM "Devices" AS d Sep 23 01:15:09 ubuntu dotnet[4147723]: WHERE d."Id" = @__deviceId_0 Sep 23 01:15:09 ubuntu dotnet[4147723]: LIMIT 1 Sep 23 01:15:09 ubuntu dotnet[4147723]: [01:15:09 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 23 01:15:09 ubuntu dotnet[4147723]: INSERT INTO "DeviceCommands" ("Id", "CommandType", "CompletedAt", "CreatedAt", "CreatedBy", "DeviceId", "DurationMs", "ExpiresAt", "Parameters", "ResultCode", "ResultMessage", "StartedAt", "Status", "TenantId") Sep 23 01:15:09 ubuntu dotnet[4147723]: VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13); Sep 23 01:15:09 ubuntu dotnet[4147723]: [01:15:09 INF] Created remote command cmd_121f313d337c44578e38080537f74a19 (RestartClient) for Device dev_59e35e79 (Tenant t_beijing_no4, TTL 2m) by 北京四中管理员 Sep 23 01:15:09 ubuntu dotnet[4147723]: [01:15:09 INF] Executed DbCommand (0ms) [Parameters=[@__commandId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 23 01:15:09 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 23 01:15:09 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 23 01:15:09 ubuntu dotnet[4147723]: WHERE d."Id" = @__commandId_0 Sep 23 01:15:09 ubuntu dotnet[4147723]: LIMIT 1 Sep 23 01:15:09 ubuntu dotnet[4147723]: [01:15:09 INF] Executed DbCommand (1ms) [Parameters=[@p1='?', @p0='?'], CommandType='Text', CommandTimeout='30'] Sep 23 01:15:09 ubuntu dotnet[4147723]: UPDATE "DeviceCommands" SET "Status" = @p0 Sep 23 01:15:09 ubuntu dotnet[4147723]: WHERE "Id" = @p1; Sep 23 01:15:09 ubuntu dotnet[4147723]: [01:15:09 INF] Dispatched command cmd_121f313d337c44578e38080537f74a19 (RestartClient) to device dev_59e35e79 via SignalR 8uHn3OyUcu0AqaZvtwuWGg Sep 23 01:15:09 ubuntu dotnet[4147723]: [01:15:09 INF] Executing OkObjectResult, writing value of type '<>f__AnonymousType4`4[[System.Boolean, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeytoken=[REDACTED]],[ClassNotify.Shared.Models.DeviceCommandDto, ClassNotify.Shared, Version=1.0.0.0, Culture=neutral, PublicKeytoken=[REDACTED]],[System.Boolean, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeytoken=[REDACTED]],[System.String, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeytoken=[REDACTED]]]'. Sep 23 01:15:09 ubuntu dotnet[4147723]: [01:15:09 INF] Executed action ClassNotify.Server.Controllers.DeviceCommandController.SendCommand (ClassNotify.Server) in 317.2824ms Sep 23 01:15:09 ubuntu dotnet[4147723]: [01:15:09 INF] Executed endpoint 'ClassNotify.Server.Controllers.DeviceCommandController.SendCommand (ClassNotify.Server)' Sep 23 01:15:09 ubuntu dotnet[4147723]: [01:15:09 INF] Request finished HTTP/1.1 POST https://classnotify.paradise.eu.org/api/device-command/send - 200 null application/json; charset=utf-8 317.6824ms Sep 23 01:15:12 ubuntu dotnet[4147723]: [01:15:12 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/api/device-command/cmd_121f313d337c44578e38080537f74a19 - null null Sep 23 01:15:12 ubuntu dotnet[4147723]: [01:15:12 INF] Executing endpoint 'ClassNotify.Server.Controllers.DeviceCommandController.GetCommand (ClassNotify.Server)' Sep 23 01:15:12 ubuntu dotnet[4147723]: [01:15:12 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 23 01:15:12 ubuntu dotnet[4147723]: [01:15:12 INF] Executed DbCommand (1ms) [Parameters=[@__commandId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 23 01:15: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 23 01:15:12 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 23 01:15:12 ubuntu dotnet[4147723]: WHERE d."Id" = @__commandId_0 Sep 23 01:15:12 ubuntu dotnet[4147723]: LIMIT 1 Sep 23 01:15:12 ubuntu dotnet[4147723]: [01:15:12 INF] Executing OkObjectResult, writing value of type 'ClassNotify.Shared.Models.DeviceCommandDto'. Sep 23 01:15:12 ubuntu dotnet[4147723]: [01:15:12 INF] Executed action ClassNotify.Server.Controllers.DeviceCommandController.GetCommand (ClassNotify.Server) in 1.4304ms Sep 23 01:15:12 ubuntu dotnet[4147723]: [01:15:12 INF] Executed endpoint 'ClassNotify.Server.Controllers.DeviceCommandController.GetCommand (ClassNotify.Server)' Sep 23 01:15:12 ubuntu dotnet[4147723]: [01:15:12 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/api/device-command/cmd_121f313d337c44578e38080537f74a19 - 200 null application/json; charset=utf-8 1.8567ms Sep 23 01:15:14 ubuntu dotnet[4147723]: [01:15:14 INF] Request starting HTTP/1.1 POST http://classnotify.paradise.eu.org/api/device-command/send - application/json 71 Sep 23 01:15:14 ubuntu dotnet[4147723]: [01:15:14 INF] Executing endpoint 'ClassNotify.Server.Controllers.DeviceCommandController.SendCommand (ClassNotify.Server)' Sep 23 01:15:14 ubuntu dotnet[4147723]: [01:15:14 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 23 01:15:15 ubuntu dotnet[4147723]: [01:15:15 INF] Executed DbCommand (1ms) [Parameters=[@__deviceId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 23 01:15: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 23 01:15:15 ubuntu dotnet[4147723]: FROM "Devices" AS d Sep 23 01:15:15 ubuntu dotnet[4147723]: WHERE d."Id" = @__deviceId_0 Sep 23 01:15:15 ubuntu dotnet[4147723]: LIMIT 1 Sep 23 01:15:15 ubuntu dotnet[4147723]: [01:15:15 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 23 01:15:15 ubuntu dotnet[4147723]: INSERT INTO "DeviceCommands" ("Id", "CommandType", "CompletedAt", "CreatedAt", "CreatedBy", "DeviceId", "DurationMs", "ExpiresAt", "Parameters", "ResultCode", "ResultMessage", "StartedAt", "Status", "TenantId") Sep 23 01:15:15 ubuntu dotnet[4147723]: VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13); Sep 23 01:15:15 ubuntu dotnet[4147723]: [01:15:15 INF] Created remote command cmd_600c096d67034f5bb64d035804822b0a (Reconnect) for Device dev_59e35e79 (Tenant t_beijing_no4, TTL 2m) by 北京四中管理员 Sep 23 01:15:15 ubuntu dotnet[4147723]: [01:15:15 INF] Executed DbCommand (0ms) [Parameters=[@__commandId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 23 01:15: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 23 01:15:15 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 23 01:15:15 ubuntu dotnet[4147723]: WHERE d."Id" = @__commandId_0 Sep 23 01:15:15 ubuntu dotnet[4147723]: LIMIT 1 Sep 23 01:15:15 ubuntu dotnet[4147723]: [01:15:15 INF] Executed DbCommand (1ms) [Parameters=[@p1='?', @p0='?'], CommandType='Text', CommandTimeout='30'] Sep 23 01:15:15 ubuntu dotnet[4147723]: UPDATE "DeviceCommands" SET "Status" = @p0 Sep 23 01:15:15 ubuntu dotnet[4147723]: WHERE "Id" = @p1; Sep 23 01:15:15 ubuntu dotnet[4147723]: [01:15:15 INF] Dispatched command cmd_600c096d67034f5bb64d035804822b0a (Reconnect) to device dev_59e35e79 via SignalR 8uHn3OyUcu0AqaZvtwuWGg Sep 23 01:15:15 ubuntu dotnet[4147723]: [01:15:15 INF] Executing OkObjectResult, writing value of type '<>f__AnonymousType4`4[[System.Boolean, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeytoken=[REDACTED]],[ClassNotify.Shared.Models.DeviceCommandDto, ClassNotify.Shared, Version=1.0.0.0, Culture=neutral, PublicKeytoken=[REDACTED]],[System.Boolean, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeytoken=[REDACTED]],[System.String, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeytoken=[REDACTED]]]'. Sep 23 01:15:15 ubuntu dotnet[4147723]: [01:15:15 INF] Executed action ClassNotify.Server.Controllers.DeviceCommandController.SendCommand (ClassNotify.Server) in 236.8685ms Sep 23 01:15:15 ubuntu dotnet[4147723]: [01:15:15 INF] Executed endpoint 'ClassNotify.Server.Controllers.DeviceCommandController.SendCommand (ClassNotify.Server)' Sep 23 01:15:15 ubuntu dotnet[4147723]: [01:15:15 INF] Request finished HTTP/1.1 POST https://classnotify.paradise.eu.org/api/device-command/send - 200 null application/json; charset=utf-8 237.2847ms Sep 23 01:15:16 ubuntu dotnet[4147723]: [01:15:16 INF] Request starting HTTP/1.1 POST http://classnotify.paradise.eu.org/hubs/device/negotiate?negotiateVersion=1 - null 0 Sep 23 01:15:16 ubuntu dotnet[4147723]: [01:15:16 INF] Executing endpoint '/hubs/device/negotiate' Sep 23 01:15:16 ubuntu dotnet[4147723]: [01:15:16 INF] Executed endpoint '/hubs/device/negotiate' Sep 23 01:15:16 ubuntu dotnet[4147723]: [01:15:16 INF] Request finished HTTP/1.1 POST https://classnotify.paradise.eu.org/hubs/device/negotiate?negotiateVersion=1 - 200 316 application/json 0.3097ms Sep 23 01:15:17 ubuntu dotnet[4147723]: [01:15:17 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/hubs/device?id=yxiHxICpp4RIZWCxJ4uzGw - null null Sep 23 01:15:17 ubuntu dotnet[4147723]: [01:15:17 INF] Executing endpoint '/hubs/device' Sep 23 01:15:17 ubuntu dotnet[4147723]: [01:15:17 INF] Executed DbCommand (1ms) [Parameters=[@__deviceId_0='?', @__tokenHash_1='?'], CommandType='Text', CommandTimeout='30'] Sep 23 01:15:17 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 23 01:15:17 ubuntu dotnet[4147723]: FROM "Devices" AS d Sep 23 01:15:17 ubuntu dotnet[4147723]: WHERE d."Id" = @__deviceId_0 AND d."DeviceTokenHash" = @__tokenHash_1 AND d."IsActive" Sep 23 01:15:17 ubuntu dotnet[4147723]: LIMIT 1 Sep 23 01:15:17 ubuntu dotnet[4147723]: [01:15:17 INF] Replacing previous ConnectionId 8uHn3OyUcu0AqaZvtwuWGg with RPX-7SS0Gl4ZCgHy-ryrlQ for Device dev_59e35e79 Sep 23 01:15:17 ubuntu dotnet[4147723]: [01:15:17 INF] Device dev_59e35e79 connected via SignalR. ConnectionId=RPX-7SS0Gl4ZCgHy-ryrlQ, IP=130.61.36.218 Sep 23 01:15:17 ubuntu dotnet[4147723]: [01:15:17 INF] Removed replaced connection 8uHn3OyUcu0AqaZvtwuWGg from class group t:t_beijing_no4:c:cls_802; current connection is RPX-7SS0Gl4ZCgHy-ryrlQ Sep 23 01:15:17 ubuntu dotnet[4147723]: [01:15:17 INF] Device dev_59e35e79 authenticated successfully. Joined group t:t_beijing_no4:c:cls_802 at RPX-7SS0Gl4ZCgHy-ryrlQ Sep 23 01:15:17 ubuntu dotnet[4147723]: [01:15:17 INF] Executed DbCommand (0ms) [Parameters=[@__tenantId_0='?', @__classId_1='?'], CommandType='Text', CommandTimeout='30'] Sep 23 01:15:17 ubuntu dotnet[4147723]: SELECT c."TenantId", c."Id", c."CreatedAt", c."DisplayName", c."Grade", c."RoomNumber" Sep 23 01:15:17 ubuntu dotnet[4147723]: FROM "Classrooms" AS c Sep 23 01:15:17 ubuntu dotnet[4147723]: WHERE c."TenantId" = @__tenantId_0 AND c."Id" = @__classId_1 Sep 23 01:15:17 ubuntu dotnet[4147723]: LIMIT 1 Sep 23 01:15:17 ubuntu dotnet[4147723]: [01:15:17 INF] Executed DbCommand (1ms) [Parameters=[@__deviceId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 23 01:15:17 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 23 01:15:17 ubuntu dotnet[4147723]: FROM "NotificationReceipts" AS n Sep 23 01:15:17 ubuntu dotnet[4147723]: INNER JOIN "Notifications" AS n0 ON n."NotificationId" = n0."Id" Sep 23 01:15:17 ubuntu dotnet[4147723]: WHERE n."DeviceId" = @__deviceId_0 AND n."Status" = 'Sent' Sep 23 01:15:17 ubuntu dotnet[4147723]: [01:15:17 INF] Executed DbCommand (1ms) [Parameters=[@__deviceId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 23 01:15: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 23 01:15:17 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 23 01:15:17 ubuntu dotnet[4147723]: WHERE d."DeviceId" = @__deviceId_0 AND d."Status" IN ('Pending', 'Dispatched') Sep 23 01:15:17 ubuntu dotnet[4147723]: ORDER BY d."CreatedAt" Sep 23 01:15:17 ubuntu dotnet[4147723]: [01:15:17 INF] Device dev_59e35e79 connected with 2 pending command(s) to catch up. Sep 23 01:15:17 ubuntu dotnet[4147723]: [01:15:17 INF] Executed DbCommand (0ms) [Parameters=[@__commandId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 23 01:15: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 23 01:15:17 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 23 01:15:17 ubuntu dotnet[4147723]: WHERE d."Id" = @__commandId_0 Sep 23 01:15:17 ubuntu dotnet[4147723]: LIMIT 1 Sep 23 01:15:17 ubuntu dotnet[4147723]: [01:15:17 INF] Executed DbCommand (0ms) [Parameters=[@__commandId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 23 01:15: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 23 01:15:17 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 23 01:15:17 ubuntu dotnet[4147723]: WHERE d."Id" = @__commandId_0 Sep 23 01:15:17 ubuntu dotnet[4147723]: LIMIT 1 Sep 23 01:15:18 ubuntu dotnet[4147723]: [01:15:18 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 01:15:18 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 23 01:15:18 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 23 01:15:18 ubuntu dotnet[4147723]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 23 01:15:18 ubuntu dotnet[4147723]: [01:15:18 INF] Executed DbCommand (1ms) [Parameters=[@__result_CommandId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 23 01:15:18 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 23 01:15:18 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 23 01:15:18 ubuntu dotnet[4147723]: WHERE d."Id" = @__result_CommandId_0 Sep 23 01:15:18 ubuntu dotnet[4147723]: LIMIT 1 Sep 23 01:15:18 ubuntu dotnet[4147723]: [01:15:18 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 23 01:15:18 ubuntu dotnet[4147723]: UPDATE "DeviceCommands" SET "CompletedAt" = @p0, "DurationMs" = @p1, "ResultCode" = @p2, "ResultMessage" = @p3, "StartedAt" = @p4, "Status" = @p5 Sep 23 01:15:18 ubuntu dotnet[4147723]: WHERE "Id" = @p6; Sep 23 01:15:18 ubuntu dotnet[4147723]: [01:15:18 INF] Recorded execution result for Command cmd_121f313d337c44578e38080537f74a19 (Device dev_59e35e79): Status=Succeeded, ResultCode=0, Duration=376ms Sep 23 01:15:18 ubuntu dotnet[4147723]: [01:15:18 INF] Unregistered active device connection RPX-7SS0Gl4ZCgHy-ryrlQ for Device dev_59e35e79 Sep 23 01:15:18 ubuntu dotnet[4147723]: [01:15:18 INF] Device dev_59e35e79 disconnected for Tenant t_beijing_no4, Class cls_802 Sep 23 01:15:18 ubuntu dotnet[4147723]: [01:15:18 INF] Executed endpoint '/hubs/device' Sep 23 01:15:18 ubuntu dotnet[4147723]: [01:15:18 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/hubs/device?id=yxiHxICpp4RIZWCxJ4uzGw - 101 null null 717.2636ms Sep 23 01:15:19 ubuntu dotnet[4147723]: [01:15:19 INF] Request starting HTTP/1.1 POST http://classnotify.paradise.eu.org/hubs/device/negotiate?negotiateVersion=1 - null 0 Sep 23 01:15:19 ubuntu dotnet[4147723]: [01:15:19 INF] Executing endpoint '/hubs/device/negotiate' Sep 23 01:15:19 ubuntu dotnet[4147723]: [01:15:19 INF] Executed endpoint '/hubs/device/negotiate' Sep 23 01:15:19 ubuntu dotnet[4147723]: [01:15:19 INF] Request finished HTTP/1.1 POST https://classnotify.paradise.eu.org/hubs/device/negotiate?negotiateVersion=1 - 200 316 application/json 0.3142ms Sep 23 01:15:20 ubuntu dotnet[4147723]: [01:15:20 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/hubs/device?id=a7vHYQLkBvXWlZyfeYwf9w - null null Sep 23 01:15:20 ubuntu dotnet[4147723]: [01:15:20 INF] Executing endpoint '/hubs/device' Sep 23 01:15:20 ubuntu dotnet[4147723]: [01:15:20 INF] Executed DbCommand (1ms) [Parameters=[@__deviceId_0='?', @__tokenHash_1='?'], CommandType='Text', CommandTimeout='30'] Sep 23 01:15:20 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 23 01:15:20 ubuntu dotnet[4147723]: FROM "Devices" AS d Sep 23 01:15:20 ubuntu dotnet[4147723]: WHERE d."Id" = @__deviceId_0 AND d."DeviceTokenHash" = @__tokenHash_1 AND d."IsActive" Sep 23 01:15:20 ubuntu dotnet[4147723]: LIMIT 1 Sep 23 01:15:20 ubuntu dotnet[4147723]: [01:15:20 INF] Device dev_59e35e79 connected via SignalR. ConnectionId=07ohQm1Qb1gtWVXCQFBPZg, IP=130.61.36.218 Sep 23 01:15:20 ubuntu dotnet[4147723]: [01:15:20 INF] Device dev_59e35e79 authenticated successfully. Joined group t:t_beijing_no4:c:cls_802 at 07ohQm1Qb1gtWVXCQFBPZg Sep 23 01:15:20 ubuntu dotnet[4147723]: [01:15:20 INF] Executed DbCommand (0ms) [Parameters=[@__tenantId_0='?', @__classId_1='?'], CommandType='Text', CommandTimeout='30'] Sep 23 01:15:20 ubuntu dotnet[4147723]: SELECT c."TenantId", c."Id", c."CreatedAt", c."DisplayName", c."Grade", c."RoomNumber" Sep 23 01:15:20 ubuntu dotnet[4147723]: FROM "Classrooms" AS c Sep 23 01:15:20 ubuntu dotnet[4147723]: WHERE c."TenantId" = @__tenantId_0 AND c."Id" = @__classId_1 Sep 23 01:15:20 ubuntu dotnet[4147723]: LIMIT 1 Sep 23 01:15:20 ubuntu dotnet[4147723]: [01:15:20 INF] Executed DbCommand (1ms) [Parameters=[@__deviceId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 23 01:15:20 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 23 01:15:20 ubuntu dotnet[4147723]: FROM "NotificationReceipts" AS n Sep 23 01:15:20 ubuntu dotnet[4147723]: INNER JOIN "Notifications" AS n0 ON n."NotificationId" = n0."Id" Sep 23 01:15:20 ubuntu dotnet[4147723]: WHERE n."DeviceId" = @__deviceId_0 AND n."Status" = 'Sent' Sep 23 01:15:20 ubuntu dotnet[4147723]: [01:15:20 INF] Executed DbCommand (0ms) [Parameters=[@__deviceId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 23 01:15:20 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 23 01:15:20 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 23 01:15:20 ubuntu dotnet[4147723]: WHERE d."DeviceId" = @__deviceId_0 AND d."Status" IN ('Pending', 'Dispatched') Sep 23 01:15:20 ubuntu dotnet[4147723]: ORDER BY d."CreatedAt" Sep 23 01:15:20 ubuntu dotnet[4147723]: [01:15:20 INF] Device dev_59e35e79 connected with 1 pending command(s) to catch up. Sep 23 01:15:20 ubuntu dotnet[4147723]: [01:15:20 INF] Executed DbCommand (0ms) [Parameters=[@__commandId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 23 01:15:20 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 23 01:15:20 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 23 01:15:20 ubuntu dotnet[4147723]: WHERE d."Id" = @__commandId_0 Sep 23 01:15:20 ubuntu dotnet[4147723]: LIMIT 1 Sep 23 01:15:21 ubuntu dotnet[4147723]: [01:15:21 INF] Executed DbCommand (1ms) [Parameters=[@__result_CommandId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 23 01:15:21 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 23 01:15:21 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 23 01:15:21 ubuntu dotnet[4147723]: WHERE d."Id" = @__result_CommandId_0 Sep 23 01:15:21 ubuntu dotnet[4147723]: LIMIT 1 Sep 23 01:15:21 ubuntu dotnet[4147723]: [01:15:21 INF] Executed DbCommand (4ms) [Parameters=[@p6='?', @p0='?' (DbType = DateTime), @p1='?' (DbType = Int64), @p2='?' (DbType = Int32), @p3='?', @p4='?' (DbType = DateTime), @p5='?'], CommandType='Text', CommandTimeout='30'] Sep 23 01:15:21 ubuntu dotnet[4147723]: UPDATE "DeviceCommands" SET "CompletedAt" = @p0, "DurationMs" = @p1, "ResultCode" = @p2, "ResultMessage" = @p3, "StartedAt" = @p4, "Status" = @p5 Sep 23 01:15:21 ubuntu dotnet[4147723]: WHERE "Id" = @p6; Sep 23 01:15:21 ubuntu dotnet[4147723]: [01:15:21 INF] Recorded execution result for Command cmd_600c096d67034f5bb64d035804822b0a (Device dev_59e35e79): Status=Succeeded, ResultCode=0, Duration=2661ms Sep 23 01:15:21 ubuntu dotnet[4147723]: [01:15:21 INF] Executed DbCommand (0ms) [Parameters=[@__result_CommandId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 23 01:15:21 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 23 01:15:21 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 23 01:15:21 ubuntu dotnet[4147723]: WHERE d."Id" = @__result_CommandId_0 Sep 23 01:15:21 ubuntu dotnet[4147723]: LIMIT 1 Sep 23 01:15:21 ubuntu dotnet[4147723]: [01:15:21 INF] Command cmd_600c096d67034f5bb64d035804822b0a already completed with terminal status 'Succeeded'. Ignoring duplicate result report. Sep 23 01:15:26 ubuntu dotnet[4147723]: [01:15:26 INF] Executed DbCommand (1ms) [Parameters=[@__p_0='?'], CommandType='Text', CommandTimeout='30'] Sep 23 01:15:26 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 23 01:15:26 ubuntu dotnet[4147723]: FROM "Devices" AS d Sep 23 01:15:26 ubuntu dotnet[4147723]: WHERE d."Id" = @__p_0 Sep 23 01:15:26 ubuntu dotnet[4147723]: LIMIT 1 Sep 23 01:15:26 ubuntu dotnet[4147723]: [01:15:26 INF] Executed DbCommand (2ms) [Parameters=[@p1='?', @p0='?' (DbType = DateTime)], CommandType='Text', CommandTimeout='30'] Sep 23 01:15:26 ubuntu dotnet[4147723]: UPDATE "Devices" SET "LastHeartbeatAt" = @p0 Sep 23 01:15:26 ubuntu dotnet[4147723]: WHERE "Id" = @p1; Sep 23 01:15:26 ubuntu dotnet[4147723]: [01:15:26 INF] Stale connection 8uHn3OyUcu0AqaZvtwuWGg disconnected for Device dev_59e35e79 (Tenant t_beijing_no4, Class cls_802); device is still active on newer connection. Skipping Offline status broadcast. Sep 23 01:15:27 ubuntu dotnet[4147723]: [01:15:27 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/api/health - null null Sep 23 01:15:27 ubuntu dotnet[4147723]: [01:15:27 INF] Executing endpoint 'HTTP: GET /api/health' Sep 23 01:15:27 ubuntu dotnet[4147723]: [01:15:27 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 01:15:27 ubuntu dotnet[4147723]: SELECT 1 Sep 23 01:15:27 ubuntu dotnet[4147723]: [01:15:27 INF] Setting HTTP status code 200. Sep 23 01:15:27 ubuntu dotnet[4147723]: [01:15:27 INF] Writing value of type '<>f__AnonymousType28`6' as Json. Sep 23 01:15:27 ubuntu dotnet[4147723]: [01:15:27 INF] Executed endpoint 'HTTP: GET /api/health' Sep 23 01:15:27 ubuntu dotnet[4147723]: [01:15:27 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/api/health - 200 null application/json; charset=utf-8 12.7035ms Sep 23 01:15:28 ubuntu dotnet[4147723]: [01:15:28 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 01:15:28 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 23 01:15:28 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 23 01:15:28 ubuntu dotnet[4147723]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 23 01:15:31 ubuntu dotnet[4147723]: [01:15:31 INF] Connection id "0HNOOC57U1JBK", Request id "0HNOOC57U1JBK:00000001": the application aborted the connection. Sep 23 01:15:31 ubuntu dotnet[4147723]: [01:15:31 INF] Executed endpoint '/hubs/device' Sep 23 01:15:31 ubuntu dotnet[4147723]: [01:15:31 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/hubs/device?id=vrsxT8FjlIxEJurylgQfnQ - 101 null null 58509.6678ms Sep 23 01:15:38 ubuntu dotnet[4147723]: [01:15:38 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 01:15:38 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 23 01:15:38 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 23 01:15:38 ubuntu dotnet[4147723]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 23 01:15:48 ubuntu dotnet[4147723]: [01:15:48 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 01:15:48 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 23 01:15:48 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 23 01:15:48 ubuntu dotnet[4147723]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 23 01:15:56 ubuntu dotnet[4147723]: [01:15:56 INF] Executed DbCommand (1ms) [Parameters=[@__p_0='?'], CommandType='Text', CommandTimeout='30'] Sep 23 01:15:56 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 23 01:15:56 ubuntu dotnet[4147723]: FROM "Devices" AS d Sep 23 01:15:56 ubuntu dotnet[4147723]: WHERE d."Id" = @__p_0 Sep 23 01:15:56 ubuntu dotnet[4147723]: LIMIT 1 Sep 23 01:15:56 ubuntu dotnet[4147723]: [01:15:56 INF] Executed DbCommand (1ms) [Parameters=[@p1='?', @p0='?' (DbType = DateTime)], CommandType='Text', CommandTimeout='30'] Sep 23 01:15:56 ubuntu dotnet[4147723]: UPDATE "Devices" SET "LastHeartbeatAt" = @p0 Sep 23 01:15:56 ubuntu dotnet[4147723]: WHERE "Id" = @p1; Sep 23 01:15:57 ubuntu dotnet[4147723]: [01:15:57 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/api/health - null null Sep 23 01:15:57 ubuntu dotnet[4147723]: [01:15:57 INF] Executing endpoint 'HTTP: GET /api/health' Sep 23 01:15:57 ubuntu dotnet[4147723]: [01:15:57 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 01:15:57 ubuntu dotnet[4147723]: SELECT 1 Sep 23 01:15:57 ubuntu dotnet[4147723]: [01:15:57 INF] Setting HTTP status code 200. Sep 23 01:15:57 ubuntu dotnet[4147723]: [01:15:57 INF] Writing value of type '<>f__AnonymousType28`6' as Json. Sep 23 01:15:57 ubuntu dotnet[4147723]: [01:15:57 INF] Executed endpoint 'HTTP: GET /api/health' Sep 23 01:15:57 ubuntu dotnet[4147723]: [01:15:57 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/api/health - 200 null application/json; charset=utf-8 12.6194ms Sep 23 01:15:58 ubuntu dotnet[4147723]: [01:15:58 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 01:15:58 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 23 01:15:58 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 23 01:15:58 ubuntu dotnet[4147723]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 23 01:16:08 ubuntu dotnet[4147723]: [01:16:08 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 01:16:08 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 23 01:16:08 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 23 01:16:08 ubuntu dotnet[4147723]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 23 01:16:18 ubuntu dotnet[4147723]: [01:16:18 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 01:16:18 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 23 01:16:18 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 23 01:16:18 ubuntu dotnet[4147723]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 23 01:16:27 ubuntu dotnet[4147723]: [01:16:27 INF] Executed DbCommand (1ms) [Parameters=[@__p_0='?'], CommandType='Text', CommandTimeout='30'] Sep 23 01:16: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 23 01:16:27 ubuntu dotnet[4147723]: FROM "Devices" AS d Sep 23 01:16:27 ubuntu dotnet[4147723]: WHERE d."Id" = @__p_0 Sep 23 01:16:27 ubuntu dotnet[4147723]: LIMIT 1 Sep 23 01:16:27 ubuntu dotnet[4147723]: [01:16:27 INF] Executed DbCommand (1ms) [Parameters=[@p1='?', @p0='?' (DbType = DateTime)], CommandType='Text', CommandTimeout='30'] Sep 23 01:16:27 ubuntu dotnet[4147723]: UPDATE "Devices" SET "LastHeartbeatAt" = @p0 Sep 23 01:16:27 ubuntu dotnet[4147723]: WHERE "Id" = @p1; Sep 23 01:16:28 ubuntu dotnet[4147723]: [01:16:28 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 01:16:28 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 23 01:16:28 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 23 01:16:28 ubuntu dotnet[4147723]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 23 01:16:28 ubuntu dotnet[4147723]: [01:16:28 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/api/health - null null Sep 23 01:16:28 ubuntu dotnet[4147723]: [01:16:28 INF] Executing endpoint 'HTTP: GET /api/health' Sep 23 01:16:28 ubuntu dotnet[4147723]: [01:16:28 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 01:16:28 ubuntu dotnet[4147723]: SELECT 1 Sep 23 01:16:28 ubuntu dotnet[4147723]: [01:16:28 INF] Setting HTTP status code 200. Sep 23 01:16:28 ubuntu dotnet[4147723]: [01:16:28 INF] Writing value of type '<>f__AnonymousType28`6' as Json. Sep 23 01:16:28 ubuntu dotnet[4147723]: [01:16:28 INF] Executed endpoint 'HTTP: GET /api/health' Sep 23 01:16:28 ubuntu dotnet[4147723]: [01:16:28 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/api/health - 200 null application/json; charset=utf-8 12.8924ms Sep 23 01:16:38 ubuntu dotnet[4147723]: [01:16:38 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 01:16:38 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 23 01:16:38 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 23 01:16:38 ubuntu dotnet[4147723]: WHERE d."Status" IN ('Pending', 'Dispatched')