PostHog / PostHog/posthog

Bug: People Search Not Working: "Problem completing query" Error When Searching

Open
#28,463 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

bug feature/persons team/cdp
Dominant language
Python
Stars
39.9k
Forks
3.4k
Avg merge
7h 27m
Merged PRs (30d)
222

Description

Bug Description
Bug Description

Search functionality in the People & Groups tab is not working. When attempting to search for people, an error occurs and no results are returned.

Steps to Reproduce
  1. Navigate to the People & Groups tab
  2. Type any search term in the search box
  3. Observe the error message and lack of results
Current Behavior
  • Error message appears: "There was a problem completing this query"
  • No people are returned in the results
  • When searching for people within an insight, a similar error occurs with additional technical details related to illegal Float64 type
Expected Behavior
  • Search should return matching people results
  • No error message should appear
Error Messages
  1. In People & Groups tab:
    "There was a problem completing this query"

  2. In Insights:
    "There is a problem with this query"
    Detailed error: "Illegal type Float64 of argument of function ilike"
    [Full error message included in original ticket]

Additional Context

The error appears to be related to type handling in the search query, specifically around Float64 type conversion when using the ILIKE function.

Debug info
Kind: bug

Target area: analytics

Report event: http://go/ticketByUUID/eb89a0d1-0d70-4b84-b168-ca71b67c21fe

Session: https://us.posthog.com/project/sTMFPsFhdP1Ssg/replay/0194b79b-5f5b-75cc-80fc-0456e719dc7e?t=136

Exceptions: https://us.posthog.com/project/2/error_tracking?filterGroup=%7B%22type%22%3A%22AND%22%2C%22values%22%3A%5B%7B%22type%22%3A%22AND%22%2C%22values%22%3A%5B%7B%22key%22%3A%22%24session_id%22%2C%22value%22%3A%5B%220194b79b-5f5b-75cc-80fc-0456e719dc7e%22%5D%2C%22operator%22%3A%22exact%22%2C%22type%22%3A%22event%22%7D%5D%7D%5D%7D

Location: https://eu.posthog.com/project/27563/persons

Sentry: http://go/sentryEU/27563

Persons-on-events mode for project: person_id_override_properties_on_events

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by reproducing the failure in the People & Groups tab and in People searches within Insights. Trace the search query handling around the reported illegal Float64 argument passed to ILIKE; done means both searches return matching people without either error message.

Written by the indexing model from the issue text.

Assessment

Tech stack
python
Domain
analytics, databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
28/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.