What steps will reproduce the problem? 1. bootstrap.py 2. buidout 3. bin/test

What is the expected output? What do you see instead?

tests failed : enlil:formalchemy benoitc$ sudo bin/test Traceback (most recent call last): File "bin/test", line 26, in <module> from formalchemy import tests File "/Users/benoitc/Work/formalchemy/formalchemy/tests/init.py", line 264, in <module> Base.metadata.create_all() File "/Users/benoitc/Work/formalchemy/eggs/SQLAlchemy-0.5.2- py2.6.egg/sqlalchemy/schema.py", line 1765, in create_all bind.create(self, checkfirst=checkfirst, tables=tables) File "/Users/benoitc/Work/formalchemy/eggs/SQLAlchemy-0.5.2- py2.6.egg/sqlalchemy/engine/base.py", line 1129, in create self._run_visitor(self.dialect.schemagenerator, entity, connection=connection, **kwargs) File "/Users/benoitc/Work/formalchemy/eggs/SQLAlchemy-0.5.2- py2.6.egg/sqlalchemy/engine/base.py", line 1158, in _run_visitor visitorcallable(self.dialect, conn, **kwargs).traverse(element) File "/Users/benoitc/Work/formalchemy/eggs/SQLAlchemy-0.5.2- py2.6.egg/sqlalchemy/sql/visitors.py", line 89, in traverse return traverse(obj, self.traverse_options, self._visitor_dict) File "/Users/benoitc/Work/formalchemy/eggs/SQLAlchemy-0.5.2- py2.6.egg/sqlalchemy/sql/visitors.py", line 200, in traverse return traverse_using(iterate(obj, opts), obj, visitors) File "/Users/benoitc/Work/formalchemy/eggs/SQLAlchemy-0.5.2- py2.6.egg/sqlalchemy/sql/visitors.py", line 194, in traverse_using meth(target) File "/Users/benoitc/Work/formalchemy/eggs/SQLAlchemy-0.5.2- py2.6.egg/sqlalchemy/sql/compiler.py", line 795, in visit_metadata collection = [t for t in sql_util.sort_tables(tables) if self._can_create(t)] File "/Users/benoitc/Work/formalchemy/eggs/SQLAlchemy-0.5.2- py2.6.egg/sqlalchemy/sql/compiler.py", line 788, in _can_create return not self.checkfirst or not self.dialect.has_table(self.connection, table.name, schema=table.schema) File "/Users/benoitc/Work/formalchemy/eggs/SQLAlchemy-0.5.2- py2.6.egg/sqlalchemy/databases/sqlite.py", line 443, in has_table row = cursor.fetchone() File "/Users/benoitc/Work/formalchemy/eggs/SQLAlchemy-0.5.2- py2.6.egg/sqlalchemy/engine/base.py", line 1668, in fetchone self.connection._handle_dbapi_exception(e, None, None, self.cursor, self.context) File "/Users/benoitc/Work/formalchemy/eggs/SQLAlchemy-0.5.2- py2.6.egg/sqlalchemy/engine/base.py", line 931, in _handle_dbapi_exception raise exc.DBAPIError.instance(statement, parameters, e, connection_invalidated=is_disconnect) sqlalchemy.exc.ProgrammingError: (ProgrammingError) Cannot operate on a closed cursor. None None

What version of the product are you using? On what operating system? last trunk

try removing your old bin/ and run this instead

$ python -S bootstrap.py $ python -S bin/buildout

Semi-fixed in the trunk. The pysqlite > 1.5.3 break FA's tests or SA.

Version is fixed to 1.5.3 in buildout.cfg

We need to fix this later or see if next SA releases have the same bug.

All works fine with SA 0.5.3 and latest pysqlite

tests worked with latest trunk. thanks :)

Same thing here:

....env/formalchemy$ ls eggs/ Babel-0.9.4-py2.5.egg Paste-1.7.2-py2.5.egg
Sphinx-0.6.1-py2.5.egg Beaker-1.3-py2.5.egg PasteDeploy-1.3.2-py2.5.egg
SQLAlchemy-0.5.2-py2.5.egg BeautifulSoup-3.1.0.1-py2.5.egg PasteScript-1.7.3-py2.5.egg
Tempita-0.3-py2.5.egg coverage-2.85-py2.5.egg Pygments-1.0-py2.5.egg
WebError-0.10.1-py2.5.egg decorator-3.0.1-py2.5.egg Pylons-0.9.7rc4-py2.5.egg
WebHelpers-0.6.4-py2.5.egg docutils-0.5-py2.5.egg pyprof2calltree-1.1.0-py2.5.egg
WebOb-0.9.6.1-py2.5.egg FormEncode-1.2.2-py2.5.egg py_restclient-1.2.3-py2.5.egg
WebTest-1.1-py2.5.egg Genshi-0.5.1-py2.5-linux-i686.egg py_simplecouchdb-0.9.26-py2.5.egg
zc.buildout-1.2.1-py2.5.egg httplib2-0.4.0-py2.5.egg pysqlite-2.5.5-py2.5-linux-i686.egg
zc.recipe.egg-1.2.2-py2.5.egg Jinja2-2.1.1-py2.5-linux-i686.egg repoze.profile-0.8-py2.5.egg
zope.event-3.4.1-py2.5.egg Mako-0.2.4-py2.5.egg Routes-1.10.3-py2.5.egg
zope.i18nmessageid-3.4.3-py2.5-linux-i686.egg meld3-0.6.5-py2.5.egg setuptools-0.6c9-py2.5.egg
zope.interface-3.5.1-py2.5-linux-i686.egg nose-0.10.4-py2.5.egg simplejson-2.0.9-py2.5-linux-i686.egg zope.schema-3.5.4-py2.5.egg

oops, sorry