Add FailedInternal*Query profile events

Why it matters

This feature introduces specific profiling events that allow better identification and analysis of failed internal queries. It helps users monitor internal query failures more effectively, improving diagnostics and performance tuning.

How to use it

Users can monitor the new FailedInternal*Query profile events through existing ClickHouse profiling and logging mechanisms to gain insights into internal query failures.