I'm not getting an error. Hovering over the 'switch' changes the mouse pointer correctly, but clicking doesn't do anything. It's just the one database. I need to check write privileges (today is supposed to be a day off, so may wait until Monday!).
I've tried this a few times and in both Chrome and Firefox. Consistently gives me this:
[8a7e2454-d41c-4da2-81b2-7866763a6e0a] 2023-03-10T11:51:23+00:00 INFO metabase.models.database :postgres Database 'CarePlanner Combined' sync/analyze schedules have changed!
Sync metadata was: '0 38 * * * ? *' is now: '0 46 * * * ? *'
Cache FieldValues was: '0 0 13 * * ? *', is now: '0 0 22 * * ? *'
[8a7e2454-d41c-4da2-81b2-7866763a6e0a] 2023-03-10T11:51:23+00:00 INFO metabase.task.sync-databases Scheduling sync/analyze for database 5: trigger: metabase.task.sync-and-analyze.trigger.5
[8a7e2454-d41c-4da2-81b2-7866763a6e0a] 2023-03-10T11:51:23+00:00 INFO metabase.task.sync-databases Scheduling field-values for database 5: trigger: metabase.task.update-field-values.trigger.5
[8a7e2454-d41c-4da2-81b2-7866763a6e0a] 2023-03-10T11:51:23+00:00 DEBUG metabase.server.middleware.log PUT /api/database/5 200 57.4 ms (9 DB calls) App DB connections: 0/13 Jetty threads: 4/50 (7 idle, 0 queued) (77 total active threads) Queries in flight: 0 (0 queued)
[8a7e2454-d41c-4da2-81b2-7866763a6e0a] 2023-03-10T11:51:23+00:00 DEBUG metabase.server.middleware.log GET /api/database 200 10.8 ms (3 DB calls) App DB connections: 0/13 Jetty threads: 4/50 (7 idle, 0 queued) (77 total active threads) Queries in flight: 0 (0 queued)
Which makes no sense at all.
I changed the connection to use postgres user. Still fails.
Recreating the connection using postgres user works.
Recreating the connection using the same user that failed on the first connection works.
However! In the Metabase database, the dbms_version for that connection is empty as is the 'settings' text.
I copied values from the working connections, rebooted etc. Still doesn't work!
I've copied the entries from the 'details' column to see if I can find any differences.
The first in this list is the old connection that doesn't work. Second is the one that allows me to change the selector (oddly, it's shorter).
I've removed the username and passwords:
Which bit do you need?
In the network settings, I can see the api/database being called, but no errors.
In console, there's a load of errors on loading any database but after clearing that, clicking the button does nothing.
Only oddity I can see in the HTML source is that the non-working check has both aria-checked="true" checked="" (I've turned it on by editing the metabase database).
the other databases only have aria-checked="true".
No idea if that is relevant.