MySQL Bugs: #76180: Selecting the Information ("i") icon for a schema results in Error

Bug #76180	Selecting the Information ("i") icon for a schema results in Error
Submitted:	5 Mar 2015 18:51	Modified:	30 Jan 2016 19:28
Reporter:	Alan Lesmerises	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	6.2.3.12312 build 2280 (64 bits) Commun.	OS:	Linux (Centos 7)
Assigned to:		CPU Architecture:	Any
Tags:	python, schema, showInspector, SQLIDEUtils

Description:
Clicking on the "i" (Information) icon for an entire schema results in the following error message:

"error calling Python module function SQLIDEUtils.showInspector"

Excerpt from wb.log:

10:49:22 [INF][   base library]: Notification GNUIFormCreated is not registered
10:49:22 [ERR][         python]: error calling SQLIDEUtils.showInspectorTraceback (most recent call last):
10:49:22 [ERR][         python]:   File "/usr/lib64/mysql-workbench/modules/sqlide_grt.py", line 601, in showInspector
10:49:22 [ERR][         python]:     show_schema_manager(editor, schema_insp, False)
10:49:22 [ERR][         python]:   File "/usr/lib64/mysql-workbench/modules/sqlide_catalogman_ext.py", line 30, in show_schema_manager
10:49:22 [ERR][         python]:     sman = SchemaManager(editor, schema_name)
10:49:22 [ERR][         python]:   File "/usr/lib64/mysql-workbench/modules/sqlide_catalogman_ext.py", line 1050, in __init__
10:49:22 [ERR][         python]:     self.refresh()
10:49:22 [ERR][         python]:   File "/usr/lib64/mysql-workbench/modules/sqlide_catalogman_ext.py", line 1059, in refresh
10:49:22 [ERR][         python]:     tab.refresh()
10:49:22 [ERR][         python]:   File "/usr/lib64/mysql-workbench/modules/sqlide_catalogman_ext.py", line 353, in refresh
10:49:22 [ERR][         python]:     self.preload_data(self.get_query())
10:49:22 [ERR][         python]:   File "/usr/lib64/mysql-workbench/modules/sqlide_catalogman_ext.py", line 347, in preload_data
10:49:22 [ERR][         python]:     node.set_string(i, rset.stringFieldValueByName(field) or "" if format_func is None else format_func(rset.stringFieldValueByName(field)))
10:49:22 [ERR][         python]: SystemError: invalid column Comment for resultset

How to repeat:
For me, all I have to do is click on the icon.

Suggested fix:
Unknown.

I couldn't repeat with 6.2.5 version, please try it. 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".

I was able to reproduce the bug with mysql 5.0 sever. Same schema in mysql 5.5 works fine. it could be related to obsolete dictionary tables in 5.0 compared to modern mysql version.

5.0 isn't more supported.

Hi, I'm had the same problem. On getting info on the partitioned table with 350 000 000 rows. Table are partitioned to 90 parts.

10:59:05 [INF][SQL Editor Form]: Opened connection 'autobt.atohm.cz 3306' to (Debian) version 10.0.30-MariaDB-0+deb8u1
10:59:05 [ERR][      WBContext]: Unsupported server version: (Debian) 10.0.30-MariaDB-0+deb8u1
10:59:12 [ERR][         python]: error calling SQLIDEUtils.showInspectorTraceback (most recent call last):
10:59:12 [ERR][         python]:   File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_grt.py", line 607, in showInspector
10:59:12 [ERR][         python]:     show_table_inspector(editor, table_insp)
10:59:12 [ERR][         python]:   File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_tableman_ext.py", line 40, in show_table_inspector
10:59:12 [ERR][         python]:     tinspect.show_table(schema, table)
10:59:12 [ERR][         python]:   File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_tableman_ext.py", line 1138, in show_table
10:59:12 [ERR][         python]:     tab.show_table(schema, table)
10:59:12 [ERR][         python]:   File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_tableman_ext.py", line 809, in show_table
10:59:12 [ERR][         python]:     self.refresh()
10:59:12 [ERR][         python]:   File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_catalogman_ext.py", line 364, in refresh
10:59:12 [ERR][         python]:     self.preload_data(self.get_query())
10:59:12 [ERR][         python]:   File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_catalogman_ext.py", line 348, in preload_data
10:59:12 [ERR][         python]:     node.set_int(i, rset.intFieldValueByName(field) or 0)
10:59:12 [ERR][         python]:   File "/Applications/MySQLWorkbench.app/Contents/Resources/libraries/mforms.py", line 3793, in set_int
10:59:12 [ERR][         python]:     return _mforms.TreeNodeRef_set_int(self, column, value)
10:59:12 [ERR][         python]: OverflowError: in method 'TreeNodeRef_set_int', argument 3 of type 'int'
10:59:17 [ERR][         python]: error calling SQLIDEUtils.showInspectorTraceback (most recent call last):
10:59:17 [ERR][         python]:   File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_grt.py", line 607, in showInspector
10:59:17 [ERR][         python]:     show_table_inspector(editor, table_insp)
10:59:17 [ERR][         python]:   File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_tableman_ext.py", line 40, in show_table_inspector
10:59:17 [ERR][         python]:     tinspect.show_table(schema, table)
10:59:17 [ERR][         python]:   File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_tableman_ext.py", line 1138, in show_table
10:59:17 [ERR][         python]:     tab.show_table(schema, table)
10:59:17 [ERR][         python]:   File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_tableman_ext.py", line 809, in show_table
10:59:17 [ERR][         python]:     self.refresh()
10:59:17 [ERR][         python]:   File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_catalogman_ext.py", line 364, in refresh
10:59:17 [ERR][         python]:     self.preload_data(self.get_query())
10:59:17 [ERR][         python]:   File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_catalogman_ext.py", line 348, in preload_data
10:59:17 [ERR][         python]:     node.set_int(i, rset.intFieldValueByName(field) or 0)
10:59:17 [ERR][         python]:   File "/Applications/MySQLWorkbench.app/Contents/Resources/libraries/mforms.py", line 3793, in set_int
10:59:17 [ERR][         python]:     return _mforms.TreeNodeRef_set_int(self, column, value)
10:59:17 [ERR][         python]: OverflowError: in method 'TreeNodeRef_set_int', argument 3 of type 'int'
11:13:50 [ERR][         python]: error calling SQLIDEUtils.showInspectorTraceback (most recent call last):
11:13:50 [ERR][         python]:   File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_grt.py", line 607, in showInspector
11:13:50 [ERR][         python]:     show_table_inspector(editor, table_insp)
11:13:50 [ERR][         python]:   File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_tableman_ext.py", line 40, in show_table_inspector
11:13:50 [ERR][         python]:     tinspect.show_table(schema, table)
11:13:50 [ERR][         python]:   File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_tableman_ext.py", line 1138, in show_table
11:13:50 [ERR][         python]:     tab.show_table(schema, table)
11:13:50 [ERR][         python]:   File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_tableman_ext.py", line 809, in show_table
11:13:50 [ERR][         python]:     self.refresh()
11:13:50 [ERR][         python]:   File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_catalogman_ext.py", line 364, in refresh
11:13:50 [ERR][         python]:     self.preload_data(self.get_query())
11:13:50 [ERR][         python]:   File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_catalogman_ext.py", line 348, in preload_data
11:13:50 [ERR][         python]:     node.set_int(i, rset.intFieldValueByName(field) or 0)
11:13:50 [ERR][         python]:   File "/Applications/MySQLWorkbench.app/Contents/Resources/libraries/mforms.py", line 3793, in set_int
11:13:50 [ERR][         python]:     return _mforms.TreeNodeRef_set_int(self, column, value)
11:13:50 [ERR][         python]: OverflowError: in method 'TreeNodeRef_set_int', argument 3 of type 'int'
11:15:19 [ERR][         python]: error calling SQLIDEUtils.showInspectorTraceback (most recent call last):
11:15:19 [ERR][         python]:   File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_grt.py", line 607, in showInspector
11:15:19 [ERR][         python]:     show_table_inspector(editor, table_insp)
11:15:19 [ERR][         python]:   File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_tableman_ext.py", line 40, in show_table_inspector
11:15:19 [ERR][         python]:     tinspect.show_table(schema, table)
11:15:19 [ERR][         python]:   File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_tableman_ext.py", line 1138, in show_table
11:15:19 [ERR][         python]:     tab.show_table(schema, table)
11:15:19 [ERR][         python]:   File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_tableman_ext.py", line 809, in show_table
11:15:19 [ERR][         python]:     self.refresh()
11:15:19 [ERR][         python]:   File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_catalogman_ext.py", line 364, in refresh
11:15:19 [ERR][         python]:     self.preload_data(self.get_query())
11:15:19 [ERR][         python]:   File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_catalogman_ext.py", line 348, in preload_data
11:15:19 [ERR][         python]:     node.set_int(i, rset.intFieldValueByName(field) or 0)
11:15:19 [ERR][         python]:   File "/Applications/MySQLWorkbench.app/Contents/Resources/libraries/mforms.py", line 3793, in set_int
11:15:19 [ERR][         python]:     return _mforms.TreeNodeRef_set_int(self, column, value)
11:15:19 [ERR][         python]: OverflowError: in method 'TreeNodeRef_set_int', argument 3 of type 'int'

Ran into this error when selecting the information icon for a table, not a schema.  As in Jan's case, I have a large table with multiple partitions: 60M rows, 4 primary and 14 secondary partitions, total of 56.

I was able to recreate this error by clicking on the icon again.  This error does NOT occur when clicking on the information icon for a table with the same data but without partitions.

From wb.log:

20:49:36 [ERR][         python]: error calling SQLIDEUtils.showInspectorTraceback (most recent call last):
20:49:36 [ERR][         python]:   File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_grt.py", line 607, in showInspector
20:49:36 [ERR][         python]:     show_table_inspector(editor, table_insp)
20:49:36 [ERR][         python]:   File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.py", line 37, in show_table_inspector
20:49:36 [ERR][         python]:     tinspect.show_table(schema, table)
20:49:36 [ERR][         python]:   File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.py", line 1108, in show_table
20:49:36 [ERR][         python]:     tab.show_table(schema, table)
20:49:36 [ERR][         python]:   File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_tableman_ext.py", line 774, in show_table
20:49:36 [ERR][         python]:     self.refresh()
20:49:36 [ERR][         python]:   File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.py", line 353, in refresh
20:49:36 [ERR][         python]:     self.preload_data(self.get_query())
20:49:36 [ERR][         python]:   File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_catalogman_ext.py", line 337, in preload_data
20:49:36 [ERR][         python]:     node.set_int(i, rset.intFieldValueByName(field) or 0)
20:49:36 [ERR][         python]:   File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\mforms.py", line 2300, in set_int
20:49:36 [ERR][         python]:     def set_int(self, *args): return _mforms.TreeNodeRef_set_int(self, *args)
20:49:36 [ERR][         python]: TypeError: in method 'TreeNodeRef_set_int', argument 3 of type 'int'

I confirm this error still exists in this version and also in the latest 6.3.10 build 12092614 CE (64 bits).

It seems to always happen with any partitioned table.

I've been working on 3 tables that are around 30M rows each. I created a copy of each table, structure and data. Clicked the Information icon before partitioning and it was working. Immediately after partitioning it stops working forever (4 parts each table). If I revert the partitioning it works again.
The Configure icon next to it still works fine though.