Here is the output from those commands:
select state,expt_locked,canceled,idx from experiments where pid='emulab-ops' and eid='machine';
+------------+---------------------+----------+-----+
| state | expt_locked | canceled | idx |
+------------+---------------------+----------+-----+
| activating | 2009-07-07 15:27:41 | 2 | 28 |
+------------+---------------------+----------+-----+
1 row in set (0.00 sec)
mysql> select rsrcidx,lastrsrc from experiment_stats where exptidx='28';
+---------+----------+
| rsrcidx | lastrsrc |
+---------+----------+
| 44 | 43 |
+---------+----------+
1 row in set (0.00
sec)
Regards,
T Ficarra
--- On Wed, 7/8/09, Leigh Stoller <stoller@flux.utah.edu> wrote:
From: Leigh Stoller <stoller@flux.utah.edu>
Subject: Re: Deleting an Experiment
To: "Timothy Ficarra" <t.ficarra@yahoo.com>
Cc: "tbops Operations" <testbed-ops@flux.utah.edu>
Date: Wednesday, July 8, 2009, 10:45 AM
> On my testbed I have an experiment which has become stuck. It cannot
> be terminated, it cannot be cancelled, and it has been of status
> 'activating' for the past 16 hours. Fortunately, it is not utilizing
> any node PCs. Regardless, is there a way to manually delete,
> terminate, or remove an experiment in this state? Or possibly to
> reset the cancel flags so that the test can be terminated through
> the
web interface?
Anyway, in mysql please do this and send it to us.
mysql> select state,expt_locked,canceled,exptidx from experiments
mysql> where pid='yourpid' and eid='youreid';
mysql> select rsrcidx,lastrsrc from experiments_stats
mysql> where exptidx='exptidx from above query';
Lbs
|