Pulse sending duplicate blank emails

Problem: A non-admin user modified a single email Pulse on 7/10 to email to an additional address that belonged to a non-metabase user.

After that change, we began received 2 emails for every Pulse we had setup (not just the modified one). First email contained all the correct data. Second email contains no results. Emails are several hours apart…

Troubleshooting: I deleted all of the Pulses and now we are receiving one set of emails for each Pulse that previously existed, with no results in the email.

Let me know if you need logs or additional info.

Do you see anything in the logs around the time the email is sent?

Also, can you access the application database and see what’s in you pulse table?

I have h2 console setup but having trouble finding the correct connection string. I tried
URL jdbc:h2:home/centos/metabase.db.h2.db

Hey Metabase team - Any guidance here?

This might sound really stupid, but the only time I’ve seen this occur is when there is another instance running, perhaps on someone’s laptop. This might be a consequence of the fact that we run 10+ instances internally.

Otherwise, can you give us more info on the Metabase version, what platform you’re running it on, and can you copy/paste the server logs at around the time this is happening?

Hi Sameer,

Sorry to intrude here. Can you please help me out with this issue.

Appreciate and Thanks

I thought duplicate processes might be the case too (but then I’d expect data in both emails).
[centos@ip-10-0-0-30 ~]$ ps -aux | grep “metabase”
root 2149 0.4 38.0 2644832 715976 ? Sl Jul25 14:55 java -jar /home/centos/metabase.jar
centos 23582 0.0 0.0 112644 956 pts/0 R+ 18:50 0:00 grep --color=auto metabase

Most recent email was at 2:07pm EST. I’ll get the logs. DM me your email and I can send them to you there.

Metabase v0.18.0 (upgraded before, but still had this problem)
CentOS Linux release 7.2.1511 (Core)

Also, I’m still up for clearing the Pulse table. i just need help with the connection details. I think I have the connection URL correct, but then the username/pass is up for debate

[centos@ip ~]$ pwd
[centos@ip ~]$ ll
total 178620
-rw-rw-r–. 1 centos centos 1775801 Jul 21 20:02 h2-1.4.192.jar
-rw-rw-rw-. 1 centos centos 10350592 May 26 00:48 metabase.db.h2.db
-rw-rw-r–. 1 centos centos 12288 Jul 21 20:11 metabase.db.h2.db.mv.db
-rw-rw-r–. 1 centos centos 428 Jul 21 20:11 metabase.db.h2.db.trace.db
-rw-rw-rw-. 1 centos centos 187 Mar 25 16:42 metabase.db.trace.db
-rw-r–r--. 1 centos centos 85373691 Jun 21 00:32 metabase.jar
lrwxrwxrwx. 1 centos centos 30 Jun 20 16:06 metabase.log -> /var/log/metabase/metabase.log
-rw-r–r--. 1 root root 85375549 Jul 12 17:56 metabase_v0.18.1.jar
[centos@ip ~]$ java -cp h2*.jar org.h2.tools.Shell

Welcome to H2 Shell 1.4.192 (2016-05-26)
Exit with Ctrl+C
[Enter] jdbc:h2:~/test
URL jdbc:h2:tcp://localhost/~/metabase
[Enter] org.h2.Driver
[Enter] Hide
SQL Exception: Connection is broken: “java.net.ConnectException: Connection refused: localhost” [90067-192]