https://community.esri.com/t5/arcgis-api-for-python-questions/error-504-when-query-30000-records-for-feature/m-p/1669307#M11796 <P>Hi,<BR /><BR />Our client code already run for 6 months and suddenly we got hit with 504 Gateway Timeout.</P><P><STRONG><SPAN>svc = gis.content.get(svcid)</SPAN></STRONG></P><P><STRONG><SPAN>layerA = svc.layers[layerA_id]</SPAN></STRONG></P><P><STRONG><SPAN>layerB = svc.tables[layerB_id]</SPAN></STRONG></P><DIV><DIV><STRONG>&nbsp;&nbsp;</STRONG></DIV><DIV><STRONG>recordA = layerA.query(where=query, as_df=True)</STRONG></DIV><DIV><SPAN><STRONG>recordB = layerB.query(as_df=True)</STRONG><BR /><BR />recordA line works but recordB doesn't work.<BR /><BR />Based on the code recordB will query everything which is up to 30k of records. We do have services timeout until 5 minutes.<BR /><BR />It seems to be working for past 6 months but only today it doesn't work. I did try to query only for 10 records, but it hits the timeout issue.<BR /><BR />The only workaround I have for now is to call layer thru the REST call.<BR /><BR />Is it potentially python API issues or environment issues? I'm afraid it might eventually come to recordA once recordA data grow and need to apply the same workaround<BR /><BR /><BR /><BR /><BR /></SPAN></DIV></DIV> Mon, 01 Dec 2025 10:01:34 GMT Muhammad_AzhaziqBin_Mohd_Azlan 2025-12-01T10:01:34Z https://community.esri.com/t5/arcgis-api-for-python-questions/error-504-when-query-30000-records-for-feature/m-p/1669307#M11796 <P>Hi,<BR /><BR />Our client code already run for 6 months and suddenly we got hit with 504 Gateway Timeout.</P><P><STRONG><SPAN>svc = gis.content.get(svcid)</SPAN></STRONG></P><P><STRONG><SPAN>layerA = svc.layers[layerA_id]</SPAN></STRONG></P><P><STRONG><SPAN>layerB = svc.tables[layerB_id]</SPAN></STRONG></P><DIV><DIV><STRONG>&nbsp;&nbsp;</STRONG></DIV><DIV><STRONG>recordA = layerA.query(where=query, as_df=True)</STRONG></DIV><DIV><SPAN><STRONG>recordB = layerB.query(as_df=True)</STRONG><BR /><BR />recordA line works but recordB doesn't work.<BR /><BR />Based on the code recordB will query everything which is up to 30k of records. We do have services timeout until 5 minutes.<BR /><BR />It seems to be working for past 6 months but only today it doesn't work. I did try to query only for 10 records, but it hits the timeout issue.<BR /><BR />The only workaround I have for now is to call layer thru the REST call.<BR /><BR />Is it potentially python API issues or environment issues? I'm afraid it might eventually come to recordA once recordA data grow and need to apply the same workaround<BR /><BR /><BR /><BR /><BR /></SPAN></DIV></DIV> Mon, 01 Dec 2025 10:01:34 GMT https://community.esri.com/t5/arcgis-api-for-python-questions/error-504-when-query-30000-records-for-feature/m-p/1669307#M11796 Muhammad_AzhaziqBin_Mohd_Azlan 2025-12-01T10:01:34Z https://community.esri.com/t5/arcgis-api-for-python-questions/error-504-when-query-30000-records-for-feature/m-p/1669316#M11797 <P>Hi&nbsp;<a href="https://community.esri.com/t5/user/viewprofilepage/user-id/89517">@Muhammad_AzhaziqBin_Mohd_Azlan</a>,</P><P>This sounds like it could be a service issue.&nbsp; If you publish the same data as a new service, are you able to reproduce the issue?</P><P>What type of service are you querying?&nbsp; For example, is it a 11.5 referenced ArcGIS Server service?</P><P>What version of the API are you using?</P> Mon, 01 Dec 2025 12:13:20 GMT https://community.esri.com/t5/arcgis-api-for-python-questions/error-504-when-query-30000-records-for-feature/m-p/1669316#M11797 JakeSkinner 2025-12-01T12:13:20Z