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

[BUG] Error while typing search query (w/ postgres) #5802

Open
GICodeWarrior opened this issue Dec 20, 2024 · 0 comments
Open

[BUG] Error while typing search query (w/ postgres) #5802

GICodeWarrior opened this issue Dec 20, 2024 · 0 comments
Labels
bug Something isn't working c/traces triage issues that need triage

Comments

@GICodeWarrior
Copy link

Describe the bug
While typing a search query, the UI "crashed" and was replaced with the error message below.

To Reproduce
Steps to reproduce the behavior:

  1. Open a tracing project
  2. Search for "" in input.value and span.k
  3. Note that entire UI is replaced with an error screen

Expected behavior
Other invalid queries outline the box in red. It seems like that should be the expected case here as well.

Screenshots
Screenshot 2024-12-20 at 9 52 05 AM

Environment (please complete the following information):

  • OS: macOS
  • Browser: Chrome
  • Version: 7.0.1, self-hosted, w/ postgres

Additional context

Error fetching GraphQL query 'TracesTableQuery' with variables '{"after":null,"filterCondition":"\"\" in input.value and span.k","first":50,"sort":{"col":"startTime","dir":"desc"},"timeRange":{"start":"2024-12-13T17:00:00.000Z","end":"2025-12-20T17:00:00.000Z"},"id":"UHJvamVjdDo0"}': [{"message":"(sqlalchemy.dialects.postgresql.asyncpg.ProgrammingError) <class 'asyncpg.exceptions.DatatypeMismatchError'>: argument of AND must be type boolean, not type jsonb\n[SQL: SELECT traces.id, traces.trace_id, spans.id AS id_1, spans.trace_rowid, spans.span_id, spans.parent_id, spans.name, spans.span_kind, spans.start_time, spans.end_time, spans.attributes, spans.events, spans.status_code, spans.status_message, spans.cumulative_error_count, spans.cumulative_llm_token_count_prompt, spans.cumulative_llm_token_count_completion, spans.llm_token_count_prompt, spans.llm_token_count_completion, spans.start_time AS \"f{self.name}_span_sort_column\" \nFROM spans JOIN traces ON traces.id = spans.trace_rowid LEFT OUTER JOIN (SELECT spans.span_id AS span_id \nFROM spans) AS anon_1 ON spans.parent_id = anon_1.span_id \nWHERE traces.project_rowid = $1::INTEGER AND spans.start_time >= $2::TIMESTAMP WITH TIME ZONE AND spans.start_time < $3::TIMESTAMP WITH TIME ZONE AND anon_1.span_id IS NULL AND strpos(CAST((spans.attributes #>> $4) AS VARCHAR), $5::VARCHAR) > $6::INTEGER AND (spans.attributes #> $7) ORDER BY \"f{self.name}_span_sort_column\" DESC NULLS LAST, spans.id DESC \n LIMIT $8::INTEGER]\n[parameters: (4, datetime.datetime(2024, 12, 13, 17, 0, tzinfo=datetime.timezone.utc), datetime.datetime(2025, 12, 20, 17, 0, tzinfo=datetime.timezone.utc), ['input', 'value'], '', 0, ['span', 'k'], 51)]\n(Background on this error at: https://sqlalche.me/e/20/f405)","locations":[{"line":24,"column":3}],"path":["node","rootSpans"]}]

@GICodeWarrior GICodeWarrior added bug Something isn't working triage issues that need triage labels Dec 20, 2024
@github-project-automation github-project-automation bot moved this to 📘 Todo in phoenix Dec 20, 2024
@dosubot dosubot bot added the c/traces label Dec 20, 2024
@GICodeWarrior GICodeWarrior changed the title [BUG] Error while typing search query [BUG] Error while typing search query (w/ postgres) Dec 24, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working c/traces triage issues that need triage
Projects
Status: 📘 Todo
Development

No branches or pull requests

1 participant