Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Trying to edit/create a segment for a Google Analytics database breaks Segments interface #13362

Closed
flamber opened this issue Oct 5, 2020 · 1 comment
Closed

Trying to edit/create a segment for a Google Analytics database breaks Segments interface #13362

flamber opened this issue Oct 5, 2020 · 1 comment
Assignees
@paulrosenzweig
Labels
Administration/Metrics & Segments Priority:P1 Security holes w/o exploit, crashing, setup/upgrade, login, broken common features, correctness Type:Bug Product defects
Projects
0.36.1+ and 0.37 (old board -- see mi...
Milestone
0.36.8

Comments

@flamber
Copy link
Contributor

flamber commented Oct 5, 2020 •
edited

Describe the bug
Trying to edit/create a segment for a Google Analytics database breaks Segments interface.

Workaround: restore Segment interface is to manually archive the segment via the application database table segment.archived

To Reproduce

  1. Admin > Data Model > Segments > New segment
  2. Select a Google Analytics database and table
  3. Use the default filter "Date: Previous 365 days"
  4. Give it a name and description, and click Save changes - results in this error: Unexpected input given to normalize. Expected type to be "object", found "string".
    image
  5. And now it's not possible to view/edit/create/remove segments anymore.

There's a request to /api/segment, but with empty results and no errors in the log:

[8882630f-861c-4e3e-9e2d-c4389c0f1606] 2020-10-05T15:15:21+02:00 DEBUG metabase.middleware.log GET /api/segment 200 81.1 ms (42 DB calls) App DB connections: 1/4 Jetty threads: 3/50 (4 idle, 0 queued) (66 total active threads) Queries in flight: 0 (0 queued)

Going to the newly created segment (by finding the segment ID from /api/table/:id/query_metadata) /admin/datamodel/segment/:id, then I'm seeing the following error in the interface:
ERROR: operator does not exist: integer = character varying Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts. Position: 35

Full stacktrace 
[c30b63e4-cba6-4acb-a1cd-0a5ab9619fd2] 2020-10-05T15:24:23+02:00 ERROR metabase.middleware.log GET /api/segment/43 500 15.4 ms (7 DB calls) 
{:via
 [{:type org.postgresql.util.PSQLException,
   :message "ERROR: operator does not exist: integer = character varying\n  Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.\n  Position: 35",
   :at [org.postgresql.core.v3.QueryExecutorImpl receiveErrorResponse "QueryExecutorImpl.java" 2497]}],
 :trace
 [[org.postgresql.core.v3.QueryExecutorImpl receiveErrorResponse "QueryExecutorImpl.java" 2497]
  [org.postgresql.core.v3.QueryExecutorImpl processResults "QueryExecutorImpl.java" 2233]
  [org.postgresql.core.v3.QueryExecutorImpl execute "QueryExecutorImpl.java" 310]
  [org.postgresql.jdbc.PgStatement executeInternal "PgStatement.java" 446]
  [org.postgresql.jdbc.PgStatement execute "PgStatement.java" 370]
  [org.postgresql.jdbc.PgPreparedStatement executeWithFlags "PgPreparedStatement.java" 149]
  [org.postgresql.jdbc.PgPreparedStatement executeQuery "PgPreparedStatement.java" 108]
  [com.mchange.v2.c3p0.impl.NewProxyPreparedStatement executeQuery "NewProxyPreparedStatement.java" 431]
  [clojure.java.jdbc$execute_query_with_params invokeStatic "jdbc.clj" 1090]
  [clojure.java.jdbc$execute_query_with_params invoke "jdbc.clj" 1084]
  [clojure.java.jdbc$db_query_with_resultset_STAR_ invokeStatic "jdbc.clj" 1113]
  [clojure.java.jdbc$db_query_with_resultset_STAR_ invoke "jdbc.clj" 1093]
  [clojure.java.jdbc$query invokeStatic "jdbc.clj" 1182]
  [clojure.java.jdbc$query invoke "jdbc.clj" 1144]
  [toucan.db$query invokeStatic "db.clj" 288]
  [toucan.db$query doInvoke "db.clj" 284]
  [clojure.lang.RestFn invoke "RestFn.java" 410]
  [toucan.db$simple_select invokeStatic "db.clj" 394]
  [toucan.db$simple_select invoke "db.clj" 383]
  [toucan.db$simple_select_one invokeStatic "db.clj" 420]
  [toucan.db$simple_select_one invoke "db.clj" 409]
  [toucan.db$select_one invokeStatic "db.clj" 627]
  [toucan.db$select_one doInvoke "db.clj" 620]
  [clojure.lang.RestFn applyTo "RestFn.java" 139]
  [clojure.lang.Var applyTo "Var.java" 705]
  [clojure.core$apply invokeStatic "core.clj" 671]
  [clojure.core$apply invoke "core.clj" 660]
  [toucan.models$invoke_model invokeStatic "models.clj" 380]
  [toucan.models$invoke_model doInvoke "models.clj" 368]
  [clojure.lang.RestFn invoke "RestFn.java" 445]
  [toucan.models$invoke_model invokeStatic "models.clj" 378]
  [toucan.models$invoke_model invoke "models.clj" 368]
  [clojure.lang.AFn applyToHelper "AFn.java" 156]
  [clojure.lang.RestFn applyTo "RestFn.java" 132]
  [clojure.core$apply invokeStatic "core.clj" 667]
  [clojure.core$apply invoke "core.clj" 660]
  [toucan.models$invoke_model_or_instance invokeStatic "models.clj" 395]
  [toucan.models$invoke_model_or_instance doInvoke "models.clj" 391]
  [clojure.lang.RestFn invoke "RestFn.java" 423]
  [metabase.models.metric.MetricInstance invoke "metric.clj" 21]
  [metabase.api.query_description$get_aggregation_details$match_57153__57154$fn__57169$fn__57170 invoke "query_description.clj" 22]
  [metabase.api.query_description$get_aggregation_details$match_57153__57154$fn__57169 invoke "query_description.clj" 22]
  [metabase.api.query_description$get_aggregation_details$match_57153__57154 invoke "query_description.clj" 22]
  [clojure.core$partial$fn__5839 invoke "core.clj" 2624]
  [clojure.core$map$fn__5866 invoke "core.clj" 2753]
  [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$apply invokeStatic "core.clj" 660]
  [clojure.core$mapcat invokeStatic "core.clj" 2783]
  [clojure.core$mapcat doInvoke "core.clj" 2783]
  [clojure.lang.RestFn invoke "RestFn.java" 423]
  [metabase.mbql.util.match$match_in_collection invokeStatic "match.clj" 96]
  [metabase.mbql.util.match$match_in_collection invoke "match.clj" 86]
  [metabase.api.query_description$get_aggregation_details$match_57153__57154$fn__57169$fn__57170$fn__57171$fn__57176 invoke "query_description.clj" 22]
  [metabase.api.query_description$get_aggregation_details$match_57153__57154$fn__57169$fn__57170$fn__57171 invoke "query_description.clj" 22]
  [metabase.api.query_description$get_aggregation_details$match_57153__57154$fn__57169$fn__57170 invoke "query_description.clj" 22]
  [metabase.api.query_description$get_aggregation_details$match_57153__57154$fn__57169 invoke "query_description.clj" 22]
  [metabase.api.query_description$get_aggregation_details$match_57153__57154 invoke "query_description.clj" 22]
  [metabase.mbql.util.match$match_in_collection$iter__24876__24880$fn__24881 invoke "match.clj" 93]
  [clojure.lang.LazySeq sval "LazySeq.java" 42]
  [clojure.lang.LazySeq seq "LazySeq.java" 51]
  [clojure.lang.Cons next "Cons.java" 39]
  [clojure.lang.RT next "RT.java" 713]
  [clojure.core$next__5386 invokeStatic "core.clj" 64]
  [clojure.core.protocols$fn__8159 invokeStatic "protocols.clj" 169]
  [clojure.core.protocols$fn__8159 invoke "protocols.clj" 124]
  [clojure.core.protocols$fn__8114$G__8109__8123 invoke "protocols.clj" 19]
  [clojure.core.protocols$seq_reduce invokeStatic "protocols.clj" 27]
  [clojure.core.protocols$fn__8146 invokeStatic "protocols.clj" 75]
  [clojure.core.protocols$fn__8146 invoke "protocols.clj" 75]
  [clojure.core.protocols$fn__8088$G__8083__8101 invoke "protocols.clj" 13]
  [clojure.core$reduce invokeStatic "core.clj" 6824]
  [clojure.core$reduce invoke "core.clj" 6810]
  [metabase.mbql.util.match$match_in_collection invokeStatic "match.clj" 92]
  [metabase.mbql.util.match$match_in_collection invoke "match.clj" 86]
  [metabase.api.query_description$get_aggregation_details$match_57153__57154$fn__57169$fn__57170$fn__57171$fn__57176 invoke "query_description.clj" 22]
  [metabase.api.query_description$get_aggregation_details$match_57153__57154$fn__57169$fn__57170$fn__57171 invoke "query_description.clj" 22]
  [metabase.api.query_description$get_aggregation_details$match_57153__57154$fn__57169$fn__57170 invoke "query_description.clj" 22]
  [metabase.api.query_description$get_aggregation_details$match_57153__57154$fn__57169 invoke "query_description.clj" 22]
  [metabase.api.query_description$get_aggregation_details$match_57153__57154 invoke "query_description.clj" 22]
  [metabase.api.query_description$get_aggregation_details invokeStatic "query_description.clj" 22]
  [metabase.api.query_description$get_aggregation_details invoke "query_description.clj" 17]
  [metabase.api.query_description$get_aggregation_description invokeStatic "query_description.clj" 51]
  [metabase.api.query_description$get_aggregation_description invoke "query_description.clj" 49]
  [metabase.api.query_description$generate_query_description$fn__57252 invoke "query_description.clj" 113]
  [clojure.core$map$fn__5866 invoke "core.clj" 2753]
  [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$apply invokeStatic "core.clj" 660]
  [clojure.core$apply invoke "core.clj" 660]
  [metabase.api.query_description$generate_query_description invokeStatic "query_description.clj" 112]
  [metabase.api.query_description$generate_query_description invoke "query_description.clj" 99]
  [metabase.api.segment$add_query_descriptions$iter__66450__66454$fn__66455$fn__66456 invoke "segment.clj" 56]
  [metabase.api.segment$add_query_descriptions$iter__66450__66454$fn__66455 invoke "segment.clj" 52]
  [clojure.lang.LazySeq sval "LazySeq.java" 42]
  [clojure.lang.LazySeq seq "LazySeq.java" 51]
  [clojure.lang.LazySeq first "LazySeq.java" 73]
  [clojure.lang.RT first "RT.java" 692]
  [clojure.core$first__5384 invokeStatic "core.clj" 55]
  [clojure.core$first__5384 invoke "core.clj" 55]
  [metabase.api.segment$fn__66465 invokeStatic "segment.clj" 61]
  [metabase.api.segment$fn__66465 invoke "segment.clj" 58]
  [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" 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" 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$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$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.middleware.auth$enforce_authentication$fn__68577 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]
  [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]
  [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]
  [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]
  [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]
  [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 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.routes$fn__69974$fn__69975 doInvoke "routes.clj" 56]
  [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" 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" 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" 152]
  [compojure.core$routes$fn__2005$f__2006 invoke "core.clj" 198]
  [compojure.core$routes$fn__2005 invoke "core.clj" 200]
  [metabase.middleware.exceptions$catch_uncaught_exceptions$fn__68680 invoke "exceptions.clj" 96]
  [metabase.middleware.exceptions$catch_api_exceptions$fn__68677 invoke "exceptions.clj" 84]
  [metabase.middleware.log$log_api_call$fn__70422$fn__70423 invoke "log.clj" 197]
  [toucan.db$_do_with_call_counting invokeStatic "db.clj" 216]
  [toucan.db$_do_with_call_counting invoke "db.clj" 209]
  [metabase.middleware.log$log_api_call$fn__70422 invoke "log.clj" 191]
  [metabase.middleware.security$add_security_headers$fn__68643 invoke "security.clj" 121]
  [metabase.middleware.json$wrap_json_body$fn__70125 invoke "json.clj" 64]
  [metabase.middleware.json$wrap_streamed_json_response$fn__70143 invoke "json.clj" 100]
  [ring.middleware.keyword_params$wrap_keyword_params$fn__70723 invoke "keyword_params.clj" 55]
  [ring.middleware.params$wrap_params$fn__70739 invoke "params.clj" 69]
  [metabase.middleware.misc$maybe_set_site_url$fn__70453 invoke "misc.clj" 59]
  [metabase.middleware.session$bind_current_user$fn__65135$fn__65136 invoke "session.clj" 204]
  [metabase.middleware.session$do_with_current_user invokeStatic "session.clj" 186]
  [metabase.middleware.session$do_with_current_user invoke "session.clj" 178]
  [metabase.middleware.session$bind_current_user$fn__65135 invoke "session.clj" 203]
  [metabase.middleware.session$wrap_current_user_info$fn__65122 invoke "session.clj" 169]
  [metabase.middleware.session$wrap_session_id$fn__65110 invoke "session.clj" 127]
  [metabase.middleware.auth$wrap_api_key$fn__68585 invoke "auth.clj" 27]
  [ring.middleware.cookies$wrap_cookies$fn__70643 invoke "cookies.clj" 216]
  [metabase.middleware.misc$add_content_type$fn__70438 invoke "misc.clj" 28]
  [metabase.middleware.misc$disable_streaming_buffering$fn__70461 invoke "misc.clj" 76]
  [ring.middleware.gzip$wrap_gzip$fn__70685 invoke "gzip.clj" 86]
  [metabase.middleware.ssl$redirect_to_https_middleware$fn__70474 invoke "ssl.clj" 49]
  [metabase.server$async_proxy_handler$fn__70200 invoke "server.clj" 72]
  [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" 500]
  [org.eclipse.jetty.server.HttpChannel lambda$handle$1 "HttpChannel.java" 383]
  [org.eclipse.jetty.server.HttpChannel dispatch "HttpChannel.java" 547]
  [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" 103]
  [org.eclipse.jetty.io.ChannelEndPoint$2 run "ChannelEndPoint.java" 117]
  [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" 806]
  [org.eclipse.jetty.util.thread.QueuedThreadPool$Runner run "QueuedThreadPool.java" 938]
  [java.lang.Thread run nil -1]],
 :cause "ERROR: operator does not exist: integer = character varying\n  Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.\n  Position: 35",
 :message "ERROR: operator does not exist: integer = character varying\n  Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.\n  Position: 35",
 :type org.postgresql.util.PSQLException,
 :sql-exception-chain
 ["PSQLException:"
  "Message: ERROR: operator does not exist: integer = character varying"
  "Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts."
  "Position: 35"
  "SQLState: 42883"
  "Error Code: 0"]}

Information about your Metabase Installation:
Metabase 0.36.6

Severity
Giving P1, since it breaks the entire Segments interface and is very difficult to fix.

Additional context
https://discourse.metabase.com/t/segments-section-is-broken/11860
Very related to #10844
@flamber flamber added Type:Bug Product defects Priority:P1 Security holes w/o exploit, crashing, setup/upgrade, login, broken common features, correctness Administration/Metrics & Segments labels Oct 5, 2020
@paulrosenzweig paulrosenzweig self-assigned this Oct 16, 2020
@paulrosenzweig paulrosenzweig mentioned this issue Oct 16, 2020
Merged
@paulrosenzweig paulrosenzweig added this to Bug fixes (0.36.1+) in 0.36.1+ and 0.37 (old board -- see milestones instead) via automation Oct 16, 2020
@paulrosenzweig paulrosenzweig moved this from Bug fixes (0.36.1+) to Waiting for review in 0.36.1+ and 0.37 (old board -- see milestones instead) Oct 16, 2020
@paulrosenzweig
Copy link
Contributor

The bad part of this error was fixed in #13508. #13507 covers the rest.

0.36.1+ and 0.37 (old board -- see milestones instead) automation moved this from Waiting for review to Done Oct 16, 2020
@flamber flamber added this to the 0.36.8 milestone Oct 17, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@paulrosenzweig paulrosenzweig

Labels
Administration/Metrics & Segments Priority:P1 Security holes w/o exploit, crashing, setup/upgrade, login, broken common features, correctness Type:Bug Product defects
Projects
No open projects
0.36.1+ and 0.37 (old board -- see mi...
  
Done
Milestone
0.36.8
Development

No branches or pull requests
2 participants
@paulrosenzweig @flamber