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 [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
-~----------~----~----~----~------~----~------~--~---

Reply via email to