awslabs / awslabs/amazon-redshift-utils

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

Open
#545 1 comment 0 reactions 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.