id,summary,reporter,owner,description,type,status,priority,component,severity,resolution,keywords,cc,release 9079,PostgreSQL: Database error when creating new user with attributes,Oliver Metz,Steffen Hoffmann,"Hi. We are running trac-0.12.3 with postgres db. Since one of the last updates of account manager plugin users cause this error message when creating a new account: {{{ 2011-08-10 08:33:05,339 Trac[api] INFO: Created new user: foobar 2011-08-10 08:33:05,370 Trac[main] ERROR: Internal Server Error:. Traceback (most recent call last): File ""/usr/local/lib/python2.6/dist-packages/Trac-0.12.3dev_r10719-py2.6.egg/trac/web/main.py"", line 522, in _dispatch_request dispatcher.dispatch(req) File ""/usr/local/lib/python2.6/dist-packages/Trac-0.12.3dev_r10719-py2.6.egg/trac/web/main.py"", line 243, in dispatch resp = chosen_handler.process_request(req) File ""build/bdist.linux-i686/egg/acct_mgr/web_ui.py"", line 439, in process_request _create_user(req, self.env) File ""build/bdist.linux-i686/egg/acct_mgr/web_ui.py"", line 154, in _create_user set_user_attribute(env, username, attribute, value) File ""build/bdist.linux-i686/egg/acct_mgr/api.py"", line 581, in set_user_attribute """""", (username, attribute, value)) File ""/usr/local/lib/python2.6/dist-packages/Trac-0.12.3dev_r10719-py2.6.egg/trac/db/util.py"", line 65, in execute return self.cursor.execute(sql_escape_percent(sql), args) IntegrityError: insert or update on table ""session_attribute"" violates foreign key constraint ""fk_session_sid"" DETAIL: Key (sid)=(foobar) is not present in table ""session"". IntegrityError: insert or update on table ""session_attribute"" violates foreign key constraint ""fk_session_sid"" DETAIL: Key (sid)=(foobar) is not present in table ""session"". }}} This happens only when one of the additional fields (name, email) is filled out. Otherwise everything ist fine. Despite the error message the user is created. Do you have an idea what is going on here? Regards[[BR]] Oliver p.s. Thank you for your great work on this plugin.",defect,closed,normal,AccountManagerPlugin,normal,fixed,database PostgreSQL IntegrityError,,0.12