plpython intermittent ImportErrors - Mailing list pgsql-general

From Brian Sutherland
Subject plpython intermittent ImportErrors
Date
Msg-id 20130114163014.GA600@Brians-MacBook-Air.local
Whole thread Raw
Responses Re: plpython intermittent ImportErrors  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: plpython intermittent ImportErrors  (Stuart Bishop <stuart@stuartbishop.net>)
List pgsql-general
Hi,

I have a plpython stored procedure which sometimes fails when I run my
applications automated test suite. The procedure is called hundreds of
times during the tests but only fails a few times, often with the
following ImportError:

    Traceback (most recent call last):
      File "/Users/jinty/.buildout/eggs/setuptools-0.6c11-py2.7.egg/site.py", line 73, in <module>
        __boot()
      File "/Users/jinty/.buildout/eggs/setuptools-0.6c11-py2.7.egg/site.py", line 2, in __boot
        import sys, imp, os, os.path
      File "/Users/jinty/src/mp/lib/python2.7/os.py", line 49, in <module>
        import posixpath as path
      File "/Users/jinty/src/mp/lib/python2.7/posixpath.py", line 15, in <module>
        import stat
    ImportError: No module named stat

Changing the order in which the tests are run, or running tests
individually makes the error move/change or disappear. The behaviour is
the same with PostgreSQL versions 9.2.2 and 9.1.7.

I have tried (but failed) to reproduce this error in a simple .sql
script. Outside of the tests, it always seems to work.

Having run into a brick wall debugging this, I'm hoping there's someone
here who can help?

--
Brian Sutherland


pgsql-general by date:

Previous
From: "Daniel Verite"
Date:
Subject: Re: VALUES() evaluation order
Next
From: Gavin Flower
Date:
Subject: Re: Linux Distribution Preferences?