Just to wrap up, I describe a fix here:
http://www.manasupo.com/2012/03/geventpsycopg2-execute-cannot-be-used.html
Cheers,
Daniel
On Feb 28, 4:25 pm, j_syk <jesyk...@gmail.com> wrote:
> As far as I remember, I quickly switched back to 'sync' worker type (the
> default) for the app which had this problem. I've never seen the error
> again. I have another project running on eventlet, still with gunicorn,
> postgres, and psycopg2. Never have had any problems with that one. So maybe
> it is a problem with gevent.
>
> I'd like to hear from someone who has had success with gevent.
>
>
>
>
>
>
>
> On Tuesday, February 28, 2012 7:34:03 AM UTC-6, Daniel Svonava wrote:
>
> > Hi, this same error happened to me as well. My setup:
>
> > Django==1.3.1
> > gevent==0.13.6
> > greenlet==0.3.4
> > gunicorn==0.13.4
> > psycopg2==2.4.4
>
> > I use this function to make psycopg2 "green" (in the gunicorn config):
>
> > worker_class = "gevent"
> > def def_post_fork(server, worker):
> > from psyco_gevent import make_psycopg_green
> > make_psycopg_green()
> > worker.log.info("Made Psycopg Green")
> > post_fork = def_post_fork
>
> > This is making me worried of using the Gunicorn+Gevent+psycopg2 combo.
>
> > Cheers,
> > Daniel
>
> > On Friday, January 20, 2012 3:46:47 PM UTC+1, j_syk wrote:
>
> >> I was testing one my apps today with a form that features a drop-down
> >> field that initiates a json lookup for additional detail. You choose a
> >> location, it populates address fields. It's been working for weeks.
> >> Today, when I clicked an entry, the target detail field didn't change.
>
> >> I have debug off, so instantly I feel my phone buzz and I've been sent
> >> a http500 report e-mail with the following message-
>
> >> DatabaseError: execute cannot be used while an asynchronous query is
> >> underway
>
> >> I can't seem to reproduce the error, it's never happened before, and I
> >> haven't changed this piece of code for a while, so I doubt it's
> >> something new.
>
> >> I'm willing to write it off as a fluke, but at the same time I'd like
> >> to learn more and the search results on the topic don't seem good.
>
> >> Server setup is Django 1.3.1, Gunicorn 0.13 with geventlet processes,
> >> Nginx 0.7, postgres 8.4.8,
> >> That particular page was using Jquery and a .getJSON call to a json
> >> output produced by a django view which calls a basic query.
>
> >> What should I know about the "asynchronous query" error? Are there
> >> ways to prevent it? Should I be worried?
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
