[MDEV-15224] Table #sql- is full when doing CREATE TEMPOARY TABLE ... SELECT into Aria table Created: 2018-02-06  Updated: 2020-08-25  Resolved: 2018-03-23

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Aria
Affects Version/s: 10.2.12
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Michael Widenius Assignee: Michael Widenius
Resolution: Not a Bug Votes: 0
Labels: None


 Description   

The following sequence can sometimes cause a table is full error when adding index:

CREATE TEMPORARY TABLE tmp engine=aria SELECT ....
CREATE INDEX (..) on t1 (...);

In theory on should be able to drop "temporary" table above, add 'transactional=0" and just check max key length with 'aria_check'.

Unfortunately we don't show max index length in 'show table status' and also we don't show
temporary tables either.

 Comments   
Comment by Michael Widenius [ 2018-03-23 ]

No bug, Aria works perfectly.
The bug was in InnoDB and was fixed as part of MDEV-15591

However, to make bugs like this easier to fix, I did add 'Max_index_length' to
INFORMATION_SCHEMA.TABLES in 10.3 to make it easier to check the limits for
index storage.

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