- Mais recentes
- Mais votos
- Mais comentários
Hello,
I understand that an error message "invalid transaction termination" occurred when calling a stored procedure and you want to know if patch was applied on the DB Instance.
In order to check the DB Instance, please open a support case with AWS using the following https://console.aws.amazon.com/support/home#/case/create and we can check the DB Instance prior and during the time of the error message to see if there are issue that may have occurred the time frame of the issue.
On further research, the error message can be due to one of the below reasons :
- There may have been custom settings on the database or which are set for session during the execution of the above stored procedures.
- Explicitly starting a transaction with BEGIN before calling the stored procedure.
- if there are SECURITY DEFINER in the stored procedure.
Recommendations :
-
Consider setting autocommit to ON before calling the stored procedure/function. https://www.postgresql.org/docs/12/ecpg-sql-set-autocommit.html
-
I would recommend you review the transaction management : https://www.postgresql.org/docs/12/plpgsql-transactions.html
-
Additional third party link that may help - https://stackoverflow.com/questions/53214740/error-invalid-transaction-termination-when-trying-to-execute-a-procedure-with
Conteúdo relevante
- AWS OFICIALAtualizada há 2 anos
- AWS OFICIALAtualizada há 2 anos
- AWS OFICIALAtualizada há 2 anos