Auto-registration and database session issue

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

Auto-registration and database session issue

Durdevic, Marija

Dear all,


I am using LDAP authentication and auto registration options.  LDAP authentication passed successfully, but I got error message during auto-registration process:



  File "/home/galaxy/galaxy/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/", line 450, in do_execute

    cursor.execute(statement, parameters)

sqlalchemy.exc.IntegrityError: (psycopg2.IntegrityError) duplicate key value violates unique constraint "ix_role_name"

DETAIL:  Key (name)=([hidden email]) already exists.

[SQL: 'INSERT INTO role (create_time, update_time, name, description, type, deleted) VALUES (%(create_time)s, %(update_time)s, %(name)s, %(description)s, %(type)s, %(deleted)s) RETURNING'] [parameters: {'update_time': datetime.datetime(2016, 6, 6, 12, 43, 29, 93304), 'description': u'Private Role for [hidden email]', 'deleted': False, 'create_time': datetime.datetime(2016, 6, 6, 12, 43, 29, 93290), 'type': 'private', 'name': u'[hidden email]'}]

[pid: 22823|app: 0|req: 2/2] () {54 vars in 1129 bytes} [Mon Jun  6 14:43:29 2016] POST /user/login?use_panels=False => generated 0 bytes in 74 msecs (HTTP/1.1 500) 1 headers in 63 bytes (0 switches on core 1)



After that, user appear in database and I am able to login. Anyhow, I would like to solve this issue and to register without errors.


I tried to debug Galaxy code…  It looks like that problem is somewhere with sessions…








create_private_user_role( self, user )


In this line:



Anny suggestion what can be wrong?


Thanks in advance,




Mag. Marija Đurđević

Core Facility Computational Bioanalytics


Medical University of Graz

Center for Medical Research

Stiftingtalstraße 24, A-8010 Graz



Phone: +43 316/385-73024

Fax:+43 316/385-73009


Email: [hidden email]

Email: [hidden email]




Please keep all replies on the list by using "reply all"
in your mail client.  To manage your subscriptions to this
and other Galaxy lists, please use the interface at:

To search Galaxy mailing lists use the unified search at: