Maybe it is locked? What engine do you use, is it multi threaded?

Diez

Am 02.07.2010 um 18:12 schrieb Andrea Crotti <andrea.crotti. [email protected]>:

Thanks,
Mmm if I don't add at all I get the LOCKED database error...


Error - <class 'sqlalchemy.exc.OperationalError'>: (OperationalError)
database is locked u'INSERT INTO ldapper_model_entry_entry (name,
description, row_type) VALUES (?, ?, ?)' [u'asdfsdfs', None, 'person']
URL: http://localhost:8081/create_person
File '/Library/Python/2.6/site-packages/WebError-0.10.2-py2.6.egg/
weberror/errormiddleware.py', line 162 in __call__
 app_iter = self.application(environ, sr_checker)
File '/Users/andrea/Documents/turbo2/lib/python2.6/site-packages/
TurboGears2-2.0.3-py2.6.egg/tg/configuration.py', line 655 in wrapper
 return app(environ, start_response)
File '/Users/andrea/Documents/turbo2/lib/python2.6/site-packages/
TurboGears2-2.0.3-py2.6.egg/tg/configuration.py', line 555 in remover
 return app(environ, start_response)
File '/Users/andrea/Documents/turbo2/lib/python2.6/site-packages/
repoze.tm2-1.0a4-py2.6.egg/repoze/tm/__init__.py', line 37 in __call__
 self.commit()
File '/Users/andrea/Documents/turbo2/lib/python2.6/site-packages/
repoze.tm2-1.0a4-py2.6.egg/repoze/tm/__init__.py', line 42 in commit
 t.commit()
File '/Users/andrea/Documents/turbo2/lib/python2.6/site-packages/
transaction-1.0a1-py2.6.egg/transaction/_transaction.py', line 322 in
commit
 self._commitResources()
File '/Users/andrea/Documents/turbo2/lib/python2.6/site-packages/
transaction-1.0a1-py2.6.egg/transaction/_transaction.py', line 414 in
_commitResources
 rm.tpc_begin(self)
File '/Users/andrea/Documents/turbo2/lib/python2.6/site-packages/
zope.sqlalchemy-0.5-py2.6.egg/zope/sqlalchemy/datamanager.py', line 67
in tpc_begin
 self.session.flush()
File '/Library/Python/2.6/site-packages/SQLAlchemy-0.5.6-py2.6.egg/
sqlalchemy/orm/session.py', line 1356 in flush
 self._flush(objects)
File '/Library/Python/2.6/site-packages/SQLAlchemy-0.5.6-py2.6.egg/
sqlalchemy/orm/session.py', line 1434 in _flush
 flush_context.execute()
File '/Library/Python/2.6/site-packages/SQLAlchemy-0.5.6-py2.6.egg/
sqlalchemy/orm/unitofwork.py', line 261 in execute
 UOWExecutor().execute(self, tasks)
File '/Library/Python/2.6/site-packages/SQLAlchemy-0.5.6-py2.6.egg/
sqlalchemy/orm/unitofwork.py', line 753 in execute
 self.execute_save_steps(trans, task)
File '/Library/Python/2.6/site-packages/SQLAlchemy-0.5.6-py2.6.egg/
sqlalchemy/orm/unitofwork.py', line 768 in execute_save_steps
 self.save_objects(trans, task)
File '/Library/Python/2.6/site-packages/SQLAlchemy-0.5.6-py2.6.egg/
sqlalchemy/orm/unitofwork.py', line 759 in save_objects
 task.mapper._save_obj(task.polymorphic_tosave_objects, trans)
File '/Library/Python/2.6/site-packages/SQLAlchemy-0.5.6-py2.6.egg/
sqlalchemy/orm/mapper.py', line 1406 in _save_obj
 c = connection.execute(statement.values(value_params), params)
File '/Library/Python/2.6/site-packages/SQLAlchemy-0.5.6-py2.6.egg/
sqlalchemy/engine/base.py', line 824 in execute
 return Connection.executors[c](self, object, multiparams, params)
File '/Library/Python/2.6/site-packages/SQLAlchemy-0.5.6-py2.6.egg/
sqlalchemy/engine/base.py', line 874 in _execute_clauseelement
 return self.__execute_context(context)
File '/Library/Python/2.6/site-packages/SQLAlchemy-0.5.6-py2.6.egg/
sqlalchemy/engine/base.py', line 896 in __execute_context
 self._cursor_execute(context.cursor, context.statement,
context.parameters[0], context=context)
File '/Library/Python/2.6/site-packages/SQLAlchemy-0.5.6-py2.6.egg/
sqlalchemy/engine/base.py', line 950 in _cursor_execute
 self._handle_dbapi_exception(e, statement, parameters, cursor,
context)
File '/Library/Python/2.6/site-packages/SQLAlchemy-0.5.6-py2.6.egg/
sqlalchemy/engine/base.py', line 931 in _handle_dbapi_exception
 raise exc.DBAPIError.instance(statement, parameters, e,
connection_invalidated=is_disconnect)
OperationalError: (OperationalError) database is locked u'INSERT INTO
ldapper_model_entry_entry (name, description, row_type) VALUES
(?, ?, ?)' [u'asdfsdfs', None, 'person']

--
You received this message because you are subscribed to the Google Groups "TurboGears" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to [email protected] . For more options, visit this group at http://groups.google.com/group/turbogears?hl=en .


--
You received this message because you are subscribed to the Google Groups 
"TurboGears" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/turbogears?hl=en.

Reply via email to