#16454: sequence for AUTH_PERMISSION.ID
----------------------------+----------------------------------------------
Reporter: | Owner: nobody
alexei.vlassov@… | Status: new
Type: Bug | Component: Database layer (models, ORM)
Milestone: | Severity: Release blocker
Version: SVN | Triage Stage: Unreviewed
Keywords: oracle | Easy pickings: 0
Has patch: 0 |
UI/UX: 0 |
----------------------------+----------------------------------------------
manage.py syncdb fails with ORA-06552
{{{
Traceback (most recent call last):
File "./manage.py", line 20, in <module>
execute_manager(settings)
File
"/media/sf_workspace_python/djadmin/3rdparty/apps/django/core/management/__init__.py",
line 442, in execute_manager
utility.execute()
File
"/media/sf_workspace_python/djadmin/3rdparty/apps/django/core/management/__init__.py",
line 379, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File
"/media/sf_workspace_python/djadmin/3rdparty/apps/django/core/management/base.py",
line 191, in run_from_argv
self.execute(*args, **options.__dict__)
File
"/media/sf_workspace_python/djadmin/3rdparty/apps/django/core/management/base.py",
line 220, in execute
output = self.handle(*args, **options)
File
"/media/sf_workspace_python/djadmin/3rdparty/apps/django/core/management/base.py",
line 351, in handle
return self.handle_noargs(**options)
File
"/media/sf_workspace_python/djadmin/3rdparty/apps/south/management/commands/syncdb.py",
line 90, in handle_noargs
syncdb.Command().execute(**options)
File
"/media/sf_workspace_python/djadmin/3rdparty/apps/django/core/management/base.py",
line 220, in execute
output = self.handle(*args, **options)
File
"/media/sf_workspace_python/djadmin/3rdparty/apps/django/core/management/base.py",
line 351, in handle
return self.handle_noargs(**options)
File
"/media/sf_workspace_python/djadmin/3rdparty/apps/django/core/management/commands/syncdb.py",
line 109, in handle_noargs
emit_post_sync_signal(created_models, verbosity, interactive, db)
File
"/media/sf_workspace_python/djadmin/3rdparty/apps/django/core/management/sql.py",
line 190, in emit_post_sync_signal
interactive=interactive, db=db)
File
"/media/sf_workspace_python/djadmin/3rdparty/apps/django/dispatch/dispatcher.py",
line 172, in send
response = receiver(signal=self, sender=sender, **named)
File
"/media/sf_workspace_python/djadmin/3rdparty/apps/django/contrib/auth/management/__init__.py",
line 56, in create_permissions
content_type=ctype
File
"/media/sf_workspace_python/djadmin/3rdparty/apps/django/db/models/manager.py",
line 138, in create
return self.get_query_set().create(**kwargs)
File
"/media/sf_workspace_python/djadmin/3rdparty/apps/django/db/models/query.py",
line 360, in create
obj.save(force_insert=True, using=self.db)
File
"/media/sf_workspace_python/djadmin/3rdparty/apps/django/db/models/base.py",
line 463, in save
self.save_base(using=using, force_insert=force_insert,
force_update=force_update)
File
"/media/sf_workspace_python/djadmin/3rdparty/apps/django/db/models/base.py",
line 556, in save_base
result = manager._insert(values, return_id=update_pk, using=using)
File
"/media/sf_workspace_python/djadmin/3rdparty/apps/django/db/models/manager.py",
line 198, in _insert
return insert_query(self.model, values, **kwargs)
File
"/media/sf_workspace_python/djadmin/3rdparty/apps/django/db/models/query.py",
line 1456, in insert_query
return query.get_compiler(using=using).execute_sql(return_id)
File
"/media/sf_workspace_python/djadmin/3rdparty/apps/django/db/models/sql/compiler.py",
line 810, in execute_sql
cursor = super(SQLInsertCompiler, self).execute_sql(None)
File
"/media/sf_workspace_python/djadmin/3rdparty/apps/django/db/models/sql/compiler.py",
line 754, in execute_sql
cursor.execute(sql, params)
File
"/media/sf_workspace_python/djadmin/3rdparty/apps/django/db/backends/util.py",
line 34, in execute
return self.cursor.execute(sql, params)
File
"/media/sf_workspace_python/djadmin/3rdparty/apps/django/db/backends/oracle/base.py",
line 640, in execute
return self.cursor.execute(query, self._param_generator(params))
django.db.utils.IntegrityError: ORA-01400: cannot insert NULL into
("***"."AUTH_PERMISSION"."ID")
}}}
params from django/db/backends/oracle/base.py line 640
{{{
INSERT INTO "AUTH_PERMISSION" ("NAME", "CONTENT_TYPE_ID", "CODENAME")
VALUES (:arg0, :arg1, :arg2) RETURNING "AUTH_PERMISSION"."ID" INTO :arg3
['Can add permission', 1, 'add_permission', <cx_Oracle.NUMBER with value
None>]
}}}
Django 1.4 pre-alpha SVN-16538
Python 2.6.5 (r265:79063, Apr 16 2010, 13:09:56)
cx_Oracle 5.0
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
--
Ticket URL: <https://code.djangoproject.com/ticket/16454>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" 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/django-updates?hl=en.
