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 2021/11/12 09:55:27 UTC
[GitHub] [shardingsphere] penghuazhou opened a new issue #13575: How to user local transaction in shardingsphere-proxy 5.0.0?
penghuazhou opened a new issue #13575:
URL: https://github.com/apache/shardingsphere/issues/13575
Can I user Local transaction like this in shardingshpere-proxy 5.0.0?
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] zjcnb commented on issue #13575: How to user local transaction in shardingsphere-proxy 5.0.0?
Posted by GitBox <gi...@apache.org>.
zjcnb commented on issue #13575:
URL: https://github.com/apache/shardingsphere/issues/13575#issuecomment-967011720
@penghuazhou Hi, you needn't set Local. Because Local are ShardingSphere default transaction type.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] penghuazhou edited a comment on issue #13575: How to user local transaction in shardingsphere-proxy 5.0.0?
Posted by GitBox <gi...@apache.org>.
penghuazhou edited a comment on issue #13575:
URL: https://github.com/apache/shardingsphere/issues/13575#issuecomment-969941550
@RaigorJiang, It alse have Atomikos logs, when I disabled registry.
[WARN ] 2021-11-16 15:12:40.022 [main] c.a.icatch.provider.imp.AssemblerImp - Th
anks for using Atomikos! Evaluate http://www.atomikos.com/Main/ExtremeTransactio
ns for advanced features and professional support
or register at http://www.atomikos.com/Main/RegisterYourDownload to disable this
message and receive FREE tips & advice
[WARN ] 2021-11-16 15:12:40.022 [main] c.a.icatch.provider.imp.AssemblerImp - Th
anks for using Atomikos! Evaluate http://www.atomikos.com/Main/ExtremeTransactio
ns for advanced features and professional support
or register at http://www.atomikos.com/Main/RegisterYourDownload to disable this
message and receive FREE tips & advice
Thanks for using Atomikos! Evaluate http://www.atomikos.com/Main/ExtremeTransact
ions for advanced features and professional support
or register at http://www.atomikos.com/Main/RegisterYourDownload to disable this
message and receive FREE tips & advice
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #13575: How to user local transaction in shardingsphere-proxy 5.0.0?
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #13575:
URL: https://github.com/apache/shardingsphere/issues/13575#issuecomment-969960235
> @RaigorJiang, It alse have Atomikos logs, when I disabled registry.
OK, I will check it.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] penghuazhou closed issue #13575: How to user local transaction in shardingsphere-proxy 5.0.0?
Posted by GitBox <gi...@apache.org>.
penghuazhou closed issue #13575:
URL: https://github.com/apache/shardingsphere/issues/13575
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] penghuazhou commented on issue #13575: How to user local transaction in shardingsphere-proxy 5.0.0?
Posted by GitBox <gi...@apache.org>.
penghuazhou commented on issue #13575:
URL: https://github.com/apache/shardingsphere/issues/13575#issuecomment-970036837
thanks very mush
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #13575: How to user local transaction in shardingsphere-proxy 5.0.0?
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #13575:
URL: https://github.com/apache/shardingsphere/issues/13575#issuecomment-970003975
Hi @penghuazhou ,
Indeed, as you reported, the proxy loads Atomikos, but the actual transaction type used is not affected by this.
You can execute the following statement to query the currently used transaction type:
```sql
mysql> show variable transaction_type;
+------------------+
| transaction_type |
+------------------+
| LOCAL |
+------------------+
1 row in set (0.01 sec)
```
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] penghuazhou closed issue #13575: How to user local transaction in shardingsphere-proxy 5.0.0?
Posted by GitBox <gi...@apache.org>.
penghuazhou closed issue #13575:
URL: https://github.com/apache/shardingsphere/issues/13575
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] penghuazhou commented on issue #13575: How to user local transaction in shardingsphere-proxy 5.0.0?
Posted by GitBox <gi...@apache.org>.
penghuazhou commented on issue #13575:
URL: https://github.com/apache/shardingsphere/issues/13575#issuecomment-969904400
@RaigorJiang, Why there have Atomikos logs when i config like below? Does shardingshpere-proxy use Atomikos to manage Local TRANSACTION?
Thanks for using Atomikos! Evaluate http://www.atomikos.com/Main/ExtremeTransactions for advanced features and professional support
or register at http://www.atomikos.com/Main/RegisterYourDownload to disable this message and receive FREE tips & advice
[INFO ] 2021-11-15 19:44:40.995 [main] o.a.s.p.i.i.AbstractBootstrapInitializer - Database name is PostgreSQL, version is 9.2.24
[INFO ] 2021-11-15 19:44:41.227 [main] o.a.s.p.frontend.ShardingSphereProxy - ShardingSphere-Proxy start success.
Thanks for using Atomikos! Evaluate http://www.atomikos.com/Main/ExtremeTransactions for advanced features and professional support
or register at http://www.atomikos.com/Main/RegisterYourDownload to disable this message and receive FREE tips & advice
[INFO ] 2021-11-15 19:48:02.450 [main] o.a.s.p.i.i.AbstractBootstrapInitializer - Database name is PostgreSQL, version is 9.2.24
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #13575: How to user local transaction in shardingsphere-proxy 5.0.0?
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #13575:
URL: https://github.com/apache/shardingsphere/issues/13575#issuecomment-968286550
You can change the type to LOCAL, or comment out the `!TRANSACTION` rule configuration, because LOCAL will be used by default.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] penghuazhou commented on issue #13575: How to user local transaction in shardingsphere-proxy 5.0.0?
Posted by GitBox <gi...@apache.org>.
penghuazhou commented on issue #13575:
URL: https://github.com/apache/shardingsphere/issues/13575#issuecomment-969941550
@RaigorJiang, It alse have Atomikos logs, when I disabled registry.
[WARN ] 2021-11-16 15:12:40.022 [main] c.a.icatch.provider.imp.AssemblerImp - Th
anks for using Atomikos! Evaluate http://www.atomikos.com/Main/ExtremeTransactio
ns for advanced features and professional support
or register at http://www.atomikos.com/Main/RegisterYourDownload to disable this
message and receive FREE tips & advice
[WARN ] 2021-11-16 15:12:40.022 [main] c.a.icatch.provider.imp.AssemblerImp - Th
anks for using Atomikos! Evaluate http://www.atomikos.com/Main/ExtremeTransactio
ns for advanced features and professional support
or register at http://www.atomikos.com/Main/RegisterYourDownload to disable this
message and receive FREE tips & advice
Thanks for using Atomikos! Evaluate http://www.atomikos.com/Main/ExtremeTransact
ions for advanced features and professional support
or register at http://www.atomikos.com/Main/RegisterYourDownload to disable this
message and receive FREE tips & advice
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #13575: How to user local transaction in shardingsphere-proxy 5.0.0?
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #13575:
URL: https://github.com/apache/shardingsphere/issues/13575#issuecomment-969931068
Hi @penghuazhou
Please check your `mode` configuration. If the registry is enabled and `overwrite` is false, then the registry configuration will be used to start the proxy instead of your local configuration file.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] penghuazhou commented on issue #13575: How to user local transaction in shardingsphere-proxy 5.0.0?
Posted by GitBox <gi...@apache.org>.
penghuazhou commented on issue #13575:
URL: https://github.com/apache/shardingsphere/issues/13575#issuecomment-968510608
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org