Confirmation

• I confirm that I am a maintainer and so can use this template. If I am not, I understand this issue will be closed and I will be asked to use a different template.

Issue body

Follow up to #6098, add auto-debugging loop to CodeExecutionAgent so it automatically tries to regenerate code when there is error.