[trove] Unable to manage databases with mariadb 10.7

Rishat Azizov rishat.azizov at gmail.com
Tue Jan 31 14:11:31 UTC 2023


Hello! I get this error when listing databases:

"An error occurred communicating with the guest: 'utf8mb3_general_ci' not a
valid collation.\nTraceback (most recent call last):\n\n File
\"/opt/guest-agent-venv/lib/python3.8/site-packages/oslo_messaging/rpc/server.py\",
line 165, in _process_incoming\n res =
self.dispatcher.dispatch(message)\n\n File
\"/opt/guest-agent-venv/lib/python3.8/site-packages/oslo_messaging/rpc/dispatcher.py\",
line 309, in dispatch\n return self._do_dispatch(endpoint, method, ctxt,
args)\n\n File
\"/opt/guest-agent-venv/lib/python3.8/site-packages/oslo_messaging/rpc/dispatcher.py\",
line 229, in _do_dispatch\n result = func(ctxt, **new_args)\n\n File
\"/opt/guest-agent-venv/lib/python3.8/site-packages/osprofiler/profiler.py\",
line 160, in wrapper\n result = f(*args, **kwargs)\n\n File
\"/opt/guest-agent-venv/lib/python3.8/site-packages/trove/guestagent/datastore/manager.py\",
line 812, in list_databases\n return self.adm.list_databases(limit, marker,
include_marker)\n\n File
\"/opt/guest-agent-venv/lib/python3.8/site-packages/trove/guestagent/datastore/mysql_common/service.py\",
line 341, in list_databases\n mysql_db =
models.MySQLSchema(name=database[0],\n\n File
\"/opt/guest-agent-venv/lib/python3.8/site-packages/trove/common/db/mysql/models.py\",
line 46, in __init__\n self.collate = collate\n\n File
\"/opt/guest-agent-venv/lib/python3.8/site-packages/trove/common/db/mysql/models.py\",
line 85, in collate\n raise ValueError(_(\"'%s' not a valid collation.\") %
value)\n\nValueError: 'utf8mb3_general_ci' not a valid collation.\n.❌ 400
get /instances/78ffcc29-9a36-486d-aa4f-f4133511696d/databases trustId:
a8daa2804e404a28b64df50fb824bb63"

Listing failed becase in mariadb 10.7 utf8_general_ci aliased to
utf8mb3_general_ci. Could you please help with this error?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.openstack.org/pipermail/openstack-discuss/attachments/20230131/4ba789ec/attachment-0001.htm>


More information about the openstack-discuss mailing list