No Arranca wiithon (error sqlalchemy)

Asked by juanito on 2009-12-20

El error me deba en ubuntu jaunty, pero actualice a karmic y continua

Gracias de antemano

juanio@influenza:~/wiithon$ more /tmp/wiithon_debug.log
Distributor ID: Ubuntu
Description: Ubuntu 9.10
Release: 9.10
Codename: karmic
kernel: 2.6.31-16-generic
LANG=en_US.UTF-8
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"feria@influenza:~/wiithon$ more /tmp/wiithon_debug.log

LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=
================================================================
INFO:sqlalchemy.engine.base.Engine.0x...32cc:PRAGMA table_info("online_features")
INFO:sqlalchemy.engine.base.Engine.0x...32cc:()
INFO:sqlalchemy.engine.base.Engine.0x...32cc:ROLLBACK
Traceback (most recent call last):
  File "/usr/games/wiithon", line 17, in <module>
    from preferencias import Preferencias
  File "/usr/share/wiithon/preferencias.py", line 11, in <module>
    from wiitdb_schema import Preferencia
  File "/usr/share/wiithon/wiitdb_schema.py", line 501, in <module>
    util.crearBDD(Base.metadata)
  File "/usr/share/wiithon/util.py", line 399, in crearBDD
    metadatos.create_all(db)
  File "/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/schema.py", line 1765, in create_all
    bind.create(self, checkfirst=checkfirst, tables=tables)
  File "/usr/local/lib/python2.6/dist-packages/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 "/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/engine/base.py", line 1158, in _run_visitor
    visitorcallable(self.dialect, conn, **kwargs).traverse(element)
  File "/usr/local/lib/python2.6/dist-packages/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 "/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/sql/visitors.py", line 200, in traverse
    return traverse_using(iterate(obj, opts), obj, visitors)
  File "/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/sql/visitors.py", line 194, in traverse_using
    meth(target)
  File "/usr/local/lib/python2.6/dist-packages/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 "/usr/local/lib/python2.6/dist-packages/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 "/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/databases/sqlite.py", line 443, in has_table
    row = cursor.fetchone()
  File "/usr/local/lib/python2.6/dist-packages/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 "/usr/local/lib/python2.6/dist-packages/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

Question information

Language:
English Edit question
Status:
Answered
For:
wiithon Edit question
Assignee:
No assignee Edit question
Last query:
2009-12-20
Last reply:
2009-12-31
Carlo Mandelli (camandel) said : #1

Please try these operations (if the first solves the second is not needed):

1) restore preferencies to defaults (preferencies --> default)
2) format wiithon db (preferencies --> utility and tools --> format DB).

If the this doesn't solve your problem, open a new bug with all steps to reproduce it.

Can you help with this problem?

Provide an answer of your own, or ask juanito for more information if necessary.

To post a message you must log in.