jmac11 / googlecloudsql

Automatically exported from code.google.com/p/googlecloudsql
0 stars 0 forks source link

DeadlineExceededError for query taking more than 60 sec on backend instance #71

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Set up backend instance
2. Add task using tasqueue to for executing on backend instance. Task performs 
"long" query, that takes more than 60 seconds. Connection is established using 
sqlalchemy.
3. Navigate to logs for the backend instance

What is the name of your database instance?
-

What is the expected output? What do you see instead?
- Expected to see query successfully executed
- Instead after 60 seconds tasks is aborted with:

"""
<...>
File 
"/python27_runtime/python27_lib/versions/1/google/appengine/api/apiproxy_rpc.py"
, line 133, in CheckSuccess
    raise self.exception
DeadlineExceededError: The API call rdbms.Exec() took too long to respond and 
was cancelled.
"""

Original issue reported on code.google.com by kame...@upwork.com on 14 Jun 2013 at 4:12

GoogleCodeExporter commented 9 years ago
Currently, queries are limited to 60 seconds even when they come from a task. 
We are working on addressing this limitation.

Original comment by razv...@google.com on 15 Jun 2013 at 1:59

GoogleCodeExporter commented 9 years ago
[deleted comment]
GoogleCodeExporter commented 9 years ago
Is there a work-a-round? Or when approximately it is going to be fixed? It's 
blocking the business.

Original comment by kame...@upwork.com on 19 Jun 2013 at 4:23

GoogleCodeExporter commented 9 years ago
We should have a solution for you very shortly.
Subscribe to the google-cloud-sql-announce mailing list for more news:

https://groups.google.com/forum/#!forum/google-cloud-sql-announce

Original comment by joefa...@google.com on 21 Jun 2013 at 5:18

GoogleCodeExporter commented 9 years ago
Notably, there's no such bug in Java environment.

Original comment by kame...@upwork.com on 3 Jul 2013 at 8:01

GoogleCodeExporter commented 9 years ago
Quick note: the new connectivity [1] should fix this issue. Please reopen if 
you are still seeing issues.

[1] https://groups.google.com/forum/#!topic/google-cloud-sql-discuss/GRTyrIqv0qk

Original comment by razv...@google.com on 18 Jul 2013 at 3:55

GoogleCodeExporter commented 9 years ago
Everything works as expected with the new connectivity, thanks for the fix!

Original comment by kame...@upwork.com on 11 Oct 2013 at 12:13