Symptoms
Notifications are not sent after migration to CentOS 7. The following entries can be found in billing.log:
[17-04-21 13:24:45.241 billing RQ65769 TH03069 NTE] [29855] Exclusively locking a row (MailID=2497528) in table MailMsg
[17-04-21 13:24:45.241 RDBMS RQ65769 TH03069 INF] Prepare [0x7f72785a9f60]: SELECT "MailID", "Direction", "Status", "CollectorID", "To", "From", "Subject", "Comment", "Message", "UserArc", "DateArc" FROM "MailMsg" WHERE "MailID" = $1 FOR UPDATE
[17-04-21 13:24:45.241 RDBMS RQ65769 TH03069 INF] Execute [0x7f72785a9f60]: 2497528
[17-04-21 13:24:45.241 RDBMS RQ65769 TH03069 INF] Service execute [0x7f7278164cb0_0]: BEGIN (implicit on previous command)
[17-04-21 13:24:45.243 RDBMS RQ65769 TH03069 DBG] Fetch [0x7f72785a9f60]: 2497528, 2, 12, <NULL>, <NULL>, 'Provider <no-reply@provider.com>', 'Payemnt 1,440.00 USD received', 'mailsmtp_data failed with code error 14:'Transaction failed'', <BLOB>, -1, 1492765920
[17-04-21 13:24:45.272 billing RQ65769 TH03069 FTL] Terminated; Minidump: /usr/local/bm/var/dump/00000b81-0fdc-38d8-2aea10ce-0df69f90.dmp
Cause
The issue #PBA-80225 "Notifications are not sent and AMAIL container crashes Billing when "To" in "MailMsg" is empty"
Resolution .
For a workaround, please, refer to the following KB article.