actiontech / dtle Goto Github PK
View Code? Open in Web Editor NEWDistributed Data Transfer Service for MySQL
Home Page: https://actiontech.github.io/dtle-docs-cn
License: Mozilla Public License 2.0
Distributed Data Transfer Service for MySQL
Home Page: https://actiontech.github.io/dtle-docs-cn
License: Mozilla Public License 2.0
Description
Steps to reproduce the issue:
grant all xxx
in sourceDescribe the results you received:
dtle error:
parse query [GRANT ALL PRIVILEGES xxx] event failed ...
Describe the results you expected:
no error
Output of ./dtle version
:
(not available)
Additional information you deem important (e.g. issue happens only occasionally):
Additional details (log, config, job config etc):
Description
Steps to reproduce the issue:
Describe the results you received:
Describe the results you expected:
empty database should be replicated
Output of ./dtle version
:
(not available)
Additional information you deem important (e.g. issue happens only occasionally):
Additional details (log, config, job config etc):
[INTERNAL USE]
Description
Steps to reproduce the issue:
ALTER TABLE sbtest2 ADD CONSTRAINT fk_PerOrders FOREIGN KEY (k) REFERENCES sbtest1(k);
in sourceDescribe the results you received:
dtle error:
[ERR] mysql.applier: unspected error: Error 1022: Can't write; duplicate key in table '#sql-4641_310'
Describe the results you expected:
it should work
Output of ./dtle version
:
(not available)
Additional information you deem important (e.g. issue happens only occasionally):
Additional details (log, config, job config etc):
[INTERNAL USE]
[INTERNAL USE]
Description
Steps to reproduce the issue:
create index k_1 on sbtest1(K)
in both two sourcesDescribe the results you received:
dtle error:
[ERR] mysql.applier: exec sql error: Error 1061: Duplicate key name 'k_1'
Describe the results you expected:
No error
Output of ./dtle version
:
(not available)
Additional information you deem important (e.g. issue happens only occasionally):
Additional details (log, config, job config etc):
Description
Steps to reproduce the issue:
insert into Dtypes_string_blob (sid,num,col1,col2,col3,col4) values ('ERNSH',1,'123','abc','__%%%\','a_bcdefg');
Describe the results you received:
dtle report error:
Describe the results you expected:
Output of ./dtle version
:
(not available)
Additional information you deem important (e.g. issue happens only occasionally):
Additional details (log, config, job config etc):
Description
Steps to reproduce the issue:
Describe the results you received:
job2 replication doesn't work
Describe the results you expected:
job2 replication should work
Output of ./dtle version
:
(not available)
Additional information you deem important (e.g. issue happens only occasionally):
Additional details (log, config, job config etc):
Description
Steps to reproduce the issue:
Describe the results you received:
dtle exit with error:
[ERR] mysql.extractor: unexpected error on publish, got nats: connection closed.
...
[ERR] mysql.applier: exec set gtid_next err: sql: database is closed
[ERR] mysql.applier: unexpected err: sql: database is closed
Describe the results you expected:
it should work
Output of ./dtle version
:
(not available)
Additional information you deem important (e.g. issue happens only occasionally):
Additional details (log, config, job config etc):
[INTERNAL USE]
Description
Steps to reproduce the issue:
Describe the results you received:
No job deleted
Describe the results you expected:
Specific job should be deleted
Output of ./dtle version
:
(not available)
Additional information you deem important (e.g. issue happens only occasionally):
Additional details (log, config, job config etc):
Description
Steps to reproduce the issue:
dtle_test74_client_allocs_job1500516500_Dest_6f7b1172_9776_610f_b887_e460f05bcecf_Dest_table_dest_queue_size
Describe the results you received:
udp_dest_queue_size
, and attributes should be put into labelsDescribe the results you expected:
Output of ./dtle version
:
(not available)
Additional information you deem important (e.g. issue happens only occasionally):
Additional details (log, config, job config etc):
[INTERNAL USE]
[INTERNAL USE]
[INTERNAL USE]
[INTERNAL USE]
[INTERNAL USE]
Is your feature request related to a problem? Please describe.
No
Describe the solution you'd like
Add a parameter called "network_ratelimit" on job, to limit network resource usage.
Describe alternatives you've considered
None
Description
Steps to reproduce the issue:
Describe the results you received:
dtle report error:
[ERR] mysql.extractor: Error in Request: nats: timeout
Describe the results you expected:
Output of ./dtle version
:
(not available)
Additional information you deem important (e.g. issue happens only occasionally):
Additional details (log, config, job config etc):
[INTERNAL USE]
[INTERNAL USE]
[INTERNAL USE]
Is your feature request related to a problem? Please describe.
No
Describe the solution you'd like
GTIDs are implemented as a new binlog event type. GTIDs are written to the
binlog prior to the transaction that they describe. They effectivity represent
a new type of commit position. MySQL provides a new sessions variable
NEXT_GTID that can be used to set the GTID when replaying transactions in
slaves.
dtle will parse GTIDs correctly, set them correctly on slaves, and will
take advantage of them to prevent multi-master loops.
GTIDs have a number of uses in dtle that should be includes in the
implementation.
Parse GTID events and add them to the event log.
Set GTID values on the slave.
Optionally use GTID values to prevent replication loops as a replacement
from the current system using MySQL binlog and offset values to identify the
position of slaves.
GTIDs if usable provide a means of avoiding replication loops.They also make
it possible switch between different MySQL.
Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.
[INTERNAL USE]
Description
Steps to reproduce the issue:
Describe the results you received:
replication not work
Describe the results you expected:
replication should work
Output of ./dtle version
:
(not available)
Additional information you deem important (e.g. issue happens only occasionally):
Additional details (log, config, job config etc):
Description
Steps to reproduce the issue:
CREATE VIEW v AS SELECT count(*) from sbtest1
Describe the results you received:
dtle report error:
[INFO] mysql.extractor: streamEvents encountered unexpected error: parse query [CREATE ... VIEW v AS SELECT count(*) from sbtest1" (total length 107)
Describe the results you expected:
no error
Output of ./dtle version
:
(not available)
Additional information you deem important (e.g. issue happens only occasionally):
Additional details (log, config, job config etc):
Description
Steps to reproduce the issue:
show processlist
on sourceDescribe the results you received:
Found connection to MySQL leaks
Describe the results you expected:
Output of ./dtle version
:
(not available)
Additional information you deem important (e.g. issue happens only occasionally):
Additional details (log, config, job config etc):
[INTERNAL USE]
Description
Steps to reproduce the issue:
Describe the results you received:
dtle reports it cannot replicate table with foreign key
Describe the results you expected:
Output of ./dtle version
:
(not available)
Additional information you deem important (e.g. issue happens only occasionally):
Additional details (log, config, job config etc):
Description
Steps to reproduce the issue:
Describe the results you received:
Describe the results you expected:
Output of ./dtle version
:
(not available)
Additional information you deem important (e.g. issue happens only occasionally):
Additional details (log, config, job config etc):
Is your feature request related to a problem? Please describe.
No
Describe the solution you'd like
rpm should support relocation (http://rpm5.org/docs/api/relocatable.html).
rpm -ivh --prefix /opt/dtle dtle-1.0.0-qa.x86_64.rpm
should not failed
Describe alternatives you've considered
No
[INTERNAL USE]
[INTERNAL USE]
[INTERNAL USE]
Description
Steps to reproduce the issue:
ALTER USER xxx
in source databaseDescribe the results you received:
dtle failed to start
Describe the results you expected:
replication should work
Output of ./dtle version
:
(Not available)
Additional information you deem important (e.g. issue happens only occasionally):
Additional details (log, config, job config etc):
[INTERNAL USE]
[INTERNAL USE]
Description
Steps to reproduce the issue:
Describe the results you received:
Describe the results you expected:
Output of ./dtle version
:
(not available)
Additional information you deem important (e.g. issue happens only occasionally):
Additional details (log, config, job config etc):
[INTERNAL USE]
Description
Steps to reproduce the issue:
insert into varchar_columns (id,c_varchar) values (6,'~`!@#$%&*()-=_+{}[]|:;<>,.?/');
Describe the results you received:
dtle report SQL syntax error
Describe the results you expected:
Output of ./dtle version
:
(not available)
Additional information you deem important (e.g. issue happens only occasionally):
Additional details (log, config, job config etc):
[INTERNAL USE]
Description
Steps to reproduce the issue:
drop database if exists sbtest
in both sourcescreate database if not exists sbtest;
USE sbtest;
CREATE TABLE sbtest1 (
id int(10) unsigned NOT NULL,
k int(10) unsigned NOT NULL DEFAULT '0',
c char(120) NOT NULL DEFAULT '',
pad char(60) NOT NULL DEFAULT '',
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 MAX_ROWS=1000000
Describe the results you received:
dtle error:
[ERR] mysql.applier: exec sql error: Error 1046: No database selected
Describe the results you expected:
it should work
Output of ./dtle version
:
(not available)
Additional information you deem important (e.g. issue happens only occasionally):
Additional details (log, config, job config etc):
[INTERNAL USE]
Is your feature request related to a problem? Please describe.
No
Describe the solution you'd like
if set GTID to "AUTO", like MySQL do, target should detect source's GTID and start replication from it
Describe alternatives you've considered
None
[INTERNAL USE]
[INTERNAL USE]
[INTERNAL USE]
[INTERNAL USE]
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.