addady
asked on
User fail on disk quota when creating a file?
User fail on disk quota when creating a file,
Although this user have a lot of free quota
mysql user and group got lot of free disk space :
>/sbin/quotaoff /dev/hda4
>quota -v mysql
Disk quotas for user mysql (uid 116):
Filesystem blocks quota limit grace files quota limit grace
/dev/hda4 88415 1000000 2000000 87 1000 2000
>quota -g mysql
Disk quotas for group mysql (gid 116):
Filesystem blocks quota limit grace files quota limit grace
/dev/hda4 4 512001 512000 6 1000 2000
Only quotaoff
>/sbin/quotaoff /dev/hda4
bypass this problem !
The linux Kernel is 2.2.14
Any idea ?
Although this user have a lot of free quota
mysql user and group got lot of free disk space :
>/sbin/quotaoff /dev/hda4
>quota -v mysql
Disk quotas for user mysql (uid 116):
Filesystem blocks quota limit grace files quota limit grace
/dev/hda4 88415 1000000 2000000 87 1000 2000
>quota -g mysql
Disk quotas for group mysql (gid 116):
Filesystem blocks quota limit grace files quota limit grace
/dev/hda4 4 512001 512000 6 1000 2000
Only quotaoff
>/sbin/quotaoff /dev/hda4
bypass this problem !
The linux Kernel is 2.2.14
Any idea ?
When you see the quota problem is mysql the logged on user, or is the logged on user someone else that's using the database?
ASKER
I'm login as root and then "su mysql",
so you can say I'm logon as user.
The point is the mysql database process fail for the
same resion.
so you can say I'm logon as user.
The point is the mysql database process fail for the
same resion.
Do you get the same failure if you log on as the mysql user? Are quota's in effect for any other file systems?
I've heard of this problem before with MySQL but since I use Postgres rather than MySQL I've never encountered it myself. I don't know if it's actually a quota problem or a problem with MySQL in how it manipulates its data storage. My guess, right now, is that it's a problem with MySQL.
I've heard of this problem before with MySQL but since I use Postgres rather than MySQL I've never encountered it myself. I don't know if it's actually a quota problem or a problem with MySQL in how it manipulates its data storage. My guess, right now, is that it's a problem with MySQL.
ASKER
>Do you get the same failure if you log on as the mysql >user?
Yes
>Are quota's in effect for any other file
>systems?
No
Yes
>Are quota's in effect for any other file
>systems?
No
What Linux is this? Can I see the output of 'df -k'? And I'd like to know where the home dir of the mysql user is.
I've been assuming, from the way the question is phrased, that the problem occurs when MySQL is trying to create or mannipulate databases. Can the mysql user create a simple file, perhaps like:
mysql> cd
mysql> cp /etc/hosts .
I've been assuming, from the way the question is phrased, that the problem occurs when MySQL is trying to create or mannipulate databases. Can the mysql user create a simple file, perhaps like:
mysql> cd
mysql> cp /etc/hosts .
ASKER
>What Linux is this?
red hat 6.0 Kernel is 2.2.14 on cobalt raq4.
>I've been assuming, from the way the question is phrased,
>that the problem occurs when MySQL is trying
>to create or mannipulate databases
You are rigth, that how is start. But It happen allso when
I login as mysql user and try to create a file
>Can I see the output of 'df -k'
now the quota is off. the problem is on /home
$ df -k
Filesystem 1k-blocks Used Available Use% Mounted on
/dev/hda1 743466 628597 114869 85% /
/dev/hda3 198601 24611 173990 12% /var
/dev/hda4 17671528 4276710 13394818 24% /home
red hat 6.0 Kernel is 2.2.14 on cobalt raq4.
>I've been assuming, from the way the question is phrased,
>that the problem occurs when MySQL is trying
>to create or mannipulate databases
You are rigth, that how is start. But It happen allso when
I login as mysql user and try to create a file
>Can I see the output of 'df -k'
now the quota is off. the problem is on /home
$ df -k
Filesystem 1k-blocks Used Available Use% Mounted on
/dev/hda1 743466 628597 114869 85% /
/dev/hda3 198601 24611 173990 12% /var
/dev/hda4 17671528 4276710 13394818 24% /home
Well, since it quotas apparently worked a for a time and then started failing I'd say it's probably a software fault in the quota system. Especially since the failure occurs for the user when creating ordinary files. Ordinarily I'd suggest updating the system, but on a Cobalt you'd need to get those updates from the vendor and that service may only be available with a service contract.
Do you really need quotas enabled? The obvious work around would be to just disable quotas and manually monitor disk space for abuse.
Do you really need quotas enabled? The obvious work around would be to just disable quotas and manually monitor disk space for abuse.
ASKER
>Do you really need quotas enabled? The obvious work >around would be to just disable quotas and manually
>monitor disk space for abuse.
That what I'm doing now, but I realy need it.
Do you know any ext2 util that can repare the quota ?
>monitor disk space for abuse.
That what I'm doing now, but I realy need it.
Do you know any ext2 util that can repare the quota ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Isn't there a decent way to turn off quotas without having to reboot?
See 'man quotaoff'
The quota system can be turned on/off without a reboot. In the comment above, booting into single user mode was necessary to be able to rebuild the quota system with that file system unmounted.
The quota system can be turned on/off without a reboot. In the comment above, booting into single user mode was necessary to be able to rebuild the quota system with that file system unmounted.
So what command actually sets the command? I was able to reset the quota for a folder I think thourgh the RAQ3 admin module. Can you please comment on what it may have done?
There must be a quota adjust command and this seemed to affect a certain set of folders. it was rather strange it worked like this. I was expecting quotaoff to run as root and shut off all the quota services and thus not have any quota errors there after but the system appears not to let you do this. What will happen when I reboot most likely? Will the quota system stop working if II ran quotaoff? or will it probably just turn it back on. This is a Cobalt Raq3 server I am talking about.
There must be a quota adjust command and this seemed to affect a certain set of folders. it was rather strange it worked like this. I was expecting quotaoff to run as root and shut off all the quota services and thus not have any quota errors there after but the system appears not to let you do this. What will happen when I reboot most likely? Will the quota system stop working if II ran quotaoff? or will it probably just turn it back on. This is a Cobalt Raq3 server I am talking about.
I don't know what the "reset quota" action the RAQ admin module does. It might be using quotacheck or edquota in some way.
To completely disable quotas, use quotaoff to disable checking an enforcing of quotas, and then remove the quota files from the root of the file system. On the next reboot quotas on the filesystem will not start. See the man pages for quota, quotaon, edquota, etc for more information.
To completely disable quotas, use quotaoff to disable checking an enforcing of quotas, and then remove the quota files from the root of the file system. On the next reboot quotas on the filesystem will not start. See the man pages for quota, quotaon, edquota, etc for more information.