Bug #58806 sporadic failure of ps.test

• Submitted: 7 Dec 2010 22:14
• Modified: 7 Dec 2010 22:14
• Reporter: Matthias Leich
• Status: Analyzing
• Category: MySQL Server: Tests
• Severity: S3 (Non-critical)
• Version: mysql-5.5-bugteam
• OS: Any
• Assigned to: Assigned Account
• CPU Architecture: Any

[7 Dec 2010 22:14] Matthias Leich

Description:
ps.test has the potential to harm succeeding tests
when there is a parallel high CPU load on the testing
box (run a compile or tests on other source trees...).
The succeeding test might process the result of
   SHOW PROCESSLIST or
   SELECT ... information_schema.processlist
very early and see connections caused by ps.test
where the disconnect is not finished.

ps.test failed one time when I applied my non official
high load stability test.

My release was a mysql-5.5-bugteam revno: 3170
2010-12-07 but I assume ps.test in many other MySQL
versions have the same weakness.

How to repeat:
Not available

Suggested fix:
Take care that any disconnect ... is finished before
the ps.test ends.