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

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15591 Create index fails on innoDB temporary table

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            Dermot.Brereton Dermot Brereton created issue -
            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).

            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).
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            Labels need_feedback
            Dermot.Brereton Dermot Brereton added a comment -

            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.
            Dermot.Brereton Dermot Brereton made changes -
            Attachment sp_CRM_Outcome_Ticket_Campaign.sql [ 45244 ]
            Dermot.Brereton Dermot Brereton made changes -
            Attachment my.cnf [ 45245 ]
            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.

            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.
            elenst Elena Stepanova made changes -
            Labels need_feedback
            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.

            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.
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            Priority Blocker [ 1 ] Major [ 3 ]
            elenst Elena Stepanova made changes -
            Component/s Storage Engine - InnoDB [ 10129 ]
            Fix Version/s 10.2.14 [ 22911 ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 85665 ] MariaDB v4 [ 153833 ]

            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.