amazon-redshift-utils
amazon-redshift-utils copied to clipboard
SimpleReplay and error: cursors can only be used within the transaction that created them.
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, Thank you for the feedback. We will take a look and address the issue.