User Error Rate Spike Indicating Query Syntax or Schema Issues
infoElevated user error failures suggesting widespread issues with query syntax, schema changes, or permission problems affecting multiple queries from users.
Monitor presto_execution_user_error_failures_one_minute_rate for sustained increases. Compare against presto_execution_started_queries_one_minute_rate to calculate error percentage. Check if errors correlate with recent schema changes, permission updates, or deployment of new client applications. Review error messages in logs for common patterns.
Analyze error logs to identify common error patterns. If schema-related, communicate schema changes to users and update documentation. For permission issues, review and correct access controls. If query syntax issues are prevalent, provide query templates or improve query validation in client tools. Consider implementing query linting in development environments.