Bug #50972 Exception running GUI Administration
Submitted: 7 Feb 2010 23:02 Modified: 12 Apr 2010 22:57
Reporter: Matthias Schlomann Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.2.15 Beta OS:Windows (Exception)
Assigned to: CPU Architecture:Any

[7 Feb 2010 23:02] Matthias Schlomann 
Description:
Exception = System.ArgumentOutOfRangeException
Message = Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
FullText = System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
   at System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)
   at System.ThrowHelper.ThrowArgumentOutOfRangeException()
   at System.Collections.Generic.List`1.get_Item(Int32 index)
   at System.Collections.ObjectModel.ReadOnlyCollection`1.get_Item(Int32 index)
   at MySQL.GUI.Workbench.MainForm.mainDockPanel_ActiveDocumentChanged(Object sender, EventArgs e)
   at WeifenLuo.WinFormsUI.Docking.DockPanel.OnActiveDocumentChanged(EventArgs e)
   at WeifenLuo.WinFormsUI.Docking.DockPanel.FocusManagerImpl.RefreshActiveWindow()
   at WeifenLuo.WinFormsUI.Docking.DockPanel.FocusManagerImpl.HookEventHandler(Object sender, HookEventArgs e)
   at WeifenLuo.WinFormsUI.Docking.DockPanel.FocusManagerImpl.LocalWindowsHook.OnHookInvoked(HookEventArgs e)
   at WeifenLuo.WinFormsUI.Docking.DockPanel.FocusManagerImpl.LocalWindowsHook.CoreHookProc(Int32 code, IntPtr wParam, IntPtr lParam)
   at WeifenLuo.WinFormsUI.Docking.NativeMethods.CallNextHookEx(IntPtr hhook, Int32 code, IntPtr wParam, IntPtr lParam)
   at WeifenLuo.WinFormsUI.Docking.DockPanel.FocusManagerImpl.LocalWindowsHook.CoreHookProc(Int32 code, IntPtr wParam, IntPtr lParam)
   at WeifenLuo.WinFormsUI.Docking.NativeMethods.CallNextHookEx(IntPtr hhook, Int32 code, IntPtr wParam, IntPtr lParam)
   at WeifenLuo.WinFormsUI.Docking.DockPanel.FocusManagerImpl.LocalWindowsHook.CoreHookProc(Int32 code, IntPtr wParam, IntPtr lParam)
   at System.Windows.Forms.UnsafeNativeMethods.SetFocus(HandleRef hWnd)
   at System.Windows.Forms.ContainerControl.FocusActiveControlInternal()
   at System.Windows.Forms.ContainerControl.SetActiveControlInternal(Control value)
   at System.Windows.Forms.ContainerControl.SetActiveControl(Control ctl)
   at System.Windows.Forms.ContainerControl.set_ActiveControl(Control value)
   at System.Windows.Forms.Control.Select(Boolean directed, Boolean forward)
   at System.Windows.Forms.Control.SelectNextControl(Control ctl, Boolean forward, Boolean tabStopOnly, Boolean nested, Boolean wrap)
   at System.Windows.Forms.Control.SelectNextControlInternal(Control ctl, Boolean forward, Boolean tabStopOnly, Boolean nested, Boolean wrap)
   at System.Windows.Forms.Control.SelectNextIfFocused()
   at System.Windows.Forms.Control.SetVisibleCore(Boolean value)
   at System.Windows.Forms.Form.SetVisibleCore(Boolean value)
   at System.Windows.Forms.Control.set_Visible(Boolean value)
   at WeifenLuo.WinFormsUI.Docking.DockContentHandler.SetVisible()
   at WeifenLuo.WinFormsUI.Docking.DockPane.set_ActiveContent(IDockContent value)
   at WeifenLuo.WinFormsUI.Docking.DockPaneStripBase.OnMouseDown(MouseEventArgs e)
   at System.Windows.Forms.Control.WmMouseDown(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at WeifenLuo.WinFormsUI.Docking.DockPaneStripBase.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

How to repeat:
I deleted a user into the database management.  this is my first try to use the new workbench tool.
[9 Feb 2010 10:36] Susanne Ebrecht 
Did you delete the user with which you were connected or a different user?
[9 Feb 2010 19:43] Matthias Schlomann 
No I din't. I know I have first to delete the user after deleting the database.
[9 Feb 2010 20:34] Matthias Schlomann 
What I done realy was:

as root:
Created a new database schema.
Added a new user for this database
Setting Privilegs for the db user for this database

Logoff
Logon as db User which before was new created for this database
Could not logon

relogon as root
delete the database
Try to delete the db user
get the postet error serveral times.

A day later, after I restarted the system serveral times I could delete the user suiccesfull and could create the database and the new db user.  It is worked now.

No windows updates are installed between successfull creating the database and the error I get.
[10 Feb 2010 11:34] Susanne Ebrecht 
I am not sure here if this problem is related to Workbench or MySQL server.

Which server version did you use?
[11 Feb 2010 23:11] Matthias Schlomann 
I using the Community version 5.1.43.
[19 Feb 2010 11:59] Susanne Ebrecht 
I tried the following by using Workbench 5.2.16 and Ubuntu and server 5.1.45.

1) open workbench
2) connect as super user
3) Open Administrator -> Account
4) Create a new user ... e.g. bar@foo
5) close workbench
6) open workbench again
7) do step 2 and 3
8) try to remove the user

Error
Unhandled exception: AdminSecurity instance has no attribute '_connection'
[19 Feb 2010 19:07] Matthias Schlomann 
No I was logged on with a standard root user.  It is clearly for me that I could not delete the user with them I am logged in.
[12 Mar 2010 22:58] MySQL Verification Team 
I couldn't repeat with 5.2.16, please try this version. Thanks in advance.
[12 Apr 2010 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".