All pages
Powered by GitBook
5 of 84

MariaDB Error Codes 1900 to 1999

Error 1900: "

Error Code
SQLSTATE
Error
Description

1900

ER_UNUSED_18

"

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1901: Function or expression cannot be used in the clause of

Error Code
SQLSTATE
Error
Description

1901

ER_GENERATED_COLUMN_FUNCTION_IS_NOT_ALLOWED

Function or expression '%s' cannot be used in the %s clause of %`s

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1902: "

Error Code
SQLSTATE
Error
Description

1902

ER_UNUSED_19

"

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1903: Primary key cannot be defined upon a generated column

Error Code
SQLSTATE
Error
Description

1903

ER_PRIMARY_KEY_BASED_ON_GENERATED_COLUMN

Primary key cannot be defined upon a generated column

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1904: Key/Index cannot be defined on a virtual generated column

Error Code
SQLSTATE
Error
Description

1904

ER_KEY_BASED_ON_GENERATED_VIRTUAL_COLUMN

Key/Index cannot be defined on a virtual generated column

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1905: Cannot define foreign key with clause on a generated column

Error Code
SQLSTATE
Error
Description

1905

ER_WRONG_FK_OPTION_FOR_GENERATED_COLUMN

Cannot define foreign key with %s clause on a generated column

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1906: The value specified for generated column in table has been ignored

Error Code
SQLSTATE
Error
Description

1906

ER_WARNING_NON_DEFAULT_VALUE_FOR_GENERATED_COLUMN

The value specified for generated column '%s' in table '%s' has been ignored

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1907: This is not yet supported for generated columns

Error Code
SQLSTATE
Error
Description

1907

ER_UNSUPPORTED_ACTION_ON_GENERATED_COLUMN

This is not yet supported for generated columns

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1908: "

Error Code
SQLSTATE
Error
Description

1908

ER_UNUSED_20

"

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1909: "

Error Code
SQLSTATE
Error
Description

1909

ER_UNUSED_21

"

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1910: storage engine does not support generated columns

Error Code
SQLSTATE
Error
Description

1910

ER_UNSUPPORTED_ENGINE_FOR_GENERATED_COLUMNS

%s storage engine does not support generated columns

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1911: Unknown option

Error Code
SQLSTATE
Error
Description

1911

ER_UNKNOWN_OPTION

Unknown option '%-.64s'

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1912: Incorrect value for option

Error Code
SQLSTATE
Error
Description

1912

ER_BAD_OPTION_VALUE

Incorrect value '%-.64s' for option '%-.64s'

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1913: You should never see it

Error Code
SQLSTATE
Error
Description

1913

ER_UNUSED_6

You should never see it

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1914: You should never see it

Error Code
SQLSTATE
Error
Description

1914

ER_UNUSED_7

You should never see it

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1915: You should never see it

Error Code
SQLSTATE
Error
Description

1915

ER_UNUSED_8

You should never see it

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1916: Got overflow when converting to. Value truncated

Error Code
SQLSTATE
Error
Description

1916

ER_DATA_OVERFLOW 22003

Got overflow when converting '%-.128s' to %-.32s. Value truncated.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1917: Truncated value when converting to

Error Code
SQLSTATE
Error
Description

1917

ER_DATA_TRUNCATED 22003

Truncated value '%-.128s' when converting to %-.32s

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1918: Encountered illegal value when converting to

Error Code
SQLSTATE
Error
Description

1918

ER_BAD_DATA 22007

Encountered illegal value '%-.128s' when converting to %-.32s

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1919: Encountered illegal format of dynamic column string

Error Code
SQLSTATE
Error
Description

1919

ER_DYN_COL_WRONG_FORMAT

Encountered illegal format of dynamic column string

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1920: Dynamic column implementation limit reached

Error Code
SQLSTATE
Error
Description

1920

ER_DYN_COL_IMPLEMENTATION_LIMIT

Dynamic column implementation limit reached

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1921: Illegal value used as argument of dynamic column function

Error Code
SQLSTATE
Error
Description

1921

ER_DYN_COL_DATA 22007

Illegal value used as argument of dynamic column function

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1922: Dynamic column contains unknown character set

Error Code
SQLSTATE
Error
Description

1922

ER_DYN_COL_WRONG_CHARSET

Dynamic column contains unknown character set

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1923: At least one of the 'in_to_exists' or 'materialization' optimizer_switch flags must be '

Error Code
SQLSTATE
Error
Description

1923

ER_ILLEGAL_SUBQUERY_OPTIMIZER_SWITCHES

At least one of the 'in_to_exists' or 'materialization' optimizer_switch flags must be 'on'.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1924: Query cache is disabled (resize or similar command in progress); repeat this command lat

Error Code
SQLSTATE
Error
Description

1924

ER_QUERY_CACHE_IS_DISABLED

Query cache is disabled (resize or similar command in progress); repeat this command later

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1925: Query cache is globally disabled and you can't enable it only for this session

Error Code
SQLSTATE
Error
Description

1925

ER_QUERY_CACHE_IS_GLOBALY_DISABLED

Query cache is globally disabled and you can't enable it only for this session

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1926: View ORDER BY clause ignored because there is other ORDER BY clause already

Error Code
SQLSTATE
Error
Description

1926

ER_VIEW_ORDERBY_IGNORED

View '%-.192s'.'%-.192s' ORDER BY clause ignored because there is other ORDER BY clause already.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1927: Connection was killed

Error Code
SQLSTATE
Error
Description

1927

70100

ER_CONNECTION_KILLED

Connection was killed

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1928: You should never see it

Error Code
SQLSTATE
Error
Description

1928

ER_UNUSED_11

You should never see it

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1929: Cannot modify @@session.skip_replication inside a transaction

Error Code
SQLSTATE
Error
Description

1929

ER_INSIDE_TRANSACTION_PREVENTS_SWITCH_SKIP_REPLICATION

Cannot modify @@session.skip_replication inside a transaction

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1930: Cannot modify @@session.skip_replication inside a stored function or trigger

Error Code
SQLSTATE
Error
Description

1930

ER_STORED_FUNCTION_PREVENTS_SWITCH_SKIP_REPLICATION

Cannot modify @@session.skip_replication inside a stored function or trigger

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1931: Query execution was interrupted. The query exceeded. The query result may be incomplete

MariaDB starting with 10.5.22

= MariaDB 11.1.2, MariaDB 10.11.5, MariaDB 10.6.15, MariaDB 10.5.22:

Error Code
SQLSTATE
Error
Description

1931

ER_QUERY_RESULT_INCOMPLETE

Query execution was interrupted. The query exceeded %s %llu. The query result may be incomplete

MariaDB until 10.6.14

<= MariaDB 11.1.1, MariaDB 10.11.4, MariaDB 10.6.14, MariaDB 10.5.21:

Error Code
SQLSTATE
Error
Description

1931

ER_QUERY_EXCEEDED_ROWS_EXAMINED_LIMIT

Query execution was interrupted. The query examined at least %llu rows, which exceeds LIMIT ROWS EXAMINED (%llu). The query result may be incomplete.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1932: Table doesn't exist in engine

Error Code
SQLSTATE
Error
Description

1932

ER_NO_SUCH_TABLE_IN_ENGINE 42S02

Table '%-.192s.%-.192s' doesn't exist in engine

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1933: Target is not running an EXPLAINable command

Error Code
SQLSTATE
Error
Description

1933

ER_TARGET_NOT_EXPLAINABLE

Target is not running an EXPLAINable command

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1934: Connection conflicts with existing connection

Error Code
SQLSTATE
Error
Description

1934

ER_CONNECTION_ALREADY_EXISTS

Connection '%.*s' conflicts with existing connection '%.*s'

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1935: Master

Error Code
SQLSTATE
Error
Description

1935

ER_MASTER_LOG_PREFIX

Master '%.*s':

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1936: Can't %s SLAVE

Error Code
SQLSTATE
Error
Description

1936

ER_CANT_START_STOP_SLAVE

Can't %s SLAVE '%.*s'

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1937: SLAVE started

Error Code
SQLSTATE
Error
Description

1937

ER_SLAVE_STARTED

SLAVE '%.*s' started

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1938: SLAVE stopped

Error Code
SQLSTATE
Error
Description

1938

ER_SLAVE_STOPPED

SLAVE '%.*s' stopped

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1939: Engine failed to discover table with

Error Code
SQLSTATE
Error
Description

1939

ER_SQL_DISCOVER_ERROR

Engine %s failed to discover table %-.192s.%-.192s with '%s'

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1940: Failed initializing replication GTID state

Error Code
SQLSTATE
Error
Description

1940

ER_FAILED_GTID_STATE_INIT

Failed initializing replication GTID state

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1941: Could not parse GTID list

Error Code
SQLSTATE
Error
Description

1941

ER_INCORRECT_GTID_STATE

Could not parse GTID list

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1942: Could not update replication slave gtid state

Error Code
SQLSTATE
Error
Description

1942

ER_CANNOT_UPDATE_GTID_STATE

Could not update replication slave gtid state

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1943: GTID conflict (duplicate domain id)

Error Code
SQLSTATE
Error
Description

1943

ER_DUPLICATE_GTID_DOMAIN

GTID %u-%u-%llu and %u-%u-%llu conflict (duplicate domain id %u)

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1944: Failed to open

Error Code
SQLSTATE
Error
Description

1944

ER_GTID_OPEN_TABLE_FAILED

Failed to open %s.%s

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1945: Connecting slave requested to start from GTID, which is not in the master's binlog

Error Code
SQLSTATE
Error
Description

1945

ER_GTID_POSITION_NOT_FOUND_IN_BINLOG

Connecting slave requested to start from GTID %u-%u-%llu, which is not in the master's binlog

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1946: Failed to load replication slave GTID position from table

Error Code
SQLSTATE
Error
Description

1946

ER_CANNOT_LOAD_SLAVE_GTID_STATE

Failed to load replication slave GTID position from table %s.%s

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1947: Specified GTID conflicts with the binary log which contains a more recent GTID

Error Code
SQLSTATE
Error
Description

1947

ER_MASTER_GTID_POS_CONFLICTS_WITH_BINLOG

Specified GTID %u-%u-%llu conflicts with the binary log which contains a more recent GTID %u-%u-%llu. If MASTER_GTID_POS=CURRENT_POS is used, the binlog position will override the new value of @@gtid_slave_pos.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1948: Specified value for @@gtid_slave_pos contains no value for replication domain

Error Code
SQLSTATE
Error
Description

1948

ER_MASTER_GTID_POS_MISSING_DOMAIN

Specified value for @@gtid_slave_pos contains no value for replication domain %u. This conflicts with the binary log which contains GTID %u-%u-%llu. If MASTER_GTID_POS=CURRENT_POS is used, the binlog position will override the new value of @@gtid_slave_pos.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1949: START SLAVE UNTIL master_gtid_pos requires that slave is using GTID

Error Code
SQLSTATE
Error
Description

1949

ER_UNTIL_REQUIRES_USING_GTID

START SLAVE UNTIL master_gtid_pos requires that slave is using GTID

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1950: An attempt was made to binlog GTID which would create an out-of-order sequence number wi

Error Code
SQLSTATE
Error
Description

1950

ER_GTID_STRICT_OUT_OF_ORDER

An attempt was made to binlog GTID %u-%u-%llu which would create an out-of-order sequence number with existing GTID %u-%u-%llu, and gtid strict mode is enabled.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1951: The binlog on the master is missing the GTID requested by the slave

Error Code
SQLSTATE
Error
Description

1951

ER_GTID_START_FROM_BINLOG_HOLE

The binlog on the master is missing the GTID %u-%u-%llu requested by the slave (even though a subsequent sequence number does exist), and GTID strict mode is enabled

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1952: Unexpected GTID received from master after reconnect

Error Code
SQLSTATE
Error
Description

1952

ER_SLAVE_UNEXPECTED_MASTER_SWITCH

Unexpected GTID received from master after reconnect. This normally indicates that the master server was replaced without restarting the slave threads. %s

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1953: Cannot modify @@session.gtid_domain_id or @@session.gtid_seq_no inside a transaction

Error Code
SQLSTATE
Error
Description

1953

ER_INSIDE_TRANSACTION_PREVENTS_SWITCH_GTID_DOMAIN_ID_SEQ_NO

Cannot modify @@session.gtid_domain_id or @@session.gtid_seq_no inside a transaction

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1954: Cannot modify @@session.gtid_domain_id or @@session.gtid_seq_no inside a stored function

Error Code
SQLSTATE
Error
Description

1954

ER_STORED_FUNCTION_PREVENTS_SWITCH_GTID_DOMAIN_ID_SEQ_NO

Cannot modify @@session.gtid_domain_id or @@session.gtid_seq_no inside a stored function or trigger

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1955: Connecting slave requested to start from GTID which is not in the master's binlog

Error Code
SQLSTATE
Error
Description

1955

ER_GTID_POSITION_NOT_FOUND_IN_BINLOG2

Connecting slave requested to start from GTID %u-%u-%llu, which is not in the master's binlog. Since the master's binlog contains GTIDs with higher sequence numbers, it probably means that the slave has diverged due to executing extra errorneous transactions

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1956: This operation is not allowed if any GTID has been logged to the binary log

Error Code
SQLSTATE
Error
Description

1956

ER_BINLOG_MUST_BE_EMPTY

This operation is not allowed if any GTID has been logged to the binary log. Run RESET MASTER first to erase the log

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1957: Unknown query id

Error Code
SQLSTATE
Error
Description

1957

ER_NO_SUCH_QUERY

Unknown query id: %lld

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1958: Bad base64 data as position

Error Code
SQLSTATE
Error
Description

1958

ER_BAD_BASE64_DATA

Bad base64 data as position %u

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1959: Invalid role specification

Error Code
SQLSTATE
Error
Description

1959

ER_INVALID_ROLE

Invalid role specification %`s.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1960: The current user is invalid

Error Code
SQLSTATE
Error
Description

1960

ER_INVALID_CURRENT_USER

The current user is invalid.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1961: Cannot grant role to

Error Code
SQLSTATE
Error
Description

1961

ER_CANNOT_GRANT_ROLE

Cannot grant role '%s' to: %s.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1962: Cannot revoke role from

Error Code
SQLSTATE
Error
Description

1962

ER_CANNOT_REVOKE_ROLE

Cannot revoke role '%s' from: %s.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1963: Cannot change @@slave_parallel_threads while another change is in progress

Error Code
SQLSTATE
Error
Description

1963

ER_CHANGE_SLAVE_PARALLEL_THREADS_ACTIVE

Cannot change @@slave_parallel_threads while another change is in progress

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1964: Commit failed due to failure of an earlier commit on which this one depends

Error Code
SQLSTATE
Error
Description

1964

ER_PRIOR_COMMIT_FAILED

Commit failed due to failure of an earlier commit on which this one depends

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1965: is a view

Error Code
SQLSTATE
Error
Description

1965

ER_IT_IS_A_VIEW

'%-.192s' is a view

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1966: When using GTID, @@sql_slave_skip_counter can not be used

Error Code
SQLSTATE
Error
Description

1966

ER_SLAVE_SKIP_NOT_IN_GTID

When using GTID, @@sql_slave_skip_counter can not be used. Instead, setting @@gtid_slave_pos explicitly can be used to skip to after a given GTID position.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1967: The definition for table is too big

Error Code
SQLSTATE
Error
Description

1967

ER_TABLE_DEFINITION_TOO_BIG

The definition for table %`s is too big

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1968: Plugin already installed

Error Code
SQLSTATE
Error
Description

1968

ER_PLUGIN_INSTALLED

Plugin '%-.192s' already installed

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1969: Query execution was interrupted (max_statement_time exceeded)

Error Code
SQLSTATE
Error
Description

1969

ER_STATEMENT_TIMEOUT

Query execution was interrupted (max_statement_time exceeded)

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1970: does not support subqueries or stored functions

Error Code
SQLSTATE
Error
Description

1970

ER_SUBQUERIES_NOT_SUPPORTED

%s does not support subqueries or stored functions.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1971: The system variable cannot be set in SET STATEMENT

Error Code
SQLSTATE
Error
Description

1971

ER_SET_STATEMENT_NOT_SUPPORTED

The system variable %.200s cannot be set in SET STATEMENT.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1972: You should never see it

Error Code
SQLSTATE
Error
Description

1972

ER_UNUSED_9

You should never see it

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1973: Can't create user; it already exists

Error Code
SQLSTATE
Error
Description

1973

ER_USER_CREATE_EXISTS

Can't create user '%-.64s'@'%-.64s'; it already exists

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1974: Can't drop user; it doesn't exist

Error Code
SQLSTATE
Error
Description

1974

ER_USER_DROP_EXISTS

Can't drop user '%-.64s'@'%-.64s'; it doesn't exist

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1975: Can't create role; it already exists

Error Code
SQLSTATE
Error
Description

1975

ER_ROLE_CREATE_EXISTS

Can't create role '%-.64s'; it already exists

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1976: Can't drop role; it doesn't exist

Error Code
SQLSTATE
Error
Description

1976

ER_ROLE_DROP_EXISTS

Can't drop role '%-.64s'; it doesn't exist

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1977: Cannot convert character to

Error Code
SQLSTATE
Error
Description

1977

ER_CANNOT_CONVERT_CHARACTER

Cannot convert '%s' character 0x%-.64s to '%s'

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1978: Incorrect default value for column

Error Code
SQLSTATE
Error
Description

1978

ER_INVALID_DEFAULT_VALUE_FOR_FIELD

Incorrect default value '%-.128s' for column '%.192s'

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1979: You are not owner of query

Error Code
SQLSTATE
Error
Description

1979

ER_KILL_QUERY_DENIED_ERROR

You are not owner of query %lu

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1980: Engine-independent statistics are not collected for column

Error Code
SQLSTATE
Error
Description

1980

ER_NO_EIS_FOR_FIELD

Engine-independent statistics are not collected for column '%s'

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1981: Aggregate function of SELECT belongs to SELECT

Error Code
SQLSTATE
Error
Description

1981

ER_WARN_AGGFUNC_DEPENDENCE

Aggregate function '%-.192s)' of SELECT #%d belongs to SELECT #%d

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1982: option ignored for InnoDB partition

Error Code
SQLSTATE
Error
Description

1982

WARN_INNODB_PARTITION_OPTION_IGNORED

<%-.64s> option ignored for InnoDB partition

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL