| | 758 | ------------------------ |
| | 759 | |
| | 760 | Gene had some pstamp jobs stuck. Running the usual query: |
| | 761 | {{{ |
| | 762 | pstamptool -dbname ippRequestServer -dbserver ipp113 -pendingdependent -simple |
| | 763 | }}} |
| | 764 | shows a bunch of jobs: |
| | 765 | {{{ |
| | 766 | 10977292 new chip 1131144 XY71 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977292.log 320 |
| | 767 | 10977293 new chip 1131146 XY16 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977293.log 320 |
| | 768 | 10977294 new chip 1131208 XY71 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977294.log 320 |
| | 769 | 10977295 new chip 1131210 XY16 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977295.log 320 |
| | 770 | 10977296 new chip 1130544 XY71 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977296.log 320 |
| | 771 | 10977297 new chip 1130549 XY71 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977297.log 320 |
| | 772 | 10977298 new chip 1130551 XY16 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977298.log 320 |
| | 773 | 10977299 new chip 1130546 XY16 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977299.log 320 |
| | 774 | 10977304 new chip 1130556 XY61 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977304.log 320 |
| | 775 | 10977305 new chip 1130560 XY61 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977305.log 320 |
| | 776 | 10977312 new chip 1131230 XY12 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977312.log 320 |
| | 777 | 10977313 new chip 1200205 XY12 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977313.log 320 |
| | 778 | 10977314 new chip 1131246 XY12 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977314.log 320 |
| | 779 | 10977315 new chip 1131251 XY12 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977315.log 320 |
| | 780 | 10977318 new chip 1130562 XY10 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977318.log 320 |
| | 781 | 10977319 new chip 1130564 XY10 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977319.log 320 |
| | 782 | 10977332 new chip 1130568 XY47 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977332.log 320 |
| | 783 | 10977333 new chip 1130570 XY47 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977333.log 320 |
| | 784 | 10977336 new chip 1131257 XY66 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977336.log 320 |
| | 785 | 10977337 new chip 1131260 XY66 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977337.log 320 |
| | 786 | 10977338 new chip 1200216 XY21 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977338.log 320 |
| | 787 | 10977339 new chip 1130573 XY21 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977339.log 320 |
| | 788 | 10977342 new chip 1131276 XY63 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977342.log 320 |
| | 789 | 10977343 new chip 1131280 XY63 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977343.log 320 |
| | 790 | 10977344 new chip 1130575 XY47 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977344.log 320 |
| | 791 | 10977345 new chip 1130578 XY47 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977345.log 320 |
| | 792 | 10977348 new chip 1131297 XY47 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977348.log 320 |
| | 793 | 10977349 new chip 1131303 XY47 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977349.log 320 |
| | 794 | 10977350 new chip 1131318 XY65 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977350.log 320 |
| | 795 | 10977351 new chip 1131321 XY65 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977351.log 320 |
| | 796 | 10977364 new chip 1130587 XY33 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977364.log 320 |
| | 797 | 10977365 new chip 1130590 XY46 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977365.log 320 |
| | 798 | 10977373 new chip 1131340 XY33 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977373.log 320 |
| | 799 | 10977384 new chip 1130596 XY34 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977384.log 320 |
| | 800 | 10977385 new chip 1130598 XY34 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977385.log 320 |
| | 801 | 10977386 new chip 1130600 XY34 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977386.log 320 |
| | 802 | 10977447 new chip 1583717 XY34 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977447.log 320 |
| | 803 | 10977448 new chip 1583733 XY34 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977448.log 320 |
| | 804 | 10977481 new chip 1756192 XY01 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977481.log 320 |
| | 805 | 10977483 new chip 1756719 XY01 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977483.log 320 |
| | 806 | 10977509 new chip 1795556 XY04 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977509.log 320 |
| | 807 | 10977510 new chip 1795572 XY04 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977510.log 320 |
| | 808 | 10977511 new chip 1795588 XY04 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977511.log 320 |
| | 809 | 10977512 new chip 1795603 XY04 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977512.log 320 |
| | 810 | 10977517 new chip 1813787 XY40 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977517.log 320 |
| | 811 | 10977518 new chip 1813804 XY40 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977518.log 320 |
| | 812 | 10977519 new chip 1813821 XY40 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977519.log 320 |
| | 813 | 10977520 new chip 1813838 XY40 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977520.log 320 |
| | 814 | 10977541 new chip 1936305 XY75 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977541.log 320 |
| | 815 | 10977542 new chip 1936310 XY01 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977542.log 320 |
| | 816 | 10977543 new chip 1936321 XY75 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977543.log 320 |
| | 817 | 10977544 new chip 1936326 XY01 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977544.log 320 |
| | 818 | 10977545 new chip 1936337 XY75 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977545.log 320 |
| | 819 | 10977546 new chip 1936342 XY01 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977546.log 320 |
| | 820 | 10977547 new chip 1936353 XY75 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977547.log 320 |
| | 821 | 10977548 new chip 1936358 XY01 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977548.log 320 |
| | 822 | 10977565 new chip 2055192 XY45 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977565.log 320 |
| | 823 | 10977566 new chip 2055202 XY45 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977566.log 320 |
| | 824 | 10977567 new chip 2055212 XY45 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977567.log 320 |
| | 825 | 10977568 new chip 2055222 XY45 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977568.log 320 |
| | 826 | 10977585 new chip 2088153 XY34 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977585.log 320 |
| | 827 | 10977586 new chip 2088169 XY34 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977586.log 320 |
| | 828 | 10977587 new chip 2088185 XY34 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977587.log 320 |
| | 829 | 10977588 new chip 2088201 XY34 gpc1 /data/ipp113.0/pstamp/work/2019/05/14/924082 ps_ud_WEB F 0 0 WEB 924082 /data/ipp113.0/pstamp/work/2019/05/14/924082/checkdep.10977588.log 320 |
| | 830 | }}} |
| | 831 | |
| | 832 | We can find their chip_id and warp_id, using: |
| | 833 | {{{ |
| | 834 | mysql -hscidbm -uippuser -pippuser gpc1 -B -e ' SELECT rawExp.exp_name,rawExp.exp_id,chipRun.chip_id,chipRun.state,chipRun.label,warpRun.warp_id,warpRun.state,warpRun.label,warpRun.data_group FROM warpSkyfile, warpRun, fakeRun, camRun, chipRun, rawExp WHERE warpSkyfile.warp_id = warpRun.warp_id AND warpRun.fake_id = fakeRun.fake_id AND fakeRun.cam_id = camRun.cam_id AND camRun.chip_id = chipRun.chip_id AND chipRun.exp_id = rawExp.exp_id AND chipRun.chip_id in (1131144,1131146,1131208,1131210,1130544,1130549,1130551,1130546,1130556,1130560,1131230,1200205,1131246,1131251,1130562,1130564,1130568,1130570,1131257,1131260,1200216,1130573,1131276,1131280,1130575,1130578,1131297,1131303,1131318,1131321,1130587,1130590,1131340,1130596,1130598,1130600,1583717,1583733,1756192,1756719,1795556,1795572,1795588,1795603,1813787,1813804,1813821,1813838,1936305,1936310,1936321,1936326,1936337,1936342,1936353,1936358,2055192,2055202,2055212,2055222,2088153,2088169,2088185,2088201) group by chip_id;' |
| | 835 | }}} |
| | 836 | And then send the chips to cleanup and then back to update. |
| | 837 | ->In fact, as soon as I sent them to cleanup, the pstamp server re-set their states to update and proceeded with making the stamps (since the warprun.state was full). Therefore, they are likely not properly cleaned at all.... |
| | 838 | |