Successfully reconnected after internal server error, transaction was rolled back

hemanthsch
Contributor

We got the below error for our few pipelines and all those pipelines got failed
Error: [40005] Successfully reconnected after internal server error, transaction was rolled back.SessionID: 1697730546883690111.
Can anyone tell me the reason and solution for this issue?

Thanks in Advance,

2 REPLIES 2

mwellbro
Xpert

Hi @hemanthsch ,

could be a number of things - do you have auditing enabled ? Might be worth looking into to get the exact statement that caused this.

Also, this might be thrown if you have a script enabled that kills connections based on runtime or temp_mem behaviour.

Aaand it could be just what it says, an interntal server error => bug.

Which version are you sporting ? Could you disclose the sql that caused the session to error out ?

Cheers,
Malte

hemanthsch
Contributor

Thanks for your response