I'm trying to delete all the entities of a specific type (150k+). My app engine is in Java. This is a 5 minute task on any other database/ platform. I am unable to find a working, custom or OTB, solution!
Steps I have taken 1. Tried to follow the documented way to delete entities. http://code.google.com/appengine/docs/java/datastore/queriesandindexes.html#Delete_By_Query -This times out (App engine has a 30 second request limit) and deletes nothing 2. Used this java class to delete records via a custom task (50 requests put in queue at a time) http://stackoverflow.com/questions/108822/delete-all-data-for-a-kind-in-google-app-engine#answer-1882697 -dss.delete(keys) says I've deleted 128 to 256 entities each request -I hit my CPU quota in ~4 hours. I've tried this for days with no end in sight 3. Tried to manually delete the records via the "Datastore Viewer" on the app engine website -Datastore Viewer returns "Error: Server Error. The server encountered an error and could not complete your request. If the problem persists, please report your problem and mention this error message and the query that caused it." (for days) -Datastore Statistics returns the same error (for days) 4. Tried to learn/use the Python remote_api to delete my entities. -After configuring the remote_api, installing the mac GoogleAppEngineLauncher, and trying to follow a bunch of tutorials (http://code.google.com/appengine/articles/remote_api.html). Still working on this route, but this cannot be a real solution, right? Requires custom code, working knowledge of Python, and manual iterative execution- if it even works for Java entities. 5. Tried to search the forums Datastore Viewer returns 500 error -open since May 23, 2008 http://code.google.com/p/googleappengine/issues/detail?id=384. Cites null properties in entities as the cause. Solution (might be) to update or delete the entities....! -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.
