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/10/10 06:30:31 UTC
[GitHub] [shardingsphere] novice-gamer opened a new issue, #16795: Version problem
novice-gamer opened a new issue, #16795:
URL: https://github.com/apache/shardingsphere/issues/16795
# Problem background
The shardingsphere proxy (version 5.1.0) is configured with zookeeper。
- This is version 5.1.0 of the connection
```sql
mysql> use customer_delivery_dev;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show schema resources;
+------+-------+-------------+------+-----------------------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| name | type | host | port | db | connection_timeout_milliseconds | idle_timeout_milliseconds | max_lifetime_milliseconds | max_pool_size | min_pool_size | read_only | other_attributes |
+------+-------+-------------+------+-----------------------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| ds_0 | MySQL | 192.168.1.6 | 3306 | customer_delivery_dev | 30000 | 60000 | 2100000 | 50 | 1 | false | {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","useSSL":"false","rewriteBatchedStatements":"true","cacheResultSetMetadata":"false","useLocalSessionState":"true","maintainTimeStats":"false","prepStmtCacheSize":"200000","tinyInt1isBit":"false","prepStmtCacheSqlLimit":"2048","serverTimezone":"UTC","netTimeoutForStreamingResults":"0"},"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"allowPoolSuspension":false,"autoCommit":true,"isolateInternalQueries":false} |
+------+-------+-------------+------+-----------------------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql>
```
After that, I downloaded the latest version 5.1.1 and used the same zookeeper.
Although you can log in with the same user name and password, there are no data sources
- This is version 5.1.1 of the connection
```sql
mysql> use customer_delivery_dev;
Database changed
mysql> show schema resources;
Empty set (0.00 sec)
mysql>
```
-------
5.1.1 version configuration file：
```yaml
mode:
type: Cluster
repository:
type: ZooKeeper
props:
namespace: governance_ds
server-lists: zk_host:2181
retryIntervalMilliseconds: 500
timeToLiveSeconds: 60
maxRetries: 3
operationTimeoutMilliseconds: 500
overwrite: false
```
Excuse me, are the versions incompatible or do you need to configure other parameters?
--
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 #16795: Version problem
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #16795:
URL: https://github.com/apache/shardingsphere/issues/16795#issuecomment-1272350026
Hello , this issue has not received a reply for several days.
This issue is supposed to be closed.
--
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 #16795: Version problem
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #16795:
URL: https://github.com/apache/shardingsphere/issues/16795#issuecomment-1099891704
@zjcnb Got it, 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] novice-gamer commented on issue #16795: Version problem
Posted by GitBox <gi...@apache.org>.
novice-gamer commented on issue #16795:
URL: https://github.com/apache/shardingsphere/issues/16795#issuecomment-1098628591
OK, thanks for your answer
--
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] novice-gamer closed issue #16795: Version problem
Posted by GitBox <gi...@apache.org>.
novice-gamer closed issue #16795: Version problem
URL: https://github.com/apache/shardingsphere/issues/16795
--
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 #16795: Version problem
Posted by GitBox <gi...@apache.org>.
zjcnb commented on issue #16795:
URL: https://github.com/apache/shardingsphere/issues/16795#issuecomment-1097890807
@novice-gamer Hi, thank for your feedback. 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] zjcnb commented on issue #16795: Version problem
Posted by GitBox <gi...@apache.org>.
zjcnb commented on issue #16795:
URL: https://github.com/apache/shardingsphere/issues/16795#issuecomment-1099879606
> > `/metadata/test/test/versions/0/dataSources`.
>
> Hi @zjcnb , what's the difference bewteen the two 'test'?
@RaigorJiang Hi, because it add database concept. The one is `database name` and another is `schema name`
--
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 #16795: Version problem
Posted by GitBox <gi...@apache.org>.
zjcnb commented on issue #16795:
URL: https://github.com/apache/shardingsphere/issues/16795#issuecomment-1097984467
The `ZooKeeper` center are adjustment, the `5.1.0` get data source path are : `/metadata/test/versions/0/dataSources`. But the `5.1.1` version to get data source path are : `/metadata/test/test/versions/0/dataSources`.
--
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 #16795: Version problem
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #16795:
URL: https://github.com/apache/shardingsphere/issues/16795#issuecomment-1098035327
> `/metadata/test/test/versions/0/dataSources`.
Hi @zjcnb , what's the difference bewteen the two 'test'?
--
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] github-actions[bot] closed issue #16795: Version problem
Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #16795: Version problem
URL: https://github.com/apache/shardingsphere/issues/16795
--
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