Autocomplete not working in 1.50.0-1.51.1

[helgelol]

Edit: Just updated to 1.51.1, and error is still present there.

I upgraded my applications through homebrew yesterday, and among them was mycli from what I can tell from this:

/opt/homebrew/Cellar/mycli/1.50.0 (4,167 files, 38.7MB) *
  Poured from bottle using the formulae.brew.sh API on 2026-02-09 at 00:16:51

And now I get this error when I connect to a database: (I can just press ctrl+c, and the application works, but autocomplete to chose table etc, does not work.)

Exception in thread completion_refresh:
Traceback (most recent call last):
  File "/opt/homebrew/Cellar/python@3.14/3.14.3_1/Frameworks/Python.framework/Versions/3.14/lib/python3.14/threading.py", line 1082, in _bootstrap_inner
    self._context.run(self.run)
    ~~~~~~~~~~~~~~~~~^^^^^^^^^^
  File "/opt/homebrew/Cellar/python@3.14/3.14.3_1/Frameworks/Python.framework/Versions/3.14/lib/python3.14/threading.py", line 1024, in run
    self._target(*self._args, **self._kwargs)
    ~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^te suggestion     Refreshing completions...
  File "/opt/homebrew/Cellar/mycli/1.50.0/libexec/lib/python3.14/site-packages/mycli/completion_refresher.py", line 84, in _bg_refresh
    refresher(completer, executor)
    ~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^
  File "/opt/homebrew/Cellar/mycli/1.50.0/libexec/lib/python3.14/site-packages/mycli/completion_refresher.py", line 160, in refresh_procedures
    completer.extend_procedures(executor.procedures())
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/homebrew/Cellar/mycli/1.50.0/libexec/lib/python3.14/site-packages/mycli/sqlcompleter.py", line 941, in extend_procedures
    for elt in procedure_data:
               ^^^^^^^^^^^^^^
  File "/opt/homebrew/Cellar/mycli/1.50.0/libexec/lib/python3.14/site-packages/mycli/sqlexecute.py", line 464, in procedures
    cur.execute(self.procedures_query % self.dbname)
    ~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/homebrew/Cellar/mycli/1.50.0/libexec/lib/python3.14/site-packages/pymysql/cursors.py", line 153, in execute
    result = self._query(query)
  File "/opt/homebrew/Cellar/mycli/1.50.0/libexec/lib/python3.14/site-packages/pymysql/cursors.py", line 322, in _query
    conn.query(q)
    ~~~~~~~~~~^^^
  File "/opt/homebrew/Cellar/mycli/1.50.0/libexec/lib/python3.14/site-packages/pymysql/connections.py", line 575, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
                          ~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/homebrew/Cellar/mycli/1.50.0/libexec/lib/python3.14/site-packages/pymysql/connections.py", line 826, in _read_query_result
    result.read()
    ~~~~~~~~~~~^^
  File "/opt/homebrew/Cellar/mycli/1.50.0/libexec/lib/python3.14/site-packages/pymysql/connections.py", line 1203, in read
    first_packet = self.connection._read_packet()
  File "/opt/homebrew/Cellar/mycli/1.50.0/libexec/lib/python3.14/site-packages/pymysql/connections.py", line 782, in _read_packet
    packet.raise_for_error()
    ~~~~~~~~~~~~~~~~~~~~~~^^
  File "/opt/homebrew/Cellar/mycli/1.50.0/libexec/lib/python3.14/site-packages/pymysql/protocol.py", line 219, in raise_for_error
    err.raise_mysql_exception(self._data)
    ~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^
  File "/opt/homebrew/Cellar/mycli/1.50.0/libexec/lib/python3.14/site-packages/pymysql/err.py", line 150, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.OperationalError: (1054, "Unknown column 'PROCEDURE' in 'WHERE'")

I run Apple M4 Pro on Tahoe 26.2 if that's relevant.

Is there anything else I can provide that would help in this matter?

[rolandwalker]

It must be #1474, which we can address. But what version of MySQL is running on the server?

[helgelol]

It must be #1474, which we can address. But what version of MySQL is running on the server?

Server version is 11.4.9-MariaDB-ubu2204-log mariadb.org binary distribution.
Local docker container running 11.4.9-MariaDB-ubu2404 mariadb.org binary distribution did NOT have issues,
so might be related to Ubuntu LTS versions.

[rolandwalker]

Thanks! Good to know, in case there is a better way to list stored procedures on MariaDB. A general fix is in dev review in #1533 .

[scottnemes]

Interesting bit is the actual error:

(1054, "Unknown column 'PROCEDURE' in 'WHERE'")

It's complaining about PROCEDURE not being a column, however the query doesn't have that as a column. So seems it is having issues parsing it somehow:

SELECT ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES
    WHERE ROUTINE_TYPE="PROCEDURE" AND ROUTINE_SCHEMA = "%s"

MariaDB has the same columns for the information_schema.ROUTINES table, so it's not a compatibility issue there anyway. Given the query, it must be parsing the ROUTINE_TYPE="PROCEDURE" bit and treating PROCEDURE as a column.

I tried connecting to a 11.4.10-MariaDB-ubu2404 server from mycli running on Ubuntu 24.04 (x86_64), and also from a Mac M2 Max with Tahoe 26.2 and could not reproduce the issue on either. Also notice unbuffered mentioned in the output, so I tried that as well, but still could not reproduce it.

[rolandwalker]

Should be fixed in https://github.com/dbcli/mycli/releases/tag/v1.52.0, let us know if not!

[rolandwalker]

@scottnemes MySQL parsing errors are not always informative. What if the cause is needless quotes around %s?

[scottnemes]

@scottnemes MySQL parsing errors are not always informative. What if the cause is needless quotes around %s?

Possible, but without a reproducible test case I wouldn't change anything currently since it (seemingly) works the vast majority of the time. Given this is a newer issue, hopefully we'll get some more reports to narrow it down if it keeps happening.

[helgelol]

Should be fixed in https://github.com/dbcli/mycli/releases/tag/v1.52.0, let us know if not!

Thanks, I upgraded and got new and improved errors 😬

MariaDB 11.4.9
mycli 1.52.0
Home: http://mycli.net
Bug tracker: https://github.com/dbcli/mycli/issues
Thanks to the contributor — Phil Cohen
MariaDB redacted@localhost:redacted> Exception in thread completion_refresh:
Traceback (most recent call last):
  File "/opt/homebrew/Cellar/python@3.14/3.14.3_1/Frameworks/Python.framework/Versions/3.14/lib/python3.14/threading.py", line 1082, in _bootstrap_inner
    self._context.run(self.run)
    ~~~~~~~~~~~~~~~~~^^^^^^^^^^
  File "/opt/homebrew/Cellar/python@3.14/3.14.3_1/Frameworks/Python.framework/Versions/3.14/lib/python3.14/threading.py", line 1024, in run
    self._target(*self._args, **self._kwargs)
    ~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/homebrew/Cellar/mycli/1.52.0/libexec/lib/python3.14/site-packages/mycli/completion_refresher.py", line 84, in _bg_refresh
    refresher(completer, executor)
    ~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^
  File "/opt/homebrew/Cellar/mycli/1.52.0/libexec/lib/python3.14/site-packages/mycli/completion_refresher.py", line 160, in refresh_procedures
    completer.extend_procedures(executor.procedures())
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/homebrew/Cellar/mycli/1.52.0/libexec/lib/python3.14/site-packages/mycli/sqlcompleter.py", line 942, in extend_procedures
    metadata[self.dbname][elt[0]] = None
                          ~~~^^^
IndexError: tuple index out of range

I tried creating a Dockerfile from scratch with Ubuntu 2204 and Mariadb 11.4.9 to replicate the errors I was having, but annoyingly it just worked.

I ended up uninstalling mycli with brew, and installed through pipx, so I could easily downgrade to see if the errors went away.

Currently running 1.47.0 with no errors.

[rolandwalker]

Thanks for being patient and trying the Dockerfile, and thanks for the report. It does look like something we need to fix, and I'm reopening.

[rolandwalker]

Can you try v1.53.0 via pip? It was just published.

[helgelol]

Can you try v1.53.0 via pip? It was just published.

I tried 3 different environments that have previously given errors, and they all work just fine now.
Seems to have fixed it, what a champ!