amazon-redshift-utils icon indicating copy to clipboard operation
amazon-redshift-utils copied to clipboard

SimpleReplay and error: cursors can only be used within the transaction that created them.

Open jsyrjala opened this issue 4 years ago • 1 comments

When running replay.py, I am occasionally seeing errors like this

[ERROR] 2021-04-06 10:38:32 [12] (260) Exception in connect: {'S': 'ERROR', 'C': 'XX000', 'M': 'cursors can only be used within the transaction that created them.', 'F': '/home/ec2-user/padb/src/pg/src/backend/utils/misc/superuser.c', 'L': '88', 'R': 'featureEnabledForBootstrapUserOnly'}

So basically a cursor is created and multiple commands like this will be used to fetch data.

fetch 10000 in "SQL_CUR7";

jsyrjala avatar Apr 06 '21 10:04 jsyrjala

jsyrjala, Thank you for the feedback. We will take a look and address the issue.

ragsrina avatar Apr 13 '21 22:04 ragsrina