PDA

View Full Version : Cannot Manually 'Expire' Tests



KWSN Sir CADCAM
12-03-2007, 06:56 AM
When I try to manually 'expire' some orphaned tests I get the following message:-


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

znedelchev
12-04-2007, 05:46 AM
There is a bug in the SB-PHP, but, I think, in spite of all errors (which are different, depending on the browser) , the unwanted test is expired and this can be viewed by refreshing the pending tests page

Alien88
12-06-2007, 11:03 PM
When I try to manually 'expire' some orphaned tests I get the following message:-


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


Hrm.

Does the test still show up in your list of tests? What k/n is it?

engracio
12-07-2007, 12:57 AM
Hrm.

Does the test still show up in your list of tests? What k/n is it?

If that post is to ask if it is still happening. YES, it has been happening every time I expired a wu. As posted above, most of us just assumed it is a fact of life since you guys are too busy for little things like this. I mean a couple of mouse click and you verfied that the wu is dropped.

If you back browser and refreesh the page, it would be gone. The expired wu that is.