Here it is with private information replaced with generic information. if request.env.web2py_runtime_gae: # if running on Google App Engine db = DAL('gae') # connect to Google BigTable session.connect(request, response, db = db) # and store sessions and tickets there else: # else use a normal relational database db = DAL('postgres://name:password@localhost:5432/db') # db = DAL('sqlite://storage.sqlite')
On Jan 17, 1:19 pm, Massimo Di Pierro <massimo.dipie...@gmail.com> wrote: > Are you using connection pooling? Can I see the line db = DAL(...)? > > On Jan 16, 2:24 pm, VP <vtp2...@gmail.com> wrote: > > > Kenneth (see post above) had the same problem with MySQL. > > > On Jan 16, 3:55 am, ron_m <ron.mco...@gmail.com> wrote: > > > > Is there any chance to try another server based database such as MySQL. > > > Since SQLite did not exhibit a problem that is a valid data point but it > > > is > > > an embedded database so called directly by the web2py server code instead > > > of > > > using a driver. There is a possibility there is a problem with the driver > > > on > > > PostgreSQL if the connections are being reused in a pool. This is very > > > difficult to find without some further logging. I gather the page request > > > you see failing as a user simply never completes. I saw this once while > > > testing the application but the loading is only myself running tests. I > > > use > > > PostgreSQL in this app but I also have a version that runs on MySQL which > > > has only a connection string difference plus the content of the databases > > > directory. Maybe I can try this tomorrow, it is almost 2 am here so I > > > don't > > > want to start something new right now. I just need to learn how to use ab > > > which I take it isn't going to be much to figure out. > >