exception while trying to select watcher

open the watchers view of a task and click the "select a user" icon right of the text area.
the reason in the exception indicates a database corruption ... again.

Cause:
java.lang.RuntimeException: java.lang.RuntimeException: Found more than one user with name 'ivan.dyatlov'; ids [GenericEntity:OSUser][id,15640][name,ivan.dyatlov][passwordHash,13pbpUl3Muv9LliIgJ0TOJpsGwUNAhka0+9sDL14PA3nFvEzO1HAtd0ZiMpzeuQjv/PNCrS0VzOPn+5DXj62SQ==], [GenericEntity:OSUser][id,15641][name,ivan.dyatlov][passwordHash,null], [GenericEntity:OSUser][id,15642][name,ivan.dyatlov][passwordHash,null]

Stack Trace: [hide]

java.lang.RuntimeException: java.lang.RuntimeException: Found more than one user with name 'ivan.dyatlov'; ids [GenericEntity:OSUser][id,15640][name,ivan.dyatlov][passwordHash,13pbpUl3Muv9LliIgJ0TOJpsGwUNAhka0+9sDL14PA3nFvEzO1HAtd0ZiMpzeuQjv/PNCrS0VzOPn+5DXj62SQ==], [GenericEntity:OSUser][id,15641][name,ivan.dyatlov][passwordHash,null], [GenericEntity:OSUser][id,15642][name,ivan.dyatlov][passwordHash,null]
at com.atlassian.jira.web.action.admin.user.UserPickerBrowser.getBrowsableItems(UserPickerBrowser.java:104)
at com.atlassian.jira.web.action.admin.user.UserPickerBrowser.doExecute(UserPickerBrowser.java:54)
at webwork.action.ActionSupport.execute(ActionSupport.java:153)
at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:54)
at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:132)
at com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:178)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.jira.web.filters.AccessLogFilter.doFilter(AccessLogFilter.java:73)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119)
at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55)
at com.atlassian.jira.web.filters.SitemeshExcludePathFilter.doFilter(SitemeshExcludePathFilter.java:38)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:204)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.seraph.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:120)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.seraph.filter.BaseLoginFilter.doFilter(BaseLoginFilter.java:138)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132)
at com.atlassian.jira.web.filters.JIRAProfilingFilter.doFilter(JIRAProfilingFilter.java:16)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:43)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.jira.web.filters.RequestCleanupFilter.doFilter(RequestCleanupFilter.java:50)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:72)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:350)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:75)
at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:33)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.atlassian.jira.appconsistency.db.DatabaseCompatibilityEnforcerFilter.doFilter(DatabaseCompatibilityEnforcerFilter.java:39)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:548)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.RuntimeException: Found more than one user with name 'ivan.dyatlov'; ids [GenericEntity:OSUser][id,15640][name,ivan.dyatlov][passwordHash,13pbpUl3Muv9LliIgJ0TOJpsGwUNAhka0+9sDL14PA3nFvEzO1HAtd0ZiMpzeuQjv/PNCrS0VzOPn+5DXj62SQ==], [GenericEntity:OSUser][id,15641][name,ivan.dyatlov][passwordHash,null], [GenericEntity:OSUser][id,15642][name,ivan.dyatlov][passwordHash,null]
at com.opensymphony.user.provider.ofbiz.OFBizAbstractProvider.findUser(OFBizAbstractProvider.java:159)
at com.opensymphony.user.provider.ofbiz.OFBizCredentialsProvider.handles(OFBizCredentialsProvider.java:114)
at com.opensymphony.user.UserManager.getProvider(UserManager.java:322)
at com.opensymphony.user.UserManager$Accessor.getCredentialsProvider(UserManager.java:409)
at com.opensymphony.user.Entity.getCredentialsProvider(Entity.java:59)
at com.opensymphony.user.User.<init>(User.java:53)
at com.opensymphony.user.UserManager.buildEntity(UserManager.java:348)
at com.opensymphony.user.UserManager.getEntities(UserManager.java:299)
at com.opensymphony.user.UserManager.getUsers(UserManager.java:209)
at com.atlassian.core.user.UserUtils.getAllUsers(UserUtils.java:65)
at com.atlassian.jira.web.bean.UserPickerFilter.getFilteredUsers(UserPickerFilter.java:67)
at com.atlassian.jira.web.action.admin.user.UserPickerBrowser.getBrowsableItems(UserPickerBrowser.java:99)
... 64 more

Referer URL: http://bugreports.qt.nokia.com/secure/ManageWatchers!default.jspa?id=161284

Build Information:
Uptime : N/A
Edition : Enterprise
Version : 3.13.4.4
Build Number : 354
Atlassian Partner : null
Installation Type : unknown
Server ID : Contact your Administrator to discover this property value.

Server Information:
Application Server: Apache Tomcat/5.5.26
Servlet Version: 2.4

File Paths:
Contact your System Administrator to discover file path information.

Memory Information:
Total Memory: 1920 MB
Free Memory: 163 MB
Used Memory: 1757 MB
Total PermGen Memory: 176 MB
Free PermGen Memory: 90 MB
Used PermGen Memory: 85 MB

System Information:
System Date : Monday, 17 May 2010
System Time : 10:17:23 +0200
Current Working Directory : Contact your System Administrator to discover this property value.
Java Version : 1.6.0_16
Java Vendor : Sun Microsystems Inc.
JVM Version : 1.0
JVM Vendor : Sun Microsystems Inc.
JVM Implementation Version : 14.2-b01
Java Runtime : Java(TM) SE Runtime Environment
Java VM : Java HotSpot(TM) 64-Bit Server VM
User Name : mkeir
User Timezone : Europe/Oslo
User Locale : English (United States)
System Encoding : UTF-8
Operating System : Linux 2.6.18-164.15.1.el5xen
OS Architecture : amd64
Application Server Container :
Database type : mysql
Database JNDI address : java:comp/env/jdbc/JiraDS
Database URL : Hidden
Database version : 5.0.77-log
Database driver : MySQL-AB JDBC Driver mysql-connector-java-5.1.10 ( Revision: ${svn.Revision} )
External user management : OFF
Crowd integration : OFF
JVM Input Arguments : Contact your System Administrator to discover this property value.

Language Info:
Installed languages: Catalan (Spain)
Chinese (China)
Chinese (Taiwan)
Czech (Czech Republic)
Danish (Denmark)
Dutch (Belgium)
English (UK)
English (United States)
French (France)
German (Germany)
German (Switzerland)
Hungarian (Hungary)
Italian (Italy)
Japanese (Japan)
Norwegian (Norway)
Polish (Poland)
Portuguese (Brazil)
Russian (Russia)
Slovak (Slovakia)
Spanish (Spain)
Turkish (Turkey)
Default language: English (United States) - System Default

Request Information:

• Request URL: http://bugreports.qt.nokia.com/500page.jsp
• Scheme: http
• Server: bugreports.qt.nokia.com
• Port: 80
• URI: /500page.jsp
• Context Path:
• - Servlet Path: /500page.jsp
• - Path Info: null
• - Query String: formName=startform&multiSelect=true&element=userNames

Request Attributes

• javax.servlet.forward.request_uri : /secure/popups/UserPickerBrowser.jspa
• javax.servlet.forward.context_path :
• javax.servlet.forward.servlet_path : /secure/popups/UserPickerBrowser.jspa
• javax.servlet.forward.path_info : /500page.jsp
• javax.servlet.forward.query_string : formName=startform&multiSelect=true&element=userNames
• os_securityfilter_already_filtered : true
• atlassian.core.seraph.original.url : /secure/popups/UserPickerBrowser.jspa?formName=startform&multiSelect=true&element=userNames
• javax.servlet.error.servlet_name : action
• com.atlassian.gzipfilter.GzipFilter_already_filtered : true
• loginfilter.already.filtered : true
• com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true
• jira.webwork.generic.dispatcher : webwork.dispatcher.GenericDispatcher@51adef50
• gzipMimeTypes : text/.*,application/x-javascript,application/javascript,application/xml,application/xhtml+xml
• javax.servlet.error.message :
• webwork.result : Value stack =========== ===========
• com.atlassian.jira.web.filters.RequestCleanupFilter_already_filtered : true
• javax.servlet.error.request_uri : /secure/popups/UserPickerBrowser.jspa
• jira.webwork.cleanup : false
• javax.servlet.error.status_code : 500
• com.atlassian.jira.web.filters.ActionCleanupDelayFilter : true
• com.atlassian.gzipfilter.org.tuckey.web.filters.urlrewrite.RuleMatched : true
• _sitemesh_filterapplied : true
• javax.servlet.error.exception : javax.servlet.ServletException: java.lang.RuntimeException: Found more than one user with name 'ivan.dyatlov'; ids [GenericEntity:OSUser][id,15640][name,ivan.dyatlov][passwordHash,13pbpUl3Muv9LliIgJ0TOJpsGwUNAhka0+9sDL14PA3nFvEzO1HAtd0ZiMpzeuQjv/PNCrS0VzOPn+5DXj62SQ==], [GenericEntity:OSUser][id,15641][name,ivan.dyatlov][passwordHash,null], [GenericEntity:OSUser][id,15642][name,ivan.dyatlov][passwordHash,null]

Request Logging
0 log statements generated by this request:

Listeners

• GreenHopper Listener (com.pyxis.greenhopper.jira.customfields.GreenHopperCTFIndexer)
• Issue Cache Listener (com.atlassian.jira.event.listeners.cache.IssueCacheListener)
• Issue Index Listener (com.atlassian.jira.event.listeners.search.IssueIndexListener)
• Mail Listener (com.atlassian.jira.event.listeners.mail.MailListener)

Services

• Backup Service (com.atlassian.jira.service.services.export.ExportService)
• Delay: 240 minutes
• Mail Queue Service (com.atlassian.jira.service.services.mail.MailQueueService)
• Delay: 1 minutes

Plugins

• Admin Menu Sections 1.0 - Plugin by Atlassian Pty Ltd
• Enabled
• Browse Project Operations Sections 1.0 - Plugin by Atlassian Pty Ltd
• Enabled
• Content Link Resolvers Plugin 1.0 - Plugin by Atlassian Pty Ltd
• Enabled
• Custom Field Types & Searchers 1.0 - Plugin by Atlassian Pty Ltd
• Enabled
• GreenHopper 3.8-jira313 - Plugin by Atlassian
• Disabled
• Issue Operations Plugin 1.0 - Plugin by Atlassian Pty Ltd
• Enabled
• Issue Tab Panels Plugin 1.0 - Plugin by Atlassian Pty Ltd
• Enabled
• Issue Views Plugin 1.0 - Plugin by Atlassian Pty Ltd
• Enabled
• JIRA Calendar Plugin 1.9 - Plugin by Atlassian Pty Ltd
• Enabled
• JIRA Charting Plugin 1.4.3 - Plugin by Atlassian Pty Ltd
• Enabled
• JIRA Footer 1.0 - Plugin by Atlassian Pty Ltd
• Enabled
• JIRA Labels Plugin 2.2.2 - Plugin by Atlassian Pty Ltd
• Enabled
• JIRA Suite Utilities 0.6.7 - Plugin by Quadratica SRL
• Enabled
• Jira SU 1.2 - Plugin by Andy Brook
• Enabled
• Portlets Plugin 1.0 - Plugin by Atlassian Pty Ltd
• Enabled
• Preset Filters Sections 1.0 - Plugin by Atlassian Pty Ltd
• Enabled
• Project Panels Plugin 1.0 - Plugin by Atlassian Pty Ltd
• Enabled
• Project Role Actors Plugin 1.0 - Plugin by Atlassian Pty Ltd
• Enabled
• RPC JIRA Plugin 3.13.1 - Plugin by Atlassian Software Systems Pty Ltd
• Enabled
• Renderer Component Factories Plugin 1.0 - Plugin by Atlassian Pty Ltd
• Enabled
• Renderer Plugin 1.0 - Plugin by Atlassian Pty Ltd
• Enabled
• Reports Plugin 1.0 - Plugin by Atlassian Pty Ltd
• Enabled
• Timecharts Plugin 3.13 - Plugin by Consulting Toolsmiths
• Enabled
• Top Navigation Bar 1.0 - Plugin by Atlassian Pty Ltd
• Enabled
• User Format 1.0 - Plugin by Atlassian Pty Ltd
• Enabled
• User Navigation Bar Sections 1.0 - Plugin by Atlassian Pty Ltd
• Enabled
• User Profile Links 1.0 - Plugin by Atlassian Pty Ltd
• Enabled
• View Project Operations Sections 1.0 - Plugin by Atlassian Pty Ltd
• Enabled
• Web Resources Plugin 1.0 - Plugin by Atlassian Pty Ltd
• Enabled
• Webwork Plugin 1.0 - Plugin by Atlassian Pty Ltd
• Enabled
• Wiki Renderer Macros Plugin 1.0 - Plugin by Atlassian Pty Ltd
• Enabled
• Workflow Plugin 1.0 - Plugin by Atlassian Pty Ltd
• Enabled