Changes between Version 7 and Version 8 of MergeDvoDbLap20120706

Timestamp:

Feb 8, 2013, 11:49:20 AM (13 years ago)

Author:

heather

Comment:

--

MergeDvoDbLap20120706

@@ -51 +51 @@
 
  * to check: there are 152 or so faulted addstuffs..why?? note I don't think it has to do with what I've been doing ... oh it is...I fail at compiling.. I think it's okay though... need to check...
+
+== restart ==
+
+The mergedvodb that I created failed because of file permissions. I have fixed the directory permission problem but I need to start over:
+
+ * step 1 rsync -> /data/ipp005.0/gpc1/catdirs/LAP.ThreePi.20120706.20130208 == this is a horrible name but at least it's descriptive
+ * step 2 fix hosttable.dat
+ * step 3 dvodist -out
+ * step 4 fix the mergedvodbRun tables - want to redo the merging.
+   * check that addstarlap and addstar do not have anything in show.mergedvodb or survey.show.mergedvodb (I deleted them)
+   * use these commands to move stuff out of the way in the db 
+   {{{ 
+mysql> update mergedvodbRun set mergedvodb_path = '/data/ipp005.0/gpc1/catdirs/LAP.ThreePi.20120706.drop.20130207' where mergedvodb = 'LAP.20120706';
+Query OK, 74 rows affected (0.04 sec)
+Rows matched: 74  Changed: 74  Warnings: 0
+
+mysql> update mergedvodbRun set mergedvodb = 'LAP.20120706.drop.20130207' where mergedvodb = 'LAP.20120706';
+Query OK, 74 rows affected (0.01 sec)
+Rows matched: 74  Changed: 74  Warnings: 0
+}}}
+   * move stuff out of the way on the ipp005.0 side; 
+{{{
+ippdvo@ipp005:/data/ipp005.0/gpc1/catdirs>mv LAP.ThreePi.20120706.drop2 LAP.ThreePi.20120706.drop.20130207
+}}}
+pantasks_client stuff:
+{{{
+pantasks: mergedvodb.merge.off
+}}}
+queue:
+{{{
+survey.add.mergedvodb LAP.20120706.cam LAP.20120706 LAP.slice18.cam
+}}}
+remove from queue:
+survey.del.mergedvodb LAP.20120706.cam
+
+and repeat for .skycal
+
+