MySQL Bugs: #54288: Error 'Nonetype' object has no attribute 'nextRow' in WB Security

Bug #54288	Error 'Nonetype' object has no attribute 'nextRow' in WB Security
Submitted:	7 Jun 2010 11:36	Modified:	26 Sep 2015 12:53
Reporter:	Abhilash Shah	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S2 (Serious)
Version:	5.2.22	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
Navigation:
Mysql WB --> Administration --> Accounts Tab

1.clicked on Login Tab
2. Enter userid and passwd
3. Selected DBA from Administrative Roles Tab
4. Click on 'Apply' Button

After a while i get the above error.

Conclusion: Unable to create an account user in WB Admin-Security tab. 

Please fix this ASAP.

Server Environment: Mysql 5.0.77, RHEL 5

How to repeat:
AS Above steps

Suggested fix:
You should tell me what to do

PLEASE SEE THE ATTACHMENT FOR DETAILS

Attachment: MYSQLERROR.docx (application/vnd.openxmlformats-officedocument.wordprocessingml.document, text), 114.73 KiB.

Not repeatable for me on Mac OS X. Looks like Windows-specific problem.

Thank you for the bug report. I couldn't repeat on Windows Vista X64, could you please attach the screen-shot (the picture file) and the output of Help->System Info. Thanks in advance.

revised screenshots

Attachment: MYSQLERROR.docx (application/vnd.openxmlformats-officedocument.wordprocessingml.document, text), 201.85 KiB.

please refer the revised screenshot file MYSQLERROR.doc

Please attach picture file not within docx format file. Thanks in advance.

Same here, trying this out on a XP x86 machine. (Clean Database, everything's fresh)

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".

I am seeing the same error when trying to create a new user account. :[

Screenshot of bug in png format.

Attachment: 7-16-2010 12-53-24 PM.png (image/x-png, text), 83.91 KiB.

I am using Microsoft Windows XP Professional, Service Pack 3
Intel Pentium 4 CPU, 1.80Ghz (yes, underpowered, rub it in)
1.82 Ghz, 2.00 Gb RAM

All reporters,

Please, check if this error still happens with Workbench 5.2.25. Send the results of Help > System Info in this case, in plain text.

Yes, I am experiencing this issue with version 5.2.25 CE, Revision 6303.

Screenshot showing version 5.2.25 CE, Revision 6303

Attachment: 7-19-2010 10-51-09 AM.png (image/x-png, text), 248.29 KiB.

Contents of Help > System Info:

MySQL Workbench CE for Windows version 5.2.25
Data Directory: C:\Program Files\MySQL\MySQL Workbench 5.2 CE
Cairo Version: 1.8.8
Rendering Mode: OpenGL is available on this system, so OpenGL is used for rendering.
OpenGL Driver Version: 1.5.7
OS: Microsoft Windows XP Professional Service Pack 3 (build 2600)
CPU: Intel(R) Pentium(R) 4 CPU 1.80GHz, 2.0 GiB RAM
Video adapter info:
Adapter type: NVIDIA GeForce2 MX/MX 400
Chip Type: GeForce2 MX/MX 400
BIOS String: Version 3.11.01.37.00
Video Memory: 65536 KB
get_server_version: parsed (5, 0, 77)
ctrl_be: Query Error Error executing 'DESCRIBE mysql.db':
1142. Error:1142
ctrl_be: Query Error Error executing 'DESCRIBE mysql.user':
1142. Error:1142
ctrl_be: Query Error Error executing 'SELECT User, Host FROM mysql.user':
1142. Error:1142
ctrl_be: Query Error Error executing 'INSERT INTO mysql.user (User, Host, Password, max_questions, max_updates, max_connections) VALUES ('newuser', '%', PASSWORD('None'), 0, 0, 0)':
1142. Error:1142
ctrl_be: Query Error Error executing 'FLUSH PRIVILEGES':
1227. Error:1227
ctrl_be: Query Error Error executing 'FLUSH PRIVILEGES':
1227. Error:1227
ctrl_be: Query Error Error executing 'SELECT * FROM mysql.user WHERE User='newuser' AND Host='%'':
1142. Error:1142
Traceback (most recent call last):
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_security.py", line 626, in commit
    self._selected_user.load(self._selected_user.username, self._selected_user.host)
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_security_be.py", line 664, in load
    if not result.nextRow():
AttributeError: 'NoneType' object has no attribute 'nextRow'
ctrl_be: Query Error Error executing 'DROP USER 'newuser'@'%'':
1227. Error:1227
ctrl_be: Query Error Error executing 'FLUSH PRIVILEGES':
1227. Error:1227
ctrl_be: Query Error Error executing 'INSERT INTO mysql.user (User, Host, Password, max_questions, max_updates, max_connections) VALUES ('newuser', '%', PASSWORD('None'), 0, 0, 0)':
1142. Error:1142
ctrl_be: Query Error Error executing 'FLUSH PRIVILEGES':
1227. Error:1227
ctrl_be: Query Error Error executing 'FLUSH PRIVILEGES':
1227. Error:1227
ctrl_be: Query Error Error executing 'SELECT * FROM mysql.user WHERE User='newuser' AND Host='%'':
1142. Error:1142
Traceback (most recent call last):
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_security.py", line 626, in commit
    self._selected_user.load(self._selected_user.username, self._selected_user.host)
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_security_be.py", line 664, in load
    if not result.nextRow():
AttributeError: 'NoneType' object has no attribute 'nextRow'
ctrl_be: Query Error Error executing 'SELECT * FROM mysql.user WHERE User='newuser' AND Host='%'':
1142. Error:1142
Traceback (most recent call last):
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_security.py", line 445, in user_selected
    user_info = self.owner.secman.async_get_account(self.show_user, user, host)
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_security_be.py", line 317, in async_get_account
    account.load(name, host)
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_security_be.py", line 664, in load
    if not result.nextRow():
AttributeError: 'NoneType' object has no attribute 'nextRow'
ctrl_be: Query Error Error executing 'SELECT * FROM mysql.user WHERE User='newuser' AND Host='%'':
1142. Error:1142
Traceback (most recent call last):
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_security.py", line 445, in user_selected
    user_info = self.owner.secman.async_get_account(self.show_user, user, host)
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_security_be.py", line 317, in async_get_account
    account.load(name, host)
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_security_be.py", line 664, in load
    if not result.nextRow():
AttributeError: 'NoneType' object has no attribute 'nextRow'
ctrl_be: Query Error Error executing 'SELECT * FROM mysql.user WHERE User='newuser' AND Host='%'':
1142. Error:1142
Traceback (most recent call last):
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_security.py", line 445, in user_selected
    user_info = self.owner.secman.async_get_account(self.show_user, user, host)
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_security_be.py", line 317, in async_get_account
    account.load(name, host)
  File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_security_be.py", line 664, in load
    if not result.nextRow():
AttributeError: 'NoneType' object has no attribute 'nextRow'

Does your workbench user has enough rights (for user and host) e.g. GRANT OPTIONS for working on users?

What is the last entry in general log before/during the error message?

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".

How do I check to be sure those permissions are correct?

Please, connect as usual and send the results of:

show grants;

statement.

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".

I have this same problem on version 6.2.4.12437 and my colleague has it on an older Workbench version.
I am using root user id, so the problem is not about sufficient user rights.

Show grant result

Attachment: ShowGrant.png (image/png, text), 9.70 KiB.

Contents of Help > System Info shows settings on my local computer, which is working fine. So I can't give you that info.

Server side log /var/log/mysqld.log has nothing since previous restart (Jan 15) that didn't complain about anything either.
I didn't find any client side log under D:\Program Files\MySQL\MySQL Workbench 6.2 CE\

Please try version 6.3.4. Thanks.

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".

This error is still displayed in V8 of MySQL Workbench. 
It happens when you access Navigator/MANAGEMENT/Users and Privileges/Add Account then press Apply.
It occurs when MySQL Workbench has dropped its connection to the MySQL Server.
It is clear when you read the log file (as other commenters have suggested).
It would be useful if wb_admin_security_be.py tested whether the connection is still operational, then report to the user if it is not. Here is a log dump.
Perhaps this feedback will allow this 10-year old report to be closed.
--Start of log dump
10:28:18 [WRN][wb_admin_control.py:exec_sql:658]: Error executing SQL CREATE USER 'MLDBA'@'%' 
   IDENTIFIED WITH 'mysql_native_password' BY 'xxxxxxx':
10:28:18 [WRN][wb_admin_control.py:exec_sql:660]: exec_sql: Loss of connection to mysql server was detected.
10:28:18 [ERR][       pymforms]: Unhandled exception in Python code: 
Traceback (most recent call last):
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\wb_admin_security.py", line 2032, in commit
    self.reload_user(is_new_user)
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\wb_admin_security.py", line 2069, in reload_user
    self._selected_user.load(self._selected_user.username, self._selected_user.host)
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\wb_admin_security_be.py", line 941, in load
    if not result.nextRow():
AttributeError: 'NoneType' object has no attribute 'nextRow'
10:28:32 [ERR][wb_admin_security.py:commit:2016]: Exception while saving account: Traceback (most recent call last):
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\wb_admin_security.py", line 2003, in commit
    self._selected_user.save()
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\wb_admin_security_be.py", line 811, in save
    assert self._orig_username is not None and self._orig_host is not None
AssertionError
---end of log dump