exposure got stuck in registration

[bills]

exp_id 310765 never finished registration but no entry in rawExp got inserted into the database.

We looked into this and apparently the registration faulted. See below.

However newExp.state got set to 'stop' so the exposure was stuck.
Changing the state to 'run' allowed the exposure to complete.

Starting script /home/panstarrs/ipp/psconfigipp-20110218.lin64/bin/register_exp.pl on ipp030 at Tue Mar 15 15:27:20 HST 2011

exp_id S64 310765
tmp_exp_name STR o5635g0509o
tmp_camera STR gpc1
tmp_telescope STR ps1
state STR run
workdir STR neb://@HOST@.0/gpc1/20110315
workdir_state STR dirty
reduction STR NULL
dvodb STR NULL
tess_id STR NULL
end_stage STR reg
label STR NULL
camera STR GPC1
filter STR i.00000
obs_mode STR 3PI
obs_group STR NULL
epoch TAI 2011-03-15T07:31:23.000000
dateobs TAI 2011-03-15T12:40:17.000000
* stderr *
Unable to stat Nebulous handle neb://any/gpc1/20110315/o5635g0509o.310765/o5635g0509o.310765.reg.log at /home/panstarrs/ipp/psconfigipp-20110218.lin64/bin/register_exp.pl line 56
cannot resolve neb://any/gpc1/20110315/o5635g0509o.310765/o5635g0509o.310765.reg.log at /home/panstarrs/ipp/psconfigipp-20110218.lin64/bin/register_exp.pl line 56
Unable to redirect output at /home/panstarrs/ipp/psconfigipp-20110218.lin64/bin/register_exp.pl line 347

main::my_die('Unable to redirect output', 310765, 2) called at /home/panstarrs/ipp/psconfigipp-20110218.lin64/bin/register_exp.pl line 56

system failure for: register_exp.pl --exp_id 310765 --exp_tag o5635g0509o.310765 --logfile neb://any/gpc1/20110315/o5635g0509o.310765/o5635g0509o.310765.reg.log --dbname gpc1 --verbose
job exit status: 2
job host: ipp030
job dtime: 180.85355
job exit date: Tue Mar 15 15:30:22 2011
* stdout *
* stderr *

[bills]

There are other exposures in this state
mysql> select exp_id, tmp_exp_name from newExp left join rawExp using(exp_id) where rawExp.state is null and tmp_exp_name like 'o5%o' order by exp_id desc ;
+--------+--------------+
| exp_id | tmp_exp_name |
+--------+--------------+
| 311754 | o5636g0745o |
| 311753 | o5636g0744o |
| 311752 | o5636g0743o |
| 311751 | o5636g0741o |
| 311750 | o5636g0740o |
| 311749 | o5636g0742o |
| 311748 | o5636g0738o |
| 311747 | o5636g0739o |
| 311746 | o5636g0737o |
| 311745 | o5636g0736o |
| 311744 | o5636g0735o |
| 311743 | o5636g0734o |
| 311742 | o5636g0732o |
| 311741 | o5636g0733o |
| 311740 | o5636g0731o |
| 311739 | o5636g0729o |
| 311738 | o5636g0730o |
| 311737 | o5636g0727o |
| 311736 | o5636g0728o |
| 311735 | o5636g0726o |
| 311734 | o5636g0725o |
| 311733 | o5636g0724o |
| 311732 | o5636g0723o |
| 311731 | o5636g0722o |
| 311730 | o5636g0721o |
| 311729 | o5636g0720o |
| 311728 | o5636g0719o |
| 311727 | o5636g0718o |
| 311726 | o5636g0716o |
| 311725 | o5636g0717o |
| 311724 | o5636g0714o |
| 311723 | o5636g0715o |
| 311722 | o5636g0712o |
| 311721 | o5636g0713o |
| 311720 | o5636g0710o |
| 311719 | o5636g0711o |
| 311718 | o5636g0709o |
| 311717 | o5636g0708o |
| 311716 | o5636g0707o |
| 311715 | o5636g0706o |
| 311714 | o5636g0704o |
| 311713 | o5636g0705o |
| 311712 | o5636g0702o |
| 311711 | o5636g0703o |
| 311710 | o5636g0700o |
| 311709 | o5636g0701o |
| 311708 | o5636g0699o |
| 311707 | o5636g0698o |
| 311706 | o5636g0697o |
| 311705 | o5636g0696o |
| 311704 | o5636g0694o |
| 311703 | o5636g0693o |
| 311702 | o5636g0695o |
| 311701 | o5636g0692o |
| 311700 | o5636g0691o |
| 311699 | o5636g0690o |
| 311698 | o5636g0688o |
| 311697 | o5636g0689o |
| 311696 | o5636g0687o |
| 311695 | o5636g0686o |
| 311694 | o5636g0685o |
| 311693 | o5636g0684o |
| 311692 | o5636g0682o |
| 311691 | o5636g0683o |
| 311690 | o5636g0680o |
| 311689 | o5636g0681o |
| 311688 | o5636g0679o |
| 311687 | o5636g0678o |
| 311686 | o5636g0677o |
| 311685 | o5636g0675o |
| 311684 | o5636g0676o |
| 311683 | o5636g0674o |
| 311682 | o5636g0673o |
| 311681 | o5636g0672o |
| 311680 | o5636g0671o |
| 311679 | o5636g0669o |
| 311678 | o5636g0670o |
| 311677 | o5636g0667o |
| 311676 | o5636g0668o |
| 90893 | o5071g0020o |
+--------+--------------+
80 rows in set (0.62 sec)

[bills]

The query in the last change to this ticket was wrong. Except for the last one these are just exposures that hadn't finished registration yet.