Details
-
Bug
-
Status: Closed (View Workflow)
-
Trivial
-
Resolution: Fixed
-
10.3(EOL)
-
None
Description
create or replace table t1 (a int) with system versioning |
partition by system_time interval 1 second ( |
partition p0 history,
|
partition p1 history,
|
partition pc current |
);
|
-- wait for 3 seconds
|
insert into t1 values (1),(2),(3); |
show warnings;
|
|
10.3 9f84451d87 |
+---------+------+----------------------------------------------------------------------------------+
|
| Level | Code | Message |
|
+---------+------+----------------------------------------------------------------------------------+
|
| Warning | 4114 | Versioned table `test`.`t1`: partition `p1` is full, add more HISTORY partitions |
|
+---------+------+----------------------------------------------------------------------------------+
|
1 row in set (0.00 sec)
|
The warning is not wrong (apart being thrown at a strange time, when no historical rows are created; but for that we have a separate JIRA item). However, the text is confusing – the partition is not full, it's just expired.
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Alexander Krizhanovsky [ krizhanovsky ] | Eugene Kosov [ kevg ] |
| Assignee | Eugene Kosov [ kevg ] | Nikita Malyavin [ nikitamalyavin ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Assignee | Nikita Malyavin [ nikitamalyavin ] | Sergei Golubchik [ serg ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Fix Version/s | 10.4 [ 22408 ] |
nikitamalyavin there's a PR https://github.com/MariaDB/server/pull/825 waiting that seems to agree with your previous comment. Do you think its correct? Can you merge it?
| Fix Version/s | 10.3.24 [ 24306 ] | |
| Fix Version/s | 10.4.14 [ 24305 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Fix Version/s | 10.4 [ 22408 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Review [ 10002 ] | Closed [ 6 ] |
| Fix Version/s | 10.5.5 [ 24423 ] |
| Workflow | MariaDB v3 [ 86787 ] | MariaDB v4 [ 154253 ] |
I think no warning should be here. All the data is just added into pn, and p1, p2 are not even touched