id	summary	reporter	owner	description	type	status	priority	milestone	component	resolution	keywords	cc	parents
1017	"Key (activity)=(n) is not present in table ""core__activity_intermediators""."	ayleph		"Running from current git master https://gitorious.org/mediagoblin/mediagoblin/commit/c5f258fec07b9791b35d52298dd71954de81ef20, I get an error when a user uploads media. The file is uploaded, but the user gets a SERVER ERROR page, and I get entries in my logfile.

Here's one such example.

{{{
IntegrityError: (IntegrityError) insert or update on table ""core__media_entries"" violates foreign key constraint ""core__media_entries_activity_fkey""
DETAIL:  Key (activity)=(1025) is not present in table ""core__activity_intermediators"".
 'UPDATE core__media_entries SET activity=%(activity)s WHERE core__media_entries.id = %(core__media_entries_id)s' {'core__media_entries_id': 1278, 'activity': 1025}
}}}

If I query the db directly, I see that activity 1025 indeed does not exist.

{{{
mediagoblin=# select * from core__activity_intermediators where id > 1010;
  id  |    type
------+------------
 1011 | media
 1012 | media
 1013 | media
 1014 | media
 1015 | media
 1016 | media
 1017 | media
 1018 | media
 1019 | media
 1020 | media
(10 rows)
}}}

And if I examine the media entry that was created, I see that its activity id is 1020 (the last id number in the activity intermediators table), not 1025.

{{{
mediagoblin=# select * from core__media_entries where id = 1278;
  id  | uploader | title |    slug    |          created           | description |          media_type           |   state   |                   license                   | file_size | fail_error | fail_metadata | transcoding_pr
ogress | queued_media_file |            queued_task_id            | media_metadata | activity | location
------+----------+-------+------------+----------------------------+-------------+-------------------------------+-----------+---------------------------------------------+-----------+------------+---------------+---------------
-------+-------------------+--------------------------------------+----------------+----------+----------
 1278 |        3 |       | tucker12-2 | 2014-10-28 21:13:19.904526 |             | mediagoblin.media_types.image | processed | http://creativecommons.org/licenses/by/3.0/ |         0 |            |               |
       |                   | 3cb0017d-5539-4e78-9b7a-25a4a2e3dce7 | {}             |     1020 |
(1 row)
}}}

Perhaps this is related to #984?"	defect	closed	major		programming	fixed	activity,db,models,foreignkey