1.74.5. I will upgrade when I can reproduce the problem locally.
On Jan 17, 5:13 pm, Massimo Di Pierro <massimo.dipie...@gmail.com>
wrote:
> How old web2py? We have had bugs in the past that may cause your
> problem.
> You should try upgrade.
>
> Massimo
>
> On Jan 17, 6:58 pm, Michael Toomim <too...@gmail.com> wrote:
>
>
>
> > The problem for me is that this occurs on a webapp used by mechanical
> > turk, and it fails when I have hundreds of mechanical turkers using my
> > app... which only happens when I pay them hundreds of dollars. So
> > it's hard to reproduce right now without hundreds of dollars.
>
> > I am excited to try using VP's ab benchmark to try to reproduce the
> > error more cheaply. When I can do that, and get a minimal system
> > exhibiting the error, I will let you know.
>
> > I'm also currently using an older version of web2py. One pre-DAL.
>
> > On Jan 17, 12:20 pm, Massimo Di Pierro <massimo.dipie...@gmail.com>
> > wrote:
>
> > > You should really have
>
> > > db = DAL('postgres://name:password@localhost:5432/db',pool_size=20)
>
> > > The reason is that client-server databases may set a max to number of
> > > open connections and it takes time to perform the 3-way handshake to
> > > establish a new connection at every http request. Without pooling you
> > > may hit the max sooner than you should.
>
> > > This will also make your app faster.
>
> > > Massimo
>
> > > On Jan 17, 1:39 pm, VP <vtp2...@gmail.com> wrote:
>
> > > > 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.
