List:Replication« Previous MessageNext Message »
From:Rick James Date:October 12 2009 8:25pm
Subject:RE: replication problem due an inexistent table
View as plain text  
And what is the actual query that it is complaining about?

 
Rick James
MySQL Geeks - Consulting & Review

 

> -----Original Message-----
> From: Benedikt Schackenberg [mailto:Schackenberg@stripped] 
> Sent: Wednesday, October 07, 2009 2:41 AM
> To: 'Bermejo, Rodrigo (GE Infra, Aviation)'; 
> replication@stripped
> Subject: AW: replication problem due an inexistent table
> 
> Witch version of mysql is on your server running?
> 
> -----Ursprüngliche Nachricht-----
> Von: Bermejo, Rodrigo (GE Infra, Aviation) 
> [mailto:rodrigo.bermejo@stripped] 
> Gesendet: Dienstag, 6. Oktober 2009 20:50
> An: replication@stripped
> Betreff: replication problem due an inexistent table
> 
> Hi List /.
>  
> We are facing a problem with the replication of a DB
> We have two databases which act as master and slave of each other.
> The problem the log show is this:
>  
> Server A -> The MYSQL error is:
> 
> Error 'Table 'aso.aso_time' doesn't exist' on query.
> 
> Server B -> The MySQL error is:
> 
> Error 'Unknown table 'aso.aso_time'  on query.
> 
> We added one table to server A but  while we were creating the other
> table on Server B the replication process started failing.
> 
> So we droped the table from server A but the problem still persits.
> 
> What do you recommend to get in sync both DB's  /?
> 
> Thanks
> 
>  
> 
>  
> 
> 
> 
> -- 
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe:    
> http://lists.mysql.com/replication?unsub=1
> 
> 
Thread
replication problem due an inexistent tableAviation) GE Infra6 Oct
  • AW: replication problem due an inexistent tableBenedikt Schackenberg7 Oct
    • RE: replication problem due an inexistent tableRick James12 Oct
  • Re: replication problem due an inexistent tableJustin Edwards7 Oct