[branch-2.1](tracing) Pick pipeline tracing and relative bugfix

[zclllyybb]

Proposed changes

Issue Number: close #xxx

cherry pick https://github.com/apache/doris/pull/31027, https://github.com/apache/doris/pull/31305 and https://github.com/apache/doris/pull/31357

Further comments

If this is a relatively large or complex change, kick off the discussion at [email protected] by explaining why you chose the solution you did and what alternatives you considered, etc...

[doris-robot]

Thank you for your contribution to Apache Doris. Don't know what should be done next? See How to process your PR