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

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