Bug 172001

Summary: MySQL 4.0.26 crashes when memlock option enabled
Product: Red Hat Enterprise Linux 4 Reporter: Owen <owen>
Component: kernelAssignee: Kernel Maintainer List <kernel-maint>
Status: CLOSED NOTABUG QA Contact: Brian Brock <bbrock>
Severity: medium Docs Contact:
Priority: medium    
Version: 4.0   
Target Milestone: ---   
Target Release: ---   
Hardware: i686   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2005-11-01 00:59:54 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Owen 2005-10-28 22:23:45 UTC 
From Bugzilla Helper:
User-Agent: Mozilla/5.0 (Macintosh; U; PPC Mac OS X; en) AppleWebKit/412.7 (KHTML, like Gecko) Safari/412.5

Description of problem:
After the most recent kernel upgrade to RHE4, the memlock feature of MySQL stopped working. When 
starting mysql with memlock turned on MySQL would exit and the following would be shown in the error 
log:
051028 17:22:08  mysqld restarted
051028 17:22:08 Can't start server: Bind on TCP/IP port: Address already in use
051028 17:22:08 Do you already have another mysqld server running on port: 3306 ?
051028 17:22:08 Aborting

051028 17:22:08 /usr/local/mysql/bin/mysqld: Shutdown Complete

051028 17:22:08  mysqld ended

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


How reproducible:
Always

Steps to Reproduce:
1. Using the 4.0.26 binaries from MySQL.com, add the following line to the /etc/my.cnf file in the mysqld 
section: memlock
2. Restart mysql
3. Mysql will not start and will exit immediately.

Actual Results:  MySQL exited immediately.

Expected Results:  MySQL should have ran as normal. This feature worked normally before the kernel upgrade.

Additional info:

[root@mercury ~]# mysql -V
mysql  Ver 12.22 Distrib 4.0.26, for pc-linux-gnu (i686)

Dual Xeon, 2 GB RAM.
Comment 1 Owen 2005-10-28 22:24:47 UTC 
# uname -a
Linux mercury.op-design.com 2.6.9-22.0.1.ELsmp #1 SMP Tue Oct 18 18:39:27 EDT 2005 i686 i686 i386 
GNU/Linux
Comment 2 Jason Baron 2005-11-01 00:11:58 UTC 
what was the previous kernel version that this work under?
Comment 3 Owen 2005-11-01 00:59:54 UTC 
Upon lots of further testing, it turns out to be a goof on my part. Thanks anyway!
Comment 4 Jason Baron 2005-11-01 01:20:45 UTC 
ok. thanks for the update.