Getting "Save Failed" while trying to save changes on Dashboards

When I'm trying to save Dashboard, I get "Save Failed" error. Albeit some changes have been saving — styles of questions or allocation. The configuration of filters couldn't been saved.

{
  "browser-info": {
    "language": "ru-RU",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.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.17+8-post-Ubuntu-1ubuntu220.04",
    "java.vendor": "Ubuntu",
    "java.vendor.url": "https://ubuntu.com/",
    "java.version": "11.0.17",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.17+8-post-Ubuntu-1ubuntu220.04",
    "os.name": "Linux",
    "os.version": "5.4.0-136-generic",
    "user.language": "en",
    "user.timezone": "Etc/UTC"
  },
  "metabase-info": {
    "databases": [
      "mysql"
    ],
    "hosting-env": "unknown",
    "application-database": "h2",
    "application-database-details": {
      "database": {
        "name": "H2",
        "version": "1.4.197 (2018-03-18)"
      },
      "jdbc-driver": {
        "name": "H2 JDBC Driver",
        "version": "1.4.197 (2018-03-18)"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2022-10-17",
      "tag": "v0.44.5",
      "branch": "release-x.44.x",
      "hash": "29fab4d"
    },
    "settings": {
      "report-timezone": "Europe/Moscow"
    }
  }
}
[a7525992-b466-4982-8bc8-4e6581b36ecf] 2023-02-08T09:08:22+03:00 DEBUG metabase.server.middleware.log POST /api/dashboard/1/dashcard/193/card/193/query 202 [ASYNC: completed] 3.5 s (19 DB calls) App DB connections: 0/13 Jetty threads: 2/50 (10 idle, 0 queued) (110 total active threads) Queries in flight: 1 (0 queued); mysql DB 2 connections: 2/6 (0 threads blocked)
[a7525992-b466-4982-8bc8-4e6581b36ecf] 2023-02-08T09:08:23+03:00 INFO metabase.query-processor.middleware.cache Query took 4.6 s to run; minimum for cache eligibility is 10.0 s
[a7525992-b466-4982-8bc8-4e6581b36ecf] 2023-02-08T09:08:23+03:00 DEBUG metabase.server.middleware.log POST /api/dashboard/1/dashcard/161/card/161/query 202 [ASYNC: completed] 5.0 s (19 DB calls) App DB connections: 0/13 Jetty threads: 2/50 (10 idle, 0 queued) (110 total active threads) Queries in flight: 1 (0 queued); mysql DB 2 connections: 3/6 (0 threads blocked)
[a7525992-b466-4982-8bc8-4e6581b36ecf] 2023-02-08T09:08:40+03:00 DEBUG metabase.server.middleware.log PUT /api/dashboard/1/cards 200 328.3 ms (87 DB calls) App DB connections: 0/13 Jetty threads: 3/50 (9 idle, 0 queued) (110 total active threads) Queries in flight: 0 (0 queued)
[a7525992-b466-4982-8bc8-4e6581b36ecf] 2023-02-08T09:08:40+03:00 DEBUG metabase.server.middleware.log PUT /api/dashboard/1 400 20.6 ms (0 DB calls) 
{:errors {:collection_position "value may be nil, or if non-nil, value must be an integer greater than zero."}}

[a7525992-b466-4982-8bc8-4e6581b36ecf] 2023-02-08T09:10:13+03:00 DEBUG metabase.server.middleware.log PUT /api/dashboard/1/cards 200 327.6 ms (87 DB calls) App DB connections: 0/13 Jetty threads: 3/50 (8 idle, 0 queued) (100 total active threads) Queries in flight: 0 (0 queued)
[a7525992-b466-4982-8bc8-4e6581b36ecf] 2023-02-08T09:10:13+03:00 DEBUG metabase.server.middleware.log PUT /api/dashboard/1 400 3.6 ms (0 DB calls) 
{:errors {:collection_position "value may be nil, or if non-nil, value must be an integer greater than zero."}}

[a7525992-b466-4982-8bc8-4e6581b36ecf] 2023-02-08T09:13:43+03:00 DEBUG metabase.server.middleware.log PUT /api/dashboard/1/cards 200 279.2 ms (87 DB calls) App DB connections: 1/13 Jetty threads: 3/50 (5 idle, 0 queued) (97 total active threads) Queries in flight: 0 (0 queued)
[a7525992-b466-4982-8bc8-4e6581b36ecf] 2023-02-08T09:13:43+03:00 DEBUG metabase.server.middleware.log PUT /api/dashboard/1 400 3.9 ms (0 DB calls) 
{:errors {:collection_position "value may be nil, or if non-nil, value must be an integer greater than zero."}}

is it possible that the dashboard is pinned? can you try unpinning the dashboard and then saving it again?

BTW: please upgrade to the latest version, thanks!

I can't unpin it — also get 500 error in Chrome Dev Tools Console.

ok, can you post the logs when you try to unpin it? there seems to be a corruption at some point then

[b865c215-0208-4d72-a16d-0600f62ef8ef] 2023-02-09T10:19:51+03:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 93.0 ms (5 DB calls) App DB connections: 0/4 Jetty threads: 4/50 (3 idle, 0 queued) (49 total active threads) Queries in flight: 0 (0 queued)
[b865c215-0208-4d72-a16d-0600f62ef8ef] 2023-02-09T10:19:52+03:00 DEBUG metabase.server.middleware.log GET /api/user/current 200 683.9 ms (10 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (4 idle, 0 queued) (49 total active threads) Queries in flight: 0 (0 queued)
[b865c215-0208-4d72-a16d-0600f62ef8ef] 2023-02-09T10:19:52+03:00 DEBUG metabase.server.middleware.log GET /api/bookmark 200 227.8 ms (1 DB calls) App DB connections: 1/7 Jetty threads: 8/50 (1 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[b865c215-0208-4d72-a16d-0600f62ef8ef] 2023-02-09T10:19:52+03:00 DEBUG metabase.server.middleware.log GET /api/database 200 222.8 ms (3 DB calls) App DB connections: 1/7 Jetty threads: 8/50 (1 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[b865c215-0208-4d72-a16d-0600f62ef8ef] 2023-02-09T10:19:52+03:00 DEBUG metabase.server.middleware.log GET /api/collection/root 200 742.3 ms (2 DB calls) App DB connections: 0/7 Jetty threads: 6/50 (3 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[b865c215-0208-4d72-a16d-0600f62ef8ef] 2023-02-09T10:19:52+03:00 DEBUG metabase.server.middleware.log GET /api/collection/tree 200 763.6 ms (10 DB calls) App DB connections: 0/7 Jetty threads: 5/50 (4 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[b865c215-0208-4d72-a16d-0600f62ef8ef] 2023-02-09T10:19:53+03:00 DEBUG metabase.server.middleware.log GET /api/activity/recent_views 200 663.7 ms (8 DB calls) App DB connections: 0/7 Jetty threads: 4/50 (5 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[b865c215-0208-4d72-a16d-0600f62ef8ef] 2023-02-09T10:19:53+03:00 DEBUG metabase.server.middleware.log GET /api/activity/popular_items 200 905.7 ms (10 DB calls) App DB connections: 0/7 Jetty threads: 3/50 (6 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[b865c215-0208-4d72-a16d-0600f62ef8ef] 2023-02-09T10:19:54+03:00 DEBUG metabase.server.middleware.log GET /api/collection/97 200 27.0 ms (3 DB calls) App DB connections: 0/7 Jetty threads: 4/50 (5 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[b865c215-0208-4d72-a16d-0600f62ef8ef] 2023-02-09T10:19:54+03:00 DEBUG metabase.server.middleware.log GET /api/collection/tree 200 45.6 ms (10 DB calls) App DB connections: 1/7 Jetty threads: 4/50 (5 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[b865c215-0208-4d72-a16d-0600f62ef8ef] 2023-02-09T10:19:55+03:00 DEBUG metabase.server.middleware.log GET /api/collection/97/items 200 324.2 ms (5 DB calls) App DB connections: 0/7 Jetty threads: 4/50 (5 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[b865c215-0208-4d72-a16d-0600f62ef8ef] 2023-02-09T10:19:55+03:00 DEBUG metabase.server.middleware.log GET /api/collection/97/items 200 379.9 ms (5 DB calls) App DB connections: 0/7 Jetty threads: 3/50 (6 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[b865c215-0208-4d72-a16d-0600f62ef8ef] 2023-02-09T10:19:58+03:00 ERROR metabase.server.middleware.log PUT /api/dashboard/1 500 54.7 ms (3 DB calls) 
{:via
 [{:type clojure.lang.ExceptionInfo,
   :message
   "Input to maybe-reconcile-collection-position! does not match schema: \n\n\t   [(named {:collection_position (not (\"Integer greater than zero\" 0))} arg0) nil]  \n\n",
   :data
   {:type :schema.core/error,
    :schema
    [{:schema
      (maybe
       {:collection_id (maybe (constrained Int "Integer greater than zero")),
        :collection_position (maybe (constrained Int "Integer greater than zero")),
        Any Any}),
      :optional? false,
      :name arg0}
     {:schema
      {{:k :collection_id} (maybe (constrained Int "Integer greater than zero")),
       {:k :collection_position} (maybe (constrained Int "Integer greater than zero")),
       Any Any},
      :optional? false,
      :name arg1}],
    :value
    [{:description nil,
      :archived false,
      :collection_position 0,
      :enable_embedding false,
      :collection_id 97,
      :show_in_getting_started false,
      :name "Общие показатели клиник",
      :caveats nil,
      :creator_id 1,
      :updated_at #t "2022-10-21T14:32:30.155",
      :made_public_by_id 1,
      :embedding_params nil,
      :cache_ttl nil,
      :id 1,
      :position nil,
      :entity_id nil,
      :parameters
      [{:name "Клиника",
        :slug "%D0%BA%D0%BB%D0%B8%D0%BD%D0%B8%D0%BA%D0%B0",
        :id "fc8b8c10",
        :type :category,
        :hasOnlyFieldTargets true}
       {:name "Период",
        :slug "%D0%BF%D0%B5%D1%80%D0%B8%D0%BE%D0%B4",
        :id "3e4dbc38",
        :type :date/relative,
        :sectionId "date",
        :default "thisyear"}],
      :created_at #t "2021-06-22T14:36:35.221",
      :public_uuid "835c477b-0651-4ab7-8d91-478ed3ea93d2",
      :points_of_interest nil}
     {:collection_position nil}],
    :error [(named {:collection_position (not ("Integer greater than zero" 0))} arg0) nil]},
   :at [metabase.api.common$fn__29489$maybe_reconcile_collection_position_BANG___29498 invoke "common.clj" 478]}],
 :trace
 [[metabase.api.common$fn__29489$maybe_reconcile_collection_position_BANG___29498 invoke "common.clj" 478]
  [metabase.api.dashboard$fn__72407$fn__72410 invoke "dashboard.clj" 293]
  [toucan.db$do_in_transaction$fn__29053 invoke "db.clj" 147]
  [clojure.java.jdbc$db_transaction_STAR_ invokeStatic "jdbc.clj" 807]
  [clojure.java.jdbc$db_transaction_STAR_ invoke "jdbc.clj" 776]
  [clojure.java.jdbc$db_transaction_STAR_ invokeStatic "jdbc.clj" 852]
  [clojure.java.jdbc$db_transaction_STAR_ invoke "jdbc.clj" 776]
  [clojure.java.jdbc$db_transaction_STAR_ invokeStatic "jdbc.clj" 789]
  [clojure.java.jdbc$db_transaction_STAR_ invoke "jdbc.clj" 776]
  [toucan.db$do_in_transaction invokeStatic "db.clj" 145]
  [toucan.db$do_in_transaction invoke "db.clj" 142]
  [metabase.api.dashboard$fn__72407 invokeStatic "dashboard.clj" 289]
  [metabase.api.dashboard$fn__72407 invoke "dashboard.clj" 262]
  [compojure.core$wrap_response$fn__28102 invoke "core.clj" 160]
  [compojure.core$wrap_route_middleware$fn__28086 invoke "core.clj" 132]
  [compojure.core$wrap_route_info$fn__28091 invoke "core.clj" 139]
  [compojure.core$wrap_route_matches$fn__28095 invoke "core.clj" 151]
  [compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
  [compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116 invoke "core.clj" 197]
  [compojure.core$wrap_route_matches$fn__28095 invoke "core.clj" 153]
  [compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
  [compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116 invoke "core.clj" 197]
  [compojure.core$wrap_route_matches$fn__28095 invoke "core.clj" 153]
  [compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
  [compojure.core$routes$fn__28114 invoke "core.clj" 200]
  [metabase.server.middleware.auth$enforce_authentication$fn__68963 invoke "auth.clj" 14]
  [compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
  [compojure.core$routes$fn__28114 invoke "core.clj" 200]
  [compojure.core$make_context$handler__28142 invoke "core.clj" 289]
  [compojure.core$make_context$fn__28146 invoke "core.clj" 299]
  [compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
  [compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116 invoke "core.clj" 197]
  [compojure.core$make_context$fn__28146 invoke "core.clj" 300]
  [compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
  [compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116 invoke "core.clj" 197]
  [compojure.core$make_context$fn__28146 invoke "core.clj" 300]
  [compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
  [compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116 invoke "core.clj" 197]
  [compojure.core$make_context$fn__28146 invoke "core.clj" 300]
  [compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
  [compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116 invoke "core.clj" 197]
  [compojure.core$make_context$fn__28146 invoke "core.clj" 300]
  [compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
  [compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116 invoke "core.clj" 197]
  [compojure.core$make_context$fn__28146 invoke "core.clj" 300]
  [compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
  [compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116 invoke "core.clj" 197]
  [compojure.core$make_context$fn__28146 invoke "core.clj" 300]
  [compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
  [compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116 invoke "core.clj" 197]
  [metabase.api.routes$fn__79951$fn__79954 invoke "routes.clj" 60]
  [compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
  [compojure.core$routes$fn__28114 invoke "core.clj" 200]
  [clojure.lang.AFn applyToHelper "AFn.java" 160]
  [clojure.lang.AFn applyTo "AFn.java" 144]
  [clojure.core$apply invokeStatic "core.clj" 667]
  [clojure.core$apply invoke "core.clj" 662]
  [metabase.server.routes$fn__80106$fn__80107 doInvoke "routes.clj" 67]
  [clojure.lang.RestFn invoke "RestFn.java" 436]
  [compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
  [compojure.core$routes$fn__28114 invoke "core.clj" 200]
  [compojure.core$make_context$handler__28142 invoke "core.clj" 289]
  [compojure.core$make_context$fn__28146 invoke "core.clj" 299]
  [compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
  [compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116 invoke "core.clj" 197]
  [compojure.core$wrap_route_matches$fn__28095 invoke "core.clj" 153]
  [compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
  [compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116 invoke "core.clj" 197]
  [compojure.core$wrap_route_matches$fn__28095 invoke "core.clj" 153]
  [compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
  [compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116 invoke "core.clj" 197]
  [compojure.core$wrap_route_matches$fn__28095 invoke "core.clj" 153]
  [compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
  [compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116 invoke "core.clj" 197]
  [metabase.server.routes$fn__80092$fn__80094 invoke "routes.clj" 45]
  [compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
  [compojure.core$routes$fn__28114 invoke "core.clj" 200]
  [metabase.server.middleware.exceptions$catch_uncaught_exceptions$fn__76840 invoke "exceptions.clj" 98]
  [metabase.server.middleware.exceptions$catch_api_exceptions$fn__76837 invoke "exceptions.clj" 86]
  [metabase.server.middleware.log$log_api_call$fn__81518$fn__81519$fn__81520 invoke "log.clj" 211]
  [metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info invokeStatic "diagnostic.clj" 15]
  [metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info invoke "diagnostic.clj" 9]
  [metabase.server.middleware.log$log_api_call$fn__81518$fn__81519 invoke "log.clj" 203]
  [toucan.db$_do_with_call_counting invokeStatic "db.clj" 236]
  [toucan.db$_do_with_call_counting invoke "db.clj" 229]
  [metabase.server.middleware.log$log_api_call$fn__81518 invoke "log.clj" 202]
  [metabase.server.middleware.browser_cookie$ensure_browser_id_cookie$fn__84618 invoke "browser_cookie.clj" 38]
  [metabase.server.middleware.security$add_security_headers$fn__62356 invoke "security.clj" 149]
  [metabase.server.middleware.json$wrap_json_body$fn__83576 invoke "json.clj" 63]
  [metabase.server.middleware.json$wrap_streamed_json_response$fn__83594 invoke "json.clj" 99]
  [metabase.server.middleware.offset_paging$handle_paging$fn__62380 invoke "offset_paging.clj" 42]
  [ring.middleware.keyword_params$wrap_keyword_params$fn__84885 invoke "keyword_params.clj" 55]
  [ring.middleware.params$wrap_params$fn__84904 invoke "params.clj" 77]
  [metabase.server.middleware.misc$maybe_set_site_url$fn__35785 invoke "misc.clj" 59]
  [metabase.server.middleware.session$reset_session_timeout$fn__47477 invoke "session.clj" 377]
  [metabase.server.middleware.session$bind_current_user$fn__47460$fn__47461 invoke "session.clj" 313]
  [metabase.server.middleware.session$do_with_current_user invokeStatic "session.clj" 292]
  [metabase.server.middleware.session$do_with_current_user invoke "session.clj" 281]
  [metabase.server.middleware.session$bind_current_user$fn__47460 invoke "session.clj" 312]
  [metabase.server.middleware.session$wrap_current_user_info$fn__47442 invoke "session.clj" 262]
  [metabase.server.middleware.session$wrap_session_id$fn__47426 invoke "session.clj" 195]
  [metabase.server.middleware.auth$wrap_api_key$fn__68971 invoke "auth.clj" 27]
  [ring.middleware.cookies$wrap_cookies$fn__84805 invoke "cookies.clj" 216]
  [metabase.server.middleware.misc$add_content_type$fn__35768 invoke "misc.clj" 27]
  [metabase.server.middleware.misc$disable_streaming_buffering$fn__35793 invoke "misc.clj" 76]
  [ring.middleware.gzip$wrap_gzip$fn__84847 invoke "gzip.clj" 86]
  [metabase.server.middleware.misc$bind_request$fn__35796 invoke "misc.clj" 93]
  [metabase.server.middleware.ssl$redirect_to_https_middleware$fn__84634 invoke "ssl.clj" 38]
  [metabase.server$async_proxy_handler$fn__80314 invoke "server.clj" 73]
  [metabase.server.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a handle nil -1]
  [org.eclipse.jetty.server.handler.StatisticsHandler handle "StatisticsHandler.java" 181]
  [org.eclipse.jetty.server.handler.HandlerWrapper handle "HandlerWrapper.java" 127]
  [org.eclipse.jetty.server.Server handle "Server.java" 516]
  [org.eclipse.jetty.server.HttpChannel lambda$handle$1 "HttpChannel.java" 487]
  [org.eclipse.jetty.server.HttpChannel dispatch "HttpChannel.java" 732]
  [org.eclipse.jetty.server.HttpChannel handle "HttpChannel.java" 479]
  [org.eclipse.jetty.server.HttpConnection onFillable "HttpConnection.java" 277]
  [org.eclipse.jetty.io.AbstractConnection$ReadCallback succeeded "AbstractConnection.java" 311]
  [org.eclipse.jetty.io.FillInterest fillable "FillInterest.java" 105]
  [org.eclipse.jetty.io.ChannelEndPoint$1 run "ChannelEndPoint.java" 104]
  [org.eclipse.jetty.util.thread.strategy.EatWhatYouKill runTask "EatWhatYouKill.java" 338]
  [org.eclipse.jetty.util.thread.strategy.EatWhatYouKill doProduce "EatWhatYouKill.java" 315]
  [org.eclipse.jetty.util.thread.strategy.EatWhatYouKill tryProduce "EatWhatYouKill.java" 173]
  [org.eclipse.jetty.util.thread.strategy.EatWhatYouKill run "EatWhatYouKill.java" 131]
  [org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread run "ReservedThreadExecutor.java" 409]
  [org.eclipse.jetty.util.thread.QueuedThreadPool runJob "QueuedThreadPool.java" 883]
  [org.eclipse.jetty.util.thread.QueuedThreadPool$Runner run "QueuedThreadPool.java" 1034]
  [java.lang.Thread run "Thread.java" 829]],
 :cause
 "Input to maybe-reconcile-collection-position! does not match schema: \n\n\t   [(named {:collection_position (not (\"Integer greater than zero\" 0))} arg0) nil]  \n\n",
 :data
 {:type :schema.core/error,
  :schema
  [{:schema
    (maybe
     {:collection_id (maybe (constrained Int "Integer greater than zero")),
      :collection_position (maybe (constrained Int "Integer greater than zero")),
      Any Any}),
    :optional? false,
    :name arg0}
   {:schema
    {{:k :collection_id} (maybe (constrained Int "Integer greater than zero")),
     {:k :collection_position} (maybe (constrained Int "Integer greater than zero")),
     Any Any},
    :optional? false,
    :name arg1}],
  :value
  [{:description nil,
    :archived false,
    :collection_position 0,
    :enable_embedding false,
    :collection_id 97,
    :show_in_getting_started false,
    :name "Общие показатели клиник",
    :caveats nil,
    :creator_id 1,
    :updated_at #t "2022-10-21T14:32:30.155",
    :made_public_by_id 1,
    :embedding_params nil,
    :cache_ttl nil,
    :id 1,
    :position nil,
    :entity_id nil,
    :parameters
    [{:name "Клиника",
      :slug "%D0%BA%D0%BB%D0%B8%D0%BD%D0%B8%D0%BA%D0%B0",
      :id "fc8b8c10",
      :type :category,
      :hasOnlyFieldTargets true}
     {:name "Период",
      :slug "%D0%BF%D0%B5%D1%80%D0%B8%D0%BE%D0%B4",
      :id "3e4dbc38",
      :type :date/relative,
      :sectionId "date",
      :default "thisyear"}],
    :created_at #t "2021-06-22T14:36:35.221",
    :public_uuid "835c477b-0651-4ab7-8d91-478ed3ea93d2",
    :points_of_interest nil}
   {:collection_position nil}],
  :error [(named {:collection_position (not ("Integer greater than zero" 0))} arg0) nil]},
 :message
 "Input to maybe-reconcile-collection-position! does not match schema: \n\n\t   [(named {:collection_position (not (\"Integer greater than zero\" 0))} arg0) nil]  \n\n",
 :value
 [{:description nil,
   :archived false,
   :collection_position 0,
   :enable_embedding false,
   :collection_id 97,
   :show_in_getting_started false,
   :name "Общие показатели клиник",
   :caveats nil,
   :creator_id 1,
   :updated_at #t "2022-10-21T14:32:30.155",
   :made_public_by_id 1,
   :embedding_params nil,
   :cache_ttl nil,
   :id 1,
   :position nil,
   :entity_id nil,
   :parameters
   [{:name "Клиника",
     :slug "%D0%BA%D0%BB%D0%B8%D0%BD%D0%B8%D0%BA%D0%B0",
     :id "fc8b8c10",
     :type :category,
     :hasOnlyFieldTargets true}
    {:name "Период",
     :slug "%D0%BF%D0%B5%D1%80%D0%B8%D0%BE%D0%B4",
     :id "3e4dbc38",
     :type :date/relative,
     :sectionId "date",
     :default "thisyear"}],
   :created_at #t "2021-06-22T14:36:35.221",
   :public_uuid "835c477b-0651-4ab7-8d91-478ed3ea93d2",
   :points_of_interest nil}
  {:collection_position nil}],
 :error [(named {:collection_position (not ("Integer greater than zero" 0))} arg0) nil]}

[b865c215-0208-4d72-a16d-0600f62ef8ef] 2023-02-09T10:19:58+03:00 DEBUG metabase.server.middleware.log GET /api/collection/97/items 200 140.6 ms (5 DB calls) App DB connections: 0/7 Jetty threads: 4/50 (5 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[b865c215-0208-4d72-a16d-0600f62ef8ef] 2023-02-09T10:19:58+03:00 DEBUG metabase.server.middleware.log GET /api/collection/97/items 200 199.6 ms (5 DB calls) App DB connections: 0/7 Jetty threads: 3/50 (6 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[b865c215-0208-4d72-a16d-0600f62ef8ef] 2023-02-09T10:20:00+03:00 DEBUG metabase.server.middleware.log GET /api/user/current 200 36.3 ms (9 DB calls) App DB connections: 0/7 Jetty threads: 4/50 (5 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[b865c215-0208-4d72-a16d-0600f62ef8ef] 2023-02-09T10:20:00+03:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 62.7 ms (5 DB calls) App DB connections: 0/7 Jetty threads: 3/50 (6 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[b865c215-0208-4d72-a16d-0600f62ef8ef] 2023-02-09T10:20:00+03:00 DEBUG metabase.server.middleware.log GET /api/bookmark 200 19.5 ms (1 DB calls) App DB connections: 0/7 Jetty threads: 6/50 (3 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[b865c215-0208-4d72-a16d-0600f62ef8ef] 2023-02-09T10:20:00+03:00 DEBUG metabase.server.middleware.log GET /api/collection/root 200 33.9 ms (2 DB calls) App DB connections: 0/7 Jetty threads: 6/50 (3 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[b865c215-0208-4d72-a16d-0600f62ef8ef] 2023-02-09T10:20:00+03:00 DEBUG metabase.server.middleware.log GET /api/database 200 26.5 ms (3 DB calls) App DB connections: 0/7 Jetty threads: 6/50 (3 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[b865c215-0208-4d72-a16d-0600f62ef8ef] 2023-02-09T10:20:00+03:00 DEBUG metabase.server.middleware.log GET /api/collection/tree 200 37.5 ms (10 DB calls) App DB connections: 0/7 Jetty threads: 3/50 (6 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[b865c215-0208-4d72-a16d-0600f62ef8ef] 2023-02-09T10:20:00+03:00 DEBUG metabase.server.middleware.log GET /api/collection/97 200 17.2 ms (3 DB calls) App DB connections: 1/7 Jetty threads: 4/50 (5 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[b865c215-0208-4d72-a16d-0600f62ef8ef] 2023-02-09T10:20:00+03:00 DEBUG metabase.server.middleware.log GET /api/collection/tree 200 35.4 ms (10 DB calls) App DB connections: 0/7 Jetty threads: 3/50 (6 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[b865c215-0208-4d72-a16d-0600f62ef8ef] 2023-02-09T10:20:00+03:00 DEBUG metabase.server.middleware.log GET /api/collection/97/items 200 164.8 ms (5 DB calls) App DB connections: 0/7 Jetty threads: 4/50 (5 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[b865c215-0208-4d72-a16d-0600f62ef8ef] 2023-02-09T10:20:00+03:00 DEBUG metabase.server.middleware.log GET /api/collection/97/items 200 213.9 ms (5 DB calls) App DB connections: 0/7 Jetty threads: 3/50 (6 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[b865c215-0208-4d72-a16d-0600f62ef8ef] 2023-02-09T10:20:03+03:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 70.6 ms (5 DB calls) App DB connections: 0/7 Jetty threads: 4/50 (5 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[b865c215-0208-4d72-a16d-0600f62ef8ef] 2023-02-09T10:20:03+03:00 DEBUG metabase.server.middleware.log GET /api/setting 200 134.2 ms (4 DB calls) App DB connections: 0/7 Jetty threads: 4/50 (5 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[b865c215-0208-4d72-a16d-0600f62ef8ef] 2023-02-09T10:20:03+03:00 DEBUG metabase.server.middleware.log GET /api/setup/admin_checklist 200 59.6 ms (11 DB calls) App DB connections: 0/7 Jetty threads: 3/50 (6 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[b865c215-0208-4d72-a16d-0600f62ef8ef] 2023-02-09T10:20:04+03:00 DEBUG metabase.server.middleware.log GET /api/util/bug_report_details 200 14.9 ms (1 DB calls) App DB connections: 0/7 Jetty threads: 3/50 (6 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)

Not sure how did this happen, but collection_position is set to 0. As the logs say, it has to be either null or a number greater than zero (1).

Two things:

  1. If you can access your application database, you can alter this value (set it to null if you don't want it to be pinned or to 1 if you want it pinned)
  2. Please do not use H2 in production

Is it clear understanding that I should remove H2 Titles from Dashboard? I don't have access to the database.

No.
You have to open an application database. Because you're using H2, it's going to be a file on your system metabase.db.mv.db. You can connect to it using a tool like DBeaver or similar. Do not confuse this with your external data source, which is MySQL.

My second suggestion was to stop using H2 as your application database as it's easy to end up with a corrupted file (as you've experienced). You'll find this helpful

I'd first fix the corruption on your application database, and only then try to migrate to something like Postgres or MySQL.

1 Like