List all Database Errors
Database errors can be grouped into major categories. Below is a comprehensive list of common database error types across MySQL, PostgreSQL, SQL Server, Oracle, SQLite, MongoDB, Redis, Cassandra, and other databases.
| Error Category | Description | Examples |
|---|---|---|
| Connection Errors | Unable to connect to database | Connection refused, Host unreachable |
| Authentication Errors | Invalid login credentials | Access denied, Invalid password |
| Authorization Errors | Insufficient permissions | Permission denied, SELECT denied |
| Database Not Found | Requested database doesn’t exist | Unknown database |
| Table Not Found | Missing table | Table doesn’t exist |
| View Not Found | Missing database view | Unknown view |
| Column Not Found | Invalid column | Unknown column |
| Index Errors | Missing or corrupted indexes | Index not found |
| Schema Errors | Invalid schema | Schema doesn’t exist |
| Constraint Violation | Violates database constraints | Foreign key violation |
| Primary Key Errors | Duplicate or missing PK | Duplicate primary key |
| Foreign Key Errors | Invalid relationship | Foreign key constraint fails |
| Unique Constraint Errors | Duplicate unique value | Duplicate entry |
| Check Constraint Errors | Check condition failed | CHECK constraint failed |
| NOT NULL Errors | NULL inserted into mandatory column | Column cannot be null |
| Default Value Errors | Invalid default values | Invalid default expression |
| SQL Syntax Errors | Invalid SQL query | Syntax error near FROM |
| Query Parsing Errors | Parser unable to parse SQL | Parse error |
| Query Execution Errors | Execution failed | Execution aborted |
| Transaction Errors | Transaction failures | Rollback failed |
| Deadlock Errors | Two transactions waiting | Deadlock detected |
| Lock Timeout Errors | Waiting for lock exceeded | Lock wait timeout |
| Concurrency Errors | Simultaneous update conflict | Serialization failure |
| Timeout Errors | Query exceeded timeout | Query timeout |
| Memory Errors | Insufficient memory | Out of memory |
| Disk Space Errors | Database storage full | Disk full |
| Storage Engine Errors | Engine-specific issues | InnoDB error |
| File System Errors | Missing/corrupt files | Cannot open data file |
| Corruption Errors | Data/index corruption | Database corruption |
| Backup Errors | Backup failed | Backup aborted |
| Restore Errors | Restore failed | Invalid backup file |
| Replication Errors | Replication issues | Slave stopped |
| Cluster Errors | Cluster node failures | Cluster unavailable |
| Failover Errors | Failover unsuccessful | Failover timeout |
| Network Errors | Network interruption | Lost connection during query |
| Data Type Errors | Invalid datatype | Incorrect integer value |
| Data Conversion Errors | Conversion failed | Cannot convert varchar to int |
| Data Truncation Errors | Data exceeds column size | Data too long |
| Overflow Errors | Numeric overflow | Arithmetic overflow |
| Underflow Errors | Numeric underflow | Floating-point underflow |
| Divide by Zero Errors | Division by zero | Divide by zero encountered |
| Encoding Errors | Character encoding issues | Invalid UTF-8 |
| Collation Errors | Collation mismatch | Illegal mix of collations |
| Serialization Errors | Cannot serialize transaction | Serialization failure |
| Cursor Errors | Cursor misuse | Cursor already closed |
| Trigger Errors | Trigger execution failed | BEFORE INSERT trigger failed |
| Stored Procedure Errors | Procedure execution failed | Procedure not found |
| Function Errors | Function call failed | Invalid function |
| Sequence Errors | Sequence problems | Sequence doesn’t exist |
| Trigger Recursion Errors | Infinite trigger recursion | Maximum recursion reached |
| Prepared Statement Errors | Invalid prepared statement | Statement closed |
| Parameter Errors | Missing parameters | Invalid bind parameter |
| JSON Errors | Invalid JSON | Invalid JSON document |
| XML Errors | Invalid XML | XML parse error |
| BLOB/CLOB Errors | Binary object problems | Invalid BLOB |
| Partition Errors | Partition missing | Partition not found |
| Sharding Errors | Incorrect shard | Shard unavailable |
| Cache Errors | Cache unavailable | Cache miss |
| Configuration Errors | Invalid DB configuration | Invalid configuration parameter |
| Version Compatibility Errors | Client/server version mismatch | Unsupported protocol |
| Migration Errors | Schema migration failed | Migration rollback |
| Import Errors | Data import failed | CSV import error |
| Export Errors | Data export failed | Export aborted |
| Recovery Errors | Recovery process failed | Crash recovery failed |
| Log Errors | Transaction log issues | Log file full |
| WAL Errors | Write-ahead log problems | WAL corruption |
| Checkpoint Errors | Checkpoint failure | Checkpoint timeout |
| Resource Exhaustion Errors | CPU/memory/process limit | Too many connections |
| Connection Pool Errors | Pool exhausted | No available connections |
| SSL/TLS Errors | Secure connection failed | SSL handshake failed |
| Certificate Errors | Invalid certificates | Certificate expired |
| DNS Errors | Host resolution failed | Unknown host |
| Driver Errors | JDBC/ODBC driver issue | Driver not found |
| API Errors | Database API failed | ORM exception |
| ORM Errors | ORM mapping issue | Entity mapping failed |
| Pagination Errors | Invalid LIMIT/OFFSET | Invalid page number |
| Aggregate Errors | Invalid aggregation | GROUP BY error |
| Window Function Errors | Window function misuse | Invalid OVER clause |
| Join Errors | Invalid JOIN | Ambiguous column |
| Subquery Errors | Invalid nested query | Subquery returns multiple rows |
| Temporary Table Errors | Temp table issue | Temp table exists |
| Materialized View Errors | Refresh failed | Materialized view invalid |
| Read-only Errors | Write attempted on read-only DB | Database is read only |
| Read Replica Errors | Replica unavailable | Replica lag |
| Licensing Errors | Enterprise feature unavailable | License expired |
| Internal Database Errors | Database engine bug | Internal error |
| Unknown Database Errors | Uncategorized failures | Unknown database error |
Most Common Database Errors Users Search
- Connection refused
- Access denied
- Too many connections
- Lost connection to database
- Unknown database
- Table doesn’t exist
- Unknown column
- Duplicate entry
- Foreign key constraint fails
- Cannot insert NULL
- SQL syntax error
- Deadlock detected
- Lock wait timeout
- Query timeout
- Out of memory
- Disk full
- Data too long
- Invalid data type
- Divide by zero
- Database is read only
- Transaction rollback
- Database corruption
- Backup failed
- Restore failed
- Replication stopped
- Too many connections
- SSL connection error
- Invalid JSON
- Permission denied
- Connection timeout
Discover more from what is my ERROR!
Subscribe to get the latest posts sent to your email.