[egenix-users] hangs: import mx.ODBC.unixODBC

[Griff McClellan]

Hello,

I have been using mxODBC 2.0.5 and python 2.3 with no problems for over six months.  Suddenly, my python scripts that import mx.ODBC.unixODBC don't work.  The problem is that when I import that module, the python interpreter hangs.  Further, if I type control-C and then import again, the interpreter imports successfully.  Here's a session that demonstrates the problem:

[oracle at lin ~]$ python
Python 2.3.4 (#1, Jan  9 2007, 16:40:18)
[GCC 3.4.6 20060404 (Red Hat 3.4.6-3)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>>
>>> import sys # just to show that importing works
>>>
>>> import mx.ODBC.unixODBC

...hanging...^C

Traceback (most recent call last):
  File "<stdin>", line 1, in ?
  File "/usr/lib/python2.3/site-packages/mx/ODBC/unixODBC/__init__.py", line 8, in ?
    from mxODBC import *
KeyboardInterrupt
>>>
>>> import mx.ODBC.unixODBC
>>>
>>> mx.ODBC.__version__
'2.0.1'
>>>

If I go to /usr/lib/python2.3/site-packages/mx, where my installation resides, I see the same problem.

[oracle at lin python]$ cd /usr/lib/python2.3/site-packages/mx/ODBC/unixODBC/
[oracle at lin unixODBC]$
[oracle at lin unixODBC]$ python
Python 2.3.4 (#1, Jan  9 2007, 16:40:18)
[GCC 3.4.6 20060404 (Red Hat 3.4.6-3)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>>
>>> import mxODBC

...hanging...^C

Traceback (most recent call last):
  File "<stdin>", line 1, in ?
KeyboardInterrupt
>>>
>>> import mxODBC
>>>
>>> mxODBC.__version__
'2.0.5'
>>>

My database is Oracle 10g and my OS is Red Hat Enterprise Linux ES release 4 (Nahant Update 4).  The database seems to work fine although a tablespace did fill up around the time the import stopped working.  I haven't been able to get test.py to work because I can't find a connect arguments it will accept.

Any ideas what the problem could be?

Thanks,
Griff
-------------- next part --------------
An HTML attachment was scrubbed...
URL: /mailman-archives/egenix-users/attachments/20071012/a2b7a827/attachment.htm