Title: database.read and database.execute_sql should not return the session to the pool till the stream is closed · Issue #3768 · googleapis/google-cloud-python · GitHub
Open Graph Title: database.read and database.execute_sql should not return the session to the pool till the stream is closed · Issue #3768 · googleapis/google-cloud-python
X Title: database.read and database.execute_sql should not return the session to the pool till the stream is closed · Issue #3768 · googleapis/google-cloud-python
Description: Cloud Spanner API says that at any point in time there can be at most one active transaction. But the way database.read and database.execute_query have been implemented, they return the session to the pool immediately. Now that session c...
Open Graph Description: Cloud Spanner API says that at any point in time there can be at most one active transaction. But the way database.read and database.execute_query have been implemented, they return the session to ...
X Description: Cloud Spanner API says that at any point in time there can be at most one active transaction. But the way database.read and database.execute_query have been implemented, they return the session to ...
Opengraph URL: https://github.com/googleapis/google-cloud-python/issues/3768
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"database.read and database.execute_sql should not return the session to the pool till the stream is closed","articleBody":"Cloud Spanner API [says](https://cloud.google.com/spanner/docs/reference/rpc/google.spanner.v1#transactionoptions) that at any point in time there can be at most one active transaction. But the way `database.read` and `database.execute_query` have been implemented, they return the session to the pool immediately. Now that session can be reused for doing something else even before the stream returned by previous `database.read` has completed. This needs to be fixed so that the sessions is returned to the pool only after the iterator has been completely consumed or closed.\r\nThis needs to be done before Beta.\r\n","author":{"url":"https://github.com/vkedia","@type":"Person","name":"vkedia"},"datePublished":"2017-08-08T22:27:45.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":7},"url":"https://github.com/3768/google-cloud-python/issues/3768"}| route-pattern | /_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:0c4d94eb-f94c-c7cc-7495-ccdf60a4e16b |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | 9664:7DC64:849F04:C132AD:6A4E126E |
| html-safe-nonce | c59ce2cb825c0db070d070c311c1fcc5c7881f454ad9fae338674fe4a5148396 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI5NjY0OjdEQzY0Ojg0OUYwNDpDMTMyQUQ6NkE0RTEyNkUiLCJ2aXNpdG9yX2lkIjoiMzc4MjE5NzE3Mzg1ODIxMDQxNCIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9 |
| visitor-hmac | 8331d9ea242abd5c0b6ef9f0b124874ee3d78b9932c4ccebd68d406e1e61511a |
| hovercard-subject-tag | issue:248864783 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/googleapis/google-cloud-python/3768/issue_layout |
| twitter:image | https://opengraph.githubassets.com/1207b8f83bf94f48ef33bf70bc6bcbd2b1aa89b5bf0dc3d0c1e158fc6b59121f/googleapis/google-cloud-python/issues/3768 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/1207b8f83bf94f48ef33bf70bc6bcbd2b1aa89b5bf0dc3d0c1e158fc6b59121f/googleapis/google-cloud-python/issues/3768 |
| og:image:alt | Cloud Spanner API says that at any point in time there can be at most one active transaction. But the way database.read and database.execute_query have been implemented, they return the session to ... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | vkedia |
| hostname | github.com |
| expected-hostname | github.com |
| None | 030096ee0db095447bfe77409d33bfac127ca7128299c58deef27c52eaa1b1f0 |
| turbo-cache-control | no-preview |
| go-import | github.com/googleapis/google-cloud-python git https://github.com/googleapis/google-cloud-python.git |
| octolytics-dimension-user_id | 16785467 |
| octolytics-dimension-user_login | googleapis |
| octolytics-dimension-repository_id | 16316451 |
| octolytics-dimension-repository_nwo | googleapis/google-cloud-python |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 16316451 |
| octolytics-dimension-repository_network_root_nwo | googleapis/google-cloud-python |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | ea9187571e3edc5f2780f750631138669441ca50 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
Links:
Viewport: width=device-width