Appwrite Python SDK Keeps returning the same rows, why?

So I have a couple services, one is a scheduling engine responsible for fetching data from a database and launching a containerized micro service to process that data, the other is the containerized microservice that takes that data, fetches new data, and then organizes into AppWrites Database. When it is done, updates it's parent status to 2 which should stop it from being repulled again. However it appears app write is just sending me the same 25 rows again and again even though they are marked as complete in the DB. I've verified my worker services is appropriately changing job states in the DB so this shouldn't be happening.

For what it's worth, this appears to have happened in the middle of the night. my database was populating fine, then at about 408k rows progress stopped and it just started doing the same things over and over again so I'm at 1.5M requests on 435K rows 💀

Can anyone help me understand what's going on? I'm using the Python SDK.

The Behavior seems to be that I have to pull larger and larger pages of rows to get rows with fresh data. this has to be some kind of caching, right?