Skip to content

Cannot create cursors in hot standby replica nodes #66

New issue

Have a question about this project? No Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

No Sign up for GitHub

By clicking “No Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? No Sign in to your account

Jump to bottom
Closed
tomas-fp opened this issue Jan 12, 2017 · 1 comment
Closed

Cannot create cursors in hot standby replica nodes #66

tomas-fp opened this issue Jan 12, 2017 · 1 comment
Labels
need more info

Comments

@tomas-fp
Copy link

I'm querying a large dataset using cursors. I can do it properly with against a master node, but if I run against a hot standby replica node I'm getting the following error:

asyncpg.exceptions.FeatureNotSupportedError: cannot use serializable mode in a hot standby

Is it possible to run cursors against replica nodes?
How the hot standby affects this?

Environment:

  • Python v3.6.0
  • asyncpg v0.8.4
  • PostgreSQL v9.4
@tomas-fp tomas-fp changed the title Cannot create cursors in hot replica nodes Cannot create cursors in hot standby replica nodes Jan 12, 2017
@elprans
Copy link
Member

elprans commented Feb 2, 2017

Please provide some example code that triggers this. From your description it looks like you are trying to use transaction(isolation='serializable') on a standby node.

elprans added a commit that referenced this issue Sep 12, 2017
@elprans
Add a test for cursors on a standby replica.
c484a47 
Closes: #66.
No Sign up for free to join this conversation on GitHub. Already have an account? No Sign in to comment
Assignees
No one assigned
Labels
need more info
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@elprans @tomas-fp