| 476 | | mysql -hscidbm -uX -pX gpc1 -B -e 'SELECT count(*),gather.data_group,gather.label FROM (SELECT suba.exp_id,subb.warp_id,subb.chip_id,subb.state,subb.data_group,subb.label FROM (SELECT exp_id FROM warpRun JOIN fakeRun USING (fake_id) JOIN camRun USING (cam_id) JOIN chipRun USING (chip_id) JOIN rawExp USING (exp_id) WHERE warpRun.state NOT LIKE "%full%" AND rawExp.camera LIKE "%GPC1%" AND camRun.label LIKE "%LAP.PV3%" GROUP BY exp_id) as suba INNER JOIN (SELECT * FROM (SELECT warp_id,chipRun.exp_id,chipRun.chip_id,warpRun.state,camRun.data_group,camRun.label FROM warpRun JOIN fakeRun USING (fake_id) JOIN camRun USING (cam_id) JOIN chipRun USING (chip_id) JOIN rawExp USING (exp_id) WHERE warpRun.label NOT LIKE "%broke%" AND warpRun.label NOT LIKE "%hold%" AND rawExp.camera LIKE "%GPC1%" ORDER BY warp_id DESC) as od GROUP BY od.exp_id) AS subb ON (subb.exp_id = suba.exp_id)) as gather WHERE (state LIKE "%cleaned" OR state LIKE "update") GROUP BY data_group;' |
| | 476 | mysql -hscidbm -uX -pX gpc1 -B -e 'SELECT count(*),gather.data_group,gather.label FROM (SELECT suba.exp_id,subb.warp_id,subb.chip_id,subb.state,subb.data_group,subb.label FROM (SELECT exp_id FROM warpRun JOIN fakeRun USING (fake_id) JOIN camRun USING (cam_id) JOIN chipRun USING (chip_id) JOIN rawExp USING (exp_id) WHERE warpRun.state NOT LIKE "%full%" AND rawExp.camera LIKE "%GPC1%" AND camRun.label LIKE "%LAP.PV3%" GROUP BY exp_id) as suba INNER JOIN (SELECT * FROM (SELECT warp_id,chipRun.exp_id,chipRun.chip_id,warpRun.state,warpRun.data_group,camRun.label FROM warpRun JOIN fakeRun USING (fake_id) JOIN camRun USING (cam_id) JOIN chipRun USING (chip_id) JOIN rawExp USING (exp_id) WHERE warpRun.label NOT LIKE "%broke%" AND warpRun.label NOT LIKE "%hold%" AND rawExp.camera LIKE "%GPC1%" ORDER BY warp_id DESC) as od GROUP BY od.exp_id) AS subb ON (subb.exp_id = suba.exp_id)) as gather WHERE (state LIKE "%cleaned" OR state LIKE "update") GROUP BY data_group;' |
| | 727 | --------------------- |
| | 728 | |
| | 729 | Czar meeting at 13:30: |
| | 730 | We want to test the ippx nodes, now that they have been redistributed within their cabinet. Best way, set them as the only nodes to be used by stdscience for the ~2hours until the daily restart. Look at hosts groups in ippconfig/pantasks_hosts.input to find which host groups are loaded by the regular stdscience pantasks: |
| | 731 | {{{ |
| | 732 | macro hosts.stdscience |
| | 733 | echo hosts.stdscience |
| | 734 | control run reap |
| | 735 | |
| | 736 | hosts.ignore.storage |
| | 737 | |
| | 738 | ## 5x, 4x seems to work better, fewer faults MEH 20170316 |
| | 739 | ## reduce 3x si0, boost 5x ci0+1 while dvo/psps running MEH 20170812 |
| | 740 | ## adding more power with data nodes s4-8 after large MOPS update testing MEH 180524 |
| | 741 | for i 0 3 |
| | 742 | hosts add si0 |
| | 743 | hosts add s4 |
| | 744 | hosts add s5 |
| | 745 | hosts add s6 |
| | 746 | hosts add s7 |
| | 747 | hosts add s8 |
| | 748 | end |
| | 749 | # |
| | 750 | for i 0 5 |
| | 751 | hosts add ci0 |
| | 752 | hosts add ci1 |
| | 753 | end |
| | 754 | # add another ci1 but not ci0 since ippitc+pantasks running there too MEH 180524 |
| | 755 | hosts add ci1 |
| | 756 | |
| | 757 | control run |
| | 758 | end |
| | 759 | }}} |
| | 760 | Now then, to get the x nodes in, we first added the hosts definitions for the ippx nodes to the ippconfig/pantasks_hosts.input file. Then, we restarted the pantasks to load those in, and then use 'hosts off' with the appropriate groups to turn off the current set of nodes. Then, we add hosts groups x0,x1,x2 a total of 10 times, to get their CPUs fully utilised. They are using about 80 percent CPU on ganglia but seem to be behaving alright. |
| | 761 | Keep an eye on boottime in ganglia, to see if any x nodes randomly reboot, in prep for PS2. Tomorrow morning, add the xnodes back in to test them again, and keep an eye on them. |