Re: multiple oracle database queries in one request problem

On 09/01/2010 11:54 PM, Reinout van Rees wrote:
> On 09/01/2010 02:00 PM, Reinout van Rees wrote:
>> Hi,
>>
>> I'm deploying a site on windows with oracle (and I don't know either of
>> them well). Simple apache+wsgi setup for now.
>
> I'll have to test it out tomorrow when I'm near the windows machine
> again, but I might have found the solution in an existing bug report:
> http://code.djangoproject.com/ticket/13351
>
> In a threaded situation (which you always have with mod_wsgi on
> windows), you apparently need to pass the cx_oracle database driver a
> threaded=True option (which is off by default).
>
> So I added the following to my database config and I'm hoping I'll be
> happy tomorrow morning...
>
> 'OPTIONS': {'threaded': True}

That did not help... If anything, it crashes earlier.

Some things I know for (reasonably) sure:

- It occurs when running with threads: mod_wsgi on windows.

- It occurs when talking to the oracle database.

- It occurs when I talk to two databases on the same oracle server
(well, that's database in django speak, oracle calls it a schema: it is
in the same physical oracle-speak database).

So I'm desperately trying to figure out how to tell mod_wsgi to run in
single threaded mode for the time being. The problem is that only
WSGIDaemonProcess has the required "threads=1" option and exactly that
WSGIDaemonProcess isn't available on windows! Catch 22.

Reinout

--
Reinout van Rees - reinout@vanrees.org - http://reinout.vanrees.org
Collega's gezocht!
Django/python vacature in Utrecht: http://tinyurl.com/35v34f9

--
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+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.