njcuwebsupport
asked on
"The table 'hd_ticket' is full" message is a MySQL error message. Help??
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
is there any limit/quota on user or folder on operating system which mysql runs?
ASKER
Thanks
do you have anything on your ini file like this (my.cnf)
innodb_data_file_path = ibdata1:10M:autoextend:max :128M
innodb_data_file_path = ibdata1:10M:autoextend:max
sorry, what is the solution :) I just sent information about size/limits...