Issue 1:
Bug Report

Which version of ShardingSphere did you use?

shardingjdbc4.1.1

Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?

ShardingSphere-JDBC

bug

Distributed system snowflake algorithm duplicate ID

### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '624998537125429249' for key 'PRIMARY'
### The error may involve com.dongao.phoenix.biz.study.manage.mapper.MsPushRecordLinkPoMapper.insert-Inline
### The error occurred while setting parameters
### SQL: insert into biz_ms_push_record_link (ms_push_record_id, type, create_date, update_date, member_ids, device_tokens ) values (?, ?, ?, ?, ?, ? )
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '624998537125429249' for key 'PRIMARY'
; SQL []; Duplicate entry '624998537125429249' for key 'PRIMARY'; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '624998537125429249' for key 'PRIMARY' org.springframework.dao.DuplicateKeyException:
### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '624998537125429249' for key 'PRIMARY'
### The error may involve com.dongao.phoenix.biz.study.manage.mapper.MsPushRecordLinkPoMapper.insert-Inline
### The error occurred while setting parameters
### SQL: insert into biz_ms_push_record_link (ms_push_record_id, type, create_date, update_date, member_ids, device_tokens ) values (?, ?, ?, ?, ?, ? )
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '624998537125429249' for key 'PRIMARY'

configuration

<bean id="msPushShardingAlgorithm" class="com.xx.phoenix.biz.study.manage.config.MsPushShardingAlgorithm" />
<sharding:standard-strategy id="pushTableStrategy" sharding-column="create_date" precise-algorithm-ref="msPushShardingAlgorithm" range-algorithm-ref="msPushShardingAlgorithm"/>
<sharding:key-generator id="idKeyGenerator" type="SNOWFLAKE" column="id"/>

<sharding:data-source id="shardingDataSource">
<sharding:sharding-rule data-source-names="ds1">
<sharding:table-rules>
<sharding:table-rule logic-table="biz_ms_push"
actual-data-nodes="ds1.biz_ms_push_20$->{21..25}"
table-strategy-ref="pushTableStrategy" key-generator-ref="idKeyGenerator" />
<sharding:table-rule logic-table="biz_ms_push_record"
actual-data-nodes="ds1.biz_ms_push_record_20$->{21..25}"
table-strategy-ref="pushTableStrategy" key-generator-ref="idKeyGenerator" />
<sharding:table-rule logic-table="biz_ms_push_record_link"
actual-data-nodes="ds1.biz_ms_push_record_link_20$->{21..25}"
table-strategy-ref="pushTableStrategy" key-generator-ref="idKeyGenerator" />
</sharding:table-rules>
<sharding:binding-table-rules>
<sharding:binding-table-rule logic-tables="biz_ms_push_record" />
</sharding:binding-table-rules>
</sharding:sharding-rule>
<sharding:props>
<prop key="sql.show">true</prop>
</sharding:props>
</sharding:data-source>

Issue 2:
Question

For English only, other languages will not accept.

Before asking a question, make sure you have:

Googled your question.

Searched open and closed GitHub issues.

Read documentation: ShardingSphere Doc.

Please pay attention on issues you submitted, because we maybe need more details.

If no response anymore and we cannot reproduce it on current information, we will close it.

Hi, when I batch insert data into the table through ShardingSphere-proxy-v5.2.1，I will be prompted with the following exception. However ,it is normal to directly insert into the table without the proxy.

Did I configure something wrong ? HELP ~

Note: I have tried to increase the value of sqlStatementCache in server.yaml

2022/10/28 04:00:46 - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : org.pentaho.di.core.exception.KettleException:
2022/10/28 04:00:46 - Error batch inserting rows into table [t_accounts].
2022/10/28 04:00:46 - Errors encountered (first 10):
2022/10/28 04:00:46 -
2022/10/28 04:00:46 -
2022/10/28 04:00:46 - Error updating batch
2022/10/28 04:00:46 - Parameter index out of bounds. 60177 is not between valid values of 1 and 60176
2022/10/28 04:00:46 -
2022/10/28 04:00:46 -
2022/10/28 04:00:46 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:348)
2022/10/28 04:00:46 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:125)
2022/10/28 04:00:46 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2022/10/28 04:00:46 - at java.lang.Thread.run(Thread.java:750)
2022/10/28 04:00:46 - Caused by: org.pentaho.di.core.exception.KettleDatabaseBatchException:
2022/10/28 04:00:46 - Error updating batch