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 2022/01/13 10:11:24 UTC
[GitHub] [shardingsphere] newchendb opened a new issue #14744: [shardingsphere-proxy] . The property set in server.yaml is inconsistent with the mysql variable query
newchendb opened a new issue #14744:
URL: https://github.com/apache/shardingsphere/issues/14744
shardingsphere-proxy version is 5.1.1。
server.yaml:
```
mode:
type: Standalone
rules:
- !AUTHORITY
users:
- root@%:123456
provider:
type: ALL_PRIVILEGES_PERMITTED
- !TRANSACTION
defaultType: BASE
providerType: seata
```
But the query “show variable transaction_type” result is “LOCAL”。
--
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 #14744: [shardingsphere-proxy] . The property set in server.yaml is inconsistent with the mysql variable query
Posted by GitBox <gi...@apache.org>.
zjcnb commented on issue #14744:
URL: https://github.com/apache/shardingsphere/issues/14744#issuecomment-1012162290
@newchendb Hi , thank you for your feedback, your `ShardingSphere-Proxy` are `5.1.1` version? I think this version are not exist. Can you confirm it? By the way, I use XA and Standalone mode is ok in master branch. I will check BASE.
--
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] newchendb commented on issue #14744: [shardingsphere-proxy] . The property set in server.yaml is inconsistent with the mysql variable query
Posted by GitBox <gi...@apache.org>.
newchendb commented on issue #14744:
URL: https://github.com/apache/shardingsphere/issues/14744#issuecomment-1012902290
@zjcnb
For the same configuration, an error will be reported with version 5.0.0 :
```
Exception in thread "main" org.apache.shardingsphere.spi.exception.ServiceProviderNotFoundException: No implementation class load from SPI `org.apache.shardingsphere.transaction.xa.spi.XATransactionManagerProvider` with type `seata`.
at org.apache.shardingsphere.spi.typed.TypedSPIRegistry.getRegisteredService(TypedSPIRegistry.java:76)
at org.apache.shardingsphere.transaction.xa.manager.XATransactionManagerProviderLoader.getXATransactionManagerProvider(XATransactionManagerProviderLoader.java:58)
at org.apache.shardingsphere.transaction.xa.XAShardingSphereTransactionManager.init(XAShardingSphereTransactionManager.java:54)
at org.apache.shardingsphere.transaction.ShardingSphereTransactionManagerEngine.lambda$init$0(ShardingSphereTransactionManagerEngine.java:71)
at java.util.Map.forEach(Map.java:630)
at org.apache.shardingsphere.transaction.ShardingSphereTransactionManagerEngine.init(ShardingSphereTransactionManagerEngine.java:71)
at org.apache.shardingsphere.mode.manager.standalone.StandaloneContextManagerBuilder.createTransactionContexts(StandaloneContextManagerBuilder.java:183)
at org.apache.shardingsphere.mode.manager.standalone.StandaloneContextManagerBuilder.build(StandaloneContextManagerBuilder.java:80)
at org.apache.shardingsphere.proxy.initializer.BootstrapInitializer.initContext(BootstrapInitializer.java:77)
at org.apache.shardingsphere.proxy.initializer.BootstrapInitializer.init(BootstrapInitializer.java:68)
at org.apache.shardingsphere.proxy.Bootstrap.main(Bootstrap.java:47)
```
There is another situation, the first time configuration is effective. However, the configuration was changed and restarted, and the configuration did not change. Even passwords.
--
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 #14744: [shardingsphere-proxy] . The property set in server.yaml is inconsistent with the mysql variable query
Posted by GitBox <gi...@apache.org>.
zjcnb commented on issue #14744:
URL: https://github.com/apache/shardingsphere/issues/14744#issuecomment-1015054496
`shardingsphere-proxy-bootstrap pom.xml` add dependency.
```
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>shardingsphere-transaction-base-seata-at</artifactId>
<version>${project.version}</version>
</dependency>
```
--
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] newchendb commented on issue #14744: [shardingsphere-proxy] . The property set in server.yaml is inconsistent with the mysql variable query
Posted by GitBox <gi...@apache.org>.
newchendb commented on issue #14744:
URL: https://github.com/apache/shardingsphere/issues/14744#issuecomment-1016149067
thank you
--
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] newchendb commented on issue #14744: [shardingsphere-proxy] . The property set in server.yaml is inconsistent with the mysql variable query
Posted by GitBox <gi...@apache.org>.
newchendb commented on issue #14744:
URL: https://github.com/apache/shardingsphere/issues/14744#issuecomment-1012902655
I will try it with 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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] newchendb commented on issue #14744: [shardingsphere-proxy] . The property set in server.yaml is inconsistent with the mysql variable query
Posted by GitBox <gi...@apache.org>.
newchendb commented on issue #14744:
URL: https://github.com/apache/shardingsphere/issues/14744#issuecomment-1015041318
@zjcnb Thank you. The problem that the configuration does not take effect has been solved.
```
- !TRANSACTION
defaultType: BASE
providerType: seata
```
Another problem is to help you look at the configured BASE transaction, but the following error is reported.
```
Exception in thread "main" org.apache.shardingsphere.spi.exception.ServiceProviderNotFoundException: No implementation class load from SPI `org.apache.shardingsphere.transaction.xah type `seata`.
at org.apache.shardingsphere.spi.typed.TypedSPIRegistry.getRegisteredService(TypedSPIRegistry.java:76)
at org.apache.shardingsphere.transaction.xa.manager.XATransactionManagerProviderLoader.getXATransactionManagerProvider(XATransactionManagerProviderLoader.java:58)
at org.apache.shardingsphere.transaction.xa.XAShardingSphereTransactionManager.init(XAShardingSphereTransactionManager.java:55)
at org.apache.shardingsphere.transaction.ShardingSphereTransactionManagerEngine.lambda$init$0(ShardingSphereTransactionManagerEngine.java:71)
at java.util.Map.forEach(Map.java:630)
at org.apache.shardingsphere.transaction.ShardingSphereTransactionManagerEngine.init(ShardingSphereTransactionManagerEngine.java:71)
at org.apache.shardingsphere.transaction.context.TransactionContextsBuilder.build(TransactionContextsBuilder.java:54)
at org.apache.shardingsphere.mode.manager.standalone.StandaloneContextManagerBuilder.build(StandaloneContextManagerBuilder.java:79)
at org.apache.shardingsphere.proxy.initializer.BootstrapInitializer.initContext(BootstrapInitializer.java:76)
at org.apache.shardingsphere.proxy.initializer.BootstrapInitializer.init(BootstrapInitializer.java:67)
at org.apache.shardingsphere.proxy.Bootstrap.main(Bootstrap.java: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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] newchendb commented on issue #14744: [shardingsphere-proxy] . The property set in server.yaml is inconsistent with the mysql variable query
Posted by GitBox <gi...@apache.org>.
newchendb commented on issue #14744:
URL: https://github.com/apache/shardingsphere/issues/14744#issuecomment-1012663306
@zjcnb Hi,My packaged branch is 5.1.0-release,Packaging result display 5.1.1-SNAPSHOT 。
--
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 edited a comment on issue #14744: [shardingsphere-proxy] . The property set in server.yaml is inconsistent with the mysql variable query
Posted by GitBox <gi...@apache.org>.
zjcnb edited a comment on issue #14744:
URL: https://github.com/apache/shardingsphere/issues/14744#issuecomment-1012162290
@newchendb Hi , thank you for your feedback, your `ShardingSphere-Proxy` are `5.1.1` version? I think this version are not exist. Can you confirm it? By the way, I use XA and Standalone mode is ok in master branch. I will check BASE.
![image](https://user-images.githubusercontent.com/33742097/149344147-0062b7b9-e7c1-4fc4-a21c-faa10b3cf105.png)
--
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 #14744: [shardingsphere-proxy] . The property set in server.yaml is inconsistent with the mysql variable query
Posted by GitBox <gi...@apache.org>.
zjcnb commented on issue #14744:
URL: https://github.com/apache/shardingsphere/issues/14744#issuecomment-1012844907
>
@newchendb Can you try it with `master` branch? The 5.1.0-release unavailable now.
--
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] newchendb closed issue #14744: [shardingsphere-proxy] . The property set in server.yaml is inconsistent with the mysql variable query
Posted by GitBox <gi...@apache.org>.
newchendb closed issue #14744:
URL: https://github.com/apache/shardingsphere/issues/14744
--
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] newchendb commented on issue #14744: [shardingsphere-proxy] . The property set in server.yaml is inconsistent with the mysql variable query
Posted by GitBox <gi...@apache.org>.
newchendb commented on issue #14744:
URL: https://github.com/apache/shardingsphere/issues/14744#issuecomment-1015029397
@zjcnb It is strange that the modification of the configuration file does not take effect.Have you ever encountered this situation in agent mode.
--
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] newchendb commented on issue #14744: [shardingsphere-proxy] . The property set in server.yaml is inconsistent with the mysql variable query
Posted by GitBox <gi...@apache.org>.
newchendb commented on issue #14744:
URL: https://github.com/apache/shardingsphere/issues/14744#issuecomment-1015035095
shardingsphere-5.0.0-beta is relatively normal, and higher versions always encounter various strange problems.
--
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 #14744: [shardingsphere-proxy] . The property set in server.yaml is inconsistent with the mysql variable query
Posted by GitBox <gi...@apache.org>.
zjcnb commented on issue #14744:
URL: https://github.com/apache/shardingsphere/issues/14744#issuecomment-1015035519
```
mode:
type: Standalone
repository:
type: File
overwrite: true
```
Change overwrite is true and try it again.
--
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