Skip to content
New issue

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

Sign up for GitHub

By clicking “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? Sign in to your account

Jump to bottom

investigate "Error: pq: no unpinned buffers available" error #122

Closed
kaidaguerre opened this issue Feb 1, 2021 · 1 comment
Closed

investigate "Error: pq: no unpinned buffers available" error #122

kaidaguerre opened this issue Feb 1, 2021 · 1 comment
Assignees
@binaek
Labels
bug Something isn't working
Milestone
0.1.3

Comments

@kaidaguerre
Copy link
Contributor 

@kai @binaek my best guess from quick research is that it's related to our small shared_buffers size  defined here - https://github.com/turbot/steampipe/blob/main/db/start.go#L126```
@kaidaguerre kaidaguerre added the bug Something isn't working label Feb 1, 2021
@e-gineer
Copy link
Contributor

e-gineer commented Feb 6, 2021

FYI - since commenting out that setting as a test I’ve not seen this problem again.

We need to review these settings for the optimal values. Perhaps ask the Postgres mailing list for a quick review?

@kaidaguerre kaidaguerre added this to the 0.1.2 milestone Feb 9, 2021
kaidaguerre pushed a commit that referenced this issue Feb 11, 2021
@binaek @kaidaguerre
Fix 'no unpinned buffers available' error. Remove shared buffer size …
25bcefb 
…limitation. Closes #122
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@binaek binaek

Labels
bug Something isn't working
Projects
None yet
Milestone
0.1.3
Development

No branches or pull requests
3 participants
@binaek @e-gineer @kaidaguerre