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/04 06:08:11 UTC
[GitHub] [shardingsphere] ccw55ccw opened a new issue #13455: LOCAL TransationType unable to enable
ccw55ccw opened a new issue #13455:
URL: https://github.com/apache/shardingsphere/issues/13455
here server.xml:
scaling:
blockQueueSize: 10000
workerThread: 40
clusterAutoSwitchAlgorithm:
type: IDLE
props:
incremental-task-idle-minute-threshold: 30
dataConsistencyCheckAlgorithm:
type: DEFAULT
mode:
type: Cluster
repository:
type: ZooKeeper
props:
namespace: governance_ds
server-lists: local.zookeeper.cn:2181
retryIntervalMilliseconds: 500
timeToLiveSeconds: 60
maxRetries: 3
operationTimeoutMilliseconds: 500
overwrite: false
rules:
- !AUTHORITY
users:
- root@%:123456
- test@%:yunnex
- sharding@:sharding
provider:
type: ALL_PRIVILEGES_PERMITTED
- !TRANSACTION
defaultType: LOCAL
props:
max-connections-size-per-query: 1
kernel-executor-size: 16 # Infinite by default.
proxy-frontend-flush-threshold: 128 # The default value is 128.
proxy-opentracing-enabled: false
proxy-hint-enabled: false
sql-show: false
check-table-metadata-enabled: true
lock-wait-timeout-milliseconds: 50000 # The maximum time to wait for a lock
show-process-list-enabled: true
# Proxy backend query fetch size. A larger value may increase the memory usage of ShardingSphere Proxy.
# The default value is -1, which means set the minimum value for different JDBC drivers.
proxy-backend-query-fetch-size: -1
check-duplicate-table-enabled: false
sql-comment-parse-enabled: false
proxy-frontend-executor-size: 0 # Proxy frontend executor size. The default value is 0, which means let Netty decide.
# Available options of proxy backend executor suitable: OLAP(default), OLTP. The OLTP option may reduce time cost of writing packets to client, but it may increase the latency of SQL execution
# if client connections are more than proxy-frontend-netty-executor-size, especially executing slow SQL.
proxy-backend-executor-suitable: OLAP
proxy-frontend-max-connections: 20 # Less than or equal to 0 means no limitation.
sql-federation-enabled: false
start log:
[INFO ] 2021-11-04 14:04:13.919 [main-EventThread] o.a.c.f.state.ConnectionStateManager - State change: CONNECTED
[INFO ] 2021-11-04 14:04:14.046 [main-EventThread] o.a.c.framework.imps.EnsembleTracker - New config event received: {}
[INFO ] 2021-11-04 14:04:14.046 [main-EventThread] o.a.c.framework.imps.EnsembleTracker - New config event received: {}
WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflective access by org.codehaus.groovy.reflection.CachedClass (file:/C:/Users/Awoo/.m2/repository/org/codehaus/groovy/groovy/2.4.19/groovy-2.4.19-indy.jar) to method java.lang.Object.finalize()
WARNING: Please consider reporting this to the maintainers of org.codehaus.groovy.reflection.CachedClass
WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
WARNING: All illegal access operations will be denied in a future release
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
--
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] TeslaCN commented on issue #13455: LOCAL TransationType unable to enable
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #13455:
URL: https://github.com/apache/shardingsphere/issues/13455#issuecomment-960603964
Just remove the following blocks, and then the LOCAL transaction will be enabled.
```
- !TRANSACTION
defaultType: 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] ccw55ccw commented on issue #13455: LOCAL TransationType unable to enable
Posted by GitBox <gi...@apache.org>.
ccw55ccw commented on issue #13455:
URL: https://github.com/apache/shardingsphere/issues/13455#issuecomment-961569893
> Just remove the following blocks, and then the LOCAL transaction will be enabled.
>
> ```
> - !TRANSACTION
> defaultType: LOCAL
> ```
i have tried,it doesn't work,AtomikosTransactionManager always registed.
--
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] TeslaCN commented on issue #13455: LOCAL TransationType unable to enable
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #13455:
URL: https://github.com/apache/shardingsphere/issues/13455#issuecomment-974593103
Don't worry if you see the log about Atomikos, the Proxy will still use the LOCAL transaction.
I'm closing this due to no response.
--
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 #13455: LOCAL TransationType unable to enable
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #13455:
URL: https://github.com/apache/shardingsphere/issues/13455#issuecomment-962012668
--
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] TeslaCN closed issue #13455: LOCAL TransationType unable to enable
Posted by GitBox <gi...@apache.org>.
TeslaCN closed issue #13455:
URL: https://github.com/apache/shardingsphere/issues/13455
--
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 #13455: LOCAL TransationType unable to enable
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #13455:
URL: https://github.com/apache/shardingsphere/issues/13455#issuecomment-962012668
> mode:
type: Cluster
repository:
type: ZooKeeper
props:
namespace: governance_ds
server-lists: local.zookeeper.cn:2181
retryIntervalMilliseconds: 500
timeToLiveSeconds: 60
maxRetries: 3
operationTimeoutMilliseconds: 500
overwrite: false
@wangeDear You need to change the `overwrite` to `true`.
--
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 #13455: LOCAL TransationType unable to enable
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #13455:
URL: https://github.com/apache/shardingsphere/issues/13455#issuecomment-963887918
Hi @wangeDear
If your problem is solved, can we close this 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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] TeslaCN closed issue #13455: LOCAL TransationType unable to enable
Posted by GitBox <gi...@apache.org>.
TeslaCN closed issue #13455:
URL: https://github.com/apache/shardingsphere/issues/13455
--
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 #13455: LOCAL TransationType unable to enable
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #13455:
URL: https://github.com/apache/shardingsphere/issues/13455#issuecomment-974603711
I would like to add that users can view the currently used transaction type through `show variable 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] RaigorJiang commented on issue #13455: LOCAL TransationType unable to enable
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #13455:
URL: https://github.com/apache/shardingsphere/issues/13455#issuecomment-974603711
I would like to add that users can view the currently used transaction type through `show variable 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] TeslaCN commented on issue #13455: LOCAL TransationType unable to enable
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #13455:
URL: https://github.com/apache/shardingsphere/issues/13455#issuecomment-974593103
Don't worry if you see the log about Atomikos, the Proxy will still use the LOCAL transaction.
I'm closing this due to no response.
--
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] ccw55ccw commented on issue #13455: LOCAL TransationType unable to enable
Posted by GitBox <gi...@apache.org>.
ccw55ccw commented on issue #13455:
URL: https://github.com/apache/shardingsphere/issues/13455#issuecomment-961569893
--
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