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/04/22 13:13:28 UTC
[GitHub] [shardingsphere] novice-gamer opened a new issue, #17015: OperationalError: (1997, 'Runtime exception: [Sequence ID of MySQL command packet must be `0`.]')
novice-gamer opened a new issue, #17015:
URL: https://github.com/apache/shardingsphere/issues/17015
Sharding proxy version 5.1.0
Using Python to import data, an error is reported when it reaches one million:
Pymysql is used
```
OperationalError: (1997, 'Runtime exception: [Sequence ID of MySQL command packet must be `0`.]')
```
Props configuration information:
```yaml
proxy-frontend-executor-size: 0
proxy-frontend-flush-threshold: 128
allow.range.query.with.inline.sharding: true
proxy-frontend-max-connections: 0
check-duplicate-table-enabled: false
proxy-backend-query-fetch-size: -1
kernel-executor-size: 16
show-process-list-enabled: false
proxy-backend-executor-suitable: OLAP
proxy-hint-enabled: false
sql-show: true
proxy-opentracing-enabled: false
sql-federation-enabled: false
max-connections-size-per-query: 1
check-table-metadata-enabled: false
```
Rules configuration:
```yaml
- !SHARDING
keyGenerators:
csys_build_demand_sx61_snowflake:
type: snowflake
csys_company_demand_sx61_snowflake:
type: snowflake
tables:
csys_build_demand_sx61:
actualDataNodes: ds_0.csys_build_demand_sx61
keyGenerateStrategy:
column: id
keyGeneratorName: csys_build_demand_sx61_snowflake
logicTable: csys_build_demand_sx61
csys_company_demand_sx61:
actualDataNodes: ds_0.csys_company_demand_sx61
keyGenerateStrategy:
column: id
keyGeneratorName: csys_company_demand_sx61_snowflake
logicTable: csys_company_demand_sx61
```
--
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] novice-gamer closed issue #17015: OperationalError: (1997, 'Runtime exception: [Sequence ID of MySQL command packet must be `0`.]')
Posted by GitBox <gi...@apache.org>.
novice-gamer closed issue #17015: OperationalError: (1997, 'Runtime exception: [Sequence ID of MySQL command packet must be `0`.]')
URL: https://github.com/apache/shardingsphere/issues/17015
--
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] terrymanu commented on issue #17015: OperationalError: (1997, 'Runtime exception: [Sequence ID of MySQL command packet must be `0`.]')
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #17015:
URL: https://github.com/apache/shardingsphere/issues/17015#issuecomment-1164695325
I just set it as invalid because of the author close the issue without any reason.
--
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] gogogonow commented on issue #17015: OperationalError: (1997, 'Runtime exception: [Sequence ID of MySQL command packet must be `0`.]')
Posted by GitBox <gi...@apache.org>.
gogogonow commented on issue #17015:
URL: https://github.com/apache/shardingsphere/issues/17015#issuecomment-1156236517
Hi, i meet the same problem when import data using shardingsphere proxy, So how do you resolve this problem, thanks.
--
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] gogogonow commented on issue #17015: OperationalError: (1997, 'Runtime exception: [Sequence ID of MySQL command packet must be `0`.]')
Posted by GitBox <gi...@apache.org>.
gogogonow commented on issue #17015:
URL: https://github.com/apache/shardingsphere/issues/17015#issuecomment-1156242322
> Sharding proxy version 5.1.0
>
> Using Python to import data, an error is reported when it reaches one million: Pymysql is used
>
> ```
> OperationalError: (1997, 'Runtime exception: [Sequence ID of MySQL command packet must be `0`.]')
> ```
>
> Props configuration information:
>
> ```yaml
> proxy-frontend-executor-size: 0
> proxy-frontend-flush-threshold: 128
> allow.range.query.with.inline.sharding: true
> proxy-frontend-max-connections: 0
> check-duplicate-table-enabled: false
> proxy-backend-query-fetch-size: -1
> kernel-executor-size: 16
> show-process-list-enabled: false
> proxy-backend-executor-suitable: OLAP
> proxy-hint-enabled: false
> sql-show: true
> proxy-opentracing-enabled: false
> sql-federation-enabled: false
> max-connections-size-per-query: 1
> check-table-metadata-enabled: false
> ```
>
> Rules configuration:
>
> ```yaml
> - !SHARDING
> keyGenerators:
> csys_build_demand_sx61_snowflake:
> type: snowflake
> csys_company_demand_sx61_snowflake:
> type: snowflake
> tables:
> csys_build_demand_sx61:
> actualDataNodes: ds_0.csys_build_demand_sx61
> keyGenerateStrategy:
> column: id
> keyGeneratorName: csys_build_demand_sx61_snowflake
> logicTable: csys_build_demand_sx61
> csys_company_demand_sx61:
> actualDataNodes: ds_0.csys_company_demand_sx61
> keyGenerateStrategy:
> column: id
> keyGeneratorName: csys_company_demand_sx61_snowflake
> logicTable: csys_company_demand_sx61
> ```
Hi, i meet the same problem when import data using shardingsphere proxy, So how do you resolve this problem? thanks.
--
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