{"record":{"id":"faa03c96c2851bf0","repo":"prestodb/presto","slug":"invalid-session-property-faa03c","errorCode":"INVALID_SESSION_PROPERTY","errorMessage":"Invalid session property '%s'","messagePattern":"Invalid session property '(.+?)'","errorType":"error_code","errorClass":"SemanticException","httpStatus":null,"severity":"error","filePath":"presto-main-base/src/main/java/com/facebook/presto/execution/ResetSessionTask.java","lineNumber":46,"sourceCode":"import static com.facebook.presto.metadata.MetadataUtil.getConnectorIdOrThrow;\nimport static com.facebook.presto.sql.analyzer.SemanticErrorCode.INVALID_SESSION_PROPERTY;\nimport static com.google.common.util.concurrent.Futures.immediateFuture;\n\npublic class ResetSessionTask\n        implements SessionTransactionControlTask<ResetSession>\n{\n    @Override\n    public String getName()\n    {\n        return \"RESET SESSION\";\n    }\n\n    @Override\n    public ListenableFuture<?> execute(ResetSession statement, TransactionManager transactionManager, Metadata metadata, AccessControl accessControl, QueryStateMachine stateMachine, List<Expression> parameters, String query)\n    {\n        List<String> parts = statement.getName().getParts();\n        if (parts.size() > 2) {\n            throw new SemanticException(INVALID_SESSION_PROPERTY, statement, \"Invalid session property '%s'\", statement.getName());\n        }\n\n        // validate the property name\n        if (parts.size() == 1) {\n            metadata.getSessionPropertyManager().getSystemSessionPropertyMetadata(parts.get(0))\n                    .orElseThrow(() -> new SemanticException(INVALID_SESSION_PROPERTY, statement, \"Session property %s does not exist\", statement.getName()));\n        }\n        else {\n            ConnectorId connectorId = getConnectorIdOrThrow(stateMachine.getSession(), metadata, parts.get(0), statement, catalogError);\n            metadata.getSessionPropertyManager().getConnectorSessionPropertyMetadata(connectorId, parts.get(1))\n                    .orElseThrow(() -> new SemanticException(INVALID_SESSION_PROPERTY, statement, \"Session property %s does not exist\", statement.getName()));\n        }\n\n        stateMachine.addResetSessionProperties(statement.getName().toString());\n\n        return immediateFuture(null);\n    }\n}","sourceCodeStart":28,"sourceCodeEnd":64,"githubUrl":"https://github.com/prestodb/presto/blob/55bb57d202de3b926896fa966c2c4a44c779634e/presto-main-base/src/main/java/com/facebook/presto/execution/ResetSessionTask.java#L28-L64","documentation":"SemanticException (INVALID_SESSION_PROPERTY) from ResetSessionTask.execute: the property name in RESET SESSION does not resolve to any known session property for its catalog (or any built-in property), so there is nothing to reset.","triggerScenarios":"Thrown at presto-main-base/src/main/java/com/facebook/presto/execution/ResetSessionTask.java:46 when the library encounters an invalid state.","commonSituations":"See trigger scenarios.","solutions":["List valid properties with SHOW SESSION and correct the property name","Include the correct catalog prefix for connector-specific properties","Reset properties individually rather than guessing names"],"exampleFix":null,"handlingStrategy":"validation","validationCode":null,"typeGuard":null,"tryCatchPattern":null,"preventionTips":[],"tags":[],"backgroundTag":null,"analyzedSha":"55bb57d202de3b926896fa966c2c4a44c779634e","analyzedAt":"2026-09-04T12:50:26.162Z","contentChangedAt":"2026-09-04T12:50:26.162Z","schemaVersion":2},"datasetVersion":"2026-09-11T21:17:09.523Z"}