Subversion Repositories SmartDukaan

-- Retire the SENDGRID sender label from dtr.mail_outbox.

--

-- SENDGRID never meant SendGrid. MailOutboxService.resolveSender() routed it to

-- the Google Workspace relay, same as RELAY -- which is why outbox mail kept

-- being delivered while code that injected a JavaMailSender directly failed

-- against the real (and dead) SendGrid bean.

--

-- Relabelling therefore changes no behaviour: these rows were already being sent

-- through the relay. It removes a label that named a provider we do not use.

--

-- APPLIED TO PRODUCTION (hadb1) 2026-08-31 18:10 IST.

--   before: SENDGRID=5956  RELAY=0     GOOGLE=4896  (total 10852)

--   after:  SENDGRID=0     RELAY=5956  GOOGLE=4896  (total 10852)

--   backup: dtr.mail_outbox_sendgrid_backup_20260831_1810 (5956 rows)

--

-- The single PENDING row (id=26838) migrated cleanly and still routes to the

-- relay, exactly as it would have before.

-- 1. Back up what is about to change.

CREATE TABLE dtr.mail_outbox_sendgrid_backup_20260831_1810 AS

SELECT id, sender_type, status, created_at

FROM dtr.mail_outbox

WHERE sender_type = 'SENDGRID';

-- 2. Relabel.

UPDATE dtr.mail_outbox

SET sender_type = 'RELAY'

WHERE sender_type = 'SENDGRID';

-- 3. Verify: expect SENDGRID=0 and only GOOGLE,RELAY remaining.

SELECT sender_type, COUNT(*) FROM dtr.mail_outbox GROUP BY sender_type;

-- Rollback, should it ever be needed:

--   UPDATE dtr.mail_outbox o

--     JOIN dtr.mail_outbox_sendgrid_backup_20260831_1810 b ON b.id = o.id

--     SET o.sender_type = b.sender_type;