You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "azexcy (via GitHub)" <gi...@apache.org> on 2023/07/24 03:10:09 UTC
[GitHub] [shardingsphere] azexcy opened a new issue, #27403: The CSN value is a little confusing when using openGauss with GLT
azexcy opened a new issue, #27403:
URL: https://github.com/apache/shardingsphere/issues/27403
## Question
When using openGauss with GLT, I find the change in the CSN value is not well understood, I'm not sure that's a problem, because everything else is fine.
When transactions are turned on manually, the CSN value is retrieved from redis. just like
```
begin;
...
...
commit;
```
but when without transaction, the CSN value will not retrieved from redis.
As you can see in this screenshot below.
And I debug at local, When transactions are not manually turned on, they don't go to this method
Here is my config
```
mode:
type: Cluster
repository:
type: ZooKeeper
props:
namespace: cdc_demo
server-lists: localhost:2181
retryIntervalMilliseconds: 500
timeToLiveSeconds: 60
maxRetries: 3
operationTimeoutMilliseconds: 500
authority:
users:
- user: root@%
password: root
privilege:
type: ALL_PERMITTED
transaction:
defaultType: XA
providerType: Atomikos
sqlParser:
sqlCommentParseEnabled: false
sqlStatementCache:
initialCapacity: 2000
maximumSize: 65535
parseTreeCache:
initialCapacity: 128
maximumSize: 1024
globalClock:
enabled: true
type: TSO
provider: redis
props:
host: 127.0.0.1
port: 6379
logging:
loggers:
- loggerName: ShardingSphere-SQL
additivity: true
level: INFO
props:
enable: false
sqlFederation:
sqlFederationEnabled: false
executionPlanCache:
initialCapacity: 2000
maximumSize: 65535
props:
system-log-level: INFO
max-connections-size-per-query: 1
kernel-executor-size: 16 # Infinite by default.
proxy-frontend-flush-threshold: 128 # The default value is 128.
# sql-show is the same as props in logger ShardingSphere-SQL, and its priority is lower than logging rule
sql-show: false
check-table-metadata-enabled: false
# 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
proxy-frontend-executor-size: 0 # Proxy frontend executor size. The default value is 0, which means let Netty decide.
proxy-frontend-max-connections: 0 # Less than or equal to 0 means no limitation.
proxy-default-port: 3307 # Proxy default port.
proxy-netty-backlog: 1024 # Proxy netty backlog.
cdc-server-port: 33071 # CDC server port
proxy-frontend-ssl-enabled: false
proxy-frontend-ssl-cipher: ''
proxy-frontend-ssl-version: TLSv1.2,TLSv1.3
proxy-frontend-database-protocol-type: openGauss
```
and I also add redis GLT dependency.
<img width="765" alt="image" src="https://github.com/apache/shardingsphere/assets/101622833/bfed523c-4ed2-4613-98a5-7dcf6218e21d">
<img width="954" alt="image" src="https://github.com/apache/shardingsphere/assets/101622833/7f0b4369-313b-49ed-acea-a30f544c4a8d">
--
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.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] github-actions[bot] commented on issue #27403: The CSN value is a little confusing when using openGauss with GLT
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #27403:
URL: https://github.com/apache/shardingsphere/issues/27403#issuecomment-1690563683
There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.
--
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
Re: [I] The CSN value is a little confusing when using openGauss with GLT [shardingsphere]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #27403:
URL: https://github.com/apache/shardingsphere/issues/27403#issuecomment-1783444614
There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.
--
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
Re: [I] The CSN value is a little confusing when using openGauss with GLT [shardingsphere]
Posted by "FlyingZC (via GitHub)" <gi...@apache.org>.
FlyingZC closed issue #27403: The CSN value is a little confusing when using openGauss with GLT
URL: https://github.com/apache/shardingsphere/issues/27403
--
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
Re: [I] The CSN value is a little confusing when using openGauss with GLT [shardingsphere]
Posted by "FlyingZC (via GitHub)" <gi...@apache.org>.
FlyingZC commented on issue #27403:
URL: https://github.com/apache/shardingsphere/issues/27403#issuecomment-1818124421
Currently, it is not supported to change the CSN without transactions. `insert...values` spans multiple nodes, xa transactions are implicitly enabled, so it can change the CSN.
--
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
Re: [I] The CSN value is a little confusing when using openGauss with GLT [shardingsphere]
Posted by "azexcy (via GitHub)" <gi...@apache.org>.
azexcy commented on issue #27403:
URL: https://github.com/apache/shardingsphere/issues/27403#issuecomment-1809779318
After test, i find bulk insert will get CSN from glt, just like
```
INSERT INTO t_order (id, c_int, c_smallint, c_float, c_double, c_numeric, c_boolean,c_char, c_text)VALUES (11, 2, 3, 4, 5, 6.00, true, 'c_char', 'c_text'),(12, 22, 33, 44, 55, 7.00, true, 'c_char', 'c_text');
```
different database CSN is equals.
--
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