Sep 22 13:27:57 ubuntu dotnet[4147723]: [13:27:57 INF] Route matched with {action = "GetNotificationHistory", controller = "Notification"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetNotificationHistory(System.String, Int32) on controller ClassNotify.Server.Controllers.NotificationController (ClassNotify.Server). Sep 22 13:27:57 ubuntu dotnet[4147723]: [13:27:57 INF] Executed DbCommand (1ms) [Parameters=[@__tenantId_0='?', @__classId_1='?', @__p_2='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30'] Sep 22 13:27:57 ubuntu dotnet[4147723]: SELECT t."Id", t."ClassroomId", t."CreatedAt", t."DurationSeconds", t."ExpiresAt", t."Message", t."Priority", t."SenderName", t."SenderUserId", t."Shake", t."TenantId", t."Title", t."Voice", n0."Id", n0."AcknowledgedAt", n0."DeviceId", n0."DeviceReceivedAt", n0."DisplayedAt", n0."FailedAt", n0."FailureReason", n0."NotificationId", n0."Status", n0."UpdatedAt" Sep 22 13:27:57 ubuntu dotnet[4147723]: FROM ( Sep 22 13:27:57 ubuntu dotnet[4147723]:     SELECT n."Id", n."ClassroomId", n."CreatedAt", n."DurationSeconds", n."ExpiresAt", n."Message", n."Priority", n."SenderName", n."SenderUserId", n."Shake", n."TenantId", n."Title", n."Voice" Sep 22 13:27:57 ubuntu dotnet[4147723]:     FROM "Notifications" AS n Sep 22 13:27:57 ubuntu dotnet[4147723]:     WHERE n."TenantId" = @__tenantId_0 AND n."ClassroomId" = @__classId_1 Sep 22 13:27:57 ubuntu dotnet[4147723]:     ORDER BY n."CreatedAt" DESC Sep 22 13:27:57 ubuntu dotnet[4147723]:     LIMIT @__p_2 Sep 22 13:27:57 ubuntu dotnet[4147723]: ) AS t Sep 22 13:27:57 ubuntu dotnet[4147723]: LEFT JOIN "NotificationReceipts" AS n0 ON t."Id" = n0."NotificationId" Sep 22 13:27:57 ubuntu dotnet[4147723]: ORDER BY t."CreatedAt" DESC, t."Id" Sep 22 13:27:57 ubuntu dotnet[4147723]: [13:27:57 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 13:27:57 ubuntu dotnet[4147723]: SELECT c."TenantId", c."Id", c."CreatedAt", c."DisplayName", c."Grade", c."RoomNumber" Sep 22 13:27:57 ubuntu dotnet[4147723]: FROM "Classrooms" AS c Sep 22 13:27:57 ubuntu dotnet[4147723]: [13:27:57 INF] Executing OkObjectResult, writing value of type 'System.Collections.Generic.List`1[[ClassNotify.Shared.Models.NotificationRecordDto, ClassNotify.Shared, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. Sep 22 13:27:57 ubuntu dotnet[4147723]: [13:27:57 INF] Executed action ClassNotify.Server.Controllers.NotificationController.GetNotificationHistory (ClassNotify.Server) in 3.1129ms Sep 22 13:27:57 ubuntu dotnet[4147723]: [13:27:57 INF] Executed endpoint 'ClassNotify.Server.Controllers.NotificationController.GetNotificationHistory (ClassNotify.Server)' Sep 22 13:27:57 ubuntu dotnet[4147723]: [13:27:57 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/api/notification/history?classId=cls_802&limit=10 - 200 null application/json; charset=utf-8 3.5529ms Sep 22 13:27:58 ubuntu dotnet[4147723]: [13:27:58 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/api/notification/history?classId=cls_802&limit=10 - null null Sep 22 13:27:58 ubuntu dotnet[4147723]: [13:27:58 INF] Executing endpoint 'ClassNotify.Server.Controllers.NotificationController.GetNotificationHistory (ClassNotify.Server)' Sep 22 13:27:58 ubuntu dotnet[4147723]: [13:27:58 INF] Route matched with {action = "GetNotificationHistory", controller = "Notification"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetNotificationHistory(System.String, Int32) on controller ClassNotify.Server.Controllers.NotificationController (ClassNotify.Server). Sep 22 13:27:58 ubuntu dotnet[4147723]: [13:27:58 INF] Executed DbCommand (1ms) [Parameters=[@__tenantId_0='?', @__classId_1='?', @__p_2='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30'] Sep 22 13:27:58 ubuntu dotnet[4147723]: SELECT t."Id", t."ClassroomId", t."CreatedAt", t."DurationSeconds", t."ExpiresAt", t."Message", t."Priority", t."SenderName", t."SenderUserId", t."Shake", t."TenantId", t."Title", t."Voice", n0."Id", n0."AcknowledgedAt", n0."DeviceId", n0."DeviceReceivedAt", n0."DisplayedAt", n0."FailedAt", n0."FailureReason", n0."NotificationId", n0."Status", n0."UpdatedAt" Sep 22 13:27:58 ubuntu dotnet[4147723]: FROM ( Sep 22 13:27:58 ubuntu dotnet[4147723]:     SELECT n."Id", n."ClassroomId", n."CreatedAt", n."DurationSeconds", n."ExpiresAt", n."Message", n."Priority", n."SenderName", n."SenderUserId", n."Shake", n."TenantId", n."Title", n."Voice" Sep 22 13:27:58 ubuntu dotnet[4147723]:     FROM "Notifications" AS n Sep 22 13:27:58 ubuntu dotnet[4147723]:     WHERE n."TenantId" = @__tenantId_0 AND n."ClassroomId" = @__classId_1 Sep 22 13:27:58 ubuntu dotnet[4147723]:     ORDER BY n."CreatedAt" DESC Sep 22 13:27:58 ubuntu dotnet[4147723]:     LIMIT @__p_2 Sep 22 13:27:58 ubuntu dotnet[4147723]: ) AS t Sep 22 13:27:58 ubuntu dotnet[4147723]: LEFT JOIN "NotificationReceipts" AS n0 ON t."Id" = n0."NotificationId" Sep 22 13:27:58 ubuntu dotnet[4147723]: ORDER BY t."CreatedAt" DESC, t."Id" Sep 22 13:27:58 ubuntu dotnet[4147723]: [13:27:58 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 13:27:58 ubuntu dotnet[4147723]: SELECT c."TenantId", c."Id", c."CreatedAt", c."DisplayName", c."Grade", c."RoomNumber" Sep 22 13:27:58 ubuntu dotnet[4147723]: FROM "Classrooms" AS c Sep 22 13:27:58 ubuntu dotnet[4147723]: [13:27:58 INF] Executing OkObjectResult, writing value of type 'System.Collections.Generic.List`1[[ClassNotify.Shared.Models.NotificationRecordDto, ClassNotify.Shared, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. Sep 22 13:27:58 ubuntu dotnet[4147723]: [13:27:58 INF] Executed action ClassNotify.Server.Controllers.NotificationController.GetNotificationHistory (ClassNotify.Server) in 3.2453ms Sep 22 13:27:58 ubuntu dotnet[4147723]: [13:27:58 INF] Executed endpoint 'ClassNotify.Server.Controllers.NotificationController.GetNotificationHistory (ClassNotify.Server)' Sep 22 13:27:58 ubuntu dotnet[4147723]: [13:27:58 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/api/notification/history?classId=cls_802&limit=10 - 200 null application/json; charset=utf-8 3.7669ms Sep 22 13:27:58 ubuntu dotnet[4147723]: [13:27:58 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/api/notification/history?classId=cls_802&limit=10 - null null Sep 22 13:27:58 ubuntu dotnet[4147723]: [13:27:58 INF] Executing endpoint 'ClassNotify.Server.Controllers.NotificationController.GetNotificationHistory (ClassNotify.Server)' Sep 22 13:27:58 ubuntu dotnet[4147723]: [13:27:58 INF] Route matched with {action = "GetNotificationHistory", controller = "Notification"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetNotificationHistory(System.String, Int32) on controller ClassNotify.Server.Controllers.NotificationController (ClassNotify.Server). Sep 22 13:27:58 ubuntu dotnet[4147723]: [13:27:58 INF] Executed DbCommand (1ms) [Parameters=[@__tenantId_0='?', @__classId_1='?', @__p_2='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30'] Sep 22 13:27:58 ubuntu dotnet[4147723]: SELECT t."Id", t."ClassroomId", t."CreatedAt", t."DurationSeconds", t."ExpiresAt", t."Message", t."Priority", t."SenderName", t."SenderUserId", t."Shake", t."TenantId", t."Title", t."Voice", n0."Id", n0."AcknowledgedAt", n0."DeviceId", n0."DeviceReceivedAt", n0."DisplayedAt", n0."FailedAt", n0."FailureReason", n0."NotificationId", n0."Status", n0."UpdatedAt" Sep 22 13:27:58 ubuntu dotnet[4147723]: FROM ( Sep 22 13:27:58 ubuntu dotnet[4147723]:     SELECT n."Id", n."ClassroomId", n."CreatedAt", n."DurationSeconds", n."ExpiresAt", n."Message", n."Priority", n."SenderName", n."SenderUserId", n."Shake", n."TenantId", n."Title", n."Voice" Sep 22 13:27:58 ubuntu dotnet[4147723]:     FROM "Notifications" AS n Sep 22 13:27:58 ubuntu dotnet[4147723]:     WHERE n."TenantId" = @__tenantId_0 AND n."ClassroomId" = @__classId_1 Sep 22 13:27:58 ubuntu dotnet[4147723]:     ORDER BY n."CreatedAt" DESC Sep 22 13:27:58 ubuntu dotnet[4147723]:     LIMIT @__p_2 Sep 22 13:27:58 ubuntu dotnet[4147723]: ) AS t Sep 22 13:27:58 ubuntu dotnet[4147723]: LEFT JOIN "NotificationReceipts" AS n0 ON t."Id" = n0."NotificationId" Sep 22 13:27:58 ubuntu dotnet[4147723]: ORDER BY t."CreatedAt" DESC, t."Id" Sep 22 13:27:58 ubuntu dotnet[4147723]: [13:27:58 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 13:27:58 ubuntu dotnet[4147723]: SELECT c."TenantId", c."Id", c."CreatedAt", c."DisplayName", c."Grade", c."RoomNumber" Sep 22 13:27:58 ubuntu dotnet[4147723]: FROM "Classrooms" AS c Sep 22 13:27:58 ubuntu dotnet[4147723]: [13:27:58 INF] Executing OkObjectResult, writing value of type 'System.Collections.Generic.List`1[[ClassNotify.Shared.Models.NotificationRecordDto, ClassNotify.Shared, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. Sep 22 13:27:58 ubuntu dotnet[4147723]: [13:27:58 INF] Executed action ClassNotify.Server.Controllers.NotificationController.GetNotificationHistory (ClassNotify.Server) in 3.4535ms Sep 22 13:27:58 ubuntu dotnet[4147723]: [13:27:58 INF] Executed endpoint 'ClassNotify.Server.Controllers.NotificationController.GetNotificationHistory (ClassNotify.Server)' Sep 22 13:27:58 ubuntu dotnet[4147723]: [13:27:58 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/api/notification/history?classId=cls_802&limit=10 - 200 null application/json; charset=utf-8 3.916ms Sep 22 13:27:59 ubuntu dotnet[4147723]: [13:27:59 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/api/notification/history?classId=cls_802&limit=10 - null null Sep 22 13:27:59 ubuntu dotnet[4147723]: [13:27:59 INF] Executing endpoint 'ClassNotify.Server.Controllers.NotificationController.GetNotificationHistory (ClassNotify.Server)' Sep 22 13:27:59 ubuntu dotnet[4147723]: [13:27:59 INF] Route matched with {action = "GetNotificationHistory", controller = "Notification"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetNotificationHistory(System.String, Int32) on controller ClassNotify.Server.Controllers.NotificationController (ClassNotify.Server). Sep 22 13:27:59 ubuntu dotnet[4147723]: [13:27:59 INF] Executed DbCommand (1ms) [Parameters=[@__tenantId_0='?', @__classId_1='?', @__p_2='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30'] Sep 22 13:27:59 ubuntu dotnet[4147723]: SELECT t."Id", t."ClassroomId", t."CreatedAt", t."DurationSeconds", t."ExpiresAt", t."Message", t."Priority", t."SenderName", t."SenderUserId", t."Shake", t."TenantId", t."Title", t."Voice", n0."Id", n0."AcknowledgedAt", n0."DeviceId", n0."DeviceReceivedAt", n0."DisplayedAt", n0."FailedAt", n0."FailureReason", n0."NotificationId", n0."Status", n0."UpdatedAt" Sep 22 13:27:59 ubuntu dotnet[4147723]: FROM ( Sep 22 13:27:59 ubuntu dotnet[4147723]:     SELECT n."Id", n."ClassroomId", n."CreatedAt", n."DurationSeconds", n."ExpiresAt", n."Message", n."Priority", n."SenderName", n."SenderUserId", n."Shake", n."TenantId", n."Title", n."Voice" Sep 22 13:27:59 ubuntu dotnet[4147723]:     FROM "Notifications" AS n Sep 22 13:27:59 ubuntu dotnet[4147723]:     WHERE n."TenantId" = @__tenantId_0 AND n."ClassroomId" = @__classId_1 Sep 22 13:27:59 ubuntu dotnet[4147723]:     ORDER BY n."CreatedAt" DESC Sep 22 13:27:59 ubuntu dotnet[4147723]:     LIMIT @__p_2 Sep 22 13:27:59 ubuntu dotnet[4147723]: ) AS t Sep 22 13:27:59 ubuntu dotnet[4147723]: LEFT JOIN "NotificationReceipts" AS n0 ON t."Id" = n0."NotificationId" Sep 22 13:27:59 ubuntu dotnet[4147723]: ORDER BY t."CreatedAt" DESC, t."Id" Sep 22 13:27:59 ubuntu dotnet[4147723]: [13:27:59 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 13:27:59 ubuntu dotnet[4147723]: SELECT c."TenantId", c."Id", c."CreatedAt", c."DisplayName", c."Grade", c."RoomNumber" Sep 22 13:27:59 ubuntu dotnet[4147723]: FROM "Classrooms" AS c Sep 22 13:27:59 ubuntu dotnet[4147723]: [13:27:59 INF] Executing OkObjectResult, writing value of type 'System.Collections.Generic.List`1[[ClassNotify.Shared.Models.NotificationRecordDto, ClassNotify.Shared, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. Sep 22 13:27:59 ubuntu dotnet[4147723]: [13:27:59 INF] Executed action ClassNotify.Server.Controllers.NotificationController.GetNotificationHistory (ClassNotify.Server) in 2.966ms Sep 22 13:27:59 ubuntu dotnet[4147723]: [13:27:59 INF] Executed endpoint 'ClassNotify.Server.Controllers.NotificationController.GetNotificationHistory (ClassNotify.Server)' Sep 22 13:27:59 ubuntu dotnet[4147723]: [13:27:59 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/api/notification/history?classId=cls_802&limit=10 - 200 null application/json; charset=utf-8 3.3874ms Sep 22 13:28:02 ubuntu dotnet[4147723]: [13:28:02 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 13:28: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:28:02 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 13:28:02 ubuntu dotnet[4147723]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 22 13:28:04 ubuntu dotnet[4147723]: [13:28:04 INF] Executed DbCommand (1ms) [Parameters=[@__messageId_0='?', @__tenantId_1='?', @__classroomId_2='?'], CommandType='Text', CommandTimeout='30'] Sep 22 13:28:04 ubuntu dotnet[4147723]: SELECT EXISTS ( Sep 22 13:28:04 ubuntu dotnet[4147723]:     SELECT 1 Sep 22 13:28:04 ubuntu dotnet[4147723]:     FROM "Notifications" AS n Sep 22 13:28:04 ubuntu dotnet[4147723]:     WHERE n."Id" = @__messageId_0 AND n."TenantId" = @__tenantId_1 AND n."ClassroomId" = @__classroomId_2) Sep 22 13:28:04 ubuntu dotnet[4147723]: [13:28:04 INF] ACK validated from Tenant t_beijing_no4, Class cls_802 (Device dev_59e35e79): Message msg_1790083654070_73da -> Timeout Sep 22 13:28:04 ubuntu dotnet[4147723]: [13:28:04 INF] Executed DbCommand (1ms) [Parameters=[@__messageId_0='?', @__authenticatedDeviceId_1='?'], CommandType='Text', CommandTimeout='30'] Sep 22 13:28:04 ubuntu dotnet[4147723]: SELECT n."Id", n."AcknowledgedAt", n."DeviceId", n."DeviceReceivedAt", n."DisplayedAt", n."FailedAt", n."FailureReason", n."NotificationId", n."Status", n."UpdatedAt" Sep 22 13:28:04 ubuntu dotnet[4147723]: FROM "NotificationReceipts" AS n Sep 22 13:28:04 ubuntu dotnet[4147723]: WHERE n."NotificationId" = @__messageId_0 AND n."DeviceId" = @__authenticatedDeviceId_1 Sep 22 13:28:04 ubuntu dotnet[4147723]: LIMIT 1 Sep 22 13:28:04 ubuntu dotnet[4147723]: [13:28:04 INF] Executed DbCommand (2ms) [Parameters=[@p2='?', @p0='?', @p1='?' (DbType = DateTime)], CommandType='Text', CommandTimeout='30'] Sep 22 13:28:04 ubuntu dotnet[4147723]: UPDATE "NotificationReceipts" SET "Status" = @p0, "UpdatedAt" = @p1 Sep 22 13:28:04 ubuntu dotnet[4147723]: WHERE "Id" = @p2;