[Catalog-sig] psycoph errors from pypi

[Jim Fulton]

I imagine the people working on the cheeseshop are aware of this,  
but, in case you aren't, I'm getting intermittent  errors from the  
cheeseshop.  For example, requests for:  http://www.python.org/pypi/  
Often give:

Error...

There's been a problem with your request

psycopg.ProgrammingError: ERROR:  current transaction is aborted,  
commands ignored until end of transaction block

select name, version, summary, _pypi_ordering
             from releases  where (lower(name) LIKE '%%%%') and  
_pypi_hidden = FALSE
             order by lower(name), _pypi_ordering

or http://www.python.org/pypi/setuptools sometimes gives:

Error...

There's been a problem with your request

psycopg.ProgrammingError: ERROR:  current transaction is aborted,  
commands ignored until end of transaction block


             select name, version, summary, _pypi_hidden
             from releases
             where name = 'setuptools' and _pypi_hidden = False
             order by _pypi_ordering desc

http://www.python.org/pypi/setuptools/0.6c6 gives:

Error...

There's been a problem with your request

psycopg.ProgrammingError: ERROR:  current transaction is aborted,  
commands ignored until end of transaction block

select packages.name as name, stable_version, version, author,
                   author_email, maintainer, maintainer_email,  
home_page,
                   license, summary, description, description_html,  
keywords,
                   platform, download_url, _pypi_ordering, _pypi_hidden,
                   cheesecake_installability_id,
                   cheesecake_documentation_id,
                   cheesecake_code_kwalitee_id
                  from packages, releases
                  where packages.name='setuptools' and version='0.6c6'
                   and packages.name = releases.name

And so on.

Jim

--
Jim Fulton			mailto:jim at zope.com		Python Powered!
CTO 				(540) 361-1714			http://www.python.org
Zope Corporation	http://www.zope.com		http://www.zope.org