Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-4805

Aria Max Table Size for internal on-disk temporary tables

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: 5.5.32
        • Fix Version/s: None
        • Component/s: None
        • 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.

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                elenst Elena Stepanova added a comment -

                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

                Show
                elenst Elena Stepanova added a comment - 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
                Hide
                Permalink
                elenst Elena Stepanova added a comment -

                Hi Ian,

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

                Thanks

                Show
                elenst Elena Stepanova added a comment - Hi Ian, Can you provide test case with which you are still getting the error on 5.5.32? Thanks
                Hide
                Permalink
                elenst Elena Stepanova added a comment -

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

                Show
                elenst Elena Stepanova added a comment - Closing as solved (in 5.5.32), please feel free to comment/resolve if you are still experiencing the problem.

                  People

                  • Assignee:
                    elenst Elena Stepanova
                    Reporter:
                    greenman Ian Gilfillan
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    4 Start watching this issue

                    Dates

                    • Due:
                      Created:
                      Updated:
                      Resolved: