Error 1050( Replicaition)

Posted on 2010-01-06
Medium Priority
Last Modified: 2012-05-08
i have 3 way Multimaster replication.
One of Slave having this problem

 Last_Errno: 1050
                 Last_Error: Error 'Table 'test_EV' already exists' on query. Default database: 'xxxx'. Query: 'create table test_EV(
id int )'

From Slave :
 Master_Log_File: mysql-bin.000003
        Read_Master_Log_Pos: 344819

From MAster:

mysql> show master status;
| File             | Position | Binlog_Do_DB              | Binlog_Ignore_DB |
| mysql-bin.000003 |   344819 | fosiul,hesk,xxxxx| mysql,test       |

As you can see, both log positions  is same

now, if i do this :

In Master : Stop master, reset master
in Salve : stop salve, reset slave, start slave

its works fine.
but if there is any connection problems in between master and slave, after connections established, i see the same error in Slave

so what shall i do ??

Question by:fosiul01
  • 2

Accepted Solution

marklogan earned 2000 total points
ID: 26188661
If the slave has stopped you need to skip the query and restart it, you shouldn't need to stop the master.

stop slave;
set global sql_slave_skip_counter=1; 
start slave;

Open in new window

LVL 29

Author Comment

ID: 26188689
HI thanks

I did that one yesterday night set sql_slave

but then i see this error :

 Last_Errno: 1062
                 Last_Error: Error 'Duplicate entry '16' for key 1' on query. Default database: 'fosiul'. Query: 'INSERT /* Revision::insertOn Fosiul */  INTO `mwi_text` (old_id,old_text,old_flags) VALUES (NULL,'* How to define an array ? \n  :<pre> \n   use strict;\n   my @myarray;\n   @myarray = (\"fosiul\",\"safali\",\"yusuf\");\n   print \"@myarray\\n\";\n  </pre>','utf-8')'

which is duplicate key

in this slave , i have this setup

auto_increment_increment = 2
auto_increment_offset = 3

so where is the problem ??

Expert Comment

ID: 26188720
Sorry, my knowledge of a n-way multi-master setup isn't that great.

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
Suggested Courses

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question