External Recipients are randomly removed from question alerts

Bug reports
1

Running v0.49.2, Open Source
I have created a question, and added a couple of daily alerts to it. One is to an internal manager, and the other is to a customer rep, and two contacts at the customer.
Everything seems fine for a few days, and then randomly the two customer contacts are removed from the alert and stop receiving daily emails.

None of the internal users are affected. The length of time between when the external users are set up in the alert, and when they disappear is inconsistent.

{
"browser-info": {
"language": "en-US",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "17.0.2+8",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "17.0.2",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "17.0.2+8",
"os.name": "Linux",
"os.version": "4.14.273-207.502.amzn2.x86_64",
"user.language": "en",
"user.timezone": "UTC"
},
"metabase-info": {
"databases": [
"mysql",
"snowflake",
"athena"
],
"hosting-env": "unknown",
"application-database": "mysql",
"application-database-details": {
"database": {
"name": "MySQL",
"version": "8.0.32"
},
"jdbc-driver": {
"name": "MariaDB Connector/J",
"version": "2.7.10"
}
},
"run-mode": "prod",
"version": {
"date": "2024-03-28",
"tag": "v0.49.2",
"hash": "4b83b88"
},
"settings": {
"report-timezone": "America/New_York"
}
}
}

2

what do you mean by customer contacts? can you also upgrade to the latest version 49.11 please

3

Customer contacts = emails that are not set up as users on our instance. For example, when I put my name on an alert, I see 'ryanr', but for external recipients it's 'person@external.com'

4

Is it possible someone else is tweeking those subscription?

Do you have access to the Application Database? Can you check the Activity table and check if anything else is tweeking with the subscription setting ... also check the Pulse Table for the Updated At column to check if there where any updates to that subscription

5

As of version 0.48 those tables are only available on the Pro and Enterprise versions, and we're running the open source.
As for whether someone else is changing the settings, I don't think so--it's happened twice, and it's been addressed with everyone involved in this particular report.
I'm trying to reproduce the issue on a question from my personal space, but no dice so far.

Is it possible that it's automatically removing bounced emails, etc from the subscription? I know the addresses are good, but in communicating with the recipients there was something they had to do vis-a-vis getting them to come through their company's email filter.

6

nope, Metabase won't listen to bounce emails, as it doesn't have any functionality on the email side other than sending

7

We're on Enterprise v1.50.26 and face the same issue. We have an email report that goes out and one of the recipients (external) get removed every now and then, which is super weird behavior. Given that no one else has access to the collection, I'm certain that no one else has messed with it.

8

They could be clicking on unsubscribe on the email