This happened to me as well. Happened after installing libsqlite3-dev. Fixed by running apt-get remove libsqlite3-dev .
Best, David. On Thursday, 8 November 2012 10:19:06 UTC+3, Eugeny Klementev wrote: > > Hi all, > > I use sqlalchemy with postgresql backend. > > On script starting i use code to initialize all table: > > engine = create_engine(settings.database_engine) > Base.metadata.create_all(engine) > session = Session(bind = engine) > > And i run two instances of this script. > > One of instances broken with message: > > Traceback (most recent call last): > File "./datadb.py", line 40, in <module> > Base.metadata.create_all(engine) > File "/usr/lib/python2.7/dist-packages/sqlalchemy/schema.py", line 2515, > in create_all > tables=tables) > File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line > 2234, in _run_visitor > conn._run_visitor(visitorcallable, element, **kwargs) > File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line > 1904, in _run_visitor > **kwargs).traverse_single(element) > File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line > 86, in traverse_single > return meth(obj, **kw) > File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/ddl.py", line > 67, in visit_metadata > self.traverse_single(table, create_ok=True) > File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line > 86, in traverse_single > return meth(obj, **kw) > File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/ddl.py", line > 86, in visit_table > self.connection.execute(schema.CreateTable(table)) > File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line > 1405, in execute > params) > File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line > 1496, in _execute_ddl > compiled > File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line > 1646, in _execute_context > context) > File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line > 1639, in _execute_context > context) > File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", > line 330, in do_execute > cursor.execute(statement, parameters) > sqlalchemy.exc.IntegrityError: (IntegrityError) duplicate key value > violates unique constraint "pg_type_typname_nsp_index" > DETAIL: Key (typname, typnamespace)=(datadb_datapoint_id_seq, 2200) > already exists. > '\nCREATE TABLE datadb_datapoint (\n\tid SERIAL NOT NULL, \n\tunit_id > INTEGER NOT NULL, \n\ttimestamp INTEGER NOT NULL, \n\tvalue_type VARCHAR > NOT NULL, \n\tvalue VARCHAR NOT NULL, \n\tPRIMARY KEY (id)\n)\n\n' {} > > I understand it is conflict of creation of tables from different instances > at one time. > > I hope that sqlalchemy has any locking mechanism, but my investigations > are failed. > > Anybody known solution of my problem? > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy?hl=en. For more options, visit https://groups.google.com/groups/opt_out.