Sep 23 02:09:31 ubuntu dotnet[384061]:    at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken) Sep 23 02:09:31 ubuntu dotnet[384061]:    at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken) Sep 23 02:09:31 ubuntu dotnet[384061]:    at ClassNotify.Server.Services.SecurityService.GetNotificationsAsync(String tenantId, String classId, Int32 limit) in C:\Users\Administrator\.gemini\antigravity\scratch\ClassNotify\src\Server\ClassNotify.Server\Services\SecurityService.cs:line 826 Sep 23 02:09:31 ubuntu dotnet[384061]:    at ClassNotify.Server.Controllers.NotificationController.GetNotificationHistory(String classId, Int32 limit) in C:\Users\Administrator\.gemini\antigravity\scratch\ClassNotify\src\Server\ClassNotify.Server\Controllers\NotificationController.cs:line 142 Sep 23 02:09:31 ubuntu dotnet[384061]:    at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) Sep 23 02:09:31 ubuntu dotnet[384061]:    at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask) Sep 23 02:09:31 ubuntu dotnet[384061]:    at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) Sep 23 02:09:31 ubuntu dotnet[384061]:    at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) Sep 23 02:09:31 ubuntu dotnet[384061]:    at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) Sep 23 02:09:31 ubuntu dotnet[384061]:    at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() Sep 23 02:09:31 ubuntu dotnet[384061]: --- End of stack trace from previous location --- Sep 23 02:09:31 ubuntu dotnet[384061]:    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:09:31 ubuntu dotnet[384061]:    at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Logged|17_1(ResourceInvoker invoker) Sep 23 02:09:31 ubuntu dotnet[384061]:    at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Logged|17_1(ResourceInvoker invoker) Sep 23 02:09:31 ubuntu dotnet[384061]:    at Microsoft.AspNetCore.Routing.EndpointMiddleware.<Invoke>g__AwaitRequestTask|7_0(Endpoint endpoint, Task requestTask, ILogger logger) Sep 23 02:09:31 ubuntu dotnet[384061]:    at Microsoft.AspNetCore.RateLimiting.RateLimitingMiddleware.InvokeInternal(HttpContext context, EnableRateLimitingAttribute enableRateLimitingAttribute) Sep 23 02:09:31 ubuntu dotnet[384061]:    at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context) Sep 23 02:09:31 ubuntu dotnet[384061]:    at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context) Sep 23 02:09:31 ubuntu dotnet[384061]:    at Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpProtocol.ProcessRequests[TContext](IHttpApplication`1 application) Sep 23 02:09:31 ubuntu dotnet[384061]: [02:09:31 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/api/notification/history?classId=cls_802&limit=10 - 500 0 null 73.3457ms Sep 23 02:09:32 ubuntu dotnet[384061]: [02:09:32 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:09:32 ubuntu dotnet[384061]: [02:09:32 INF] Executing endpoint 'ClassNotify.Server.Controllers.NotificationController.GetNotificationHistory (ClassNotify.Server)' Sep 23 02:09:32 ubuntu dotnet[384061]: [02:09:32 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:09:32 ubuntu dotnet[384061]: [02:09:32 INF] Executed DbCommand (3ms) [Parameters=[@__tenantId_0='?', @__classId_1='?', @__p_2='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30'] Sep 23 02:09:32 ubuntu dotnet[384061]: 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:09:32 ubuntu dotnet[384061]: FROM ( Sep 23 02:09:32 ubuntu dotnet[384061]:     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:09:32 ubuntu dotnet[384061]:     FROM "Notifications" AS n Sep 23 02:09:32 ubuntu dotnet[384061]:     WHERE n."TenantId" = @__tenantId_0 AND n."ClassroomId" = @__classId_1 Sep 23 02:09:32 ubuntu dotnet[384061]:     ORDER BY n."CreatedAt" DESC Sep 23 02:09:32 ubuntu dotnet[384061]:     LIMIT @__p_2 Sep 23 02:09:32 ubuntu dotnet[384061]: ) AS t Sep 23 02:09:32 ubuntu dotnet[384061]: LEFT JOIN "NotificationReceipts" AS n0 ON t."Id" = n0."NotificationId" Sep 23 02:09:32 ubuntu dotnet[384061]: ORDER BY t."CreatedAt" DESC, t."Id" Sep 23 02:09:32 ubuntu dotnet[384061]: [02:09:32 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 02:09:32 ubuntu dotnet[384061]: SELECT c."TenantId", c."Id", c."CreatedAt", c."DisplayName", c."Grade", c."RoomNumber" Sep 23 02:09:32 ubuntu dotnet[384061]: FROM "Classrooms" AS c Sep 23 02:09:32 ubuntu dotnet[384061]: [02:09:32 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:09:32 ubuntu dotnet[384061]: [02:09:32 INF] Executed action ClassNotify.Server.Controllers.NotificationController.GetNotificationHistory (ClassNotify.Server) in 31.6405ms Sep 23 02:09:32 ubuntu dotnet[384061]: [02:09:32 INF] Executed endpoint 'ClassNotify.Server.Controllers.NotificationController.GetNotificationHistory (ClassNotify.Server)' Sep 23 02:09:32 ubuntu dotnet[384061]: [02:09:32 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 32.6802ms Sep 23 02:09:32 ubuntu dotnet[384061]: [02:09:32 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/api/notification/history?classId=cls_802&limit=60 - null null Sep 23 02:09:32 ubuntu dotnet[384061]: [02:09:32 INF] Executing endpoint 'ClassNotify.Server.Controllers.NotificationController.GetNotificationHistory (ClassNotify.Server)' Sep 23 02:09:32 ubuntu dotnet[384061]: [02:09:32 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:09:32 ubuntu dotnet[384061]: [02:09:32 INF] Executed DbCommand (4ms) [Parameters=[@__tenantId_0='?', @__classId_1='?', @__p_2='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30'] Sep 23 02:09:32 ubuntu dotnet[384061]: 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:09:32 ubuntu dotnet[384061]: FROM ( Sep 23 02:09:32 ubuntu dotnet[384061]:     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:09:32 ubuntu dotnet[384061]:     FROM "Notifications" AS n Sep 23 02:09:32 ubuntu dotnet[384061]:     WHERE n."TenantId" = @__tenantId_0 AND n."ClassroomId" = @__classId_1 Sep 23 02:09:32 ubuntu dotnet[384061]:     ORDER BY n."CreatedAt" DESC Sep 23 02:09:32 ubuntu dotnet[384061]:     LIMIT @__p_2 Sep 23 02:09:32 ubuntu dotnet[384061]: ) AS t Sep 23 02:09:32 ubuntu dotnet[384061]: LEFT JOIN "NotificationReceipts" AS n0 ON t."Id" = n0."NotificationId" Sep 23 02:09:32 ubuntu dotnet[384061]: ORDER BY t."CreatedAt" DESC, t."Id" Sep 23 02:09:32 ubuntu dotnet[384061]: [02:09:32 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 02:09:32 ubuntu dotnet[384061]: SELECT c."TenantId", c."Id", c."CreatedAt", c."DisplayName", c."Grade", c."RoomNumber" Sep 23 02:09:32 ubuntu dotnet[384061]: FROM "Classrooms" AS c Sep 23 02:09:32 ubuntu dotnet[384061]: [02:09:32 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:09:32 ubuntu dotnet[384061]: [02:09:32 INF] Executed action ClassNotify.Server.Controllers.NotificationController.GetNotificationHistory (ClassNotify.Server) in 11.9241ms Sep 23 02:09:32 ubuntu dotnet[384061]: [02:09:32 INF] Executed endpoint 'ClassNotify.Server.Controllers.NotificationController.GetNotificationHistory (ClassNotify.Server)' Sep 23 02:09:32 ubuntu dotnet[384061]: [02:09:32 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/api/notification/history?classId=cls_802&limit=60 - 200 null application/json; charset=utf-8 13.0999ms Sep 23 02:09:35 ubuntu dotnet[384061]: [02:09:35 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 02:09:35 ubuntu dotnet[384061]: 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:09:35 ubuntu dotnet[384061]: FROM "DeviceCommands" AS d Sep 23 02:09:35 ubuntu dotnet[384061]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 23 02:09:35 ubuntu dotnet[384061]: [02:09:35 INF] Request starting HTTP/1.1 POST http://classnotify.paradise.eu.org/api/notification/send - application/json 178 Sep 23 02:09:35 ubuntu dotnet[384061]: [02:09:35 INF] Executing endpoint 'ClassNotify.Server.Controllers.NotificationController.SendNotification (ClassNotify.Server)' Sep 23 02:09:35 ubuntu dotnet[384061]: [02:09:35 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:09:36 ubuntu dotnet[384061]: [02:09:36 INF] Executed DbCommand (1ms) [Parameters=[@__tenantId_0='?', @__classId_1='?'], CommandType='Text', CommandTimeout='30'] Sep 23 02:09:36 ubuntu dotnet[384061]: SELECT c."TenantId", c."Id", c."CreatedAt", c."DisplayName", c."Grade", c."RoomNumber" Sep 23 02:09:36 ubuntu dotnet[384061]: FROM "Classrooms" AS c Sep 23 02:09:36 ubuntu dotnet[384061]: WHERE c."TenantId" = @__tenantId_0 AND c."Id" = @__classId_1 Sep 23 02:09:36 ubuntu dotnet[384061]: LIMIT 1 Sep 23 02:09:36 ubuntu dotnet[384061]: [02:09:36 INF] Executed DbCommand (1ms) [Parameters=[@__notification_TenantId_0='?', @__notification_ClassId_1='?'], CommandType='Text', CommandTimeout='30'] Sep 23 02:09:36 ubuntu dotnet[384061]: SELECT d."Id", d."ClassroomId", d."CreatedAt", d."DeviceTokenHash", d."Hostname", d."InstallationId", d."IsActive", d."LastHeartbeatAt", d."RawDeviceToken", d."TenantId" Sep 23 02:09:36 ubuntu dotnet[384061]: FROM "Devices" AS d Sep 23 02:09:36 ubuntu dotnet[384061]: WHERE d."TenantId" = @__notification_TenantId_0 AND d."ClassroomId" = @__notification_ClassId_1 AND d."IsActive" Sep 23 02:09:36 ubuntu dotnet[384061]: [02:09:36 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:09:36 ubuntu dotnet[384061]: INSERT INTO "Notifications" ("Id", "ClassroomId", "CreatedAt", "DurationSeconds", "ExpiresAt", "Message", "Priority", "SenderName", "SenderUserId", "Shake", "TenantId", "Title", "Voice") Sep 23 02:09:36 ubuntu dotnet[384061]: VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12); Sep 23 02:09:36 ubuntu dotnet[384061]: INSERT INTO "NotificationReceipts" ("Id", "AcknowledgedAt", "DeviceId", "DeviceReceivedAt", "DisplayedAt", "FailedAt", "FailureReason", "NotificationId", "Status", "UpdatedAt") Sep 23 02:09:36 ubuntu dotnet[384061]: VALUES (@p13, @p14, @p15, @p16, @p17, @p18, @p19, @p20, @p21, @p22); Sep 23 02:09:36 ubuntu dotnet[384061]: INSERT INTO "NotificationReceipts" ("Id", "AcknowledgedAt", "DeviceId", "DeviceReceivedAt", "DisplayedAt", "FailedAt", "FailureReason", "NotificationId", "Status", "UpdatedAt") Sep 23 02:09:36 ubuntu dotnet[384061]: VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32); Sep 23 02:09:36 ubuntu dotnet[384061]: INSERT INTO "NotificationReceipts" ("Id", "AcknowledgedAt", "DeviceId", "DeviceReceivedAt", "DisplayedAt", "FailedAt", "FailureReason", "NotificationId", "Status", "UpdatedAt") Sep 23 02:09:36 ubuntu dotnet[384061]: VALUES (@p33, @p34, @p35, @p36, @p37, @p38, @p39, @p40, @p41, @p42); Sep 23 02:09:36 ubuntu dotnet[384061]: INSERT INTO "NotificationReceipts" ("Id", "AcknowledgedAt", "DeviceId", "DeviceReceivedAt", "DisplayedAt", "FailedAt", "FailureReason", "NotificationId", "Status", "UpdatedAt") Sep 23 02:09:36 ubuntu dotnet[384061]: VALUES (@p43, @p44, @p45, @p46, @p47, @p48, @p49, @p50, @p51, @p52); Sep 23 02:09:36 ubuntu dotnet[384061]: INSERT INTO "NotificationReceipts" ("Id", "AcknowledgedAt", "DeviceId", "DeviceReceivedAt", "DisplayedAt", "FailedAt", "FailureReason", "NotificationId", "Status", "UpdatedAt") Sep 23 02:09:36 ubuntu dotnet[384061]: VALUES (@p53, @p54, @p55, @p56, @p57, @p58, @p59, @p60, @p61, @p62); Sep 23 02:09:36 ubuntu dotnet[384061]: INSERT INTO "NotificationReceipts" ("Id", "AcknowledgedAt", "DeviceId", "DeviceReceivedAt", "DisplayedAt", "FailedAt", "FailureReason", "NotificationId", "Status", "UpdatedAt") Sep 23 02:09:36 ubuntu dotnet[384061]: VALUES (@p63, @p64, @p65, @p66, @p67, @p68, @p69, @p70, @p71, @p72); Sep 23 02:09:36 ubuntu dotnet[384061]: INSERT INTO "NotificationReceipts" ("Id", "AcknowledgedAt", "DeviceId", "DeviceReceivedAt", "DisplayedAt", "FailedAt", "FailureReason", "NotificationId", "Status", "UpdatedAt") Sep 23 02:09:36 ubuntu dotnet[384061]: VALUES (@p73, @p74, @p75, @p76, @p77, @p78, @p79, @p80, @p81, @p82); Sep 23 02:09:36 ubuntu dotnet[384061]: INSERT INTO "NotificationReceipts" ("Id", "AcknowledgedAt", "DeviceId", "DeviceReceivedAt", "DisplayedAt", "FailedAt", "FailureReason", "NotificationId", "Status", "UpdatedAt") Sep 23 02:09:36 ubuntu dotnet[384061]: VALUES (@p83, @p84, @p85, @p86, @p87, @p88, @p89, @p90, @p91, @p92); Sep 23 02:09:36 ubuntu dotnet[384061]: INSERT INTO "NotificationReceipts" ("Id", "AcknowledgedAt", "DeviceId", "DeviceReceivedAt", "DisplayedAt", "FailedAt", "FailureReason", "NotificationId", "Status", "UpdatedAt") Sep 23 02:09:36 ubuntu dotnet[384061]: VALUES (@p93, @p94, @p95, @p96, @p97, @p98, @p99, @p100, @p101, @p102); Sep 23 02:09:36 ubuntu dotnet[384061]: [02:09:36 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:09:36 ubuntu dotnet[384061]: [02:09:36 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:09:36 ubuntu dotnet[384061]: [02:09:36 INF] Executed action ClassNotify.Server.Controllers.NotificationController.SendNotification (ClassNotify.Server) in 255.5753ms Sep 23 02:09:36 ubuntu dotnet[384061]: [02:09:36 INF] Executed endpoint 'ClassNotify.Server.Controllers.NotificationController.SendNotification (ClassNotify.Server)' Sep 23 02:09:36 ubuntu dotnet[384061]: [02:09:36 INF] Request finished HTTP/1.1 POST https://classnotify.paradise.eu.org/api/notification/send - 200 null application/json; charset=utf-8 256.4317ms Sep 23 02:09:36 ubuntu dotnet[384061]: [02:09:36 INF] Executed DbCommand (1ms) [Parameters=[@__messageId_0='?', @__tenantId_1='?', @__classroomId_2='?'], CommandType='Text', CommandTimeout='30'] Sep 23 02:09:36 ubuntu dotnet[384061]: SELECT EXISTS ( Sep 23 02:09:36 ubuntu dotnet[384061]:     SELECT 1 Sep 23 02:09:36 ubuntu dotnet[384061]:     FROM "Notifications" AS n Sep 23 02:09:36 ubuntu dotnet[384061]:     WHERE n."Id" = @__messageId_0 AND n."TenantId" = @__tenantId_1 AND n."ClassroomId" = @__classroomId_2) Sep 23 02:09:36 ubuntu dotnet[384061]: [02:09:36 INF] ACK validated from Tenant t_beijing_no4, Class cls_802 (Device dev_59e35e79): Message msg_1790129376048_f737 -> Delivered Sep 23 02:09:36 ubuntu dotnet[384061]: [02:09:36 INF] Executed DbCommand (0ms) [Parameters=[@__messageId_0='?', @__authenticatedDeviceId_1='?'], CommandType='Text', CommandTimeout='30'] Sep 23 02:09:36 ubuntu dotnet[384061]: SELECT n."Id", n."AcknowledgedAt", n."DeviceId", n."DeviceReceivedAt", n."DisplayedAt", n."FailedAt", n."FailureReason", n."NotificationId", n."Status", n."UpdatedAt" Sep 23 02:09:36 ubuntu dotnet[384061]: FROM "NotificationReceipts" AS n Sep 23 02:09:36 ubuntu dotnet[384061]: WHERE n."NotificationId" = @__messageId_0 AND n."DeviceId" = @__authenticatedDeviceId_1 Sep 23 02:09:36 ubuntu dotnet[384061]: LIMIT 1 Sep 23 02:09:36 ubuntu dotnet[384061]: [02:09:36 INF] Executed DbCommand (2ms) [Parameters=[@p4='?', @p0='?' (DbType = DateTime), @p1='?' (DbType = DateTime), @p2='?', @p3='?' (DbType = DateTime)], CommandType='Text', CommandTimeout='30'] Sep 23 02:09:36 ubuntu dotnet[384061]: UPDATE "NotificationReceipts" SET "DeviceReceivedAt" = @p0, "DisplayedAt" = @p1, "Status" = @p2, "UpdatedAt" = @p3 Sep 23 02:09:36 ubuntu dotnet[384061]: WHERE "Id" = @p4; Sep 23 02:09:38 ubuntu dotnet[384061]: [02:09:38 INF] Executed DbCommand (1ms) [Parameters=[@__messageId_0='?', @__tenantId_1='?', @__classroomId_2='?'], CommandType='Text', CommandTimeout='30'] Sep 23 02:09:38 ubuntu dotnet[384061]: SELECT EXISTS ( Sep 23 02:09:38 ubuntu dotnet[384061]:     SELECT 1 Sep 23 02:09:38 ubuntu dotnet[384061]:     FROM "Notifications" AS n Sep 23 02:09:38 ubuntu dotnet[384061]:     WHERE n."Id" = @__messageId_0 AND n."TenantId" = @__tenantId_1 AND n."ClassroomId" = @__classroomId_2) Sep 23 02:09:38 ubuntu dotnet[384061]: [02:09:38 INF] ACK validated from Tenant t_beijing_no4, Class cls_802 (Device dev_59e35e79): Message msg_1790129362500_cee0 -> Timeout Sep 23 02:09:38 ubuntu dotnet[384061]: [02:09:38 INF] Executed DbCommand (0ms) [Parameters=[@__messageId_0='?', @__authenticatedDeviceId_1='?'], CommandType='Text', CommandTimeout='30'] Sep 23 02:09:38 ubuntu dotnet[384061]: SELECT n."Id", n."AcknowledgedAt", n."DeviceId", n."DeviceReceivedAt", n."DisplayedAt", n."FailedAt", n."FailureReason", n."NotificationId", n."Status", n."UpdatedAt" Sep 23 02:09:38 ubuntu dotnet[384061]: FROM "NotificationReceipts" AS n Sep 23 02:09:38 ubuntu dotnet[384061]: WHERE n."NotificationId" = @__messageId_0 AND n."DeviceId" = @__authenticatedDeviceId_1 Sep 23 02:09:38 ubuntu dotnet[384061]: LIMIT 1 Sep 23 02:09:38 ubuntu dotnet[384061]: [02:09:38 INF] Executed DbCommand (2ms) [Parameters=[@p2='?', @p0='?', @p1='?' (DbType = DateTime)], CommandType='Text', CommandTimeout='30'] Sep 23 02:09:38 ubuntu dotnet[384061]: UPDATE "NotificationReceipts" SET "Status" = @p0, "UpdatedAt" = @p1 Sep 23 02:09:38 ubuntu dotnet[384061]: WHERE "Id" = @p2; Sep 23 02:09:45 ubuntu dotnet[384061]: [02:09:45 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 02:09:45 ubuntu dotnet[384061]: 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:09:45 ubuntu dotnet[384061]: FROM "DeviceCommands" AS d Sep 23 02:09:45 ubuntu dotnet[384061]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 23 02:09:55 ubuntu dotnet[384061]: [02:09:55 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 02:09:55 ubuntu dotnet[384061]: 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:09:55 ubuntu dotnet[384061]: FROM "DeviceCommands" AS d Sep 23 02:09:55 ubuntu dotnet[384061]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 23 02:09:58 ubuntu dotnet[384061]: [02:09:58 INF] Request starting HTTP/1.1 POST http://classnotify.paradise.eu.org/api/notification/send - application/json 216 Sep 23 02:09:58 ubuntu dotnet[384061]: [02:09:58 INF] Executing endpoint 'ClassNotify.Server.Controllers.NotificationController.SendNotification (ClassNotify.Server)' Sep 23 02:09:58 ubuntu dotnet[384061]: [02:09:58 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:09:59 ubuntu dotnet[384061]: [02:09:59 INF] Executed DbCommand (1ms) [Parameters=[@__tenantId_0='?', @__classId_1='?'], CommandType='Text', CommandTimeout='30'] Sep 23 02:09:59 ubuntu dotnet[384061]: SELECT c."TenantId", c."Id", c."CreatedAt", c."DisplayName", c."Grade", c."RoomNumber" Sep 23 02:09:59 ubuntu dotnet[384061]: FROM "Classrooms" AS c Sep 23 02:09:59 ubuntu dotnet[384061]: WHERE c."TenantId" = @__tenantId_0 AND c."Id" = @__classId_1 Sep 23 02:09:59 ubuntu dotnet[384061]: LIMIT 1 Sep 23 02:09:59 ubuntu dotnet[384061]: [02:09:59 INF] Executed DbCommand (0ms) [Parameters=[@__notification_TenantId_0='?', @__notification_ClassId_1='?'], CommandType='Text', CommandTimeout='30'] Sep 23 02:09:59 ubuntu dotnet[384061]: SELECT d."Id", d."ClassroomId", d."CreatedAt", d."DeviceTokenHash", d."Hostname", d."InstallationId", d."IsActive", d."LastHeartbeatAt", d."RawDeviceToken", d."TenantId" Sep 23 02:09:59 ubuntu dotnet[384061]: FROM "Devices" AS d Sep 23 02:09:59 ubuntu dotnet[384061]: WHERE d."TenantId" = @__notification_TenantId_0 AND d."ClassroomId" = @__notification_ClassId_1 AND d."IsActive" Sep 23 02:09:59 ubuntu dotnet[384061]: [02:09:59 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:09:59 ubuntu dotnet[384061]: INSERT INTO "Notifications" ("Id", "ClassroomId", "CreatedAt", "DurationSeconds", "ExpiresAt", "Message", "Priority", "SenderName", "SenderUserId", "Shake", "TenantId", "Title", "Voice") Sep 23 02:09:59 ubuntu dotnet[384061]: VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12); Sep 23 02:09:59 ubuntu dotnet[384061]: INSERT INTO "NotificationReceipts" ("Id", "AcknowledgedAt", "DeviceId", "DeviceReceivedAt", "DisplayedAt", "FailedAt", "FailureReason", "NotificationId", "Status", "UpdatedAt") Sep 23 02:09:59 ubuntu dotnet[384061]: VALUES (@p13, @p14, @p15, @p16, @p17, @p18, @p19, @p20, @p21, @p22); Sep 23 02:09:59 ubuntu dotnet[384061]: INSERT INTO "NotificationReceipts" ("Id", "AcknowledgedAt", "DeviceId", "DeviceReceivedAt", "DisplayedAt", "FailedAt", "FailureReason", "NotificationId", "Status", "UpdatedAt") Sep 23 02:09:59 ubuntu dotnet[384061]: VALUES (@p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32); Sep 23 02:09:59 ubuntu dotnet[384061]: INSERT INTO "NotificationReceipts" ("Id", "AcknowledgedAt", "DeviceId", "DeviceReceivedAt", "DisplayedAt", "FailedAt", "FailureReason", "NotificationId", "Status", "UpdatedAt") Sep 23 02:09:59 ubuntu dotnet[384061]: VALUES (@p33, @p34, @p35, @p36, @p37, @p38, @p39, @p40, @p41, @p42); Sep 23 02:09:59 ubuntu dotnet[384061]: INSERT INTO "NotificationReceipts" ("Id", "AcknowledgedAt", "DeviceId", "DeviceReceivedAt", "DisplayedAt", "FailedAt", "FailureReason", "NotificationId", "Status", "UpdatedAt") Sep 23 02:09:59 ubuntu dotnet[384061]: VALUES (@p43, @p44, @p45, @p46, @p47, @p48, @p49, @p50, @p51, @p52); Sep 23 02:09:59 ubuntu dotnet[384061]: INSERT INTO "NotificationReceipts" ("Id", "AcknowledgedAt", "DeviceId", "DeviceReceivedAt", "DisplayedAt", "FailedAt", "FailureReason", "NotificationId", "Status", "UpdatedAt") Sep 23 02:09:59 ubuntu dotnet[384061]: VALUES (@p53, @p54, @p55, @p56, @p57, @p58, @p59, @p60, @p61, @p62); Sep 23 02:09:59 ubuntu dotnet[384061]: INSERT INTO "NotificationReceipts" ("Id", "AcknowledgedAt", "DeviceId", "DeviceReceivedAt", "DisplayedAt", "FailedAt", "FailureReason", "NotificationId", "Status", "UpdatedAt") Sep 23 02:09:59 ubuntu dotnet[384061]: VALUES (@p63, @p64, @p65, @p66, @p67, @p68, @p69, @p70, @p71, @p72); Sep 23 02:09:59 ubuntu dotnet[384061]: INSERT INTO "NotificationReceipts" ("Id", "AcknowledgedAt", "DeviceId", "DeviceReceivedAt", "DisplayedAt", "FailedAt", "FailureReason", "NotificationId", "Status", "UpdatedAt") Sep 23 02:09:59 ubuntu dotnet[384061]: VALUES (@p73, @p74, @p75, @p76, @p77, @p78, @p79, @p80, @p81, @p82); Sep 23 02:09:59 ubuntu dotnet[384061]: INSERT INTO "NotificationReceipts" ("Id", "AcknowledgedAt", "DeviceId", "DeviceReceivedAt", "DisplayedAt", "FailedAt", "FailureReason", "NotificationId", "Status", "UpdatedAt") Sep 23 02:09:59 ubuntu dotnet[384061]: VALUES (@p83, @p84, @p85, @p86, @p87, @p88, @p89, @p90, @p91, @p92); Sep 23 02:09:59 ubuntu dotnet[384061]: INSERT INTO "NotificationReceipts" ("Id", "AcknowledgedAt", "DeviceId", "DeviceReceivedAt", "DisplayedAt", "FailedAt", "FailureReason", "NotificationId", "Status", "UpdatedAt") Sep 23 02:09:59 ubuntu dotnet[384061]: VALUES (@p93, @p94, @p95, @p96, @p97, @p98, @p99, @p100, @p101, @p102); Sep 23 02:09:59 ubuntu dotnet[384061]: [02:09:59 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:09:59 ubuntu dotnet[384061]: [02:09:59 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:09:59 ubuntu dotnet[384061]: [02:09:59 INF] Executed action ClassNotify.Server.Controllers.NotificationController.SendNotification (ClassNotify.Server) in 717.4528ms Sep 23 02:09:59 ubuntu dotnet[384061]: [02:09:59 INF] Executed endpoint 'ClassNotify.Server.Controllers.NotificationController.SendNotification (ClassNotify.Server)' Sep 23 02:09:59 ubuntu dotnet[384061]: [02:09:59 INF] Request finished HTTP/1.1 POST https://classnotify.paradise.eu.org/api/notification/send - 200 null application/json; charset=utf-8 718.3714ms Sep 23 02:10:05 ubuntu dotnet[384061]: [02:10:05 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 02:10:05 ubuntu dotnet[384061]: 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:10:05 ubuntu dotnet[384061]: FROM "DeviceCommands" AS d Sep 23 02:10:05 ubuntu dotnet[384061]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 23 02:10:07 ubuntu systemd[1]: Stopping ClassNotify Cloud SignalR Server... Sep 23 02:10:07 ubuntu dotnet[384061]: [02:10:07 INF] Application is shutting down... Sep 23 02:10:07 ubuntu dotnet[384061]: [02:10:07 INF] Unregistered active device connection Teq520h-wT9XrbK4s_cSkg for Device dev_59e35e79 Sep 23 02:10:07 ubuntu dotnet[384061]: [02:10:07 INF] Device dev_59e35e79 disconnected for Tenant t_beijing_no4, Class cls_802 Sep 23 02:10:07 ubuntu dotnet[384061]: [02:10:07 INF] Executed endpoint '/hubs/device' Sep 23 02:10:07 ubuntu dotnet[384061]: [02:10:07 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/hubs/device?id=XOM5tW46wW5PDZRDcwrjHA - 101 null null 48404.8573ms Sep 23 02:10:07 ubuntu dotnet[384061]: [02:10:07 INF] DeviceCommandTimeoutWorker stopped. Sep 23 02:10:07 ubuntu systemd[1]: classnotify.service: Deactivated successfully. Sep 23 02:10:07 ubuntu systemd[1]: Stopped ClassNotify Cloud SignalR Server. Sep 23 02:10:07 ubuntu systemd[1]: classnotify.service: Consumed 7.276s CPU time. Sep 23 02:10:07 ubuntu systemd[1]: Started ClassNotify Cloud SignalR Server. Sep 23 02:10:08 ubuntu dotnet[384682]: [02:10:08 INF] Executed DbCommand (55ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 02:10:08 ubuntu dotnet[384682]: SELECT EXISTS ( Sep 23 02:10:08 ubuntu dotnet[384682]:     SELECT 1 FROM pg_catalog.pg_class c Sep 23 02:10:08 ubuntu dotnet[384682]:     JOIN pg_catalog.pg_namespace n ON n.oid=c.relnamespace Sep 23 02:10:08 ubuntu dotnet[384682]:     WHERE n.nspname='public' AND Sep 23 02:10:08 ubuntu dotnet[384682]:           c.relname='__EFMigrationsHistory' Sep 23 02:10:08 ubuntu dotnet[384682]: ) Sep 23 02:10:08 ubuntu dotnet[384682]: [02:10:08 INF] Executed DbCommand (5ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 02:10:08 ubuntu dotnet[384682]: SELECT "MigrationId", "ProductVersion" Sep 23 02:10:08 ubuntu dotnet[384682]: FROM "__EFMigrationsHistory" Sep 23 02:10:08 ubuntu dotnet[384682]: ORDER BY "MigrationId"; Sep 23 02:10:08 ubuntu dotnet[384682]: [02:10:08 INF] Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 02:10:08 ubuntu dotnet[384682]: SELECT EXISTS ( Sep 23 02:10:08 ubuntu dotnet[384682]:     SELECT 1 FROM pg_catalog.pg_class c Sep 23 02:10:08 ubuntu dotnet[384682]:     JOIN pg_catalog.pg_namespace n ON n.oid=c.relnamespace Sep 23 02:10:08 ubuntu dotnet[384682]:     WHERE n.nspname='public' AND Sep 23 02:10:08 ubuntu dotnet[384682]:           c.relname='__EFMigrationsHistory' Sep 23 02:10:08 ubuntu dotnet[384682]: ) Sep 23 02:10:08 ubuntu dotnet[384682]: [02:10:08 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 02:10:08 ubuntu dotnet[384682]: SELECT EXISTS ( Sep 23 02:10:08 ubuntu dotnet[384682]:     SELECT 1 FROM pg_catalog.pg_class c Sep 23 02:10:08 ubuntu dotnet[384682]:     JOIN pg_catalog.pg_namespace n ON n.oid=c.relnamespace Sep 23 02:10:08 ubuntu dotnet[384682]:     WHERE n.nspname='public' AND Sep 23 02:10:08 ubuntu dotnet[384682]:           c.relname='__EFMigrationsHistory' Sep 23 02:10:08 ubuntu dotnet[384682]: ) Sep 23 02:10:08 ubuntu dotnet[384682]: [02:10:08 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 02:10:08 ubuntu dotnet[384682]: SELECT "MigrationId", "ProductVersion" Sep 23 02:10:08 ubuntu dotnet[384682]: FROM "__EFMigrationsHistory" Sep 23 02:10:08 ubuntu dotnet[384682]: ORDER BY "MigrationId"; Sep 23 02:10:08 ubuntu dotnet[384682]: [02:10:08 INF] No migrations were applied. The database is already up to date. Sep 23 02:10:08 ubuntu dotnet[384682]: [02:10:08 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 02:10:08 ubuntu dotnet[384682]: SELECT EXISTS ( Sep 23 02:10:08 ubuntu dotnet[384682]:     SELECT 1 Sep 23 02:10:08 ubuntu dotnet[384682]:     FROM "Tenants" AS t Sep 23 02:10:08 ubuntu dotnet[384682]:     WHERE t."Id" = 'global') Sep 23 02:10:08 ubuntu dotnet[384682]: [02:10:08 INF] Production environment: Development seeding is strictly prohibited. Skipping. Sep 23 02:10:09 ubuntu dotnet[384682]: [02:10:09 INF] Executed DbCommand (7ms) [Parameters=[@__p_0='?'], CommandType='Text', CommandTimeout='30'] Sep 23 02:10:09 ubuntu dotnet[384682]: SELECT m."Id", m."Details", m."MigratedAt" Sep 23 02:10:09 ubuntu dotnet[384682]: FROM "MigrationMarkers" AS m Sep 23 02:10:09 ubuntu dotnet[384682]: WHERE m."Id" = @__p_0 Sep 23 02:10:09 ubuntu dotnet[384682]: LIMIT 1 Sep 23 02:10:09 ubuntu dotnet[384682]: [02:10:09 INF] JSON migration marker 'JsonMigration_v1' already exists (migrated at 09/20/2026 23:08:55 +00:00). Skipping migration. Sep 23 02:10:09 ubuntu dotnet[384682]: [02:10:09 INF] DeviceCommandTimeoutWorker started (CheckInterval: 10s) Sep 23 02:10:09 ubuntu dotnet[384682]: [02:10:09 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 02:10:09 ubuntu dotnet[384682]: 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:10:09 ubuntu dotnet[384682]: FROM "DeviceCommands" AS d Sep 23 02:10:09 ubuntu dotnet[384682]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 23 02:10:09 ubuntu dotnet[384682]: [02:10:09 INF] Now listening on: http://127.0.0.1:5000 Sep 23 02:10:09 ubuntu dotnet[384682]: [02:10:09 INF] Application started. Press Ctrl+C to shut down. Sep 23 02:10:09 ubuntu dotnet[384682]: [02:10:09 INF] Hosting environment: Production Sep 23 02:10:09 ubuntu dotnet[384682]: [02:10:09 INF] Content root path: /var/www/classnotify/releases/20260922-122247-28315D00 Sep 23 02:10:19 ubuntu dotnet[384682]: [02:10:19 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 02:10:19 ubuntu dotnet[384682]: 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:10:19 ubuntu dotnet[384682]: FROM "DeviceCommands" AS d Sep 23 02:10:19 ubuntu dotnet[384682]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 23 02:10:24 ubuntu dotnet[384682]: [02:10:24 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/api/health - null null Sep 23 02:10:24 ubuntu dotnet[384682]: [02:10:24 INF] Executing endpoint 'HTTP: GET /api/health' Sep 23 02:10:24 ubuntu dotnet[384682]: [02:10:24 INF] Executed DbCommand (4ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 02:10:24 ubuntu dotnet[384682]: SELECT 1 Sep 23 02:10:24 ubuntu dotnet[384682]: [02:10:24 INF] Setting HTTP status code 200. Sep 23 02:10:24 ubuntu dotnet[384682]: [02:10:24 INF] Writing value of type '<>f__AnonymousType28`6' as Json. Sep 23 02:10:24 ubuntu dotnet[384682]: [02:10:24 INF] Executed endpoint 'HTTP: GET /api/health' Sep 23 02:10:24 ubuntu dotnet[384682]: [02:10:24 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/api/health - 200 null application/json; charset=utf-8 111.466ms Sep 23 02:10:26 ubuntu dotnet[384682]: [02:10:26 INF] Request starting HTTP/1.1 POST http://classnotify.paradise.eu.org/hubs/device/negotiate?negotiateVersion=1 - null 0 Sep 23 02:10:26 ubuntu dotnet[384682]: [02:10:26 INF] Executing endpoint '/hubs/device/negotiate' Sep 23 02:10:26 ubuntu dotnet[384682]: [02:10:26 INF] Executed endpoint '/hubs/device/negotiate' Sep 23 02:10:26 ubuntu dotnet[384682]: [02:10:26 INF] Request finished HTTP/1.1 POST https://classnotify.paradise.eu.org/hubs/device/negotiate?negotiateVersion=1 - 200 316 application/json 10.505ms Sep 23 02:10:27 ubuntu dotnet[384682]: [02:10:27 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/hubs/device?id=8UAFHj19ZueXrxDvVLI8Qw - null null Sep 23 02:10:27 ubuntu dotnet[384682]: [02:10:27 INF] Executing endpoint '/hubs/device' Sep 23 02:10:28 ubuntu dotnet[384682]: [02:10:28 INF] Executed DbCommand (1ms) [Parameters=[@__deviceId_0='?', @__tokenHash_1='?'], CommandType='Text', CommandTimeout='30'] Sep 23 02:10:28 ubuntu dotnet[384682]: SELECT d."Id", d."ClassroomId", d."CreatedAt", d."DeviceTokenHash", d."Hostname", d."InstallationId", d."IsActive", d."LastHeartbeatAt", d."RawDeviceToken", d."TenantId" Sep 23 02:10:28 ubuntu dotnet[384682]: FROM "Devices" AS d Sep 23 02:10:28 ubuntu dotnet[384682]: WHERE d."Id" = @__deviceId_0 AND d."DeviceTokenHash" = @__tokenHash_1 AND d."IsActive" Sep 23 02:10:28 ubuntu dotnet[384682]: LIMIT 1 Sep 23 02:10:28 ubuntu dotnet[384682]: [02:10:28 INF] Device dev_59e35e79 connected via SignalR. ConnectionId=6_mRDZUv9nFFO58tBS9PlQ, IP=130.61.36.218 Sep 23 02:10:28 ubuntu dotnet[384682]: [02:10:28 INF] Device dev_59e35e79 authenticated successfully. Joined group t:t_beijing_no4:c:cls_802 at 6_mRDZUv9nFFO58tBS9PlQ Sep 23 02:10:28 ubuntu dotnet[384682]: [02:10:28 INF] Executed DbCommand (1ms) [Parameters=[@__tenantId_0='?', @__classId_1='?'], CommandType='Text', CommandTimeout='30'] Sep 23 02:10:28 ubuntu dotnet[384682]: SELECT c."TenantId", c."Id", c."CreatedAt", c."DisplayName", c."Grade", c."RoomNumber" Sep 23 02:10:28 ubuntu dotnet[384682]: FROM "Classrooms" AS c Sep 23 02:10:28 ubuntu dotnet[384682]: WHERE c."TenantId" = @__tenantId_0 AND c."Id" = @__classId_1 Sep 23 02:10:28 ubuntu dotnet[384682]: LIMIT 1 Sep 23 02:10:28 ubuntu dotnet[384682]: [02:10:28 INF] Executed DbCommand (3ms) [Parameters=[@__deviceId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 23 02:10:28 ubuntu dotnet[384682]: 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:10:28 ubuntu dotnet[384682]: FROM "NotificationReceipts" AS n Sep 23 02:10:28 ubuntu dotnet[384682]: INNER JOIN "Notifications" AS n0 ON n."NotificationId" = n0."Id" Sep 23 02:10:28 ubuntu dotnet[384682]: WHERE n."DeviceId" = @__deviceId_0 AND n."Status" = 'Sent' Sep 23 02:10:28 ubuntu dotnet[384682]: [02:10:28 INF] Device dev_59e35e79 connected with 1 pending notification(s) to catch up. Sep 23 02:10:28 ubuntu dotnet[384682]: [02:10:28 INF] Executed DbCommand (1ms) [Parameters=[@__deviceId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 23 02:10:28 ubuntu dotnet[384682]: 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:10:28 ubuntu dotnet[384682]: FROM "DeviceCommands" AS d Sep 23 02:10:28 ubuntu dotnet[384682]: WHERE d."DeviceId" = @__deviceId_0 AND d."Status" IN ('Pending', 'Dispatched') Sep 23 02:10:28 ubuntu dotnet[384682]: ORDER BY d."CreatedAt" Sep 23 02:10:29 ubuntu dotnet[384682]: [02:10:29 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 02:10:29 ubuntu dotnet[384682]: 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:10:29 ubuntu dotnet[384682]: FROM "DeviceCommands" AS d Sep 23 02:10:29 ubuntu dotnet[384682]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 23 02:10:29 ubuntu dotnet[384682]: [02:10:29 INF] Executed DbCommand (1ms) [Parameters=[@__messageId_0='?', @__tenantId_1='?', @__classroomId_2='?'], CommandType='Text', CommandTimeout='30'] Sep 23 02:10:29 ubuntu dotnet[384682]: SELECT EXISTS ( Sep 23 02:10:29 ubuntu dotnet[384682]:     SELECT 1 Sep 23 02:10:29 ubuntu dotnet[384682]:     FROM "Notifications" AS n Sep 23 02:10:29 ubuntu dotnet[384682]:     WHERE n."Id" = @__messageId_0 AND n."TenantId" = @__tenantId_1 AND n."ClassroomId" = @__classroomId_2) Sep 23 02:10:29 ubuntu dotnet[384682]: [02:10:29 INF] ACK validated from Tenant t_beijing_no4, Class cls_802 (Device dev_59e35e79): Message msg_1790129399317_1ab9 -> Delivered Sep 23 02:10:29 ubuntu dotnet[384682]: [02:10:29 INF] Executed DbCommand (1ms) [Parameters=[@__messageId_0='?', @__authenticatedDeviceId_1='?'], CommandType='Text', CommandTimeout='30'] Sep 23 02:10:29 ubuntu dotnet[384682]: SELECT n."Id", n."AcknowledgedAt", n."DeviceId", n."DeviceReceivedAt", n."DisplayedAt", n."FailedAt", n."FailureReason", n."NotificationId", n."Status", n."UpdatedAt" Sep 23 02:10:29 ubuntu dotnet[384682]: FROM "NotificationReceipts" AS n Sep 23 02:10:29 ubuntu dotnet[384682]: WHERE n."NotificationId" = @__messageId_0 AND n."DeviceId" = @__authenticatedDeviceId_1 Sep 23 02:10:29 ubuntu dotnet[384682]: LIMIT 1 Sep 23 02:10:29 ubuntu dotnet[384682]: [02:10:29 INF] Executed DbCommand (3ms) [Parameters=[@p4='?', @p0='?' (DbType = DateTime), @p1='?' (DbType = DateTime), @p2='?', @p3='?' (DbType = DateTime)], CommandType='Text', CommandTimeout='30'] Sep 23 02:10:29 ubuntu dotnet[384682]: UPDATE "NotificationReceipts" SET "DeviceReceivedAt" = @p0, "DisplayedAt" = @p1, "Status" = @p2, "UpdatedAt" = @p3 Sep 23 02:10:29 ubuntu dotnet[384682]: WHERE "Id" = @p4; Sep 23 02:10:38 ubuntu dotnet[384682]: [02:10:38 INF] Executed DbCommand (1ms) [Parameters=[@__p_0='?'], CommandType='Text', CommandTimeout='30'] Sep 23 02:10:38 ubuntu dotnet[384682]: SELECT d."Id", d."ClassroomId", d."CreatedAt", d."DeviceTokenHash", d."Hostname", d."InstallationId", d."IsActive", d."LastHeartbeatAt", d."RawDeviceToken", d."TenantId" Sep 23 02:10:38 ubuntu dotnet[384682]: FROM "Devices" AS d Sep 23 02:10:38 ubuntu dotnet[384682]: WHERE d."Id" = @__p_0 Sep 23 02:10:38 ubuntu dotnet[384682]: LIMIT 1 Sep 23 02:10:38 ubuntu dotnet[384682]: [02:10:38 INF] Executed DbCommand (2ms) [Parameters=[@p1='?', @p0='?' (DbType = DateTime)], CommandType='Text', CommandTimeout='30'] Sep 23 02:10:38 ubuntu dotnet[384682]: UPDATE "Devices" SET "LastHeartbeatAt" = @p0 Sep 23 02:10:38 ubuntu dotnet[384682]: WHERE "Id" = @p1; Sep 23 02:10:39 ubuntu dotnet[384682]: [02:10:39 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 02:10:39 ubuntu dotnet[384682]: 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:10:39 ubuntu dotnet[384682]: FROM "DeviceCommands" AS d Sep 23 02:10:39 ubuntu dotnet[384682]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 23 02:10:39 ubuntu dotnet[384682]: [02:10:39 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:10:39 ubuntu dotnet[384682]: [02:10:39 INF] Executing endpoint 'ClassNotify.Server.Controllers.NotificationController.GetNotificationHistory (ClassNotify.Server)' Sep 23 02:10:39 ubuntu dotnet[384682]: [02:10:39 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:10:39 ubuntu dotnet[384682]: [02:10:39 INF] Executed DbCommand (2ms) [Parameters=[@__tenantId_0='?', @__classId_1='?', @__p_2='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30'] Sep 23 02:10:39 ubuntu dotnet[384682]: 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:10:39 ubuntu dotnet[384682]: FROM ( Sep 23 02:10:39 ubuntu dotnet[384682]:     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:10:39 ubuntu dotnet[384682]:     FROM "Notifications" AS n Sep 23 02:10:39 ubuntu dotnet[384682]:     WHERE n."TenantId" = @__tenantId_0 AND n."ClassroomId" = @__classId_1 Sep 23 02:10:39 ubuntu dotnet[384682]:     ORDER BY n."CreatedAt" DESC Sep 23 02:10:39 ubuntu dotnet[384682]:     LIMIT @__p_2 Sep 23 02:10:39 ubuntu dotnet[384682]: ) AS t Sep 23 02:10:39 ubuntu dotnet[384682]: LEFT JOIN "NotificationReceipts" AS n0 ON t."Id" = n0."NotificationId" Sep 23 02:10:39 ubuntu dotnet[384682]: ORDER BY t."CreatedAt" DESC, t."Id" Sep 23 02:10:39 ubuntu dotnet[384682]: [02:10:39 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 23 02:10:39 ubuntu dotnet[384682]: SELECT c."TenantId", c."Id", c."CreatedAt", c."DisplayName", c."Grade", c."RoomNumber" Sep 23 02:10:39 ubuntu dotnet[384682]: FROM "Classrooms" AS c Sep 23 02:10:39 ubuntu dotnet[384682]: [02:10:39 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:10:39 ubuntu dotnet[384682]: [02:10:39 INF] Executed action ClassNotify.Server.Controllers.NotificationController.GetNotificationHistory (ClassNotify.Server) in 74.0489ms Sep 23 02:10:39 ubuntu dotnet[384682]: [02:10:39 INF] Executed endpoint 'ClassNotify.Server.Controllers.NotificationController.GetNotificationHistory (ClassNotify.Server)' Sep 23 02:10:39 ubuntu dotnet[384682]: [02:10:39 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 139.8803ms Sep 23 02:10:44 ubuntu dotnet[384682]: [02:10:44 INF] Executed DbCommand (1ms) [Parameters=[@__messageId_0='?', @__tenantId_1='?', @__classroomId_2='?'], CommandType='Text', CommandTimeout='30'] Sep 23 02:10:44 ubuntu dotnet[384682]: SELECT EXISTS ( Sep 23 02:10:44 ubuntu dotnet[384682]:     SELECT 1 Sep 23 02:10:44 ubuntu dotnet[384682]:     FROM "Notifications" AS n Sep 23 02:10:44 ubuntu dotnet[384682]:     WHERE n."Id" = @__messageId_0 AND n."TenantId" = @__tenantId_1 AND n."ClassroomId" = @__classroomId_2) Sep 23 02:10:44 ubuntu dotnet[384682]: [02:10:44 INF] ACK validated from Tenant t_beijing_no4, Class cls_802 (Device dev_59e35e79): Message msg_1790129399317_1ab9 -> Timeout Sep 23 02:10:44 ubuntu dotnet[384682]: [02:10:44 INF] Executed DbCommand (1ms) [Parameters=[@__messageId_0='?', @__authenticatedDeviceId_1='?'], CommandType='Text', CommandTimeout='30'] Sep 23 02:10:44 ubuntu dotnet[384682]: SELECT n."Id", n."AcknowledgedAt", n."DeviceId", n."DeviceReceivedAt", n."DisplayedAt", n."FailedAt", n."FailureReason", n."NotificationId", n."Status", n."UpdatedAt" Sep 23 02:10:44 ubuntu dotnet[384682]: FROM "NotificationReceipts" AS n Sep 23 02:10:44 ubuntu dotnet[384682]: WHERE n."NotificationId" = @__messageId_0 AND n."DeviceId" = @__authenticatedDeviceId_1 Sep 23 02:10:44 ubuntu dotnet[384682]: LIMIT 1 Sep 23 02:10:44 ubuntu dotnet[384682]: [02:10:44 INF] Executed DbCommand (2ms) [Parameters=[@p2='?', @p0='?', @p1='?' (DbType = DateTime)], CommandType='Text', CommandTimeout='30'] Sep 23 02:10:44 ubuntu dotnet[384682]: UPDATE "NotificationReceipts" SET "Status" = @p0, "UpdatedAt" = @p1 Sep 23 02:10:44 ubuntu dotnet[384682]: WHERE "Id" = @p2;