[MDEV-4805] Aria Max Table Size for internal on-disk temporary tables Created: 2013-07-22  Updated: 2013-10-03  Due: 2013-09-27  Resolved: 2013-10-03

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.5.32
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Ian Gilfillan Assignee: Elena Stepanova
Resolution: Fixed Votes: 0
Labels: None


 Description   

When a query requires an internal temporary table, and this tables becomes too large to be kept in ram, the table is moved to disk using Aria engine. If the on-disk .MAD file reaches 4GB, an error occurs:

[ERROR] mysqld: The table '/tmp/#sql_74e_0' is full

See discussion at https://lists.launchpad.net/maria-discuss/msg00842.html and the original report at https://kb.askmonty.org/en/aria-max-table-size-for-internal-on-disk-temporary-tables/ and

I can't find an issue for this, so I think it may have been overlooked.

 Comments   
Comment by Elena Stepanova [ 2013-07-25 ]

Hi Ian,

Is it actually reproducible on 5.5.32? With the current tree, I'm getting temporary files far greater than 4 GB:

rw-rw--- 1 elenst elenst 11754151936 Jul 25 03:34 #sql_3808_0.MAD
rw-rw--- 1 elenst elenst 8192 Jul 25 03:11 #sql_3808_0.MAI

and it looks like this revision was supposed to fix the problem: http://bazaar.launchpad.net/~maria-captains/maria/5.5/revision/3787

I will check before/after the revision later to confirm, meanwhile could you please let us know if you really do experience the problem on the current release.

Thanks

Comment by Elena Stepanova [ 2013-08-18 ]

Hi Ian,

Can you provide test case with which you are still getting the error on 5.5.32?

Thanks

Comment by Elena Stepanova [ 2013-10-03 ]

Closing as solved (in 5.5.32), please feel free to comment/resolve if you are still experiencing the problem.

Generated at Thu Feb 08 06:59:18 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.