Skip to content

"Unknown column 'FUNCTION' in 'where clause'" #246

Description

@BakPakMark

The following error happens seemingly at random. Sometimes when closing a tab, sometimes when executing a query, sometimes when doing nothing at all. Hard to reproduce since it happens sporadically without a noticeable pattern of why.

--- Logging error ---
Traceback (most recent call last):
  File "mysql\connector\connection_cext.py", line 565, in cmd_query
_mysql_connector.MySQLInterfaceError: Unknown column 'FUNCTION' in 'where clause'

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "ossdbtoolsservice\language\completion_refresher.py", line 88, in _bg_refresh
  File "ossdbtoolsservice\language\completion_refresher.py", line 138, in refresh_functions
  File "ossdbtoolsservice\language\metadata_executor.py", line 87, in functions
  File "ossdbtoolsservice\language\metadata_executor.py", line 87, in <listcomp>
  File "ossdbtoolsservice\language\query\mysql_lightweight_metadata.py", line 81, in functions
  File "mysql\connector\cursor_cext.py", line 279, in execute
  File "mysql\connector\connection_cext.py", line 573, in cmd_query
mysql.connector.errors.ProgrammingError: 1054 (42S22): Unknown column 'FUNCTION' in 'where clause'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "logging\__init__.py", line 1100, in emit
  File "logging\__init__.py", line 943, in format
  File "logging\__init__.py", line 678, in format
  File "logging\__init__.py", line 368, in getMessage
TypeError: not all arguments converted during string formatting
Call stack:
  File "threading.py", line 973, in _bootstrap
  File "threading.py", line 1016, in _bootstrap_inner
  File "threading.py", line 953, in run
  File "ossdbtoolsservice\language\completion_refresher.py", line 109, in _bg_refresh
  File "logging\__init__.py", line 1512, in exception
  File "logging\__init__.py", line 1506, in error
  File "logging\__init__.py", line 1624, in _log
  File "logging\__init__.py", line 1634, in handle
  File "logging\__init__.py", line 1696, in callHandlers
  File "logging\__init__.py", line 968, in handle
  File "logging\__init__.py", line 1218, in emit
  File "logging\__init__.py", line 1108, in emit
Message: 'Error during metadata refresh: {0}'
Arguments: (ProgrammingError(1054, "1054 (42S22): Unknown column 'FUNCTION' in 'where clause'", '42S22'),)
[Error - 11:25:43 AM] Connection to server got closed. Server will not be restarted.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions