Details
-
Bug
-
Resolution: Timed out
-
Low
-
None
-
5.9.1-OD-2015.43.0-0328, 6.1.0
-
Location: https://pug.jira-dev.com/wiki/users/viewfollow.action?username=phnguyen
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.101 Safari/537.36
Referrer: https://pug.jira-dev.com/wiki/users/viewmyprofile.action
Screen Resolution: 1440 x 900
User Name: phnguyen
Current Dark Features: confluence.flashboard,confluence-inline-comments-rich-editor,shared-drafts.SSH,synchrony.~DMA,shared-drafts.~ETOM,rotp.admin.shortcuts,synchrony.CBT,synchrony.CONFENT,com.atlassian.growth.shakuni.sysadmin.enabled,notifications.rolemedium.hipchat.TASK_UPDATE_NOTIFICATION,jquery.external,shared-drafts.~PSEMENIUK,file-annotations,shared-drafts.CBT,confluence.efi.onboarding.rich.space.content,notifications.rolemedium.hipchat.SPACE_BLOGS,simple.dashboard.enabled,com.atlassian.growth.aes.only_primary,synchrony.CP,image-effects.microservice.enable,shared-drafts.~HNGUYEN,shared-drafts.~JSODERSTROM,synchrony.~HNGUYEN,synchrony.~JKLEYNHANS,shared-drafts.KM,confluence-table-enhancements.copy-cut-paste-cols,synchrony.SSH,heatmapper,notification.plugin.api.enabled.com.atlassian.confluence.plugins.files.notifications.event.FileContentMentionUpdateEvent,synchrony.CONFSIM,quick-reload-inline-comments-flags,cql.search.screen,synchrony.~ETOM,notifications.rolemedium.hipchat.SPACE_ALL,nps.survey.inline.dialog,onboarding-plugin-features,com.atlassian.growth.shakuni.force_inject_on_no_experiment,shared-drafts.GAL,pdf-preview,previews.versions,shared-drafts.PM,hipchat.chatbar,synchrony.VD,synchrony.~MERICKSON,content.rank,synchrony.GAL,notification.plugin.api.enabled.com.atlassian.confluence.plugins.inlinecomments.events.InlineCommentResolveEvent,notification.plugin.api.enabled.rest.static,notifications.medium.hipchat,notifications.rolemedium.hipchat.SINGLE_PAGE,shared-drafts.CONFENT,synchrony.WD,notifications.rolemedium.hipchat.NEW_FOLLOWER_NOTIFICATION,early.header.flush,confluence.view.edit.transition,shared-drafts.VD,synchrony.~JSODERSTROM,connect-page-history,notification.plugin.api.enabled.admin.settings.page,restrictions.new.dialog,synchrony.PM,federated.search,hipchat-emoticons,notifications.rolemedium.hipchat.SITE_BLOGS,shared-drafts.CONFSIM,synchrony.~PSEMENIUK,shared-drafts.~JKLEYNHANS,shared-drafts.WD,shared-drafts.~MERICKSON,confluence.table.resizable,notification.batch,non.polling.index.flush,rotp.project.shortcuts,confluence-questions,api.viewpage.link,clc.quick.create,confluence-table-enhancements.sticky-headers,confluence-table-enhancements.auto-row,confluence.efi.onboarding.new.templates,synchrony.WTS,shared-drafts.CP,quick-reload-inline-comments,notifications.rolemedium.hipchat.SHARE_PAGE,notifications.rolemedium.hipchat.com.atlassian.confluence.plugins.mentions,shared-drafts.~XTAIXE,atlassian.darkfeature.confluence.bigpipe.configuration.enable,searchv3,notification.plugin.api.enabled.com.atlassian.confluence.plugins.files.notifications.event.FileContentUpdateEvent,notification.plugin.api.enabled.com.atlassian.confluence.plugins.files.notifications.event.FileContentRemoveEvent,shared-drafts.WTS,atlassian.aui.raphael.disabled,previews.conversion-service,editor.ajax.save,shared-drafts.~DMA,synchrony.KM,notification.plugin.api.enabled.com.atlassian.confluence.plugins.inlinecomments.events.InlineCommentCreateEvent,synchrony.EDITOR,notifications.medium.hipchat.system_user,previews.sharing.pushstate,email-tracking,file-notifications,notifications.rolemedium.hipchat.NETWORK,shared-drafts.EDITOR,ondemand.marketplace.prototype,file-annotations.likes,synchrony.~XTAIXE,confluence-monitoring.ignore.ondemand.check,notification.plugin.api.enabled.com.atlassian.confluence.plugins.sharepage.api.ShareAttachmentEvent,notifications.rolemedium.hipchat.LIKE_NOTIFICATION,confluence-inline-comments-resolved,notification.plugin.api.enabled.com.atlassian.confluence.plugins.sharepage.api.ShareContentEvent,notification.plugin.api.enabled.com.atlassian.confluence.plugins.mentions.api.ConfluenceMentionEvent,notification.plugin.api.enabled.com.atlassian.confluence.event.events.security.ForgotPasswordEvent,notification.plugin.api.enabled.com.atlassian.confluence.plugins.tasklist.event.SendTaskEmailEvent,unified.usermanagement,notification.plugin.api.enabled.com.atlassian.confluence.event.events.content.comment.CommentCreateEvent,notification.plugin.api.enabled.com.atlassian.confluence.event.events.follow.FollowEvent,confluence.baseurl.cdn.enabled,notification.plugin.api.enabled.com.atlassian.confluence.event.events.content.blogpost.BlogPostCreateEvent,notification.plugin.api.enabled.com.atlassian.confluence.event.events.content.blogpost.BlogPostUpdateEvent,confluence.non.polling.index.flush,notification.plugin.api.enabled.com.atlassian.confluence.event.events.content.page.async.PageCreatedEvent,baseurl.cdn.enabled,notification.plugin.api.enabled.com.atlassian.confluence.plugins.hipchat.api.events.HipChatUserMapped,notification.plugin.api.enabled.com.atlassian.confluence.event.events.content.blogpost.BlogPostMovedEvent,notification.plugin.api.enabled.com.atlassian.confluence.event.events.content.page.async.PageMovedEvent,previews.sharing,notification.plugin.api.enabled.com.atlassian.confluence.event.events.content.attachment.AttachmentBatchUploadCompletedEvent,notification.plugin.api.enabled.com.atlassian.confluence.efi.emails.events.OnboardingLessUsersEvent,confluence.wrap.macro,notification.plugin.api.enabled.com.atlassian.confluence.event.events.content.comment.CommentUpdateEvent,app-switcher.new,notification.plugin.api.enabled.com.atlassian.confluence.event.events.content.page.async.PageEditedEvent,previews.trigger-all-file-types,notification.plugin.api.enabled.com.atlassian.confluence.event.events.like.LikeCreatedEvent,fusion.bitbucket.rebrand,notification.plugin.api.enabled.com.atlassian.confluence.efi.emails.events.OnboardingNoSpaceCreatedEvent,confluence-inline-comments,confluence-inline-comments-dangling-comment
SpaceTheme: theme-default profile aui-layout aui-theme-default
VersionNumber: 5.9.1-OD-2015.43.0-0328Location : https://pug.jira-dev.com/wiki/users/viewfollow.action?username=phnguyen User-Agent : Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.101 Safari/537.36 Referrer : https://pug.jira-dev.com/wiki/users/viewmyprofile.action Screen Resolution : 1440 x 900 User Name : phnguyen Current Dark Features : confluence.flashboard,confluence-inline-comments-rich-editor,shared-drafts.SSH,synchrony.~DMA,shared-drafts.~ETOM,rotp.admin.shortcuts,synchrony.CBT,synchrony.CONFENT,com.atlassian.growth.shakuni.sysadmin.enabled,notifications.rolemedium.hipchat.TASK_UPDATE_NOTIFICATION,jquery.external,shared-drafts.~PSEMENIUK,file-annotations,shared-drafts.CBT,confluence.efi.onboarding.rich.space.content,notifications.rolemedium.hipchat.SPACE_BLOGS,simple.dashboard.enabled,com.atlassian.growth.aes.only_primary,synchrony.CP,image-effects.microservice.enable,shared-drafts.~HNGUYEN,shared-drafts.~JSODERSTROM,synchrony.~HNGUYEN,synchrony.~JKLEYNHANS,shared-drafts.KM,confluence-table-enhancements.copy-cut-paste-cols,synchrony.SSH,heatmapper,notification.plugin.api.enabled.com.atlassian.confluence.plugins.files.notifications.event.FileContentMentionUpdateEvent,synchrony.CONFSIM,quick-reload-inline-comments-flags,cql.search.screen,synchrony.~ETOM,notifications.rolemedium.hipchat.SPACE_ALL,nps.survey.inline.dialog,onboarding-plugin-features,com.atlassian.growth.shakuni.force_inject_on_no_experiment,shared-drafts.GAL,pdf-preview,previews.versions,shared-drafts.PM,hipchat.chatbar,synchrony.VD,synchrony.~MERICKSON,content.rank,synchrony.GAL,notification.plugin.api.enabled.com.atlassian.confluence.plugins.inlinecomments.events.InlineCommentResolveEvent,notification.plugin.api.enabled.rest.static,notifications.medium.hipchat,notifications.rolemedium.hipchat.SINGLE_PAGE,shared-drafts.CONFENT,synchrony.WD,notifications.rolemedium.hipchat.NEW_FOLLOWER_NOTIFICATION,early.header.flush,confluence.view.edit.transition,shared-drafts.VD,synchrony.~JSODERSTROM,connect-page-history,notification.plugin.api.enabled.admin.settings.page,restrictions.new.dialog,synchrony.PM,federated.search,hipchat-emoticons,notifications.rolemedium.hipchat.SITE_BLOGS,shared-drafts.CONFSIM,synchrony.~PSEMENIUK,shared-drafts.~JKLEYNHANS,shared-drafts.WD,shared-drafts.~MERICKSON,confluence.table.resizable,notification.batch,non.polling.index.flush,rotp.project.shortcuts,confluence-questions,api.viewpage.link,clc.quick.create,confluence-table-enhancements.sticky-headers,confluence-table-enhancements.auto-row,confluence.efi.onboarding.new.templates,synchrony.WTS,shared-drafts.CP,quick-reload-inline-comments,notifications.rolemedium.hipchat.SHARE_PAGE,notifications.rolemedium.hipchat.com.atlassian.confluence.plugins.mentions,shared-drafts.~XTAIXE,atlassian.darkfeature.confluence.bigpipe.configuration.enable,searchv3,notification.plugin.api.enabled.com.atlassian.confluence.plugins.files.notifications.event.FileContentUpdateEvent,notification.plugin.api.enabled.com.atlassian.confluence.plugins.files.notifications.event.FileContentRemoveEvent,shared-drafts.WTS,atlassian.aui.raphael.disabled,previews.conversion-service,editor.ajax.save,shared-drafts.~DMA,synchrony.KM,notification.plugin.api.enabled.com.atlassian.confluence.plugins.inlinecomments.events.InlineCommentCreateEvent,synchrony.EDITOR,notifications.medium.hipchat.system_user,previews.sharing.pushstate,email-tracking,file-notifications,notifications.rolemedium.hipchat.NETWORK,shared-drafts.EDITOR,ondemand.marketplace.prototype,file-annotations.likes,synchrony.~XTAIXE,confluence-monitoring.ignore.ondemand.check,notification.plugin.api.enabled.com.atlassian.confluence.plugins.sharepage.api.ShareAttachmentEvent,notifications.rolemedium.hipchat.LIKE_NOTIFICATION,confluence-inline-comments-resolved,notification.plugin.api.enabled.com.atlassian.confluence.plugins.sharepage.api.ShareContentEvent,notification.plugin.api.enabled.com.atlassian.confluence.plugins.mentions.api.ConfluenceMentionEvent,notification.plugin.api.enabled.com.atlassian.confluence.event.events.security.ForgotPasswordEvent,notification.plugin.api.enabled.com.atlassian.confluence.plugins.tasklist.event.SendTaskEmailEvent,unified.usermanagement,notification.plugin.api.enabled.com.atlassian.confluence.event.events.content.comment.CommentCreateEvent,notification.plugin.api.enabled.com.atlassian.confluence.event.events.follow.FollowEvent,confluence.baseurl.cdn.enabled,notification.plugin.api.enabled.com.atlassian.confluence.event.events.content.blogpost.BlogPostCreateEvent,notification.plugin.api.enabled.com.atlassian.confluence.event.events.content.blogpost.BlogPostUpdateEvent,confluence.non.polling.index.flush,notification.plugin.api.enabled.com.atlassian.confluence.event.events.content.page.async.PageCreatedEvent,baseurl.cdn.enabled,notification.plugin.api.enabled.com.atlassian.confluence.plugins.hipchat.api.events.HipChatUserMapped,notification.plugin.api.enabled.com.atlassian.confluence.event.events.content.blogpost.BlogPostMovedEvent,notification.plugin.api.enabled.com.atlassian.confluence.event.events.content.page.async.PageMovedEvent,previews.sharing,notification.plugin.api.enabled.com.atlassian.confluence.event.events.content.attachment.AttachmentBatchUploadCompletedEvent,notification.plugin.api.enabled.com.atlassian.confluence.efi.emails.events.OnboardingLessUsersEvent,confluence.wrap.macro,notification.plugin.api.enabled.com.atlassian.confluence.event.events.content.comment.CommentUpdateEvent,app-switcher.new,notification.plugin.api.enabled.com.atlassian.confluence.event.events.content.page.async.PageEditedEvent,previews.trigger-all-file-types,notification.plugin.api.enabled.com.atlassian.confluence.event.events.like.LikeCreatedEvent,fusion.bitbucket.rebrand,notification.plugin.api.enabled.com.atlassian.confluence.efi.emails.events.OnboardingNoSpaceCreatedEvent,confluence-inline-comments,confluence-inline-comments-dangling-comment SpaceTheme : theme-default profile aui-layout aui-theme-default VersionNumber : 5.9.1-OD-2015.43.0-0328
-
2
-
Severity 3 - Minor
-
Description
NOTE: This bug report is for Confluence Server. Using Confluence Cloud? See the corresponding bug report.
Summary
Clicking twice on Save on user creation creates two entries in the user table.
Steps to Reproduce
- Go to Configuration > User Management
- Go to Add Users
- Enter the details for a new user
- Click save twice really quickly
- Go to List Users
- Search for the user
2017-04-01 16:34:02,975 ERROR [http-nio-8090-exec-8] [atlassian.confluence.servlet.ConfluenceServletDispatcher] sendError Could not execute action
-- referer: http://localhost:8090/admin/users/createuser.action | url: /admin/users/docreateuser.action | traceId: 4eaa8a47918f56e4 | userName: admin
org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [cwd_user_name_dir_id]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement
at org.springframework.orm.hibernate5.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:241)
Workaround
As always, please backup your database first before making these changes.
There are 3 tables we need to remove the user from, in order
- cwd_membership
- cwd_user_attribute
- cwd_user
Confirm the user has not created any content yet. Run this SQL to confirm no data is in the content table.
select c.user_name, u.user_key, co.contenttype, co.title from cwd_user c join user_mapping u on c.user_name = u.username join content co on u.user_key = co.creator or u.user_key = co.username where co.contenttype <> 'USERINFO' and c.user_name = '<USERNAME>';
Then we can delete the user with these three commands
delete from cwd_membership where child_user_id = (select id from cwd_user where lower_user_name = '<USERNAME>'); delete from cwd_user_attribute where user_id = (select id from cwd_user where lower_user_name = '<USERNAME>'); delete from cwd_user where lower_user_name = '<USERNAME>';
Attachments
Issue Links
- relates to
-
CONFCLOUD-39569 Duplicate following user
- Closed
- mentioned in
-
Page Loading...