Fixes
Databases and Redis
Connection limits, slow queries, locks and migration problems in MariaDB, MySQL, PostgreSQL and Redis, with the commands that find the cause.

434 fixes
Problems in this area
434 of 434 fixes
- Installing the Airflow MySQL provider fails on pkg-config or mysqlclient
pip install apache-airflow-providers-mysql stops with a pkg-config error2 causes - asyncpg InterfaceError: another operation is in progress with SQLAlchemy
asyncpg.exceptions._base.InterfaceError: cannot perform operation: another operation is in progress4 causes - A query on Aurora MySQL dies with 'table /rdsdbdata/tmp/#sql... is full'
ERROR 1114 (HY000): The table '/rdsdbdata/tmp/#sql161_17a011_a' is full3 causes - Azure Database for MySQL refuses a connection that does not use SSL
ERROR 3159 (HY000): Connections using insecure transport are prohibited while --require_secure_transport=ON.4 causes - Compiling a C or C++ program that includes mysql.h fails
fatal error: mysql.h: No such file or directory3 causes - Dapper cannot find a constructor that fits the query columns
A parameterless default constructor or one matching signature3 causes - DBeaver fails to resolve Maven dependencies when downloading a database driver
Error resolving maven dependencies3 causes - DBeaver cannot verify the MySQL server certificate
unable to find valid certification path to requested target2 causes - DBeaver cannot run pg_restore: the utility is not found in the client home
Error executing process3 causes - DBeaver cannot download the PostgreSQL driver from Maven
Maven artifact:org.postgresql:postgresql:RELEASE' can't be resolved in External Repositories3 causes - Django cannot load MySQLdb and asks whether mysqlclient is installed
django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: No module named MySQLdb3 causes - python manage.py migrate finishes but the tables for my app are missing
(no migrations)3 causes - Django save fails on PostgreSQL: null value in a column violates a not-null constraint
django.db.utils.IntegrityError: null value in column "price" of relation "shop_product" violates not-null constraint3 causes - Django migration on PostgreSQL stops with 'pending trigger events'
django.db.utils.OperationalError: cannot ALTER TABLE "mytable" because it has pending trigger events2 causes - Django cannot connect to PostgreSQL: connection refused on port 5432, locally or in Docker
connection to server at "localhost" (127.0.0.1), port 5432 failed: Connection refused4 causes - Django cannot connect to PostgreSQL through a pg_service.conf service
definition of service "my_service" not found4 causes - manage.py test stops with 'permission denied to create database' on PostgreSQL
Got an error creating the test database: permission denied to create database2 causes - Node.js in Docker Compose cannot find mysql2/promise
Error: Cannot find module 'mysql2/promise'2 causes - A container cannot resolve the name of its database container
dial tcp: lookup db on 127.0.0.11:53: no such host3 causes - .NET Framework app cannot load the Unsafe assembly after a NuGet update
Could not load file or assembly 'System.Runtime.CompilerServices.Unsafe'4 causes - DynamoDB Query rejects your key condition expression
Query condition missed key schema element3 causes - An EC2 instance cannot reach its RDS database
Can't connect to RDS instance from EC2 instance3 causes - EF Core logs 'An error occurred using the connection to database' with MySQL
An error occurred using the connection to database '' on server 'localhost'.3 causes - EF Core says 'transient failure' when it cannot reach PostgreSQL in Docker
An exception has been raised that is likely due to a transient failure3 causes - DbContextOptionsBuilder has no UseMySql method
UseMysql is not found on DbContextOptionsBuilder3 causes - Elasticsearch rejects requests with circuit_breaking_exception: Data too large
circuit_breaking_exception3 causes - elasticsearch-php says it found no alive nodes in the cluster
No alive nodes found in your cluster3 causes - Flyway cannot handle the PostgreSQL URL after upgrading to Flyway 10 or newer
No Flyway database plugin found to handle: jdbc:foo://localhost:port4 causes - PHP cannot connect to SQL Server through FreeTDS
Adaptive Server is unavailable or does not exist3 causes - GeoDjango on Windows says it could not find the GDAL library (WinError 126)
django.core.exceptions.ImproperlyConfigured: Could not find the GDAL library3 causes - A Go program is refused by Postgres with password authentication failed
pq: password authentication failed for user "user-name"2 causes - H2 in PostgreSQL mode still behaves differently from PostgreSQL
SQL that runs on PostgreSQL fails on H2 in tests4 causes - H2 fails an INSERT or CREATE TABLE with: expected identifier
org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement3 causes - Hibernate cannot find hibernate.cfg.xml at startup
org.hibernate.internal.util.config.ConfigurationException: Could not locate cfg.xml resource [hibernate.cfg.xml]2 causes - EntityNotFoundException when loading an entity that has a missing related row
jakarta.persistence.EntityNotFoundException3 causes - Hibernate fails on a CREATE or ALTER TABLE statement at startup
Error executing DDL "alter table events drop foreign key FKg0mkvgsqn8584qoql6a2rxheq" via JDBC Statement3 causes - Hibernate cannot initialize a lazy collection or proxy in Spring Boot
org.hibernate.LazyInitializationException: failed to lazily initialize a collection of role3 causes - Hibernate cannot find the sequence hibernate_sequence on PostgreSQL
Missing sequence or table: hibernate_sequence3 causes - PSQLException: column user0_.id does not exist in a Hibernate query
org.postgresql.util.PSQLException: ERROR: column user0_.id does not exist3 causes - Hibernate cannot resolve org.hibernate.dialect.MySQL5Dialect as a strategy
Unable to resolve name [org.hibernate.dialect.MySQL5Dialect] as strategy [org.hibernate.dialect.Dialect]3 causes - Spring Boot fails on startup: HikariPool-1 exception during pool initialization
HikariPool-1 - Exception during pool initialization3 causes - IntelliJ IDEA Test Connection fails for a PostgreSQL data source
Test Connection in the data source properties reports a failure4 causes - MySQL Connector/J: EOFException, expected to read 4 bytes, read 0 bytes
java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.3 causes - Java cannot load org.postgresql.Driver
java.lang.ClassNotFoundException: org.postgresql.Driver3 causes - Jedis cannot borrow a connection from its pool
redis.clients.jedis.exceptions.JedisException: Could not get a resource from the pool3 causes - TypedQuery rejects a query that selects several columns
java.lang.IllegalArgumentException4 causes - JupyterLab cannot determine its build status without Node.js
Could not determine jupyterlab build status without nodejs3 causes - Keycloak in a container will not let you create the first admin user
You need local access to create the initial admin user.2 causes - Laravel bulk insert fails with 'too many placeholders'
SQLSTATE[HY000]: General error: 1390 Prepared statement contains too many placeholders3 causes - Laravel query fails: conversion from one collation into another is impossible
SQLSTATE[HY000]: General error: 3988 Conversion from collation utf8_unicode_ci into utf8mb4_0900_ai_ci impossible for parameter3 causes - An old PostgreSQL client says authentication method 10 not supported
authentication method 10 not supported2 causes - A program fails to start because libpq.so.5 is missing
error while loading shared libraries: libpq.so.5: cannot open shared object file: No such file or directory3 causes - Locked out of a fresh MariaDB install as root on Mac or Linux
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)3 causes - An Aria table fails with 'Read page with wrong checksum' (error 1030, code 176)
#1030 - Got error 176 "Read page with wrong checksum" from storage engine Aria3 causes - The client cannot open a TCP connection to MariaDB or MySQL (error 2003)
ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (10061)4 causes - MariaDB will not start after a move: Can't create test file ... lower-test
[Warning] Can't create test file /home/mysql/beta.lower-test4 causes - MariaDB warns that it could not raise max_open_files to the value it wants
[Warning] Could not increase number of max_open_files to more than 4096 (request: 4214)3 causes - The column named in the statement is not found in that table (error 1054)
ERROR 1054 (42S22): Unknown column 'Maaz' in 'field list'3 causes - The server could not parse an SQL statement (error 1064)
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'order (id, total) VALUES (1, 5)' at line 13 causes - Reading the mysql.user view fails with error 1356
Queries on the mysql.user view fail because the server considers the view invalid (error 1356)2 causes - An insert or update is rejected because the parent row does not exist (error 1452)
ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`shop`.`orders`, CONSTRAINT `fk_orders_customer` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`))4 causes - A Galera node will not start: gcomm backend connection failed with error 110
gcomm backend connection failed: 1104 causes - MariaDB will not start: Plugin 'InnoDB' registration as a STORAGE ENGINE failed
[ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.2 causes - Job for mariadb.service failed: how to find the real reason
Failed to start MariaDB 11.4 database server.3 causes - The MariaDB or MySQL container ignores the root password you set
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)3 causes - systemctl start mariadb hangs, then fails with a timeout
Job for mariadb.service failed because a timeout was exceeded.3 causes - A new MariaDB client refuses to connect to a server without TLS (error 2026)
ERROR 2026 (HY000): TLS/SSL error: SSL is required, but the server does not support it2 causes - SHOW TABLES lists the table, but every query says it does not exist in the engine
ERROR 1932 (42S02): Table 'shop.orders' doesn't exist in engine3 causes - systemctl says Unit mariadb.service not found on Fedora
Failed to start mariadb.service: Unit mariadb.service not found.2 causes - mongod stops with: dbpath (/data/db) does not exist
ERROR: dbpath (/data/db) does not exist.3 causes - mongod --fork stops with child process failed, exited with error number 1
ERROR: child process failed, exited with error number 13 causes - systemctl cannot find mongod.service on Ubuntu
Failed to start mongod.service: Unit mongod.service not found.2 causes - Mongoose cannot sign in to MongoDB Atlas: bad auth, authentication failed
MongoServerError: bad auth : Authentication failed.3 causes - MongoDB bindIp 127.0.0.1 refuses remote clients, 0.0.0.0 works
bindIp: 127.0.0.1 works locally but remote clients get connection refused3 causes - MongoDB says duplicate key, but the value is null
E11000 duplicate key error collection: mydb.users index: email_1 dup key: { email: null }3 causes - mongodb-memory-server will not start under Jest or in Docker
libcurl4 is not available on your system. Mongod requires it and cannot be started without it.4 causes - MongoDB refuses a read because the node is a secondary
not primary and secondaryOk=false3 causes - updateOne() runs without an error but the document does not change
Update document requires atomic operators4 causes - Mongoose.Types.ObjectId call fails or shows as deprecated
Class constructor ObjectId cannot be invoked without 'new'3 causes - MongoServerSelectionError: the Node.js driver cannot reach any server
MongoServerSelectionError: connect ECONNREFUSED <IPv6 address>:<port>5 causes - phpMyAdmin shows #1142 SELECT command denied on pma__table_uiprefs
#1142 - SELECT command denied to user ''@'localhost' for table 'pma__table_uiprefs'3 causes - A view, procedure or trigger names a DEFINER account that this server does not have
ERROR 1449 (HY000): The user specified as a definer ('old_admin'@'localhost') does not exist4 causes - A WITH common table expression fails with a syntax error in MySQL
ERROR 1064 (42000) on a statement that begins with WITH3 causes - Creating a MySQL user with a password fails on MySQL 8 and later
GRANT ALL ON db.* TO 'app'@'%' IDENTIFIED BY 'secret' is rejected with a syntax error4 causes - ALTER TABLE ADD COLUMN with AFTER gives a syntax error
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AFTER'2 causes - There is already an open DataReader on the MySQL connection
There is already an open DataReader associated with this Connection which must be closed first3 causes - ALTER TABLE ... ADD CONSTRAINT fails with error 1064 syntax error
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near3 causes - MySQL ALTER TABLE takes hours on a big table
ALTER TABLE runs for hours on a large table3 causes - apt update fails: the MySQL repository signature cannot be verified
The following signatures couldn't be verified because the public key is not available: NO_PUBKEY2 causes - A client says it cannot load the caching_sha2_password plugin
A client or connector built before MySQL 8.0 cannot connect to an account that uses caching_sha2_password3 causes - PHP cannot connect to MySQL: the connection attempt failed
Can't connect to MySQL server on 'host'4 causes - The client cannot reach the MySQL or MariaDB server through its Unix socket file
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)4 causes - A MySQL CHECK constraint exists but bad rows still go in
Check constraint 'chk_price' is violated.4 causes - MySQL INSERT fails: column count does not match value count at row 1
ERROR 1136 (21S01): Column count doesn't match value count at row 13 causes - MySQL or MariaDB: Column count of mysql.proc is wrong, table probably corrupted
Column count of mysql.proc is wrong. Expected 20, found 16. The table is probably corrupted3 causes - MySQL 8: Column count of mysql.user is wrong, table probably corrupted
Column count of mysql.user is wrong. Expected 42, found 44. The table is probably corrupted2 causes - The mysql command is not found in the terminal on a Mac
zsh: command not found: mysql2 causes - Java cannot log in to MySQL 8: authentication plugin caching_sha2_password not supported
Unable to load authentication plugin 'caching_sha2_password'.3 causes - MySQL error 3159: connections using insecure transport are prohibited
3159 (HY000): Connections using insecure transport are prohibited while --require_secure_transport=ON.3 causes - MySQL replica will not start: could not initialize master info structure
Could not initialize connection metadata structure; more error messages can be found in the MySQL error log2 causes - The MySQL container stops with: the designated data directory is unusable
The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it.3 causes - MySQL refuses or trims a value: Data truncated for column
Data truncated for column 'status' at row 13 causes - Saving an empty date from PHP into a MySQL DATETIME column fails
The insert fails with an error about an invalid datetime value when the date field is empty4 causes - Why a DATE column will not take CURRENT_DATE or CURDATE() as its default
ERROR 1064 (42000): ... near 'CURRENT_DATE' at line 33 causes - A script with DELIMITER fails with error 1064 near DELIMITER
ERROR 1064 (42000)3 causes - Error 1062 on a composite primary key when the row looks new
ERROR 1062 (23000): Duplicate entry 'abc-2025' for key 'orders.PRIMARY'3 causes - DROP DATABASE fails with Error dropping database (can't rmdir)
ERROR 1010 (HY000): Error dropping database (can't rmdir './shop', errno: 39 - Directory not empty)2 causes - A query with ORDER BY stops with error 1038, out of sort memory
ERROR 1038 (HY001): Out of sort memory, consider increasing server sort buffer size3 causes - ERROR 1044: Access denied for user to database
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'db'3 causes - MySQL says Access denied for user 'root'@'localhost' and Django cannot connect
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)3 causes - A query fails with No database selected
ERROR 1046 (3D000): No database selected3 causes - ERROR 1049 (42000): Unknown database
ERROR 1049 (42000): Unknown database 'mydatabasename'3 causes - MySQL says the table already exists when you create it
ERROR 1050 (42S01): Table 'users' already exists3 causes - A JOIN query fails with 'Column ... is ambiguous'
ERROR 1052 (23000): Column 'user_id' in field list is ambiguous3 causes - MySQL does not know a column alias used in the WHERE clause
ERROR 1054 (42S22): Unknown column 'total' in 'where clause'2 causes - GROUP BY query rejected by sql_mode only_full_group_by
ERROR 1055 (42000): Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column4 causes - Duplicate entry for key 'PRIMARY' when inserting a row
ERROR 1062 (23000): Duplicate entry '1' for key 'PRIMARY'3 causes - Error 1066: 'Not unique table/alias' in a join or HANDLER statement
ERROR 1066 (42000): Not unique table/alias: 'orders'2 causes - MySQL refuses a DATE, DATETIME or TIMESTAMP column default
ERROR 1067 (42000): Invalid default value for 'created_at'3 causes - MySQL says Multiple primary key defined in CREATE or ALTER TABLE
ERROR 1068 (42000): Multiple primary key defined3 causes - MySQL refuses to create an index: specified key was too long
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes3 causes - MySQL will not turn a column into AUTO_INCREMENT
ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key4 causes - MySQL error 1089: Incorrect prefix key
ERROR 1089 (HY000): Incorrect prefix key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique prefix keys3 causes - UPDATE or DELETE fails: can't specify target table in FROM clause
ERROR 1093 (HY000): You can't specify target table 'items' for update in FROM clause2 causes - MySQL will not let a TEXT column have a default value
ERROR 1101 (42000): BLOB, TEXT, GEOMETRY or JSON column 'notes' can't have a default value2 causes - Aggregate functions are not allowed in WHERE: error 1111 and how to rewrite
ERROR 1111 (HY000): Invalid use of group function3 causes - MySQL error 1115: Unknown character set 'utf8mb4'
ERROR 1115 (42000): Unknown character set: 'utf8mb4'3 causes - CREATE TABLE or ALTER TABLE fails with Row size too large
ERROR 1118 (42000): Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs3 causes - A query on a temporary table fails with "Can't reopen table"
ERROR 1137 (HY000): Can't reopen table: 'temp_table'2 causes - MySQL REGEXP fails with error 1139: repetition-operator operand invalid
ERROR 1139 (42000): Got error 'repetition-operator operand invalid' from regexp2 causes - MySQL error 1142: the account may not SELECT from this table
ERROR 1142 (42000): SELECT command denied to user 'app'@'10.0.0.5' for table 'orders'3 causes - MySQL says Table 'db.table' doesn't exist but you can see it
ERROR 1146 (42S02): Table 'shop.Orders' doesn't exist2 causes - A single statement or row is larger than max_allowed_packet (error 1153)
ERROR 1153 (08S01): Got a packet bigger than 'max_allowed_packet' bytes3 causes - MySQL refuses to index a TEXT or BLOB column
ERROR 1170 (42000): BLOB/TEXT column 'title' used in key specification without a key length3 causes - A stored procedure stops with 'Result consisted of more than one row'
ERROR 1172 (42000): Result consisted of more than one row3 causes - UPDATE or DELETE rejected: 'You are using safe update mode'
You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column.3 causes - MySQL says the user already has more than max_user_connections active connections
ERROR 1203 (42000): User app already has more than 'max_user_connections' active connections3 causes - MySQL refuses to create a foreign key (error 1215)
ERROR 1215 (HY000): Cannot add foreign key constraint5 causes - MySQL ERROR 1227: you need the CREATE USER privilege
ERROR 1227 (42000): Access denied; you need (at least one of) the CREATE USER privilege(s) for this operation3 causes - MySQL 8 refuses sql_mode NO_AUTO_CREATE_USER from a dump or config
ERROR 1231 (42000): Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'3 causes - MySQL error 1235: 'doesn't yet support LIMIT & IN/ALL/ANY/SOME subquery'
ERROR 1235 (42000): This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'2 causes - A subquery in FROM fails with: Every derived table must have its own alias
ERROR 1248 (42000): Every derived table must have its own alias3 causes - ERROR 1264: Out of range value for column on INSERT
ERROR 1264 (22003): Out of range value for column 'i1' at row 13 causes - MySQL error 1273: Unknown collation utf8mb4_0900_ai_ci
ERROR 1273 (HY000): Unknown collation: 'utf8mb4_0900_ai_ci'3 causes - MySQL refuses writes: 'running with the --read-only option'
ERROR 1290 (HY000): The MySQL server is running with the --read-only option so it cannot execute this statement2 causes - MySQL error 1292 on a statement that compares text with a number
ERROR 1292 (22007): Truncated incorrect DOUBLE value: 'grape'2 causes - MySQL rejects text with ERROR 1300: Invalid utf8mb4 character string
ERROR 1300 (HY000): Invalid utf8mb4 character string: 'Paysand'2 causes - MySQL error 1305: the function you call does not exist
ERROR 1305 (42000): FUNCTION mydb.my_func does not exist3 causes - A trigger fails with error 1363 because it reads a row that does not exist for that event
ERROR 1363 (HY000): There is no OLD row in on INSERT trigger3 causes - CREATE USER fails with error 1396
CREATE USER is refused for an account whose user and host already exist (error 1396)3 causes - MySQL rejects an INSERT with Data too long for column
ERROR 1406 (22001): Data too long for column 'description' at row 12 causes - A trigger or stored function fails with error 1442 on its own table
ERROR 1442 (HY000): Can't update table 'orders' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.2 causes - MySQL refuses to delete a row because other rows point to it
ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails3 causes - MySQL ERROR 1524: the auth_socket plugin is not loaded
ERROR 1524 (HY000): Plugin 'auth_socket' is not loaded2 causes - Cannot drop index: needed in a foreign key constraint (MySQL 1553)
ERROR 1553 (HY000): Cannot drop index 'index_name': needed in a foreign key constraint2 causes - MySQL rejects a new password with error 1819
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements3 causes - Adding a foreign key fails: missing index in the referenced table
Error Code: 1822. Failed to add the foreign key constraint. Missing index for constraint 'fk_orders_customer' in the referenced table 'customers'2 causes - MySQL refuses a foreign key because it cannot open the parent table
ERROR 1824 (HY000): Failed to open the referenced table 'parent'3 causes - MySQL ERROR 1832: cannot change a column used in a foreign key
ERROR 1832 (HY000): Cannot change column 'user_id': used in a foreign key constraint 'fk_orders_user'3 causes - Error 2005: Unknown MySQL server host, including 'localhost'
ERROR 2005 (HY000): Unknown MySQL server host 'localhost' (11001)2 causes - The connection to MySQL dropped while a query was running (error 2013)
ERROR 2013 (HY000): Lost connection to MySQL server during query4 causes - MySQL ERROR 2026 (HY000): SSL connection error when connecting from Django or the client
ERROR 2026 (HY000): SSL connection error: <reason>3 causes - Error 2068: the client rejected your LOAD DATA LOCAL INFILE file
ERROR 2068 (HY000): LOAD DATA LOCAL INFILE file request rejected due to restrictions on access.2 causes - Laravel migration fails on managed MySQL because a table has no primary key
SQLSTATE[HY000]: General error: 3750 Unable to create or change a table without a primary key, when the system variable 'sql_require_primary_key' is set.3 causes - Adding a foreign key fails because the two columns do not match
ERROR 3780 (HY000): Referencing column 'user_id' and referenced column 'id' in foreign key constraint 'fk_orders_user' are incompatible.2 causes - Restoring a dump stops with ERROR at line N: Unknown command
ERROR at line 1153: Unknown command '\''2 causes - MySQL fails with Error writing file ... (errno 28)
Error writing file '/tmp/MLwr8FX1' (Errcode: 28)3 causes - MySQL says execute command denied to user for routine
Execute command denied to user ''@'localhost' for routine3 causes - mysqld will not start after a generic binary install
Failed to find valid data directory.3 causes - C# INSERT fails with 'Fatal error encountered during command execution'
Fatal error encountered during command execution.3 causes - MySQL error 1364: Field 'id' doesn't have a default value on INSERT
ERROR 1364 (HY000): Field 'id' doesn't have a default value3 causes - MySQL gives a syntax error on FULL OUTER JOIN
1064 syntax error near FULL OUTER JOIN2 causes - Cannot run GRANT as root: access denied for user 'root'@'localhost'
ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'mydb'4 causes - The GRANT ran without an error, but the user is still refused
ERROR 1044 (42000): Access denied for user 'app'@'localhost' to database 'shop'3 causes - MySQL refuses to compare two strings: illegal mix of collations
ERROR 1267 (HY000): Illegal mix of collations (utf8mb4_bin,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '='3 causes - Importing a mysqldump file fails at line 1 with strange characters
ERROR 1064 (42000) at line 1 when importing a .sql dump3 causes - IMPORT TABLESPACE fails because the tablespace still exists
ERROR: Tablespace for table 'xxx' exists. Please DISCARD the tablespace before IMPORT3 causes - MySQL rejects a date with 'Incorrect date value' on INSERT
Incorrect date value: '31-12-2024'3 causes - MySQL rejects text with 'Incorrect string value' (emoji and other characters)
Mysql2::Error: Incorrect string value: '\xF0\x9F\x98\x80' for column 'body' at row 13 causes - InnoDB warning: page_cleaner 1000ms intended loop took longer, settings might not be optimal
InnoDB: page_cleaner: 1000ms intended loop took XXX ms. The settings might not be optimal.3 causes - MySQL or MariaDB will not start: unable to lock ibdata1
[ERROR] InnoDB: Unable to lock ./ibdata1 error: 112 causes - INSERT ... VALUES with a WHERE clause gives a syntax error
ERROR 1064 (42000): ... near 'WHERE' at line 13 causes - JDBC cannot talk to MySQL: Communications link failure
com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure3 causes - MySQL: could not create connection to database server
MySQLNonTransientConnectionException: Could not create connection to database server3 causes - Connector/J cannot work out the MySQL server time zone
The server time zone value 'XXX' is unrecognized or represents more than one time zone.2 causes - LOAD DATA turns empty CSV fields into 0 or fails with Data truncated
ERROR 1265 (01000): Data truncated for column 'price' at row 13 causes - LOAD DATA INFILE fails with 'Access denied' for a normal MySQL user
ERROR 1045 (28000): Access denied for user3 causes - LOAD DATA INFILE cannot find the file it was given
Can't get stat of '/home/me/data.csv' (OS errno 2 - No such file or directory)3 causes - LOAD DATA LOCAL INFILE is refused: loading local data is disabled
ERROR 3950 (42000): Loading local data is disabled; this must be enabled on both the client and server side3 causes - A statement waited for a lock held by another transaction and gave up (error 1205)
ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction4 causes - MySqlException: Timeout expired in a .NET app
MySql.Data.MySqlClient.MySqlException: Timeout expired3 causes - What the note 'Table does not support optimize, doing recreate + analyze instead' means
Table does not support optimize, doing recreate + analyze instead3 causes - A MySQL query becomes very slow as soon as it has an ORDER BY
Using filesort4 causes - mysql warns about a password on the command line in a script
mysql: [Warning] Using a password on the command line interface can be insecure.2 causes - MySQL: Table 'performance_schema.session_variables' doesn't exist
ERROR 1146 (42S02): Table 'performance_schema.session_variables' doesn't exist2 causes - MySQL error 1615: prepared statement needs to be re-prepared
ER_NEED_REPREPARE (error 1615, SQLSTATE HY000)2 causes - JDBC says Public Key Retrieval is not allowed when connecting to MySQL
Public Key Retrieval is not allowed3 causes - MySQL accepts local logins but refuses connections from other machines
Can't connect to MySQL server on 'host' (111)4 causes - REPLACE() leaves the line breaks in a MySQL text column
REPLACE(column, '\n', ' ') returns the text with its line breaks still there4 causes - Replication stopped: error 1032, coordinator stopped because of worker errors
Last_SQL_Errno: 10323 causes - LOAD DATA INFILE or INTO OUTFILE blocked by --secure-file-priv
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement3 causes - mysql_secure_installation cannot set the root password on Ubuntu
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements2 causes - MySQL SELECT ... INTO says Undeclared variable
ERROR 1327 (42000): Undeclared variable: total4 causes - MySQL start fails with: the server quit without updating the PID file
Can't start server: Bind on TCP/IP port: Address already in use3 causes - MySQL logs keep warning that sha256_password is deprecated
Server error log lines that name the sha256_password plugin as deprecated2 causes - SHOW DATABASES lists only some of the databases that exist
SHOW DATABASES does not list all of my databases3 causes - MySQL root password reset fails: skip-grant-tables will not run ALTER USER
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement3 causes - C# cannot reach MySQL: connection attempt failed, no response in time
A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond3 causes - MySQL rejects CREATE TABLE ... TYPE=MyISAM from an old script
mysql error 'TYPE=MyISAM'3 causes - MySQL says a table is marked as crashed and must be repaired
Table 'wp_options' is marked as crashed and should be repaired4 causes - MySQL 'Too many connections' when PHP opens database connections
Too many connections3 causes - TRUNCATE TABLE only when the table exists: there is no IF EXISTS
ERROR 1146 (42S02): Table 'mydb.staging_events' doesn't exist4 causes - MySqlException: unable to connect to any of the specified MySQL hosts
Unable to connect to any of the specified MySQL hosts4 causes - A MySQL zero date or out-of-range value breaks DateTime reads in .NET
Unable to convert MySQL date/time value to System.DateTime3 causes - MySQL or XAMPP will not start: unknown variable innodb_additional_mem_pool_size
unknown variable 'innodb_additional_mem_pool_size=2M'2 causes - UPDATE ... CONCAT wipes the column or writes 0 instead of the joined text
CONCAT() returns NULL if any argument is NULL2 causes - Warning 1681: integer display width is deprecated
Warning: #1681 Integer display width is deprecated and will be removed in a future release.2 causes - MySQL is installed on Windows but there is no MySQL service
NET START MySQL fails because no service named MySQL exists3 causes - MySQL service will not start on Windows: System error 1067 has occurred
System error 1067 has occurred.2 causes - MySQL Workbench says it cannot connect to the server on localhost:3306
Can't connect to MySQL server on 'localhost' (10061)4 causes - MySQL Workbench's Table Data Import Wizard takes hours on a big CSV
The Table Data Import Wizard sits on the import step for hours3 causes - pip install mysqlclient fails on a Mac
pip install mysqlclient ends with a build error on macOS3 causes - pip install mysqlclient fails to build on Windows, Linux or macOS
fatal error C1083: Cannot open include file: 'mysql.h': No such file or directory3 causes - mysqld cannot create binlog.index: OS errno 13, Permission denied
mysqld: File '.\binlog.index' not found (OS errno 13 - Permission denied)3 causes - mysqld stops with 'Please read Security section ... run mysqld as root'
Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!4 causes - systemctl says Job for mysqld.service failed because the control process exited
Job for mysqld.service failed because the control process exited with error code.4 causes - mysqld.service refuses to start: start request repeated too quickly
mysqld.service: Start request repeated too quickly.3 causes - mysqldump says access denied even though the user has ALL on the database
Access denied; you need (at least one of) the PROCESS privilege(s) for this operation3 causes - mysqldump is not recognised or says command not found
mysqldump: command not found2 causes - mysqldump says access denied (1045) with a password that works elsewhere
Access denied for user 'root'@'localhost' (using password: YES)3 causes - mysqldump stops with Unknown table 'COLUMN_STATISTICS' in information_schema
Unknown table 'COLUMN_STATISTICS' in information_schema (1109)3 causes - NestJS connects to MySQL at ::1 and is refused
Error: connect ECONNREFUSED ::1:33062 causes - NestJS cannot open an SSL connection to a managed Postgres database
DEPTH_ZERO_SELF_SIGNED_CERT4 causes - Node.js MySQL: Cannot enqueue Query after a fatal error
Error: Cannot enqueue Query after fatal error.2 causes - Node.js cannot reach MySQL: connect ETIMEDOUT
Error: connect ETIMEDOUT4 causes - MySQL says Too many connections to a Node.js app
Error: ER_CON_COUNT_ERROR: Too many connections3 causes - Node.js says the MySQL server closed the connection
Error: Connection lost: The server closed the connection.3 causes - node-oracledb DPI-1047 and libclntsh.so cannot open shared object file
DPI-1047: Cannot locate an Oracle Client library5 causes - node-postgres fails locally with 'The server does not support SSL connections'
Error: The server does not support SSL connections3 causes - node-redis throws ConnectionTimeoutError on connect
ConnectionTimeoutError: Connection timeout3 causes - node-redis throws The client is closed when you send a command
ClientClosedError: The client is closed3 causes - Npgsql refuses a local DateTime for a timestamp with time zone column
Cannot write DateTime with Kind=Local to PostgreSQL type 'timestamp with time zone'3 causes - Npgsql throws 'Exception while reading from stream' against PostgreSQL
Npgsql.NpgsqlException: Exception while reading from stream3 causes - pyodbc cannot find the SQL Server ODBC driver on Linux
Can't open lib 'ODBC Driver 17 for SQL Server' : file not found3 causes - pandas read_sql fails with Execution failed on sql ... sqlite_master on a MySQL connection
pandas.errors.DatabaseError: Execution failed on sql 'SELECT name FROM sqlite_master WHERE type='table' AND name=?;'3 causes - PHP throws "could not find driver" when it opens a PDO connection
PDOException: could not find driver4 causes - pg_dump refuses to run: server version is newer than pg_dump
pg_dump: error: aborting because of server version mismatch3 causes - gem install pg fails because the libpq header files are missing
Can't find the 'libpq-fe.h header3 causes - pg_restore refuses a dump file as not a valid archive
pg_restore: [archiver] input file does not appear to be a valid archive3 causes - pg_restore prints role does not exist for owners and grants after a move to a new server
could not execute query: ERROR: role "xxx" does not exist3 causes - pgAdmin 4 will not let you edit rows in the data grid
Cells in View/Edit Data cannot be edited2 causes - A table you created does not appear in the pgAdmin 4 browser tree
Table created, but not shown under Schemas > public > Tables4 causes - pgAdmin 4 never finishes loading after you open it
pgAdmin 4 shows the loading spinner forever2 causes - pgAdmin cannot connect to the PostgreSQL server: timeout expired
Timeout expired4 causes - pgAdmin says the utility file was not found and asks for a Binary Path
Utility file not found. Please configure the Binary Path in the Preferences dialog.3 causes - A pgvector distance query fails with 'operator does not exist'
ERROR: operator does not exist: <type> <-> <type>3 causes - Postgres cannot find the vector type for pgvector
ERROR: type "vector" does not exist3 causes - Building pgvector on Windows with nmake fails
PGROOT is not set3 causes - PHP cannot log in because the database says your host is not allowed
Warning: mysqli::__construct(): (HY000/1130): Host is not allowed to connect to this MariaDB server3 causes - phpMyAdmin: Access denied for user 'root'@'localhost'
#1045 - Access denied for user 'root'@'localhost' (using password: NO)4 causes - phpMyAdmin shows 'Cannot connect: invalid settings' on its Access denied page
Access denied!3 causes - phpMyAdmin rejects a CSV import with Invalid column count on line 1
Invalid column count in CSV input on line 1.4 causes - phpMyAdmin will not import a big SQL file
Import fails with a file size or upload error in phpMyAdmin4 causes - phpMyAdmin stops an import and asks you to resubmit the file
Script timeout passed, if you want to finish import, please resubmit the same file and import will resume3 causes - pip cannot build the mariadb package because mariadb_config is missing
mariadb_config not found.3 causes - PostGIS is installed, but type "geometry" does not exist
ERROR: type "geometry" does not exist3 causes - Adding months to a date in PostgreSQL fails or returns the wrong type
Adding months to a date in PostgreSQL gives a syntax error3 causes - Adding a NOT NULL column to a table that already has rows
ERROR: column "zipcode" of relation "distributors" contains null values3 causes - ALTER SCHEMA ... OWNER TO never finishes in PostgreSQL
ALTER SCHEMA sales OWNER TO app_owner; runs for minutes with no result4 causes - Postgres.app on macOS will not start a server on port 5432
Port 5432 is already in use4 causes - INSERT into an array column fails with a malformed array literal
ERROR: array value must start with "{" or dimension information3 causes - cached plan must not change result type after an ALTER TABLE
ERROR: cached plan must not change result type3 causes - Queries on a PostgreSQL standby get canceled while replication replays
ERROR: canceling statement due to conflict with recovery3 causes - ALTER COLUMN TYPE blocked because a view uses the column
ERROR: cannot alter type of a column used by a view or rule3 causes - DROP TABLE is refused because a view or foreign key points at it
ERROR: cannot drop table users because other objects depend on it3 causes - DROP DATABASE fails because it is the database you are connected to
pq: cannot drop the currently open database3 causes - PostgreSQL refuses writes: cannot execute CREATE TABLE in a read-only transaction
ERROR: cannot execute CREATE TABLE in a read-only transaction3 causes - CASE WHEN does not match NULL values in PostgreSQL
CASE WHEN col = NULL THEN ... never fires3 causes - PostgreSQL cluster fails to start with pg_ctlcluster on Ubuntu or Debian
Failed to start PostgreSQL Cluster 16-main.3 causes - PostgreSQL warns about a collation version mismatch after an OS upgrade
WARNING: database "mydb" has a collation version mismatch3 causes - ALTER COLUMN TYPE says the column cannot be cast automatically
ERROR: column "amount" cannot be cast automatically to type integer3 causes - PostgreSQL wants column types for a function that returns record
ERROR: 42601: a column definition list is required for functions returning "record"3 causes - ERROR: column does not exist, though you can see it in the table
ERROR: column "firstname" does not exist3 causes - PostgreSQL refuses to store a text value in an integer column
ERROR: column "qty" is of type integer but expression is of type text3 causes - psql or pgAdmin gets Connection refused from a Postgres container
psql: error: connection to server at "localhost" (::1), port 5432 failed: Connection refused4 causes - Cannot connect to PostgreSQL on port 5432 from another machine
psql: error: connection to server at "203.0.113.10", port 5432 failed: Connection refused3 causes - ALTER TABLE ADD CONSTRAINT fails because the constraint already exists in PostgreSQL
ERROR: constraint "my_constraint" for relation "my_table" already exists2 causes - Importing a CSV into a json column fails on a single quote
ERROR: invalid input syntax for type json3 causes - Importing a CSV into PostgreSQL fails with Permission denied
Permission denied when importing a CSV file from pgAdmin3 causes - COPY fails on a CSV with invalid input syntax for an integer column
ERROR: invalid input syntax for integer4 causes - psql \copy stops with 'missing data for column' while loading a CSV file
ERROR: missing data for column "email"3 causes - PostgreSQL will not start: permission denied on the SSL private key
FATAL: could not access private key file "/etc/ssl/private/ssl-cert-snakeoil.key": Permission denied2 causes - PostgreSQL cannot work out the type of a null query parameter from Hibernate
ERROR: could not determine data type of parameter $13 causes - A Postgres query in Docker fails with: could not resize shared memory segment
pq: could not resize shared memory segment "/PostgreSQL.1234567890" to 67145856 bytes: No space left on device2 causes - PostgreSQL refuses CREATE DATABASE because a transaction is open
ERROR: CREATE DATABASE cannot run inside a transaction block3 causes - CREATE DATABASE fails because template1 is being accessed by other users
ERROR: source database "template1" is being accessed by other users2 causes - createdb fails with permission denied to create database
createdb: database creation failed: ERROR: permission denied to create database2 causes - The Postgres container refuses to start: data directory has invalid permissions
FATAL: data directory "/var/lib/postgresql/data/pgdata" has invalid permissions3 causes - PostgreSQL rejects a day/month/year date string as out of range
ERROR: date/time field value out of range: "30/12/2014 23:58:04"3 causes - The postgres container exits when ssl=on and a mounted certificate
Postgres unable to load ssl certificate3 causes - The postgres container exits at start and asks for a superuser password
Error: Database is uninitialized and superuser password is not specified.3 causes - DROP DATABASE fails because other sessions are connected
ERROR: database "mydb" is being accessed by other users3 causes - DROP ROLE refuses because the role still owns objects or has default privileges
ERROR: role "doomed_role" cannot be dropped because some objects depend on it4 causes - CREATE DATABASE with UTF8 fails because the inherited locale needs LATIN1
ERROR: encoding "UTF8" does not match locale "en_US"3 causes - PostgreSQL says function dblink(unknown, unknown) does not exist
ERROR: function dblink(unknown, unknown) does not exist3 causes - gen_random_uuid() fails on an older PostgreSQL server
SELECT gen_random_uuid(); fails on a PostgreSQL 12 or older server3 causes - C compiler cannot find postgres.h when building a PostgreSQL extension
fatal error: 'postgres.h' file not found2 causes - brew services says PostgreSQL started, but psql cannot connect
brew services list shows postgresql@17 as started, yet psql cannot connect3 causes - Ident authentication failed for user when connecting over TCP
FATAL: Ident authentication failed for user "postgres"3 causes - The shell says initdb: command not found after installing PostgreSQL
initdb: command not found3 causes - The Postgres container cannot set permissions on a bind-mounted data folder
initdb: error: could not change permissions of directory "/var/lib/postgresql/data": Operation not permitted3 causes - The Postgres container cannot initialise because its data directory already has files
initdb: error: directory "/var/lib/postgresql/data" exists but is not empty3 causes - INSERT has more target columns than expressions, but the counts look equal
ERROR: INSERT has more target columns than expressions3 causes - invalid byte sequence for encoding UTF8 while importing data
ERROR: invalid byte sequence for encoding "UTF8": 0xe92 causes - The text 'null' is being sent to a double precision column
ERROR: invalid input syntax for type double precision: "null"2 causes - invalid input syntax for type json when a column mixes JSON and plain text
ERROR: invalid input syntax for type json3 causes - PostgreSQL fails with invalid memory alloc request size on a large value
org.postgresql.util.PSQLException: Invalid Memory Alloc Request size2 causes - PostgreSQL will not start: invalid resource manager ID in primary checkpoint record
invalid resource manager ID in primary checkpoint record2 causes - PostgreSQL does not know the time zone name Europe/Kyiv
ERROR: invalid value for parameter "TimeZone": "Europe/Kyiv"3 causes - JDBC cannot log in to PostgreSQL: authentication type 10
org.postgresql.util.PSQLException: The authentication type 10 is not supported.3 causes - PostgreSQL JDBC: an I/O error occurred while sending to the backend
org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.3 causes - executeQuery on an INSERT or UPDATE throws in PostgreSQL JDBC
org.postgresql.util.PSQLException: No results were returned by the query.2 causes - Saving a UUID through JDBC fails with a type mismatch
ERROR: column "id" is of type uuid but expression is of type character varying3 causes - Querying for null values inside a JSON column returns the wrong rows
WHERE data -> 'email' IS NULL returns fewer rows than expected3 causes - A jsonb query is slow and the GIN index is never used
Seq Scan on a table with a GIN index on the jsonb column3 causes - PostgreSQL 'missing FROM-clause entry for table' and 'invalid reference to FROM-clause entry'
ERROR: missing FROM-clause entry for table "cities"3 causes - A subquery used as a single value returns several rows
ERROR: more than one row returned by a subquery used as an expression3 causes - CREATE SCHEMA AUTHORIZATION fails with must be member of role
ERROR: must be member of role "app_owner"3 causes - PostgreSQL says must be owner of relation when you alter a table or change its owner
ERROR: must be owner of relation3 causes - PostgreSQL cannot create a table because search_path has no valid schema
SQLSTATE 3F000 (invalid_schema_name)4 causes - The Postgres container cannot write postmaster.pid because Docker is out of disk
FATAL: could not write lock file "postmaster.pid": No space left on device3 causes - Creating a foreign key fails: no unique constraint matches the referenced columns
ERROR: there is no unique constraint matching given keys for referenced table "bar"3 causes - A PostgreSQL query with NOT IN returns nothing when the subquery contains NULL
(0 rows) from a SELECT with WHERE col NOT IN (SELECT ...) although you know unmatched rows exist3 causes - A PostgreSQL query drops rows with NULL when you use = NULL, <> or NOT LIKE
SELECT * FROM t WHERE col = NULL returns (0 rows)3 causes - INSERT fails because the id column receives null
ERROR: null value in column "id" violates not-null constraint3 causes - An upsert fails because one INSERT would change the same row twice
ERROR: ON CONFLICT DO UPDATE command cannot affect row a second time4 causes - ON CONFLICT still raises a duplicate key error when a table has several unique constraints
ERROR: duplicate key value violates unique constraint3 causes - INSERT ... ON CONFLICT fails because no unique constraint matches the conflict target
ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification4 causes - INSERT ... ON CONFLICT ... RETURNING gives back no row for the existing record
An empty RETURNING result when the row already exists3 causes - operator does not exist when comparing an integer to text
ERROR: operator does not exist: integer = character varying3 causes - The Postgres container rejects the password you set in POSTGRES_PASSWORD
FATAL: password authentication failed for user "postgres"2 causes - Peer authentication failed for user, on a local PostgreSQL connection
FATAL: Peer authentication failed for user "postgres"3 causes - A role cannot create tables in the public schema after upgrading to PostgreSQL 15
ERROR: permission denied for schema public3 causes - INSERT fails with permission denied for sequence
ERROR: permission denied for sequence cities_id_seq3 causes - A read-only role gets permission denied on a table it should read
ERROR: permission denied for table orders3 causes - CREATE EXTENSION fails for a role that is not a superuser
ERROR: permission denied to create extension "hstore"3 causes - You search a Mac for pg_hba.conf or postgresql.conf and find nothing
No such file or directory3 causes - pg_stat_statements is in the config but the view cannot be queried
ERROR: relation "pg_stat_statements" does not exist3 causes - psql or pg_dump still asks for a password although ~/.pgpass exists
Password:4 causes - A query fills the disk with temporary files: could not write to pgsql_tmp
ERROR: could not write to file "base/pgsql_tmp/pgsql_tmp32058.285": No space left on device3 causes - make fails because pgxs.mk is missing when building a PostgreSQL extension
Makefile:10: /usr/pgsql-14/lib/pgxs/src/makefiles/pgxs.mk: No such file or directory2 causes - CREATE EXTENSION postgis fails: could not open extension control file (Homebrew)
ERROR: could not open extension control file3 causes - psql on Windows warns that the console code page differs from the Windows code page
WARNING: Console code page (437) differs from Windows code page (1252)3 causes - ERROR: relation does not exist for a table that is there
ERROR: relation "users" does not exist3 causes - PostgreSQL error: column c.relhasoids does not exist
ERROR: column c.relhasoids does not exist2 causes - Reset the postgres password when you cannot log in to PostgreSQL
FATAL: password authentication failed for user "postgres"3 causes - A PostgreSQL restore fails on foreign key constraints
violates foreign key constraint3 causes - psql says the role does not exist, even for postgres or your own user
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: role "postgres" does not exist3 causes - Postgres in Docker says the role "root" does not exist
FATAL: role "root" does not exist3 causes - PostgreSQL says function round(double precision, integer) does not exist
ERROR: function round(double precision, integer) does not exist2 causes - Password authentication failed right after switching pg_hba.conf from md5 to scram-sha-256
FATAL: password authentication failed for user "appuser"3 causes - SELECT DISTINCT fails because ORDER BY uses a column that is not selected
ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list3 causes - Adding NOT NULL and a default to a column without a long table lock
ERROR: column "status" of relation "orders" contains null values3 causes - A PostgreSQL query is fast without LIMIT but slow with ORDER BY ... LIMIT
SELECT ... ORDER BY created_at DESC LIMIT 10 takes seconds, while the same query without LIMIT is fast4 causes - ERROR: subquery must return only one column
ERROR: subquery must return only one column2 causes - PostgreSQL rejects a name or value that contains a hyphen
ERROR: syntax error at or near "-"3 causes - Creating or querying a table named user fails in PostgreSQL
ERROR: syntax error at or near "user"2 causes - A statement lists the same table, or the same alias, twice
ERROR: table name "orders" specified more than once3 causes - PostgreSQL UNION fails because the column types do not match
ERROR: UNION types text and bigint cannot be matched3 causes - A UNIQUE constraint in PostgreSQL still lets duplicate rows in when a column is NULL
The second identical row with a NULL is accepted instead of failing with a duplicate key error3 causes - A primary key or unique index on a partitioned table is rejected
Creating a PRIMARY KEY on a partitioned table fails when the key lacks the partition column3 causes - PostgreSQL says a quoted string was never closed
ERROR: unterminated quoted string at or near3 causes - A DELETE is refused because another table still points at the row
ERROR: update or delete on table "tablename" violates foreign key constraint4 causes - Why Postgres rejects a table alias in front of the column in UPDATE SET
UPDATE orders AS o SET o.status = 'shipped' WHERE o.id = 7;3 causes - A simple UPDATE on a table with millions of rows takes forever
UPDATE on millions of rows runs for many minutes4 causes - A table with capital letters cannot be found in PostgreSQL
Why PostgreSQL does not like uppercase table names3 causes - The uuid-ossp extension is listed, but uuid_generate_v4() still fails
SELECT uuid_generate_v4(); fails although CREATE EXTENSION reported success3 causes - An insert fails with value too long for type character varying(500)
ERROR: value too long for type character varying(500)3 causes - Hibernate insert fails: column is of type bit but expression is of type boolean
ERROR: column "active" is of type bit but expression is of type boolean3 causes - PostgreSQL says postgresql.conf has errors and a setting does not apply
postgresql.conf contains errors3 causes - pgjdbc says the column index is out of range, number of columns: 0
org.postgresql.util.PSQLException: The column index is out of range: 1, number of columns: 0.3 causes - Power BI cannot validate the SSL certificate of an RDS PostgreSQL server
An error happened while reading data from the provider: The remote certificate is invalid according to the validation procedure.2 causes - Prisma with MongoDB fails when you create a User
prisma.user.create() fails against MongoDB in a Next.js route or server action3 causes - Prisma says P1000: the database credentials are not valid
P1000: Authentication failed against database server at `localhost`, the provided database credentials for `postgres` are not valid.3 causes - Prisma says it can't reach the database server, but the database is up
Error: P1001: Can't reach database server at `localhost`:`5432`4 causes - Prisma P1010: the database user was denied access
P1010: User `app_user` was denied access on the database `appdb`3 causes - Prisma fails with prepared statement s0 already exists behind a pooler
Error: undefined: Database error3 causes - The shell says psql: command not found
-bash: psql: command not found2 causes - psql cannot connect: no such file or directory on the Unix socket
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory3 causes - psql prints invalid command \N many times during a restore
invalid command \N3 causes - A psql script prints ERROR lines, runs on, and the shell sees success
ERROR: relation "orders" does not exist3 causes - psycopg2 cannot connect: connection refused on port 5432
psycopg2.OperationalError: connection to server at "localhost" (127.0.0.1), port 5432 failed: Connection refused3 causes - psycopg2 cannot resolve the host name db in Docker Compose
psycopg2.OperationalError: could not translate host name "db" to address4 causes - pip install psycopg2 fails with 'Failed building wheel for psycopg2'
ERROR: Failed building wheel for psycopg23 causes - InFailedSqlTransaction: commands ignored until end of transaction block
psycopg2.errors.InFailedSqlTransaction: current transaction is aborted, commands ignored until end of transaction block3 causes - psycopg2 hangs with no timeout: connect, query and dead connections
The script hangs on psycopg2.connect() with no error4 causes - psycopg2 fails with: server closed the connection unexpectedly
psycopg2.OperationalError: server closed the connection unexpectedly3 causes - psycopg2 fails with SSL SYSCALL error: EOF detected on a PostgreSQL connection
psycopg2.OperationalError: SSL SYSCALL error: EOF detected3 causes - psycopg2 raises a syntax error because of how the query is built
psycopg2.errors.SyntaxError: syntax error at or near ...4 causes - pyodbc says the data source name was not found and no default driver was specified
pyodbc.InterfaceError: IM002 Data source name not found and no default driver specified3 causes - TypeError when you subtract or compare two Python datetimes
TypeError: can't subtract offset-naive and offset-aware datetimes3 causes - Python stops with UnicodeDecodeError: 'charmap' codec can't decode byte
UnicodeDecodeError: 'charmap' codec can't decode byte 0x81 in position 3852: character maps to <undefined>3 causes - Python cannot import psycopg2 even though you installed it
ModuleNotFoundError: No module named 'psycopg2'3 causes - Your laptop cannot reach an RDS database, and ping does not work either
Could not connect to server: Connection timed out4 causes - A dump restore into RDS fails on a DEFINER clause and asks for SUPER
Access denied; you need (at least one of) the SUPER privilege(s) for this operation2 causes - Creating a trigger or function on RDS fails because binary logging is on
ERROR 1419 (HY000): You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)2 causes - New connections to RDS PostgreSQL are refused because every normal slot is taken
FATAL: remaining connection slots are reserved for non-replication superuser connections2 causes - redis-cli says Connection refused on a Mac with Homebrew
Could not connect to Redis at 127.0.0.1:6379: Connection refused3 causes - Redis cannot save dump.rdb because it is not allowed to write there
Failed opening .rdb for saving: Permission denied3 causes - Redis answers every command with LOADING after a restart
LOADING Redis is loading the dataset in memory3 causes - A Flask or Sidekiq container cannot reach Redis on localhost:6379
Error 99 connecting to localhost:6379. Cannot assign requested address.4 causes - Redis answers NOAUTH Authentication required
NOAUTH Authentication required.3 causes - Redis refuses writes with OOM command not allowed
OOM command not allowed when used memory > 'maxmemory'3 causes - Sequelize fails with 'Operation timeout' while waiting for a connection
SequelizeConnectionAcquireTimeoutError: Operation timeout5 causes - SequelizeUniqueConstraintError: Validation error on insert
SequelizeUniqueConstraintError: Validation error3 causes - JdbcTemplate throws BadSqlGrammarException on a MySQL query
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar2 causes - Spring Boot does not create the schema on MySQL or PostgreSQL
Tables are created on H2 but not on MySQL or PostgreSQL3 causes - Spring Boot cannot configure a DataSource for PostgreSQL
Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could be configured.3 causes - Spring Boot stops at startup with flywayInitializer failing
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flywayInitializer'4 causes - Spring Boot cannot use the PostgreSQL JDBC URL it was given
Driver org.postgresql.Driver claims to not accept jdbcUrl, jdbc:postgresql://${DB_ADDR_ALIAS}:${DB_PORT}/${DB_NAME}3 causes - Spring Boot in a container cannot connect to the MySQL container
Communications link failure3 causes - Spring Boot stops with 'Unable to build Hibernate SessionFactory'
jakarta.persistence.PersistenceException: [PersistenceUnit: default] Unable to build Hibernate SessionFactory3 causes - @CreatedDate is not filled in when I save an entity
created_date is null after save()4 causes - Spring Data JPA rejects the @Query on one repository method
Validation failed for query for method3 causes - batchUpdate inserts one row at a time on MySQL
jdbcTemplate.batchUpdate() takes seconds for a few thousand rows3 causes - Spring Boot JPA cannot find the PostgreSQL table it maps to
org.springframework.dao.InvalidDataAccessResourceUsageException: JDBC exception executing SQL2 causes - Spring Boot cannot connect to Redis and shows the wrong host
io.lettuce.core.RedisConnectionException: Unable to connect to localhost:63792 causes - db.create_all() runs without an error but the tables never appear
db.create_all() finishes with no error and the database stays empty3 causes - SQLAlchemy cannot load the dialect plugin for a postgres:// URL
sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:postgres2 causes - Cannot log in as sa to SQL Server running in a Docker container
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Login failed for user 'SA'4 causes - StackExchange.Redis RedisTimeoutException in a .NET app
StackExchange.Redis.RedisTimeoutException4 causes - Strapi cannot reach PostgreSQL on 127.0.0.1:5432
Error: connect ECONNREFUSED 127.0.0.1:54323 causes - apt cannot find the postgresql package on Ubuntu
E: Unable to locate package postgresql2 causes - XAMPP MySQL stops right after you start it
Error: MySQL shutdown unexpectedly.3 causes
Next step
Something here keeps breaking?
I fix these for clients and run the same stack in production myself.