Cannot expire pending test.

[DukeBox]

When I expire pending tests i get the following error:


System error

error: DBD::mysql::db do failed: Duplicate entry '3526970' for key 1 at /usr/local/apache/htdocs/sb/account/testsPendingPost.mhtml line 21.

context: ...
17:
18: my $priority = $test_info->{priority};
19: $priority = $n unless defined($priority);
20:
21: $dbh->do("INSERT INTO queued_tests " .
22: "(k, n, queue_name, priority) " .
23: "VALUES (?, ?, ?, ?)", { },
24: $k, $n, 'dropped-tests', $priority);
25:
...

code stack: /usr/local/apache/htdocs/sb/account/testsPendingPost.mhtml:21
/usr/local/apache/htdocs/sb/account/autohandler:6
/usr/local/apache/htdocs/sb/autohandler:53
/usr/local/apache/htdocs/sb/syshandler:20

raw error:

DBD::mysql::db do failed: Duplicate entry '3526970' for key 1 at /usr/local/apache/htdocs/sb/account/testsPendingPost.mhtml line 21.


Trace begun at /usr/local/share/perl/5.8.4/HTML/Mason/Exceptions.pm line 129
HTML::Mason::Exceptions::rethrow_exception('DBD::mysql::db do failed: Duplicate entry \'3526970\' for key 1 at /usr/local/apache/htdocs/sb/account/testsPendingPost.mhtml line 21.^J') called at /usr/local/apache/htdocs/sb/account/testsPendingPost.mhtml line 21
HTML::Mason::Commands::__ANON__('n', 9307107, 'k', 67607, 'userid', 3955, 'id', 836563) called at /usr/local/share/perl/5.8.4/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x8ce9ff8)', 'n', 9307107, 'k', 67607, 'userid', 3955, 'id', 836563) called at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 1255
eval {...} at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 1249
HTML::Mason::Request::comp(undef, undef, 'n', 9307107, 'k', 67607, 'userid', 3955, 'id', 836563) called at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 916
HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x8c18414)') called at /usr/local/apache/htdocs/sb/account/autohandler line 6
HTML::Mason::Commands::__ANON__('n', 9307107, 'k', 67607, 'userid', 3955, 'id', 836563) called at /usr/local/share/perl/5.8.4/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x8cef854)', 'n', 9307107, 'k', 67607, 'userid', 3955, 'id', 836563) called at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 1250
eval {...} at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 1249
HTML::Mason::Request::comp(undef, undef, 'n', 9307107, 'k', 67607, 'userid', 3955, 'id', 836563) called at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 916
HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x8c18414)') called at /usr/local/apache/htdocs/sb/autohandler line 53
HTML::Mason::Commands::__ANON__('n', 9307107, 'k', 67607, 'userid', 3955, 'id', 836563) called at /usr/local/share/perl/5.8.4/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x86c1654)', 'n', 9307107, 'k', 67607, 'userid', 3955, 'id', 836563) called at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 1255
eval {...} at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 1249
HTML::Mason::Request::comp(undef, undef, 'n', 9307107, 'k', 67607, 'userid', 3955, 'id', 836563) called at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 916
HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x8c18414)') called at /usr/local/apache/htdocs/sb/syshandler line 20
HTML::Mason::Commands::__ANON__('n', 9307107, 'k', 67607, 'userid', 3955, 'id', 836563) called at /usr/local/share/perl/5.8.4/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x887eb80)', 'n', 9307107, 'k', 67607, 'userid', 3955, 'id', 836563) called at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 1250
eval {...} at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 1249
HTML::Mason::Request::comp(undef, undef, undef, 'n', 9307107, 'k', 67607, 'userid', 3955, 'id', 836563) called at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 461
eval {...} at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 461
eval {...} at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 413
HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x8c18414)') called at /usr/local/share/perl/5.8.4/HTML/Mason/ApacheHandler.pm line 167
HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0x8c18414)') called at /usr/local/share/perl/5.8.4/HTML/Mason/ApacheHandler.pm line 817
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x86b54c8)', 'Apache=SCALAR(0x8c09c5c)') called at (eval 31) line 8
HTML::Mason::ApacheHandler::handler('HTML::Mason::ApacheHandler', 'Apache=SCALAR(0x8c09c5c)') called at /dev/null line 0
eval {...} at /dev/null line 0

[engracio]

Dukebox,

check this thread. Expire the wu, back browser and reload/refresh browser. Wallla wu gone.

http://www.free-dc.org/forum/showthread.php?t=12731

[jasong]

Wallla wu gone.
I think you mean,"voila," possibly with a little symbol over the a which I don't know how to make with my keyboard setup.

That mistake made my day. Not that I'm calling you an idiot, it just gave me a very much needed chuckle.

[engracio]

I think you mean,"voila," possibly with a little symbol over the a which I don't know how to make with my keyboard setup.

That mistake made my day. Not that I'm calling you an idiot, it just gave me a very much needed chuckle.

:rotfl: aims to please

[fetofs]

It's a grave accent: "voilà" (laughs of the fact that his keyboard layout can produce lots of strange symbols éòüñãêç)

[Joh14vers6]

It is already, for half a year this strange behaviour (ie behavior) that we get error-reports when we expiring tests. But what Engracio wrote is true.

[Alien88]

This is now fixed.