Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ERROR 1114: The table 'SQL44c4046_0' is full

Status
Not open for further replies.
rhackenb

rhackenb

Programmer
Nov 7, 2002
17
US
I am trying to do a complex query in MySQL version 3.22.29 and get the error:

ERROR 1114: The table 'SQL44c4046_0' is full

This only happens sometimes. The structure of the query is the same each time but the specific search criteria varies. I find that if I narrow down the query, I can get it to work when this happens. I have a lot of data in the database and I have no problem adding more. What I think is happening is that MySQL is building a temporary table to process the complex query and that temporary table gets too large.

Can someone help with this? I'm at a loss as to how to debug the problem.

thanks,

bob
 
Status
Not open for further replies.

Similar threads

Loomis
  • Locked
  • Question
stepping through table rows
Replies
7
Views
423
rashmibala
R
bharons
  • Locked
  • Question
function argument value, type or count is invalid
Replies
3
Views
679
bharons
bharons
Marclem
  • Locked
  • Question
Joining 4 tables issue
Replies
11
Views
565
Andrzejek
Andrzejek
boylesg
  • Locked
  • Question
Can't sort my table by a particular column, records are returned in autinc order.
Replies
4
Views
680
spamjim
spamjim
EdLentz
  • Locked
  • Question
Need to compare two tables and list the differences
Replies
3
Views
789
EdLentz
EdLentz

Part and Inventory Search

Sponsor

Back
Top