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/07/02 09:26:19 UTC
[GitHub] [shardingsphere] 1006572352 opened a new issue #6239: Unknown system variable 'transaction_isolation'
1006572352 opened a new issue #6239:
URL: https://github.com/apache/shardingsphere/issues/6239
----------------------------------------------------------------
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] tuohai666 commented on issue #6239: Make the version of ShardingProxy and DB cluster consistent
Posted by GitBox <gi...@apache.org>.
tuohai666 commented on issue #6239:
URL: https://github.com/apache/shardingsphere/issues/6239#issuecomment-654051496
@1006572352 The pr(https://github.com/apache/shardingsphere/pull/6270) that fix this problem is going to be merged. Would you like to have a test using master branch?
----------------------------------------------------------------
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] xbkaishui commented on issue #6239: Make the version of ShardingProxy and DB cluster consistent
Posted by GitBox <gi...@apache.org>.
xbkaishui commented on issue #6239:
URL: https://github.com/apache/shardingsphere/issues/6239#issuecomment-654020041
thanks :blush:
----------------------------------------------------------------
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] xbkaishui commented on issue #6239: Make the version of ShardingProxy and DB cluster consistent
Posted by GitBox <gi...@apache.org>.
xbkaishui commented on issue #6239:
URL: https://github.com/apache/shardingsphere/issues/6239#issuecomment-653997837
Hi anyone can help to review this bug fix. thanks
----------------------------------------------------------------
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] tuohai666 commented on issue #6239: Make the version of ShardingProxy and DB cluster consistent
Posted by GitBox <gi...@apache.org>.
tuohai666 commented on issue #6239:
URL: https://github.com/apache/shardingsphere/issues/6239#issuecomment-654137900
I have finished the test with MySQL server 5.6.47. It works well with connector/j 5.1.47.
----------------------------------------------------------------
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] kimmking commented on issue #6239: Unknown system variable 'transaction_isolation'
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #6239:
URL: https://github.com/apache/shardingsphere/issues/6239#issuecomment-653426821
MySQL8, tx_isolation -> transaction_isolation.
And in recent version, proxy return the version with mysql 8.
----------------------------------------------------------------
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] tuohai666 closed issue #6239: Make the version of ShardingProxy and DB cluster consistent
Posted by GitBox <gi...@apache.org>.
tuohai666 closed issue #6239:
URL: https://github.com/apache/shardingsphere/issues/6239
----------------------------------------------------------------
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] xbkaishui edited a comment on issue #6239: Make the version of ShardingProxy and DB cluster consistent
Posted by GitBox <gi...@apache.org>.
xbkaishui edited a comment on issue #6239:
URL: https://github.com/apache/shardingsphere/issues/6239#issuecomment-653997837
Hi anyone can help to review this bug fix ? thanks
----------------------------------------------------------------
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] tuohai666 commented on issue #6239: Make the version of ShardingProxy and DB cluster consistent
Posted by GitBox <gi...@apache.org>.
tuohai666 commented on issue #6239:
URL: https://github.com/apache/shardingsphere/issues/6239#issuecomment-654124230
@1006572352 Since you use mysql 5.6.x, please change the connector/j version to 5.1.12 instead of 5.1.47
----------------------------------------------------------------
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] 1006572352 commented on issue #6239: Unknown system variable 'transaction_isolation'
Posted by GitBox <gi...@apache.org>.
1006572352 commented on issue #6239:
URL: https://github.com/apache/shardingsphere/issues/6239#issuecomment-653386588
> @1006572352 Hi ShardingProxy would not try to find `transaction_isolation`. It just transfers the requests from users or APPs to the lower database cluster.
>
> > sharding-proxy are trying to find the variable ‘’transaction_isolation‘’，but mysql 5.6 don't have the variable 'transaction_isolation' instead of 'tx_isolation'。
but when I test sharding-proxy-4.0.1, it correctly identified parameter ‘tx_isolation’.
===logg/stdout.log
[INFO ] 14:55:37.382 [ShardingSphere-Command-0] ShardingSphere-SQL - Rule Type: sharding
[INFO ] 14:55:37.382 [ShardingSphere-Command-0] ShardingSphere-SQL - Logic SQL: /* mysql-connector-java-5.1.47 ( Revision: fe1903b1ecb4a96a917f7ed3190d80c049b1de29 ) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@collation_server AS collation_server, @@collation_connection AS collation_connection, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS transaction_isolation, @@wait_timeout AS wait_timeout
----------------------------------------------------------------
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] xbkaishui commented on issue #6239: Make the version of ShardingProxy and DB cluster consistent
Posted by GitBox <gi...@apache.org>.
xbkaishui commented on issue #6239:
URL: https://github.com/apache/shardingsphere/issues/6239#issuecomment-653557896
I have a question, why we set the CHARSET to utf8_general_ci in MySQLServerInfo ? can we change it to utf8mb4_unicode_ci to support like emoji ?
----------------------------------------------------------------
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] tuohai666 commented on issue #6239: Make the version of ShardingProxy and DB cluster consistent
Posted by GitBox <gi...@apache.org>.
tuohai666 commented on issue #6239:
URL: https://github.com/apache/shardingsphere/issues/6239#issuecomment-654011231
I'll review this pull request.
----------------------------------------------------------------
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] tuohai666 commented on issue #6239: Make the version of ShardingProxy and DB cluster consistent
Posted by GitBox <gi...@apache.org>.
tuohai666 commented on issue #6239:
URL: https://github.com/apache/shardingsphere/issues/6239#issuecomment-653578400
ok
----------------------------------------------------------------
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] 1006572352 closed issue #6239: Unknown system variable 'transaction_isolation'
Posted by GitBox <gi...@apache.org>.
1006572352 closed issue #6239:
URL: https://github.com/apache/shardingsphere/issues/6239
----------------------------------------------------------------
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] xbkaishui commented on issue #6239: Make the version of ShardingProxy and DB cluster consistent
Posted by GitBox <gi...@apache.org>.
xbkaishui commented on issue #6239:
URL: https://github.com/apache/shardingsphere/issues/6239#issuecomment-653556712
let me try, @tuohai666 please re-assign to me
----------------------------------------------------------------
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] tristaZero commented on issue #6239: Unknown system variable 'transaction_isolation'
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #6239:
URL: https://github.com/apache/shardingsphere/issues/6239#issuecomment-653442190
@1006572352 @kimmking
Thanks for your feedback.
It is sorted as a bug. Here is one of the recommended solutions, welcome everyone to try to fix it, and contribute to our community.
1. Get the version of MySQL servers deployed, like 5.7 by JDBC interface
2. Set the `SERVER_VERSION` in `MySQLServerInfo` class.
3. Therefore the versions of ShardingProxy and MySQL from the bottom are consistent.
----------------------------------------------------------------
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] 1006572352 closed issue #6239: Unknown system variable 'transaction_isolation'
Posted by GitBox <gi...@apache.org>.
1006572352 closed issue #6239:
URL: https://github.com/apache/shardingsphere/issues/6239
----------------------------------------------------------------
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] tristaZero commented on issue #6239: Unknown system variable 'transaction_isolation'
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #6239:
URL: https://github.com/apache/shardingsphere/issues/6239#issuecomment-653317869
@1006572352 Hi ShardingProxy would not try to find `transaction_isolation`. It just transfers the requests from users or APPs to the lower database cluster.
> sharding-proxy are trying to find the variable ‘’transaction_isolation‘’，but mysql 5.6 don't have the variable 'transaction_isolation' instead of 'tx_isolation'。
----------------------------------------------------------------
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