Re: Django+ oracle, working with apache(mod_python, wsgi) and in runserver, ora-03114 in fastcgi

Django 1.2.3
python 2.6
cx_oracle 5.0.4
oracle 10 XE

$ cat /var/log/nginx/localhost.error_log
2011/02/28 16:52:39 [error] 11159#0: *47 FastCGI sent in stderr:
"Traceback (most recent call last):
File "/usr/lib/python2.6/site-packages/flup-1.0.3.dev_20110111-
py2.6.egg/flup/server/fcgi_base.py", line 574, in run
protocolStatus, appStatus = self.server.handler(self)
File "/usr/lib/python2.6/site-packages/flup-1.0.3.dev_20110111-
py2.6.egg/flup/server/fcgi_base.py", line 1159, in handler
result = self.application(environ, start_response)
File "/home/intranet/libs/django/core/handlers/wsgi.py", line 248,
in __call__
signals.request_finished.send(sender=self.__class__)
File "/home/intranet/libs/django/dispatch/dispatcher.py", line 162,
in send
response = receiver(signal=self, sender=sender, **named)
File "/home/intranet/libs/django/db/__init__.py", line 84, in
close_connection
conn.close()
File "/home/intranet/libs/django/db/backends/__init__.py", line 70,
in close
self.connection.close()
OperationalError: ORA-03114: not connected to ORACLE" while reading
response header from upstream, client: 192.168.1.105, server:
localhost, request: "GET /accounts/menuleft/122/ HTTP/1.1", upstream:
"fastcgi://127.0.0.1:9001", host: "192.168.1.50", referrer: "http://
192.168.1.50/accounts/menuleft/"
2011/02/28 16:54:46 [error] 11159#0: *56 connect() failed (111:
Connection refused) while connecting to upstream, client:
192.168.1.105, server: localhost, request: "GET /accounts/menuleft/
122/ HTTP/1.1", upstream: "fastcgi://127.0.0.1:9001", host:
"192.168.1.50", referrer: "http://192.168.1.50/accounts/menuleft/"

On 1 Mar, 01:45, Ian <ian.g.ke...@gmail.com> wrote:
> On Feb 28, 10:04 am, lipt0n <michal.lipin...@gmail.com> wrote:
>
>
>
> > Hi
> > my application works fine in apache as mod_python and wsgi, also work
> > great when I run manage.py runserver
> > but I have to move it on nginx.
>
> > so I run it by 'python2.6 manage.py runfcgi host=127.0.0.1 port=9001 --
> > settings=settings'
> > and it works fine until it have to connect to the database (oracle in
> > my situation) and i get " Unhandled Exception",
> > when I checked logs its what I found :
> > "
> > OperationalError: ORA-03114: not connected to ORACLE" while reading
> > response header from upstream, client: 192.168.1.105, server:
> > localhost, request: "POST / HTTP/1.1", upstream: "fastcgi://
> > 127.0.0.1:9001", host: "192.168.1.50", referrer: "http://
> > 192.168.1.50/"
> > "
>
> > ORACLE enviroment vars are set correctly, what can I do to fix this?
>
> Could you post the full traceback?  That may be helpful in figuring
> out what is happening.  Also, what versions of Django, Oracle, and
> cx_Oracle are you using?
>
> Thanks,
> Ian

--
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.