A user receives a lot of multiple doubling lines in a simple question

User1 set up a Metabase project with a link to own database. Another User2 creates a query via NEW -> SQLQuery -> chooses a table, filter it by column1, filter by column2 -> and receives a lot of totally equal lines, which is incorrect, because there is only one line in the DB, which meets the filters. The User1 makes the same steps - chooses the same table, apply the same filters and receives exactly one row (which is correct).

The User2 can give a link to a question to User1 - User1 also sees a lot of lines!

User1 sends the link to User2 - User2 sees the 1 line!

So there is a local problem of User2 which shows a lot of lines. This is just some visual bug which can be reproduced by someone else only when they goes via a link to bugged view.

User2 tried to clean and remove cashes, use another browser - no result.

What can cause such a wired behavior? And what else can we do to get rid of duplicate lines by Useer2?

Hi @glamps_evo

Post "Diagnostic Info" from Admin > Troubleshooting.

Sounds like the different users are doing something differently, or querying different databases.

User1

Summary

{
"browser-info": {
"language": "ru-RU",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:101.0) Gecko/20100101 Firefox/101.0",
"vendor": ""
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.14.1+1",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.14.1",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.14.1+1",
"os.name": "Linux",
"os.version": "5.4.0-100-generic",
"user.language": "en",
"user.timezone": "UTC"
},
"metabase-info": {
"databases": [
"postgres"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "14.1 (Ubuntu 14.1-201-yandex.52142.672784f35a)"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.23"
}
},
"run-mode": "prod",
"version": {
"date": "2022-02-28",
"tag": "v0.42.2",
"branch": "release-x.42.x",
"hash": "d6ff494"
},
"settings": {
"report-timezone": "Europe/Moscow"
}
}
}

User2

Summary

{
"browser-info": {
"язык": "ru-RU",
"платформа": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, например Gecko) Chrome/102.0.0.0 Safari/537.36",
"vendor": "Google Inc."
}
}
"file.encoding": "UTF-8",
"java.runtime.name": "Среда выполнения OpenJDK",
"java.runtime.version": "11.0.14.1+1",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.14.1",
"java.vm.name": "Виртуальная машина 64-разрядного сервера OpenJDK" ,
"java.vm.version": "11.0.14.1+1",
"os.name": "Linux",
"os.version": "5.4.0-100-универсальный",
"user.language": " ru",
"user.timezone": "UTC"
},
"метабаза-информация": {
"базы данных": [
"postgres"
],
"hosting-env": "неизвестно",
"база данных приложений": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "14.1 (Ubuntu 14.1-201-yandex.52142.672784f35a)"
},
"jdbc-driver": {
" name": "PostgreSQL JDBC Driver",
"version": "42.2.23"
}
},
"run-mode": "prod",
"version": {
"date": "2022-02-28",
"tag ": "v0.42.2",
"ветка": "релиз-x.42.x",
"хэш": "d6ff494"
},
"settings": {
"report-timezone": "Европа/Москва"
}
}
}

This link on a view with single line

Summary

https://metabase.bpc.epoch8.co/question#eyJkYXRhc2V0X3F1ZXJ5Ijp7ImRhdGFiYXNlIjoyLCJxdWVyeSI6eyJzb3VyY2UtdGFibGUiOjg0LCJmaWx0ZXIiOlsiYW5kIixbIj0iLFsiZmllbGQiLDU4MCxudWxsXSwiOTkxNDQyNjQ5OCJdLFsiPSIsWyJmaWVsZCIsNTg1LG51bGxdLCIwNDIwMjIiXV19LCJ0eXBlIjoicXVlcnkifSwiZGlzcGxheSI6InRhYmxlIiwidmlzdWFsaXphdGlvbl9zZXR0aW5ncyI6e319

link to a view with multiple lines

Summary

https://metabase.bpc.epoch8.co/question#eyJuYW1lIjoi0JTQlyDQuCDQvdCw0YfQuNGB0LvQtdC90LjRjyIsImRlc2NyaXB0aW9uIjpudWxsLCJkYXRhc2V0X3F1ZXJ5Ijp7InR5cGUiOiJxdWVyeSIsInF1ZXJ5Ijp7ImZpbHRlciI6WyJhbmQiLFsiY29udGFpbnMiLFsiZmllbGQiLDU5NCx7InNvdXJjZS1maWVsZCI6NTgwfV0sIjk5MTQ0MjY0OTgiXSxbIj0iLFsiZmllbGQiLDU4NSxudWxsXSwiMDQyMDIyIl1dLCJzb3VyY2UtdGFibGUiOjg0fSwiZGF0YWJhc2UiOjJ9LCJkaXNwbGF5IjoidGFibGUiLCJkaXNwbGF5SXNMb2NrZWQiOnRydWUsInZpc3VhbGl6YXRpb25fc2V0dGluZ3MiOnsidGFibGUuY2VsbF9jb2x1bW4iOiJkZWJ0X3N0YXJ0IiwidGFibGUucGl2b3RfY29sdW1uIjoiYmlsbGluZ19wZXJpb2QifSwib3JpZ2luYWxfY2FyZF9pZCI6Mzd9

@glamps_evo User1 is filtering field = 9914426498, whereas User2 is filtering field 594 should contain 9914426498.

So the two users are using Metabase differently, making different queries, which means different results.
There's nothing wrong with Metabase, just how it is being used.
Since I can see that User2's diagnostic info is translated, then I'm guessing that's the problem. The inline browser translation is causing User2 to select a different filter.

could you please explain how do you know that Users are filtering different fields? And for this case it sounds more correct to filter field xxx for value 9914426498, than to filter field 9914426498 (this is the necessary value). And the more important thing is what table are they referring. Any way, there is no table in the DB where this line multiples for so many times.

I understand that the problem is somewhere on the User2 side, but still don't understand how to help with it...

@glamps_evo For both users, click the "View the SQL" button in the Notebook, perhaps that will help understanding the difference in the results.
User2 is filtering on a remapped field, from what I can tell, which means it's actually filtering according to another implicitly joined table.
Anyway, the queries are different between the users, so they see different results.

1 Like