Changes between Version 15 and Version 16 of PS1_IPP_Czarlog_20130429

Timestamp:

May 2, 2013, 5:17:55 AM (13 years ago)

Author:

bills

Comment:

--

PS1_IPP_Czarlog_20130429

@@ -17 +17 @@
  * 16:00 started up summit copy and registration
 === Thursday : 2013.05.02 ===
+Bill is czar today
+ * 04:00 EAM : reconfigured mysql on ipp005 - ipp009 : set innodb_buffer_pool_size back down to 2G from 16G.  I had bumped these up in an attempt to help ipptopsps / dvopsps go faster (avoid swapping), but have since switched to memory engine for the dvoDetectionFull table causing the problem.  I also killed some rpc.statds on ipp008 and ipp010.
+ * 05:12 replication of ippRequestServer database from ippc17 to ippc19 has failed. The error is that an insert into the slave failed because an insert into dsFileset tried to use a value for the primary key that duplicates an existing row
 
- * 04:00 EAM : reconfigured mysql on ipp005 - ipp009 : set innodb_buffer_pool_size back down to 2G from 16G.  I had bumped these up in an attempt to help ipptopsps / dvopsps go faster (avoid swapping), but have since switched to memory engine for the dvoDetectionFull table causing the problem.  I also killed some rpc.statds on ipp008 and ipp010.
+{{{
+On the master
+select * From dsFileset where fileset_id = 3478690;
++---------+------------+---------------+---------------------+------+-------+------------+------------+------------+------------+------------+------------+------------+------------+
+| prod_id | fileset_id | fileset_name  | reg_time            | hide | type  | prod_col_0 | prod_col_1 | prod_col_2 | prod_col_3 | prod_col_4 | prod_col_5 | prod_col_6 | prod_col_7 |
++---------+------------+---------------+---------------------+------+-------+------------+------------+------------+------------+------------+------------+------------+------------+
+|      52 |    3478690 | dqstats.20794 | 2013-05-02 06:18:09 |    0 | table | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | 
++---------+------------+---------------+---------------------+------+-------+------------+------------+------------+------------+------------+------------+------------+------------+
+1 row in set (0.00 sec)
+
+On the slave
+mysql> select * From dsFileset where fileset_id = 3478690;
++---------+------------+--------------------------------------+---------------------+------+----------+------------+------------+------------+-------------+------------------+------------+------------+------------+
+| prod_id | fileset_id | fileset_name                         | reg_time            | hide | type     | prod_col_0 | prod_col_1 | prod_col_2 | prod_col_3  | prod_col_4       | prod_col_5 | prod_col_6 | prod_col_7 |
++---------+------------+--------------------------------------+---------------------+------+----------+------------+------------+------------+-------------+------------------+------------+------------+------------+
+|      54 |    3478690 | o6414g0056o.camera.808365.2945979.26 | 2013-05-02 06:17:09 |    0 | IPP-DIST | 1316       | camera     | 808365     | o6414g0056o | ThreePi.20130502 | y.00000    | NULL       | NULL       | 
++---------+------------+--------------------------------------+---------------------+------+----------+------------+------------+------------+-------------+------------------+------------+------------+------------+
+1 row in set (0.00 sec)
+
+But this fileset is missing on the master
+mysql> select * From dsFileset where fileset_name = 'o6414g0056o.camera.808365.2945979.26';
+Empty set (0.50 sec)
+}}}
 
 === Friday : 2013.05.03  ===