info: Redis not configured, continuing without cache {"service":"cbc-sms","timestamp":"2026-07-16 03:48:10"}
info: Testing database connection... {"service":"cbc-sms","timestamp":"2026-07-16 03:48:12"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT 1+1 AS result","service":"cbc-sms","timestamp":"2026-07-16 03:48:12"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT 1+1 AS result","service":"cbc-sms","timestamp":"2026-07-16 03:48:12"}
info: ✓ Sequelize database connection established successfully {"service":"cbc-sms","timestamp":"2026-07-16 03:48:12"}
info: ✓ Database connected successfully {"service":"cbc-sms","timestamp":"2026-07-16 03:48:12"}
info: ✓ Database schema loaded (models initialized) {"service":"cbc-sms","timestamp":"2026-07-16 03:48:12"}
✅ Socket.IO instance set for NotificationService
info: ✅ Socket.IO initialized for real-time notifications {"service":"cbc-sms","timestamp":"2026-07-16 03:48:12"}
info: ✅ Scheduled Messages cron job initialized (runs every minute) {"service":"cbc-sms","timestamp":"2026-07-16 03:48:12"}
info: ============================================================ {"service":"cbc-sms","timestamp":"2026-07-16 03:48:12"}
info: 🚀 CBC SMS Server started successfully {"service":"cbc-sms","timestamp":"2026-07-16 03:48:12"}
info: 📍 Environment: development {"service":"cbc-sms","timestamp":"2026-07-16 03:48:12"}
info: 🌐 Server: http://0.0.0.0:5001 {"service":"cbc-sms","timestamp":"2026-07-16 03:48:12"}
info: 💾 Database: Connected (Sequelize ORM) {"service":"cbc-sms","timestamp":"2026-07-16 03:48:12"}
info: ✨ Tables: 137 models loaded {"service":"cbc-sms","timestamp":"2026-07-16 03:48:12"}
info: ============================================================ {"service":"cbc-sms","timestamp":"2026-07-16 03:48:12"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 03:49:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 03:49:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 03:49:00"}
http: 127.0.0.1 - - [16/Jul/2026:00:49:30 +0000] "GET /api/health HTTP/1.1" 404 61 "-" "curl/7.76.1" {"service":"cbc-sms","timestamp":"2026-07-16 03:49:30"}
info: HTTP_REQUEST {"durationMs":153.12,"ip":"127.0.0.1","method":"GET","path":"/api/health","requestId":"a9839d01-eea2-4126-ac9c-8432f4181505","schoolId":null,"service":"cbc-sms","status":404,"timestamp":"2026-07-16 03:49:30","userId":null}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 03:50:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 03:50:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 03:50:00"}
http: 127.0.0.1 - - [16/Jul/2026:00:50:05 +0000] "GET /health HTTP/1.1" 200 54 "-" "curl/7.76.1" {"service":"cbc-sms","timestamp":"2026-07-16 03:50:05"}
info: HTTP_REQUEST {"durationMs":3.23,"ip":"127.0.0.1","method":"GET","path":"/health","requestId":"7660a9c3-13f1-4fdb-8c4f-29c1f888da37","schoolId":null,"service":"cbc-sms","status":200,"timestamp":"2026-07-16 03:50:05","userId":null}
error: SyntaxError: Expected property name or '}' in JSON at position 1
    at JSON.parse (<anonymous>)
    at parse (/home/aereuxky/nodevenv/cbcsms-backend/20/lib/node_modules/body-parser/lib/types/json.js:96:19)
    at /home/aereuxky/nodevenv/cbcsms-backend/20/lib/node_modules/body-parser/lib/read.js:128:18
    at AsyncResource.runInAsyncScope (node:async_hooks:206:9)
    at invokeCallback (/home/aereuxky/nodevenv/cbcsms-backend/20/lib/node_modules/raw-body/index.js:238:16)
    at done (/home/aereuxky/nodevenv/cbcsms-backend/20/lib/node_modules/raw-body/index.js:227:7)
    at IncomingMessage.onEnd (/home/aereuxky/nodevenv/cbcsms-backend/20/lib/node_modules/raw-body/index.js:287:7)
    at IncomingMessage.emit (node:events:524:28)
    at endReadableNT (node:internal/streams/readable:1698:12)
    at process.processTicksAndRejections (node:internal/process/task_queues:82:21) {"service":"cbc-sms","timestamp":"2026-07-16 03:50:23"}
http: 127.0.0.1 - - [16/Jul/2026:00:50:39 +0000] "GET /api/v1/auth/login HTTP/1.1" 404 68 "-" "curl/7.76.1" {"service":"cbc-sms","timestamp":"2026-07-16 03:50:39"}
info: HTTP_REQUEST {"durationMs":5.31,"ip":"127.0.0.1","method":"GET","path":"/api/v1/auth/login","requestId":"7a1e43e2-1dfc-4b7b-8c50-b4ac441bfb91","schoolId":null,"service":"cbc-sms","status":404,"timestamp":"2026-07-16 03:50:39","userId":null}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 03:51:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 03:51:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 03:51:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 03:52:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 03:52:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 03:52:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 03:53:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 03:53:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 03:53:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 03:54:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 03:54:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 03:54:00"}
http: 127.0.0.1 - - [16/Jul/2026:00:54:20 +0000] "GET /health HTTP/1.1" 200 54 "-" "curl/7.76.1" {"service":"cbc-sms","timestamp":"2026-07-16 03:54:20"}
info: HTTP_REQUEST {"durationMs":2.26,"ip":"127.0.0.1","method":"GET","path":"/health","requestId":"cd011b4a-84d5-471c-af58-130857641a6e","schoolId":null,"service":"cbc-sms","status":200,"timestamp":"2026-07-16 03:54:20","userId":null}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 03:55:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 03:55:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 03:55:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 03:56:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 03:56:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 03:56:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 03:57:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 03:57:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 03:57:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 03:58:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 03:58:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 03:58:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 03:59:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 03:59:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 03:59:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:00:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:00:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:00:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:01:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:01:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:01:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:02:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:02:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:02:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:03:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:03:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:03:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:04:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:04:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:04:00"}
http: 127.0.0.1 - - [16/Jul/2026:01:04:37 +0000] "GET /api/health HTTP/1.1" 404 61 "-" "curl/7.76.1" {"service":"cbc-sms","timestamp":"2026-07-16 04:04:37"}
info: HTTP_REQUEST {"durationMs":3.3,"ip":"127.0.0.1","method":"GET","path":"/api/health","requestId":"50da239f-bcfe-4af1-a617-d0566fdf118d","schoolId":null,"service":"cbc-sms","status":404,"timestamp":"2026-07-16 04:04:37","userId":null}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:05:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:05:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:05:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:06:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:06:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:06:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:07:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:07:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:07:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:08:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:08:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:08:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:09:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:09:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:09:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:10:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:10:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:10:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:11:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:11:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:11:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:12:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:12:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:12:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:13:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:13:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:13:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:14:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:14:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:14:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:15:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:15:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:15:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:16:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:16:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:16:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:17:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:17:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:17:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:18:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:18:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:18:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:19:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:19:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:19:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:20:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:20:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:20:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:21:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:21:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:21:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:22:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:22:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:22:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:23:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:23:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:23:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:24:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:24:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:24:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:25:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:25:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:25:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:26:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:26:01"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:26:01"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:27:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:27:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:27:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:28:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:28:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:28:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:29:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:29:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:29:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:30:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:30:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:30:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:31:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:31:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:31:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:32:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:32:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:32:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:33:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:33:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:33:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:34:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:34:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:34:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:35:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:35:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:35:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:36:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:36:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:36:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:37:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:37:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:37:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:38:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:38:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:38:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:39:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:39:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:39:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:40:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:40:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:40:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:41:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:41:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:41:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:42:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:42:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:42:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:43:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:43:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:43:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:44:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:44:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:44:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:45:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:45:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:45:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:46:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:46:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:46:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:47:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:47:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:47:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:48:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:48:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:48:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:49:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:49:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:49:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:50:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:50:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:50:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:51:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:51:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:51:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:52:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:52:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:52:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:53:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:53:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:53:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:54:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:54:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:54:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:55:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:55:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:55:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:56:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:56:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:56:00"}
info: SEQUELIZE_QUERY {"query":"Executing (default): SELECT `id`, `school_id` AS `schoolId`, `channel`, `template_id` AS `templateId`, `subject`, `body`, `audience_filter` AS `audienceFilter`, `scheduled_at` AS `scheduledAt`, `status`, `sent_at` AS `sentAt`, `error_message` AS `errorMessage`, `sent_by_user_id` AS `sentByUserId`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `scheduled_messages` AS `ScheduledMessage` WHERE `ScheduledMessage`.`status` = 'pending' AND `ScheduledMessage`.`scheduled_at` <= '2026-07-16 04:57:00' LIMIT 50;","service":"cbc-sms","timestamp":"2026-07-16 04:57:00"}
info: [ScheduledMessages] No messages due for delivery {"service":"cbc-sms","timestamp":"2026-07-16 04:57:00"}