Bug #11141 Group quota for databases, Mysql hang up when quota exceed
Submitted: 7 Jun 2005 16:03 Modified: 10 Jun 2005 18:01
Reporter: Ilya Zhuravlev Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server Severity:S2 (Serious)
Version:4.1.12 OS:FreeBSD (FreeBSD 4/5)
Assigned to: CPU Architecture:Any

[7 Jun 2005 16:03] Ilya Zhuravlev
Mysql 4.0.24 was compiled from freebsd-ports collection
All databases owned by 'mysql' user but different groups. When group quota is exceded, I see in log-file this message :
/usr/local/libexec/mysqld: Disk is full writing './customer/table.TMD' (Errcode: 69). Waiting for someone to free space... Retry in 60 secs
This message repeates for 1-3 times and after this mysql's correct shutdown is impossible and table customer/table is corrupted.
Harddisk quota used.

How to repeat:
cd /var/db/mysql
chown mysql:somegroup database
edquota -g somegroup
add some quota
try to exceed quota
[7 Jun 2005 17:25] Ilya Zhuravlev
Tested : this bug also applicable for 4.1.11
[8 Jun 2005 0:02] Ilya Zhuravlev
Package mysql4.1.12 for FreeBSD4 from http://dev.mysql.com/downloads/mysql/4.1.html
was tested too and it also crashed.
[10 Jun 2005 18:01] Alexander Keremidarski
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php
[11 Jun 2005 21:43] Ilya Zhuravlev
What I'm know, doesn't exist other way to use limit ?
In todo and maillists this was not found. You plan to add this feature in MySQL ?