Bug #707 The Table trnlbtdtls is ful.
Submitted: 24 Jun 2003 3:11 Modified: 27 Jul 2003 2:34
Reporter: mirunalini sethuraman Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:3.23.47 OS:Microsoft Windows (Windows)
Assigned to: CPU Architecture:Any

[24 Jun 2003 3:11] mirunalini sethuraman
Description:
When Queries used for creating a new record
"SELECT fields FROM trnlbtdtls"
and "DELETE FROM trnlbtdlts"
i get the error
"The table trnlbtdtls is full"
I increased the tmp_table_size.
then tried the same queries.
the same error repeated.

How to repeat:
need suggestions
[24 Jun 2003 5:14] Miguel Solorzano
The information you are provided isn't enough for to repeat
the bug reported. Could you please send for us a test case for.
[24 Jun 2003 10:44] mirunalini sethuraman
Select count(*) from trnlbtdtls.
RESULT:
301258

INSERT INTO trnlbtdtls VALUES('23','2','0','0','1','23','90.87');
(THIS done using FRONT END Software Visual Basic)
RESULT:
The Table trnlbtdtls is full.

then increased the tmp_table_size from 32MB to 64MB.
INSERT INTO trnlbtdtls VALUES('23','2','0','0','1','23','90.87');
RESULT:
The Table trnlbtdtls is full.
[27 Jun 2003 2:34] Heikki Tuuri
Hi!

I assume the table is a temporary table?

Why would increasing the max temp table size help if not?

If the table is an InnoDB type table, you have to check with SHOW TABLE STATUS that there is free space in ibdata files.

Regards,

Heikki
[14 Feb 2005 22:54] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".