Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

数据同步丢失问题 #118

Open
liyang-liuna opened this issue Feb 14, 2019 · 0 comments
Open

数据同步丢失问题 #118

liyang-liuna opened this issue Feb 14, 2019 · 0 comments

Comments

@liyang-liuna
Copy link

liyang-liuna commented Feb 14, 2019

使用 bireme.2.0 版本。
使用过程中,发现同一张表中的数据 有的同步过来了,有的没有。
请问 同一张表 bireme如何保证有序性的?

下面是同一个表 执行一次copyManage的日志,从日志上看,数据是积累的一定数量后 在执行 同步的,如果这一批数据有先后数据,这样同步能保证数据的一致性吗?

07:51:48 INFO Maxwell-maxwell1-pgtopic-1 - -copyWorker---------insert---------sql:COPY ttpai_ms_admin."ROUTE_SERVICE" (id,service_id,instance_ip,instance_port,static_instance,create_time,modify_time) FROM STDIN WITH DELIMITER '|' NULL '' CSV QUOTE '"' ESCAPE E'\';
07:51:48 ERROR Maxwell-maxwell1-pgtopic-1 - ------CopyManager-----sql:COPY ttpai_ms_admin."ROUTE_SERVICE" (id,service_id,instance_ip,instance_port,static_instance,create_time,modify_time) FROM STDIN WITH DELIMITER '|' NULL '' CSV QUOTE '"' ESCAPE E'\';,PipedInputStream:73|"TTPAI-MS-OPERATELOG"|"172.16.3.56"|8080|0|2019-01-13 05:30:29|2019-02-14 15:48:12
63|"TTPAI-MS-SHORTURL"|"172.16.3.71"|8080|0|2019-01-13 05:30:29|2019-02-14 15:48:12
72|"TTPAI-MS-CALLCENTER"|"172.16.3.75"|8080|0|2019-01-13 05:30:29|2019-02-14 15:48:12
69|"TTPAI-MS-PAYMENT"|"172.16.3.95"|8080|0|2019-01-13 05:30:29|2019-02-14 15:48:12
68|"TTPAI-MS-REGISTRY"|"172.16.3.134"|8080|0|2019-01-13 05:30:29|2019-02-14 15:48:12
66|"TTPAI-MS-ROUTE"|"172.16.3.91"|8080|0|2019-01-13 05:30:29|2019-02-14 15:48:12
64|"TTPAI-MS-COUPON"|"172.16.3.77"|8080|0|2019-01-13 05:30:29|2019-02-14 15:48:12
70|"TTPAI-MS-B2C-CHECK"|"172.16.3.185"|8080|0|2019-01-13 05:30:29|2019-02-14 15:48:12
67|"TTPAI-MS-SOLR"|"172.16.3.51"|8080|0|2019-01-13 05:30:29|2019-02-14 15:48:12
71|"TTPAI-MS-CHECK"|"172.16.3.187"|8080|0|2019-01-13 05:30:29|2019-02-14 15:48:12
62|"TTPAI-MS-PUBLIC"|"172.16.3.133"|8080|0|2019-01-13 05:30:29|2019-02-14 15:48:12
59|"TTPAI-MS-CARMODEL"|"172.16.3.146"|8080|0|2019-01-13 05:30:29|2019-02-14 15:48:12
65|"TTPAI-MS-GPK"|"172.16.3.147"|8080|0|2019-01-13 05:30:29|2019-02-14 15:48:12
60|"TTPAI-ODIN-PROXY"|"172.16.3.195"|8080|0|2019-01-13 05:30:29|2019-02-14 15:48:12
61|"TTPAI-MS-CONTRACT"|"172.16.3.5"|8080|0|2019-01-13 05:30:29|2019-02-14 15:48:12

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant