René's URL Explorer Experiment


Title: Possible memory leak when using Google Sheets API · Issue #535 · googleapis/google-api-python-client · GitHub

Open Graph Title: Possible memory leak when using Google Sheets API · Issue #535 · googleapis/google-api-python-client

X Title: Possible memory leak when using Google Sheets API · Issue #535 · googleapis/google-api-python-client

Description: There seems to be a memory leak when using the google-api-client with GSheets. Environment: $ python --version Python 3.6.4 $ pip show google-api-python-client Name: google-api-python-client Version: 1.7.3 Here's a simple reproducer (wit...

Open Graph Description: There seems to be a memory leak when using the google-api-client with GSheets. Environment: $ python --version Python 3.6.4 $ pip show google-api-python-client Name: google-api-python-client Versio...

X Description: There seems to be a memory leak when using the google-api-client with GSheets. Environment: $ python --version Python 3.6.4 $ pip show google-api-python-client Name: google-api-python-client Versio...

Opengraph URL: https://github.com/googleapis/google-api-python-client/issues/535

X: @github

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Possible memory leak when using Google Sheets API","articleBody":"There seems to be a memory leak when using the google-api-client with GSheets.\r\n\r\nEnvironment:\r\n```\r\n$ python --version\r\nPython 3.6.4\r\n$ pip show google-api-python-client\r\nName: google-api-python-client\r\nVersion: 1.7.3\r\n```\r\n\r\nHere's a simple reproducer (without a `.client_secret.json`):\r\n```python\r\n#!/usr/bin/env python3\r\n\r\nimport httplib2\r\nimport os\r\nfrom apiclient import discovery\r\nfrom memory_profiler import profile\r\nfrom oauth2client import client, tools\r\nfrom oauth2client.file import Storage\r\nfrom time import sleep\r\n\r\nSCOPES = \"https://www.googleapis.com/auth/spreadsheets.readonly\"\r\n# See https://cloud.google.com/docs/authentication/getting-started\r\nCLIENT_SECRET_FILE = \".client_secret.json\"\r\nAPPLICATION_NAME = \"ClientDebug\"\r\nDISCOVERY_URL = \"https://sheets.googleapis.com/$discovery/rest?version=v4\"\r\n\r\ndef get_credentials():\r\n    home_dir = os.path.expanduser(\"~\")\r\n    credential_dir = os.path.join(home_dir, \".credentials\")\r\n    flags = None\r\n    if not os.path.exists(credential_dir):\r\n        os.makedirs(credential_dir)\r\n    credential_path = os.path.join(credential_dir,\r\n                                \"sheets.googleapis.com-clientdebug.json\")\r\n\r\n    store = Storage(credential_path)\r\n    credentials = store.get()\r\n    if not credentials or credentials.invalid:\r\n        flow = client.flow_from_clientsecrets(CLIENT_SECRET_FILE, SCOPES)\r\n        flow.user_agent = APPLICATION_NAME\r\n        credentials = tools.run_flow(flow, store, flags)\r\n\r\n    return credentials\r\n\r\n@profile(precision=4)\r\ndef get_responses(creds):\r\n    \"\"\"Fetch spreadsheet data.\"\"\"\r\n    sheet_id = \"1TowKJrFVbT4Bfp-HFcMh_CZ5anfH0CLfmoqCz9SUr9c\"\r\n\r\n    http = creds.authorize(httplib2.Http())\r\n    service = discovery.build(\"sheets\", \"v4\", http=http,\r\n                discoveryServiceUrl=(DISCOVERY_URL), cache_discovery=False)\r\n    result = service.spreadsheets().values().get(\r\n            spreadsheetId=sheet_id, range=\"A1:O\").execute()\r\n    values = result.get(\"values\", [])\r\n\r\n    print(\"Got {} rows\".format(len(values)))\r\n\r\nif __name__ == \"__main__\":\r\n    creds = get_credentials()\r\n    for i in range(0, 50):\r\n        get_responses(creds)\r\n        sleep(2)\r\n```\r\n\r\nFor measurements I used `memory_profiler` module with following results:\r\n## First and second iteration\r\n```\r\nGot 760 rows\r\nFilename: ./main.py\r\n\r\nLine #    Mem usage    Increment   Line Contents\r\n================================================\r\n    35  26.5195 MiB  26.5195 MiB   @profile(precision=4)\r\n    36                             def get_responses(creds):\r\n    37                                 \"\"\"Fetch spreadsheet data.\"\"\"\r\n    38  26.5195 MiB   0.0000 MiB       sheet_id = \"1TowKJrFVbT4Bfp-HFcMh_CZ5anfH0CLfmoqCz9SUr9c\"\r\n    39                             \r\n    40  26.5195 MiB   0.0000 MiB       http = creds.authorize(httplib2.Http())\r\n    41  26.5195 MiB   0.0000 MiB       service = discovery.build(\"sheets\", \"v4\", http=http,\r\n    42  29.2891 MiB   2.7695 MiB                   discoveryServiceUrl=(DISCOVERY_URL), cache_discovery=False)\r\n    43  49.5742 MiB  20.2852 MiB       result = service.spreadsheets().values().get(\r\n    44  49.5742 MiB   0.0000 MiB               spreadsheetId=sheet_id, range=\"A1:O\").execute()\r\n    45  49.5742 MiB   0.0000 MiB       values = result.get(\"values\", [])\r\n    46                             \r\n    47  49.5742 MiB   0.0000 MiB       print(\"Got {} rows\".format(len(values)))\r\n\r\n\r\nGot 760 rows\r\nFilename: ./main.py\r\n\r\nLine #    Mem usage    Increment   Line Contents\r\n================================================\r\n    35  49.5742 MiB  49.5742 MiB   @profile(precision=4)\r\n    36                             def get_responses(creds):\r\n    37                                 \"\"\"Fetch spreadsheet data.\"\"\"\r\n    38  49.5742 MiB   0.0000 MiB       sheet_id = \"1TowKJrFVbT4Bfp-HFcMh_CZ5anfH0CLfmoqCz9SUr9c\"\r\n    39                             \r\n    40  49.5742 MiB   0.0000 MiB       http = creds.authorize(httplib2.Http())\r\n    41  49.5742 MiB   0.0000 MiB       service = discovery.build(\"sheets\", \"v4\", http=http,\r\n    42  49.5742 MiB   0.0000 MiB                   discoveryServiceUrl=(DISCOVERY_URL), cache_discovery=False)\r\n    43  67.9922 MiB  18.4180 MiB       result = service.spreadsheets().values().get(\r\n    44  67.9922 MiB   0.0000 MiB               spreadsheetId=sheet_id, range=\"A1:O\").execute()\r\n    45  67.9922 MiB   0.0000 MiB       values = result.get(\"values\", [])\r\n    46                             \r\n    47  67.9922 MiB   0.0000 MiB       print(\"Got {} rows\".format(len(values)))\r\n```\r\n\r\n## Last iteration\r\n```\r\nGot 760 rows\r\nFilename: ./main.py\r\n\r\nLine #    Mem usage    Increment   Line Contents\r\n================================================\r\n    35 229.6055 MiB 229.6055 MiB   @profile(precision=4)\r\n    36                             def get_responses(creds):\r\n    37                                 \"\"\"Fetch spreadsheet data.\"\"\"\r\n    38 229.6055 MiB   0.0000 MiB       sheet_id = \"1TowKJrFVbT4Bfp-HFcMh_CZ5anfH0CLfmoqCz9SUr9c\"\r\n    39                             \r\n    40 229.6055 MiB   0.0000 MiB       http = creds.authorize(httplib2.Http())\r\n    41 229.6055 MiB   0.0000 MiB       service = discovery.build(\"sheets\", \"v4\", http=http,\r\n    42 229.6055 MiB   0.0000 MiB                   discoveryServiceUrl=(DISCOVERY_URL), cache_discovery=False)\r\n    43 229.6055 MiB   0.0000 MiB       result = service.spreadsheets().values().get(\r\n    44 229.6055 MiB   0.0000 MiB               spreadsheetId=sheet_id, range=\"A1:O\").execute()\r\n    45 229.6055 MiB   0.0000 MiB       values = result.get(\"values\", [])\r\n    46                             \r\n    47 229.6055 MiB   0.0000 MiB       print(\"Got {} rows\".format(len(values)))\r\n```\r\n\r\nThere's clearly a memory leak, as the reproducer fetches the same data over and over again, yet the memory consumption keeps rising. Full log can be found [here](https://gist.github.com/mrc0mmand/dd306a69e4732a5c1e186d2ce50913fb).\r\n\r\nAs a temporary workaround for one of my long-running applications I use an explicit garbage collector call, which mitigates this issue, at least for now:\r\n\r\n```python\r\n...\r\nimport gc\r\n...\r\n    result = service.spreadsheets().values().get(\r\n            spreadsheetId=sheet_id, range=\"A1:O\").execute()\r\n    values = result.get(\"values\", [])\r\n\r\n    gc.collect()\r\n...\r\n```\r\n----\r\n\r\nI went a little deeper, and the main culprit seems to be in the `createMethod` function when creating dynamic method `batchUpdate`:\r\n```\r\nMethod 'batchUpdate, approx. __doc__ size: 2886834                                                                                                                                             \r\n\u003cclass 'function'>                                                                                                                                                            \r\nFilename: /home/fsumsal/venv/googleapiclient/lib64/python3.6/site-packages/googleapiclient/discovery.py                                                                       \r\n                                                                                                                                                                              \r\nLine #    Mem usage    Increment   Line Contents                                                                                                                              \r\n================================================                                                                                                                              \r\n  1064     48.7 MiB     48.7 MiB     @profile                                                                                                                                 \r\n  1065                               def _add_basic_methods(self, resourceDesc, rootDesc, schema):                                                                            \r\n  1066                                 # If this is the root Resource, add a new_batch_http_request() method.                                                                 \r\n  1067     48.7 MiB      0.0 MiB       if resourceDesc == rootDesc:                                                                                                           \r\n...                          \r\n  1086                                                                                                                                                                        \r\n  1087                                 # Add basic methods to Resource                                                                                                        \r\n  1088     48.7 MiB      0.0 MiB       if 'methods' in resourceDesc:                                                                                                          \r\n  1089     66.8 MiB      0.0 MiB         for methodName, methodDesc in six.iteritems(resourceDesc['methods']):                                                                \r\n  1090     56.0 MiB      0.0 MiB           fixedMethodName, method = createMethod(                                                                                            \r\n  1091     66.8 MiB     18.1 MiB               methodName, methodDesc, rootDesc, schema)                                                                                      \r\n  1092     66.8 MiB      0.0 MiB           print(type(method))                                                                                                                \r\n  1093     66.8 MiB      0.0 MiB           self._set_dynamic_attr(fixedMethodName,             \r\n  1094     66.8 MiB      0.0 MiB                                  method.__get__(self, self.__class__))                                                                                        \r\n  1095                                     # Add in _media methods. The functionality of the attached method will                                                                              \r\n  1096                                     # change when it sees that the method name ends in _media.                                                                                          \r\n  1097     66.8 MiB      0.0 MiB           if methodDesc.get('supportsMediaDownload', False):  \r\n  1098                                       fixedMethodName, method = createMethod(           \r\n  1099                                           methodName + '_media', methodDesc, rootDesc, schema)                                                                                          \r\n  1100                                       self._set_dynamic_attr(fixedMethodName,           \r\n  1101                                                              method.__get__(self, self.__class__))\r\n```\r\n\r\n(This method has a *huge* docstring.)\r\n\r\nNevertheless, there is probably a reference loop somewhere, as the `gc.collect()` call manages to collect all those unreachable objects.","author":{"url":"https://github.com/mrc0mmand","@type":"Person","name":"mrc0mmand"},"datePublished":"2018-06-29T12:50:39Z","url":"https://github.com/googleapis/google-api-python-client/issues/535"}

react-profiling0
react-import-mapreact,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322
route-pattern/_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format)
route-controllervoltron_issues_fragments
route-actionissue_layout
fetch-noncev2:b4aeabd0-ec8f-4877-82eb-72959202bcb5
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-idBBE2:30C16C:4FFA34:6BC991:6B00A76F
html-safe-noncebb644e19b2babd1967dcbf96473ee606229fe7c4df0a7c796be9ee50e2008aef
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJCQkUyOjMwQzE2Qzo0RkZBMzQ6NkJDOTkxOjZCMDBBNzZGIiwidmlzaXRvcl9pZCI6Ijc3OTUwMzQ1NDkzMDEzMjM2MzEiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmacd8e59b67820e1ca52be54622b59f4256946b7156cc72834892dcff9c3a8a6851
hovercard-subject-tagissue:336986812
github-keyboard-shortcutsrepository,issues,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///voltron/issues_fragments/issue_layout
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/googleapis/google-api-python-client/535/issue_layout
twitter:imagehttps://opengraph.githubassets.com/d51999fa234d6497a87887a98d79a4c237d58f29ecc466b87a3e037afdf5b6fb/googleapis/google-api-python-client/issues/535
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/d51999fa234d6497a87887a98d79a4c237d58f29ecc466b87a3e037afdf5b6fb/googleapis/google-api-python-client/issues/535
og:image:altThere seems to be a memory leak when using the google-api-client with GSheets. Environment: $ python --version Python 3.6.4 $ pip show google-api-python-client Name: google-api-python-client Versio...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernamemrc0mmand
hostnamegithub.com
expected-hostnamegithub.com
None455b493e3402a3a3a06beac5d20bb7db3da060808b220aa48d6a7eca7c59863a
turbo-cache-controlno-preview
go-importgithub.com/googleapis/google-api-python-client git https://github.com/googleapis/google-api-python-client.git
octolytics-dimension-user_id16785467
octolytics-dimension-user_logingoogleapis
octolytics-dimension-repository_id15749269
octolytics-dimension-repository_nwogoogleapis/google-api-python-client
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id15749269
octolytics-dimension-repository_network_root_nwogoogleapis/google-api-python-client
turbo-body-classeslogged-out env-production page-responsive
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release2f575159976167242d488c0b062eb355c4e198b7
ui-targetfull
theme-color#1e2327
color-schemelight dark
react-app-nameissues

Links:

Skip to contenthttps://github.com/googleapis/google-api-python-client/issues/535#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fgoogleapis%2Fgoogle-api-python-client%2Fissues%2F535
GitHubRepository hosting, code review, and collaborationhttps://github.com/platform
CopilotAI coding agent for tasks, projects, and automated workhttps://github.com/features/copilot
ActionsCI/CD and automationhttps://github.com/features/actions
Code QualityQuality analysis, fixes, and enforcementhttps://github.com/features/code-quality
CodespacesCloud development environmentshttps://github.com/features/codespaces
Code SecurityVulnerability detection and remediationhttps://github.com/security/advanced-security/code-security
Secret ProtectionSecret scanning and leak preventionhttps://github.com/security/advanced-security/secret-protection
All Featureshttps://github.com/features
Documentationhttps://docs.github.com/en
Traininghttps://learn.github.com/skills
Certificationshttps://learn.github.com/credentials
Build with Copilothttps://github.com/features/ai
Customize Copilothttps://docs.github.com/en/copilot/how-tos/copilot-on-github/customize-copilot/customize-copilot-overview
Integrationshttps://github.com/marketplace
Trending reposhttps://github.com/trending
GitHub Sponsorshttps://github.com/open-source/sponsors
Developer articleshttps://github.com/resources/articles
ChangelogYour source for the latest features, improvements, and fixes across GitHub products, all in one place.https://github.blog/changelog/
Enterpriseshttps://github.com/enterprise
Teamhttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
See all industrieshttps://github.com/solutions/industry
Why GitHubhttps://github.com/why-github
Customer Storieshttps://github.com/customer-stories
Business insightshttps://github.com/solutions/executive-insights
Trust Centerhttps://github.com/trust-center
GitHub Advanced SecurityEnterprise-grade code securityhttps://github.com/security/advanced-security
Copilot for businessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/enterprise/premium-support
Documentationhttps://docs.github.com/en
Resource centerhttps://github.com/resources
Bloghttps://github.blog/
Events & webinarshttps://github.com/resources/events
Community Forumhttps://github.com/orgs/community/discussions
Customer Storieshttps://github.com/customer-stories
Integrationshttps://github.com/marketplace
Customer supporthttps://help.github.com/
Traininghttps://learn.github.com/skills
GitHub Statushttps://www.githubstatus.com/
Abouthttps://github.com/about
Partnershttps://github.com/partners
Changeloghttps://github.blog/changelog/
GitHub UniverseThe event for developers, by developers — talks, workshops, and what’s next for GitHub.https://githubuniverse.com/
Pricinghttps://github.com/pricing
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fgoogleapis%2Fgoogle-api-python-client%2Fissues%2F535
Sign uphttps://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fvoltron%2Fissues_fragments%2Fissue_layout&source=header-repo&source_repo=googleapis%2Fgoogle-api-python-client
Reloadhttps://github.com/googleapis/google-api-python-client/issues/535
Reloadhttps://github.com/googleapis/google-api-python-client/issues/535
Reloadhttps://github.com/googleapis/google-api-python-client/issues/535
googleapishttps://github.com/googleapis
google-api-python-clienthttps://github.com/googleapis/google-api-python-client
Codehttps://github.com/googleapis/google-api-python-client
Issues18 (18)https://github.com/googleapis/google-api-python-client/issues
Pull requests39 (39)https://github.com/googleapis/google-api-python-client/pulls
Discussionshttps://github.com/googleapis/google-api-python-client/discussions
Actionshttps://github.com/googleapis/google-api-python-client/actions
Projectshttps://github.com/googleapis/google-api-python-client/projects
Security and qualityhttps://github.com/googleapis/google-api-python-client/security
Insightshttps://github.com/googleapis/google-api-python-client/insights
https://github.com/googleapis/google-api-python-client
New issuehttps://github.com/login?return_to=https://github.com/googleapis/google-api-python-client/issues/535
New issuehttps://github.com/login?return_to=https://github.com/googleapis/google-api-python-client/issues/535
Possible memory leak when using Google Sheets APIhttps://github.com/googleapis/google-api-python-client/issues/535#top
https://github.com/mcdonc
api: sheetsIssues related to the Sheets API API.https://github.com/googleapis/google-api-python-client/issues?q=state%3Aopen%20label%3A%22api%3A%20sheets%22
status: blockedResolving the issue is dependent on other work.https://github.com/googleapis/google-api-python-client/issues?q=state%3Aopen%20label%3A%22status%3A%20blocked%22
type: feature request‘Nice-to-have’ improvement, new feature or different behavior or design.https://github.com/googleapis/google-api-python-client/issues?q=state%3Aopen%20label%3A%22type%3A%20feature%20request%22
https://github.com/mrc0mmand
mrc0mmandhttps://github.com/mrc0mmand
on Jun 29, 2018https://github.com/googleapis/google-api-python-client/issues/535#issue-336986812
herehttps://gist.github.com/mrc0mmand/dd306a69e4732a5c1e186d2ce50913fb
Nexthttps://github.com/googleapis/google-api-python-client/issues/535?timeline_page=1
mcdonchttps://github.com/mcdonc
on Jun 29, 2018https://github.com/googleapis/google-api-python-client/issues/535#event-1708680254
mcdonchttps://github.com/mcdonc
priority: p2+https://github.com/googleapis/google-api-python-client/issues?q=state%3Aopen%20label%3A%22priority%3A%20p2%2B%22
on Jun 29, 2018https://github.com/googleapis/google-api-python-client/issues/535#event-1708680578
https://github.com/mcdonc
mcdonchttps://github.com/mcdonc
on Jun 29, 2018https://github.com/googleapis/google-api-python-client/issues/535#issuecomment-401386702
mcdonchttps://github.com/mcdonc
status: investigatingThe issue is under investigation, which is determined to be non-trivial.https://github.com/googleapis/google-api-python-client/issues?q=state%3Aopen%20label%3A%22status%3A%20investigating%22
on Jun 29, 2018https://github.com/googleapis/google-api-python-client/issues/535#event-1708904866
https://github.com/mcdonc
mcdonchttps://github.com/mcdonc
on Jul 10, 2018https://github.com/googleapis/google-api-python-client/issues/535#issuecomment-403859190
mcdonchttps://github.com/mcdonc
on Jul 10, 2018https://github.com/googleapis/google-api-python-client/issues/535#event-1725959249
heavyhanded fix for googleapis#535, which identifies a memory leak wh…https://github.com/mcdonc/google-api-python-client/commit/136b83f80ca36a8088de20a877e7c751079b626d
googleapis#535https://github.com/googleapis/google-api-python-client/issues/535
136b83fhttps://github.com/mcdonc/google-api-python-client/commit/136b83f80ca36a8088de20a877e7c751079b626d
https://github.com/mcdonc
mcdonchttps://github.com/mcdonc
on Jul 12, 2018https://github.com/googleapis/google-api-python-client/issues/535#issuecomment-404598197
https://user-images.githubusercontent.com/125174/42650919-c93c0f86-85db-11e8-9943-a207875a382e.png
https://github.com/google/google-api-python-client/blob/master/googleapiclient/discovery.py#L1088https://github.com/google/google-api-python-client/blob/master/googleapiclient/discovery.py#L1088
https://github.com/mcdonc
mcdonchttps://github.com/mcdonc
on Jul 14, 2018https://github.com/googleapis/google-api-python-client/issues/535#issuecomment-404994715
https://github.com/mcdonc/google-api-python-client/tree/fix-createmethod-memleak-535https://github.com/mcdonc/google-api-python-client/tree/fix-createmethod-memleak-535
#1https://github.com/googleapis/google-api-python-client/pull/1
#2https://github.com/googleapis/google-api-python-client/pull/2
https://github.com/mcdonc/google-api-python-client/tree/fix-createmethod-memleak-535https://github.com/mcdonc/google-api-python-client/tree/fix-createmethod-memleak-535
https://docs.python.org/3/library/pickle.html#pickle.Unpicklerhttps://docs.python.org/3/library/pickle.html#pickle.Unpickler
https://github.com/mrc0mmand
mrc0mmandhttps://github.com/mrc0mmand
on Jul 14, 2018https://github.com/googleapis/google-api-python-client/issues/535#issuecomment-405017487
https://github.com/mcdonc
mcdonchttps://github.com/mcdonc
on Jul 14, 2018https://github.com/googleapis/google-api-python-client/issues/535#issuecomment-405022391
@mrc0mmandhttps://github.com/mrc0mmand
mcdonchttps://github.com/mcdonc
status: acknowledgedhttps://github.com/googleapis/google-api-python-client/issues?q=state%3Aopen%20label%3A%22status%3A%20acknowledged%22
status: investigatingThe issue is under investigation, which is determined to be non-trivial.https://github.com/googleapis/google-api-python-client/issues?q=state%3Aopen%20label%3A%22status%3A%20investigating%22
on Jul 14, 2018https://github.com/googleapis/google-api-python-client/issues/535#event-1733871865
https://github.com/mcdonc
mcdonchttps://github.com/mcdonc
on Jul 14, 2018https://github.com/googleapis/google-api-python-client/issues/535#issuecomment-405024023
@theacodeshttps://github.com/theacodes
#535 (comment)https://github.com/googleapis/google-api-python-client/issues/535#issuecomment-404994715
JustinBeckwithhttps://github.com/JustinBeckwith
priority: p2Moderately-important priority. Fix may not be included in next release.https://github.com/googleapis/google-api-python-client/issues?q=state%3Aopen%20label%3A%22priority%3A%20p2%22
priority: p2+https://github.com/googleapis/google-api-python-client/issues?q=state%3Aopen%20label%3A%22priority%3A%20p2%2B%22
on Jul 16, 2018https://github.com/googleapis/google-api-python-client/issues/535#event-1735618061
https://github.com/hx2A
hx2Ahttps://github.com/hx2A
on Aug 9, 2020https://github.com/googleapis/google-api-python-client/issues/535#issuecomment-671056871
@AmosDinhhttps://github.com/AmosDinh
https://github.com/AmosDinh
AmosDinhhttps://github.com/AmosDinh
on Aug 9, 2020https://github.com/googleapis/google-api-python-client/issues/535#issuecomment-671058396
@hx2Ahttps://github.com/hx2A
https://github.com/hx2A
hx2Ahttps://github.com/hx2A
on Aug 9, 2020https://github.com/googleapis/google-api-python-client/issues/535#issuecomment-671059115
@AmosDinhhttps://github.com/AmosDinh
https://github.com/AmosDinh
AmosDinhhttps://github.com/AmosDinh
on Aug 9, 2020https://github.com/googleapis/google-api-python-client/issues/535#issuecomment-671060120
@hx2Ahttps://github.com/hx2A
https://github.com/AmosDinh
AmosDinhhttps://github.com/AmosDinh
on Aug 9, 2020https://github.com/googleapis/google-api-python-client/issues/535#issuecomment-671086867
https://github.com/hx2A
hx2Ahttps://github.com/hx2A
on Aug 18, 2020https://github.com/googleapis/google-api-python-client/issues/535#issuecomment-675529220
@AmosDinhhttps://github.com/AmosDinh
https://github.com/AmosDinh
AmosDinhhttps://github.com/AmosDinh
on Aug 18, 2020https://github.com/googleapis/google-api-python-client/issues/535#issuecomment-675597686
https://drive.google.comhttps://drive.google.com
https://github.com/hx2A
hx2Ahttps://github.com/hx2A
on Aug 18, 2020https://github.com/googleapis/google-api-python-client/issues/535#issuecomment-675613979
https://github.com/marvic2409
marvic2409https://github.com/marvic2409
on Oct 20, 2020https://github.com/googleapis/google-api-python-client/issues/535#issuecomment-713154437
https://github.com/hx2A
hx2Ahttps://github.com/hx2A
on Oct 21, 2020https://github.com/googleapis/google-api-python-client/issues/535#issuecomment-713249187
@marvic2409https://github.com/marvic2409
https://github.com/busunkim96
busunkim96https://github.com/busunkim96
on Nov 5, 2020https://github.com/googleapis/google-api-python-client/issues/535#issuecomment-722476579
#535 (comment)https://github.com/googleapis/google-api-python-client/issues/535#issuecomment-404994715
busunkim96https://github.com/busunkim96
completedhttps://github.com/googleapis/google-api-python-client/issues?q=is%3Aissue%20state%3Aclosed%20archived%3Afalse%20reason%3Acompleted
on Nov 5, 2020https://github.com/googleapis/google-api-python-client/issues/535#event-3963200098
fan0916https://github.com/fan0916
on Oct 16, 2025https://github.com/googleapis/google-api-python-client/issues/535#event-20317182707
[TSK-14668] manually call gc, reference: googleapis/google-api-python…https://github.com/peakflo/pfMCP/commit/d2e4d68a8387532071715440720a08278e9f81f0
googleapis/google-api-python…https://github.com/googleapis/google-api-python-client/issues/535
d2e4d68https://github.com/peakflo/pfMCP/commit/d2e4d68a8387532071715440720a08278e9f81f0
dimavedenyapinhttps://github.com/dimavedenyapin
on Oct 21, 2025https://github.com/googleapis/google-api-python-client/issues/535#event-20393940409
[TSK-14668] manually call gc, reference: googleapis/google-api-python…https://github.com/peakflo/pfMCP/commit/1835a4335047347a2dddf20ecf84e99ede577bb7
googleapis/google-api-python…https://github.com/googleapis/google-api-python-client/issues/535
1835a43https://github.com/peakflo/pfMCP/commit/1835a4335047347a2dddf20ecf84e99ede577bb7
lipkenthttps://github.com/lipkent
on Sep 7, 2026https://github.com/googleapis/google-api-python-client/issues/535#event-30672965413
Cache sheets.spreadsheets() nested resource to fix ~170MB/push leakhttps://github.com/lipkent/RTO-Tracker/commit/248e8d2c22da34c0a4611a2b03c70cc80cb15d30
248e8d2https://github.com/lipkent/RTO-Tracker/commit/248e8d2c22da34c0a4611a2b03c70cc80cb15d30
Sign up for freehttps://github.com/signup?return_to=https://github.com/googleapis/google-api-python-client/issues/535
Sign in to commenthttps://github.com/login?return_to=https://github.com/googleapis/google-api-python-client/issues/535
mcdonchttps://github.com/mcdonc
api: sheetsIssues related to the Sheets API API.https://github.com/googleapis/google-api-python-client/issues?q=state%3Aopen%20label%3A%22api%3A%20sheets%22
status: blockedResolving the issue is dependent on other work.https://github.com/googleapis/google-api-python-client/issues?q=state%3Aopen%20label%3A%22status%3A%20blocked%22
type: feature request‘Nice-to-have’ improvement, new feature or different behavior or design.https://github.com/googleapis/google-api-python-client/issues?q=state%3Aopen%20label%3A%22type%3A%20feature%20request%22
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width


URLs of crawlers that visited me.