[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

"The table 'hd_ticket' is full" message is a MySQL error message. Help??

Posted on 2011-09-07
5
Medium Priority
?
497 Views
Last Modified: 2012-05-12
I have a "help desk" application running on a Windows 2008 server, with IIS7.

Just yesterday, tickets stopped going into the system.  I emailed the developers of the application and they wrote back to me with the following:

======================

I tried sending in a new ticket via email, and when I clicked Run next to your parsed email account, I received this error:

"Email xxx@xxxxxxx.com NOT parsed as a ticket post! Error: save-ticket The table 'hd_ticket' is full"

The "The table 'hd_ticket' is full" message is a MySQL error message.There may be some type of setting that is restricting the size of your MySQL database or table.


================================

The table  "hd_ticket" in the MySQL database has the following:

Engine:   InnoDB
Rows:   1704
Data length:  1.5MB
Index length:  592kb

Additional Info about the databases:

Number of tables:  194
Rows:  205,865
Data len:  293.1MB
Index len:  163.0MB


Also note:
The Server has more than enough Hard Drive space.  (More than 75GB on all drives).
The Drives are formatted using NTFS.
Some of the tables are set to InnoDB and some are set to  MyISAM, but mostly InnoDB.

How can I fix this issue?  Can I allow for more space?  (If so, how, etc.)??

Gary
0
Comment
Question by:njcuwebsupport
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
5 Comments
 
LVL 60

Accepted Solution

by:
HainKurt earned 2000 total points
ID: 36498807
http://dev.mysql.com/doc/refman/5.0/en/full-table.html

it may be that the disk is full or that the table has reached its maximum size. The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits

http://dev.mysql.com/doc/refman/5.0/en/table-size-limit.html

Operating System File-size Limit
Win32 w/ FAT/FAT32 : 2GB/4GB
Win32 w/ NTFS : 2TB (possibly larger)
0
 
LVL 60

Expert Comment

by:HainKurt
ID: 36498815
is there any limit/quota on user or folder on operating system which mysql runs?
0
 

Author Closing Comment

by:njcuwebsupport
ID: 36498838
Thanks
0
 
LVL 60

Expert Comment

by:HainKurt
ID: 36498847
do you have anything on your ini file like this (my.cnf)

innodb_data_file_path = ibdata1:10M:autoextend:max:128M
0
 
LVL 60

Expert Comment

by:HainKurt
ID: 36498849
sorry, what is the solution :) I just sent information about size/limits...
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question