Philip,
"I've discovered that if I create an empty database via a direct
connection to CloudSQL and point the DAL at that" that statement makes
me think....
web2py *never* sends a "create database" statement to the database (no
matter what DB you are using). it expects that the DB server is up and
running at the configured address, and that the empty database/schema
(depending on the DB engine the terms change) is already there with
proper permissions for the user that web2py will try to login with.
then web2py will issue "create table" statements as needed. if the
database/schema does not exist, there will be errors.
cfh
On 3/6/13 0:07 , Philip Kilner wrote:
Hi Christian,
On 06/03/13 07:42, Christian Foster Howes wrote:
the ticket you linked to looks like it is not failing on the connection,
but rather failing on a query. these 2 line are of interest to me:
File
"/base/data/home/apps/s~gk-hercules/1.365624770532609305/gluon/dal.py", line
4115, in execute
return self.log_execute(command.decode('utf8'), *a, **b)
File
"/base/data/home/apps/s~gk-hercules/1.365624770532609305/gluon/dal.py", line
1703, in log_execute
ret = self.cursor.execute(*a, **b)
Well spotted - it's spitting out a very wide variety of errors, but I'm
increasingly leaning to thinking it relates to the failed migration.
any chance you are able to open dal.py and put in some debug logging
at those lines an run it again? I'm curious what query/command web2py
is trying to run on the database. that might open the door to the
missing answer!
I'll do that - I've discovered that if I create an empty database via a
direct connection to CloudSQL and point the DAL at that, the application
is accessible.
Given GAE's recent issues around resources/latency, I'm beginning to
think that this is the real issue, and the other factors are simply
generating spurious errors before it can show me the "real" error.
I'm really anxious to get the migration pickles out of the db that they
are attempting to manage and into GAE's datastore.
I've had to move the app to conventional hosting, as this has been a
huge time-sink, so it will be a day or two before I get back to it.
--
---
You received this message because you are subscribed to the Google Groups "web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
