Bug 153719 - Mysql restarts with file size problem
Mysql restarts with file size problem
Status: CLOSED DEFERRED
Product: Fedora Legacy
Classification: Retired
Component: mysql (Show other bugs)
rhl9
i386 Linux
medium Severity high
: ---
: ---
Assigned To: Jesse Keating
DEFER
:
Depends On:
Blocks:
  Show dependency treegraph
 
Reported: 2005-04-05 06:16 EDT by Asier
Modified: 2008-08-02 19:40 EDT (History)
0 users

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Environment:
Last Closed: 2006-08-13 09:54:15 EDT
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---


Attachments (Terms of Use)

  None (edit)
Description Asier 2005-04-05 06:16:11 EDT
From Bugzilla Helper:
User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)

Description of problem:
When we start mysql it starts OK but after a while it restarts with message:

Number of processes running now: 1
mysqld process hanging, pid 25560 - killed
050405 12:09:27  mysqld restarted
/usr/bin/mysqld_safe: line 315: 25581 Superado el límite de tamaño de fichero                 $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking >>$err_log 2>&1

It is an spanish installation, the message means "file size limit exceeded"

Version-Release number of selected component (if applicable):
4.0.11

How reproducible:
Always

Steps to Reproduce:
1.start mysql server
2.
3.
  

Actual Results:  After a while the mysql server restarts

Additional info:
Comment 1 Jesse Keating 2005-04-05 13:37:41 EDT
Sounds like you are hitting a ulimit with the database file, which has nothign
to do w/ mysql.  Can you check the size of your database files in /var/lib/mysql
and the current quotas or ulimits you have?
Comment 2 Asier 2005-04-06 02:39:23 EDT
Hi,

I don´t know much about Lynux, but if I do ulimit -a the limit for file size 
is 100000 blocks. As red hat 9 has a blocksize of 16K, this must be a limit of 
1.6GB for a file. Mysql biggest file if 120MB, so this can´t be the problem. 
How do I see current quotas?
Comment 3 Jesse Keating 2005-04-06 19:45:14 EDT
Can you repro this with the older mysql version?
Comment 4 Pekka Savola 2005-11-16 08:22:58 EST
This doesn't seem to be important enough to fix just on its own, so mark it DEFER.

Note You need to log in before you can comment on or make changes to this bug.