Garden Exception: The table 'GDN_UserDiscussion' is full

Yive

Today my forums has suffered an error which wont allow you to view threads with new posts.

Full error: http://pastebin.com/raw.php?i=mH5FBgB5

peregrine

what is the size of your your userdiscussion table. what version of vanilla.

you can click structure on the table to see the size in phpmyadmin

Does the host have a limit on sizes?

how much free space do you have on your file system?

iinodb table or myisam.

http://dev.mysql.com/doc/refman/5.1/en/full-table.html

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

http://dev.mysql.com/doc/refman/5.1/en/innodb-data-log-reconfiguration.html

as k your host if you have exceeded capacity for your slq database.

if you haven't exceeded limitations.

you could try exporting table, truncating table and re-importing or try optimizing.

Yive

@peregrine said:
what is the size of your your userdiscussion table. what version of vanilla.

you can click structure on the table to see the size.

Does the host have a limit on sizes?

how much free space do you have on your file system?

iinodb table or myisam.

http://dev.mysql.com/doc/refman/5.1/en/full-table.html

as k your host if you have exceeded capacity for your slq database.

if you haven't exceeded limitations.

you could try exporting table, truncating table and re-importing or try optimizing.

Table: GDN_UserDiscussion ~3,743 304 KiB

The host says there is no limit on the sizes or free space.

iinodb

I'll try exporting and see if that does anything.

Yive

Seems to be working now, for whatever reason every few days this happens for no reason at all.

businessdad

@Yive said:
The host says there is no limit on the sizes or free space.

Almost true. If the disk is full (and it does happen), then there is no free space.

Linc

I will chime in just to confirm for the record: there's definitely no size limitations coded into Vanilla. That would be ludicrous.

x00

Never choose a hosting package based on 'unlimited' this and that.

All that means is you don't know what you are getting. There is always a way of limiting your usage. The most popular is called 'throttling' which is an artificial restriction.

As businessdad says, even if you are to have unlimited drive space (doubtful), it doesn't mean they manage this well. you may reach a limit before they do something about it.

vrijvlinder

Unlimited storage is not the same as unlimited bandwidth ...if it is a shared host you can bet they throttle if your traffic exceeds their allotted allowance per account.

This goes double for free hosting.

x00

Throttling can work on any metric, it is not specific to one.

So any particular aspect of consumption can be restricted by throttling.

"Unlimited" is basically a con. Throttling is just a way of restricting consumption, whist not directly capping it.

vrijvlinder

"Unlimited" is basically a con.

This happens with cellulars too. Att was sued
They were forced to pay back some money and also to tell their clients that they may throttled as a result of their usage.

http://abcnews.go.com/Technology/att-loses-iphone-data-throttling-case/story?id=15927963