Tag: Database

Problems related to databases, such as PostgreSQL, or MySQL.

ID	Title	Description	Category	Technology	Tags
prequel-2025-0011 Medium Impact: 7/10 Mitigation: 5/10	GraphQL internal server error due to record not found	The application is experiencing internal server errors when GraphQL operations attempt to access records that do not exist in the database. This occurs when GraphQL queries reference entities that have been deleted, were never created, or are inaccessible due to permission issues. Instead of handling these cases gracefully with proper error responses, the API is escalating them to internal server errors that may impact client applications and user experience.	GraphQL Problems	graphql	GraphQL Database Errors
prequel-2025-0086 Medium Impact: 7/10 Mitigation: 3/10	Database Not-Null Constraint Violation	An application is attempting to insert or update records in a database table with NULL values in columns that have NOT NULL constraints. This causes database operations to fail with integrity errors, typically surfacing as NotNullViolation exceptions in application logs. In Django applications, this commonly appears as django.db.utils.IntegrityError or psycopg2.errors.NotNullViolation when using PostgreSQL.	Database Integrity Problems	psycopg2	Database PostgreSQL Django Data Integrity