Bug Report: Funnel query with many steps throws a timeout

[skoob13]

Bug Description

Bug description

Funnel query with 12+ steps sometimes never completes for users because the SQL query is terminated.

How to reproduce

1. Create a funnel query with many steps (e.g. 14)
2. Query is terminated after a timeout

Response from the query status endpoint

{
    "type": "invalid_request",
    "code": "not_found",
    "detail": "Query c36f4d80-6404-44c1-8b08-a303f97cf9bf not found for team",
    "attr": null
}

Exception

Code: 210. DB::NetException: Connection reset by peer, while reading from socket (ip:50148). (NETWORK_ERROR) (version 23.12.5.81 (official build))

Additional context

• Example Query on Metabase
• Ticket 1 - 14 steps in the funnel
• Ticket 2 - 16 steps in the funnel
• Ticket 3
• Ticket 4
• Ticket 5
• Ticket 6
• Ticket 7
• Internal Discussion 1
• Internal Discussion 2
• Full SQL query for Ticket 1

Debug info

No response

[webjunkie]

+1 https://posthoghelp.zendesk.com/agent/tickets/15970 +1 https://posthoghelp.zendesk.com/agent/tickets/16148

[slshults]

+1 https://posthoghelp.zendesk.com/agent/tickets/17333

[slshults]

+1 https://posthoghelp.zendesk.com/agent/tickets/17350

[slshults]

+1 https://posthoghelp.zendesk.com/agent/tickets/17388

[abigailbramble]

+1 https://posthoghelp.zendesk.com/agent/tickets/17444

[abigailbramble]

+1 https://posthoghelp.zendesk.com/agent/tickets/18226

[slshults]

+1 https://posthoghelp.zendesk.com/agent/tickets/18342

[darkopia]

+1 https://posthoghelp.zendesk.com/agent/tickets/18479

[abigailbramble]

+1 https://posthoghelp.zendesk.com/agent/tickets/19789