[MDEV-28288] System versioning doesn't support correct work for engine=connect and doesn't always give any warnings/errors - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL)
Fix Version/s: 10.5.27, 10.6.20, 10.11.10, 11.2.6, 11.4.4
Component/s: Versioned Tables
Labels:
- reviewed

Description

Test:

create table t2 (

  x int,

  y int

) engine=connect table_type=FIX file_name='test.txt' with system versioning;

insert into t2 values (1,1),(2,2),(3,3),(4,4),(5,5);

select * from t2;

update t2 set x=10 where y=4;

select * from t2;

delete from t2 where x=1;

select * from t2;

drop table t2;

Result:

create table t2 (

x int,

y int

) engine=connect table_type=FIX file_name='/test.txt' with system versioning;

insert into t2 values (1,1),(2,2),(3,3),(4,4),(5,5);

select * from t2;

x	y

update t2 set x=10 where y=4;

select * from t2;

x	y

delete from t2 where x=1;

mysqltest: At line 11: query 'delete from t2 where x=1' failed: ER_CRASHED_ON_USAGE (1194): Table 't2' is marked as crashed and should be repaired

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

test.txt
0.2 kB
2022-04-11 09:27

Issue Links

relates to

MDEV-15968 System versioning and CONNECT engine don't work well together: current data is not returned

Confirmed

MDEV-17554 Auto-create history partitions for system-versioned tables

Closed

Activity

Ascending order - Click to sort in descending order

Lena Startseva created issue - 2022-04-11 09:28

Lena Startseva made changes - 2022-04-11 09:28

Field	Original Value	New Value
Link		This issue relates to ~~MDEV-17554~~ [ ~~MDEV-17554~~ ]

Lena Startseva made changes - 2022-04-11 09:29

Description

If add for engine=connect "system versioning" there is no any warnings/errors on creating table and inserting data, but "select" gives an empty result, "update" doesn't change value and "delete" fails with error:

Test:

{code}
create table t2 (
  x int,
  y int
) engine=connect table_type=FIX file_name='test.txt' with system versioning;

insert into t2 values (1,1),(2,2),(3,3),(4,4),(5,5);
select * from t2;

update t2 set x=10 where y=4;
select * from t2;
delete from t2 where x=1;
select * from t2;

drop table t2;
{code}

Result:
{code}
create table t2 (
x int,
y int
) engine=connect table_type=FIX file_name='/test.txt' with system versioning;
insert into t2 values (1,1),(2,2),(3,3),(4,4),(5,5);
select * from t2;
x y
update t2 set x=10 where y=4;
select * from t2;
x y
delete from t2 where x=1;
versioning.bbb [ fail ]
        Test ended at 2022-04-11 16:15:32

CURRENT_TEST: versioning.bbb
mysqltest: At line 11: query 'delete from t2 where x=1' failed: ER_CRASHED_ON_USAGE (1194): Table 't2' is marked as crashed and should be repaired
{code}

If add for engine=connect "system versioning" there is no any warnings/errors on creating table and inserting data, but "select" gives an empty result, "update" doesn't change value and "delete" fails with error:

Test:

{code}
create table t2 (
x int,
y int
) engine=connect table_type=FIX file_name='test.txt' with system versioning;

insert into t2 values (1,1),(2,2),(3,3),(4,4),(5,5);
select * from t2;

update t2 set x=10 where y=4;
select * from t2;
delete from t2 where x=1;
select * from t2;

drop table t2;
{code}

Result:
{code}
create table t2 (
x int,
y int
) engine=connect table_type=FIX file_name='/test.txt' with system versioning;
insert into t2 values (1,1),(2,2),(3,3),(4,4),(5,5);
select * from t2;
x y
update t2 set x=10 where y=4;
select * from t2;
x y
delete from t2 where x=1;

mysqltest: At line 11: query 'delete from t2 where x=1' failed: ER_CRASHED_ON_USAGE (1194): Table 't2' is marked as crashed and should be repaired
{code}

Ralf Gebhardt added a comment - 2022-04-13 14:59 - edited

Hi lstartseva,

this issue does not seem to be related to the new feature in 10.9, so the affectedVersion might need to be changed. Can you check this?

Ralf Gebhardt added a comment - 2022-04-13 14:59 - edited Hi lstartseva , this issue does not seem to be related to the new feature in 10.9, so the affectedVersion might need to be changed. Can you check this?

Elena Stepanova added a comment - 2022-04-13 15:15

Indeed it isn't. The generic problem was stated in MDEV-15968, but the combination of versioning and Connect hasn't been prohibited.

Elena Stepanova added a comment - 2022-04-13 15:15 Indeed it isn't. The generic problem was stated in MDEV-15968 , but the combination of versioning and Connect hasn't been prohibited.

Elena Stepanova made changes - 2022-04-13 15:15

Fix Version/s		10.3 [ 22126 ]
Fix Version/s		10.4 [ 22408 ]
Fix Version/s		10.5 [ 23123 ]
Fix Version/s		10.6 [ 24028 ]
Fix Version/s		10.7 [ 24805 ]
Fix Version/s		10.8 [ 26121 ]
Affects Version/s		10.3 [ 22126 ]
Affects Version/s		10.4 [ 22408 ]
Affects Version/s		10.5 [ 23123 ]
Affects Version/s		10.6 [ 24028 ]
Affects Version/s		10.7 [ 24805 ]
Affects Version/s		10.8 [ 26121 ]

Elena Stepanova made changes - 2022-04-13 15:15

Status

Open [ 1 ]

Confirmed [ 10101 ]

Elena Stepanova made changes - 2022-04-13 15:18

Link

This issue relates to MDEV-15968 [ MDEV-15968 ]

Julien Fritsch made changes - 2023-03-03 17:31

Fix Version/s

10.7 [ 24805 ]

Julien Fritsch made changes - 2023-04-27 13:57

Fix Version/s

10.3 [ 22126 ]

Julien Fritsch made changes - 2023-04-27 14:59

Fix Version/s

10.8 [ 26121 ]

Julien Fritsch made changes - 2024-09-10 14:58

Fix Version/s

10.4 [ 22408 ]

Aleksey Midenkov made changes - 2024-09-29 21:35

Status

Confirmed [ 10101 ]

In Progress [ 3 ]

Aleksey Midenkov added a comment - 2024-10-01 13:01

Please review bb-10.5-midenok

Aleksey Midenkov added a comment - 2024-10-01 13:01 Please review bb-10.5-midenok

Aleksey Midenkov made changes - 2024-10-01 13:01

Assignee	Aleksey Midenkov [ midenok ]	Nikita Malyavin [ nikitamalyavin ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Ralf Gebhardt added a comment - 2024-10-01 13:13

The fix is to return "ERROR HY000: System-versioned tables do not support CONNECT storage engine".

Ralf Gebhardt added a comment - 2024-10-01 13:13 The fix is to return "ERROR HY000: System-versioned tables do not support CONNECT storage engine".

Nikita Malyavin added a comment - 2024-10-04 10:12

commit 20ba4c3b is approved

Nikita Malyavin added a comment - 2024-10-04 10:12 commit 20ba4c3b is approved

Nikita Malyavin made changes - 2024-10-04 10:12

Assignee	Nikita Malyavin [ nikitamalyavin ]	Aleksey Midenkov [ midenok ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Aleksey Midenkov made changes - 2024-10-05 22:54

Labels

reviewed

Aleksey Midenkov made changes - 2024-10-08 11:19

Fix Version/s		10.5.27 [ 29902 ]
Fix Version/s	10.5 [ 23123 ]
Fix Version/s	10.6 [ 24028 ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

JiraAutomate made changes - 2024-10-08 11:19

Fix Version/s		10.6.20 [ 29903 ]
Fix Version/s		10.11.10 [ 29904 ]
Fix Version/s		11.2.6 [ 29906 ]
Fix Version/s		11.4.4 [ 29907 ]

People

Assignee:: Aleksey Midenkov

Reporter:: Lena Startseva

Votes:: 0 Vote for this issue

Watchers:: 6 Start watching this issue

Dates

Created:: 2022-04-11 09:28

Updated:: 2024-10-08 11:19

Resolved:: 2024-10-08 11:19

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server

Details

Description

Attachments

Attachments

Issue Links

Activity

People

Dates

Git Integration