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

[ERROR] mysqld: The table '#sql-984_1c' is full

Details

    Description

      "[ERROR] mysqld: The table '#sql-984_1c' is full" occurs during the execution of a stored procedure.

      Storage capacity is available on the host;

      Filesystem Size Used Avail Use% Mounted on
      udev 4.9G 0 4.9G 0% /dev
      tmpfs 1003M 8.5M 994M 1% /run
      /dev/xvda 58G 23G 32G 42% /
      tmpfs 4.9G 0 4.9G 0% /dev/shm
      tmpfs 5.0M 0 5.0M 0% /run/lock
      tmpfs 4.9G 0 4.9G 0% /sys/fs/cgroup

      Attachments

        Issue Links

          Activity

            Can you provide the definition of the stored procedure and structures used in the procedure?
            Please also attach your cnf file(s).

            elenst Elena Stepanova added a comment - Can you provide the definition of the stored procedure and structures used in the procedure? Please also attach your cnf file(s).

            Stored procedure and my.cnf file attached for review.

            Dermot.Brereton Dermot Brereton added a comment - Stored procedure and my.cnf file attached for review.

            I have tracked the error to the creation of an index on the temporary table (contained within the stored procedure);

            CREATE INDEX idx01_ticket ON CRM_Outcomes_ranks(Ticket_id);

            12:18:18 CREATE INDEX idx01_ticket ON CRM_Outcomes_ranks(Ticket_id) Error Code: 1114. The table '#sql-2c3_15' is full 0.250 sec

            CRM_Outcomes_ranks is a Temporary table.

            Dermot.Brereton Dermot Brereton added a comment - I have tracked the error to the creation of an index on the temporary table (contained within the stored procedure); CREATE INDEX idx01_ticket ON CRM_Outcomes_ranks(Ticket_id); 12:18:18 CREATE INDEX idx01_ticket ON CRM_Outcomes_ranks(Ticket_id) Error Code: 1114. The table '#sql-2c3_15' is full 0.250 sec CRM_Outcomes_ranks is a Temporary table.

            The stored procedure is still not callable, because it uses tables which are not in the provided SQL file. However, we have got another report which had a test case, MDEV-15591, and it turned out that the problem was incidentally fixed just a few days before this report showed up, which is probably why we couldn't reproduce it right away.

            The fix was by this commit:

            commit 852c35f571b1b7454aab5768899e2faee8f941d4
            Author: Marko Mäkelä
            Date:   Mon Feb 19 14:58:05 2018 +0200
             
                MDEV-11581 follow-up fix: Correct a condition
                
                fsp_fill_free_list(): Correctly determine whether the temporary
                tablespace file should be extended in order to respond to a
                page allocation request. The inverted condition was noticed
                by Thiru when he analyzed MDEV-13013.
            

            It will be included into the upcoming 10.2.14 release.
            If you still experience the problem after upgrade, please comment here.

            elenst Elena Stepanova added a comment - The stored procedure is still not callable, because it uses tables which are not in the provided SQL file. However, we have got another report which had a test case, MDEV-15591 , and it turned out that the problem was incidentally fixed just a few days before this report showed up, which is probably why we couldn't reproduce it right away. The fix was by this commit: commit 852c35f571b1b7454aab5768899e2faee8f941d4 Author: Marko Mäkelä Date: Mon Feb 19 14:58:05 2018 +0200 MDEV-11581 follow-up fix: Correct a condition fsp_fill_free_list(): Correctly determine whether the temporary tablespace file should be extended in order to respond to a page allocation request. The inverted condition was noticed by Thiru when he analyzed MDEV-13013. It will be included into the upcoming 10.2.14 release. If you still experience the problem after upgrade, please comment here.

            People

              Unassigned Unassigned
              Dermot.Brereton Dermot Brereton
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.