awslabs / awslabs/amazon-redshift-utils
SimpleReplay and error: cursors can only be used within the transaction that created them.
Open
- Dominant language
- Python
- Stars
- 2.8k
- Forks
- 1.2k
- PR merge metrics
- No merged PRs in 30d
Description
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";
```
Contributor guide
Assessment
This issue has not been assessed yet.