http://localhost/ticket/311 <p> Created a new package resource line and then moved it up above existing one and hit save. Result: 500 error. In logs have: </p> <pre class="wiki">[Sat May 08 21:55:41 2010] [error] [client 86.26.8.30] Error - &lt;class 'sqlalchemy.exceptions.IntegrityError'&gt;: (IntegrityError) duplicate key value violates unique constraint "package_resource_revision_pkey", referer: http://ckan.net/package/edit/cofog [Sat May 08 21:55:41 2010] [error] [client 86.26.8.30] 'INSERT INTO package_resource_revision (id, package_id, url, format, description, hash, position, state, revision_id, continuity_id) VALUES (%(id)s, %(package_id)s, %(url)s, %(format)s, %(description)s, %(hash)s, %(position)s, %(state)s, %(revision_id)s, %(continuity_id)s)' {'hash': '', 'description': 'The Treasury record of COFOG functions. ', 'format': 'XLS', 'url': 'http://www.hm-treasury.gov.uk/d/cofog_definitions_coins250609.xls', 'package_id': '8482334d-fe2e-4285-9114-5243130f80c0', 'state': 'active', 'continuity_id': '8bf302db-8a80-47d3-b5dc-bc07512a3928', 'position': 3, 'revision_id': 'e4e2cb2d-4bd5-414e-b646-e484f174d9ab', 'id': '8bf302db-8a80-47d3-b5dc-bc07512a3928'}, referer: http://ckan.net/package/edit/cofog </pre> en-us http://assets.okfn.org/p/ckan/img/ckan_logo_shortname.png http://localhost/ticket/311 Trac 0.12.3 rgrp Wed, 19 May 2010 15:14:25 GMT http://localhost/ticket/311#comment:1 http://localhost/ticket/311#comment:1 <ul> <li><strong>status</strong> changed from <em>new</em> to <em>closed</em> </li> <li><strong>resolution</strong> set to <em>fixed</em> </li> <li><strong>description</strong> modified (<a href="/ticket/311?action=diff&amp;version=1">diff</a>) </li> </ul> <p> Resolved (sort of) in cset:489007a10bb9. This was a migration issue. </p> <p> Tracked this down to fact that on ckan.net we have: </p> <blockquote> <p> "package_resource_revision_pkey" PRIMARY KEY, btree (id) </p> </blockquote> <p> When it should be: </p> <blockquote> <p> "package_resource_revision_pkey" PRIMARY KEY, btree (id, revision_id) </p> </blockquote> <p> Looking in <a class="source" href="http://localhost/browser/ckan/migration/versions/012_add_resources.py">browser:ckan/migration/versions/012_add_resources.py</a> find: </p> <pre class="wiki"> Column('revision_id', UnicodeText, ForeignKey('revision.id')), #NB revision_id should have been primary_key too (joint with id) </pre><p> How come this was not corrected here or at least noted for upgrade of ckan.net??? </p> <p> I have now fixed this so that others doing migration (at least with v1.0) will end up with correct code. </p> <p> I have also fixed issue on ckan.net by manual sql! </p> Ticket