Changes between Version 16 and Version 17 of PS1_IPP_Czarlog_20130429

Timestamp:

May 2, 2013, 5:32:23 AM (13 years ago)

Author:

bills

Comment:

--

PS1_IPP_Czarlog_20130429

@@ -22 +22 @@
 
 {{{
-On the master
+On the slave
+mysql> show slave status\G
+*************************** 1. row ***************************
+             Slave_IO_State: Waiting for master to send event
+                Master_Host: ippc17.ifa.hawaii.edu
+                Master_User: repl_pstamp
+                Master_Port: 3306
+              Connect_Retry: 60
+            Master_Log_File: mysqld-bin.000718
+        Read_Master_Log_Pos: 63235322
+             Relay_Log_File: mysqld-relay-bin.000002
+              Relay_Log_Pos: 1751685
+      Relay_Master_Log_File: mysqld-bin.000718
+           Slave_IO_Running: Yes
+          Slave_SQL_Running: No
+            Replicate_Do_DB: ippRequestServer
+        Replicate_Ignore_DB: 
+         Replicate_Do_Table: 
+     Replicate_Ignore_Table: 
+    Replicate_Wild_Do_Table: 
+Replicate_Wild_Ignore_Table: 
+                 Last_Errno: 1062
+                 Last_Error: Error 'Duplicate entry '3478690' for key 1' on query. Default database: 'ippRequestServer'. Query: 'INSERT into dsFileset (prod_id, fileset_name, reg_time, 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) VALUES('52', 'dqstats.20794', UTC_TIMESTAMP(), 'table', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)'
+               Skip_Counter: 0
+        Exec_Master_Log_Pos: 1751547
+            Relay_Log_Space: 63235460
+            Until_Condition: None
+             Until_Log_File: 
+              Until_Log_Pos: 0
+         Master_SSL_Allowed: No
+         Master_SSL_CA_File: 
+         Master_SSL_CA_Path: 
+            Master_SSL_Cert: 
+          Master_SSL_Cipher: 
+             Master_SSL_Key: 
+      Seconds_Behind_Master: NULL
+1 row in set (0.00 sec)
+
+On the master the troublesome row is
+
 select * From dsFileset where fileset_id = 3478690;
 +---------+------------+---------------+---------------------+------+-------+------------+------------+------------+------------+------------+------------+------------+------------+
@@ -31 +70 @@
 1 row in set (0.00 sec)
 
-On the slave
+While on the slave that id is used for another entry
+
 mysql> select * From dsFileset where fileset_id = 3478690;
 +---------+------------+--------------------------------------+---------------------+------+----------+------------+------------+------------+-------------+------------------+------------+------------+------------+
@@ -40 +80 @@
 1 row in set (0.00 sec)
 
-But this fileset is missing on the master
+But that entry does not exist on the master
+
 mysql> select * From dsFileset where fileset_name = 'o6414g0056o.camera.808365.2945979.26';
 Empty set (0.50 sec)
+
+
+Interestingly the corresponding fileset directory does exist in the dsroot directory on ippc17.
+
+bills% ls /data/ippc17.0/datastore/dsroot/ps1-3pi-cat/o6414g0056o.camera.808365.2945979.26
+dbinfo.camera.808365.mdc   index.txt
+dirinfo.camera.808365.mdc  o6414g0056o.607641.cm.808365.tgz
+
+But is inacessible through the datastore because the 
+wcat http://ippc17/ds/ps1-3pi-cat/o6414g0056o.camera.808365.2945979.26/index.txt
+
+failed to find o6414g0056o.camera.808365.2945979.26 in ps1-3pi-cat
 }}}
-
 === Friday : 2013.05.03  ===