Notification are sent over and over again

[madmas]

I reported this already to nextcloud/server#20286 before I realized now that it seems to be cause by this app. Please refer to that issue for details.

Trying to find the cause, I could find out that the events are not deleted from the events queue in "activity_mq" table.

Also, "amq_last_send" is not updated, it's always the same as "amq_timestamp".

Finally I cloud solve this after adding some debug statements to MailQueueHandler.php .
With these statements I got aware that there are timeouts happening when mail were put to SMTP. The timeouts also caused that send notification were not deleted from the queue table.

I suggest to merge the debug log statements in the code so that the debug level show actual helpful output.

[flagmonkey]

We got this kind of problem in an 18.0.1.3 installation. There is one user who gets about 60 mails on a daily basis without any activity in the activity timeline (content of the e-mails is the same). Not sure how to fix this without editing MailQueueHandler.php by hand.

Let me know if i can help, we would be glad if this is a bug and will be fixed in future releases.

[stefangweichinger]

Seems I have the same problem in nextcloud/docker#1156
Deleted entries from table activity_mq, waiting to see if it stays silent now.
Additional question: why does the user get the email if there's a SMTP issue?

btw: we have nextcloud:18.0.6 docker image here

[stefangweichinger]

Maybe too simple ;-) We silenced the issue by configuring:

# config.php
"mail_smtptimeout" => 30,

This seems to help with the timeouts ... and in turn we get rid of the notifications.
Of course it would help to have meaningful debug messages in case of SMTP timeouts (the default value is what? 2 seconds?).