You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "90yangkang (via GitHub)" <gi...@apache.org> on 2023/05/26 02:20:26 UTC
[GitHub] [shardingsphere] 90yangkang opened a new issue, #25903: Mysql Database field inconsistent。
90yangkang opened a new issue, #25903:
URL: https://github.com/apache/shardingsphere/issues/25903
Mysql version : 5.7.18-cynos-log
Shardingsphere Proxy : 5.1.2
Description:
When select [page_put_path] , result hava it。
But when i select * , result not hava id .
![1685066785722_99A1EF72-CF3A-4ca5-A487-4E46261AB7BE](https://github.com/apache/shardingsphere/assets/35477514/6e4cf8fa-9079-4d4b-b440-25b1a589491f)
![1685066866948_8539D39E-B544-4447-97E6-19F9D3847539](https://github.com/apache/shardingsphere/assets/35477514/3b76f8b8-b658-4c7c-a356-5fce942c0f6d)
--
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] 90yangkang closed issue #25903: Mysql Database field inconsistent。
Posted by "90yangkang (via GitHub)" <gi...@apache.org>.
90yangkang closed issue #25903: Mysql Database field inconsistent。
URL: https://github.com/apache/shardingsphere/issues/25903
--
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] tuichenchuxin commented on issue #25903: Mysql Database field inconsistent。
Posted by "tuichenchuxin (via GitHub)" <gi...@apache.org>.
tuichenchuxin commented on issue #25903:
URL: https://github.com/apache/shardingsphere/issues/25903#issuecomment-1578465669
make sql-show: true, And we could see the actual sql is with comment.
--
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] tuichenchuxin commented on issue #25903: Mysql Database field inconsistent。
Posted by "tuichenchuxin (via GitHub)" <gi...@apache.org>.
tuichenchuxin commented on issue #25903:
URL: https://github.com/apache/shardingsphere/issues/25903#issuecomment-1582306065
I saw the actual SQL run on db_pre.
Seems route result it's correct.
--
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] tuichenchuxin commented on issue #25903: Mysql Database field inconsistent。
Posted by "tuichenchuxin (via GitHub)" <gi...@apache.org>.
tuichenchuxin commented on issue #25903:
URL: https://github.com/apache/shardingsphere/issues/25903#issuecomment-1583719136
> I saw the actual SQL run on db_pre. Seems route result it's correct.
If it is not executed through shardingsphere, the altered of the table will not be synchronized
--
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] 90yangkang commented on issue #25903: Mysql Database field inconsistent。
Posted by "90yangkang (via GitHub)" <gi...@apache.org>.
90yangkang commented on issue #25903:
URL: https://github.com/apache/shardingsphere/issues/25903#issuecomment-1582375781
> I saw the actual SQL run on db_pre. Seems route result it's correct.
yes ,SQL is executed without problems,This field was added later, and I guess it was caused by the metadata not syncing in time, which was an accidental phenomenon.
--
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] sandynz commented on issue #25903: Mysql Database field inconsistent。
Posted by "sandynz (via GitHub)" <gi...@apache.org>.
sandynz commented on issue #25903:
URL: https://github.com/apache/shardingsphere/issues/25903#issuecomment-1571536532
There's no configured sharding table, is `page_data_put` single table?
And `dataSources` name doesn't match `db_pre` in SQL.
It's better to paste real steps and configurations to re-produce 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] 90yangkang commented on issue #25903: Mysql Database field inconsistent。
Posted by "90yangkang (via GitHub)" <gi...@apache.org>.
90yangkang commented on issue #25903:
URL: https://github.com/apache/shardingsphere/issues/25903#issuecomment-1583793741
> > I saw the actual SQL run on db_pre. Seems route result it's correct.
>
> If it is not executed through shardingsphere, the altered of the table will not be synchronized
@tuichenchuxin Okay, I've got it . I added new fields through Navicat . Now, I understand that this operation is not appropriate. Thank you for your reply. I will 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] 90yangkang commented on issue #25903: Mysql Database field inconsistent。
Posted by "90yangkang (via GitHub)" <gi...@apache.org>.
90yangkang commented on issue #25903:
URL: https://github.com/apache/shardingsphere/issues/25903#issuecomment-1577878712
>
this is demo, On project ,dataSources same。
--
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] sandynz commented on issue #25903: Mysql Database field inconsistent。
Posted by "sandynz (via GitHub)" <gi...@apache.org>.
sandynz commented on issue #25903:
URL: https://github.com/apache/shardingsphere/issues/25903#issuecomment-1566356650
Hi @90yangkang , could you submit issue with [template]( https://raw.githubusercontent.com/apache/shardingsphere/master/.github/ISSUE_TEMPLATE/bug-report.md )? e.g. ShardingSphere configuration etc
--
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] 90yangkang commented on issue #25903: Mysql Database field inconsistent。
Posted by "90yangkang (via GitHub)" <gi...@apache.org>.
90yangkang commented on issue #25903:
URL: https://github.com/apache/shardingsphere/issues/25903#issuecomment-1571296789
> Hi @90yangkang , could you submit issue with [template](https://raw.githubusercontent.com/apache/shardingsphere/master/.github/ISSUE_TEMPLATE/bug-report.md)? e.g. ShardingSphere configuration etc
configuration info :
config-sharding.yaml info:
databaseName: db_mall
dataSources:
db1:
url: jdbc:mysql://localhost:3306/db1
username: root
password: root
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1
db2:
url: jdbc:mysql://localhost:3306/db2
username: root
password: root
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1
db3:
url: jdbc:mysql://localhost:3306/db3
username: root
password: root
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1
rules:
- !SHARDING
defaultDatabaseStrategy:
none:
defaultTableStrategy:
none:
server.yaml info:
mode:
type: Cluster
repository:
type: ZooKeeper
props:
namespace: db_mall_
server-lists: 1.1.1.1:2181
retryIntervalMilliseconds: 500
timeToLiveSeconds: 60
maxRetries: 3
operationTimeoutMilliseconds: 500
overwrite: true
rules:
- !AUTHORITY
users:
- root@%:root
- sharding@:sharding
provider:
type: ALL_PERMITTED
- !TRANSACTION
defaultType: LOCAL
# When the provider type is Narayana, the following properties can be configured or not
- !SQL_PARSER
sqlCommentParseEnabled: true
sqlStatementCache:
initialCapacity: 2000
maximumSize: 65535
parseTreeCache:
initialCapacity: 128
maximumSize: 1024
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-hint-enabled: true
sql-show: false
check-table-metadata-enabled: false
show-process-list-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
check-duplicate-table-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
# and block other clients if client connections are more than `proxy-frontend-executor-size`, especially executing slow SQL.
proxy-backend-executor-suitable: OLAP
proxy-frontend-max-connections: 0 # Less than or equal to 0 means no limitation.
sql-federation-enabled: false
# Available proxy backend driver type: JDBC (default), ExperimentalVertx
proxy-backend-driver-type: JDBC
proxy-mysql-default-version: 5.7.18 # In the absence of schema name, the default version will be used.
proxy-default-port: 3307 # Proxy default port.
proxy-netty-backlog: 1024 # Proxy netty backlog.
--
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] 90yangkang commented on issue #25903: Mysql Database field inconsistent。
Posted by "90yangkang (via GitHub)" <gi...@apache.org>.
90yangkang commented on issue #25903:
URL: https://github.com/apache/shardingsphere/issues/25903#issuecomment-1580256972
> make sql-show: true, And we could see the actual sql is with comment.
I maked sql-show: true,actual sql is :
Actual SQL: db_pre ::: / ShardingSphere hint: dataSourceName=db_pre */ SELECT * FROM page_data_put
<== Columns: id, page_data_version_id, name, mark, cos_path, create_by, create_time, update_by, update_time, delete_flag, business_source, scene_id, business_channel
<== Row: 1, 1650329764271161346, 品牌首页, app, mall_next/page_data/haval-test/app_index.json, lp, 2022-08-23 14:01:54, xyh01, 2023-04-24 10:44:15, 1, mall, 1612702987873218562, null
The returned result does not have this column of page_put_path.
--
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