Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
4006
ER_UNACCEPTABLE_MUTUAL_RECURSION
Unacceptable mutual recursion with anchored table '%s'
4020
ER_WRONG_TYPE_FOR_ROWS_FRAME
Integer is required for ROWS-type frame
4019
ER_RANGE_FRAME_NEEDS_SIMPLE_ORDERBY
RANGE-type frame requires ORDER BY clause with single sort key
4018
ER_NO_ORDER_LIST_IN_WINDOW_SPEC
No order list in window specification for '%s'
4034
ER_BINLOG_UNCOMPRESS_ERROR
Uncompress the compressed binlog failed
4031
ER_REFERENCED_TRG_DOES_NOT_EXIST
Referenced trigger '%s' for the given action time and event type does not exist
4040
ER_JSON_DEPTH
Limit of %d on JSON nested strucures depth is reached in argument %d to function '%s' at position %d
4032
ER_INVALID_DEFAULT_PARAM
Default/ignore value is not supported for such parameter usage
4028
ER_CALCULATING_DEFAULT_VALUE
Got an error when calculating default value for %`s
4046
ER_JSON_ONE_OR_ALL
Argument 2 to function '%s' must be "one" or "all".
This article doesn't currently contain any content.
4048
ER_GEOJSON_INCORRECT
Incorrect GeoJSON format specified for st_geomfromgeojson function.
This article doesn't currently contain any content.
4051
ER_JSON_PATH_EMPTY
Path expression '$' is not allowed in argument %d to function '%s'.
This article doesn't currently contain any content.
4052
ER_SLAVE_SAME_ID
A slave with the same server_uuid/server_id as this slave has connected to the master
This article doesn't currently contain any content.
4054
ER_KEYS_OUT_OF_ORDER
Keys are out order during bulk load
This article doesn't currently contain any content.
4056
ER_REQUIRE_ROW_BINLOG_FORMAT
Can't execute updates on master with binlog_format != ROW.
This article doesn't currently contain any content.
4059
ER_UPDATES_WITH_CONSISTENT_SNAPSHOT
Can't execute updates when you started a transaction with START TRANSACTION WITH CONSISTENT [ROCKSDB] SNAPSHOT.
This article doesn't currently contain any content.
4061
ER_ROLLBACK_TO_SAVEPOINT
MyRocks currently does not support ROLLBACK TO SAVEPOINT if modifying rows.
This article doesn't currently contain any content.
4062
ER_ISOLATION_LEVEL_WITH_CONSISTENT_SNAPSHOT
Only REPEATABLE READ isolation level is supported for START TRANSACTION WITH CONSISTENT SNAPSHOT in RocksDB Storage Engine.
This article doesn't currently contain any content.
4063
ER_UNSUPPORTED_COLLATION
Unsupported collation on string indexed column %s.%s Use binary collation (%s).
This article doesn't currently contain any content.
4065
ER_CF_DIFFERENT
Column family ('%s') flag (%d) is different from an existing flag (%d). Assign a new CF flag, or do not change existing CF flag.
This article doesn't currently contain any content.
4068
ER_RDB_STATUS_MSG
%s, Status error %d received from RocksDB: %s
This article doesn't currently contain any content.
4069
ER_RDB_TTL_UNSUPPORTED
TTL support is currently disabled when table has a hidden PK.
This article doesn't currently contain any content.
4072
ER_KEY_CREATE_DURING_ALTER
MyRocks failed creating new key definitions during alter.
This article doesn't currently contain any content.
4074
ER_SUM_FUNC_WITH_WINDOW_FUNC_AS_ARG
Window functions can not be used as arguments to group functions.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
4045
ER_JSON_PATH_ARRAY
JSON path should end with an array identifier in argument %d to function '%s'
This article doesn't currently contain any content.
4064
ER_METADATA_INCONSISTENCY
Table '%s' does not exist, but metadata information exists inside MyRocks. This is a sign of data inconsistency. Please check if '%s.frm' exists, and try to restore it if it does not exist.
This article doesn't currently contain any content.
4088
ER_SEQUENCE_BINLOG_FORMAT
Sequences requires binlog_format mixed or row
This article doesn't currently contain any content.
4083
ER_END_IDENTIFIER_DOES_NOT_MATCH
END identifier '%-.192s' does not match '%-.192s'
This article doesn't currently contain any content.
4087
ER_SEQUENCE_ACCESS_ERROR
Sequence '%-.64s.%-.64s' access error
This article doesn't currently contain any content.
4093
ER_WRONG_INSERT_INTO_SEQUENCE
Wrong INSERT into a SEQUENCE. One can only do single table INSERT into a sequence object (like with mysqldump). If you want to change the SEQUENCE, use ALTER SEQUENCE instead.
This article doesn't currently contain any content.
4095
ER_PACKAGE_ROUTINE_IN_SPEC_NOT_DEFINED_IN_BODY
Subroutine '%-.192s' is declared in the package specification but is not defined in the package body
This article doesn't currently contain any content.
4075
ER_NET_OK_PACKET_TOO_LARGE
OK packet too large
This article doesn't currently contain any content.
4079
ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION
Illegal parameter data type %s for operation '%s'
This article doesn't currently contain any content.
4047
ER_UNSUPPORT_COMPRESSED_TEMPORARY_TABLE
CREATE TEMPORARY TABLE is not allowed with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
4098
ER_UNKNOWN_COMPRESSION_METHOD
Unknown compression method: %s
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
4084
ER_SEQUENCE_RUN_OUT
Sequence '%-.64s.%-.64s' has run out
In a , once the MAXVALUE has been reached, and the argument has not been used, further attempts to set the next value will fail:
This is usually intended behaviour, but there are a number of ways to prevent this:
Prior to , this defaulted to the maximum, BIGINT. From , it can be BIGINT UNSIGNED
If re-use sequence values is not a problem, you can cycle back to the start once the maximum value has been reached:
The underlying table is only updated with a new sequence value the first time the value is created, and then each time the expires. By default the cache is set to 1000. For example:
This behaviour can be prevented by setting the cache to zero, so that the value stored in the underlying table is written each time:
SETVAL(). Set next value for the sequence.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
CREATE OR REPLACE SEQUENCE s START WITH 1 INCREMENT BY 1 MAXVALUE=2;
SELECT NEXTVAL(s);
+------------+
| NEXTVAL(s) |
+------------+
| 1 |
+------------+
SELECT NEXTVAL(s);
+------------+
| NEXTVAL(s) |
+------------+
| 2 |
+------------+
SELECT NEXTVAL(s);
ERROR 4084 (HY000): Sequence 'test.s' has run outCREATE OR REPLACE SEQUENCE s AS BIGINT UNSIGNED START WITH 1 INCREMENT BY 1;
SELECT SEQUENCE_NAME,MAXIMUM_VALUE FROM INFORMATION_SCHEMA.SEQUENCES\G
*************************** 1. row ***************************
SEQUENCE_NAME: s
MAXIMUM_VALUE: 18446744073709551614CREATE OR REPLACE SEQUENCE s START WITH 1 INCREMENT BY 1 MAXVALUE=2 CYCLE;
SELECT NEXTVAL(s);
+------------+
| NEXTVAL(s) |
+------------+
| 1 |
+------------+
SELECT NEXTVAL(s);
+------------+
| NEXTVAL(s) |
+------------+
| 2 |
+------------+
SELECT NEXTVAL(s);
+------------+
| NEXTVAL(s) |
+------------+
| 1 |
+------------+CREATE OR REPLACE SEQUENCE s START WITH 1 INCREMENT BY 1 MAXVALUE=10 CACHE=5;
SELECT NEXTVAL(s);
+------------+
| NEXTVAL(s) |
+------------+
| 1 |
+------------+
SELECT NEXTVAL(s);
+------------+
| NEXTVAL(s) |
+------------+
| 2 |
+------------+
FLUSH TABLES s;
SELECT NEXTVAL(s);
+------------+
| NEXTVAL(s) |
+------------+
| 6 |
+------------+
FLUSH TABLES s;
SELECT NEXTVAL(s);
ERROR 4084 (HY000): Sequence 'test.s' has run outCREATE OR REPLACE SEQUENCE s START WITH 1 INCREMENT BY 1 MAXVALUE=10 CACHE=0;
SELECT NEXTVAL(s);
+------------+
| NEXTVAL(s) |
+------------+
| 1 |
+------------+
SELECT NEXTVAL(s);
+------------+
| NEXTVAL(s) |
+------------+
| 2 |
+------------+
FLUSH TABLES s;
SELECT NEXTVAL(s);
+------------+
| NEXTVAL(s) |
+------------+
| 3 |
+------------+