On Fri, May 22, 2009 at 7:41 AM, m...@nysv.org <markus.tornqv...@gmail.com>wrote:
> > Hi! > > I'm using python-processing to run things in parallell based > on data in a Django-powered database. > > I'm also seeing all sorts of funky tracebacks: > Traceback (most recent call last): > File "utils/XXXXX.py", line XXXXX, in XXXXXX > XXXXXX = XXXXX(XXXX, XXXXX=XXXXX, XXXX=XXXX) > File "XXXXXX", line XXXXX, in __init__ > self.XXXXX = self.XXXXX[list_index][attr] > [snip] > File "/var/lib/python-support/python2.5/django/db/models/sql/ > query.py", line 1 > 748, in <lambda> > result = iter((lambda: cursor.fetchmany(GET_ITERATOR_CHUNK_SIZE)), > ProgrammingError: no results to fetch > > It looks to me like postgres is opening only one connection here. > > What are my options? > > 1. Can I open new connections somehow and force the child-process > functions to use them? > 2. Re-architecture my code totally from a processing.Pool() with .imap > () > to something else? (This is probably what I'll try while I await a > reply :) > 3. Revert to writing my own queries and opening connections really by > hand > 4. Something else? > > Thanks for any reply, I'm sure I'm not the only one fighting this > issue, > though Googling didn't find many others :) > FWIW, the only other time I recall something like this coming up is here: http://groups.google.com/group/django-users/browse_thread/thread/4b9ae45419db931e/ You need to ensure that your multiple processes are not attempting to share a single database connection; whatever you are doing now is apparently resulting in them all trying to use a single connection. You might try starting off your routine that you are running in parallel with a connection.close() (connection is in django.db) and seeing if that forces re-initialization of a new connection for each process. Don't know if that will actually work, though. Karen --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
