Bug #27851 Instance manager test im_life_cycle fails randomly
Submitted: 16 Apr 2007 13:22 Modified: 5 Oct 2007 15:45
Reporter: Michael Widenius Email Updates:
Status: Unsupported Impact on me:
None 
Category:Instance Manager Severity:S3 (Non-critical)
Version:5.0 OS:Linux (SuSE 10.2, 64 bit intel)
Assigned to: CPU Architecture:Any
Tags: sr5_1

[16 Apr 2007 13:22] Michael Widenius
Description:
Instance manager test im_life_cycle fails randomly

How to repeat:
BUILD/compile-pentium64-debug-max
make test

As output we get:

im_life_cycle                  [ fail ]

Errors are (from /home/my/mysql-5.1/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 144: query 'START INSTANCE mysqld2' failed: 3002: The instanc
e is already started

The im_life_cycle.log shows:

STOP INSTANCE mysqld2;
Success: the process has been stopped.

--------------------------------------------------------------------
-- 1.1.4.
--------------------------------------------------------------------
START INSTANCE mysqld3;
ERROR HY000: Unknown instance name
START INSTANCE mysqld1;
ERROR HY000: The instance is already started

--------------------------------------------------------------------
-- 1.1.5.
--------------------------------------------------------------------
STOP INSTANCE mysqld3;
ERROR HY000: Unknown instance name

--------------------------------------------------------------------
-- 1.1.6.
--------------------------------------------------------------------
Killing the process...
Waiting...
Success: the process was restarted.
SHOW INSTANCES;
instance_name   state
mysqld1 online
mysqld2 online

--------------------------------------------------------------------
-- 1.1.7.
--------------------------------------------------------------------
START INSTANCE mysqld2;

............

The above indicates that there is a bug in the instance manager in that it thinks someting is closed which isn't.

im.err shows:
CURRENT_TEST: im_life_cycle
Error in my_thread_global_end(): 1 threads didn't exit

In pushbuild, we have also seen failures in the following bug assert in thread_registry.cc:

/* All threads must unregister */
DBUG_ASSERT(head.next == &head);
[5 Oct 2007 15:39] Konstantin Osipov
The test is disabled. We plan to discontinue the instance manager in future.
[5 Oct 2007 15:45] Konstantin Osipov
The Instance Manager will be discontinued.