Details
Description
TEST:
|
DROP DATABASE IF EXISTS test1; |
DROP DATABASE IF EXISTS test2; |
CREATE DATABASE test1; |
CREATE DATABASE test2; |
USE test1; |
CREATE SEQUENCE seq_t_i INCREMENT 1 START WITH 1; |
CREATE TABLE t( |
i integer DEFAULT nextval(seq_t_i), |
j integer |
);
|
INSERT INTO t VALUES (1,1),(2,2),(3,3),(4,4); |
SELECT SETVAL(seq_t_i, 4); |
INSERT INTO t(j) VALUES (5),(6),(7); |
SELECT SETVAL(seq_t_i,200); |
INSERT INTO t(j) VALUES (201),(202),(203); |
|
|
$ mysqldump test1 > foo.sql
|
$ mysql test2 < foo.sql
|
|
|
ERROR 1100 (HY000) at line 66: Table 'seq_t_id' was not locked with LOCK TABLES |
Looks like mysqldump not working correct on sequences.
Best regards,
Susanne
Attachments
Issue Links
- duplicates
-
MDEV-20071 mysqldump won't work correct on sequences
-
- Closed
-
- relates to
-
-
- Closed
-
-
MDEV-30155 SEQUENCEs/VIEWS/TRIGGERS/PROCEDURES dumped with mariadb-dump cannot be restored in different DB
-
- Confirmed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Link |
This issue duplicates |
| Component/s | Locking [ 10900 ] | |
| Component/s | Backup [ 13902 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Fix Version/s | 10.4 [ 22408 ] | |
| Affects Version/s | 10.3 [ 22126 ] | |
| Assignee | Sergey Vojtovich [ svoj ] |
| Link |
This issue relates to |
| Assignee | Sergey Vojtovich [ svoj ] | Anel Husakovic [ anel ] |
| Description |
TEST:
DROP DATABASE IF EXISTS test1; DROP DATABASE IF EXISTS test2; CREATE DATABASE test1; CREATE DATABASE test2; USE test1; CREATE SEQUENCE seq_t_i INCREMENT 1 START WITH 1; CREATE TABLE t( i integer DEFAULT nextval(seq_t_i), j integer ); INSERT INTO t VALUES (1,1),(2,2),(3,3),(4,4); SELECT SETVAL(seq_t_i, 4); INSERT INTO t(j) VALUES (5),(6),(7); SELECT SETVAL(seq_t_i,200); INSERT INTO t(j) VALUES (201),(202),(203); $ mysqldump test1 > foo.sql $ mysql test2 < foo.sql ERROR 1100 (HY000) at line 66: Table 'seq_t_id' was not locked with LOCK TABLES Looks like mysqldump not working correct on sequences. Best regards, Susanne |
{code:sql}
TEST: DROP DATABASE IF EXISTS test1; DROP DATABASE IF EXISTS test2; CREATE DATABASE test1; CREATE DATABASE test2; USE test1; CREATE SEQUENCE seq_t_i INCREMENT 1 START WITH 1; CREATE TABLE t( i integer DEFAULT nextval(seq_t_i), j integer ); INSERT INTO t VALUES (1,1),(2,2),(3,3),(4,4); SELECT SETVAL(seq_t_i, 4); INSERT INTO t(j) VALUES (5),(6),(7); SELECT SETVAL(seq_t_i,200); INSERT INTO t(j) VALUES (201),(202),(203); $ mysqldump test1 > foo.sql $ mysql test2 < foo.sql ERROR 1100 (HY000) at line 66: Table 'seq_t_id' was not locked with LOCK TABLES {code} Looks like {{mysqldump}} not working correct on sequences. Best regards, Susanne |
| Workflow | MariaDB v3 [ 98246 ] | MariaDB v4 [ 141404 ] |
| Summary | mysqldump won't work correct on sequences | cannot insert into write locked tables with sequences |
| Link | This issue relates to MDEV-30155 [ MDEV-30155 ] |
| Fix Version/s | 10.3 [ 22126 ] |
| Zendesk Related Tickets | 132208 152920 |
| Fix Version/s | 10.5 [ 23123 ] | |
| Fix Version/s | 10.6 [ 24028 ] | |
| Fix Version/s | 10.11 [ 27614 ] | |
| Fix Version/s | 11.2 [ 28603 ] | |
| Fix Version/s | 11.4 [ 29301 ] | |
| Fix Version/s | 11.6 [ 29515 ] | |
| Fix Version/s | 10.4(EOL) [ 22408 ] |
| Status | Open [ 1 ] | Confirmed [ 10101 ] |
| Assignee | Anel Husakovic [ anel ] |
| Fix Version/s | 11.5 [ 29506 ] |
| Assignee | Dmitry Shulga [ JIRAUSER47315 ] |
| Fix Version/s | 11.5 [ 29506 ] |
| Priority | Major [ 3 ] | Critical [ 2 ] |
| Fix Version/s | 11.6(EOL) [ 29515 ] |
| Fix Version/s | 11.2(EOL) [ 28603 ] |