Streaming result set com.mysql.cj.protocol.a.result.ResultsetRowsStreaming@4d221f7a is still active

[Gordon_Ye]

Alfresco Content Services Edition: Enterprise

Alfresco Content Services Version: 7.0.1

db: mysql

use cmis to search data we encountered this issue  ,error message below

"message": "{\"error\":{\"errorKey\":\"framework.exception.ApiDefault\",\"statusCode\":500,\"briefSummary\":\"nested exception is org.apache.ibatis.exceptions.PersistenceException: \\n### Error querying database.  Cause: org.springframework.dao.TransientDataAccessResourceException: \\n### Error querying database.  Cause: java.sql.SQLException: Streaming result set com.mysql.cj.protocol.a.result.ResultsetRowsStreaming@4d221f7a is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries.\\n### The error may exist in alfresco/ibatis/#resource.dialect#/permissions-common-SqlMap.xml\\n### The error may involve alfresco.permissions.parameter_IdMap\\n### The error occurred while setting parameters\\n### SQL: select             *         from             alf_access_control_list         where             id = ?\\n### Cause: java.sql.SQLException: Streaming result set com.mysql.cj.protocol.a.result.ResultsetRowsStreaming@4d221f7a is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries.\\n; Streaming result set com.mysql.cj.protocol.a.result.ResultsetRowsStreaming@4d221f7a is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries.; nested exception is java.sql.SQLException: Streaming result set com.mysql.cj.protocol.a.result.ResultsetRowsStreaming@4d221f7a is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries.\\n### Cause: org.springframework.dao.TransientDataAccessResourceException: \\n### Error querying database.  Cause: java.sql.SQLException: Streaming result set com.mysql.cj.protocol.a.result.ResultsetRowsStreaming@4d221f7a is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries.\\n### The error may exist in alfresco/ibatis/#resource.dialect#/permissions-common-SqlMap.xml\\n### The error may involve alfresco.permissions.parameter_IdMap\\n### The error occurred while setting parameters\\n### SQL: select             *         from             alf_access_control_list         where             id = ?\\n### Cause: java.sql.SQLException: Streaming result set com.mysql.cj.protocol.a.result.ResultsetRowsStreaming@4d221f7a is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries.\\n; Streaming result set com.mysql.cj.protocol.a.result.ResultsetRowsStreaming@4d221f7a is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries.; nested exception is java.sql.SQLException: Streaming result set com.mysql.cj.protocol.a.result.ResultsetRowsStreaming@4d221f7a is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries.\",\"stackTrace\":\"For security reasons the stack trace is no longer displayed, but the property is kept for previous versions\",\"descriptionURL

[McKinleyner]

The error message indicates a database query issue related to an active streaming result set that remains open, preventing new statements from being issued. It suggests closing any active streaming results prior to executing further queries. This highlights the importance of managing database resources effectively to avoid exceptions. If you're using Monkey Mart, ensure your database connections are properly managed to avoid such errors.