Hello, we would like to load data from our MySQL d...
# troubleshooting
f
Hello, we would like to load data from our MySQL database with the tab-mysql based on the binlog. We are using the MySQL version 8.0.25. We have problems with establishing the connection to the database. Among other things, the loading of the catalog fails. Does anyone have a similar problem? Does the extractor tab-mysql work with MySQL 8.0.25? I get this error when running the command
meltano select tap-mysql  --list --all
:
Copy code
Cannot list the selected attributes: Catalog discovery failed: command ['/home/data/meltano/chrono24/.meltano/extractors/tap-mysql/venv/bin/tap-mysql', '--config', '/home/data/meltano/chrono24/.meltano/run/tap-mysql/tap.config.json', '--discover'] returned 1: time=2021-06-25 12:52:04 name=tap_mysql level=CRITICAL message=255
Traceback (most recent call last):
  File "/home/data/meltano/chrono24/.meltano/extractors/tap-mysql/venv/bin/tap-mysql", line 8, in <module>
    sys.exit(main())
  File "/home/data/meltano/chrono24/.meltano/extractors/tap-mysql/venv/lib/python3.8/site-packages/tap_mysql/__init__.py", line 405, in main
    raise exc
  File "/home/data/meltano/chrono24/.meltano/extractors/tap-mysql/venv/lib/python3.8/site-packages/tap_mysql/__init__.py", line 402, in main
    main_impl()
  File "/home/data/meltano/chrono24/.meltano/extractors/tap-mysql/venv/lib/python3.8/site-packages/tap_mysql/__init__.py", line 385, in main_impl
    log_server_params(mysql_conn)
  File "/home/data/meltano/chrono24/.meltano/extractors/tap-mysql/venv/lib/python3.8/site-packages/tap_mysql/__init__.py", line 351, in log_server_params
    with connect_with_backoff(mysql_conn) as open_conn:
  File "/home/data/meltano/chrono24/.meltano/extractors/tap-mysql/venv/lib/python3.8/site-packages/backoff/_sync.py", line 94, in retry
    ret = target(*args, **kwargs)
  File "/home/data/meltano/chrono24/.meltano/extractors/tap-mysql/venv/lib/python3.8/site-packages/tap_mysql/connection.py", line 28, in connect_with_backoff
    connection.connect()
  File "/home/data/meltano/chrono24/.meltano/extractors/tap-mysql/venv/lib/python3.8/site-packages/pymysql/connections.py", line 931, in connect
    self._get_server_information()
  File "/home/data/meltano/chrono24/.meltano/extractors/tap-mysql/venv/lib/python3.8/site-packages/pymysql/connections.py", line 1269, in _get_server_information
    self.server_charset = charset_by_id(lang).name
  File "/home/data/meltano/chrono24/.meltano/extractors/tap-mysql/venv/lib/python3.8/site-packages/pymysql/charset.py", line 38, in by_id
    return self._by_id[id]
KeyError: 255
Many greetings Fabio