tests failed

[GoogleCodeExporter]

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

Original issue reported on code.google.com by bchesn...@gmail.com on 17 Apr 2009 at 9:39

[GoogleCodeExporter]

try removing your old bin/ and run this instead

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

Original comment by jbel...@gmail.com on 17 Apr 2009 at 2:36

[GoogleCodeExporter]

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.

Original comment by gael.pas...@gmail.com on 17 Apr 2009 at 3:38

• Changed state: Accepted

[GoogleCodeExporter]

All works fine with SA 0.5.3 and latest pysqlite

Original comment by gael.pas...@gmail.com on 17 Apr 2009 at 3:53

• Changed state: Fixed

[GoogleCodeExporter]

tests worked with latest trunk. thanks :)

Original comment by bchesn...@gmail.com on 17 Apr 2009 at 4:07

[GoogleCodeExporter]

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

Original comment by wackysa...@gmail.com on 17 Apr 2009 at 10:16

[GoogleCodeExporter]

oops, sorry

Original comment by wackysa...@gmail.com on 17 Apr 2009 at 10:18