Closed Bug 1283183 Opened 9 years ago Closed 7 years ago

Push connector backlog duplicate unique key

Categories

(bugzilla.mozilla.org :: Extensions, defect, P2)

Production
defect

Tracking

()

RESOLVED WORKSFORME

People

(Reporter: dylan, Unassigned)

Details

User Story

DBD::mysql::db do failed: Duplicate entry '6047-Aha' for key 'push_backlog_idx' [for Statement "INSERT INTO push_backlog (message_id, attempt_ts, push_ts, attempts, last_error, routing_key, payload, connector, change_set) VALUES (?,?,?,?,?,?,?,?,?)"] at /data/www/bugzilla.mozilla.org/extensions/Push/bin/../../../Bugzilla/Object.pm line 764.
 at /data/www/bugzilla.mozilla.org/extensions/Push/bin/../../../Bugzilla/Object.pm line 764.
	Bugzilla::Object::insert_create_data("Bugzilla::Extension::Push::BacklogMessage", HASH(0x3904c78)) called at /data/www/bugzilla.mozilla.org/extensions/Push/bin/../../../Bugzilla/Object.pm line 674
	Bugzilla::Object::create("Bugzilla::Extension::Push::BacklogMessage", HASH(0x6f610e0)) called at /loader/0x5b4aad8/Bugzilla/Extension/Push/BacklogMessage.pm line 63
	Bugzilla::Extension::Push::BacklogMessage::create_from_message("Bugzilla::Extension::Push::BacklogMessage", Bugzilla::Extension::Push::Message=HASH(0x6f6c578), Bugzilla::Extension::Push::Connector::Aha=HASH(0x703f7a0)) called at /loader/0x5b4aad8/Bugzilla/Extension/Push/Push.pm line 110
	Bugzilla::Extension::Push::Push::push(Bugzilla::Extension::Push::Push=HASH(0x6995248)) called at /loader/0x5b4aad8/Bugzilla/Extension/Push/Push.pm line 54
	Bugzilla::Extension::Push::Push::start(Bugzilla::Extension::Push::Push=HASH(0x6995248)) called at /loader/0x5b4aad8/Bugzilla/Extension/Push/Daemon.pm line 93
	Bugzilla::Extension::Push::Daemon::gd_run(Bugzilla::Extension::Push::Daemon=HASH(0x253bd48)) called at /usr/share/perl5/vendor_perl/Daemon/Generic.pm line 190
	Daemon::Generic::new("Bugzilla::Extension::Push::Daemon") called at /usr/share/perl5/vendor_perl/Daemon/Generic.pm line 38
	Daemon::Generic::newdaemon() called at /loader/0x5b4aad8/Bugzilla/Extension/Push/Daemon.pm line 22
	Bugzilla::Extension::Push::Daemon::start("Bugzilla::Extension::Push::Daemon") called at /data/www/bugzilla.mozilla.org/extensions/Push/bin/bugzilla-pushd.pl line 24
Under some circumstances the push connector backlog get a duplicate key error which kills the process. Error message in user_story. I bet we can simulate this error by having a push connector that emits a transient error every time.
Version: Development/Staging → Production
Seems like this went away, and the above testing procedure has basically already happened.
Status: NEW → RESOLVED
Closed: 7 years ago
Resolution: --- → WORKSFORME
Component: Extensions: Push → Extensions
You need to log in before you can comment on or make changes to this bug.