Support for New Location of .debug File

Why it matters

This feature addresses the issue where the .debug file had been moved, ensuring that ClickHouse can correctly locate and use the debugging file. It fixes issue #19348, improving debugging and error investigation workflows.

How to use it

No special user action is required. ClickHouse now automatically supports the new location of the .debug file, enabling seamless debugging without manual configuration changes.