MariaDB 공식 원문에 표시된 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use 항목의 문구를 확인하는 문서입니다.

참고 자료

PostgreSQL · 공식 자료

확인 범위: sqlstate-error-codes, condition-identification · 확인일: 2026-07-24

MySQL · 공식 자료

확인 범위: server-error-code, message-identification · 확인일: 2026-07-24

정상 동작 조건

확인 절차

관련 오류

Cannot truncate a table referenced in a foreign key constraint (%s)

Connection was killed

Query execution was interrupted (max_statement_time exceeded)

Access denied for user '%s'@'%s' to database '%s'

Cannot add or update a child row: a foreign key constraint fails

Can't create database '%s'; database exists

Can't drop database '%s'; database doesn't exist

Can't write; duplicate key in table '%s'

Column '%s' cannot be null

Column '%s' in %s is ambiguous

Table '%s' is read only

'%s' isn't in GROUP BY

No database selected

Out of range value for column '%s' at row %ld

Subquery returns more than 1 row

Table '%s' already exists

Table '%s.%s' doesn't exist

You must SET PASSWORD before executing this statement

unique_violation

42883

53300

Prisma needs to perform transactions, which requires your MongoDB server to be run as a replica set. See details: https://pris.ly/d/mongodb-replica-set

Authentication failed against database server at {database_host}, the provided database credentials for {database_user} are not valid. Please make sure to provide valid database credentials for the database server at {database_host}.

The database server at {database_host}:{database_port} was reached but timed out. Please try again. Please make sure your database server is running at {database_host}:{database_port}.

Database {database_name} already exists on the database server at {database_host}:{database_port}

User {database_user} was denied access on the database {database_name}

The provided database string is invalid. {details}

The underlying {kind} for model {model} does not exist.

Your Prisma schema is using features that are not supported for the version of the database. Database version: {database_version} Errors: {errors}

Your raw query had an incorrect number of parameters. Expected: {expected}, actual: {actual}.

Server has closed the connection.

The provided value for the column is too long for the column's type. Column: {column_name}

The record searched for in the where condition ({model_name}.{argument_name} = {argument_value}) does not exist

Unique constraint failed on the {constraint}

Foreign key constraint failed on the field: {field_name}

A constraint failed on the database: {database_error}

The value {field_value} stored in the database for the field {field_name} is invalid for the field's type

The provided value {field_value} for {model_name} field {field_name} is not valid

Data validation error {database_error}

Failed to parse the query {query_parsing_error} at {query_position}

Failed to validate the query: {query_validation_error} at {query_position}

Raw query failed. Code: {code}. Message: {message}

Missing a required value at {path}

Missing the required argument {argument_name} for field {field_name} on {object_name}.

The change you are trying to make would violate the required relation '{relation_name}' between the {model_a_name} and {model_b_name} models.

A related record could not be found. {details}

Query interpretation error. {details}

The records for relation {relation_name} between the {parent_name} and {child_name} models are not connected.

The required connected records were not found. {details}

Input error. {details}

Value out of range for the type. {details}

The table {table} does not exist in the current database.

The column {column} does not exist in the current database.

Inconsistent column data: {message}

Timed out fetching a new connection from the connection pool. (More info: http://pris.ly/d/connection-pool (Current connection pool timeout: {timeout}, connection limit: {connection_limit})

An operation failed because it depends on one or more records that were required but not found. {cause}

The current database provider doesn't support a feature that the query used: {feature}

Multiple errors occurred on the database during query execution: {errors}

Transaction API error: {error}

Query parameter limit exceeded error: {message}

Cannot find a fulltext index to use for the search, try adding a @@fulltext([Fields...]) to your schema

A number used in the query does not fit into a 64 bit signed integer. Consider using BigInt as field type if you're trying to store large integers

Transaction failed due to a write conflict or a deadlock. Please retry your transaction

Assertion violation on the database: {database_error}

Too many database connections opened: {message}

Failed to create database: {database_error}

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use

Unknown character set: '%s'

Unknown or incorrect time zone: '%s'

Unknown storage engine '%s'

Unknown table '%s'

Variable '%s' can't be set to the value of '%s'

참고 자료