The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

updatemysqlquota

Discussion in 'General Discussion' started by big, Nov 21, 2005.

  1. big

    big Well-Known Member

    Joined:
    Aug 12, 2001
    Messages:
    224
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Earth
    after running /scripts/updatemysqlquota eventually some users will exceed their disk space and the following shows at /var/lib/mysql/server.example.com.err :
    051121 18:55:21 /usr/sbin/mysqld: Disk is full writing './user1_vb/attachmentviews.MYD' (Errcode: 122). Waiting for someone to free space... Retry in 60 secs
    051121 18:56:02 /usr/sbin/mysqld: Can't open file: 'nuke_referer.MYI'. (errno: 145)
    051121 18:56:23 /usr/sbin/mysqld: Can't open file: 'nuke_referer.MYI'. (errno: 145)
    051121 18:57:30 /usr/sbin/mysqld: Disk is full writing './user1_vb/threadviews.MYD' (Errcode: 122). Waiting for someone to free space... Retry in 60 secs
    051121 18:57:45 /usr/sbin/mysqld: Can't open file: 'word.MYI'. (errno: 145)
    051121 19:05:21 /usr/sbin/mysqld: Disk is full writing './user1_vb/attachmentviews.MYD' (Errcode: 122). Waiting for someone to free space... Retry in 60 secs
    051121 19:07:31 /usr/sbin/mysqld: Disk is full writing './user1_vb/threadviews.MYD' (Errcode: 122). Waiting for someone to free space... Retry in 60 secs
    051121 19:09:30 /usr/sbin/mysqld: Can't open file: 'nuke_referer.MYI'. (errno: 145)
    051121 19:09:30 /usr/sbin/mysqld: Can't open file: 'nuke_referer.MYI'. (errno: 145)
    051121 19:10:24 /usr/sbin/mysqld: Can't open file: 'nuke_referer.MYI'. (errno: 145)
    051121 19:12:06 /usr/sbin/mysqld: Disk is full writing '/var/lib/mysql/user2_nuke/online.MYI' (Errcode: 122). Waiting for someone to free space... Retry in 60 secs
    051121 19:15:21 /usr/sbin/mysqld: Disk is full writing './user1_vb/attachmentviews.MYD' (Errcode: 122). Waiting for someone to free space... Retry in 60 secs
    051121 19:17:31 /usr/sbin/mysqld: Disk is full writing './user1_vb/threadviews.MYD' (Errcode: 122). Waiting for someone to free space... Retry in 60 secs
    051121 19:22:06 /usr/sbin/mysqld: Disk is full writing '/var/lib/mysql/user2_nuke/online.MYI' (Errcode: 122). Waiting for someone to free space... Retry in 60 secs

    the waiting and retry in 60 secs makes mysqlserver stops from responding totally and even apache doesn't respond

    which means all users wont be able to use their stuff including non-exceeding users.

    anyone noticed this issue ? or there is a workaround for such problem?
     
  2. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,475
    Likes Received:
    20
    Trophy Points:
    38
    Location:
    Go on, have a guess
    That's probably why it's not enabled as a feature (though I use it myself too). It's why it is essential that users remain within their disk quotas. I'm not aware of a workaround, quotas are doing what they're meant to do, but that in itself prevents MySQL doing what it needs to do.
     
  3. big

    big Well-Known Member

    Joined:
    Aug 12, 2001
    Messages:
    224
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Earth
    thats bad business approach

    imagine 50mb user with 5GB mysql quota

    think of all the resources wasted and the money lost with such customers (which i happen to have 80% of my total customers the same)
    taking 500mb r so and their vbulletin forum are ~1GB
     
  4. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,475
    Likes Received:
    20
    Trophy Points:
    38
    Location:
    Go on, have a guess
    I don't disagree, but that has nothing to do with the technical limitations involved.
     
  5. big

    big Well-Known Member

    Joined:
    Aug 12, 2001
    Messages:
    224
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Earth
    is it possible that the million hosters around the world are facing this issue and non complained or moved to another Control Panel that takes this in consideration ?!

    i can't believe they all just sit there and wasting their resources :eek:
     
  6. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,475
    Likes Received:
    20
    Trophy Points:
    38
    Location:
    Go on, have a guess
    Actually, looking at your errors again it seems to be suggesting that the disk it is trying to write to is full. Have you checked that neither /var/ nor /tmp or any other partitions are at or nearly full?
     
  7. big

    big Well-Known Member

    Joined:
    Aug 12, 2001
    Messages:
    224
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Earth
    non of the partitions are full

    i had to re-chown /var/lib/mysql/*_*/* back to mysql:mysql and things got fixed again
     

Share This Page