Sep 23 02:04:59 ubuntu dotnet[381773]:    at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) Sep 23 02:04:59 ubuntu dotnet[381773]:    at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() Sep 23 02:04:59 ubuntu dotnet[381773]: --- End of stack trace from previous location --- Sep 23 02:04:59 ubuntu dotnet[381773]:    at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeFilterPipelineAsync>g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) Sep 23 02:04:59 ubuntu dotnet[381773]:    at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Logged|17_1(ResourceInvoker invoker) Sep 23 02:04:59 ubuntu dotnet[381773]:    at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Logged|17_1(ResourceInvoker invoker) Sep 23 02:04:59 ubuntu dotnet[381773]:    at Microsoft.AspNetCore.Routing.EndpointMiddleware.<Invoke>g__AwaitRequestTask|7_0(Endpoint endpoint, Task requestTask, ILogger logger) Sep 23 02:04:59 ubuntu dotnet[381773]:    at Microsoft.AspNetCore.RateLimiting.RateLimitingMiddleware.InvokeInternal(HttpContext context, EnableRateLimitingAttribute enableRateLimitingAttribute) Sep 23 02:04:59 ubuntu dotnet[381773]:    at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context) Sep 23 02:04:59 ubuntu dotnet[381773]:    at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context) Sep 23 02:04:59 ubuntu dotnet[381773]:    at Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpProtocol.ProcessRequests[TContext](IHttpApplication`1 application) Sep 23 02:04:59 ubuntu dotnet[381773]: [02:04:59 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/api/notification/history?classId=cls_802&limit=10 - 500 0 null 75.4383ms Sep 23 02:05:00 ubuntu dotnet[381773]: [02:05:00 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/api/notification/history?classId=cls_802&limit=10 - null null Sep 23 02:05:00 ubuntu dotnet[381773]: [02:05:00 INF] Executing endpoint 'ClassNotify.Server.Controllers.NotificationController.GetNotificationHistory (ClassNotify.Server)' Sep 23 02:05:00 ubuntu dotnet[381773]: [02:05:00 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 23 02:05:00 ubuntu dotnet[381773]: [02:05:00 INF] Executed DbCommand (3ms) [Parameters=[@__tenantId_0='?', @__classId_1='?', @__p_2='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30'] Sep 23 02:05:00 ubuntu dotnet[381773]: 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 23 02:05:00 ubuntu dotnet[381773]: FROM ( Sep 23 02:05:00 ubuntu dotnet[381773]:     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 23 02:05:00 ubuntu dotnet[381773]:     FROM "Notifications" AS n Sep 23 02:05:00 ubuntu dotnet[381773]:     WHERE n."TenantId" = @__tenantId_0 AND n."ClassroomId" = @__classId_1 Sep 23 02:05:00 ubuntu dotnet[381773]:     ORDER BY n."CreatedAt" DESC Sep 23 02:05:00 ubuntu dotnet[381773]:     LIMIT @__p_2 Sep 23 02:05:00 ubuntu dotnet[381773]: ) AS t Sep 23 02:05:00 ubuntu dotnet[381773]: LEFT JOIN "NotificationReceipts" AS n0 ON t."Id" = n0."NotificationId" Sep 23 02:05:00 ubuntu dotnet[381773]: ORDER BY t."CreatedAt" DESC, t."Id" Sep 23 02:05:00 ubuntu dotnet[381773]: [02:05:00 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 02:05:00 ubuntu dotnet[381773]: SELECT c."TenantId", c."Id", c."CreatedAt", c."DisplayName", c."Grade", c."RoomNumber" Sep 23 02:05:00 ubuntu dotnet[381773]: FROM "Classrooms" AS c Sep 23 02:05:00 ubuntu dotnet[381773]: [02:05:00 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=[REDACTED]]]'. Sep 23 02:05:00 ubuntu dotnet[381773]: [02:05:00 INF] Executed action ClassNotify.Server.Controllers.NotificationController.GetNotificationHistory (ClassNotify.Server) in 32.3097ms Sep 23 02:05:00 ubuntu dotnet[381773]: [02:05:00 INF] Executed endpoint 'ClassNotify.Server.Controllers.NotificationController.GetNotificationHistory (ClassNotify.Server)' Sep 23 02:05:00 ubuntu dotnet[381773]: [02:05:00 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 33.1467ms Sep 23 02:05:01 ubuntu dotnet[381773]: [02:05:01 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/api/notification/history?classId=cls_802&limit=20 - null null Sep 23 02:05:01 ubuntu dotnet[381773]: [02:05:01 INF] Executing endpoint 'ClassNotify.Server.Controllers.NotificationController.GetNotificationHistory (ClassNotify.Server)' Sep 23 02:05:01 ubuntu dotnet[381773]: [02:05:01 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 23 02:05:01 ubuntu dotnet[381773]: [02:05:01 INF] Executed DbCommand (4ms) [Parameters=[@__tenantId_0='?', @__classId_1='?', @__p_2='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30'] Sep 23 02:05:01 ubuntu dotnet[381773]: 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 23 02:05:01 ubuntu dotnet[381773]: FROM ( Sep 23 02:05:01 ubuntu dotnet[381773]:     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 23 02:05:01 ubuntu dotnet[381773]:     FROM "Notifications" AS n Sep 23 02:05:01 ubuntu dotnet[381773]:     WHERE n."TenantId" = @__tenantId_0 AND n."ClassroomId" = @__classId_1 Sep 23 02:05:01 ubuntu dotnet[381773]:     ORDER BY n."CreatedAt" DESC Sep 23 02:05:01 ubuntu dotnet[381773]:     LIMIT @__p_2 Sep 23 02:05:01 ubuntu dotnet[381773]: ) AS t Sep 23 02:05:01 ubuntu dotnet[381773]: LEFT JOIN "NotificationReceipts" AS n0 ON t."Id" = n0."NotificationId" Sep 23 02:05:01 ubuntu dotnet[381773]: ORDER BY t."CreatedAt" DESC, t."Id" Sep 23 02:05:01 ubuntu dotnet[381773]: [02:05:01 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 02:05:01 ubuntu dotnet[381773]: SELECT c."TenantId", c."Id", c."CreatedAt", c."DisplayName", c."Grade", c."RoomNumber" Sep 23 02:05:01 ubuntu dotnet[381773]: FROM "Classrooms" AS c Sep 23 02:05:01 ubuntu dotnet[381773]: [02:05:01 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=[REDACTED]]]'. Sep 23 02:05:01 ubuntu dotnet[381773]: [02:05:01 INF] Executed action ClassNotify.Server.Controllers.NotificationController.GetNotificationHistory (ClassNotify.Server) in 7.9924ms Sep 23 02:05:01 ubuntu dotnet[381773]: [02:05:01 INF] Executed endpoint 'ClassNotify.Server.Controllers.NotificationController.GetNotificationHistory (ClassNotify.Server)' Sep 23 02:05:01 ubuntu dotnet[381773]: [02:05:01 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/api/notification/history?classId=cls_802&limit=20 - 200 null application/json; charset=utf-8 9.0863ms Sep 23 02:05:02 ubuntu dotnet[381773]: [02:05:02 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 02:05:02 ubuntu dotnet[381773]: 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 02:05:02 ubuntu dotnet[381773]: FROM "DeviceCommands" AS d Sep 23 02:05:02 ubuntu dotnet[381773]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 23 02:05:04 ubuntu dotnet[381773]: [02:05:04 INF] Request starting HTTP/1.1 POST http://classnotify.paradise.eu.org/api/notification/send - application/json 178 Sep 23 02:05:04 ubuntu dotnet[381773]: [02:05:04 INF] Executing endpoint 'ClassNotify.Server.Controllers.NotificationController.SendNotification (ClassNotify.Server)' Sep 23 02:05:04 ubuntu dotnet[381773]: [02:05:04 INF] Route matched with {action = "SendNotification", controller = "Notification"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SendNotification(ClassNotify.Shared.Models.NotificationDto) on controller ClassNotify.Server.Controllers.NotificationController (ClassNotify.Server). Sep 23 02:05:04 ubuntu dotnet[381773]: [02:05:04 INF] Executed DbCommand (1ms) [Parameters=[@__tenantId_0='?', @__classId_1='?'], CommandType='Text', CommandTimeout='30'] Sep 23 02:05:04 ubuntu dotnet[381773]: SELECT c."TenantId", c."Id", c."CreatedAt", c."DisplayName", c."Grade", c."RoomNumber" Sep 23 02:05:04 ubuntu dotnet[381773]: FROM "Classrooms" AS c Sep 23 02:05:04 ubuntu dotnet[381773]: WHERE c."TenantId" = @__tenantId_0 AND c."Id" = @__classId_1 Sep 23 02:05:04 ubuntu dotnet[381773]: LIMIT 1 Sep 23 02:05:04 ubuntu dotnet[381773]: [02:05:04 INF] Executed DbCommand (1ms) [Parameters=[@__notification_TenantId_0='?', @__notification_ClassId_1='?'], CommandType='Text', CommandTimeout='30'] Sep 23 02:05:04 ubuntu dotnet[381773]: SELECT d."Id", d."ClassroomId", d."CreatedAt", d."DeviceTokenHash", d."Hostname", d."InstallationId", d."IsActive", d."LastHeartbeatAt", d."RawDeviceToken", d."TenantId" Sep 23 02:05:04 ubuntu dotnet[381773]: FROM "Devices" AS d Sep 23 02:05:04 ubuntu dotnet[381773]: WHERE d."TenantId" = @__notification_TenantId_0 AND d."ClassroomId" = @__notification_ClassId_1 AND d."IsActive" Sep 23 02:05:04 ubuntu dotnet[381773]: [02:05:04 INF] Executed DbCommand (3ms) [Parameters=[@p0='?', @p1='?', @p2='?' (DbType = DateTime), @p3='?' (DbType = Int32), @p4='?' (DbType = DateTime), @p5='?', @p6='?', @p7='?', @p8='?', @p9='?' (DbType = Boolean), @p10='?', @p11='?', @p12='?' (DbType = Boolean), @p13='?', @p14='?' (DbType = DateTime), @p15='?', @p16='?' (DbType = DateTime), @p17='?' (DbType = DateTime), @p18='?' (DbType = DateTime), @p19='?', @p20='?', @p21='?', @p22='?' (DbType = DateTime), @p23='?', @p24='?' (DbType = DateTime), @p25='?', @p26='?' (DbType = DateTime), @p27='?' (DbType = DateTime), @p28='?' (DbType = DateTime), @p29='?', @p30='?', @p31='?', @p32='?' (DbType = DateTime), @p33='?', @p34='?' (DbType = DateTime), @p35='?', @p36='?' (DbType = DateTime), @p37='?' (DbType = DateTime), @p38='?' (DbType = DateTime), @p39='?', @p40='?', @p41='?', @p42='?' (DbType = DateTime), @p43='?', @p44='?' (DbType = DateTime), @p45='?', @p46='?' (DbType = DateTime), @p47='?' (DbType = DateTime), @p48='?' (DbType = DateTime), @p49='?', @p50='?', @p51='?', @p52='?' (DbType = DateTime), @p53='?', @p54='?' (DbType = DateTime), @p55='?', @p56='?' (DbType = DateTime), @p57='?' (DbType = DateTime), @p58='?' (DbType = DateTime), @p59='?', @p60='?', @p61='?', @p62='?' (DbType = DateTime), @p63='?', @p64='?' (DbType = DateTime), @p65='?', @p66='?' (DbType = DateTime), @p67='?' (DbType = DateTime), @p68='?' (DbType = DateTime), @p69='?', @p70='?', @p71='?', @p72='?' (DbType = DateTime), @p73='?', @p74='?' (DbType = DateTime), @p75='?', @p76='?' (DbType = DateTime), @p77='?' (DbType = DateTime), @p78='?' (DbType = DateTime), @p79='?', @p80='?', @p81='?', @p82='?' (DbType = DateTime), @p83='?', @p84='?' (DbType = DateTime), @p85='?', @p86='?' (DbType = DateTime), @p87='?' (DbType = DateTime), @p88='?' (DbType = DateTime), @p89='?', @p90='?', @p91='?', @p92='?' (DbType = DateTime), @p93='?', @p94='?' (DbType = DateTime), @p95='?', @p96='?' (DbType = DateTime), @p97='?' (DbType = DateTime), @p98='?' (DbType = DateTime), @p99='?', @p100='?', @p101='?', @p102='?' (DbType = DateTime)], CommandType='Text', CommandTimeout='30'] Sep 23 02:05:04 ubuntu dotnet[381773]: INSERT INTO "Notifications" ("Id", "ClassroomId", "CreatedAt", "DurationSeconds", "ExpiresAt", "Message", "Priority", "SenderName", "SenderUserId", "Shake", "TenantId", "Title", "Voice") Sep 23 02:05:04 ubuntu dotnet[381773]: VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12); Sep 23 02:05:04 ubuntu dotnet[381773]: INSERT INTO "NotificationReceipts" ("Id", "AcknowledgedAt", "DeviceId", "DeviceReceivedAt", "DisplayedAt", "FailedAt", "FailureReason", "NotificationId", "Status", "UpdatedAt") Sep 23 02:05:04 ubuntu dotnet[381773]: VALUES (@p13, @p14, @p15, @p16, @p17, @p18, @p19, @p20, @p21, @p22); Sep 23 02:05:04 ubuntu dotnet[381773]: INSERT INTO "NotificationReceipts" ("Id", "AcknowledgedAt", "DeviceId", "DeviceReceivedAt", "DisplayedAt", "FailedAt", "FailureReason", "NotificationId", "Status", "UpdatedAt") Sep 23 02:05:04 ubuntu dotnet[381773]: VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32); Sep 23 02:05:04 ubuntu dotnet[381773]: INSERT INTO "NotificationReceipts" ("Id", "AcknowledgedAt", "DeviceId", "DeviceReceivedAt", "DisplayedAt", "FailedAt", "FailureReason", "NotificationId", "Status", "UpdatedAt") Sep 23 02:05:04 ubuntu dotnet[381773]: VALUES (@p33, @p34, @p35, @p36, @p37, @p38, @p39, @p40, @p41, @p42); Sep 23 02:05:04 ubuntu dotnet[381773]: INSERT INTO "NotificationReceipts" ("Id", "AcknowledgedAt", "DeviceId", "DeviceReceivedAt", "DisplayedAt", "FailedAt", "FailureReason", "NotificationId", "Status", "UpdatedAt") Sep 23 02:05:04 ubuntu dotnet[381773]: VALUES (@p43, @p44, @p45, @p46, @p47, @p48, @p49, @p50, @p51, @p52); Sep 23 02:05:04 ubuntu dotnet[381773]: INSERT INTO "NotificationReceipts" ("Id", "AcknowledgedAt", "DeviceId", "DeviceReceivedAt", "DisplayedAt", "FailedAt", "FailureReason", "NotificationId", "Status", "UpdatedAt") Sep 23 02:05:04 ubuntu dotnet[381773]: VALUES (@p53, @p54, @p55, @p56, @p57, @p58, @p59, @p60, @p61, @p62); Sep 23 02:05:04 ubuntu dotnet[381773]: INSERT INTO "NotificationReceipts" ("Id", "AcknowledgedAt", "DeviceId", "DeviceReceivedAt", "DisplayedAt", "FailedAt", "FailureReason", "NotificationId", "Status", "UpdatedAt") Sep 23 02:05:04 ubuntu dotnet[381773]: VALUES (@p63, @p64, @p65, @p66, @p67, @p68, @p69, @p70, @p71, @p72); Sep 23 02:05:04 ubuntu dotnet[381773]: INSERT INTO "NotificationReceipts" ("Id", "AcknowledgedAt", "DeviceId", "DeviceReceivedAt", "DisplayedAt", "FailedAt", "FailureReason", "NotificationId", "Status", "UpdatedAt") Sep 23 02:05:04 ubuntu dotnet[381773]: VALUES (@p73, @p74, @p75, @p76, @p77, @p78, @p79, @p80, @p81, @p82); Sep 23 02:05:04 ubuntu dotnet[381773]: INSERT INTO "NotificationReceipts" ("Id", "AcknowledgedAt", "DeviceId", "DeviceReceivedAt", "DisplayedAt", "FailedAt", "FailureReason", "NotificationId", "Status", "UpdatedAt") Sep 23 02:05:04 ubuntu dotnet[381773]: VALUES (@p83, @p84, @p85, @p86, @p87, @p88, @p89, @p90, @p91, @p92); Sep 23 02:05:04 ubuntu dotnet[381773]: INSERT INTO "NotificationReceipts" ("Id", "AcknowledgedAt", "DeviceId", "DeviceReceivedAt", "DisplayedAt", "FailedAt", "FailureReason", "NotificationId", "Status", "UpdatedAt") Sep 23 02:05:04 ubuntu dotnet[381773]: VALUES (@p93, @p94, @p95, @p96, @p97, @p98, @p99, @p100, @p101, @p102); Sep 23 02:05:04 ubuntu dotnet[381773]: [02:05:04 INF] Teacher RC1 Teacher (t_beijing_no4) sending notification to 八年级(2)班 (cls_802): Smoke test: PostgreSQL restarted, data intact, write path active Sep 23 02:05:04 ubuntu dotnet[381773]: [02:05:04 INF] Executing OkObjectResult, writing value of type '<>f__AnonymousType5`6[[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]],[System.String, 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]],[System.String, 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 02:05:04 ubuntu dotnet[381773]: [02:05:04 INF] Executed action ClassNotify.Server.Controllers.NotificationController.SendNotification (ClassNotify.Server) in 240.6192ms Sep 23 02:05:04 ubuntu dotnet[381773]: [02:05:04 INF] Executed endpoint 'ClassNotify.Server.Controllers.NotificationController.SendNotification (ClassNotify.Server)' Sep 23 02:05:04 ubuntu dotnet[381773]: [02:05:04 INF] Request finished HTTP/1.1 POST https://classnotify.paradise.eu.org/api/notification/send - 200 null application/json; charset=utf-8 241.6653ms Sep 23 02:05:05 ubuntu dotnet[381773]: [02:05:05 INF] Executed DbCommand (1ms) [Parameters=[@__messageId_0='?', @__tenantId_1='?', @__classroomId_2='?'], CommandType='Text', CommandTimeout='30'] Sep 23 02:05:05 ubuntu dotnet[381773]: SELECT EXISTS ( Sep 23 02:05:05 ubuntu dotnet[381773]:     SELECT 1 Sep 23 02:05:05 ubuntu dotnet[381773]:     FROM "Notifications" AS n Sep 23 02:05:05 ubuntu dotnet[381773]:     WHERE n."Id" = @__messageId_0 AND n."TenantId" = @__tenantId_1 AND n."ClassroomId" = @__classroomId_2) Sep 23 02:05:05 ubuntu dotnet[381773]: [02:05:05 INF] ACK validated from Tenant t_beijing_no4, Class cls_802 (Device dev_59e35e79): Message msg_1790129104698_c152 -> Delivered Sep 23 02:05:05 ubuntu dotnet[381773]: [02:05:05 INF] Executed DbCommand (0ms) [Parameters=[@__messageId_0='?', @__authenticatedDeviceId_1='?'], CommandType='Text', CommandTimeout='30'] Sep 23 02:05:05 ubuntu dotnet[381773]: SELECT n."Id", n."AcknowledgedAt", n."DeviceId", n."DeviceReceivedAt", n."DisplayedAt", n."FailedAt", n."FailureReason", n."NotificationId", n."Status", n."UpdatedAt" Sep 23 02:05:05 ubuntu dotnet[381773]: FROM "NotificationReceipts" AS n Sep 23 02:05:05 ubuntu dotnet[381773]: WHERE n."NotificationId" = @__messageId_0 AND n."DeviceId" = @__authenticatedDeviceId_1 Sep 23 02:05:05 ubuntu dotnet[381773]: LIMIT 1 Sep 23 02:05:05 ubuntu dotnet[381773]: [02:05:05 INF] Executed DbCommand (2ms) [Parameters=[@p4='?', @p0='?' (DbType = DateTime), @p1='?' (DbType = DateTime), @p2='?', @p3='?' (DbType = DateTime)], CommandType='Text', CommandTimeout='30'] Sep 23 02:05:05 ubuntu dotnet[381773]: UPDATE "NotificationReceipts" SET "DeviceReceivedAt" = @p0, "DisplayedAt" = @p1, "Status" = @p2, "UpdatedAt" = @p3 Sep 23 02:05:05 ubuntu dotnet[381773]: WHERE "Id" = @p4; Sep 23 02:05:07 ubuntu dotnet[381773]: [02:05:07 INF] Executed DbCommand (1ms) [Parameters=[@__messageId_0='?', @__tenantId_1='?', @__classroomId_2='?'], CommandType='Text', CommandTimeout='30'] Sep 23 02:05:07 ubuntu dotnet[381773]: SELECT EXISTS ( Sep 23 02:05:07 ubuntu dotnet[381773]:     SELECT 1 Sep 23 02:05:07 ubuntu dotnet[381773]:     FROM "Notifications" AS n Sep 23 02:05:07 ubuntu dotnet[381773]:     WHERE n."Id" = @__messageId_0 AND n."TenantId" = @__tenantId_1 AND n."ClassroomId" = @__classroomId_2) Sep 23 02:05:07 ubuntu dotnet[381773]: [02:05:07 INF] ACK validated from Tenant t_beijing_no4, Class cls_802 (Device dev_59e35e79): Message msg_1790129091402_dadf -> Timeout Sep 23 02:05:07 ubuntu dotnet[381773]: [02:05:07 INF] Executed DbCommand (0ms) [Parameters=[@__messageId_0='?', @__authenticatedDeviceId_1='?'], CommandType='Text', CommandTimeout='30'] Sep 23 02:05:07 ubuntu dotnet[381773]: SELECT n."Id", n."AcknowledgedAt", n."DeviceId", n."DeviceReceivedAt", n."DisplayedAt", n."FailedAt", n."FailureReason", n."NotificationId", n."Status", n."UpdatedAt" Sep 23 02:05:07 ubuntu dotnet[381773]: FROM "NotificationReceipts" AS n Sep 23 02:05:07 ubuntu dotnet[381773]: WHERE n."NotificationId" = @__messageId_0 AND n."DeviceId" = @__authenticatedDeviceId_1 Sep 23 02:05:07 ubuntu dotnet[381773]: LIMIT 1 Sep 23 02:05:07 ubuntu dotnet[381773]: [02:05:07 INF] Executed DbCommand (1ms) [Parameters=[@p2='?', @p0='?', @p1='?' (DbType = DateTime)], CommandType='Text', CommandTimeout='30'] Sep 23 02:05:07 ubuntu dotnet[381773]: UPDATE "NotificationReceipts" SET "Status" = @p0, "UpdatedAt" = @p1 Sep 23 02:05:07 ubuntu dotnet[381773]: WHERE "Id" = @p2; Sep 23 02:05:12 ubuntu dotnet[381773]: [02:05:12 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 02:05:12 ubuntu dotnet[381773]: 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 02:05:12 ubuntu dotnet[381773]: FROM "DeviceCommands" AS d Sep 23 02:05:12 ubuntu dotnet[381773]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 23 02:05:22 ubuntu dotnet[381773]: [02:05:22 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 02:05:22 ubuntu dotnet[381773]: 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 02:05:22 ubuntu dotnet[381773]: FROM "DeviceCommands" AS d Sep 23 02:05:22 ubuntu dotnet[381773]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 23 02:05:28 ubuntu dotnet[381773]: [02:05:28 INF] Request starting HTTP/1.1 POST http://classnotify.paradise.eu.org/api/notification/send - application/json 216 Sep 23 02:05:28 ubuntu dotnet[381773]: [02:05:28 INF] Executing endpoint 'ClassNotify.Server.Controllers.NotificationController.SendNotification (ClassNotify.Server)' Sep 23 02:05:28 ubuntu dotnet[381773]: [02:05:28 INF] Route matched with {action = "SendNotification", controller = "Notification"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SendNotification(ClassNotify.Shared.Models.NotificationDto) on controller ClassNotify.Server.Controllers.NotificationController (ClassNotify.Server). Sep 23 02:05:29 ubuntu dotnet[381773]: [02:05:29 INF] Executed DbCommand (1ms) [Parameters=[@__tenantId_0='?', @__classId_1='?'], CommandType='Text', CommandTimeout='30'] Sep 23 02:05:29 ubuntu dotnet[381773]: SELECT c."TenantId", c."Id", c."CreatedAt", c."DisplayName", c."Grade", c."RoomNumber" Sep 23 02:05:29 ubuntu dotnet[381773]: FROM "Classrooms" AS c Sep 23 02:05:29 ubuntu dotnet[381773]: WHERE c."TenantId" = @__tenantId_0 AND c."Id" = @__classId_1 Sep 23 02:05:29 ubuntu dotnet[381773]: LIMIT 1 Sep 23 02:05:29 ubuntu dotnet[381773]: [02:05:29 INF] Executed DbCommand (0ms) [Parameters=[@__notification_TenantId_0='?', @__notification_ClassId_1='?'], CommandType='Text', CommandTimeout='30'] Sep 23 02:05:29 ubuntu dotnet[381773]: SELECT d."Id", d."ClassroomId", d."CreatedAt", d."DeviceTokenHash", d."Hostname", d."InstallationId", d."IsActive", d."LastHeartbeatAt", d."RawDeviceToken", d."TenantId" Sep 23 02:05:29 ubuntu dotnet[381773]: FROM "Devices" AS d Sep 23 02:05:29 ubuntu dotnet[381773]: WHERE d."TenantId" = @__notification_TenantId_0 AND d."ClassroomId" = @__notification_ClassId_1 AND d."IsActive" Sep 23 02:05:29 ubuntu dotnet[381773]: [02:05:29 INF] Executed DbCommand (2ms) [Parameters=[@p0='?', @p1='?', @p2='?' (DbType = DateTime), @p3='?' (DbType = Int32), @p4='?' (DbType = DateTime), @p5='?', @p6='?', @p7='?', @p8='?', @p9='?' (DbType = Boolean), @p10='?', @p11='?', @p12='?' (DbType = Boolean), @p13='?', @p14='?' (DbType = DateTime), @p15='?', @p16='?' (DbType = DateTime), @p17='?' (DbType = DateTime), @p18='?' (DbType = DateTime), @p19='?', @p20='?', @p21='?', @p22='?' (DbType = DateTime), @p23='?', @p24='?' (DbType = DateTime), @p25='?', @p26='?' (DbType = DateTime), @p27='?' (DbType = DateTime), @p28='?' (DbType = DateTime), @p29='?', @p30='?', @p31='?', @p32='?' (DbType = DateTime), @p33='?', @p34='?' (DbType = DateTime), @p35='?', @p36='?' (DbType = DateTime), @p37='?' (DbType = DateTime), @p38='?' (DbType = DateTime), @p39='?', @p40='?', @p41='?', @p42='?' (DbType = DateTime), @p43='?', @p44='?' (DbType = DateTime), @p45='?', @p46='?' (DbType = DateTime), @p47='?' (DbType = DateTime), @p48='?' (DbType = DateTime), @p49='?', @p50='?', @p51='?', @p52='?' (DbType = DateTime), @p53='?', @p54='?' (DbType = DateTime), @p55='?', @p56='?' (DbType = DateTime), @p57='?' (DbType = DateTime), @p58='?' (DbType = DateTime), @p59='?', @p60='?', @p61='?', @p62='?' (DbType = DateTime), @p63='?', @p64='?' (DbType = DateTime), @p65='?', @p66='?' (DbType = DateTime), @p67='?' (DbType = DateTime), @p68='?' (DbType = DateTime), @p69='?', @p70='?', @p71='?', @p72='?' (DbType = DateTime), @p73='?', @p74='?' (DbType = DateTime), @p75='?', @p76='?' (DbType = DateTime), @p77='?' (DbType = DateTime), @p78='?' (DbType = DateTime), @p79='?', @p80='?', @p81='?', @p82='?' (DbType = DateTime), @p83='?', @p84='?' (DbType = DateTime), @p85='?', @p86='?' (DbType = DateTime), @p87='?' (DbType = DateTime), @p88='?' (DbType = DateTime), @p89='?', @p90='?', @p91='?', @p92='?' (DbType = DateTime), @p93='?', @p94='?' (DbType = DateTime), @p95='?', @p96='?' (DbType = DateTime), @p97='?' (DbType = DateTime), @p98='?' (DbType = DateTime), @p99='?', @p100='?', @p101='?', @p102='?' (DbType = DateTime)], CommandType='Text', CommandTimeout='30'] Sep 23 02:05:29 ubuntu dotnet[381773]: INSERT INTO "Notifications" ("Id", "ClassroomId", "CreatedAt", "DurationSeconds", "ExpiresAt", "Message", "Priority", "SenderName", "SenderUserId", "Shake", "TenantId", "Title", "Voice") Sep 23 02:05:29 ubuntu dotnet[381773]: VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12); Sep 23 02:05:29 ubuntu dotnet[381773]: INSERT INTO "NotificationReceipts" ("Id", "AcknowledgedAt", "DeviceId", "DeviceReceivedAt", "DisplayedAt", "FailedAt", "FailureReason", "NotificationId", "Status", "UpdatedAt") Sep 23 02:05:29 ubuntu dotnet[381773]: VALUES (@p13, @p14, @p15, @p16, @p17, @p18, @p19, @p20, @p21, @p22); Sep 23 02:05:29 ubuntu dotnet[381773]: INSERT INTO "NotificationReceipts" ("Id", "AcknowledgedAt", "DeviceId", "DeviceReceivedAt", "DisplayedAt", "FailedAt", "FailureReason", "NotificationId", "Status", "UpdatedAt") Sep 23 02:05:29 ubuntu dotnet[381773]: VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32); Sep 23 02:05:29 ubuntu dotnet[381773]: INSERT INTO "NotificationReceipts" ("Id", "AcknowledgedAt", "DeviceId", "DeviceReceivedAt", "DisplayedAt", "FailedAt", "FailureReason", "NotificationId", "Status", "UpdatedAt") Sep 23 02:05:29 ubuntu dotnet[381773]: VALUES (@p33, @p34, @p35, @p36, @p37, @p38, @p39, @p40, @p41, @p42); Sep 23 02:05:29 ubuntu dotnet[381773]: INSERT INTO "NotificationReceipts" ("Id", "AcknowledgedAt", "DeviceId", "DeviceReceivedAt", "DisplayedAt", "FailedAt", "FailureReason", "NotificationId", "Status", "UpdatedAt") Sep 23 02:05:29 ubuntu dotnet[381773]: VALUES (@p43, @p44, @p45, @p46, @p47, @p48, @p49, @p50, @p51, @p52); Sep 23 02:05:29 ubuntu dotnet[381773]: INSERT INTO "NotificationReceipts" ("Id", "AcknowledgedAt", "DeviceId", "DeviceReceivedAt", "DisplayedAt", "FailedAt", "FailureReason", "NotificationId", "Status", "UpdatedAt") Sep 23 02:05:29 ubuntu dotnet[381773]: VALUES (@p53, @p54, @p55, @p56, @p57, @p58, @p59, @p60, @p61, @p62); Sep 23 02:05:29 ubuntu dotnet[381773]: INSERT INTO "NotificationReceipts" ("Id", "AcknowledgedAt", "DeviceId", "DeviceReceivedAt", "DisplayedAt", "FailedAt", "FailureReason", "NotificationId", "Status", "UpdatedAt") Sep 23 02:05:29 ubuntu dotnet[381773]: VALUES (@p63, @p64, @p65, @p66, @p67, @p68, @p69, @p70, @p71, @p72); Sep 23 02:05:29 ubuntu dotnet[381773]: INSERT INTO "NotificationReceipts" ("Id", "AcknowledgedAt", "DeviceId", "DeviceReceivedAt", "DisplayedAt", "FailedAt", "FailureReason", "NotificationId", "Status", "UpdatedAt") Sep 23 02:05:29 ubuntu dotnet[381773]: VALUES (@p73, @p74, @p75, @p76, @p77, @p78, @p79, @p80, @p81, @p82); Sep 23 02:05:29 ubuntu dotnet[381773]: INSERT INTO "NotificationReceipts" ("Id", "AcknowledgedAt", "DeviceId", "DeviceReceivedAt", "DisplayedAt", "FailedAt", "FailureReason", "NotificationId", "Status", "UpdatedAt") Sep 23 02:05:29 ubuntu dotnet[381773]: VALUES (@p83, @p84, @p85, @p86, @p87, @p88, @p89, @p90, @p91, @p92); Sep 23 02:05:29 ubuntu dotnet[381773]: INSERT INTO "NotificationReceipts" ("Id", "AcknowledgedAt", "DeviceId", "DeviceReceivedAt", "DisplayedAt", "FailedAt", "FailureReason", "NotificationId", "Status", "UpdatedAt") Sep 23 02:05:29 ubuntu dotnet[381773]: VALUES (@p93, @p94, @p95, @p96, @p97, @p98, @p99, @p100, @p101, @p102); Sep 23 02:05:29 ubuntu dotnet[381773]: [02:05:29 INF] Teacher RC1 Teacher (t_beijing_no4) sending notification to 八年级(2)班 (cls_802): Offline persistence test: Must survive server restart and deliver upon catch-up Sep 23 02:05:29 ubuntu dotnet[381773]: [02:05:29 INF] Executing OkObjectResult, writing value of type '<>f__AnonymousType5`6[[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]],[System.String, 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]],[System.String, 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 02:05:29 ubuntu dotnet[381773]: [02:05:29 INF] Executed action ClassNotify.Server.Controllers.NotificationController.SendNotification (ClassNotify.Server) in 374.9187ms Sep 23 02:05:29 ubuntu dotnet[381773]: [02:05:29 INF] Executed endpoint 'ClassNotify.Server.Controllers.NotificationController.SendNotification (ClassNotify.Server)' Sep 23 02:05:29 ubuntu dotnet[381773]: [02:05:29 INF] Request finished HTTP/1.1 POST https://classnotify.paradise.eu.org/api/notification/send - 200 null application/json; charset=utf-8 375.8439ms Sep 23 02:05:32 ubuntu dotnet[381773]: [02:05:32 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 02:05:32 ubuntu dotnet[381773]: 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 02:05:32 ubuntu dotnet[381773]: FROM "DeviceCommands" AS d Sep 23 02:05:32 ubuntu dotnet[381773]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 23 02:05:38 ubuntu dotnet[381773]: [02:05:38 INF] Unregistered active device connection XmyVDFOK7mZf8kGLo6SZlA for Device dev_59e35e79 Sep 23 02:05:38 ubuntu dotnet[381773]: [02:05:38 INF] Device dev_59e35e79 disconnected for Tenant t_beijing_no4, Class cls_802 Sep 23 02:05:42 ubuntu systemd[1]: Stopping ClassNotify Cloud SignalR Server... Sep 23 02:05:42 ubuntu dotnet[381773]: [02:05:42 INF] Application is shutting down... Sep 23 02:05:42 ubuntu dotnet[381773]: [02:05:42 INF] Executed endpoint '/hubs/device' Sep 23 02:05:42 ubuntu dotnet[381773]: [02:05:42 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/hubs/device?id=rsTg4CEI4hkBSbR-sCoHfQ - 101 null null 54238.6974ms Sep 23 02:05:42 ubuntu dotnet[381773]: [02:05:42 INF] DeviceCommandTimeoutWorker stopped. Sep 23 02:05:42 ubuntu systemd[1]: classnotify.service: Deactivated successfully. Sep 23 02:05:42 ubuntu systemd[1]: Stopped ClassNotify Cloud SignalR Server. Sep 23 02:05:42 ubuntu systemd[1]: classnotify.service: Consumed 7.178s CPU time. Sep 23 02:05:42 ubuntu systemd[1]: Started ClassNotify Cloud SignalR Server. Sep 23 02:05:43 ubuntu dotnet[382437]: [02:05:43 INF] Executed DbCommand (55ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 02:05:43 ubuntu dotnet[382437]: SELECT EXISTS ( Sep 23 02:05:43 ubuntu dotnet[382437]:     SELECT 1 FROM pg_catalog.pg_class c Sep 23 02:05:43 ubuntu dotnet[382437]:     JOIN pg_catalog.pg_namespace n ON n.oid=c.relnamespace Sep 23 02:05:43 ubuntu dotnet[382437]:     WHERE n.nspname='public' AND Sep 23 02:05:43 ubuntu dotnet[382437]:           c.relname='__EFMigrationsHistory' Sep 23 02:05:43 ubuntu dotnet[382437]: ) Sep 23 02:05:43 ubuntu dotnet[382437]: [02:05:43 INF] Executed DbCommand (5ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 02:05:43 ubuntu dotnet[382437]: SELECT "MigrationId", "ProductVersion" Sep 23 02:05:43 ubuntu dotnet[382437]: FROM "__EFMigrationsHistory" Sep 23 02:05:43 ubuntu dotnet[382437]: ORDER BY "MigrationId"; Sep 23 02:05:43 ubuntu dotnet[382437]: [02:05:43 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 02:05:43 ubuntu dotnet[382437]: SELECT EXISTS ( Sep 23 02:05:43 ubuntu dotnet[382437]:     SELECT 1 FROM pg_catalog.pg_class c Sep 23 02:05:43 ubuntu dotnet[382437]:     JOIN pg_catalog.pg_namespace n ON n.oid=c.relnamespace Sep 23 02:05:43 ubuntu dotnet[382437]:     WHERE n.nspname='public' AND Sep 23 02:05:43 ubuntu dotnet[382437]:           c.relname='__EFMigrationsHistory' Sep 23 02:05:43 ubuntu dotnet[382437]: ) Sep 23 02:05:43 ubuntu dotnet[382437]: [02:05:43 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 02:05:43 ubuntu dotnet[382437]: SELECT EXISTS ( Sep 23 02:05:43 ubuntu dotnet[382437]:     SELECT 1 FROM pg_catalog.pg_class c Sep 23 02:05:43 ubuntu dotnet[382437]:     JOIN pg_catalog.pg_namespace n ON n.oid=c.relnamespace Sep 23 02:05:43 ubuntu dotnet[382437]:     WHERE n.nspname='public' AND Sep 23 02:05:43 ubuntu dotnet[382437]:           c.relname='__EFMigrationsHistory' Sep 23 02:05:43 ubuntu dotnet[382437]: ) Sep 23 02:05:43 ubuntu dotnet[382437]: [02:05:43 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 02:05:43 ubuntu dotnet[382437]: SELECT "MigrationId", "ProductVersion" Sep 23 02:05:43 ubuntu dotnet[382437]: FROM "__EFMigrationsHistory" Sep 23 02:05:43 ubuntu dotnet[382437]: ORDER BY "MigrationId"; Sep 23 02:05:43 ubuntu dotnet[382437]: [02:05:43 INF] No migrations were applied. The database is already up to date. Sep 23 02:05:44 ubuntu dotnet[382437]: [02:05:44 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 02:05:44 ubuntu dotnet[382437]: SELECT EXISTS ( Sep 23 02:05:44 ubuntu dotnet[382437]:     SELECT 1 Sep 23 02:05:44 ubuntu dotnet[382437]:     FROM "Tenants" AS t Sep 23 02:05:44 ubuntu dotnet[382437]:     WHERE t."Id" = 'global') Sep 23 02:05:44 ubuntu dotnet[382437]: [02:05:44 INF] Production environment: Development seeding is strictly prohibited. Skipping. Sep 23 02:05:44 ubuntu dotnet[382437]: [02:05:44 INF] Executed DbCommand (8ms) [Parameters=[@__p_0='?'], CommandType='Text', CommandTimeout='30'] Sep 23 02:05:44 ubuntu dotnet[382437]: SELECT m."Id", m."Details", m."MigratedAt" Sep 23 02:05:44 ubuntu dotnet[382437]: FROM "MigrationMarkers" AS m Sep 23 02:05:44 ubuntu dotnet[382437]: WHERE m."Id" = @__p_0 Sep 23 02:05:44 ubuntu dotnet[382437]: LIMIT 1 Sep 23 02:05:44 ubuntu dotnet[382437]: [02:05:44 INF] JSON migration marker 'JsonMigration_v1' already exists (migrated at 09/20/2026 23:08:55 +00:00). Skipping migration. Sep 23 02:05:44 ubuntu dotnet[382437]: [02:05:44 INF] DeviceCommandTimeoutWorker started (CheckInterval: 10s) Sep 23 02:05:44 ubuntu dotnet[382437]: [02:05:44 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 02:05:44 ubuntu dotnet[382437]: 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 02:05:44 ubuntu dotnet[382437]: FROM "DeviceCommands" AS d Sep 23 02:05:44 ubuntu dotnet[382437]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 23 02:05:44 ubuntu dotnet[382437]: [02:05:44 INF] Now listening on: http://127.0.0.1:5000 Sep 23 02:05:44 ubuntu dotnet[382437]: [02:05:44 INF] Application started. Press Ctrl+C to shut down. Sep 23 02:05:44 ubuntu dotnet[382437]: [02:05:44 INF] Hosting environment: Production Sep 23 02:05:44 ubuntu dotnet[382437]: [02:05:44 INF] Content root path: /var/www/classnotify/releases/20260922-122247-28315D00 Sep 23 02:05:54 ubuntu dotnet[382437]: [02:05:54 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 02:05:54 ubuntu dotnet[382437]: 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 02:05:54 ubuntu dotnet[382437]: FROM "DeviceCommands" AS d Sep 23 02:05:54 ubuntu dotnet[382437]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 23 02:06:04 ubuntu dotnet[382437]: [02:06:04 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 02:06:04 ubuntu dotnet[382437]: 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 02:06:04 ubuntu dotnet[382437]: FROM "DeviceCommands" AS d Sep 23 02:06:04 ubuntu dotnet[382437]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 23 02:06:14 ubuntu dotnet[382437]: [02:06:14 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 02:06:14 ubuntu dotnet[382437]: 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 02:06:14 ubuntu dotnet[382437]: FROM "DeviceCommands" AS d Sep 23 02:06:14 ubuntu dotnet[382437]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 23 02:06:17 ubuntu dotnet[382437]: [02:06:17 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/api/health - null null Sep 23 02:06:17 ubuntu dotnet[382437]: [02:06:17 INF] Executing endpoint 'HTTP: GET /api/health' Sep 23 02:06:17 ubuntu dotnet[382437]: [02:06:17 INF] Executed DbCommand (4ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 02:06:17 ubuntu dotnet[382437]: SELECT 1 Sep 23 02:06:17 ubuntu dotnet[382437]: [02:06:17 INF] Setting HTTP status code 200. Sep 23 02:06:17 ubuntu dotnet[382437]: [02:06:17 INF] Writing value of type '<>f__AnonymousType28`6' as Json. Sep 23 02:06:17 ubuntu dotnet[382437]: [02:06:17 INF] Executed endpoint 'HTTP: GET /api/health' Sep 23 02:06:17 ubuntu dotnet[382437]: [02:06:17 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/api/health - 200 null application/json; charset=utf-8 109.1795ms Sep 23 02:06:24 ubuntu dotnet[382437]: [02:06:24 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 02:06:24 ubuntu dotnet[382437]: 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 02:06:24 ubuntu dotnet[382437]: FROM "DeviceCommands" AS d Sep 23 02:06:24 ubuntu dotnet[382437]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 23 02:06:26 ubuntu dotnet[382437]: [02:06:26 INF] Request starting HTTP/1.1 POST http://classnotify.paradise.eu.org/hubs/device/negotiate?negotiateVersion=1 - null 0 Sep 23 02:06:26 ubuntu dotnet[382437]: [02:06:26 INF] Executing endpoint '/hubs/device/negotiate' Sep 23 02:06:26 ubuntu dotnet[382437]: [02:06:26 INF] Executed endpoint '/hubs/device/negotiate' Sep 23 02:06:26 ubuntu dotnet[382437]: [02:06:26 INF] Request finished HTTP/1.1 POST https://classnotify.paradise.eu.org/hubs/device/negotiate?negotiateVersion=1 - 200 316 application/json 10.4163ms Sep 23 02:06:26 ubuntu dotnet[382437]: [02:06:26 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/hubs/device?id=rIGWQLfWfvcYPfoTUc5X5Q - null null Sep 23 02:06:26 ubuntu dotnet[382437]: [02:06:26 INF] Executing endpoint '/hubs/device' Sep 23 02:06:27 ubuntu dotnet[382437]: [02:06:27 INF] Executed DbCommand (1ms) [Parameters=[@__deviceId_0='?', @__tokenHash_1='?'], CommandType='Text', CommandTimeout='30'] Sep 23 02:06:27 ubuntu dotnet[382437]: SELECT d."Id", d."ClassroomId", d."CreatedAt", d."DeviceTokenHash", d."Hostname", d."InstallationId", d."IsActive", d."LastHeartbeatAt", d."RawDeviceToken", d."TenantId" Sep 23 02:06:27 ubuntu dotnet[382437]: FROM "Devices" AS d Sep 23 02:06:27 ubuntu dotnet[382437]: WHERE d."Id" = @__deviceId_0 AND d."DeviceTokenHash" = @__tokenHash_1 AND d."IsActive" Sep 23 02:06:27 ubuntu dotnet[382437]: LIMIT 1 Sep 23 02:06:27 ubuntu dotnet[382437]: [02:06:27 INF] Device dev_59e35e79 connected via SignalR. ConnectionId=lNGeDX7XGeHrjdvjGQ0iEw, IP=130.61.36.218 Sep 23 02:06:27 ubuntu dotnet[382437]: [02:06:27 INF] Device dev_59e35e79 authenticated successfully. Joined group t:t_beijing_no4:c:cls_802 at lNGeDX7XGeHrjdvjGQ0iEw Sep 23 02:06:27 ubuntu dotnet[382437]: [02:06:27 INF] Executed DbCommand (1ms) [Parameters=[@__tenantId_0='?', @__classId_1='?'], CommandType='Text', CommandTimeout='30'] Sep 23 02:06:27 ubuntu dotnet[382437]: SELECT c."TenantId", c."Id", c."CreatedAt", c."DisplayName", c."Grade", c."RoomNumber" Sep 23 02:06:27 ubuntu dotnet[382437]: FROM "Classrooms" AS c Sep 23 02:06:27 ubuntu dotnet[382437]: WHERE c."TenantId" = @__tenantId_0 AND c."Id" = @__classId_1 Sep 23 02:06:27 ubuntu dotnet[382437]: LIMIT 1 Sep 23 02:06:27 ubuntu dotnet[382437]: [02:06:27 INF] Executed DbCommand (3ms) [Parameters=[@__deviceId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 23 02:06:27 ubuntu dotnet[382437]: 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 02:06:27 ubuntu dotnet[382437]: FROM "NotificationReceipts" AS n Sep 23 02:06:27 ubuntu dotnet[382437]: INNER JOIN "Notifications" AS n0 ON n."NotificationId" = n0."Id" Sep 23 02:06:27 ubuntu dotnet[382437]: WHERE n."DeviceId" = @__deviceId_0 AND n."Status" = 'Sent' Sep 23 02:06:27 ubuntu dotnet[382437]: [02:06:27 INF] Device dev_59e35e79 connected with 1 pending notification(s) to catch up. Sep 23 02:06:27 ubuntu dotnet[382437]: [02:06:27 INF] Executed DbCommand (1ms) [Parameters=[@__deviceId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 23 02:06:27 ubuntu dotnet[382437]: 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 02:06:27 ubuntu dotnet[382437]: FROM "DeviceCommands" AS d Sep 23 02:06:27 ubuntu dotnet[382437]: WHERE d."DeviceId" = @__deviceId_0 AND d."Status" IN ('Pending', 'Dispatched') Sep 23 02:06:27 ubuntu dotnet[382437]: ORDER BY d."CreatedAt" Sep 23 02:06:28 ubuntu dotnet[382437]: [02:06:28 INF] Executed DbCommand (1ms) [Parameters=[@__messageId_0='?', @__tenantId_1='?', @__classroomId_2='?'], CommandType='Text', CommandTimeout='30'] Sep 23 02:06:28 ubuntu dotnet[382437]: SELECT EXISTS ( Sep 23 02:06:28 ubuntu dotnet[382437]:     SELECT 1 Sep 23 02:06:28 ubuntu dotnet[382437]:     FROM "Notifications" AS n Sep 23 02:06:28 ubuntu dotnet[382437]:     WHERE n."Id" = @__messageId_0 AND n."TenantId" = @__tenantId_1 AND n."ClassroomId" = @__classroomId_2) Sep 23 02:06:28 ubuntu dotnet[382437]: [02:06:28 INF] ACK validated from Tenant t_beijing_no4, Class cls_802 (Device dev_59e35e79): Message msg_1790129129029_760f -> Delivered Sep 23 02:06:28 ubuntu dotnet[382437]: [02:06:28 INF] Executed DbCommand (1ms) [Parameters=[@__messageId_0='?', @__authenticatedDeviceId_1='?'], CommandType='Text', CommandTimeout='30'] Sep 23 02:06:28 ubuntu dotnet[382437]: SELECT n."Id", n."AcknowledgedAt", n."DeviceId", n."DeviceReceivedAt", n."DisplayedAt", n."FailedAt", n."FailureReason", n."NotificationId", n."Status", n."UpdatedAt" Sep 23 02:06:28 ubuntu dotnet[382437]: FROM "NotificationReceipts" AS n Sep 23 02:06:28 ubuntu dotnet[382437]: WHERE n."NotificationId" = @__messageId_0 AND n."DeviceId" = @__authenticatedDeviceId_1 Sep 23 02:06:28 ubuntu dotnet[382437]: LIMIT 1 Sep 23 02:06:28 ubuntu dotnet[382437]: [02:06:28 INF] Executed DbCommand (3ms) [Parameters=[@p4='?', @p0='?' (DbType = DateTime), @p1='?' (DbType = DateTime), @p2='?', @p3='?' (DbType = DateTime)], CommandType='Text', CommandTimeout='30'] Sep 23 02:06:28 ubuntu dotnet[382437]: UPDATE "NotificationReceipts" SET "DeviceReceivedAt" = @p0, "DisplayedAt" = @p1, "Status" = @p2, "UpdatedAt" = @p3 Sep 23 02:06:28 ubuntu dotnet[382437]: WHERE "Id" = @p4; Sep 23 02:06:30 ubuntu dotnet[382437]: [02:06:30 INF] Executed DbCommand (1ms) [Parameters=[@__p_0='?'], CommandType='Text', CommandTimeout='30'] Sep 23 02:06:30 ubuntu dotnet[382437]: SELECT d."Id", d."ClassroomId", d."CreatedAt", d."DeviceTokenHash", d."Hostname", d."InstallationId", d."IsActive", d."LastHeartbeatAt", d."RawDeviceToken", d."TenantId" Sep 23 02:06:30 ubuntu dotnet[382437]: FROM "Devices" AS d Sep 23 02:06:30 ubuntu dotnet[382437]: WHERE d."Id" = @__p_0 Sep 23 02:06:30 ubuntu dotnet[382437]: LIMIT 1 Sep 23 02:06:30 ubuntu dotnet[382437]: [02:06:30 INF] Executed DbCommand (2ms) [Parameters=[@p1='?', @p0='?' (DbType = DateTime)], CommandType='Text', CommandTimeout='30'] Sep 23 02:06:30 ubuntu dotnet[382437]: UPDATE "Devices" SET "LastHeartbeatAt" = @p0 Sep 23 02:06:30 ubuntu dotnet[382437]: WHERE "Id" = @p1; Sep 23 02:06:34 ubuntu dotnet[382437]: [02:06:34 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 02:06:34 ubuntu dotnet[382437]: 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 02:06:34 ubuntu dotnet[382437]: FROM "DeviceCommands" AS d Sep 23 02:06:34 ubuntu dotnet[382437]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 23 02:06:37 ubuntu dotnet[382437]: [02:06:37 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/api/notification/history?classId=cls_802&limit=30 - null null Sep 23 02:06:37 ubuntu dotnet[382437]: [02:06:37 INF] Executing endpoint 'ClassNotify.Server.Controllers.NotificationController.GetNotificationHistory (ClassNotify.Server)' Sep 23 02:06:37 ubuntu dotnet[382437]: [02:06:37 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 23 02:06:37 ubuntu dotnet[382437]: [02:06:37 INF] Executed DbCommand (2ms) [Parameters=[@__tenantId_0='?', @__classId_1='?', @__p_2='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30'] Sep 23 02:06:37 ubuntu dotnet[382437]: 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 23 02:06:37 ubuntu dotnet[382437]: FROM ( Sep 23 02:06:37 ubuntu dotnet[382437]:     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 23 02:06:37 ubuntu dotnet[382437]:     FROM "Notifications" AS n Sep 23 02:06:37 ubuntu dotnet[382437]:     WHERE n."TenantId" = @__tenantId_0 AND n."ClassroomId" = @__classId_1 Sep 23 02:06:37 ubuntu dotnet[382437]:     ORDER BY n."CreatedAt" DESC Sep 23 02:06:37 ubuntu dotnet[382437]:     LIMIT @__p_2 Sep 23 02:06:37 ubuntu dotnet[382437]: ) AS t Sep 23 02:06:37 ubuntu dotnet[382437]: LEFT JOIN "NotificationReceipts" AS n0 ON t."Id" = n0."NotificationId" Sep 23 02:06:37 ubuntu dotnet[382437]: ORDER BY t."CreatedAt" DESC, t."Id" Sep 23 02:06:37 ubuntu dotnet[382437]: [02:06:37 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 02:06:37 ubuntu dotnet[382437]: SELECT c."TenantId", c."Id", c."CreatedAt", c."DisplayName", c."Grade", c."RoomNumber" Sep 23 02:06:37 ubuntu dotnet[382437]: FROM "Classrooms" AS c Sep 23 02:06:37 ubuntu dotnet[382437]: [02:06:37 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=[REDACTED]]]'. Sep 23 02:06:37 ubuntu dotnet[382437]: [02:06:37 INF] Executed action ClassNotify.Server.Controllers.NotificationController.GetNotificationHistory (ClassNotify.Server) in 76.9055ms Sep 23 02:06:37 ubuntu dotnet[382437]: [02:06:37 INF] Executed endpoint 'ClassNotify.Server.Controllers.NotificationController.GetNotificationHistory (ClassNotify.Server)' Sep 23 02:06:37 ubuntu dotnet[382437]: [02:06:37 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/api/notification/history?classId=cls_802&limit=30 - 200 null application/json; charset=utf-8 144.2086ms Sep 23 02:06:42 ubuntu dotnet[382437]: [02:06:42 INF] Executed DbCommand (1ms) [Parameters=[@__messageId_0='?', @__tenantId_1='?', @__classroomId_2='?'], CommandType='Text', CommandTimeout='30'] Sep 23 02:06:42 ubuntu dotnet[382437]: SELECT EXISTS ( Sep 23 02:06:42 ubuntu dotnet[382437]:     SELECT 1 Sep 23 02:06:42 ubuntu dotnet[382437]:     FROM "Notifications" AS n Sep 23 02:06:42 ubuntu dotnet[382437]:     WHERE n."Id" = @__messageId_0 AND n."TenantId" = @__tenantId_1 AND n."ClassroomId" = @__classroomId_2) Sep 23 02:06:42 ubuntu dotnet[382437]: [02:06:42 INF] ACK validated from Tenant t_beijing_no4, Class cls_802 (Device dev_59e35e79): Message msg_1790129129029_760f -> Timeout Sep 23 02:06:42 ubuntu dotnet[382437]: [02:06:42 INF] Executed DbCommand (0ms) [Parameters=[@__messageId_0='?', @__authenticatedDeviceId_1='?'], CommandType='Text', CommandTimeout='30'] Sep 23 02:06:42 ubuntu dotnet[382437]: SELECT n."Id", n."AcknowledgedAt", n."DeviceId", n."DeviceReceivedAt", n."DisplayedAt", n."FailedAt", n."FailureReason", n."NotificationId", n."Status", n."UpdatedAt" Sep 23 02:06:42 ubuntu dotnet[382437]: FROM "NotificationReceipts" AS n Sep 23 02:06:42 ubuntu dotnet[382437]: WHERE n."NotificationId" = @__messageId_0 AND n."DeviceId" = @__authenticatedDeviceId_1 Sep 23 02:06:42 ubuntu dotnet[382437]: LIMIT 1 Sep 23 02:06:42 ubuntu dotnet[382437]: [02:06:42 INF] Executed DbCommand (2ms) [Parameters=[@p2='?', @p0='?', @p1='?' (DbType = DateTime)], CommandType='Text', CommandTimeout='30'] Sep 23 02:06:42 ubuntu dotnet[382437]: UPDATE "NotificationReceipts" SET "Status" = @p0, "UpdatedAt" = @p1 Sep 23 02:06:42 ubuntu dotnet[382437]: WHERE "Id" = @p2;