- 新しい順
- 投票が多い順
- コメントが多い順
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
関連するコンテンツ
- 質問済み 6年前
- AWS公式更新しました 2年前
- AWS公式更新しました 2年前