http://localhost/ticket/935 <p> An internal server error was reported when trying to create a new package (not when editing): </p> <blockquote> <p> <a class="missing wiki">WebApp?</a> Error: &lt;class 'sqlalchemy.exceptions.<a class="missing wiki">IntegrityError?</a>'&gt;: (<a class="missing wiki">IntegrityError?</a>) null value in column "name" violates not-null constraint 'INSERT INTO package (id, name, title, version, url, author, author_email, maintainer, maintainer_email, notes, license_id, state, revision_id) VALUES (%(id)s, %(name)s, %(title)s, %(version)s, %(url)s, %(author)s, %(author_email)s, %(maintainer)s, %(maintainer_email)s, %(notes)s, %(license_id)s, %(state)s, %(revision_id)s)' {'maintainer': None, 'name': None, 'author': None, 'author_email': None, 'notes': None, 'title': None, 'maintainer_email': None, 'url': None, 'state': 'active', 'version': None, 'license_id': None, 'revision_id': '0141c09c-4eb3-4dda-a6b1-e07f2c73b4c5', 'id': '7fe16a29-f183-471a-99c5-2c2e81dd86e4'} </p> </blockquote> <p> The error could not be reproduced in a non-apache/mod_wsgi environment, even with a dump of the live database. Further investigation by manual editing of the package form left the "groups" field as the likely cause. After updating the packages installed, and temporarily editing the package controller the problem vanished after a restart of the web server. </p> <p> Possible causes include: </p> <ul><li>Stale pyc file </li><li>Threading issue </li><li>Dependency issue </li></ul><p> As the problem is gone for now, it cannot be further investigated atm. </p> en-us http://assets.okfn.org/p/ckan/img/ckan_logo_shortname.png http://localhost/ticket/935 Trac 0.12.3 pudo Mon, 30 May 2011 18:04:42 GMT http://localhost/ticket/935#comment:1 http://localhost/ticket/935#comment:1 <ul> <li><strong>repo</strong> set to <em>ckan</em> </li> <li><strong>status</strong> changed from <em>new</em> to <em>closed</em> </li> <li><strong>theme</strong> set to <em>none</em> </li> <li><strong>resolution</strong> set to <em>fixed</em> </li> </ul> Ticket