Bug: People Search Not Working: "Problem completing query" Error When Searching
Nobody has claimed this yet.
- 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
- Navigate to the People & Groups tab
- Type any search term in the search box
- 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
-
In People & Groups tab:
"There was a problem completing this query" -
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
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- 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