Issue with rename column in DB. Metabase dont see update

Good afternoon.

I have admin users metabase and I have problems. I need help. Please help me with this problems.

I have connected source DB Postfresql, and one table wisch one often use. All worked. But DBA users rename column name in DB and metabase dont renamed automatically this column. I started Sync database schema, Re-scan field values, Re-scan this table but nothing dont help (

How can I update columns in table , to start working table?

Thanks
image


image
image

Hi, running a sync schema now on the Database should fix that ... What version of metabase are you running and when you hit the sync schema now can you share the logs that get produced, maybe there is an error

I runed Sync DB schema now, but don't help.
I have metabase V 0.50.26.1


What about the logs?

Hi
Logs from Troubleshootings (2 rows afte started sync schema):
[e5b6f90b-e0ae-4526-af16-97c67d447f00] 2024-10-15T10:22:04+03:00 INFO metabase.server.middleware.exceptions Request canceled before finishing.
[e5b6f90b-e0ae-4526-af16-97c67d447f00] 2024-10-15T10:22:08+03:00 ERROR metabase.driver.util Failed to connect to Database,java.util.concurrent.TimeoutException: Timed out after 10.0 s, at metabase.util.jvm$deref_with_timeout.invokeStatic(jvm.clj:287), at metabase.util.jvm$deref_with_timeout.invoke(jvm.clj:279), at metabase.util.jvm$do_with_timeout.invokeStatic(jvm.clj:294), at metabase.util.jvm$do_with_timeout.invoke(jvm.clj:290), at metabase.driver.util$can_connect_with_details_QMARK_.invokeStatic(util.clj:166), at metabase.driver.util$can_connect_with_details_QMARK_.doInvoke(util.clj:155), at clojure.lang.RestFn.invoke(RestFn.java:442), at metabase.api.database$fn__99228$fn__99229$fn__99230.invoke(database.clj:1014), at metabase.api.database$fn__99228$fn__99229.invoke(database.clj:1013), at metabase.api.database$fn__99228.invokeStatic(database.clj:1010), at metabase.api.database$fn__99228.invoke(database.clj:1003), at compojure.core$wrap_response$fn__52764.invoke(core.clj:160), at compojure.core$wrap_route_middleware$fn__52748.invoke(core.clj:132), at compojure.core$wrap_route_info$fn__52753.invoke(core.clj:139), at compojure.core$wrap_route_matches$fn__52757.invoke(core.clj:151), at clojure.lang.Var.invoke(Var.java:393), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$wrap_route_matches$fn__52757.invoke(core.clj:153), at clojure.lang.Var.invoke(Var.java:393), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$wrap_route_matches$fn__52757.invoke(core.clj:152), at clojure.lang.Var.invoke(Var.java:393), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$wrap_route_matches$fn__52757.invoke(core.clj:153), at clojure.lang.Var.invoke(Var.java:393), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$wrap_route_matches$fn__52757.invoke(core.clj:153), at clojure.lang.Var.invoke(Var.java:393), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$wrap_route_matches$fn__52757.invoke(core.clj:152), at clojure.lang.Var.invoke(Var.java:393), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$wrap_route_matches$fn__52757.invoke(core.clj:152), at clojure.lang.Var.invoke(Var.java:393), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$wrap_route_matches$fn__52757.invoke(core.clj:152), at clojure.lang.Var.invoke(Var.java:393), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$wrap_route_matches$fn__52757.invoke(core.clj:153), at clojure.lang.Var.invoke(Var.java:393), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$wrap_route_matches$fn__52757.invoke(core.clj:153), at clojure.lang.Var.invoke(Var.java:393), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$wrap_route_matches$fn__52757.invoke(core.clj:152), at clojure.lang.Var.invoke(Var.java:393), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$wrap_route_matches$fn__52757.invoke(core.clj:152), at clojure.lang.Var.invoke(Var.java:393), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776.invoke(core.clj:200), at clojure.lang.AFn.applyToHelper(AFn.java:160), at clojure.lang.AFn.applyTo(AFn.java:144), at clojure.lang.AFunction$1.doInvoke(AFunction.java:31), at clojure.lang.RestFn.invoke(RestFn.java:436), at metabase.server.middleware.auth$enforce_authentication$fn__97435.invoke(auth.clj:18), at clojure.lang.AFn.applyToHelper(AFn.java:160), at clojure.lang.AFn.applyTo(AFn.java:144), at clojure.lang.AFunction$1.doInvoke(AFunction.java:31), at clojure.lang.RestFn.invoke(RestFn.java:436), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776.invoke(core.clj:200), at compojure.core$make_context$handler__52804.invoke(core.clj:290), at compojure.core$make_context$fn__52808.invoke(core.clj:300), at clojure.lang.AFn.applyToHelper(AFn.java:160), at clojure.lang.AFn.applyTo(AFn.java:144), at clojure.lang.AFunction$1.doInvoke(AFunction.java:31), at clojure.lang.RestFn.invoke(RestFn.java:436), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$make_context$fn__52808.invoke(core.clj:301), at clojure.lang.AFn.applyToHelper(AFn.java:160), at clojure.lang.AFn.applyTo(AFn.java:144), at clojure.lang.AFunction$1.doInvoke(AFunction.java:31), at clojure.lang.RestFn.invoke(RestFn.java:436), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$make_context$fn__52808.invoke(core.clj:301), at clojure.lang.AFn.applyToHelper(AFn.java:160), at clojure.lang.AFn.applyTo(AFn.java:144), at clojure.lang.AFunction$1.doInvoke(AFunction.java:31), at clojure.lang.RestFn.invoke(RestFn.java:436), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$make_context$fn__52808.invoke(core.clj:301), at clojure.lang.AFn.applyToHelper(AFn.java:160), at clojure.lang.AFn.applyTo(AFn.java:144), at clojure.lang.AFunction$1.doInvoke(AFunction.java:31), at clojure.lang.RestFn.invoke(RestFn.java:436), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$make_context$fn__52808.invoke(core.clj:301), at clojure.lang.AFn.applyToHelper(AFn.java:160), at clojure.lang.AFn.applyTo(AFn.java:144), at clojure.lang.AFunction$1.doInvoke(AFunction.java:31), at clojure.lang.RestFn.invoke(RestFn.java:436), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$make_context$fn__52808.invoke(core.clj:301), at clojure.lang.AFn.applyToHelper(AFn.java:160), at clojure.lang.AFn.applyTo(AFn.java:144), at clojure.lang.AFunction$1.doInvoke(AFunction.java:31), at clojure.lang.RestFn.invoke(RestFn.java:436), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$make_context$fn__52808.invoke(core.clj:301), at clojure.lang.AFn.applyToHelper(AFn.java:160), at clojure.lang.AFn.applyTo(AFn.java:144), at clojure.lang.AFunction$1.doInvoke(AFunction.java:31), at clojure.lang.RestFn.invoke(RestFn.java:436), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$make_context$fn__52808.invoke(core.clj:301), at clojure.lang.AFn.applyToHelper(AFn.java:160), at clojure.lang.AFn.applyTo(AFn.java:144), at clojure.lang.AFunction$1.doInvoke(AFunction.java:31), at clojure.lang.RestFn.invoke(RestFn.java:436), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$make_context$fn__52808.invoke(core.clj:301), at clojure.lang.AFn.applyToHelper(AFn.java:160), at clojure.lang.AFn.applyTo(AFn.java:144), at clojure.lang.AFunction$1.doInvoke(AFunction.java:31), at clojure.lang.RestFn.invoke(RestFn.java:436), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$make_context$fn__52808.invoke(core.clj:301), at clojure.lang.AFn.applyToHelper(AFn.java:160), at clojure.lang.AFn.applyTo(AFn.java:144), at clojure.lang.AFunction$1.doInvoke(AFunction.java:31), at clojure.lang.RestFn.invoke(RestFn.java:436), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$wrap_route_matches$fn__52757.invoke(core.clj:153), at clojure.lang.Var.invoke(Var.java:393), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at metabase.api.routes$fn__103111$fn__103114.invoke(routes.clj:73), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776.invoke(core.clj:200), at clojure.lang.AFn.applyToHelper(AFn.java:160), at clojure.lang.AFn.applyTo(AFn.java:144), at clojure.core$apply.invokeStatic(core.clj:667), at clojure.core$apply.invoke(core.clj:662), at metabase.server.routes$fn__103391$fn__103392.doInvoke(routes.clj:73), at clojure.lang.RestFn.invoke(RestFn.java:436), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776.invoke(core.clj:200), at compojure.core$make_context$handler__52804.invoke(core.clj:290), at compojure.core$make_context$fn__52808.invoke(core.clj:300), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$wrap_route_matches$fn__52757.invoke(core.clj:153), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$wrap_route_matches$fn__52757.invoke(core.clj:153), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$wrap_route_matches$fn__52757.invoke(core.clj:153), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$wrap_route_matches$fn__52757.invoke(core.clj:153), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at metabase.server.routes$fn__103374$fn__103376.invoke(routes.clj:47), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776.invoke(core.clj:200), at metabase.server.middleware.exceptions$catch_uncaught_exceptions$fn__99469.invoke(exceptions.clj:107), at metabase.server.middleware.exceptions$catch_api_exceptions$fn__99466.invoke(exceptions.clj:96), at metabase.server.middleware.log$log_api_call$fn__103678$fn__103679$fn__103680.invoke(log.clj:233), at metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invokeStatic(diagnostic.clj:18), at metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invoke(diagnostic.clj:12), at metabase.server.middleware.log$log_api_call$fn__103678$fn__103679.invoke(log.clj:224), at toucan2.execute$do_with_call_counts.invokeStatic(execute.clj:112), at toucan2.execute$do_with_call_counts.invoke(execute.clj:103), at metabase.server.middleware.log$log_api_call$fn__103678.invoke(log.clj:223), at metabase.server.middleware.browser_cookie$ensure_browser_id_cookie$fn__106968.invoke(browser_cookie.clj:40), at metabase.server.middleware.security$add_security_headers$fn__99425.invoke(security.clj:246), at ring.middleware.json$wrap_json_body$fn__107227.invoke(json.clj:64), at metabase.server.middleware.offset_paging$handle_paging$fn__87789.invoke(offset_paging.clj:43), at metabase.server.middleware.json$wrap_streamed_json_response$fn__54392.invoke(json.clj:83), at ring.middleware.keyword_params$wrap_keyword_params$fn__107316.invoke(keyword_params.clj:55), at ring.middleware.params$wrap_params$fn__107335.invoke(params.clj:77), at metabase.server.middleware.misc$maybe_set_site_url$fn__64236.invoke(misc.clj:59), at metabase.server.middleware.session$reset_session_timeout$fn__65787.invoke(session.clj:548), at metabase.server.middleware.session$bind_current_user$fn__65753$fn__65754.invoke(session.clj:443), at metabase.server.middleware.session$do_with_current_user.invokeStatic(session.clj:422), at metabase.server.middleware.session$do_with_current_user.invoke(session.clj:405), at metabase.server.middleware.session$bind_current_user$fn__65753.invoke(session.clj:442), at metabase.server.middleware.session$wrap_current_user_info$fn__65734.invoke(session.clj:381), at metabase.server.middleware.session$wrap_session_id$fn__65706.invoke(session.clj:259), at metabase.server.middleware.auth$wrap_static_api_key$fn__97443.invoke(auth.clj:32), at ring.middleware.cookies$wrap_cookies$fn__107155.invoke(cookies.clj:200), at metabase.server.middleware.misc$add_content_type$fn__64218.invoke(misc.clj:28), at metabase.server.middleware.misc$disable_streaming_buffering$fn__64244.invoke(misc.clj:75), at ring.middleware.gzip$wrap_gzip$fn__107197.invoke(gzip.clj:86), at metabase.server.middleware.misc$bind_request$fn__64247.invoke(misc.clj:91), at metabase.server.middleware.ssl$redirect_to_https_middleware$fn__106984.invoke(ssl.clj:41), at metabase.server$async_proxy_handler$fn__71978.invoke(server.clj:77), at metabase.server.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a.handle(Unknown Source), at org.eclipse.jetty.server.handler.StatisticsHandler.handle(StatisticsHandler.java:173), at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:122), at org.eclipse.jetty.server.Server.handle(Server.java:563), at org.eclipse.jetty.server.HttpChannel$RequestDispatchable.dispatch(HttpChannel.java:1598), at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:753), at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:501), at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:287), at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:314), at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:100), at org.eclipse.jetty.io.SelectableChannelEndPoint$1.run(SelectableChannelEndPoint.java:53), at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.runTask(AdaptiveExecutionStrategy.java:421), at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.consumeTask(AdaptiveExecutionStrategy.java:390), at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.tryProduce(AdaptiveExecutionStrategy.java:277), at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.run(AdaptiveExecutionStrategy.java:199), at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:411), at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:969), at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.doRunJob(QueuedThreadPool.java:1194), at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1149), at java.base/java.lang.Thread.run(Unknown Source)
[e5b6f90b-e0ae-4526-af16-97c67d447f00] 2024-10-15T10:22:08+03:00 WARN metabase.server.middleware.log POST /api/database/7/sync_schema 422 10.0 s (1 DB calls) {:metabase-user-id 763}
"Timed out after 10.0 s"

That’s a timeout so the database can’t be reached

So the error is-obvious and that metabase is just not able to connect to that DB ... Are you able to query the database? like doing some select start * thingy ... cause it seems metabase just lost the connection to your DB

I don't have problems with write sql query, all work.
For example it table in query.


Problems with sync columns name. (1-st message)

Then metabase has a problem to get the table metadata ... What permissions/roles does the metabase user you are using to connect with the DB have?

Hello
We make test, update users for connection and approved big rules. The error remains.
When start sync DB schema now, we have Error "Time out 10s."
Where can check/change time out in metabase?
image

You need to check if something changed in your DB ... Like some network or something cause clearly metabase cannot connect to the database

What permissions does the user you are connecting with the DB has?