quota problem - repquota does't match du -sh

[SupuS]

Hi All

With one web I have strange problem. It is almost over limit but du -sh returns different value:

User quota (web has this user only):

repquota -avug |grep zs25adminuser
zs25adminuser  --  996532       0       0           8856     0     0
zs25adminuser  --       0       0       0              0     0     0

Group quota:

repquota -avug |grep web25
web25     --  996532 1126400 1127424           8856     0     0
web25     --       0 1126400 1127424              0     0     0

su (as root):

du -sh /var/www/web25
693M    /var/www/web25

I tried search all files belongs to this user and group by:

find / -group web25
find / -user zs25adminuser

but all files are in /var/www/web25.

I cannot find any reason for this behavior.

Thanks for any suggestion
SupuS

[till]

Are you really sure that all files are in /var/www/web25 ? Please double check that no files or folders are in /tmp and /var/spool/mail

[SupuS]

Originally Posted by till

Are you really sure that all files are in /var/www/web25 ? Please double check that no files or folders are in /tmp and /var/spool/mail

Hi till

Yes I'am .. I checked tmp before post .. here is du of tmp and mail:

tmp:

du -sh /tmp/
58M     /tmp

mail (it is link /var/spool/mail -> ../mail)

du -sh /var/mail
740K    /var/mail

Whole tmp has 58M and no files owned by web25 or zs25*

[SupuS]

I found exactly same problem on another ispconfig server:

# repquota -avugs |grep web34
web34     --    949M   1000M   1001M          31676     0     0
web34     --       0   1000M   1001M              0     0     0

# du -sh /var/www/web34
835M    /var/www/web34

I found some empty files in /tmp and /var/mail but its deleting didn't help.

Any idea please?

SupuS

[SupuS]

Again with same problem Now I found very interesting behaviour. Listing of my quota files says that quota.user has 111 GB.

# ls -lth /quota.*
-rw------- 1 root root 111G Nov 13 14:54 /quota.user
-rw------- 1 root root 2.5M Nov 13 14:54 /quota.group
-rw------- 1 root root 2.5M Jul 23 13:19 /quota.group.new
-rw------- 1 root root 2.5M Jul 23 13:19 /quota.user.new

But whole used disc space is 31 GB only:

# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda4             127G   31G   90G  26% /

I cannot delete guota.user file. I get this error:

# rm -rf /quota.group
rm: cannot remove `/quota.group': Operation not permitted

quotacheck -avugm or quotacheck -avugmc doesn't help.

And after all .. running of repquota -avugs |grep webXX is really slow.

Any idea please?

[SupuS]

So here is what I did to fix incredible big quota.user file:

Stop the quotas:

/etc/init.d/quota stop

or

quotaoff -a

Delete quota files.

Create new quota files, build new one and turning quota on:

touch /quota.user /quota.group
chmod 600 /quota.*
quotacheck -avugm
quotaon -avug

Now my quota files has proper size:

# ls -lth /quota.*
-rw------- 1 root root 2.5M Nov 14 21:35 /quota.group
-rw------- 1 root root 2.5M Nov 14 21:35 /quota.user

Unfortunately quotas of all users seems to be gone so I have to rebuild them by manual changing quota in ispconfig. May be is better way to rebuild it .. I don't know it

For now everything seems quite well. Even differences between quotacheck and du -sh changed:

# du -sh /var/www/web16
859M    /var/www/web16

# repquota -avugs |grep web16
web16     --    726M    800M    801M           5986     0     0
web16     --       0    800M    801M              0     0     0

.. not as I expected but better than before ..

may be somebody know what happend ..

SupuS

[SupuS]

I finally solved problem with "unmatch quotas and du -su".

For reset quotas I used command:

quotacheck -avugmc

But it reseted all quotas for all webs. Now I created little script for update all quotas. Falko or Till check it please for bugs. It works for me.

Here is the script (part of writeconf.php)

PHP Code:

<?php

set_time_limit(0);
// ĂberprĂźfung, ob parallel noch ein anderer ProzeĂ läuft
if(is_file("/root/ispconfig/.ispconfig_lock")){
  clearstatcache();
  for($i=0;$i<120;$i++){ // max. 120 Sek. warten, dann weitermachen
    if(is_file("/root/ispconfig/.ispconfig_lock")){
      sleep(1);
      clearstatcache();
    }
  }
}

@touch("/root/ispconfig/.ispconfig_lock");

include("/root/ispconfig/scripts/lib/config.inc.php");
include("/root/ispconfig/scripts/lib/config.lib.php");
include("/root/ispconfig/scripts/lib/server.inc.php");

$isp_web = new isp_web;

echo "start\n";

/////////////// Web- u. Userdaten aus DB holen ////////////////
$w_ds = $mod->db->queryAllRecords("SELECT * FROM isp_isp_web");
if(!empty($w_ds)){
  foreach($w_ds as $w_d){
    $mod->system->data["isp_isp_web"][$w_d["doc_id"]] = $w_d;
  }
}

$u_ds = $mod->db->queryAllRecords("SELECT * FROM isp_isp_user");
if(!empty($u_ds)){
  foreach($u_ds as $u_d){
    $mod->system->data["isp_isp_user"][$u_d["doc_id"]] = $u_d;
  }
}

$mod->system->data["isp_server_ip"] = $mod->db->queryAllRecords("SELECT * FROM isp_server_ip WHERE server_id = '".$mod->system->server_id."' AND server_ip != ''");
////////////////////////////////////////////////////////////////

/* here I changed isp_isp_web.status = 'u' to isp_isp_web.status = '' so all webs will be updated */

$web_update = $mod->db->queryAllRecords("SELECT * from isp_isp_web, isp_nodes where isp_isp_web.doc_id = isp_nodes.doc_id and isp_nodes.doctype_id = '".$isp_web->web_doctype_id."' and isp_isp_web.status = '' and isp_isp_web.server_id = '".$mod->system->server_id."' and isp_nodes.status = '1'");
$web_update_ssl_action = 0;
if(!empty($web_update)){
  foreach($web_update as $web) {
    $doc_id = $web["doc_id"];
    $doctype_id = $web["doctype_id"];
    $isp_web->web_update($doc_id,$doctype_id,$mod->system->server_id);
    echo "UPDATE: ".$doc_id."\n";
    if($web["ssl_action"] != '') $web_update_ssl_action += 1;
  }
}

// Webs und User endgĂźltig lĂśschen
$isp_web->web_user_clean();

echo "ende\n";

// lock-Datei lĂśschen
@unlink("/root/ispconfig/.ispconfig_lock");

?>

If somebody wants to use it please backup first and be carefully. It works for me but I didn't tested it very well yet.

For run this script simply save it and run by:

/root/ispconfig/php/php /path/to/new/script.php

Hope it helps somebody

[till]

An easier solution might have been, to execute this sql statement in the ispconfig DB:

update isp_isp_user set status = 'u' where status = '';

then change a setting in one of the users in the interface and click on save, so all users get updated.

[SupuS]

Originally Posted by till

An easier solution might have been, to execute this sql statement in the ispconfig DB:

update isp_isp_user set status = 'u' where status = '';

then change a setting in one of the users in the interface and click on save, so all users get updated.

I though about your solution before I created script too .. but it doesn't work for me .. probably my fault .. thanks