Upgrade 0.47.7 to 0.48.5 causes duplicate listing of dashboard names

Bug reports
1

HI,

Just upgraded to 0.48.5 from 0.47.7 and i am seeing double/triple :slight_smile: in some collections, some dashboard names are shown several times (2-3 times), but the links point to the same dashboard.

Sometimes, editing the dashboard (no changes, just "edit" then "save") made the duplicate disappear, but not always...

Any ideas on how to clean this ?

image

Running Metabase as a service on Debian 18.04 with latest JDK

# java --version
openjdk 21.0.2 2024-01-16 LTS
OpenJDK Runtime Environment Microsoft-8905927 (build 21.0.2+13-LTS)
OpenJDK 64-Bit Server VM Microsoft-8905927 (build 21.0.2+13-LTS, mixed mode, sharing)
# cat /etc/systemd/system/metabase.service
[Unit]
Description=Metabase server
After=syslog.target
After=network.target

[Service]
WorkingDirectory=/opt/metabase/
#ExecStart=/usr/bin/java -jar /opt/metabase/v0.47.7/metabase.jar
ExecStart=/usr/bin/java -jar /opt/metabase/v0.48.5/metabase.jar
EnvironmentFile=/etc/default/metabase
User=metabase
Type=simple
StandardOutput=syslog
StandardError=syslog
SyslogIdentifier=metabase
SuccessExitStatus=143
TimeoutStopSec=120
Restart=always

[Install]
WantedBy=multi-user.target

Thanks,
Gabriel

2

Do you see actually duplicate rows in the dashboard table in the database?

3

I can check this, but i don't know in which table to look into...

4

Found it:

Metabase screen:

image
image1355×442 49.8 KB

PHPMyAdmin:

image
image1551×586 60.4 KB

Noticed that, if i edit the dashboard name, add a character, then remove it, it cleans up:

image
image1354×186 14.8 KB

5

Same here, I also found some duplicates after updating from 0.47.6
After the update, it also set "Last Updated Date" to the date of the update (for all questions/dashboards). Which is embarrassing, now I don't recognize the old questions...

6

same thread as Questions and Dashboards Duplicated in UI

unfortunately we need to find a way to reproduce this

@gabriel.moscalu seems that the DB has unique dashboards, is that correct? then this should be a frontend issue

7

Hi @dragonsahead

i tend to agree with you: the DB records look OK, it's probably a matter of frontend...

Maybe a way to clear the caches & reload everything from DB might help, or maybe a way to clean restart?

8

Any solutions on this? This happened to me as well earlier in the year, and have just updated to 0.49.1 hoping it would resolve it without luck. To add to this, if you pin a dashboard in a collection, it duplicates as well.

{
"browser-info": {
"language": "en-US",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "Cp1252",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.13+8",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.13",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.13+8",
"os.name": "Windows Server 2019",
"os.version": "10.0",
"user.language": "en",
"user.timezone": "Australia/Sydney"
},
"metabase-info": {
"databases": [
"sqlserver",
"mysql"
],
"hosting-env": "unknown",
"application-database": "mysql",
"application-database-details": {
"database": {
"name": "MySQL",
"version": "8.0.33"
},
"jdbc-driver": {
"name": "MariaDB Connector/J",
"version": "2.7.10"
}
},
"run-mode": "prod",
"version": {
"date": "2024-03-21",
"tag": "v0.49.1",
"hash": "54ef5e9"
},
"settings": {
"report-timezone": "Australia/Victoria"
}
}
}