[MDEV-25287] page_checksum is not listed in table status for aria tables the first time Created: 2021-03-29  Updated: 2023-04-27

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - Aria
Affects Version/s: 5.5, 10.0, 10.1, 10.5.9, 10.2, 10.3, 10.4, 10.5
Fix Version/s: 10.4, 10.5

Type: Bug Priority: Minor
Reporter: Oli Sennhauser Assignee: Michael Widenius
Resolution: Unresolved Votes: 0
Labels: None
Environment:

n.a.



 Description   

When I create an aria table the first time page_checksum is not listed in show table status when the table is created the first time. when alter is done later it is listed:

 
create table t (id int) engine = aria;
 
show create table t\G
*************************** 1. row ***************************
       Table: t
Create Table: CREATE TABLE `t` (
  `id` int(11) DEFAULT NULL
) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1
 
show table status like 't'\G
*************************** 1. row ***************************
            Name: t
          Engine: Aria
...
        Checksum: NULL
  Create_options: transactional=1
         Comment: 
 
alter table t table_checksum=1;
 
 
show create table t\G
*************************** 1. row ***************************
       Table: t
Create Table: CREATE TABLE `t` (
  `id` int(11) DEFAULT NULL
) ENGINE=Aria DEFAULT CHARSET=latin1 CHECKSUM=1 PAGE_CHECKSUM=1
 
show table status like 't'\G
*************************** 1. row ***************************
            Name: t
          Engine: Aria
        Checksum: 0
  Create_options: checksum=1 page_checksum=1 transactional=1
 
alter table t table_checksum=0;
show create table t\G
*************************** 1. row ***************************
       Table: t
Create Table: CREATE TABLE `t` (
  `id` int(11) DEFAULT NULL
) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1
 
show table status like 't'\G
*************************** 1. row ***************************
            Name: t
          Engine: Aria
        Checksum: NULL
  Create_options: page_checksum=1 transactional=1

This makes this information less reliable for monitoring for example...


Generated at Thu Feb 08 09:36:33 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.