[MDEV-15366] [ERROR] mysqld: The table '#sql-984_1c' is full Created: 2018-02-20  Updated: 2018-03-16  Resolved: 2018-03-16

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.2.13
Fix Version/s: 10.2.14

Type: Bug Priority: Major
Reporter: Dermot Brereton Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None
Environment:

Ubuntu 16.04 LTS

Attachments: File my.cnf     File sp_CRM_Outcome_Ticket_Campaign.sql    
Issue Links:
Relates
relates to MDEV-15591 Create index fails on innoDB temporar... Closed

 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

 Comments   
Comment by Elena Stepanova [ 2018-02-20 ]

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

Comment by Dermot Brereton [ 2018-02-21 ]

Stored procedure and my.cnf file attached for review.

Comment by Dermot Brereton [ 2018-02-21 ]

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.

Comment by Elena Stepanova [ 2018-03-16 ]

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.

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