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
12387	TransactionRollbackError when there are more ForeignKey's to one table	szymon@…	nobody	"Postgres backend. When there is more references to one table with ForeignKey in same model sometimes there is thrown Exception (not always).
{{{
File ""/usr/local/lib/python2.6/site-packages/django/db/models/base.py"", line 410, in save
   self.save_base(force_insert=force_insert, force_update=force_update)

 File ""/usr/local/lib/python2.6/site-packages/django/db/models/base.py"", line 495, in save_base
   result = manager._insert(values, return_id=update_pk)

 File ""/usr/local/lib/python2.6/site-packages/django/db/models/manager.py"", line 177, in _insert
   return insert_query(self.model, values, **kwargs)

 File ""/usr/local/lib/python2.6/site-packages/django/db/models/query.py"", line 1087, in insert_query
   return query.execute_sql(return_id)

 File ""/usr/local/lib/python2.6/site-packages/django/db/models/sql/subqueries.py"", line 320, in execute_sql
   cursor = super(InsertQuery, self).execute_sql(None)

 File ""/usr/local/lib/python2.6/site-packages/django/db/models/sql/query.py"", line 2369, in execute_sql
   cursor.execute(sql, params)

TransactionRollbackError: deadlock detected
DETAIL:  Process 40975 waits for ShareLock on transaction 172977254; blocked by process 40961.
Process 40961 waits for ShareLock on transaction 172977277; blocked by process 40975.
HINT:  See server log for query details.
CONTEXT:  SQL statement ""SELECT 1 FROM ONLY ""public"".""foo_bar"" x WHERE ""id"" OPERATOR(pg_catalog.=) $1 FOR SHARE OF x""
}}}
Example of model:
{{{
class bar(models.Model):
 baz = models.ForeignKey('some.model', related_name='sm')
 other = models.ForeignKey('some.model', related_name='so')
}}}"		closed	Uncategorized	1.1		invalid			Unreviewed	0	0	0	0	0	0