Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

Garden Exception: The table 'GDN_UserDiscussion' is full

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

Comments

  • peregrineperegrine MVP
    edited April 2014

    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.

    I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.

  • @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.

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

  • @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. :)

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

  • 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.

    grep is your friend.

  • edited April 2014

    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.

  • 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.

    grep is your friend.

  • "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

Sign In or Register to comment.