{"record":{"id":"7547dcaa4f6f4b68","repo":"apache/shardingsphere","slug":"unsupported-sql-operation-s-7547dc","errorCode":null,"errorMessage":"Unsupported SQL operation: %s.","messagePattern":"Unsupported SQL operation: (.+?)\\.","errorType":"exception","errorClass":"UnsupportedSQLOperationException","httpStatus":null,"severity":"error","filePath":"proxy/frontend/dialect/postgresql/src/main/java/org/apache/shardingsphere/proxy/frontend/postgresql/command/query/extended/close/PostgreSQLComCloseExecutor.java","lineNumber":55,"sourceCode":"public final class PostgreSQLComCloseExecutor implements CommandExecutor {\n    \n    private final PortalContext portalContext;\n    \n    private final PostgreSQLComClosePacket packet;\n    \n    private final ConnectionSession connectionSession;\n    \n    @Override\n    public Collection<DatabasePacket> execute() throws SQLException {\n        switch (packet.getType()) {\n            case PREPARED_STATEMENT:\n                connectionSession.getServerPreparedStatementRegistry().removePreparedStatement(packet.getName());\n                break;\n            case PORTAL:\n                portalContext.close(packet.getName());\n                break;\n            default:\n                throw new UnsupportedSQLOperationException(packet.getType().name());\n        }\n        return Collections.singleton(new PostgreSQLCloseCompletePacket());\n    }\n}\n","sourceCodeStart":37,"sourceCodeEnd":60,"githubUrl":"https://github.com/apache/shardingsphere/blob/e952770a215630a3659c75d64369168cd3e26b82/proxy/frontend/dialect/postgresql/src/main/java/org/apache/shardingsphere/proxy/frontend/postgresql/command/query/extended/close/PostgreSQLComCloseExecutor.java#L37-L60","documentation":"Error \"Unsupported SQL operation: %s.\" thrown in apache/shardingsphere.","triggerScenarios":"PostgreSQLComCloseExecutor receives a Close message with an unsupported type indicator.","commonSituations":"Malformed extended-protocol Close packets from buggy clients or proxies.","solutions":["Use Close only with prepared statements ('S') or portals ('P').","Do not send Close for other object types.","Verify the client library generates valid Close messages."],"exampleFix":null,"handlingStrategy":null,"validationCode":null,"typeGuard":null,"tryCatchPattern":null,"preventionTips":[],"tags":[],"backgroundTag":null,"analyzedSha":"e952770a215630a3659c75d64369168cd3e26b82","analyzedAt":"2026-08-14T13:54:53.392Z","schemaVersion":2},"datasetVersion":"2026-08-15T17:31:12.345Z"}