python32-postgresql 1.1.0 invalid (and broken)

[Jeffrey Ness]

Reported by Jason G. via Email:

Hey Guys,

I just noticed that one of our main production sites was down with this error:

=================

Traceback (most recent call last):
  File "/home/jason/DevLevel.2/TMTManage/Python/AppStruct/WSGI/Handler/__init__.py", line 47, in __new__
    Res = self.Exec()
  File "/home/jason/DevLevel.2/TMTManage/Python/AppStruct/WSGI/Handler/Coaster.py", line 174, in Exec
    RVAL = Callable(self)
  File "/home/jason/DevLevel.2/TMTManage/Python/TMTManage/ShockBox_UI/__init__.py", line 71, in Index
    SO.Hit(self.Env.get('REMOTE_ADDR', ''))
  File "/home/jason/DevLevel.2/TMTManage/Python/TMTManage/Dashboard/ShockBox.py", line 897, in Hit
    ('IP', IP),
  File "/home/jason/DevLevel.2/TMTManage/Python/AppStruct/Database/PostgreSQL.py", line 261, in Execute
    return self.CachePrepare(SQL).Execute(*Params)
  File "/home/jason/DevLevel.2/TMTManage/Python/AppStruct/Database/PostgreSQL.py", line 150, in CachePrepare
    self._PS_Cache[SQL] = self.prepare(SQL)
  File "/home/jason/DevLevel.2/TMTManage/Python/AppStruct/Database/PostgreSQL.py", line 136, in prepare
    ps = super().prepare(*args, **kwargs)
  File "/usr/lib64/python3.2/site-packages/postgresql/driver/pq3.py", line 2326, in prepare
    ps._fini()
  File "/usr/lib64/python3.2/site-packages/postgresql/driver/pq3.py", line 1548, in _fini
    pack = (typio.resolve(x) or (None,None))[0]
  File "/usr/lib64/python3.2/site-packages/postgresql/driver/pq3.py", line 247, in resolve
    typio = builtins(typid)
  File "/usr/lib64/python3.2/site-packages/postgresql/types/io/__init__.py", line 107, in resolve
    module_io.update(load(io).oid_to_io)
  File "/usr/lib64/python3.2/site-packages/postgresql/types/io/__init__.py", line 97, in load
    return __import__(__name__ + '.' + relmod, fromlist = True, level = 1)
  File "/usr/lib64/python3.2/site-packages/postgresql/types/io/pg_network.py", line 3, in <module>
    import ipaddress
ImportError: No module named ipaddress

=================

Jason spoke with the python postgresql guys and discovered Python 3.2 is not compatible with v1.1.0 py-postgresql:

   http://pgfoundry.org/pipermail/python-general/2012-October/001003.html

[Jeffrey Ness (jeffrey-ness)]

Test are not being ran on the pythonxx-postgresql packages,
this was handled in the same way Fedora upstream packages were handled:

   http://pkgs.fedoraproject.org/cgit/python3-postgresql.git/tree/python3-postgresql.spec

The reason test are not being ran is due to the test suite requiring a postgresql instance:

+ /usr/bin/python3.2 setup.py test
running test
ERROR: cannot find 'default' pg_config
HINT: set the PGINSTALLATION environment variable to the `pg_config` path
error: Bad exit status from /var/tmp/rpm-tmp.kDm6ef (%check)
RPM build errors:
    Bad exit status from /var/tmp/rpm-tmp.kDm6ef (%check)
Child return code was: 1
EXCEPTION: Command failed. See logs for output.
 # ['bash', '--login', '-c', 'rpmbuild -bb --target x86_64 --nodeps builddir/build/SPECS/python32-postgresql.spec']
Traceback (most recent call last):
  File "/usr/lib/python2.7/site-packages/mockbuild/trace_decorator.py", line 70, in trace
    result = func(*args, **kw)
  File "/usr/lib/python2.7/site-packages/mockbuild/util.py", line 352, in do
    raise mockbuild.exception.Error, ("Command failed. See logs for output.\n # %s" % (command,), child.returncode)
Error: Command failed. See logs for output.
 # ['bash', '--login', '-c', 'rpmbuild -bb --target x86_64 --nodeps builddir/build/SPECS/python32-postgresql.spec']
LEAVE do --> EXCEPTION RAISED

[Jeffrey Ness (jeffrey-ness)]

We have decided to roll back the python32-postgresql-1.1.0-2.ius package to python32-postgresql-1.0.4-1.ius,
the reason for this rollback is due to Python 3.2.x not supporting py-postgresql 1.1.0.

python32-postgresql-1.1.0-2.ius has been added to the IUS Archive repository in case needed,
and python32-postgresql-1.0.4-1.ius has been moved from Archive back to Stable.

It was decided not to epoch python32-postgresql to avoid any future confusion,
that being the case a manual rollback will be necessary (note the mirrors can take up to 24hours to sync):

   # rpm -e python32-postgresql
   # yum install python32-postgresql

As the mirrors can take up to 24 hours to sync, you may choose to grab the packages directly,
below are the links for both i686 and x86_64 for Enterprise Linux 6:

   http://dl.iuscommunity.org/pub/ius/stable/Redhat/6/i386/python32-postgresql-1.0.4-1.ius.el6.i686.rpm
   http://dl.iuscommunity.org/pub/ius/stable/Redhat/6/x86_64/python32-postgresql-1.0.4-1.ius.el6.x86_64.rpm