[e8d2717d-4a9a-4ee8-af87-f6b9a036324a] 2021-03-12T12:55:16-03:00 ERROR metabase.server.middleware.log PUT /api/collection/graph 500 322.6 ms (27 chamadas ao banco de dados)
{:via
[{:type java.sql.SQLSyntaxErrorException,
:message “(conn=4172946) Data too long for column ‘before’ at row 1”,
:at [org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory createException “ExceptionFactory.java” 62]}
{:type org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException,
:message “Data too long for column ‘before’ at row 1”,
:at [org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException of “MariaDbSqlException.java” 34]}
{:type java.sql.SQLException,
:message “Data too long for column ‘before’ at row 1”,
:at [org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol readErrorPacket “AbstractQueryProtocol.java” 1688]}],
:trace
[[org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol readErrorPacket “AbstractQueryProtocol.java” 1688]
[org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol readPacket “AbstractQueryProtocol.java” 1550]
[org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol getResult “AbstractQueryProtocol.java” 1513]
[org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol executeQuery “AbstractQueryProtocol.java” 318]
[org.mariadb.jdbc.ClientSidePreparedStatement executeInternal “ClientSidePreparedStatement.java” 220]
[org.mariadb.jdbc.ClientSidePreparedStatement execute “ClientSidePreparedStatement.java” 149]
[org.mariadb.jdbc.ClientSidePreparedStatement executeUpdate “ClientSidePreparedStatement.java” 181]
[com.mchange.v2.c3p0.impl.NewProxyPreparedStatement executeUpdate “NewProxyPreparedStatement.java” 462]
[clojure.java.jdbc$db_do_execute_prepared_return_keys$exec_and_return_keys__27192 invoke “jdbc.clj” 979]
[clojure.java.jdbc$db_do_execute_prepared_return_keys invokeStatic “jdbc.clj” 1007]
[clojure.java.jdbc$db_do_execute_prepared_return_keys invoke “jdbc.clj” 963]
[clojure.java.jdbc$db_do_prepared_return_keys invokeStatic “jdbc.clj” 1038]
[clojure.java.jdbc$db_do_prepared_return_keys invoke “jdbc.clj” 1015]
[toucan.db$simple_insert_many_BANG_$iter__28088__28092$fn__28093$fn__28094 invoke “db.clj” 563]
[toucan.db$simple_insert_many_BANG_$iter__28088__28092$fn__28093 invoke “db.clj” 561]
[clojure.lang.LazySeq sval “LazySeq.java” 42]
[clojure.lang.LazySeq seq “LazySeq.java” 51]
[clojure.lang.RT seq “RT.java” 535]
[clojure.core$seq__5402 invokeStatic “core.clj” 137]
[clojure.core$dorun invokeStatic “core.clj” 3133]
[clojure.core$doall invokeStatic “core.clj” 3148]
[clojure.core$doall invoke “core.clj” 3148]
[toucan.db$simple_insert_many_BANG_ invokeStatic “db.clj” 560]
[toucan.db$simple_insert_many_BANG_ invoke “db.clj” 546]
[toucan.db$simple_insert_BANG_ invokeStatic “db.clj” 593]
[toucan.db$simple_insert_BANG_ invoke “db.clj” 582]
[toucan.db$insert_BANG_ invokeStatic “db.clj” 610]
[toucan.db$insert_BANG_ invoke “db.clj” 597]
[toucan.db$insert_BANG_ invokeStatic “db.clj” 613]
[toucan.db$insert_BANG_ doInvoke “db.clj” 597]
[clojure.lang.RestFn invoke “RestFn.java” 731]
[metabase.models.collection.graph$save_perms_revision_BANG_ invokeStatic “graph.clj” 126]
[metabase.models.collection.graph$save_perms_revision_BANG_ invoke “graph.clj” 116]
[metabase.models.collection.graph$fn__55336$update_graph_BANG___55345$fn__55348$fn__55371 invoke “graph.clj” 155]
[toucan.db$do_in_transaction$fn__27920 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.models.collection.graph$fn__55336$update_graph_BANG___55345$fn__55348 invoke “graph.clj” 152]
[metabase.models.collection.graph$fn__55336$update_graph_BANG___55345 invoke “graph.clj” 132]
[metabase.api.collection$fn__55788 invokeStatic “collection.clj” 369]
[metabase.api.collection$fn__55788 invoke “collection.clj” 361]
[compojure.core$wrap_response$fn__1993 invoke “core.clj” 160]
[compojure.core$wrap_route_middleware$fn__1977 invoke “core.clj” 132]
[compojure.core$wrap_route_info$fn__1982 invoke “core.clj” 139]
[compojure.core$wrap_route_matches$fn__1986 invoke “core.clj” 151]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007 invoke “core.clj” 197]
[compojure.core$wrap_route_matches$fn__1986 invoke “core.clj” 153]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007 invoke “core.clj” 197]
[compojure.core$wrap_route_matches$fn__1986 invoke “core.clj” 153]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007 invoke “core.clj” 197]
[compojure.core$wrap_route_matches$fn__1986 invoke “core.clj” 153]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007 invoke “core.clj” 197]
[compojure.core$wrap_route_matches$fn__1986 invoke “core.clj” 153]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007 invoke “core.clj” 197]
[compojure.core$wrap_route_matches$fn__1986 invoke “core.clj” 152]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007 invoke “core.clj” 197]
[compojure.core$wrap_route_matches$fn__1986 invoke “core.clj” 153]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005 invoke “core.clj” 200]
[metabase.server.middleware.auth$enforce_authentication$fn__73836 invoke “auth.clj” 14]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005 invoke “core.clj” 200]
[compojure.core$make_context$handler__2033 invoke “core.clj” 287]
[compojure.core$make_context$fn__2035 invoke “core.clj” 296]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007 invoke “core.clj” 197]
[compojure.core$make_context$fn__2035 invoke “core.clj” 297]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007 invoke “core.clj” 197]
[compojure.core$make_context$fn__2035 invoke “core.clj” 297]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007 invoke “core.clj” 197]
[compojure.core$make_context$fn__2035 invoke “core.clj” 297]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007 invoke “core.clj” 197]
[compojure.core$make_context$fn__2035 invoke “core.clj” 297]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007 invoke “core.clj” 197]
[metabase.api.routes$fn__73957$fn__73959 invoke “routes.clj” 69]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005 invoke “core.clj” 200]
[clojure.lang.AFn applyToHelper “AFn.java” 160]
[clojure.lang.AFn applyTo “AFn.java” 144]
[clojure.core$apply invokeStatic “core.clj” 665]
[clojure.core$apply invoke “core.clj” 660]
[metabase.server.routes$fn__76139$fn__76140 doInvoke “routes.clj” 57]
[clojure.lang.RestFn invoke “RestFn.java” 436]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005 invoke “core.clj” 200]
[compojure.core$make_context$handler__2033 invoke “core.clj” 287]
[compojure.core$make_context$fn__2035 invoke “core.clj” 296]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007 invoke “core.clj” 197]
[compojure.core$wrap_route_matches$fn__1986 invoke “core.clj” 153]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007 invoke “core.clj” 197]
[compojure.core$wrap_route_matches$fn__1986 invoke “core.clj” 153]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007 invoke “core.clj” 197]
[compojure.core$wrap_route_matches$fn__1986 invoke “core.clj” 153]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007 invoke “core.clj” 197]
[metabase.server.routes$fn__76127$fn__76129 invoke “routes.clj” 41]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005 invoke “core.clj” 200]
[metabase.server.middleware.exceptions$catch_uncaught_exceptions$fn__73948 invoke “exceptions.clj” 96]
[metabase.server.middleware.exceptions$catch_api_exceptions$fn__73945 invoke “exceptions.clj” 84]
[metabase.server.middleware.log$log_api_call$fn__76055$fn__76056 invoke “log.clj” 195]
[toucan.db$_do_with_call_counting invokeStatic “db.clj” 216]
[toucan.db$_do_with_call_counting invoke “db.clj” 209]
[metabase.server.middleware.log$log_api_call$fn__76055 invoke “log.clj” 189]
[metabase.server.middleware.security$add_security_headers$fn__73911 invoke “security.clj” 142]
[metabase.server.middleware.json$wrap_json_body$fn__75836 invoke “json.clj” 62]
[metabase.server.middleware.json$wrap_streamed_json_response$fn__75854 invoke “json.clj” 98]
[ring.middleware.keyword_params$wrap_keyword_params$fn__76396 invoke “keyword_params.clj” 55]
[ring.middleware.params$wrap_params$fn__76412 invoke “params.clj” 69]
[metabase.server.middleware.misc$maybe_set_site_url$fn__35081 invoke “misc.clj” 58]
[metabase.server.middleware.session$bind_current_user$fn__41914$fn__41915 invoke “session.clj” 277]
[metabase.server.middleware.session$do_with_current_user invokeStatic “session.clj” 258]
[metabase.server.middleware.session$do_with_current_user invoke “session.clj” 250]
[metabase.server.middleware.session$bind_current_user$fn__41914 invoke “session.clj” 276]
[metabase.server.middleware.session$wrap_current_user_info$fn__41901 invoke “session.clj” 236]
[metabase.server.middleware.session$wrap_session_id$fn__41887 invoke “session.clj” 182]
[metabase.server.middleware.auth$wrap_api_key$fn__73844 invoke “auth.clj” 27]
[ring.middleware.cookies$wrap_cookies$fn__76316 invoke “cookies.clj” 216]
[metabase.server.middleware.misc$add_content_type$fn__35064 invoke “misc.clj” 27]
[metabase.server.middleware.misc$disable_streaming_buffering$fn__35089 invoke “misc.clj” 75]
[ring.middleware.gzip$wrap_gzip$fn__76358 invoke “gzip.clj” 86]
[metabase.server.middleware.misc$bind_request$fn__35092 invoke “misc.clj” 92]
[metabase.server.middleware.ssl$redirect_to_https_middleware$fn__76072 invoke “ssl.clj” 48]
[metabase.server$async_proxy_handler$fn__75669 invoke “server.clj” 71]
[metabase.server.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a handle nil -1]
[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” 383]
[org.eclipse.jetty.server.HttpChannel dispatch “HttpChannel.java” 556]
[org.eclipse.jetty.server.HttpChannel handle “HttpChannel.java” 375]
[org.eclipse.jetty.server.HttpConnection onFillable “HttpConnection.java” 273]
[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” 336]
[org.eclipse.jetty.util.thread.strategy.EatWhatYouKill doProduce “EatWhatYouKill.java” 313]
[org.eclipse.jetty.util.thread.strategy.EatWhatYouKill tryProduce “EatWhatYouKill.java” 171]
[org.eclipse.jetty.util.thread.strategy.EatWhatYouKill run “EatWhatYouKill.java” 129]
[org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread run “ReservedThreadExecutor.java” 375]
[org.eclipse.jetty.util.thread.QueuedThreadPool runJob “QueuedThreadPool.java” 773]
[org.eclipse.jetty.util.thread.QueuedThreadPool$Runner run “QueuedThreadPool.java” 905]
[java.lang.Thread run nil -1]],
:cause “Data too long for column ‘before’ at row 1”,
:message “(conn=4172946) Data too long for column ‘before’ at row 1”,
:type java.sql.SQLSyntaxErrorException,
:sql-exception-chain
[“SQLSyntaxErrorException:”
“Message: (conn=4172946) Data too long for column ‘before’ at row 1”
“SQLState: 22001”
“Error Code: 1406”]}
Hi @tathayde
Post “Diagnostic Info” from Admin > Troubleshooting.
You might need to go an manually change all TEXT type columns in the application database to LONGTEXT (and BLOB to LONGBLOB) - for more context: https://github.com/metabase/metabase/issues/7006