[Bugme-new] [Bug 390] New: System hang with MySql workload

[bugme-daemon at smtp.osdl.org]

http://bugme.osdl.org/show_bug.cgi?id=390

           Summary: System hang with MySql workload
    Kernel Version: 2.5.62
            Status: NEW
          Severity: blocking
             Owner: bugme-janitors at lists.osdl.org
         Submitter: jkenefic at us.ibm.com


Distribution: 
 RedHat 8.0

Hardware Environment:  
 x86 8 processor system with 12Gb ram 
 2 30gb scsi, intel pro 1000
 and 5 client systems

Software Environment:  
 MySql server on 8-way, version 3.23.52-3
 dbgrinder.pl from ltp.sf.net on clients

Problem Description:
 A MySql database server running on an 8-way x86 system with load
 driven from 5 clients (5 instance of dbgrinder.pl on each system).

 Server hangs with no information provided as to cause, this hangs
 the primary console(alt-f1) always and normally hangs the others
 as well.

 Additionaly all network connectivity is lost.

 Initialy created on 2.5.58 kernel, suspected issue with signal handling.
 Error has been reproduced through latest tested kernel, 2.5.62

 Server was only at 30% utilization at time hang. 

 This hang is related the load being driven on the system, when
 the test was executed with only 2 client systems (10 instances)
 the server functioned properly for 10+ hours, after load increased,
 4-5 client systems (20-25 instances) a hang would occur within 2 hours.
 
 Ran test against a uniprocessor server and did not reproduce hang.

Steps to reproduce:

 1.)Install and start up Mysql on server,
 2.)Install dbgrinder.pl on 5 client systems
    Note: this will require DBI and DBD:mysql from cpan.org
 3.)Execute 5 instances of dbgringer.pl on each client all 
    pointed at the server, within 2 hours the server will hang

------- You are receiving this mail because: -------
You are on the CC list for the bug, or are watching someone who is.