Hi there. We are trying Meltano in our company, but we are facing an error installing dependencies for target-mysql.

Ubuntu 22.04
Python 3.10.12
pip 23.3

pipx install meltano
meltano init
cd project/
meltano add loader target-mysql

And there's an error

Loader 'target-mysql' already exists in your Meltano project
To add it to your project another time so that each can be configured differently,
add a new plugin inheriting from the existing one with its own unique name:
    meltano add loader target-mysql--new --inherit-from target-mysql

Installing loader 'target-mysql'...
2023-10-18T16:19:22.075410Z [info     ] Logged pip install output to [...]/.meltano/logs/pip/loaders/target-mysql/pip.log
Loader 'target-mysql' could not be installed: Failed to install plugin 'target-mysql'.

Need help fixing this problem? Visit <http://melta.no/> for troubleshooting steps, or to
join our friendly Slack community.

Failed to install plugin(s)

Some errors appear on the log file, but I believe is something related with the pip_self_version_check

2023-10-18T17:19:21,894 Traceback (most recent call last):
2023-10-18T17:19:21,894   File "[project]/.meltano/loaders/target-mysql/venv/lib/python3.10/site-packages/pip/_internal/self_outdated_check.py", line 227, in pip_self_version_check
2023-10-18T17:19:21,894     upgrade_prompt = _self_version_check_logic(
2023-10-18T17:19:21,894   File "[project]/.meltano/loaders/target-mysql/venv/lib/python3.10/site-packages/pip/_internal/self_outdated_check.py", line 188, in _self_version_check_logic
2023-10-18T17:19:21,894     remote_version_str = state.get(current_time)
2023-10-18T17:19:21,894   File "[project]/.meltano/loaders/target-mysql/venv/lib/python3.10/site-packages/pip/_internal/self_outdated_check.py", line 76, in get
2023-10-18T17:19:21,894     last_check = datetime.datetime.fromisoformat(self._state["last_check"])
2023-10-18T17:19:21,894 ValueError: Invalid isoformat string: '2023-10-18T16:04:45Z'
2023-10-18T17:19:21,895 Removed mysqlclient<3.0.0,>=2.2.0 from <https://files.pythonhosted.org/packages/de/9c/b176826e8994551ce826404dab97e305a4bb76c8b0a4e016fabda2901c71/mysqlclient-2.2.0.tar.gz> (from thk-target-mysql) from build tracker '/tmp/pip-build-tracker-a4y0h84n'
2023-10-18T17:19:21,896 Removed build tracker: '/tmp/pip-build-tracker-a4y0h84n'

Tried to search for a related issue but didn't find anything in the Docs or Slack channels. I've found a related issue with pip, and tried to make this change in the self_outdated_check.py file, but I can't make this change persistent. Maybe I'm looking into the wrong file. Any idea ? Thanks

Hi @francisco_soares 👋🏼 Are you able to use Python 3.11. I think that may solve the issue for you, at least until a patch for pip is released. Another option may be to downgrade pip to

23.2.1

.

Hi @edgar_ramirez_mondragon Thanks for your feedback. I've tried in a virtualenv with python 3.11 with pip 23.3 and pip 23.2.1 as you metioned but I had no luck. have a bunch of new errors, resulting in

pip._internal.exceptions.InstallationSubprocessError: Getting requirements to build wheel exited with 1

Awesome!