Hi,
I have a problem appears recently.
There is a MailQueue table in my system and a column is named STATUS to
mark up whether this queue is sent or not.
But on Saturday(8/10 UTC+8) this queue sent the same mail with 105
times(and another for about 60 times).
There are no any error was found in GAE logs, and my own logs neither.
And it stopped sending when this problem was fixed by it self.
The send mail sequence is like to get one mail queue which is unsent, send
it, update column to SENT and return sent message which will be logged.
The result is the mail was sent and the message was logged, but the column
was not updated. It never happened before.
I just can't find out what's the problem.
Right now I have fixed this issue with logging to another table,
MailSentLogs. and check if there is a log for this mail queue or not.
The weird thing is that the insert action is totally works fine but the
update is not.
Although it will not sent repeatedly but the column still have chance to be
unable to update.
The MailQueue will be generated everyday, and the number is about 135.
Here's my codes:
//remark if it was sent or not
String remark = "(sent)";
//check if there's already a sent log to prevent sent repeatedly
if( !mailSentLogsHandler.isDuplicated(mailSentLogsDAO, mailQueueUUID) ){
//sent mail
mail.sendHTML();
remark = "(sent nothing)";
}
//This is the problem, sometimes it can't be updated but no error was
found.
mailQueueHandler.updateSending(mailQueueDAO, mailQueue);
//insert log
mailSentLogsHandler.insertWithCheck(mailSentLogsDAO, contractUUID,
mailQueueUUID, assignDayStart);
//return messages.
request.setAttribute("message", new JsonMessageBean("success", "Mail was
sent successfully." + remark + " contractId - " +
contract.getContractId()).toJson());
Any help will be appreciate.
Thanks.
Brandon
--
You received this message because you are subscribed to the Google Groups
"Google App Engine" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/google-appengine.
For more options, visit https://groups.google.com/groups/opt_out.
