Bug #42604 Migrated server is not completely deleted

• Submitted: 4 Feb 2009 20:00
• Modified: 4 Mar 2009 10:41
• Reporter: Marcos Palacios
• Status: Closed
• Category: MySQL Enterprise Monitor: Server
• Severity: S3 (Non-critical)
• Version: 2.0.4.7141
• OS: Any
• Assigned to: Sloan Childers
• CPU Architecture: Any
• Tags: mem_discuss_me

[4 Feb 2009 20:00] Marcos Palacios

Description:
In a migrated monitor (from 1.3.2 to 2.0.4) with 2 DB servers queued for migration:
- if we delete one being migrated, OR
- if we delete one that finished being migrated
They are not seen on the ManageServers page or counted in the license count until Tomcat is restarted.

Se attached log.

How to repeat:
see Description

[4 Feb 2009 20:06] Marcos Palacios

Log segment relevant to the migration and deletion

Attachment: monitor.log (application/octet-stream, text), 41.79 KiB.

[18 Feb 2009 22:50] Sloan Childers

patches pushed to bzrroot/etools/branches/2.0

[26 Feb 2009 17:30] Bill Weber

Patch installed in versions => 2.0.5.7146.

[26 Feb 2009 17:57] Marcos Palacios

Verified fixed in build 2.0.5.7146.

[26 Feb 2009 22:14] Marcos Palacios

Further testing needed.

[27 Feb 2009 0:13] Marcos Palacios

Upon further testing, it was found that the bug is not yet fixed. 
See mysql-monitor.log from using build 2.0.5.7146 at https://intranet.mysql.com/~mpalacios/mysql-monitor.log .

[27 Feb 2009 21:23] Sloan Childers

added Hibernate annotations to handle cascading deletes properly
added one new test case (thanks Oldag)

[27 Feb 2009 23:37] Keith Russell

Patch installed in versions => 2.0.5.7148.

[1 Mar 2009 21:12] Marcos Palacios

Tested with service manager build 2.0.5.7148.

When attempting to delete a server being migrated, I gives an error as shown in the next attachment.

[1 Mar 2009 21:14] Marcos Palacios

Error message with service manager build 2.0.5.7148.

Attachment: 42604newMsg.JPG (image/jpeg, text), 137.14 KiB.

[3 Mar 2009 3:12] Sloan Childers

checked into etools/branches/2.0

      - force cascading delete (Hibernate not honoring annotations)
      - add checks for server being completely deleted to test harness
      - figured out how to use live Migrator object instead of MockMigrator

[3 Mar 2009 19:28] Keith Russell

Patch installed in versions => 2.0.5.7149.

[3 Mar 2009 19:32] Marcos Palacios

Verified fixed in service manager build 2.1.0.1012.

[3 Mar 2009 19:35] Marcos Palacios

Verified fixed in build 2.0.5.7149.

[4 Mar 2009 10:41] Tony Bedford

An entry was added to the 2.0.5 changelog:

Migrated server was not completely deleted.

In a Monitor that had been updated from 1.3.2 to 2.0.4, with 2 database servers queued for migration, if a server being migrated was deleted, or a migrated server was deleted, this would not be reflected in the user interface or in the license count, until Tomcat was restarted.