Error on query large lists with calmquery

[nchasomeri]

I'm trying to update a SharePoint list on our site by using calm_query for finding the rows to update but I am getting the error "office365.runtime.client_request_exception.ClientRequestException: ('-2147467259, Microsoft.SharePoint.SPException', 'Cannot complete this action.\n\nPlease try again.', "500 Server Error: Internal Server Error for url: https://<myTenant>/sites/ipm/_api/Web/lists/GetByTitle(listname)/GetItems") "

My code is similar with this example https://github.com/vgrem/Office365-REST-Python-Client/blob/master/examples/sharepoint/lists_and_items/read_list_via_query.py

and the error raised on items = target_list.get_items(list_qry).execute_query()

My list on SharePoint is large enough (~ 56000 rows) and in query i use the rowlimit option.

Can someone help me with this? Thank you