Issue Summary

The JSM mail handler stops processing emails when it encounters an email with a sender address that exceeds 255 characters.

Steps to Reproduce

1. Send an email to the mailbox configured in the JSM mail handler, having a sender's address that exceeds 255 characters.

Expected Results

The email is processed by the JSM mail handler.

Actual Results

The email is not processed by the JSM mail handler, which stops the processing of all subsequent emails.

The incoming mail logs show the following error:

2025-01-22 14:16:01,567+0000 ERROR [] Caesium-1-3 ServiceRunner     Exception when MailPullerWorker pulls emails: 
com.querydsl.core.QueryException: Caught MysqlDataTruncation for insert into `AO_2C4E5C_MAILITEM` (`MAIL_CONNECTION_ID`, `STATUS`, `CREATED_TIMESTAMP`, `UPDATED_TIMESTAMP`, `FROM_ADDRESS`, `SUBJECT`) values (?, ?, ?, ?, ?, ?) 

Workaround

1. Manually increase the size for the FROM_ADDRESS column. Here is an example statement for MySQL:

   ALTER TABLE AO_2C4E5C_MAILITEM 
   

   MODIFY

   FROM_ADDRESS varchar(500);

    Keep in mind that this column size will be modified to its original value as soon you restart Jira or execute an upgrade so don't forget to apply the workaround again

1. Remove the email that has the exceeding Sender address size from the mailbox.

Versions Tested