wuxin2016 commented on issue #23857:
URL:
https://github.com/apache/shardingsphere/issues/23857#issuecomment-1409881932
> Hi @wuxin2016 Thanks for the feedback, can you provide the configuration
and SQL statements, we need to be able to reproduce this problem during the
investigation.
proxy-configuation:
~~~yaml
authority:
privilege:
type: ALL_PERMITTED
users:
- password: test
user: test
mode:
repository:
props:
maxRetries: 3
namespace: governance_ds
operationTimeoutMilliseconds: 5000
retryIntervalMilliseconds: 500
server-lists: shardingsphere-proxy-zookeeper:2181
timeToLiveSeconds: 60
type: ZooKeeper
type: Cluster
props:
proxy-frontend-database-protocol-type: MySQL
sql-show: true
sql-simple: false
~~~
SQLs
~~~SQL
## 1
SELECT COUNT(*)
FROM `AppLoginLogs` AS `a`
WHERE (((`a`.`LoginStatus` = 1) AND (`a`.`LoginClientType` = 1)) AND
(`a`.`UserId` = 11910177)) AND ((`a`.`CreationTime` >= '2023-01-10
01:43:10.922') AND (`a`.`CreationTime` <= '2023-01-15 01:43:15.587'
))
## 2
SELECT `a`.`Id`, `a`.`CreationTime`, `a`.`CreatorUserId`,
`a`.`EmployeeCode`, `a`.`EmployeeName`, `a`.`LoginClientType`,
`a`.`LoginStatus`, `a`.`MtVersion`, `a`.`PhoneOS`
FROM `AppLoginLogs` AS `a`
WHERE (`a`.`LoginStatus` = 1) AND ((`a`.`CreationTime` >= '2023-01-10
01:43:10.922') AND (`a`.`CreationTime` <= '2023-01-15 01:43:15.587'))
ORDER BY `a`.`CreationTime` DESC
LIMIT 10 OFFSET 1
~~~
The connection was closed after executing the first statement.
When opened the connection again before executing the second statement , I
got an exception above.
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
