[MDEV-29479] I_S.INNODB_SYS_TABLESPACES doesn't have temporary tablespace information Created: 2022-09-07  Updated: 2022-12-09  Resolved: 2022-09-14

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.3, 10.4, 10.5, 10.6
Fix Version/s: 10.3.37, 10.4.27, 10.5.18, 10.6.11, 10.7.7, 10.8.6, 10.9.4, 10.10.2

Type: Bug Priority: Major
Reporter: Thirunarayanan Balathandayuthapani Assignee: Thirunarayanan Balathandayuthapani
Resolution: Fixed Votes: 1
Labels: None


 Description   

Innodb_sys_tablespaces view in information schema doesn't show temporary tablespace
information. The following is the output of information schema output

select * from information_schema.innodb_sys_tablespaces;
 
SPACE	NAME	FLAG	ROW_FORMAT	PAGE_SIZE	FILENAME	FS_BLOCK_SIZE	FILE_SIZE	ALLOCATED_SIZE
 
0	innodb_system	21	NULL	16384	./ibdata1	4096	12582912	12582912
 
1	mysql/innodb_table_stats	21	NULL	16384	./mysql/innodb_table_stats.ibd	4096	65536	65536
 
2	mysql/innodb_index_stats	21	NULL	16384	./mysql/innodb_index_stats.ibd	4096	65536	65536
 
3	mysql/transaction_registry	21	NULL	16384	./mysql/transaction_registry.ibd	4096	114688	114688
 
5	test/t	21	NULL	16384	./test/t.ibd	4096	81920	81920

Above output should include temporary tablespace information with space as 0xFFFFFFFE

 Comments   
Comment by Marko Mäkelä [ 2022-09-07 ]

This looks OK to me. I think that it needs to be tested in both 10.3 and 10.6. The 10.6 code base is a little different because the system table SYS_TABLESPACES was removed in MDEV-22343.

Comment by Matthias Leich [ 2022-09-12 ] 

origin/bb-10.6-MDEV-29479 923d30feb1256308bb9bc9d8f44a7fd84bcff029 2022-09-07T17:40:19+05:30
 
performed well in RQG testing. The bad effects observed occur on other trees too.
 
Please be aware that the RQG tests executed do not check the content of information_schema.innodb_sys_tablespaces.

Comment by Marko Mäkelä [ 2022-12-09 ]

After this fix, the following query will return 4294967294:

SELECT SPACE FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE name like 'innodb_temporary';

Generated at Thu Feb 08 10:08:55 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.