Bug #35763 Test rpl_temporary fails due to query returning multiple rows

• Submitted: 2 Apr 2008 7:03
• Modified: 19 Jun 2008 7:01
• Reporter: Mats Kindahl
• Status: Duplicate
• Category: MySQL Server: Replication
• Severity: S3 (Non-critical)
• Version: 5.1.24
• OS: Any
• Assigned to: Assigned Account
• CPU Architecture: Any

[2 Apr 2008 7:03] Mats Kindahl

Description:
The rpl_temporary test fails because a sub-query returns multiple rows where only one was expected, causing the statement to fail.

The test only fail on Solaris machines and the error message for the offending query is::

  At line 149: query 'select id from information_schema.processlist where command='Binlog Dump' into @id' failed: 1172: Result consisted of more than one row

How to repeat:
Look in pushbuild.

Suggested fix:
The reason that the query returns multiple rows is because the dump thread from the previous test has not terminated properly. I tried adding waits to the include/master-slave.inc, but despite this it seems that the dump threads has not had the time to terminate properly.

Adding a wait for the dump threads to be only one would solve the problem.

[19 Jun 2008 7:01] Sven Sandberg

Duplicate of BUG#34647