You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/05/07 11:40:45 UTC
[GitHub] [shardingsphere] malaxiaolongxia opened a new issue #5458: scaling incrementalSyncTask is stuck
malaxiaolongxia opened a new issue #5458:
URL: https://github.com/apache/shardingsphere/issues/5458
Scaling incrementalSyncTask job is stucked in` MySQLClient.registerSlave() `and not work when i update source table
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] terrymanu closed issue #5458: scaling incrementalSyncTask is stuck
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #5458:
URL: https://github.com/apache/shardingsphere/issues/5458
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] avalon5666 commented on issue #5458: scaling incrementalSyncTask is stuck
Posted by GitBox <gi...@apache.org>.
avalon5666 commented on issue #5458:
URL: https://github.com/apache/shardingsphere/issues/5458#issuecomment-625579888
Pls provide steps to reproduce the behavior.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] avalon5666 commented on issue #5458: scaling incrementalSyncTask is stuck
Posted by GitBox <gi...@apache.org>.
avalon5666 commented on issue #5458:
URL: https://github.com/apache/shardingsphere/issues/5458#issuecomment-626325311
It seem you are using mariadb, scaling only test by mysql.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] malaxiaolongxia removed a comment on issue #5458: scaling incrementalSyncTask is stuck
Posted by GitBox <gi...@apache.org>.
malaxiaolongxia removed a comment on issue #5458:
URL: https://github.com/apache/shardingsphere/issues/5458#issuecomment-626524201
Today I installed mysql in my test environment then the test code is work,
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] malaxiaolongxia commented on issue #5458: scaling incrementalSyncTask is stuck
Posted by GitBox <gi...@apache.org>.
malaxiaolongxia commented on issue #5458:
URL: https://github.com/apache/shardingsphere/issues/5458#issuecomment-626524201
Today I installed mysql in my test environment then the test code is work,
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] malaxiaolongxia commented on issue #5458: scaling incrementalSyncTask is stuck
Posted by GitBox <gi...@apache.org>.
malaxiaolongxia commented on issue #5458:
URL: https://github.com/apache/shardingsphere/issues/5458#issuecomment-625606719
Here is my test code,when i run it , it never print ok and always wait expected response
```public class MysqlClientTest {
public static void main(String[] args) {
MySQLClient mySQLClient = new MySQLClient(2103316, "xxxx", 3306, "mall_test_m_rw", "mall_test_m_rw");
mySQLClient.connect();
mySQLClient.subscribe("mariadb-bin.000617", 790748916);
System.out.println("ok");
}
}
`show variables like '%server_id%';` then value is 2103316
`show master status;` then value is mariadb-bin.000617 790748916``
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] Lucas-307 commented on issue #5458: scaling incrementalSyncTask is stuck
Posted by GitBox <gi...@apache.org>.
Lucas-307 commented on issue #5458:
URL: https://github.com/apache/shardingsphere/issues/5458#issuecomment-630602607
@malaxiaolongxia Maybe you can try any other server_id to new MySQLClient.
`show variables like '%server_id%';` is select master server_id, MySQLClient is a slave, we don't have to use the same id.
By the way, I tried the same server_id as my master, it still work. So I'm not sure my answer is correct, maybe it also effected by db version.
Just try.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] malaxiaolongxia edited a comment on issue #5458: scaling incrementalSyncTask is stuck
Posted by GitBox <gi...@apache.org>.
malaxiaolongxia edited a comment on issue #5458:
URL: https://github.com/apache/shardingsphere/issues/5458#issuecomment-625606719
Here is my test code,when i run it , it never print ok and always wait expected response MySQLOKPacket
```public class MysqlClientTest {
public static void main(String[] args) {
MySQLClient mySQLClient = new MySQLClient(2103316, "xxxx", 3306, "mall_test_m_rw", "mall_test_m_rw");
mySQLClient.connect();
mySQLClient.subscribe("mariadb-bin.000617", 790748916);
System.out.println("ok");
}
}
`show variables like '%server_id%';` then value is 2103316
`show master status;` then value is mariadb-bin.000617 790748916``
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] malaxiaolongxia commented on issue #5458: scaling incrementalSyncTask is stuck
Posted by GitBox <gi...@apache.org>.
malaxiaolongxia commented on issue #5458:
URL: https://github.com/apache/shardingsphere/issues/5458#issuecomment-626530384
Today I installed mysql in my test environment and the test code worded,It's a little different than before
- I use mysql instead of mariadb
- The data is less than before ,mysql has one database and one record while mariadb has about 100 database and 5E records.
Hope to resolve the issue
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] malaxiaolongxia edited a comment on issue #5458: scaling incrementalSyncTask is stuck
Posted by GitBox <gi...@apache.org>.
malaxiaolongxia edited a comment on issue #5458:
URL: https://github.com/apache/shardingsphere/issues/5458#issuecomment-626530384
Today I installed mysql in my test environment and the test code worked,It's a little different than before
- I use mysql instead of mariadb
- The data is less than before ,mysql has one database and one record while mariadb has about 100 database and 5E records.
Hope to help you resolve the issue
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] KomachiSion commented on issue #5458: scaling incrementalSyncTask is stuck
Posted by GitBox <gi...@apache.org>.
KomachiSion commented on issue #5458:
URL: https://github.com/apache/shardingsphere/issues/5458#issuecomment-626416120
Theoretically, the protocol between mysql and mariadb should be the same.
The reason why it cannot be connected may be the error caused by the difference in the configuration of `abilities`. Need to be checked in detail.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] malaxiaolongxia edited a comment on issue #5458: scaling incrementalSyncTask is stuck
Posted by GitBox <gi...@apache.org>.
malaxiaolongxia edited a comment on issue #5458:
URL: https://github.com/apache/shardingsphere/issues/5458#issuecomment-626530384
Today I installed mysql in my test environment and the test code worked,It's a little different than before
- I use mysql instead of mariadb
- The data is less than before ,mysql has one database and one record while mariadb has about 100 database and 5E records.
Hope to resolve the issue
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] ssxlulu commented on issue #5458: scaling incrementalSyncTask is stuck
Posted by GitBox <gi...@apache.org>.
ssxlulu commented on issue #5458:
URL: https://github.com/apache/shardingsphere/issues/5458#issuecomment-626437375
Can you provide TCP packet for further information?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] terrymanu commented on issue #5458: scaling incrementalSyncTask is stuck
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #5458:
URL: https://github.com/apache/shardingsphere/issues/5458#issuecomment-645167594
Closed because of no response anymore
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org