Changes between Version 28 and Version 29 of PS1_IPP_CzarLog_20110627

Timestamp:

Jun 28, 2011, 7:55:17 PM (15 years ago)

Author:

Serge CHASTEL

Comment:

--

PS1_IPP_CzarLog_20110627

@@ -51 +51 @@
  * 19:38 Serge: Replication started on ippdb03
  * 19:47 Bill: turned off diff processing temporarily.
+ * 19:43-53 Serge: Replication seems to have failed again. Last exp_id on ippdb01 is 354060 while on ippdb03 it's 353683.
+The SHOW SLAVE STATUS command shows that everything's fine on the replication host:
+{{{
+            Slave_IO_State: Waiting for master to send event
+                Master_Host: ippdb01.ifa.hawaii.edu
+                Master_User: repl_gpc1
+                Master_Port: 3306
+              Connect_Retry: 60
+            Master_Log_File: mysqld-bin.020091
+        Read_Master_Log_Pos: 99203082
+             Relay_Log_File: mysqld-relay-bin.000031
+              Relay_Log_Pos: 99203220
+      Relay_Master_Log_File: mysqld-bin.020091
+           Slave_IO_Running: Yes
+          Slave_SQL_Running: Yes
+            Replicate_Do_DB: gpc1,czardb,ippadmin,isp
+        Replicate_Ignore_DB: 
+         Replicate_Do_Table: 
+     Replicate_Ignore_Table: 
+    Replicate_Wild_Do_Table: 
+Replicate_Wild_Ignore_Table: 
+                 Last_Errno: 0
+                 Last_Error: 
+               Skip_Counter: 0
+        Exec_Master_Log_Pos: 99203082
+            Relay_Log_Space: 99203220
+            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: 0
+1 row in set (0.00 sec)
+}}}
+On the master:
+{{{
+| 204458295 | repl_gpc1 | ippdb03.ifa.hawaii.edu:35103 | NULL   | Binlog Dump |   574 | Has sent all binlog to slave; waiting for binlog to be updated |
+}}}
+ippdb03 log does not show any error:
+{{{
+110628 19:37:42 [Note] Slave I/O thread: connected to master 'repl_gpc1@ippdb01.ifa.hawaii.edu:3306',  replication started in log 'mysqld-bin.020077' at position 84637877
+110628 19:37:42 [Note] Slave SQL thread initialized, starting replication in log 'mysqld-bin.020077' at position 84637877, relay log './mysqld-relay-bin.000001' position: 4
+EOF
+}}}
+... and the ippdb01 log is empty (size 0) (it doesn't seem to be redirected to some other file according to /etc/mysql/my.cnf)
+
+Note: While looking at the PROCESSLIST table of ippdb01, I saw that:
+{{{
+| 204467208 | unauthenticated user | ipp034.ifa.hawaii.edu:59761  | NULL   | Connect     |  NULL | Reading from net                                               | NULL                                                                                                 | 
+}}}
+(It's likely unrelated but I wanted to write it down)
+
+J'aime pas ça...
 === Wednesday : YYYY.MM.DD ===