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:
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?
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?
Can you repro this with the older mysql version?
This doesn't seem to be important enough to fix just on its own, so mark it DEFER.