Table structure not syncing

It seems that i cannot update the table structure of a SQLite database :

  • when adding columns, they show up with a select * from table but cannot be found anywhere when exploring the raw data or using the visual editor...
  • when removing a column for testing purposes, it does not show up anymore in the sql query, but still appears in the visual editor, in the raw data explorer, in the table metadata structure

Every other row data still updates whenever any change is made so it's only a column structure problem.

Am i missing something ?

{
  "browser-info": {
    "language": "fr-FR",
    "platform": "Linux x86_64",
    "userAgent": "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.24+8-post-Debian-2deb11u1",
    "java.vendor": "Debian",
    "java.vendor.url": "https://tracker.debian.org/openjdk-11",
    "java.version": "11.0.24",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.24+8-post-Debian-2deb11u1",
    "os.name": "Linux",
    "os.version": "5.10.0-32-amd64",
    "user.language": "fr",
    "user.timezone": "Europe/Paris"
  },
  "metabase-info": {
    "databases": [
      "h2",
      "mysql",
      "sqlite"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "13.16 (Debian 13.16-0+deb11u1)"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.7.2"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2024-05-28",
      "tag": "v0.49.13",
      "hash": "de28e83"
    },
    "settings": {
      "report-timezone": null
    }
  }
}

force a sync, and also please upgrade to v50.30

The only way i know is going in admin > database > sync and i've done it a thousand times... Is there any other way ?

I cannot yet as Yunohost package is not available in 50.30

Any update on what solution i might try ?

please check the api calls to see if the columns return when you use SQL

Thanks for the reply but i have no idea what you're talking about.
It works fine when i call the database with a select * from table and shows the current structure, when using the admin panel to explore data or sync the database it is stuck with the structure that was first scanned when adding the database to metabase.

I think this might be related to this issue : sqlite tables over 500 columns don't sync.

My annoying table is 462 columns wide (and growing) but Grist uses gristhelper columns for internal purposes and there are about 40 of them, so that sums up to over 500...

The table structure problem is kind of solved : it was indeed the number of columns that were messing with the update in metabase.

Now that i have cut down columns, tables do sync but any change i make to metadata, questions or models is EXTREMELY slow. Like 30 to 40 seconds for one metadata type change. Browser hangs, asks if i want to kille the page and suddenly it comes back to life.

Nothing suspicious in the logs. Database is pretty much the same as it was before... I tried deleting it and adding it back again so it would rescan from scratch but no change.

Is there anything i can do ?


EDIT : turns out having a model with 400 columns in it is kinda slow. What a surprise.