Re: [GCSQL] DatabaseError: 0: Connection is already in use

Hi Ken,

Thanks, but could you please clarify? Do you mean I need to catch
this error, recreate a connection and retry the same query?

Jake



On Fri, Jun 22, 2012 at 4:15 PM, Ken Ashcraft <kash@google.com> wrote:
> It means that the query is still executing on the server.  You need to throw
> away the connection and create a new one.
>
>
> On Fri, Jun 22, 2012 at 1:48 AM, Jake Czyz <jjc.work@gmail.com> wrote:
>>
>> Hello,
>>
>> My GAE app gets the following error occasionally during GC-SQL calls,
>> when unlocking previously locked tables.  Searching for the error
>> turned up nothing.  Does anyone have an idea about what could cause
>> it?
>>
>> <snip>
>>    cursor.execute('UNLOCK TABLES') #always unlock
>>  File "/base/python27_runtime/
>> python27_lib/versions/1/google/storage/speckle/python/api/rdbms.py",
>> line 424, in execute
>>    self._DoExec(request)
>>  File
>> "/base/python27_runtime/python27_lib/versions/1/google/storage/speckle/python/api/rdbms.py",
>> line 355, in _DoExec
>>    response = self._conn.MakeRequest('Exec', request)
>>  File
>> "/base/python27_runtime/python27_lib/versions/1/google/storage/speckle/python/api/rdbms.py",
>> line 711, in MakeRequest
>>    response = self._MakeRetriableRequest(stub_method, request)
>>  File
>> "/base/python27_runtime/python27_lib/versions/1/google/storage/speckle/python/api/rdbms.py",
>> line 742, in _MakeRetriableRequest
>>    sql_exception.message))
>> DatabaseError: 0: Connection is already in use.
>>
>>
>> Thanks in advance,
>> Jake
>
>