Description:
----[For better reports, please attach the log file after submitting. You can find it in /Users/rafaelroblessanchez/Library/Application Support/MySQL/Workbench/log/wb.log]
When I choose Table Inspector for a table that has a Foreign Key (ManyToOne) created with JPA (Eclipse - Hibernate), and navigate to Foreign keys (you can see the information) - If you click on [Refresh] button the interface shows a Pop-Up with this message:
Unhandled exception: invalid column constraint_name for resultset
Check the log for more details.
My equipment: MacBook Pro M2 Pro
My OS system: Mac OS - Sonoma 14.4.1
MySQL version: 8.3.0-arm64
MySQL Workbench version: 8.0.36 build 3737333 CE (64 bits) Community
---
Information extracte from the log:
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
SystemError: invalid column constraint_name for resultset
06:44:11 [WRN][ mforms]: Resource file not found: db.Constraints.16x16.png
06:44:11 [WRN][ mforms]: Resource file not found: db.Partitions.16x16.png
06:44:11 [WRN][ mforms]: Resource file not found: db.Grants.16x16.png
06:44:11 [WRN][ mforms]: Resource file not found: db.Grants.16x16.png
06:44:11 [ERR][sqlide_tableman_ext.py:show_table:1186]: Error initializing tab constraints: Traceback (most recent call last):
File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_tableman_ext.py", line 1183, in show_table
tab.show_table(schema, table)
File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_tableman_ext.py", line 854, in show_table
self.refresh()
File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_catalogman_ext.py", line 373, in refresh
self.preload_data(self.get_query())
File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_catalogman_ext.py", line 367, in preload_data
node.set_string(i, rset.stringFieldValueByName(field) or "" if format_func is None else format_func(rset.stringFieldValueByName(field)))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
SystemError: invalid column constraint_name for resultset
06:46:49 [ERR][ pymforms]: Unhandled exception in Python code:
06:47:49 [ERR][ pymforms]: Unhandled exception in Python code:
06:48:07 [WRN][ mforms]: Resource file not found: db.StoredProcedure.16x16.png
06:48:07 [WRN][ mforms]: Resource file not found: db.Function.16x16.png
06:48:07 [WRN][ mforms]: Resource file not found: db.Grants.16x16.png
06:48:20 [INF][wb_admin_control.py:query_server_installation_info:858]: Currently connected to MySQL server version '8.3.0', conn status = True, active plugins = ['INNODB_BUFFER_PAGE', 'ARCHIVE', 'INNODB_CMP', 'INNODB_FT_CONFIG', 'caching_sha2_password', 'keyring_file', 'INNODB_CMP_PER_INDEX_RESET', 'INNODB_TEMP_TABLE_INFO', 'daemon_keyring_proxy_plugin', 'INNODB_BUFFER_PAGE_LRU', 'INNODB_FT_DELETED', 'INNODB_VIRTUAL', 'ngram', 'CSV', 'INNODB_FT_DEFAULT_STOPWORD', 'MEMORY', 'TempTable', 'INNODB_TRX', 'binlog', 'INNODB_CMP_PER_INDEX', 'sha256_password', 'INNODB_INDEXES', 'InnoDB', 'INNODB_METRICS', 'INNODB_FT_INDEX_CACHE', 'INNODB_FT_BEING_DELETED', 'INNODB_FT_INDEX_TABLE', 'INNODB_CMPMEM', 'INNODB_TABLES', 'INNODB_TABLESTATS', 'INNODB_TABLESPACES', 'INNODB_CMPMEM_RESET', 'mysqlx', 'sha2_cache_cleaner', 'MyISAM', 'INNODB_CACHED_INDEXES', 'BLACKHOLE', 'INNODB_CMP_RESET', 'PERFORMANCE_SCHEMA', 'mysqlx_cache_cleaner', 'INNODB_COLUMNS', 'INNODB_SESSION_TEMP_TABLESPACES', 'mysql_native_password', 'INNODB_BUFFER_POOL_STATS', 'MRG_MYISAM']
06:48:20 [WRN][ mforms]: Resource file not found: mysql-logo-83.png
06:48:20 [WRN][ mforms]: Resource file not found: mysql-logo-83.png
06:48:25 [ERR][wb_admin_utils.py:page_activated:352]: Exception activating the page - DbMySQLQuery.resultFieldStringValueByName(): MySQL_ResultSet::isNull: invalid value of 'columnLabel'Error executing query SELECT name, timer_name FROM performance_schema.setup_timers: Error executing 'SELECT name, timer_name FROM performance_schema.setup_timers'
Table 'performance_schema.setup_timers' doesn't exist.
SQL Error: 1146
06:50:27 [ERR][wb_admin_utils.py:page_activated:352]: Exception activating the page - 'events_waits_summary_by_thread_by_event_name'Resource file not found: db.StoredProcedure.16x16.png
06:51:02 [WRN][ mforms]: Resource file not found: db.Function.16x16.png
06:51:02 [WRN][ mforms]: Resource file not found: db.Grants.16x16.png
06:52:25 [WRN][ mforms]: Resource file not found: db.Constraints.16x16.png
06:52:25 [WRN][ mforms]: Resource file not found: db.Partitions.16x16.png
06:52:25 [WRN][ mforms]: Resource file not found: db.Grants.16x16.png
06:52:26 [WRN][ mforms]: Resource file not found: db.Grants.16x16.png
06:52:26 [ERR][sqlide_tableman_ext.py:show_table:1186]: Error initializing tab constraints: Traceback (most recent call last):
File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_tableman_ext.py", line 1183, in show_table
tab.show_table(schema, table)
File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_tableman_ext.py", line 854, in show_table
self.refresh()
File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_catalogman_ext.py", line 373, in refresh
self.preload_data(self.get_query())
File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_catalogman_ext.py", line 367, in preload_data
node.set_string(i, rset.stringFieldValueByName(field) or "" if format_func is None else format_func(rset.stringFieldValueByName(field)))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
SystemError: invalid column constraint_name for resultset
06:53:54 [ERR][ pymforms]: Unhandled exception in Python code:
06:54:14 [ERR][ python]: Error forwarding notification to Python
Traceback:
No stack information.
NameError: 'str' object has no attribute '__suppress_context__'
How to repeat:
Each time I use this option.
Description: ----[For better reports, please attach the log file after submitting. You can find it in /Users/rafaelroblessanchez/Library/Application Support/MySQL/Workbench/log/wb.log] When I choose Table Inspector for a table that has a Foreign Key (ManyToOne) created with JPA (Eclipse - Hibernate), and navigate to Foreign keys (you can see the information) - If you click on [Refresh] button the interface shows a Pop-Up with this message: Unhandled exception: invalid column constraint_name for resultset Check the log for more details. My equipment: MacBook Pro M2 Pro My OS system: Mac OS - Sonoma 14.4.1 MySQL version: 8.3.0-arm64 MySQL Workbench version: 8.0.36 build 3737333 CE (64 bits) Community --- Information extracte from the log: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ SystemError: invalid column constraint_name for resultset 06:44:11 [WRN][ mforms]: Resource file not found: db.Constraints.16x16.png 06:44:11 [WRN][ mforms]: Resource file not found: db.Partitions.16x16.png 06:44:11 [WRN][ mforms]: Resource file not found: db.Grants.16x16.png 06:44:11 [WRN][ mforms]: Resource file not found: db.Grants.16x16.png 06:44:11 [ERR][sqlide_tableman_ext.py:show_table:1186]: Error initializing tab constraints: Traceback (most recent call last): File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_tableman_ext.py", line 1183, in show_table tab.show_table(schema, table) File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_tableman_ext.py", line 854, in show_table self.refresh() File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_catalogman_ext.py", line 373, in refresh self.preload_data(self.get_query()) File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_catalogman_ext.py", line 367, in preload_data node.set_string(i, rset.stringFieldValueByName(field) or "" if format_func is None else format_func(rset.stringFieldValueByName(field))) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ SystemError: invalid column constraint_name for resultset 06:46:49 [ERR][ pymforms]: Unhandled exception in Python code: 06:47:49 [ERR][ pymforms]: Unhandled exception in Python code: 06:48:07 [WRN][ mforms]: Resource file not found: db.StoredProcedure.16x16.png 06:48:07 [WRN][ mforms]: Resource file not found: db.Function.16x16.png 06:48:07 [WRN][ mforms]: Resource file not found: db.Grants.16x16.png 06:48:20 [INF][wb_admin_control.py:query_server_installation_info:858]: Currently connected to MySQL server version '8.3.0', conn status = True, active plugins = ['INNODB_BUFFER_PAGE', 'ARCHIVE', 'INNODB_CMP', 'INNODB_FT_CONFIG', 'caching_sha2_password', 'keyring_file', 'INNODB_CMP_PER_INDEX_RESET', 'INNODB_TEMP_TABLE_INFO', 'daemon_keyring_proxy_plugin', 'INNODB_BUFFER_PAGE_LRU', 'INNODB_FT_DELETED', 'INNODB_VIRTUAL', 'ngram', 'CSV', 'INNODB_FT_DEFAULT_STOPWORD', 'MEMORY', 'TempTable', 'INNODB_TRX', 'binlog', 'INNODB_CMP_PER_INDEX', 'sha256_password', 'INNODB_INDEXES', 'InnoDB', 'INNODB_METRICS', 'INNODB_FT_INDEX_CACHE', 'INNODB_FT_BEING_DELETED', 'INNODB_FT_INDEX_TABLE', 'INNODB_CMPMEM', 'INNODB_TABLES', 'INNODB_TABLESTATS', 'INNODB_TABLESPACES', 'INNODB_CMPMEM_RESET', 'mysqlx', 'sha2_cache_cleaner', 'MyISAM', 'INNODB_CACHED_INDEXES', 'BLACKHOLE', 'INNODB_CMP_RESET', 'PERFORMANCE_SCHEMA', 'mysqlx_cache_cleaner', 'INNODB_COLUMNS', 'INNODB_SESSION_TEMP_TABLESPACES', 'mysql_native_password', 'INNODB_BUFFER_POOL_STATS', 'MRG_MYISAM'] 06:48:20 [WRN][ mforms]: Resource file not found: mysql-logo-83.png 06:48:20 [WRN][ mforms]: Resource file not found: mysql-logo-83.png 06:48:25 [ERR][wb_admin_utils.py:page_activated:352]: Exception activating the page - DbMySQLQuery.resultFieldStringValueByName(): MySQL_ResultSet::isNull: invalid value of 'columnLabel'Error executing query SELECT name, timer_name FROM performance_schema.setup_timers: Error executing 'SELECT name, timer_name FROM performance_schema.setup_timers' Table 'performance_schema.setup_timers' doesn't exist. SQL Error: 1146 06:50:27 [ERR][wb_admin_utils.py:page_activated:352]: Exception activating the page - 'events_waits_summary_by_thread_by_event_name'Resource file not found: db.StoredProcedure.16x16.png 06:51:02 [WRN][ mforms]: Resource file not found: db.Function.16x16.png 06:51:02 [WRN][ mforms]: Resource file not found: db.Grants.16x16.png 06:52:25 [WRN][ mforms]: Resource file not found: db.Constraints.16x16.png 06:52:25 [WRN][ mforms]: Resource file not found: db.Partitions.16x16.png 06:52:25 [WRN][ mforms]: Resource file not found: db.Grants.16x16.png 06:52:26 [WRN][ mforms]: Resource file not found: db.Grants.16x16.png 06:52:26 [ERR][sqlide_tableman_ext.py:show_table:1186]: Error initializing tab constraints: Traceback (most recent call last): File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_tableman_ext.py", line 1183, in show_table tab.show_table(schema, table) File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_tableman_ext.py", line 854, in show_table self.refresh() File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_catalogman_ext.py", line 373, in refresh self.preload_data(self.get_query()) File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_catalogman_ext.py", line 367, in preload_data node.set_string(i, rset.stringFieldValueByName(field) or "" if format_func is None else format_func(rset.stringFieldValueByName(field))) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ SystemError: invalid column constraint_name for resultset 06:53:54 [ERR][ pymforms]: Unhandled exception in Python code: 06:54:14 [ERR][ python]: Error forwarding notification to Python Traceback: No stack information. NameError: 'str' object has no attribute '__suppress_context__' How to repeat: Each time I use this option.