Issue 1098 in tungsten-replicator: insert a row to Country table with foreign key ,the extractor crash

[tungsten-...@googlecode.com]

Status: New
Owner: ----
Labels: Type-Defect Priority-Medium FoundIn

New issue 1098 by cuig...@gmail.com: insert a row to Country table with
foreign key ,the extractor crash
https://code.google.com/p/tungsten-replicator/issues/detail?id=1098

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','Nonmetropolitan
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.


Attachments:
tungsten-diag-2015-02-26-13-01-01.zip 74.5 KB

--
You received this message because this project is configured to send all
issue notifications to this address.
You may adjust your notification preferences at:
https://code.google.com/hosting/settings

[tungsten-...@googlecode.com]

Comment #1 on issue 1098 by g.maxia: insert a row to Country table with

foreign key ,the extractor crash
https://code.google.com/p/tungsten-replicator/issues/detail?id=1098

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.

[tungsten-...@googlecode.com]

Comment #2 on issue 1098 by cuig...@gmail.com: insert a row to Country

table with foreign key ,the extractor crash
https://code.google.com/p/tungsten-replicator/issues/detail?id=1098

Thanks.

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

[tungsten-...@googlecode.com]

Comment #3 on issue 1098 by cuig...@gmail.com: insert a row to Country

table with foreign key ,the extractor crash
https://code.google.com/p/tungsten-replicator/issues/detail?id=1098

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.

[tungsten-...@googlecode.com]

Updates:
Status: Done

Comment #4 on issue 1098 by g.maxia: insert a row to Country table with

foreign key ,the extractor crash
https://code.google.com/p/tungsten-replicator/issues/detail?id=1098

The nightly builds link is accessible from the project home page.