is00hcw / tungsten-replicator

Automatically exported from code.google.com/p/tungsten-replicator
0 stars 1 forks source link

insert a row to Country table with foreign key ,the extractor crash #1098

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?

1.create 2 vm of virtualbox 4.3.22, guest os:OEL 6.6(hostname:mysql1 
master),OEL 6.4(hostname:mysql2 slave)
2.install tungsten replicator:
tpm reverse command screen output:
tools/tpm configure mydemo \
--install-directory=/opt/tungsten \
--master=mysql1 \
--members=mysql1,mysql2 \
--replication-password=tungsten \
--replication-user=tungsten \
--start=true \
--topology=master-slave
# Options for mysql1
tools/tpm configure mydemo \
--hosts=mysql1 \
--property=replicator.filter.replicate.do=world \
--property=replicator.postfilter=foreignkeychecks \
--svc-extractor-filters=replicate

3.ON master node(mysql1)
using mysql cmd:
to Create three tables(City,Country,CountryLanguage) using world_innodb.sql 
from www.mysql.com
4.On master node(mysql1)
  insert data to City,using world_innodb.sql data
then check rows number:

mysql> select count(*) from City;
+----------+
| count(*) |
+----------+
|     4079 |
+----------+
1 row in set (0.06 sec)

On slave host(mysql2):
mysql> select count(*) from City;
+----------+
| count(*) |
+----------+
|     4079 |
+----------+
1 row in set (0.00 sec)

the same rows(4079) on mysql1 and mysql2.

5.On Master host(mysql1)
mysql> SET FOREIGN_KEY_CHECKS=0  (the variable set to 1 or 0 the result is 
same,the service on mysql1 host will crash),
mysql> INSERT INTO `Country` VALUES ('ABW','Aruba','North 
America','Caribbean',193.00,NULL,103000,78.4,828.00,793.00,'Aruba','Nonmetropoli
tan Territory of The Netherlands','Beatrix',129,'AW');
Query OK, 1 row affected (0.01 sec)

What is the expected output?

a new row will be insert into table world.Country on mysql2 host.

What do you see instead?

the mysql2 host was inserted zero row.the screen output:
mysql2>show tables;
+-----------------+
| Tables_in_world |
+-----------------+
| City            |
| Country         |
| CountryLanguage |
| myt2            |
+-----------------+
4 rows in set (0.00 sec)

mysql2>select count(*) from Country;
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.00 sec) 

What version of the product are you using?

Tungsten Replicator 3.0.1 build 64 both of all on mysql1 and mysql2 hosts.

On what operating system?

mysql1: OEL 6.6 
mysql2: OEL 6.4

Please provide any additional information below.

Notes:

tpm diag output file had attached.

Original issue reported on code.google.com by cuig...@gmail.com on 26 Feb 2015 at 8:17

Attachments:

GoogleCodeExporter commented 9 years ago
This issue was already addressed by rev2733.
 It is fixed in version 3.1.0.

Please try with that version and report again if it still fails.

Original comment by g.maxia on 26 Feb 2015 at 11:41

GoogleCodeExporter commented 9 years ago
Thanks. 

    Where can I get the version 3.1.0? Please give me a download web address.
Thanks again!
BR

Original comment by cuig...@gmail.com on 27 Feb 2015 at 2:26

GoogleCodeExporter commented 9 years ago
ooh.

   I saw https://code.google.com/p/tungsten-replicator/wiki/FAQ    and 
         https://code.google.com/p/tungsten-replicator/wiki/HowToBuild .
   I build the version 4.1.0,then test again,the result is ok.
 Thanks.

BR

Original comment by cuig...@gmail.com on 27 Feb 2015 at 4:05

GoogleCodeExporter commented 9 years ago
The nightly builds link is accessible from the project home page.

Original comment by g.maxia on 27 Feb 2015 at 10:41