Error map
08P01 ERROR: bind message supplies 2 parameters, but prepared statement requires 1
PostgreSQL · layer 5, Data
Centre: this error. First ring: errors it is linked with (12). Outer ring: what those are linked with. Colours show the layer of a request each error belongs to. Click any dot to re-centre the map on it; hover to follow its connections. The centre dot opens the error page.
Directly related (12)
pg_dump: error: aborting because of server version mismatch
Your pg_dump client is older than the server you’re dumping.
Blue Screen: IRQL_NOT_LESS_OR_EQUAL (Stop code 0x0000000A)
A driver accessed memory at an interrupt level where that’s not allowed — almost always a faulty or incompatible driver, sometime…
ERROR: prepared statement "s1" already exists (PgBouncer transaction mode)
Named prepared statements collided — typically because PgBouncer in transaction pooling mode hands connections between clients.
ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification
INSERT … ON CONFLICT (cols) names columns that don’t have a matching unique index/constraint.
pg_restore: error: input file appears to be a text format dump. Please use psql.
A plain .sql dump was given to pg_restore, which only reads custom/directory/tar formats.
MySQL ERROR 1093 (HY000): You can't specify target table 'x' for update in FROM clause
An UPDATE/DELETE uses a subquery that reads from the same table, which MySQL doesn’t allow directly.
ERROR: currval of sequence "x" is not yet defined in this session
currval() was called before nextval() in the same session.
IncorrectResultSizeDataAccessException: query did not return a unique result: 2
A query expected one row but found several.
MySQL ERROR 1175 (HY000): You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
MySQL Workbench’s safe updates mode blocked an UPDATE/DELETE without a key-based WHERE.
MySQL ERROR 1241 (21000): Operand should contain 1 column(s)
A subquery or expression returned several columns where only one is expected.
ERROR: current transaction is aborted, commands ignored until end of transaction block
An earlier statement in the same transaction failed; PostgreSQL rejects everything until you ROLLBACK.
ERROR: database "x" is being accessed by other users — There is 1 other session using the database.
DROP/RENAME DATABASE can’t run while other sessions are connected.
Two steps away (24)
[nodemon] app crashed - waiting for file changes before starting...
Your app threw an error on startup; nodemon is waiting for a file change to retry.
npm ERR! could not determine executable to run
npx couldn’t find a binary to run for that package.
ERROR: canceling statement due to statement timeout
A query ran longer than statement_timeout and PostgreSQL cancelled it.
Blue Screen: CRITICAL_PROCESS_DIED (Stop code 0x000000EF)
A process Windows can’t run without (csrss, wininit, smss…) stopped unexpectedly, so the system halted.
Blue Screen: MEMORY_MANAGEMENT (Stop code 0x0000001A)
Windows detected a severe memory-management error — commonly faulty RAM, unstable memory settings or a bad driver.
ERROR: could not determine data type of parameter $1
PostgreSQL can’t infer a parameter’s type from context (e.g. $1 IS NULL or SELECT $1).
PostgreSQL: ERROR: column "x" does not exist
PostgreSQL can’t find the column — a missing migration, a case-sensitive quoted name, or a string literal written in double quote…
HikariPool-1 - Connection is not available, request timed out after 30000ms
The connection pool was exhausted — all connections were busy for 30 seconds.
ERROR: column "x" of relation "y" already exists
ALTER TABLE ADD COLUMN for a column that’s already there.
PostgreSQL: ERROR: duplicate key value violates unique constraint
An INSERT/UPDATE would create a duplicate in a UNIQUE or PRIMARY KEY column — or the id sequence is behind the existing data.
ERROR: insert or update on table "x" violates foreign key constraint "fk" — Key (user_id)=(5) is not present in table "users"
The row references a parent row that doesn’t exist.
ERROR: update or delete on table "users" violates foreign key constraint on table "orders" — Key (id)=(5) is still referenced
You tried to delete a row that other rows still reference.
ERROR: cannot drop table x because other objects depend on it
Views, foreign keys or other objects depend on what you’re dropping.
'react-scripts' is not recognized as an internal or external command / react-scripts: command not found
node_modules is missing or broken, so the react-scripts binary isn’t available.
Subquery returns more than 1 row (MySQL 1242) / more than one row returned by a subquery used as an expression
A subquery used where a single value is expected (`= (SELECT …)`) returned several rows.
ERROR: column "x" is of type integer but expression is of type text — HINT: You will need to rewrite or cast the expression.
An INSERT/UPDATE supplies a value of a different type than the column, and PostgreSQL won’t cast implicitly.
ERROR: operator does not exist: integer = text
A comparison or operation mixes types PostgreSQL won’t implicitly convert.
org.hibernate.LazyInitializationException: could not initialize proxy - no Session
A lazy-loaded association was accessed after the Hibernate session/transaction closed.
org.hibernate.TransientObjectException: object references an unsaved transient instance - save the transient instance before flushing
An entity references another entity that hasn’t been saved yet, and no cascade is configured.
org.hibernate.exception.ConstraintViolationException: could not execute statement
The database rejected an insert/update because of a constraint (unique, foreign key, not null).
Deadlock found when trying to get lock; try restarting transaction
Two transactions waited on each other’s locks; the database killed one so the other could continue.
Lock wait timeout exceeded; try restarting transaction (MySQL 1205)
A query waited too long for a row lock held by another transaction and gave up.
MySQL ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
MySQL detected a deadlock between two transactions and rolled one back.
LOG: could not bind IPv4 address "0.0.0.0": Address already in use — Is another postmaster already running on port 5432?
Another process (often a second PostgreSQL install or a container) already listens on 5432.
Map another error
Popular: 4035004000xC000007BTypeErrorCritical error404NullPointerException