Azure CLI task was failing with ERROR: An error occurred. Pip failed with status code 1.

[Prudhvi1236]

We are using azure CLI task in our pipeline to connect to our azure postgres flexi server to run scripts. Below is the command we have used in our AZ CLI task.

            "  **az config set extension.use_dynamic_install=yes_without_prompt** "

FYI : day before yesterday also the task works fine, but from yesterday onwards I am getting below error.

WARNING: The command requires the extension rdbms-connect. It will be installed first.
ERROR: An error occurred. Pip failed with status code 1. Use --debug for more information.
##[error]Script failed with exit code: 1

Seems issue with installing the extension, kindly help.

[yonzhan]

@kairu-ms for awareness

[kairu-ms]

Hi @Prudhvi1236, could you provide the version of rdbms-connect and azure-cli. It seems caused by dependencies issues.

[bebound]

Please provide the output of az extension add -n rdbms-connect --debug

[Prudhvi1236]

@kairu-ms

Azure CLI task version is 2
for rdbms-connect, I was not adding version externally so I think it will consider the latest version whatever.

[Prudhvi1236]

@bebound

Please find the log output file.

[thrsn-ur]

tasklog_13.log
Hi, we are also experiencing this issue in an Azure DevOps Release pipeline running Ubuntu 20.04. I have attached the logs.

[bebound]

I can repro it in version 2.46.
The error is

 ./psycopg/psycopg.h:35:10: fatal error: Python.h: No such file or directory
         35 | #include <Python.h>
            |          ^~~~~~~~~~
      compilation terminated.

[Prudhvi1236]

Any alternative solution available for this?

[bebound]

Workaround:
Update setuptools to latest version:
/opt/az/bin/python3 -Im pip install -U setuptools

The bug is introduced by Azure/azure-cli#24992.
It is related to pypa/setuptools#3589

[thrsn-ur]

We are able to get the Release pipeline working with this workaround, thanks!

[Prudhvi1236]

One more workaround I identified, using ubuntu 18.04 my pipeline works well. but it is going to deprecate in future.

[ghost]

Hi @Prudhvi1236. Thank you for opening this issue and giving us the opportunity to assist. We believe that this has been addressed. If you feel that further discussion is needed, please add a comment with the text “/unresolve” to remove the “issue-addressed” label and continue the conversation.

[ghost]

Hi @Prudhvi1236, since you haven’t asked that we “/unresolve” the issue, we’ll close this out. If you believe further discussion is needed, please add a comment “/unresolve” to reopen the issue.

[imranrazakhan]

I have to install rust and this error get resolved.