Hi Kenneth, Occasional datastore timeouts are expected regardless of your usage patterns. Under normal operation, they will occur very rarely, but they will occur. You need to modify your code to handle this eventuality.
-Nick Johnson On Thu, May 14, 2009 at 11:03 AM, Kenneth <goo...@kmacleod.ie> wrote: > > Our application was running with 1 user this morning and received a > datastore timeout. > > The code has no loops in it, it gets 1 row each from 4 entities, 2 of > them by key using get_or_insert and 2 of them using a reference > property. They are all root entities and there is no contention as > you can see from the log below. The tables all have <1000 rows in > them. The timeout happened on the first datastore call using > get_or_insert. Even if I retried this call it is bananas waiting 3 > seconds for a single row to come back. > > Am I better off doing a get and if that fails then trying the > get_or_insert? > > It looks like other applications running on the server are affecting > my application. If I was being billed I believe this would cost me > money. > > Here's the log, no transactions have been removed, the two > transactions at 2:11AM failed with a huge cpu spike. > > 05-14 02:24AM 55.926 /api/ 200 1040ms 1116cpu_ms 218api_cpu_ms > 0kb > 05-14 02:22AM 08.620 /api/ 200 198ms 237cpu_ms 160api_cpu_ms > 0kb > 05-14 02:22AM 07.806 /api/ 200 258ms 279cpu_ms 218api_cpu_ms > 0kb > 05-14 02:22AM 05.176 /api/ 200 205ms 218cpu_ms 160api_cpu_ms > 0kb > 05-14 02:22AM 00.864 /api/ 200 774ms 979cpu_ms 160api_cpu_ms > 0kb > > 05-14 02:11AM 22.391 /client/ 500 3189ms 6357cpu_ms > 6093api_cpu_ms 10kb > 05-14 02:11AM 18.195 /api/ 500 3444ms 6450cpu_ms 6212api_cpu_ms > 8kb > > 05-14 02:10AM 37.957 /api/ 200 175ms 223cpu_ms 160api_cpu_ms > 0kb > 05-14 02:10AM 27.585 /api/ 200 906ms 1005cpu_ms 160api_cpu_ms > 0kb > > Thank you very much for any assistance. > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to google-appengine@googlegroups.com To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en -~----------~----~----~----~------~----~------~--~---
