id,summary,reporter,owner,description,type,status,component,version,severity,resolution,keywords,cc,stage,has_patch,needs_docs,needs_tests,needs_better_patch,easy,ui_ux 7628,syncdb fails in Oracle when orphaned sequences exist,elamrtus,cmarshal,"when syncdb is run against oracle, it creates one table and crashes, throwing an exception: {{{ Creating table auth_permission Traceback (most recent call last): File ""./manage.py"", line 11, in execute_manager(settings) File ""/usr/lib/python2.5/site-packages/django/core/management/__init__.py"", line 272, in execute_manager utility.execute() File ""/usr/lib/python2.5/site-packages/django/core/management/__init__.py"", line 219, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File ""/usr/lib/python2.5/site-packages/django/core/management/base.py"", line 72, in run_from_argv self.execute(*args, **options.__dict__) File ""/usr/lib/python2.5/site-packages/django/core/management/base.py"", line 86, in execute output = self.handle(*args, **options) File ""/usr/lib/python2.5/site-packages/django/core/management/base.py"", line 168, in handle return self.handle_noargs(**options) File ""/usr/lib/python2.5/site-packages/django/core/management/commands/syncdb.py"", line 76, in handle_noargs cursor.execute(statement) File ""/usr/lib/python2.5/site-packages/django/db/backends/util.py"", line 18, in execute return self.cursor.execute(sql, params) File ""/usr/lib/python2.5/site-packages/django/db/backends/oracle/base.py"", line 299, in execute return Database.Cursor.execute(self, query, params) cx_Oracle.DatabaseError: ORA-00955: name is already used by an existing object }}} This happens for every table Then, when all tables are created, i run it again and get: {{{ Traceback (most recent call last): File ""./manage.py"", line 11, in execute_manager(settings) File ""/usr/lib/python2.5/site-packages/django/core/management/__init__.py"", line 272, in execute_manager utility.execute() File ""/usr/lib/python2.5/site-packages/django/core/management/__init__.py"", line 219, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File ""/usr/lib/python2.5/site-packages/django/core/management/base.py"", line 72, in run_from_argv self.execute(*args, **options.__dict__) File ""/usr/lib/python2.5/site-packages/django/core/management/base.py"", line 86, in execute output = self.handle(*args, **options) File ""/usr/lib/python2.5/site-packages/django/core/management/base.py"", line 168, in handle return self.handle_noargs(**options) File ""/usr/lib/python2.5/site-packages/django/core/management/commands/syncdb.py"", line 97, in handle_noargs emit_post_sync_signal(created_models, verbosity, interactive) File ""/usr/lib/python2.5/site-packages/django/core/management/sql.py"", line 491, in emit_post_sync_signal verbosity=verbosity, interactive=interactive) File ""/usr/lib/python2.5/site-packages/django/dispatch/dispatcher.py"", line 360, in send **named File ""/usr/lib/python2.5/site-packages/django/dispatch/robustapply.py"", line 47, in robustApply return receiver(*arguments, **named) File ""/usr/lib/python2.5/site-packages/django/contrib/auth/management.py"", line 26, in create_permissions ctype = ContentType.objects.get_for_model(klass) File ""/usr/lib/python2.5/site-packages/django/contrib/contenttypes/models.py"", line 28, in get_for_model defaults = {'name': smart_unicode(opts.verbose_name_raw)}, File ""/usr/lib/python2.5/site-packages/django/db/models/manager.py"", line 85, in get_or_create return self.get_query_set().get_or_create(**kwargs) File ""/usr/lib/python2.5/site-packages/django/db/models/query.py"", line 226, in get_or_create obj.save() File ""/usr/lib/python2.5/site-packages/django/db/models/base.py"", line 272, in save self.save_base() File ""/usr/lib/python2.5/site-packages/django/db/models/base.py"", line 329, in save_base result = manager._insert(values, return_id=update_pk) File ""/usr/lib/python2.5/site-packages/django/db/models/manager.py"", line 127, in _insert return insert_query(self.model, values, **kwargs) File ""/usr/lib/python2.5/site-packages/django/db/models/query.py"", line 729, in insert_query return query.execute_sql(return_id) File ""/usr/lib/python2.5/site-packages/django/db/models/sql/subqueries.py"", line 300, in execute_sql cursor = super(InsertQuery, self).execute_sql(None) File ""/usr/lib/python2.5/site-packages/django/db/models/sql/query.py"", line 1466, in execute_sql cursor.execute(sql, params) File ""/usr/lib/python2.5/site-packages/django/db/backends/util.py"", line 18, in execute return self.cursor.execute(sql, params) File ""/usr/lib/python2.5/site-packages/django/db/backends/oracle/base.py"", line 299, in execute return Database.Cursor.execute(self, query, params) cx_Oracle.DatabaseError: ORA-01400: cannot insert NULL into (""ORACLE"".""DJANGO_CONTENT_TYPE"".""ID"") }}}",,closed,Core (Management commands),dev,,fixed,,,Accepted,1,0,0,0,0,0