(The table 'swticketposts' is full)

[trigxm]

Hi,

I've attempted to reply to a clients ticket and I'm getting

(The table 'swticketposts' is full)

I'm running a repair on the table now, but it's taken forever.. Any ideas as to what I can do?

Carl

[craigbrass]

Are you sure there isn't a size limit on your database or the database server hard drive is full? That is an unusual error.

[trigxm]

No limit as far as I know, and the hDD isn't full..


[root@support root]# df
Filesystem 1K-blocks Used Available Use% Mounted on
vzfs 76244212 4687200 60044436 8% /
[root@support root]#


Ran the repair, and its working ok, but this is the second time its happened

I actually think the DB is too big for kayako, because Kayako, doesn't know how big the table is

swticketposts MyISAM 12,078 0.00 GB 909.00 KB Repair Optimize

[Jamie Edwards]

Hi trigxm,

I believe that MyISAM tables currently have a 4GB addressable limit (use of 32 bit pointers - see Overcoming MySQL's 4GB Limit (by Jeremy Zawodny)). How big is your swticketpost table?

[supportskins]

This needs to be added in the manual or Kayako KB.

[ecornet]

Wait, so there is a 4 GB limit on tickets?

[Jamie Edwards]

It is an indirect MySQL limitation, not a SupportSuite limitation. It is possible to work around it. It depends on your MySQL version, your operating system, and your chosen file system.

4gb mysql limit - Google Search

MySQL :: MySQL 5.0 Reference Manual :: B.1.2.12 The table is full
Overcoming MySQL's 4GB Limit (by Jeremy Zawodny)

[ecornet]

Ok well, what is the minimum ticket size and what is the maximum ticket size. That way i can get a range of how many tickets i can fit into my database before i have to purge it.

[Jamie Edwards]

It depends on your operating system, MySQL version and file system. I suggest reading this article: MySQL :: MySQL 5.0 Reference Manual :: B.1.2.12 The table is full

[ecornet]

ok how about this, Which ticket table is most likely to hit it's capacity first? Ticketposts?

[supportskins]

I think that should be the attachments table.

[ecornet]

ya but that's easy to fix, you can just purge the attachments. I mean if we run out of space in relation to a Ticket table which one would it be

[Jamie Edwards]

That would be the ticket posts table, that contain the bulk of ticket data. However, deleting tickets directly via the database is tricky, as there are lots of dependencies.

[trigxm]

*************************** 1. row ***************************
Name: swticketposts
Type: MyISAM
Row_format: Dynamic
Rows: 12079
Avg_row_length: 355573
Data_length: 4294967116
Max_data_length: 4294967295
Index_length: 933888
Data_free: 0
Auto_increment: 12908
Create_time: 2006-02-16 12:04:14
Update_time: 2008-04-03 19:15:30
Check_time: 2008-04-03 10:17:02
Create_options:
Comment:
1 row in set (0.01 sec)

Thats my table size

[trigxm]

I'm just updating my tables now