378910 - Adding a person to a group twice (use two tabs) triggers DBD::mysql::st execute failed: Duplicate entry ... for key 1 [for Statement "INSERT INTO user_group_map

Status: VERIFIED DUPLICATE of bug 354868

(Bugzilla :: Administration, task)

Description

[timeless]

Adding a person to a group twice (use two tabs) triggers [Bugzilla  Version 2.20/10.12]:

Software error:

DBD::mysql::st execute failed: Duplicate entry '10-2-0-0' for key 1 [for Statement "INSERT INTO user_group_map (
                  user_id, group_id, isbless, grant_type
                 ) VALUES (
                  ?, ?, ?, ?
                 )
          "] at /var/www/bugzilla-2.20-10.11/editusers.cgi line 333

For help, please send mail to the webmaster (...), giving this error message and the time and date of the error.

Steps to reproduce (hacked 2.20):
1. go to edit users
2. find yourself
3. open the link to yourself in two windows
4. in one window, add yourself to something useless
5. commit
6. repeat 4-5 in the other window.

expected results include any of the following:
a. nothing to do
b. nothing to do, the change you made has already been made
c. warning user state doesn't match the state you were editing, your edits are shown below merged with the current state
d. polite complaint about midair collision

not sure which i want. I'm pretty sure (e) ugly error telling me to contact a web master is only slightly better than (d)

Yes, I like the irony involving the path and version numbers not matching. Off by one errors really are common in the real world.

Comment 1

[timeless]

I attacked mcsmurf's account w/ the whine bit, and bugzilla crashed:

DBD::mysql::st execute failed: Duplicate entry '45949-19-0-0' for key 1 [for Statement "INSERT INTO user_group_map (
                  user_id, group_id, isbless, grant_type
                 ) VALUES (
                  ?, ?, ?, ?
                 )
          "] at /opt/webtools/bugzilla/editusers.cgi line 298
	ModPerl::ROOT::Bugzilla::ModPerl::ResponseHandler::opt_webtools_bugzilla_editusers_2ecgi::handler('Apache2::RequestRec=SCALAR(0xa064ff8)') called at /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/ModPerl/RegistryCooker.pm line 203
	eval {...} called at /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/ModPerl/RegistryCooker.pm line 203
	ModPerl::RegistryCooker::run('Bugzilla::ModPerl::ResponseHandler=HASH(0xa05835c)') called at /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/ModPerl/RegistryCooker.pm line 169
	ModPerl::RegistryCooker::default_handler('Bugzilla::ModPerl::ResponseHandler=HASH(0xa05835c)') called at /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/ModPerl/Registry.pm line 30
	ModPerl::Registry::handler('Bugzilla::ModPerl::ResponseHandler', 'Apache2::RequestRec=SCALAR(0xa064ff8)') called at /opt/webtools/bugzilla/mod_perl.pl line 93
	Bugzilla::ModPerl::ResponseHandler::handler('Bugzilla::ModPerl::ResponseHandler', 'Apache2::RequestRec=SCALAR(0xa064ff8)') called at -e line 0
	eval {...} called at -e line 0