René's URL Explorer Experiment


Title: query result pagination caught in infinite loop · Issue #1950 · googleapis/python-bigquery · GitHub

Open Graph Title: query result pagination caught in infinite loop · Issue #1950 · googleapis/python-bigquery

X Title: query result pagination caught in infinite loop · Issue #1950 · googleapis/python-bigquery

Description: Thanks for stopping by to let us know something could be better! PLEASE READ: If you have a support contract with Google, please create an issue in the support console instead of filing on GitHub. This will ensure a timely response. Plea...

Open Graph Description: Thanks for stopping by to let us know something could be better! PLEASE READ: If you have a support contract with Google, please create an issue in the support console instead of filing on GitHub. ...

X Description: Thanks for stopping by to let us know something could be better! PLEASE READ: If you have a support contract with Google, please create an issue in the support console instead of filing on GitHub. ...

Opengraph URL: https://github.com/googleapis/python-bigquery/issues/1950

X: @github

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"query result pagination caught in infinite loop","articleBody":"Thanks for stopping by to let us know something could be better!\r\n\r\n**PLEASE READ**: If you have a support contract with Google, please create an issue in the [support console](https://cloud.google.com/support/) instead of filing on GitHub. This will ensure a timely response.\r\n\r\nPlease run down the following list and make sure you've tried the usual \"quick fixes\":\r\n\r\n  - Search the issues already opened: https://github.com/googleapis/python-bigquery/issues\r\n  - Search StackOverflow: https://stackoverflow.com/questions/tagged/google-cloud-platform+python\r\n\r\nIf you are still having issues, please be sure to include as much information as possible:\r\n\r\n#### Environment details\r\n\r\n  - OS type and version:\r\n\t  - MacOS, 14.1\r\n  - Python version: `python --version`\r\n\t  - `3.11.6`\r\n  - pip version: `pip --version`\r\n\t  - `23.3.1`\r\n  - `google-cloud-bigquery` version: `pip show google-cloud-bigquery`\r\n\t  - `3.24.0`\r\n\r\n#### Steps to reproduce\r\n\r\n  1. run query\r\n  2. `query.result(...)` called with `page_size` and `start_index` loops infinitely\r\n\r\ni think `3.24.0` introduced this, as when we pinned `google-cloud-bigquery` to `3.23.1`, the issue abated. \r\n\r\nfor what it's worth, with `3.24.0` each call to `query_job.result` returns _much_ faster than in `3.23.1` -- not sure if that's perf related or because it's not actually making the network call\r\n\r\n#### Code example\r\n\r\n```python\r\nfrom typing import List\r\nimport logging\r\n\r\nfrom google.cloud import bigquery\r\n\r\nif __name__ == \"__main__\":\r\n    logging.getLogger().setLevel(logging.INFO)\r\n    client = bigquery.Client()\r\n\r\n    result_size = 100\r\n    page_size = 10\r\n\r\n    query_str = (f\"SELECT * FROM `project-id.dataset-id.table-id` LIMIT {result_size}\",)\r\n\r\n    job_config = bigquery.QueryJobConfig(use_query_cache=True)\r\n    job_config.query_parameters = []\r\n\r\n    query_job = client.query(\r\n        query=query_str,\r\n        location=\"US\",\r\n        job_config=job_config,\r\n    )\r\n\r\n    start_index = 0\r\n\r\n    while True:\r\n        page_rows: bigquery.table.RowIterator = query_job.result(\r\n            max_results=page_size, start_index=start_index\r\n        )\r\n        logging.info(\r\n            \"Retrieved result set from query page of size [%d] starting at index [%d]\",\r\n            page_size,\r\n            start_index,\r\n        )\r\n\r\n        num_rows_read = 0\r\n        processed_rows: List[bigquery.table.Row] = []\r\n        for row in page_rows:\r\n            num_rows_read += 1\r\n            processed_rows.append(row)\r\n\r\n        logging.info(\r\n            \"Processed [%d] rows from query page starting at index [%d]\",\r\n            num_rows_read,\r\n            start_index,\r\n        )\r\n        if num_rows_read == 0:\r\n            break\r\n\r\n        if start_index >= 1000:\r\n            break\r\n\r\n        start_index += num_rows_read\r\n        logging.info(\"Processed [%d] rows...\", start_index)\r\n\r\n```\r\n\r\n#### Logs\r\n```\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [0]\r\nINFO:root:Processed [10] rows from query page starting at index [0]\r\nINFO:root:Processed [10] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [10]\r\nINFO:root:Processed [10] rows from query page starting at index [10]\r\nINFO:root:Processed [20] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [20]\r\nINFO:root:Processed [10] rows from query page starting at index [20]\r\nINFO:root:Processed [30] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [30]\r\nINFO:root:Processed [10] rows from query page starting at index [30]\r\nINFO:root:Processed [40] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [40]\r\nINFO:root:Processed [10] rows from query page starting at index [40]\r\nINFO:root:Processed [50] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [50]\r\nINFO:root:Processed [10] rows from query page starting at index [50]\r\nINFO:root:Processed [60] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [60]\r\nINFO:root:Processed [10] rows from query page starting at index [60]\r\nINFO:root:Processed [70] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [70]\r\nINFO:root:Processed [10] rows from query page starting at index [70]\r\nINFO:root:Processed [80] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [80]\r\nINFO:root:Processed [10] rows from query page starting at index [80]\r\nINFO:root:Processed [90] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [90]\r\nINFO:root:Processed [10] rows from query page starting at index [90]\r\nINFO:root:Processed [100] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [100]\r\nINFO:root:Processed [10] rows from query page starting at index [100]\r\nINFO:root:Processed [110] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [110]\r\nINFO:root:Processed [10] rows from query page starting at index [110]\r\nINFO:root:Processed [120] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [120]\r\nINFO:root:Processed [10] rows from query page starting at index [120]\r\nINFO:root:Processed [130] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [130]\r\nINFO:root:Processed [10] rows from query page starting at index [130]\r\nINFO:root:Processed [140] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [140]\r\nINFO:root:Processed [10] rows from query page starting at index [140]\r\nINFO:root:Processed [150] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [150]\r\nINFO:root:Processed [10] rows from query page starting at index [150]\r\nINFO:root:Processed [160] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [160]\r\nINFO:root:Processed [10] rows from query page starting at index [160]\r\nINFO:root:Processed [170] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [170]\r\nINFO:root:Processed [10] rows from query page starting at index [170]\r\nINFO:root:Processed [180] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [180]\r\nINFO:root:Processed [10] rows from query page starting at index [180]\r\nINFO:root:Processed [190] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [190]\r\nINFO:root:Processed [10] rows from query page starting at index [190]\r\nINFO:root:Processed [200] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [200]\r\nINFO:root:Processed [10] rows from query page starting at index [200]\r\nINFO:root:Processed [210] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [210]\r\nINFO:root:Processed [10] rows from query page starting at index [210]\r\nINFO:root:Processed [220] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [220]\r\nINFO:root:Processed [10] rows from query page starting at index [220]\r\nINFO:root:Processed [230] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [230]\r\nINFO:root:Processed [10] rows from query page starting at index [230]\r\nINFO:root:Processed [240] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [240]\r\nINFO:root:Processed [10] rows from query page starting at index [240]\r\nINFO:root:Processed [250] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [250]\r\nINFO:root:Processed [10] rows from query page starting at index [250]\r\nINFO:root:Processed [260] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [260]\r\nINFO:root:Processed [10] rows from query page starting at index [260]\r\nINFO:root:Processed [270] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [270]\r\nINFO:root:Processed [10] rows from query page starting at index [270]\r\nINFO:root:Processed [280] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [280]\r\nINFO:root:Processed [10] rows from query page starting at index [280]\r\nINFO:root:Processed [290] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [290]\r\nINFO:root:Processed [10] rows from query page starting at index [290]\r\nINFO:root:Processed [300] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [300]\r\nINFO:root:Processed [10] rows from query page starting at index [300]\r\nINFO:root:Processed [310] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [310]\r\nINFO:root:Processed [10] rows from query page starting at index [310]\r\nINFO:root:Processed [320] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [320]\r\nINFO:root:Processed [10] rows from query page starting at index [320]\r\nINFO:root:Processed [330] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [330]\r\nINFO:root:Processed [10] rows from query page starting at index [330]\r\nINFO:root:Processed [340] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [340]\r\nINFO:root:Processed [10] rows from query page starting at index [340]\r\nINFO:root:Processed [350] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [350]\r\nINFO:root:Processed [10] rows from query page starting at index [350]\r\nINFO:root:Processed [360] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [360]\r\nINFO:root:Processed [10] rows from query page starting at index [360]\r\nINFO:root:Processed [370] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [370]\r\nINFO:root:Processed [10] rows from query page starting at index [370]\r\nINFO:root:Processed [380] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [380]\r\nINFO:root:Processed [10] rows from query page starting at index [380]\r\nINFO:root:Processed [390] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [390]\r\nINFO:root:Processed [10] rows from query page starting at index [390]\r\nINFO:root:Processed [400] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [400]\r\nINFO:root:Processed [10] rows from query page starting at index [400]\r\nINFO:root:Processed [410] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [410]\r\nINFO:root:Processed [10] rows from query page starting at index [410]\r\nINFO:root:Processed [420] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [420]\r\nINFO:root:Processed [10] rows from query page starting at index [420]\r\nINFO:root:Processed [430] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [430]\r\nINFO:root:Processed [10] rows from query page starting at index [430]\r\nINFO:root:Processed [440] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [440]\r\nINFO:root:Processed [10] rows from query page starting at index [440]\r\nINFO:root:Processed [450] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [450]\r\nINFO:root:Processed [10] rows from query page starting at index [450]\r\nINFO:root:Processed [460] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [460]\r\nINFO:root:Processed [10] rows from query page starting at index [460]\r\nINFO:root:Processed [470] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [470]\r\nINFO:root:Processed [10] rows from query page starting at index [470]\r\nINFO:root:Processed [480] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [480]\r\nINFO:root:Processed [10] rows from query page starting at index [480]\r\nINFO:root:Processed [490] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [490]\r\nINFO:root:Processed [10] rows from query page starting at index [490]\r\nINFO:root:Processed [500] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [500]\r\nINFO:root:Processed [10] rows from query page starting at index [500]\r\nINFO:root:Processed [510] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [510]\r\nINFO:root:Processed [10] rows from query page starting at index [510]\r\nINFO:root:Processed [520] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [520]\r\nINFO:root:Processed [10] rows from query page starting at index [520]\r\nINFO:root:Processed [530] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [530]\r\nINFO:root:Processed [10] rows from query page starting at index [530]\r\nINFO:root:Processed [540] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [540]\r\nINFO:root:Processed [10] rows from query page starting at index [540]\r\nINFO:root:Processed [550] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [550]\r\nINFO:root:Processed [10] rows from query page starting at index [550]\r\nINFO:root:Processed [560] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [560]\r\nINFO:root:Processed [10] rows from query page starting at index [560]\r\nINFO:root:Processed [570] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [570]\r\nINFO:root:Processed [10] rows from query page starting at index [570]\r\nINFO:root:Processed [580] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [580]\r\nINFO:root:Processed [10] rows from query page starting at index [580]\r\nINFO:root:Processed [590] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [590]\r\nINFO:root:Processed [10] rows from query page starting at index [590]\r\nINFO:root:Processed [600] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [600]\r\nINFO:root:Processed [10] rows from query page starting at index [600]\r\nINFO:root:Processed [610] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [610]\r\nINFO:root:Processed [10] rows from query page starting at index [610]\r\nINFO:root:Processed [620] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [620]\r\nINFO:root:Processed [10] rows from query page starting at index [620]\r\nINFO:root:Processed [630] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [630]\r\nINFO:root:Processed [10] rows from query page starting at index [630]\r\nINFO:root:Processed [640] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [640]\r\nINFO:root:Processed [10] rows from query page starting at index [640]\r\nINFO:root:Processed [650] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [650]\r\nINFO:root:Processed [10] rows from query page starting at index [650]\r\nINFO:root:Processed [660] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [660]\r\nINFO:root:Processed [10] rows from query page starting at index [660]\r\nINFO:root:Processed [670] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [670]\r\nINFO:root:Processed [10] rows from query page starting at index [670]\r\nINFO:root:Processed [680] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [680]\r\nINFO:root:Processed [10] rows from query page starting at index [680]\r\nINFO:root:Processed [690] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [690]\r\nINFO:root:Processed [10] rows from query page starting at index [690]\r\nINFO:root:Processed [700] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [700]\r\nINFO:root:Processed [10] rows from query page starting at index [700]\r\nINFO:root:Processed [710] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [710]\r\nINFO:root:Processed [10] rows from query page starting at index [710]\r\nINFO:root:Processed [720] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [720]\r\nINFO:root:Processed [10] rows from query page starting at index [720]\r\nINFO:root:Processed [730] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [730]\r\nINFO:root:Processed [10] rows from query page starting at index [730]\r\nINFO:root:Processed [740] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [740]\r\nINFO:root:Processed [10] rows from query page starting at index [740]\r\nINFO:root:Processed [750] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [750]\r\nINFO:root:Processed [10] rows from query page starting at index [750]\r\nINFO:root:Processed [760] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [760]\r\nINFO:root:Processed [10] rows from query page starting at index [760]\r\nINFO:root:Processed [770] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [770]\r\nINFO:root:Processed [10] rows from query page starting at index [770]\r\nINFO:root:Processed [780] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [780]\r\nINFO:root:Processed [10] rows from query page starting at index [780]\r\nINFO:root:Processed [790] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [790]\r\nINFO:root:Processed [10] rows from query page starting at index [790]\r\nINFO:root:Processed [800] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [800]\r\nINFO:root:Processed [10] rows from query page starting at index [800]\r\nINFO:root:Processed [810] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [810]\r\nINFO:root:Processed [10] rows from query page starting at index [810]\r\nINFO:root:Processed [820] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [820]\r\nINFO:root:Processed [10] rows from query page starting at index [820]\r\nINFO:root:Processed [830] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [830]\r\nINFO:root:Processed [10] rows from query page starting at index [830]\r\nINFO:root:Processed [840] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [840]\r\nINFO:root:Processed [10] rows from query page starting at index [840]\r\nINFO:root:Processed [850] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [850]\r\nINFO:root:Processed [10] rows from query page starting at index [850]\r\nINFO:root:Processed [860] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [860]\r\nINFO:root:Processed [10] rows from query page starting at index [860]\r\nINFO:root:Processed [870] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [870]\r\nINFO:root:Processed [10] rows from query page starting at index [870]\r\nINFO:root:Processed [880] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [880]\r\nINFO:root:Processed [10] rows from query page starting at index [880]\r\nINFO:root:Processed [890] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [890]\r\nINFO:root:Processed [10] rows from query page starting at index [890]\r\nINFO:root:Processed [900] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [900]\r\nINFO:root:Processed [10] rows from query page starting at index [900]\r\nINFO:root:Processed [910] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [910]\r\nINFO:root:Processed [10] rows from query page starting at index [910]\r\nINFO:root:Processed [920] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [920]\r\nINFO:root:Processed [10] rows from query page starting at index [920]\r\nINFO:root:Processed [930] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [930]\r\nINFO:root:Processed [10] rows from query page starting at index [930]\r\nINFO:root:Processed [940] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [940]\r\nINFO:root:Processed [10] rows from query page starting at index [940]\r\nINFO:root:Processed [950] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [950]\r\nINFO:root:Processed [10] rows from query page starting at index [950]\r\nINFO:root:Processed [960] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [960]\r\nINFO:root:Processed [10] rows from query page starting at index [960]\r\nINFO:root:Processed [970] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [970]\r\nINFO:root:Processed [10] rows from query page starting at index [970]\r\nINFO:root:Processed [980] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [980]\r\nINFO:root:Processed [10] rows from query page starting at index [980]\r\nINFO:root:Processed [990] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [990]\r\nINFO:root:Processed [10] rows from query page starting at index [990]\r\nINFO:root:Processed [1000] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [1000]\r\nINFO:root:Processed [10] rows from query page starting at index [1000]\r\n...\r\n\u003cmany more lines here>\r\n...\r\nINFO:root:Processed [10] rows from query page starting at index [17350]\r\nINFO:root:Processed [17360] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [17360]\r\nINFO:root:Processed [10] rows from query page starting at index [17360]\r\nINFO:root:Processed [17370] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [17370]\r\nINFO:root:Processed [10] rows from query page starting at index [17370]\r\nINFO:root:Processed [17380] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [17380]\r\nINFO:root:Processed [10] rows from query page starting at index [17380]\r\nINFO:root:Processed [17390] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [17390]\r\nINFO:root:Processed [10] rows from query page starting at index [17390]\r\nINFO:root:Processed [17400] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [17400]\r\nINFO:root:Processed [10] rows from query page starting at index [17400]\r\nINFO:root:Processed [17410] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [17410]\r\nINFO:root:Processed [10] rows from query page starting at index [17410]\r\nINFO:root:Processed [17420] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [17420]\r\nINFO:root:Processed [10] rows from query page starting at index [17420]\r\nINFO:root:Processed [17430] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [17430]\r\nINFO:root:Processed [10] rows from query page starting at index [17430]\r\nINFO:root:Processed [17440] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [17440]\r\n\u003cthis is where ctrl-c'd>\r\n```\r\n\r\nexpect output is\r\n```\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [0]\r\nINFO:root:Processed [10] rows from query page starting at index [0]\r\nINFO:root:Processed [10] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [10]\r\nINFO:root:Processed [10] rows from query page starting at index [10]\r\nINFO:root:Processed [20] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [20]\r\nINFO:root:Processed [10] rows from query page starting at index [20]\r\nINFO:root:Processed [30] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [30]\r\nINFO:root:Processed [10] rows from query page starting at index [30]\r\nINFO:root:Processed [40] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [40]\r\nINFO:root:Processed [10] rows from query page starting at index [40]\r\nINFO:root:Processed [50] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [50]\r\nINFO:root:Processed [10] rows from query page starting at index [50]\r\nINFO:root:Processed [60] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [60]\r\nINFO:root:Processed [10] rows from query page starting at index [60]\r\nINFO:root:Processed [70] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [70]\r\nINFO:root:Processed [10] rows from query page starting at index [70]\r\nINFO:root:Processed [80] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [80]\r\nINFO:root:Processed [10] rows from query page starting at index [80]\r\nINFO:root:Processed [90] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [90]\r\nINFO:root:Processed [10] rows from query page starting at index [90]\r\nINFO:root:Processed [100] rows...\r\nINFO:root:Retrieved result set from query page of size [10] starting at index [100]\r\nINFO:root:Processed [0] rows from query page starting at index [100]\r\n```","author":{"url":"https://github.com/ethan-oro","@type":"Person","name":"ethan-oro"},"datePublished":"2024-06-12T20:01:26Z","url":"https://github.com/googleapis/python-bigquery/issues/1950"}

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:497ffce4-a312-2827-16d0-dc49887e3d87
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-idBD4E:D184:F0A8B:144E8E:6AFE33DF
html-safe-noncefeaeb5adc2b65266447de8db1b0f2188182432fabcc5763785b3857f9cec1c8b
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJCRDRFOkQxODQ6RjBBOEI6MTQ0RThFOjZBRkUzM0RGIiwidmlzaXRvcl9pZCI6IjI5NzgxNzI5NzM4NjY2OTM1OTkiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmacc86da614e0fc946be7a2567efd5542467704717181aa04aac6926ec2aa5f1ddc
hovercard-subject-tagissue:2349585055
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/python-bigquery/1950/issue_layout
twitter:imagehttps://opengraph.githubassets.com/3dcede8507fbd2554573ddbc3aa924668e4a768e4c49055983a2452573032506/googleapis/python-bigquery/issues/1950
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/3dcede8507fbd2554573ddbc3aa924668e4a768e4c49055983a2452573032506/googleapis/python-bigquery/issues/1950
og:image:altThanks for stopping by to let us know something could be better! PLEASE READ: If you have a support contract with Google, please create an issue in the support console instead of filing on GitHub. ...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernameethan-oro
hostnamegithub.com
expected-hostnamegithub.com
Noned70e31220a67f6376c108d2416fa8e7df854c1065b1672ab7a88ab6dc3a809e2
turbo-cache-controlno-preview
go-importgithub.com/googleapis/python-bigquery git https://github.com/googleapis/python-bigquery.git
octolytics-dimension-user_id16785467
octolytics-dimension-user_logingoogleapis
octolytics-dimension-repository_id226992475
octolytics-dimension-repository_nwogoogleapis/python-bigquery
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id226992475
octolytics-dimension-repository_network_root_nwogoogleapis/python-bigquery
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
releaseccb88d9c92abe69245b429398c8a57ae87070c7c
ui-targetfull
theme-color#1e2327
color-schemelight dark
react-app-nameissues

Links:

Skip to contenthttps://github.com/googleapis/python-bigquery/issues/1950#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fgoogleapis%2Fpython-bigquery%2Fissues%2F1950
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%2Fpython-bigquery%2Fissues%2F1950
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%2Fpython-bigquery
Reloadhttps://github.com/googleapis/python-bigquery/issues/1950
Reloadhttps://github.com/googleapis/python-bigquery/issues/1950
Reloadhttps://github.com/googleapis/python-bigquery/issues/1950
googleapishttps://github.com/googleapis
python-bigqueryhttps://github.com/googleapis/python-bigquery
Codehttps://github.com/googleapis/python-bigquery
Issueshttps://github.com/googleapis/python-bigquery/issues
Pull requestshttps://github.com/googleapis/python-bigquery/pulls
Actionshttps://github.com/googleapis/python-bigquery/actions
Projectshttps://github.com/googleapis/python-bigquery/projects
Security and qualityhttps://github.com/googleapis/python-bigquery/security
Insightshttps://github.com/googleapis/python-bigquery/insights
https://github.com/googleapis/python-bigquery
#1956https://github.com/googleapis/python-bigquery/pull/1956
query result pagination caught in infinite loophttps://github.com/googleapis/python-bigquery/issues/1950#top
#1956https://github.com/googleapis/python-bigquery/pull/1956
https://github.com/Linchin
api: bigqueryIssues related to the googleapis/python-bigquery API.https://github.com/googleapis/python-bigquery/issues?q=state%3Aopen%20label%3A%22api%3A%20bigquery%22
priority: p2Moderately-important priority. Fix may not be included in next release.https://github.com/googleapis/python-bigquery/issues?q=state%3Aopen%20label%3A%22priority%3A%20p2%22
type: bugError or flaw in code with unintended results or allowing sub-optimal usage patterns.https://github.com/googleapis/python-bigquery/issues?q=state%3Aopen%20label%3A%22type%3A%20bug%22
https://github.com/ethan-oro
ethan-orohttps://github.com/ethan-oro
on Jun 12, 2024https://github.com/googleapis/python-bigquery/issues/1950#issue-2349585055
support consolehttps://cloud.google.com/support/
https://github.com/googleapis/python-bigquery/issueshttps://github.com/googleapis/python-bigquery/issues
https://stackoverflow.com/questions/tagged/google-cloud-platform+pythonhttps://stackoverflow.com/questions/tagged/google-cloud-platform+python
product-auto-labelhttps://github.com/apps/product-auto-label
api: bigqueryIssues related to the googleapis/python-bigquery API.https://github.com/googleapis/python-bigquery/issues?q=state%3Aopen%20label%3A%22api%3A%20bigquery%22
on Jun 12, 2024https://github.com/googleapis/python-bigquery/issues/1950#event-13136789522
blunderbuss-gcfhttps://github.com/apps/blunderbuss-gcf
obada-abhttps://github.com/obada-ab
on Jun 12, 2024https://github.com/googleapis/python-bigquery/issues/1950#event-13136790890
Linchinhttps://github.com/Linchin
obada-abhttps://github.com/obada-ab
on Jun 13, 2024https://github.com/googleapis/python-bigquery/issues/1950#event-13138980504
Linchinhttps://github.com/Linchin
type: bugError or flaw in code with unintended results or allowing sub-optimal usage patterns.https://github.com/googleapis/python-bigquery/issues?q=state%3Aopen%20label%3A%22type%3A%20bug%22
on Jun 13, 2024https://github.com/googleapis/python-bigquery/issues/1950#event-13139112644
Linchinhttps://github.com/Linchin
on Jun 13, 2024https://github.com/googleapis/python-bigquery/issues/1950#event-13139139292
Linchinhttps://github.com/Linchin
priority: p2Moderately-important priority. Fix may not be included in next release.https://github.com/googleapis/python-bigquery/issues?q=state%3Aopen%20label%3A%22priority%3A%20p2%22
on Jun 13, 2024https://github.com/googleapis/python-bigquery/issues/1950#event-13139139689
https://github.com/Linchin
Linchinhttps://github.com/Linchin
on Jun 13, 2024https://github.com/googleapis/python-bigquery/issues/1950#issuecomment-2164195553
#1942https://github.com/googleapis/python-bigquery/pull/1942
this changehttps://github.com/googleapis/python-bigquery/blob/19bef8d2f902ddafd32dfb34641729e25639fbd7/google/cloud/bigquery/job/query.py#L1536-L1537
https://github.com/ethan-oro
ethan-orohttps://github.com/ethan-oro
on Jun 13, 2024https://github.com/googleapis/python-bigquery/issues/1950#issuecomment-2165884766
https://github.com/Linchin
Linchinhttps://github.com/Linchin
on Jun 13, 2024https://github.com/googleapis/python-bigquery/issues/1950#issuecomment-2166820154
Linchinhttps://github.com/Linchin
completedhttps://github.com/googleapis/python-bigquery/issues?q=is%3Aissue%20state%3Aclosed%20archived%3Afalse%20reason%3Acompleted
#1956https://github.com/googleapis/python-bigquery/pull/1956
on Jun 17, 2024https://github.com/googleapis/python-bigquery/issues/1950#event-13188999949
Sign up for freehttps://github.com/signup?return_to=https://github.com/googleapis/python-bigquery/issues/1950
Sign in to commenthttps://github.com/login?return_to=https://github.com/googleapis/python-bigquery/issues/1950
Linchinhttps://github.com/Linchin
api: bigqueryIssues related to the googleapis/python-bigquery API.https://github.com/googleapis/python-bigquery/issues?q=state%3Aopen%20label%3A%22api%3A%20bigquery%22
priority: p2Moderately-important priority. Fix may not be included in next release.https://github.com/googleapis/python-bigquery/issues?q=state%3Aopen%20label%3A%22priority%3A%20p2%22
type: bugError or flaw in code with unintended results or allowing sub-optimal usage patterns.https://github.com/googleapis/python-bigquery/issues?q=state%3Aopen%20label%3A%22type%3A%20bug%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.