prabhu S pisze:
> Solution appears like a hack to me. Why do you close the connection in
> every process? Can you not just close once in parent? Execute commits
> alone in each process.
>
I've checked that. Unfortunately, in my case, it won't work. I have a
loop looking like this:
for job in joblist:
p = Process(target=self.run_job)
p.start()
When i close connection before this loop i get errors like at the
beggining. When i close connection just before creating a new process i
get: 'lost connection while performing a query' (or something like that
:)). Finally when i close connection just right after this loop it
starts to behave weirdly. One time it works fine, but next time i launch
it i get mysql has gone away errors. I suppose this happens because
sometimes subprocesses fire up queries after parent finishes this loop,
but sometimes they're faster and still use parent's connection.
Closing connections in subprocesses might look a bit hacky. I could try
to somehow reinitialize db connection, but simply closing it, and
leaving the rest to django is a lot easier :)
Thank you for your replies. I appreciate it.
Regards
Spajderix
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
