HI,
Just upgraded to 0.48.5 from 0.47.7 and i am seeing double/triple 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 ?
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
Luiggi
February 15, 2024, 3:27am
2
Do you see actually duplicate rows in the dashboard table in the database?
I can check this, but i don't know in which table to look into...
Found it:
Metabase screen:
PHPMyAdmin:
Noticed that, if i edit the dashboard name, add a character, then remove it, it cleans up:
CZvacko
February 22, 2024, 9:26am
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...
Luiggi
February 27, 2024, 1:28am
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
Hi @Luiggi
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?
amosm
March 24, 2024, 8:21am
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"
}
}
}