Hi all, new to MB. Just got it running in a container, trying to add a simple mysql (ver 8) database with 1 table (5 columns, 1 auto inc primary key) and get this error. Tried searching, but came up empty. Any tips? Thank you.
[aae13dc7-8d4a-4f1e-970b-55dfababba7d] 2021-06-18T11:04:55-05:00 DEBUG metabase.server.middleware.log POST /api/setup/validate 400 22.8 ms (0 DB calls)
{:errors {:dbname "Index 1 out of bounds for length 1"}}
[aae13dc7-8d4a-4f1e-970b-55dfababba7d] 2021-06-18T11:04:55-05:00 ERROR metabase.driver.util Database connection error
java.lang.ArrayIndexOutOfBoundsException: Index 1 out of bounds for length 1
at org.mariadb.jdbc.HostAddress.parseSimpleHostAddress(HostAddress.java:167)
at org.mariadb.jdbc.HostAddress.parse(HostAddress.java:138)
at org.mariadb.jdbc.UrlParser.defineUrlParserParameters(UrlParser.java:278)
at org.mariadb.jdbc.UrlParser.parseInternal(UrlParser.java:225)
at org.mariadb.jdbc.UrlParser.parse(UrlParser.java:180)
at org.mariadb.jdbc.Driver.connect(Driver.java:85)
at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
at clojure.java.jdbc$get_driver_connection.invokeStatic(jdbc.clj:271)
at clojure.java.jdbc$get_driver_connection.invoke(jdbc.clj:250)
at clojure.java.jdbc$get_connection.invokeStatic(jdbc.clj:411)
at clojure.java.jdbc$get_connection.invoke(jdbc.clj:274)
at clojure.java.jdbc$db_query_with_resultset_STAR_.invokeStatic(jdbc.clj:1111)
at clojure.java.jdbc$db_query_with_resultset_STAR_.invoke(jdbc.clj:1093)
at clojure.java.jdbc$query.invokeStatic(jdbc.clj:1182)
at clojure.java.jdbc$query.invoke(jdbc.clj:1144)
at clojure.java.jdbc$query.invokeStatic(jdbc.clj:1160)
at clojure.java.jdbc$query.invoke(jdbc.clj:1144)
at metabase.driver.sql_jdbc.connection$can_connect_with_spec_QMARK_.invokeStatic(connection.clj:199)
at metabase.driver.sql_jdbc.connection$can_connect_with_spec_QMARK_.invoke(connection.clj:196)
at metabase.driver.sql_jdbc.connection$can_connect_QMARK_.invokeStatic(connection.clj:207)
at metabase.driver.sql_jdbc.connection$can_connect_QMARK_.invoke(connection.clj:203)
at metabase.driver.sql_jdbc$fn__81342.invokeStatic(sql_jdbc.clj:35)
at metabase.driver.sql_jdbc$fn__81342.invoke(sql_jdbc.clj:33)
at metabase.driver.mysql$fn__80450.invokeStatic(mysql.clj:72)
at metabase.driver.mysql$fn__80450.invoke(mysql.clj:68)
at clojure.lang.MultiFn.invoke(MultiFn.java:234)
at metabase.driver.util$can_connect_with_details_QMARK_$fn__29712.invoke(util.clj:34)
at metabase.util$do_with_timeout$fn__15624.invoke(util.clj:346)
at clojure.core$binding_conveyor_fn$fn__5754.invoke(core.clj:2030)
at clojure.lang.AFn.call(AFn.java:18)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
@bender I think the error returned might be misleading. I think the error might come from something different, likely the Host or Port.
Have not seen this before, but one of the fields contains some character that breaks.
It could be any of the fields - even username/password.
tried changing the db name, username and password, all to simple things...same issue. I know the hostname and port are correct and if I change them I get a different error
@bender If you have some fancy browser extensions (like password manager), then they can be extremely unhelpful in certain situations and fills in details that you cannot see.
@jean And as you can see from this topic - it suddenly started to work, so it seems like it's a browser extension or something like that, which is causing the problem. I don't know what the problem is.
I have the same error:
[e86af93f-4cdc-456e-9ad2-b7a050bd41fc] 2023-01-21T14:00:00+01:00 INFO metabase.task.send-pulses Sending scheduled pulses...
[e86af93f-4cdc-456e-9ad2-b7a050bd41fc] 2023-01-21T14:16:04+01:00 DEBUG metabase.server.middleware.log GET /api/database 200 5.0 ms (4 DB calls) App DB connections: 0/7 Jetty threads: 4/50 (3 idle, 0 queued) (61 total active threads) Queries in flight: 0 (0 queued)
[e86af93f-4cdc-456e-9ad2-b7a050bd41fc] 2023-01-21T14:16:43+01:00 INFO metabase.driver.mysql You may need to add trustServerCertificate=true to the additional connection options to connect with SSL.
[e86af93f-4cdc-456e-9ad2-b7a050bd41fc] 2023-01-21T14:16:43+01:00 ERROR metabase.api.database Cannot connect to Database
clojure.lang.ExceptionInfo: Index 1 out of bounds for length 1 {:message "Index 1 out of bounds for length 1"}
at metabase.driver.util$can_connect_with_details_QMARK_.invokeStatic(util.clj:153)
at metabase.driver.util$can_connect_with_details_QMARK_.doInvoke(util.clj:126)
at clojure.lang.RestFn.invoke(RestFn.java:442)
at metabase.api.database$test_database_connection.invokeStatic(database.clj:598)
at metabase.api.database$test_database_connection.doInvoke(database.clj:588)
at clojure.lang.RestFn.invoke(RestFn.java:425)
at metabase.api.database$fn__78701$test_connection_details__78706$fn__78707.invoke(database.clj:651)
at metabase.api.database$fn__78701$test_connection_details__78706.invoke(database.clj:632)
at metabase.api.database$fn__78734.invokeStatic(database.clj:669)
at metabase.api.database$fn__78734.invoke(database.clj:655)
at compojure.core$wrap_response$fn__29313.invoke(core.clj:160)
at compojure.core$wrap_route_middleware$fn__29297.invoke(core.clj:132)
at compojure.core$wrap_route_info$fn__29302.invoke(core.clj:139)
at compojure.core$wrap_route_matches$fn__29306.invoke(core.clj:151)
at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__29306.invoke(core.clj:152)
at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
at compojure.core$routes$fn__29325.invoke(core.clj:200)
at metabase.server.middleware.auth$enforce_authentication$fn__70566.invoke(auth.clj:17)
at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
at compojure.core$routes$fn__29325.invoke(core.clj:200)
at compojure.core$make_context$handler__29353.invoke(core.clj:289)
at compojure.core$make_context$fn__29357.invoke(core.clj:299)
at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
at compojure.core$make_context$fn__29357.invoke(core.clj:300)
at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
at compojure.core$make_context$fn__29357.invoke(core.clj:300)
at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
at compojure.core$make_context$fn__29357.invoke(core.clj:300)
at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
at compojure.core$make_context$fn__29357.invoke(core.clj:300)
at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
at compojure.core$make_context$fn__29357.invoke(core.clj:300)
at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
at compojure.core$make_context$fn__29357.invoke(core.clj:300)
at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
at compojure.core$make_context$fn__29357.invoke(core.clj:300)
at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
at compojure.core$make_context$fn__29357.invoke(core.clj:300)
at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
at compojure.core$make_context$fn__29357.invoke(core.clj:300)
at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
at metabase.api.routes$fn__82518$fn__82521.invoke(routes.clj:64)
at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
at compojure.core$routes$fn__29325.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__82682$fn__82683.doInvoke(routes.clj:69)
at clojure.lang.RestFn.invoke(RestFn.java:436)
at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
at compojure.core$routes$fn__29325.invoke(core.clj:200)
at compojure.core$make_context$handler__29353.invoke(core.clj:289)
at compojure.core$make_context$fn__29357.invoke(core.clj:299)
at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__29306.invoke(core.clj:153)
at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__29306.invoke(core.clj:153)
at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__29306.invoke(core.clj:153)
at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
at compojure.core$routes$fn__29325$f__29326$respond_SINGLEQUOTE___29327.invoke(core.clj:197)
at metabase.server.routes$fn__82667$fn__82669.invoke(routes.clj:46)
at compojure.core$routes$fn__29325$f__29326.invoke(core.clj:198)
at compojure.core$routes$fn__29325.invoke(core.clj:200)
at metabase.server.middleware.exceptions$catch_uncaught_exceptions$fn__79040.invoke(exceptions.clj:98)
at metabase.server.middleware.exceptions$catch_api_exceptions$fn__79037.invoke(exceptions.clj:86)
at metabase.server.middleware.log$log_api_call$fn__84094$fn__84095$fn__84096.invoke(log.clj:211)
at metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invokeStatic(diagnostic.clj:15)
at metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invoke(diagnostic.clj:9)
at metabase.server.middleware.log$log_api_call$fn__84094$fn__84095.invoke(log.clj:203)
at toucan.db$do_with_call_counting.invokeStatic(db.clj:236)
at toucan.db$do_with_call_counting.invoke(db.clj:229)
at metabase.server.middleware.log$log_api_call$fn__84094.invoke(log.clj:202)
at metabase.server.middleware.browser_cookie$ensure_browser_id_cookie$fn__86991.invoke(browser_cookie.clj:38)
at metabase.server.middleware.security$add_security_headers$fn__63895.invoke(security.clj:149)
at metabase.server.middleware.json$wrap_json_body$fn__86122.invoke(json.clj:63)
at metabase.server.middleware.json$wrap_streamed_json_response$fn__86140.invoke(json.clj:99)
at metabase.server.middleware.offset_paging$handle_paging$fn__63919.invoke(offset_paging.clj:42)
at ring.middleware.keyword_params$wrap_keyword_params$fn__87258.invoke(keyword_params.clj:55)
at ring.middleware.params$wrap_params$fn__87277.invoke(params.clj:77)
at metabase.server.middleware.misc$maybe_set_site_url$fn__36696.invoke(misc.clj:59)
at metabase.server.middleware.session$reset_session_timeout$fn__48385.invoke(session.clj:394)
at metabase.server.middleware.session$bind_current_user$fn__48368$fn__48369.invoke(session.clj:331)
at metabase.server.middleware.session$do_with_current_user.invokeStatic(session.clj:310)
at metabase.server.middleware.session$do_with_current_user.invoke(session.clj:299)
at metabase.server.middleware.session$bind_current_user$fn__48368.invoke(session.clj:330)
at metabase.server.middleware.session$wrap_current_user_info$fn__48350.invoke(session.clj:280)
at metabase.server.middleware.session$wrap_session_id$fn__48334.invoke(session.clj:213)
at metabase.server.middleware.auth$wrap_api_key$fn__70574.invoke(auth.clj:30)
at ring.middleware.cookies$wrap_cookies$fn__87178.invoke(cookies.clj:216)
at metabase.server.middleware.misc$add_content_type$fn__36679.invoke(misc.clj:27)
at metabase.server.middleware.misc$disable_streaming_buffering$fn__36704.invoke(misc.clj:76)
at ring.middleware.gzip$wrap_gzip$fn__87220.invoke(gzip.clj:86)
at metabase.server.middleware.misc$bind_request$fn__36707.invoke(misc.clj:93)
at metabase.server.middleware.ssl$redirect_to_https_middleware$fn__87007.invoke(ssl.clj:38)
at metabase.server$async_proxy_handler$fn__82890.invoke(server.clj:73)
at metabase.server.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a.handle(Unknown Source)
at org.eclipse.jetty.server.handler.StatisticsHandler.handle(StatisticsHandler.java:181)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
at org.eclipse.jetty.server.Server.handle(Server.java:516)
at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:487)
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:732)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:479)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277)
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105)
at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131)
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:409)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883)
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034)
at java.base/java.lang.Thread.run(Unknown Source)
Caused by: java.lang.ArrayIndexOutOfBoundsException: Index 1 out of bounds for length 1
at org.mariadb.jdbc.HostAddress.parseSimpleHostAddress(HostAddress.java:167)
at org.mariadb.jdbc.HostAddress.parse(HostAddress.java:138)
at org.mariadb.jdbc.UrlParser.defineUrlParserParameters(UrlParser.java:274)
at org.mariadb.jdbc.UrlParser.parseInternal(UrlParser.java:222)
at org.mariadb.jdbc.UrlParser.parse(UrlParser.java:178)
at org.mariadb.jdbc.Driver.connect(Driver.java:85)
at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
at clojure.java.jdbc$get_driver_connection.invokeStatic(jdbc.clj:271)
at clojure.java.jdbc$get_driver_connection.invoke(jdbc.clj:250)
at clojure.java.jdbc$get_connection.invokeStatic(jdbc.clj:411)
at clojure.java.jdbc$get_connection.invoke(jdbc.clj:274)
at clojure.java.jdbc$db_query_with_resultset_STAR.invokeStatic(jdbc.clj:1111)
at clojure.java.jdbc$db_query_with_resultset_STAR.invoke(jdbc.clj:1093)
at clojure.java.jdbc$query.invokeStatic(jdbc.clj:1182)
at clojure.java.jdbc$query.invoke(jdbc.clj:1144)
at clojure.java.jdbc$query.invokeStatic(jdbc.clj:1160)
at clojure.java.jdbc$query.invoke(jdbc.clj:1144)
at metabase.driver.sql_jdbc.connection$can_connect_with_spec_QMARK_.invokeStatic(connection.clj:297)
at metabase.driver.sql_jdbc.connection$can_connect_with_spec_QMARK_.invoke(connection.clj:294)
at metabase.driver.sql_jdbc.connection$can_connect_QMARK_$fn__36330.invoke(connection.clj:306)
at metabase.driver.sql_jdbc.connection$do_with_connection_spec_for_testing_connection$fn__36312.invoke(connection.clj:282)
at metabase.util.ssh$do_with_ssh_tunnel.invokeStatic(ssh.clj:139)
at metabase.util.ssh$do_with_ssh_tunnel.invoke(ssh.clj:128)
at metabase.driver.sql_jdbc.connection$do_with_connection_spec_for_testing_connection.invokeStatic(connection.clj:280)
at metabase.driver.sql_jdbc.connection$do_with_connection_spec_for_testing_connection.invoke(connection.clj:276)
at metabase.driver.sql_jdbc.connection$can_connect_QMARK_.invokeStatic(connection.clj:305)
at metabase.driver.sql_jdbc.connection$can_connect_QMARK_.invoke(connection.clj:301)
at metabase.driver.sql_jdbc$fn__88483.invokeStatic(sql_jdbc.clj:38)
at metabase.driver.sql_jdbc$fn__88483.invoke(sql_jdbc.clj:36)
at metabase.driver.mysql$fn__86544.invokeStatic(mysql.clj:103)
at metabase.driver.mysql$fn__86544.invoke(mysql.clj:99)
at clojure.lang.MultiFn.invoke(MultiFn.java:234)
at metabase.driver.util$can_connect_with_details_QMARK_$fn__33794.invoke(util.clj:138)
at clojure.core$binding_conveyor_fn$fn__5823.invoke(core.clj:2047)
at clojure.lang.AFn.call(AFn.java:18)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
... 1 more
[e86af93f-4cdc-456e-9ad2-b7a050bd41fc] 2023-01-21T14:16:43+01:00 DEBUG metabase.server.middleware.log POST /api/database 400 13.4 ms (0 DB calls)
{:message "Index 1 out of bounds for length 1"}